Thank you Stefan. Yes, I would be interested in testing your application. Looks interesting.<br><br>- John<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>
<br><br><div class="gmail_quote">On Wed, Feb 9, 2011 at 8:36 PM, Stefan Keller <span dir="ltr"><<a href="mailto:sfkeller@gmail.com">sfkeller@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<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" target="_blank">http://openlayers-buch.de/beispiele/chapter-09/postgis-terminal.html</a> (its german) then there is <a href="http://www.postgisonline.org/" target="_blank">http://www.postgisonline.org/</a> . </div>
<div> </div>
<div>I've enhanced theses ideas: <a href="http://www.gis.hsr.ch/wiki/PostGIS_Terminal" target="_blank">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" target="_blank">michael.michaud@free.fr</a>></span><div><div></div><div class="h5"><br>
<blockquote style="border-left: 1px solid rgb(204, 204, 204); 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>
<blockquote type="cite">
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">John, </font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">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" face="Arial" size="2"><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" face="Arial" size="2">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" face="Arial" size="2"><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>
<div dir="ltr" align="left"><span></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">Leo</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"><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" align="left" lang="en-us">
<hr>
<font face="Tahoma" size="2"><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><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" target="_blank">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></div></div><br>
<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>