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.

Can a spatial view in ArcSDE created by "sdetable create view" command be viewed as feature class in ArcCatalog, or is it just another plain table?

I have a feature class table and an attribute table (non spatial) stored in ArcSDE database. They can be related by a command column. I plan to create a spatial view in ArcSDE joining those tables and also publish the view as a feature service in ArcGIS Server. Is it possible? And, if the view can be published as a feature service, can feature operations such as Add, Edit and Delete Features be applied to all the view fields?

Thanks for any idea! Thanks

Alex

share|improve this question
1  
Yes they can, I know because I have seen some, but that's about all I know. Hopefully someone will chime in with a real answer :) –  blah238 Apr 13 '12 at 6:49
add comment

1 Answer 1

It is possible to join the tables. Suppose your tables are named Locations{ObjecId, Shape, LocationName} and Offenders(Id, FirstName, LastName, CrimeLocation) . Follow the following steps to create the featue view:

  1. On the computer running SDE run the following command

sdetable -o create_view -T PersonsOfInterest -t SpatialDB.SchemaName.Locations -c SpatialDB.SchemaName.Locations.Shape,SpatialDB.SchemaName.Locations.ObjectId -i sde:sqlserver:SERVERNAME -D SpatialDB -u USERNAME -p PASSWORD

  1. Using SQL Server Management studio, open the new view and edit it to read :

ALTER VIEW PersonsOfInterest SELECT o.id as ObjectId, o.CrimeLocation, o.FirstName, o.LastName, loc.shape FROM SchemaName.Offenders o INNER JOIN SchemaName.Locations l ON o.LocationName = l.LocationName

Note that we changed the view so that the ObjectID column is read from the business table. If you do not set this column correctly, your view will not show the right number of records.

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.