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 <[email protected]> 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:* [email protected] [mailto: > [email protected]] *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 > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > >
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
