« Return to Thread: Loading data with ogr2ogr

Loading data with ogr2ogr

by Pål Kristensen :: Rate this Message:

Reply to Author | View in Thread

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

 « Return to Thread: Loading data with ogr2ogr