« Return to Thread: avpgcon - workaround/fix

RE: avpgcon - workaround/fix

by Robert Burgholzer :: Rate this Message:

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@...
[mailto:postgis-users-bounces@...] 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@... <mailto:rburghol@...>
>
> http://www.chesapeakebay.net/
>
>
>
>
>

------------------------------------------------------------------------
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@...
> http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

« Return to Thread: avpgcon - workaround/fix