Re: [postgis-users] Viewer plugins of PostGIS --HELP
I have used RT SQL for the exact case that you have outlined. I have a vector 'grid' that I connect to a very large data set. It allows me to store the geometry in one place and then connect the features with the values for one analytical parameter for a particular date for visualization. I have also done a similar thing with MapServer. I have a simple Web app that passes parameters for the date and the analyte to MapServer, which writes the query, hits PostGIS, and then renders the image. David. On Wed, Jun 15, 2011 at 4:04 AM, Paolo Cavallini wrote: > Il giorno mer, 15/06/2011 alle 16.29 +0800, Ben Madin ha scritto: >> This may not help, but I guess I find QGIS quite simple for actually >> visualising data. Maybe not so good for complex queries. There are now >> a number of PostGIS plug-ins though. > > Confirmed. You can also run complex queries via the RT SQL layer plugin, > and others. > All the best. > -- > Paolo Cavallini: http://www.faunalia.it/pc > > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Viewer plugins of PostGIS --HELP
Il giorno mer, 15/06/2011 alle 11.05 +0100, James David Smith ha scritto: > Can you give me more information about the 'RT SQL layer plugin' you > mention please? I use GQIS to visualise my data from PostGIS > sometimes, but do find the query tool a bit limited and wonder whether > this might be the solution...? The plugin enables users without permissions (other than SELECT) to build their queries and to save them client-side. You should not have any major limitation. Please let us know how it goes. All the best. -- Paolo Cavallini: http://www.faunalia.it/pc ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Viewer plugins of PostGIS --HELP
Dear Paolo, Can you give me more information about the 'RT SQL layer plugin' you mention please? I use GQIS to visualise my data from PostGIS sometimes, but do find the query tool a bit limited and wonder whether this might be the solution...? Thanks James On 15 June 2011 10:04, Paolo Cavallini wrote: > Il giorno mer, 15/06/2011 alle 16.29 +0800, Ben Madin ha scritto: >> This may not help, but I guess I find QGIS quite simple for actually >> visualising data. Maybe not so good for complex queries. There are now >> a number of PostGIS plug-ins though. > > Confirmed. You can also run complex queries via the RT SQL layer plugin, > and others. > All the best. > -- > Paolo Cavallini: http://www.faunalia.it/pc > > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Viewer plugins of PostGIS --HELP
Il giorno mer, 15/06/2011 alle 16.29 +0800, Ben Madin ha scritto: > This may not help, but I guess I find QGIS quite simple for actually > visualising data. Maybe not so good for complex queries. There are now > a number of PostGIS plug-ins though. Confirmed. You can also run complex queries via the RT SQL layer plugin, and others. All the best. -- Paolo Cavallini: http://www.faunalia.it/pc ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Viewer plugins of PostGIS --HELP
Ben, I know that the qGIS - OpenJump - uDig are very good solutions for visualizing the spatial data of postgis, but.. i want to try and explore these plug-ins. Anyway, thanks for your reply! Apostolis ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Viewer plugins of PostGIS --HELP
Apostolis, This may not help, but I guess I find QGIS quite simple for actually visualising data. Maybe not so good for complex queries. There are now a number of PostGIS plug-ins though. Download. Install. Run. Add PostGIS Layer... cheers Ben On 15/06/2011, at 4:19 PM, ΑΠΟΣΤΟΛΟΣ ΛΕΛΕΝΤΖΗΣ wrote: > Hi list > > For another time, i ask your help and your valuable experience!! > My problem is related with ad-hoc solutions for viewing spatial data of a > postgis database. > I was searching a lot in the internet, and i found the following links which > indicate the installation and the usability of a postgis-viewer plugin. > > [1] > http://www.postgresonline.com/journal/archives/180-pgAdmin113plugins_postgis.html > [2] > http://geotux.tuxfamily.org/index.php?option=com_myblog&task=view&id=277&Itemid=59&lang=en > > Regarding with the first plugin[1], i have execute all the necessary guides > for the installation, but it doesn't work. > Specifically, i select a geometric table or i type a spatial SQL query, but > when i switch the postgis viewer then the new window don't visualize the > relevant table or the spatial outputs. > So, could anyone help me?? Maybe, someone else has used this tool?? > > Concerning with the second plugin [2], i have installed it, very easy and > quickly, but it doesn't work because it requires the installation of OSGeo4W > environment. > The postgis_viewer.bat file contains some variables which correspond to > OSGeo4W paths. Because, i have installed seperate all these programs which > are contained at OSGeo4W, i must change these paths for the good operation > of plugin. So, could anyone to show me how to configure the > postgis_viewer.bat file??? > > Any suggestion is accepted! > Thanks in advance > > Apostolis > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] Viewer plugins of PostGIS --HELP
Hi list For another time, i ask your help and your valuable experience!! My problem is related with ad-hoc solutions for viewing spatial data of a postgis database. I was searching a lot in the internet, and i found the following links which indicate the installation and the usability of a postgis-viewer plugin. [1] http://www.postgresonline.com/journal/archives/180-pgAdmin113plugins_postgis.html [2] http://geotux.tuxfamily.org/index.php?option=com_myblog&task=view&id=277&Itemid=59&lang=en Regarding with the first plugin[1], i have execute all the necessary guides for the installation, but it doesn't work. Specifically, i select a geometric table or i type a spatial SQL query, but when i switch the postgis viewer then the new window don't visualize the relevant table or the spatial outputs. So, could anyone help me?? Maybe, someone else has used this tool?? Concerning with the second plugin [2], i have installed it, very easy and quickly, but it doesn't work because it requires the installation of OSGeo4W environment. The postgis_viewer.bat file contains some variables which correspond to OSGeo4W paths. Because, i have installed seperate all these programs which are contained at OSGeo4W, i must change these paths for the good operation of plugin. So, could anyone to show me how to configure the postgis_viewer.bat file??? Any suggestion is accepted! Thanks in advance Apostolis ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users