Thanks for the reference. I love the idea of a map viewer plugin for pgAdmin. I wasn't aware of this plugin. Unfortunately, I could not get it to work through pgAdmin III 1.12 (error: "pgviewer encountered a problem and needs to close") Off-hand, does it require MapWindow6 or .NET 4.0 to be installed?
- John ************************************************** John Callahan, Research Scientist Delaware Geological Survey, University of Delaware URL: http://www.dgs.udel.edu ************************************************** On Thu, Feb 10, 2011 at 4:51 AM, j.rolland <[email protected]> wrote: > > John, > > > I developed a plugin for PgAdmin III to visualize PostGIS data. > Go to the following link > > http://ageoguy.blogspot.com/2010/06/plugin-pgadmin-iii-postgisviewer-suite.html > postgisviewer a plugin for PgAdmin III > on my blog where you can download it and you will find a tutorial (in > french) to install and use it. > > You can also consult this link > > http://www.postgresonline.com/journal/archives/180-pgAdmin113plugins_postgis.html > Postgresonline journal pgAdmin III plugins postgis > > Regards, > Jérôme Rolland > > > John Callahan wrote: > > > > 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 > > > > > > -- > View this message in context: > http://old.nabble.com/postgis-visual-client-tp30875438p30890812.html > Sent from the PostGIS - User mailing list archive at Nabble.com. > > _______________________________________________ > 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
