Re: [postgis-users] postgis visual client

[Louwrens du Toit]

Hi Stefan, I would also be interesting in testing your program. Looks quite promising. Regards, LJ __________________________________________________ LJ du Toit On 2/10/2011 2:36 AM, Stefan Keller 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 <michael.mich...@free.fr> 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: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] 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 postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users

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