[postgis-users] avpgcon - workaround/fix

[Robert Burgholzer]

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 at chesapeakebay.net

http://www.chesapeakebay.net/

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20051202/17e01c14/attachment.html>