[postgis-users] postgis visual client

[Louwrens du Toit]

Hi Stefan,

I would also be interesting in testing your program. Looks quite promising.

Regards,
LJ

__________________________________________________
LJ du Toit

On 2/10/2011 2:36 AM, Stefan Keller 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 
> <mailto: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 <http://www.postgis.us/>
>>
>>     ------------------------------------------------------------------------
>>     *From:* postgis-users-bounces at postgis.refractions.net
>>     <mailto:postgis-users-bounces at postgis.refractions.net>
>>     [mailto: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 <http://www.dgs.udel.edu/>
>>     **************************************************
>>
>>
>>     _______________________________________________
>>     postgis-users mailing list
>>     postgis-users at postgis.refractions.net
>>     <mailto:postgis-users at postgis.refractions.net>
>>     http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>     _______________________________________________
>     postgis-users mailing list
>     postgis-users at postgis.refractions.net
>     <mailto: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/20110210/6c4ed827/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 12659 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110210/6c4ed827/attachment.png>