Thank you Stefan. Yes, I would be interested in testing your application. Looks interesting.
- John ************************************************** John Callahan, Research Scientist Delaware Geological Survey, University of Delaware URL: http://www.dgs.udel.edu ************************************************** On Wed, Feb 9, 2011 at 8:36 PM, Stefan Keller <[email protected]> wrote: > There are three different prototypes called "PostGIS Terminal" around for a > web based client with a "fixed" PostGIS geodatabase below. > > The original PostGIS-Terminal probably is > http://openlayers-buch.de/beispiele/chapter-09/postgis-terminal.html (its > german) then there is http://www.postgisonline.org/ . > > I've enhanced theses ideas: http://www.gis.hsr.ch/wiki/PostGIS_Terminal . > It's still in an early stage but I can send the code (html, JavaScript, PHP) > to anyone who is interested to become a beta tester :-> > Yours, S. > 2011/2/9 Michaël Michaud <[email protected]> > > Hi, >> >> Le 08/02/2011 19:21, Paragon Corporation a écrit : >> >> John, >> We like using OpenJump for that -- here is a quick tutorial we wrote up on >> doing Ad hoc queries with it. >> >> >> http://www.postgresonline.com/journal/index.php?/archives/72-OpenJump-for-PostGIS-Spatial-Ad-Hoc-Queries.html >> >> It works fine with PostgreSQL 9.0, but if you are using 9.0 -- you need to >> download the latest JDBC drivers or set your bytea_output to escape - both >> are documented in the FAQ >> >> http://www.postgis.org/documentation/manual-svn/PostGIS_FAQ.html#id2686352 >> >> >> Thanks for the good documentation, >> Would like to mention an undocumented feature coming with the last >> OpenJUMP release. >> >> You can copy the "fence" geometry or the "view extent" in your query : >> >> >> >> button View (Vue in the screenshot) will copy "${view:-1}" where ever you >> want in the query (replaced by view extent at execution time) >> button Fence (Cadre in the screenshot) will copy "${fence:-1}" where ever >> you want in the query (replaced by the fence geometry at execution time) >> >> It may help to download small parts of large datasets. >> >> Michaël >> >> >> Leo >> http://www.postgis.us >> >> >> ------------------------------ >> *From:* [email protected] [ >> mailto:[email protected]<[email protected]>] >> *On Behalf Of *John Callahan >> *Sent:* Tuesday, February 08, 2011 12:25 PM >> *To:* PostGIS Users Discussion >> *Subject:* [postgis-users] postgis visual client >> >> I'm sure this has been asked many times but haven't found a definitive or >> consensus answer... >> >> Is there a postgis client that supports spatial, ad hoc queries and >> returns those results to a map? This would include simple (and more >> complex) SELECT statements but also other queries with spatial results, such >> as finding nearest neighbors, intersect, union, etc... >> >> The best idea I found was to create a view from the ad hoc query and then >> use a desktop GIS to display that view. You'd need to update the view (and >> refresh the GIS screen) to run a new query. I know QGIS (and other FOSS >> GIS packages) allows you to create a definition query (a where clause to >> subset the layer) and does support database views. I haven't seen a place >> where QGIS supports ad hoc queries. Searching the web, I did find >> references to some work done using OpenMap libraries back in 2004, and the >> mezoGIS package from around 2005/2006. >> >> Does anyone know of a GUI tool to use, hopefully one that works for >> Postgres 9 and PostGIS 2? Thanks. >> >> - John >> >> PS - Thanks for the recommendations on the PostGIS in Action book. I just >> purchased it and looking forward to learning what I can. >> >> ************************************************** >> John Callahan, Research Scientist >> Delaware Geological Survey, University of Delaware >> URL: http://www.dgs.udel.edu >> ************************************************** >> >> >> _______________________________________________ >> postgis-users mailing list >> [email protected]http://postgis.refractions.net/mailman/listinfo/postgis-users >> >> >> >> _______________________________________________ >> postgis-users mailing list >> [email protected] >> http://postgis.refractions.net/mailman/listinfo/postgis-users >> >> > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > >
<<moz-screenshot-7.png>>
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
