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
