[Gdal-dev] seg fault with ogr2ogr

palmerj at xtra.co.nz palmerj at xtra.co.nz
Sun Jan 15 17:36:01 EST 2006


Hi Frank,

FYI: I wondering if the handling of the postgis 1.0 geometry type in the custom sql statements is not handled correctly. I tried modifying the previous statement to return WKB format and the queries now work correctly i.e.

ogr2ogr -f "Mapinfo File" testgis PG:dbname=testgis -sql \
"SELECT id, 
 AsBinary(transform(translate(shape,160,0,0),27200), 'NDR') AS wkb_geometry 
 FROM   crs_parcel 
 WHERE  status = 'CURR' 
 AND    toc_code ='PRIM' 
 AND    parcel_intent <> 'ROAD' 
 AND    parcel_intent <> 'HYDR'" \
-nln parcel \
-a_srs EPSG:27200

Cheers
Jeremy





More information about the Gdal-dev mailing list