[Qgis-user] edit related tables in PostGIS

[karsten vennemann]

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

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20100728/05c9a90c/attachment.html>