[gdal-dev] ogr2ogr problem

[Frank Warmerdam]

pcreso at pcreso.com wrote:
> An example ogr2ogr command is:
> 
> ogr2ogr -f "Mapinfo File" -dsco "FORMAT=MIF" -nln sql ttt 'PG:host=wms dbname=db_trawl user=woodb' -sql "select station_no, trackline from station"   
> 

Brent,

I'm not sure what is going on, but I'd suggest you try :

   ogrinfo 'PG:...' -sql "select station_no, trackline from station"

to see how OGR sees the result from the SQL statement.  If it is all
goofed up, then try just using the table directly, instead of issuing
custom SQL and see if that helps at all.

If the PG results are coming back fine, then it must be an issue with the
mapinfo writer but this is pretty hard to imagine.  I do wonder if your
2.5D geometries might be throwing something for a loop.

Best regards,
-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | Geospatial Programmer for Rent