[postgis-users] postgis visual client

[John Callahan]

Thank you Stefan.  Yes, I would be interested in testing your application.
Looks interesting.

- John

**************************************************
John Callahan, Research Scientist
Delaware Geological Survey, University of Delaware
URL: http://www.dgs.udel.edu
**************************************************


On Wed, Feb 9, 2011 at 8:36 PM, Stefan Keller <sfkeller at gmail.com> wrote:

> 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
>>
>>
>
> _______________________________________________
> 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/20110209/f9af943b/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/20110209/f9af943b/attachment.png>