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.

I'm trying out a mixed environment here at work with PostGIS and ArcSDE together.

I'm having some problems creating feature classes with custom SRIDs. I imagined that all that I needed to do was update spatial_ref_sys table, but it did not worked also.

Any tips on how to achive this with custom SRIDS? With normal srids it's working just fiiine.

Thanks

share|improve this question
    
Hi, Have you registered the PostGIS Spatial Column with SDE or are you using a Query Layer? –  CDBrown Oct 15 '10 at 4:01
    
I'm sorry for the delay. I'm just trying to create a feature dataset in arcmap with the custom srid. –  George Oct 15 '10 at 13:08

3 Answers 3

up vote 1 down vote accepted

Can you create features with custom SRIDs if you use the ST_GEOMETRY geom-type, or do you get same error for both postgis and ST_GEOM geometrytypes?

Another question is: does your user have rw-rights on the spatial_ref_sys table within the public (postgis) schema?

share|improve this answer
    
Hello Peter, I cannot create any type of feature classes with custom SRIDS (independent of geometry storage type). When I last checked, yes it the user had rw rights on spatial_ref_sys. I'll check again thought! Thanks! –  George Dec 11 '10 at 16:17

If you are attempting to create a Feature Dataset then I believe (this means I have not tested) you need to register the PostGIS with SDE. As you use the sdelayer command line reference it seems this cannot easily be done for a Feature Dataset. I got this from the article attached.

http://webhelp.esri.com/arcgisserver/9.3/dotNet/index.htm#geodatabases/enhanci-205816615.htm

I will actually set up a test of this as I am unsure just thought it was worth posting

Have Fun, CDB

share|improve this answer
    
Hello CDBrown, the feature dataset was just an example. I can't create anything with a custom SRID. –  George Oct 21 '10 at 16:24
    
Thanks I will have a test and get back to you –  CDBrown Oct 22 '10 at 2:42
    
sorry for the delay my other work has gtten in the way, still on my to do list –  CDBrown Dec 16 '10 at 23:44

The SRID is embedded in your geometry columns, you cannot change it just by changing the spatial_ref_sys, geometry tables.. , you have to register it in postgis when you first load your tables (there is no function to change tables that already have SRID). I am on the virge of finishing the mixed environment you are talking about.

First, load your tables in postgis with the SRID you want. LAST, use sdelayer -o register to register it to the arcgis geodatabase.

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.