<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Stefan,<br>
<br>
I would also be interesting in testing your program. Looks quite
promising.<br>
<br>
Regards,<br>
LJ<br>
<pre class="moz-signature" cols="72">__________________________________________________
LJ du Toit
</pre>
On 2/10/2011 2:36 AM, Stefan Keller wrote:
<blockquote
cite="mid:AANLkTi=SSv4+rmt0-YuEAMrGN98KnF40pakd+763svQS@mail.gmail.com"
type="cite">
<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
moz-do-not-send="true"
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 moz-do-not-send="true"
href="http://www.postgisonline.org/">http://www.postgisonline.org/</a> .
</div>
<div> </div>
<div>I've enhanced theses ideas: <a moz-do-not-send="true"
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
moz-do-not-send="true" href="mailto:michael.michaud@free.fr">michael.michaud@free.fr</a>></span><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 class="im">
<blockquote type="cite">
<div dir="ltr" align="left"><span><font size="2"
color="#0000ff" face="Arial">John, </font></span></div>
<div dir="ltr" align="left"><span><font size="2"
color="#0000ff" 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 size="2"
color="#0000ff" face="Arial"><a
moz-do-not-send="true"
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 size="2"
color="#0000ff" 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 size="2"
color="#0000ff" face="Arial"><a
moz-do-not-send="true"
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.06030204.01070100@eva.mpg.de"><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 size="2"
color="#0000ff" face="Arial">Leo</font></span></div>
<div dir="ltr" align="left"><span><font size="2"
color="#0000ff" face="Arial"><a
moz-do-not-send="true"
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
moz-do-not-send="true"
href="mailto:postgis-users-bounces@postgis.refractions.net"
target="_blank">postgis-users-bounces@postgis.refractions.net</a>
[<a moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true" href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a>
<a moz-do-not-send="true" 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 moz-do-not-send="true"
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a moz-do-not-send="true"
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>
<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>
</body>
</html>