[Qgis-user] edit related tables in PostGIS

[Noli Sicad]

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 <nsicad at gmail.com> 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 <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
>>
>>
>>
>>
>