[postgis-users] postgis visual client

[Paragon Corporation]

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-Po
stGIS-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
**************************************************

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110208/57da6478/attachment.html>