[GIS] Creating ArcSDE feature class in MS SQL Server

arcgis-10.0arcgis-desktopenterprise-geodatabaseesri-geodatabasesql server

Unfortunately I am totally dumb when it comes to programming, and very new to databases (mainly because I studied geography), so :

I have a Microsoft SQL Database Server, and a ArcSDE geodatabase. I made a view in SQL Server Manager, which I can see it in my geodatabase (in ArcCatalog), as a table. Which is great. But I also need the geographic information not just the data from the tables.

So how can I create a feature class in my geodatabase from a view that I created in SQL Server Manager. I did select the "shape" field, but sadly it's not that simple:P

I use: Microsoft SQL Server 2008, ArcGIS 10.0, ArcGIS Server 10.

Best Answer

You need to register your view and spatial column in SDE.

There are two good help topics regarding this question:

  1. Example: Creating a spatial view in SQL Server using SQL and registering it
  2. Example: Creating a spatial view in SQL Server using the sdetable command
Related Question