|

»

avpgcon - workaround/fix

View: New views

5 Messages — Rating Filter: Alert me

	avpgcon - workaround/fix by Robert Burgholzer :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Some parts of this message have been removed. Learn more about Nabble's security policy. 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@... http://www.chesapeakebay.net/ _______________________________________________ postgis-users mailing list postgis-users@... http://postgis.refractions.net/mailman/listinfo/postgis-users
	Re: avpgcon - workaround/fix by Armin Burger :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message 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
	RE: avpgcon - workaround/fix by Robert Burgholzer :: Rate this Message: Reply to Author \| View Threaded \| Show Only 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
	Re: avpgcon - workaround/fix by ulim :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Armin Is there still a link to downlaod avpgcon? If not I'd also like to ask for a copy. Nice feature would be if you supported schemas different from public. In my version (0.6.3) tables for all schemas are listed without the schema identifier. In order to use them I have to add the schema name manually to the table name in the edit box (ok, that is really a minor bug). Uli 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@... > [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 > > -- geOps GeoInformatics D-79100 Freiburg _______________________________________________ postgis-users mailing list postgis-users@... http://postgis.refractions.net/mailman/listinfo/postgis-users
	Re: avpgcon - workaround/fix by Armin Burger :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message 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@... > [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 > > _______________________________________________ postgis-users mailing list postgis-users@... http://postgis.refractions.net/mailman/listinfo/postgis-users