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? Aug 11, 2012 at 0:44
  • Please ask your second question on a another thread.
    – R.K.
    Dec 3, 2012 at 12:43

1 Answer 1


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 and acknowledge you have read our privacy policy.

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