[postgis-users] postgis visual client

[John Callahan]

It's working now.  Great.  Thanks for the help, and the plugin.   I had an
older version of .NET 2.0 on my machine (WinXP x64).  Upgrading to .NET
3.0/3.5 did the trick.

And thanks for the discussion.  With the availability of this plugin
(PostGISViewer), OpenJump, several QGIS plugins, and the PostGIS Terminal
from Stefan, it makes my original question seem silly.

- John



On Fri, Feb 11, 2011 at 10:59 AM, j.rolland <jrmrolland at aol.com> wrote:

>
> John,
>
> MapWindow6 or .NET 4.0 don't need to be installed,
>
> 1) just download
> http://dl.free.fr/icO8LcHoa PostGISViewer  and decompress it like follow :
>
> http://old.nabble.com/file/p30902546/directory_postgisviewer.jpg
>
> 2) define the binaries directory in PgAdmin III Preferences :
>
> http://old.nabble.com/file/p30902546/preferences_pgadminIII.jpg
>
> you can see that the PostGisViewer directory is in C:\Program
> Files\PostgreSQL\9.0\bin
>
> 3) put the lines that follow in the plugins.ini file
>
> ;
> ; PgViewer (Windows)
> ;
> [Separator]
> Title=PostGisViewer
> Command="$$PGBINDIR\PostGisViewer\PGViewer.exe"  "host=$$HOSTNAME"
> "port=$$PORT" "username=$$USERNAME" "password=$$PASSWORD"
> "database=$$DATABASE" "schema=$$SCHEMA"  "table=$$TABLE"
> Description=PostGIS Viewer
> KeyFile=$$PGBINDIR\PostGisViewer\PGViewer.exe
> Platform=windows
> ServerType=postgresql
> Database=Yes
> ;AppliesTo=database
> SetPassword=Yes
>
> 4) When you start again PgAdmin you must see PostGisViewer in the Plugins
> Menu.
>
>
> I am using PostgreSQL 9.0 and PgAdmin III 1.12.1 , but i had also tested my
> plugin with Postgresql 8.2 /8.4 and PgAdmin III 1.10
>
>
> regards,
> Jérôme Rolland
>
>
> John Callahan wrote:
> >
> > 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
> >>
> >
> > _______________________________________________
> > 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-tp30875438p30902546.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/d5510f0e/attachment.html>