[postgis-users] avpgcon - workaround/fix

[Robert Burgholzer]

Armin,
That'd be great. Sorry I didn't contact you first, I just assumed you no
longer used it.

r.b.

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Armin Burger
Sent: Friday, December 02, 2005 2:43 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] avpgcon - workaround/fix

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
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users