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

[Astrid Emde]

Hello,

thanks to all of you for the feedback.

Looks like it is better, not to handle different geometrytype in one column.

I will try your suggestions

Thanks Astrid

On Mon, December 17, 2012 5:32 pm, pcreso at pcreso.com wrote:
> 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
>
>


-- 
Mit freundlichen Grüßen

Astrid Emde

*********************************************
Das WhereGroup Team wünscht Ihnen ein frohes
Weihnachtsfest und ein glückliches Jahr 2013!
http://www.wheregroup.com
*********************************************

----------------------------------

 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