[Qgis-user] edit related tables in PostGIS

[Noli Sicad]

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 <karsten at terragis.net> 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
>
>
>
>