<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
Hi,<br>
<br>
Le 08/02/2011 19:21, Paragon Corporation a écrit :
<blockquote cite="mid:A54AFA37CF874AC7816158E93D396B06@J"
type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<meta name="GENERATOR" content="MSHTML 8.00.7600.16700">
<div dir="ltr" align="left"><span class="009271618-08022011"><font
color="#0000ff" face="Arial" size="2">John, </font></span></div>
<div dir="ltr" align="left"><span class="009271618-08022011"><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 class="009271618-08022011"></span> </div>
<div dir="ltr" align="left"><span class="009271618-08022011"><font
color="#0000ff" face="Arial" size="2"><a
moz-do-not-send="true"
href="http://www.postgresonline.com/journal/index.php?/archives/72-OpenJump-for-PostGIS-Spatial-Ad-Hoc-Queries.html">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 class="009271618-08022011"></span> </div>
<div dir="ltr" align="left"><span class="009271618-08022011"><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 class="009271618-08022011"></span> </div>
<div dir="ltr" align="left"><span class="009271618-08022011"><font
color="#0000ff" face="Arial" size="2"><a
moz-do-not-send="true"
href="http://www.postgis.org/documentation/manual-svn/PostGIS_FAQ.html#id2686352">http://www.postgis.org/documentation/manual-svn/PostGIS_FAQ.html#id2686352</a></font></span></div>
</blockquote>
<br>
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 src="cid:part1.02020007.09060607@free.fr" alt=""><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 cite="mid:A54AFA37CF874AC7816158E93D396B06@J"
type="cite">
<div dir="ltr" align="left"><span class="009271618-08022011"></span> </div>
<div dir="ltr" align="left"><span class="009271618-08022011"><font
color="#0000ff" face="Arial" size="2">Leo</font></span></div>
<div dir="ltr" align="left"><span class="009271618-08022011"><font
color="#0000ff" face="Arial" size="2"><a
moz-do-not-send="true" href="http://www.postgis.us">http://www.postgis.us</a></font></span></div>
<div dir="ltr" align="left"><span class="009271618-08022011"></span> </div>
<br>
<div dir="ltr" class="OutlookMessageHeader" align="left"
lang="en-us">
<hr tabindex="-1">
<font face="Tahoma" size="2"><b>From:</b>
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a>
[<a class="moz-txt-link-freetext" href="mailto:postgis-users-bounces@postgis.refractions.net">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 moz-do-not-send="true" href="http://www.dgs.udel.edu"
target="_blank">http://www.dgs.udel.edu</a><br>
**************************************************<br>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
<br>
</body>
</html>