I have two tables: 1 with geometry in WGS
2 with geometry in Local System

I tried this:

ogr2ogr -f "MapInfo File" output2.tab PG:"host=localhost user=postgres password=123456 dbname=postgis" -sql "SELECT * from filedata WHERE num=1"

and get files. However, after I open the files in QGIS, I see that file from the table in WGS coordinates is correct but the file from the table in the local system has a shift.


enter image description here

Local system

enter image description here

The upper part of the polygons are different but its ok.

I add proj line to file GDAL\projlib\epsg but it did not help. What am I doing wrong?

  • Did you try with the -s_srs/-a_srs/-t_srs options? – Jorge Arévalo Aug 11 '12 at 0:44
  • Please ask your second question on a another thread. – R.K. Dec 3 '12 at 12:43

Try passing the -a_srs attribute with your projection. There is also an issue with bounds in the gdal driver for the Mapinfo tab format which may be related. For more information refer to the documentation.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.