[FWTools] spurious coordinates being written from PostGIS query
brian at thetimoneygroup.com
Fri Feb 17 21:11:43 EST 2006
Here's a head scratcher--we're testing a Python CGI script that queries a
PostGIS database and takes the results of the query (standard lat/long
coordinates) and creates a shapefile using the OGR libraries. No coordinate
transformations are being perfomed.
We've verified that the query produces intended results from the database
With an identical datasource and identical script, his resulting output
shapefile contains accurate coordinate information. My output shapefile
contains whacked out spurious coordinates with numbers that end in "E+154" and
I replicated similar results by issuing a PostgreSQL-->ESRI Shapefile request
using ogr2ogr from the command line.
I'm hoping someone a lot smarter than I can shed some light on possible causes.
p.s. For those who would suggest I use my buddy's laptop instead of my own for
client demos, thanks, but I already thought of that workaround.
The Timoney Group
518 17th Street
Denver, CO 80206
Ph: (303) 929-3722
Fax: (303) 571-4304
More information about the FWTools