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
