[FWTools] ogr2ogr fatal error

Frances Collier fcollier at preparedresponse.com
Mon Apr 17 12:23:20 EDT 2006


I have been playing with postgresql and the fwtools shell. I have four
tables in postgres, three of which have polygon geometries for the same
area. When I try to use the -sql portion of ogr2ogr in order to specify the
table, I get an error and the shapefile becomes invalid. Here's my
statement:

C:\Program Files\FWTools1.0.0b2>ogr2ogr -f "ESRI Shapefile"
d:\shapefiles\fwtoolscreated\test.shp -sql "select * from tblcountypop where
within(makepoint(-122.30863952637, 47.2580032348633),wkb_geometry)"
"PG:dbname=mydb user=postgres password=postgres host=localhost"

This is running on a Windows XP Professional OS. The FWTools is the latest
one (1.0.0b2) and the postgres version is 8.1. I am not having a problem
creating a shapefile when I simply use -where
"within(makepoint(-122.30863952637, 47.2580032348633),wkb_geometry)", but I
wanted to specify the table in order to ensure I am getting the data I want.

Any help would be greatly appreciated. Oh, and is there more detailed
documentation on ogr2ogr than http://www.gdal.org/ogr/ogr2ogr.html?

Thank you for your time.

Frances Collier





More information about the FWTools mailing list