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.
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
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
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
