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