[postgis-users] postgis visual client

[John Callahan]

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 <jrmrolland at aol.com> 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
> > postgis-users at postgis.refractions.net
> > 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
> 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/20110211/2dd19de0/attachment.html>