[postgis-users] Loading data with ogr2ogr

Pål Kristensen pal.kristensen at statkart.no
Thu Dec 13 03:16:52 PST 2007


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.




More information about the postgis-users mailing list