SQL Server Spatial in ArcMap 10

In my last post, I showed how to load geospatial data into SQL Server.  I want to continue that post with how to show that data in ArcMap 10. 

We are going to use that same data to render it in ArcMap.

1. In the File menu, choose Add Data > Add Query Layer.
   
2. In the New Query Layer dialog box, click Connections.
3. In the Manage Connection(s) dialog box, click New.
   
4. In the Database Connection dialog box:
   1. For DBMS Client choose sqlserver
   2. For Data Source, enter you SQL Server (i.e. HOGWARTS\SQLEXPRESS)
   3. For Data Base, enter the database name (i.e. WORLD)
   4. For Authentication, choose OS Authentication.
   5. Click OK.
5. In the Manage Connection(s) dialog box, click OK.
6. In the New Query Layer dialog box, double click the table that contains the spatial data.
   
7. For Name enter the of the query (i.e. Major Highways)
8. Click Finish.

Unfortunately, this is READ ONLY.  If you want to see how to EDIT this data, stay tuned for the next Post.

Advertisement