Hi guys. I need to update my old trick to logically store spatial views into feature datasets until ArcSDE 9.3.1. Has anybody already done something like this for ArcSDE 10 ? Old procedure as follows:
Create basic spatial view with ArcSDE command
Refine view with SQL
Create empty dataset with same spatial reference as the view
Register previously created spatial view with geodatabase
Enter dataset identifier into DatestID field into GDB_OBJECTCLASSES table for the record related to the spatial view
The only precaution was to use the feature dataset as a logical container staying away from versioning, topology and so on.
The new geodatabase system tables for 10 are different. I would do the same thing creating relationship "DatasetInFeatureDataset" linking spatial view to feature dataset. I have not tried yet. I'll do it after posting...
OK. It's even simpler than that. Last step of my old trick is not necessary (for 9.3.1 also). Just dragging and dropping in Arccatalog works fine. It does not look like a trick any more. So...steps as follows:
Create basic spatial view with ArcSDE command (at least objectid and shape fields)
If necessary refine view with SQL
Create empty dataset with same spatial reference as the spatial view
Register previously created spatial view with geodatabase
In Arccatalog drag and drop spatial view into destination feature dataset
Checking geodatabase system tables everything seems fine. In 10 relationship type is "DatasetInFeatureDataset" when the spatial view is inside the ds.
