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.

How do I identify what geometry storage type is being used with a specific geodatabase? Thanks.

share|improve this question
    
Can't this vary within the geodatabase? In SQL Server I've used both the default ESRI binary storage format and Microsoft spatial storage datatypes side by side in the same geodatabase. Maybe you have to look at each featureclass? –  Chad Cooper Oct 4 '11 at 0:32
1  
I was thinking that it was in the dbtune.sde file and I think it can vary but I wanted to see if I could figure out what was picked when creating the geodatabase. –  Justin Oct 4 '11 at 0:43
    
The CONFIG_KEYWORD column in sde.table_registry would tell you which keyword was used. Although you could have multiple keywords using the same storage type, so you would need to know something about your dbtune. –  Jay Cummins Oct 4 '11 at 2:06
    
esp in oracle you could have mixed tables. IF you have more that 1 keyword section (dbtune.sde has more than one by default). then which ever one is called on a load, import, or any gp - that is what it goes in as. there is a method to query the metadata (SDEmetadata). –  Brad Nesom Oct 4 '11 at 3:23

1 Answer 1

Since the dbtune file can be edited, but not loaded into the geodatabase. Just use SQL to select the settings from the dbtune table in the database. That should tell you the geometry storage settings for the different types.

share|improve this answer

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.