There are 3 postgis plugins in Qgis PgQuery for QGIS : 0.1.1 A powerful plugin for creating, managing and running PostGIS queries from within QGIS Download: pgquery_plugin.zip Author: Gerry James Version: 0.1.1 Minimum QGIS Version: 1.0 Home page: http://www.carteryx.com Experimental: False
PostGIS Manager : 0.5.9 Manage your PostGIS database Download: postgis_manager.zip Author: Martin Dobias Version: 0.5.9 Minimum QGIS Version: 1.0 Home page: http://mapserver.sk/~wonder/ Experimental: False Postgis Query Editor : 1.4.12 The plugin offers a SQL query editor, performs the edited spatial PostGIS queries and visualises the query result as shape in MapCanvas. The path to pgsql2shp must be defined in the PATH environment. Download: postgisquery.zip Author: Horst Düster Version: 1.4.12 Minimum QGIS Version: 1.0 Home page: Experimental: False Noli On 7/28/10, Noli Sicad <[email protected]> wrote: > Karsten, > > Have a look at this blog, > > Leverage the power of PostGIS in QGIS with PgQuery > http://spatialintel.blogspot.com/2009/03/leverage-power-of-postgis-in-qgis-with.html > > You can add more features to this plugin and modify it to suit your needs. > > Noli > > On 7/28/10, karsten vennemann <[email protected]> wrote: >> Hi all, >> >> >> >> I was wondering if there is functionality (a plugin ?) in QGIS that would >> allow the editing of non spatial tables in PostgreSQL that are related to >> a >> PostGIS GIS layer. This could possibly involve the design of a custom >> form >> to enter data. What we will have in the database are 3 related tables for >> a >> project dealing with plant species that are entered in the field. The >> project is pretty similar to the approach taken by the initial version of >> the Open Ocean map (desktop component based on QGIS - compare >> http://www.ecotrust.org/ocean/OpenOceanMap.html ). This are the tables: >> >> >> >> 1) one polygon GIS layer of areas (static) >> >> 2) a 'record" table (updated all the time) >> >> that will store each record ever entered with fields such as species >> name, >> species_id, user, date, and map_area_id (this table will be related in a >> may >> to one relationship to the mapping areas using the map_area_id (many >> records >> related to one mapping area. In the end this table will have information >> for >> each of the mapping areas, for each area several hundred species, for >> each >> species multiple entries over time and from different users >> >> 3) a table of species (pretty static) with specific species data (common >> and scientific names, species_id, web links etc...) related to the >> records >> table using the species_id >> >> >From the above we can create a view of all records linked to a mapping >> areas >> including plant species details. >> >> >> >> We could do this adapting the Open Ocean Map tools - but would need to >> enable advanced editing (to allow updating many map areas records and >> multiple attribute data at once in a form) >> >> . >> >> Any suggestions or insights about other tools/plugins for QGIS that can >> handle something like this already? >> >> >> >> Thanks Karsten >> >> >> >> > _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
