[postgis-users] avpgcon - workaround/fix

[Armin Burger]

Robert

in the last time I had again some looks on avpgcon. I already modified 
some parts to work with newer versions of PostGIS. I still have to 
remove a bug when accessing Postgres on other ports than 5432 and modify 
the identify function. If you're interested I can send you a copy when 
it'll be mainly done.

Armin

Robert Burgholzer wrote:
> 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 <mailto:rburghol at chesapeakebay.net>
> 
> http://www.chesapeakebay.net/
> 
>  
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users