<div>There are three different prototypes called "PostGIS Terminal" around for a web based client with a "fixed" PostGIS geodatabase below.</div>
<div> </div>
<div>The original PostGIS-Terminal probably is <a href="http://openlayers-buch.de/beispiele/chapter-09/postgis-terminal.html">http://openlayers-buch.de/beispiele/chapter-09/postgis-terminal.html</a> (its german) then there is <a href="http://www.postgisonline.org/">http://www.postgisonline.org/</a> . </div>
<div> </div>
<div>I've enhanced theses ideas: <a href="http://www.gis.hsr.ch/wiki/PostGIS_Terminal">http://www.gis.hsr.ch/wiki/PostGIS_Terminal</a> . 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 :-><br>
</div>
<div>Yours, S.<br></div>
<div class="gmail_quote">2011/2/9 Michaël Michaud <span dir="ltr"><<a href="mailto:michael.michaud@free.fr">michael.michaud@free.fr</a>></span><br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div text="#000000" bgcolor="#ffffff">Hi,<br><br>Le 08/02/2011 19:21, Paragon Corporation a écrit :
<div class="im">
<blockquote type="cite">
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">John, </font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">We like using OpenJump for that -- here is a quick tutorial we wrote up on doing Ad hoc queries with it.</font></span></div>
<div dir="ltr" align="left"><span></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial"><a href="http://www.postgresonline.com/journal/index.php?/archives/72-OpenJump-for-PostGIS-Spatial-Ad-Hoc-Queries.html" target="_blank">http://www.postgresonline.com/journal/index.php?/archives/72-OpenJump-for-PostGIS-Spatial-Ad-Hoc-Queries.html</a></font></span></div>
<div dir="ltr" align="left"><span></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">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</font></span></div>
<div dir="ltr" align="left"><span></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial"><a href="http://www.postgis.org/documentation/manual-svn/PostGIS_FAQ.html#id2686352" target="_blank">http://www.postgis.org/documentation/manual-svn/PostGIS_FAQ.html#id2686352</a></font></span></div>
</blockquote><br></div>Thanks for the good documentation,<br>Would like to mention an undocumented feature coming with the last OpenJUMP release.<br><br>You can copy the "fence" geometry or the "view extent" in your query :<br>
<br><img alt="" src="cid:part1.02020007.09060607@free.fr"><br> <br>button View (Vue in the screenshot) will copy "${view:-1}" where ever you want in the query (replaced by view extent at execution time)<br>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)<br>
<br>It may help to download small parts of large datasets.<br><br>Michaël<br>
<blockquote type="cite">
<div class="im">
<div dir="ltr" align="left"><span></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">Leo</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial"><a href="http://www.postgis.us/" target="_blank">http://www.postgis.us</a></font></span></div>
<div dir="ltr" align="left"><span></span> </div><br>
<div dir="ltr" lang="en-us" align="left">
<hr>
<font size="2" face="Tahoma"><b>From:</b> <a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a> [<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">mailto:postgis-users-bounces@postgis.refractions.net</a>] <b>On Behalf Of </b>John Callahan<br>
<b>Sent:</b> Tuesday, February 08, 2011 12:25 PM<br><b>To:</b> PostGIS Users Discussion<br><b>Subject:</b> [postgis-users] postgis visual client<br></font><br></div>I'm sure this has been asked many times but haven't found a definitive or consensus answer...<br>
<br>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...<br>
<br>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. <br>
<br>Does anyone know of a GUI tool to use, hopefully one that works for Postgres 9 and PostGIS 2? Thanks.<br><br>- John<br><br>PS - Thanks for the recommendations on the PostGIS in Action book. I just purchased it and looking forward to learning what I can.<br>
<br clear="all">**************************************************<br>John Callahan, Research Scientist<br>Delaware Geological Survey, University of Delaware<br>URL: <a href="http://www.dgs.udel.edu/" target="_blank">http://www.dgs.udel.edu</a><br>
**************************************************<br></div><pre><fieldset></fieldset>
_______________________________________________
postgis-users mailing list
<div class="im"><a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</div></pre></blockquote><br></div><br>_______________________________________________<br>postgis-users mailing list<br><a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br><br></blockquote></div><br>