Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

I tried this:

ogr2ogr -f "MapInfo File" 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?

share|improve this question
Did you try with the -s_srs/-a_srs/-t_srs options? – jorgeas80 Aug 11 '12 at 0:44
Please ask your second question on a another thread. – R.K. Dec 3 '12 at 12:43

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.