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