[postgis-users] postgis visual client

[Stefan Keller]

There are three different prototypes called "PostGIS Terminal" around for a
web based client with a "fixed" PostGIS geodatabase below.

The original PostGIS-Terminal probably is
http://openlayers-buch.de/beispiele/chapter-09/postgis-terminal.html (its
german) then there is http://www.postgisonline.org/  .

I've enhanced theses ideas: http://www.gis.hsr.ch/wiki/PostGIS_Terminal .
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 :->
Yours, S.
2011/2/9 Michaël Michaud <michael.michaud at free.fr>

> Hi,
>
> Le 08/02/2011 19:21, Paragon Corporation a écrit :
>
> John,
> We like using OpenJump for that -- here is a quick tutorial we wrote up on
> doing Ad hoc queries with it.
>
>
> http://www.postgresonline.com/journal/index.php?/archives/72-OpenJump-for-PostGIS-Spatial-Ad-Hoc-Queries.html
>
> 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
>
> http://www.postgis.org/documentation/manual-svn/PostGIS_FAQ.html#id2686352
>
>
> Thanks for the good documentation,
> Would like to mention an undocumented feature coming with the last OpenJUMP
> release.
>
> You can copy the "fence" geometry or the "view extent" in your query  :
>
>
>
> button View (Vue in the screenshot) will copy "${view:-1}" where ever you
> want in the query (replaced by view extent at execution time)
> 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)
>
> It may help to download small parts of large datasets.
>
> Michaël
>
>
> Leo
> http://www.postgis.us
>
>
>  ------------------------------
> *From:* postgis-users-bounces at postgis.refractions.net [
> mailto:postgis-users-bounces at postgis.refractions.net<postgis-users-bounces at postgis.refractions.net>]
> *On Behalf Of *John Callahan
> *Sent:* Tuesday, February 08, 2011 12:25 PM
> *To:* PostGIS Users Discussion
> *Subject:* [postgis-users] postgis visual client
>
> I'm sure this has been asked many times but haven't found a definitive or
> consensus answer...
>
> 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...
>
> 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.
>
> Does anyone know of a GUI tool to use, hopefully one that works for
> Postgres 9 and PostGIS 2?  Thanks.
>
> - John
>
> PS - Thanks for the recommendations on the PostGIS in Action book.  I just
> purchased it and looking forward to learning what I can.
>
> **************************************************
> John Callahan, Research Scientist
> Delaware Geological Survey, University of Delaware
> URL: http://www.dgs.udel.edu
> **************************************************
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.nethttp://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110210/35c55b1c/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: moz-screenshot-7.png
Type: image/png
Size: 12659 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110210/35c55b1c/attachment.png>