Thanks for the responses. What you describe in your write up with OpenJump is exactly what I'm trying to do. Also, in addition to the QGIS plugins strk mentions, I just found two more possibilities: PgQuery for QGIS and Postgis SQL Editor. Looks like there are some good options available. Thanks again.<br>
<br>- John<br><br>
<br><br><div class="gmail_quote">On Tue, Feb 8, 2011 at 1:21 PM, Paragon Corporation <span dir="ltr"><<a href="mailto:lr@pcorp.us">lr@pcorp.us</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>
<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><font color="#0000ff" face="Arial" size="2"></font></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><font color="#0000ff" face="Arial" size="2"></font></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><font color="#0000ff" face="Arial" size="2"></font></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>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></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><font color="#0000ff" face="Arial" size="2"></font></span> </div><font color="#0000ff" face="Arial" size="2"></font><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>
[mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">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><div><div></div><div class="h5">
<div></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></div></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>