[postgis-users] postgis visual client

[John Callahan]

Thanks for the responses.  What you describe in your write up with OpenJump
is exactly what I'm trying to do.  Also, in addition to the QGIS plugins
strk mentions, I just found two more possibilities: PgQuery for QGIS and
Postgis SQL Editor.  Looks like there are some good options available.
Thanks again.

- John



On Tue, Feb 8, 2011 at 1:21 PM, Paragon Corporation <lr at pcorp.us> wrote:

>  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
>
> Leo
> http://www.postgis.us
>
>
>  ------------------------------
> *From:* 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
> **************************************************
>
> _______________________________________________
> 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/20110208/22e28a61/attachment.html>