Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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.

share|improve this question
    
Shapefile is a file format for storing spatial data. And you need to create/register column with spatial data in your database. There is no such term as "shapefile in geodatabase". Of course you can store shapefile as a BLOB in DB but I think this is really not what you want to do... If I am right then consider correcting your topic name. –  Alex Markov May 28 '12 at 10:29
    
Indeed. I was talking about SDE feature class. My mistake –  Ligia May 28 '12 at 11:07
add comment

1 Answer 1

up vote 2 down vote accepted

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
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.