[postgis-users] avpgcon - workaround/fix

[Armin Burger]

For the few who might be interested in an ArcView 3 extension that loads 
PostGIS layers as shapefiles (extracted with pgsql2shp), an updated 
snapshot version is available at

http://www.pmapper.net/dl/avpgcon

Most bugs should be removed now. It's not really an elegant tool but it 
does for me what it should.

Armin

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