avpgcon - workaround/fix

This from the “WayBack Machine”:

Don’t know if anyone is still using avpgcon.avx, but I still use ArcView 3.3 a bit, and so use avpgcon. This fix relates to that.

When loading a shape from postgis an error is thrown when avpgcon tests to see if the shape is within the current extent, i.e.:

SELECT gid, shapename, the_geom

FROM pg_table

WHERE

the_geom && GeometryFromText('BOX3D(-356801.233852 3928796.210200,649032.548074 4927586.338191)'::box3d,-1)

Seems that the newer version of geometryFromText don’t like the Box3d, however, if you simply change the “GeometryFromText” to “Transform”, as in :

SELECT gid, shapename, the_geom

FROM pg_table

WHERE

the_geom && transform('BOX3D(-356801.233852 3928796.210200,649032.548074 4927586.338191)'::box3d,-1)

Everything appears to be hunky-dory.

Robert W. Burgholzer

Nonpoint Source Data Analyst

University of Maryland, College Park

Chesapeake Bay Program Office

410 Severn Avenue, Suite 305B

Annapolis, MD, 21403

Phone: (410) 267-5779

rburghol@...

http://www.chesapeakebay.net/