Not sure if it makes a difference, but I usually quote the "EPSG:32633", but I've never imported from SDE so could be a totally different issue.
Hope that helps, Regina -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pål Kristensen Sent: Thursday, December 13, 2007 6:17 AM To: [email protected] Subject: [postgis-users] Loading data with ogr2ogr Hi! I have loaded some data from ArcSDE 9.1 to PostGIS using the ogr2ogr utility. The load statements typically looks like this: ogr2ogr -nlt LINESTRING -nln n50_begrensningskurve -lco GEOMETRY_NAME=the_geom -a_srs EPSG:32633 -f PostgreSQL PG:"dbname=kartdata user=**** host=***.***.***.***" SDE:***.***.***.***,5157,,sde_user,sde_password,n50.begrensningskurve The problem is that the resulting table in PostGIS has a SRID value of 1, but it should be 32633. I have tried to include the s_srs option to override the source projection, which by the way is 32633, but that did not do any difference. I have used the UpdateGeometrySRID function to change the SRID after loading, but that seems like a workaround that really not should be necessary. Is there something I've missed that causes this behavior? Any ideas? Regards, Pål Kristensen -- View this message in context: http://www.nabble.com/Loading-data-with-ogr2ogr-tp14313629p14313629.html Sent from the PostGIS - User mailing list archive at Nabble.com. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users ----------------------------------------- The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
