[Qgis-user] How to digitze points, linestrings, polygons in a single PostGIS geometry-column

[pcreso at pcreso.com]

Hi Astrid,

The only way of doing what you suggest is to create your table, then add views splitting out the geometries into the different types for use in QGIS. Update rules may need to be applied to the views to support editing through them 

There are other ways of achieving a similar effect, but this is the only way to have the single database geometry column that you specify. 

If your use case allows this, I suggest you revisit your requirement for a single table, so that you manage your underlying data in separate tables, & apply a view unioning the tables into the single database view. I think this will be a more robust way to have the editing & data management facilities, & the apparent single table/column that you require.

Brent Wood

--- On Mon, 12/17/12, Astrid Emde <astrid.emde at wheregroup.com> wrote:

From: Astrid Emde <astrid.emde at wheregroup.com>
Subject: [Qgis-user] How to digitze points, linestrings, polygons in a single PostGIS geometry-column
To: qgis-user at lists.osgeo.org
Date: Monday, December 17, 2012, 9:22 PM

Hello,

in a project I want to handle in one PostgreSQl/PostGIS table different
geometrytypes (POINT, LINESTRING, POLYGON or even MULTI-objects) in a
single geometrycolumn.

Then I would like to digitize with QGIS new objects. Is this possible?

I tried it already but in QGIS it is not possible to select the
different geometrytypes although I already have different geometrytypes
in the table.

I tried with the TYPE GEOMETRYCOLLECTION too, but QGIS seams not to
support this at all.

I am using PostGIS 1.5 and QGIS 1.8.0.

Thanks for your help.

-- 
Best regards

Astrid Emde

----------------------------------
 Astrid Emde
 WhereGroup GmbH & Co.KG
 Eifelstraße 7
 53119 Bonn
 Germany

 Fon: +49(0)228 90 90 38 - 19
 Fax: +49(0)228 90 90 38 - 11

 astrid.emde at wheregroup.com
 www.wheregroup.com
 Folgen Sie der WhereGroup auf twitter: http://twitter.com/WhereGroup_com

Amtsgericht Bonn, HRA 6788
-------------------------------
Komplementärin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Olaf Knopp, Peter Stamm
-------------------------------
 pgp-public key:
 http://pgp.mit.edu:11371/pks/lookup?search=0x06DA52D72D515284
  Signierte und/oder verschlüsselte Nachrichten sind sehr willkommen
  Signed and/or encrypted mail is highly appreciated
_______________________________________________
Qgis-user mailing list
Qgis-user at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20121217/b45f79d9/attachment.html>