[Qgis-developer] Thoughts about multi-type tables in QGIS
Roy
royroge at outlook.com
Sat Apr 4 03:05:00 PDT 2015
Hi,
i wonder if it is more likely that the same geometry type have the same
attributes,
what happens when i need an area column and also have points in the very
same table?
can i deal with that in a "normalized" structure? i find this a bit
confusing to undersand;
it seems an interesting feature but i would like to see a real case
scenario, can someone
make an example or point me to an example?
Thanks, Roy.
Il 04/04/2015 10.28, Marco Hugentobler ha scritto:
> Hi
>
> Yes, the implicit assumption that each layer has one geometry type
> probably goes back to the shapefile. I agree it is a wrong design from
> QGIS to assume that and it is not in line with the logic of many
> important datasources (Postgres, Oracle, MS SQL, WFS and also some OGR
> formats like dxf), therefore causing workarounds on the dataprovider
> level to seperate db tables into several layers. I think it is best
> (at least in the long term) to have a logic compatible to the
> datasources instead of doing workarounds at provider and gui level.
>
> There are many places where this has an impact (e.g. symbology system,
> editing). Therefore it will be good to break the 'one geometry type'
> assumption not before version 3. A first step could be to identify the
> places in core/gui/app where changes would be needed.
>
> @Nathan and Victor: I don't have experience with MapInfo. What is the
> exact reason why multi-geometries have been user-unfriendly there?
>
> Regards,
> Marco
>
>
>
> On 02.04.2015 13:52, Olivier Dalang wrote:
>> Hi,
>>
>> In some projects of mine, I work with multiple geometry types in one
>> postgis table, using a column of type geometry(Geometry,4326).
>> This is very well supported by postgis.
>>
>> It is possible to load such a table in QGIS by manually selecting the
>> geometry type you want to load. This means that to display all the
>> features, you need to add the table three times, one for each feature
>> type.
>>
>> This works more or less. There are a few bugs though :
>> - http://hub.qgis.org/issues/12499 (you can edit other type's node
>> with the node tool)
>> - http://hub.qgis.org/issues/12500 (other type's records are shown in
>> the attribute table)
>>
>> This also has some limitations. When having such a setup, it's pretty
>> sure you'll want to have the same edit forms for all the layers.
>> You'll also probably want the same filter, the same labels, the same
>> actions, etc...
>> The only thing you'd want to be able to define on a geometry type
>> basis are the symbol (well, even the classification/colors/etc could
>> be shared) and the label placement.
>> For now, you must do all settings three times, because of this
>> bug/feature request :
>> - http://hub.qgis.org/issues/12303 (copy/paste style from one
>> geometry type to another)
>>
>>
>> As you see, support multiple geometry types in QGIS is not perfect.
>>
>> Of course it's possible to fix the bugs/pr, and there are some
>> workarounds (postgis view instead of tables) but maybe it's also
>> worth thinking a bit more in depth about this.
>>
>> We could consider point/line/polygons as subcategories/sublayers of a
>> layer. A shapefile or a mono-typed table would have only one of those
>> sublayer, but a postgis table could perfectly have the three. Most of
>> the settings would be defined at the layer level, while only some
>> settings would be defined at the subcategory level.
>>
>> This is probably especially relevant when thinking long term (the day
>> we support 3D, curves, etc...).
>>
>>
>> What do you think ?
>> Do you think the relation 1 layer = 1 geometry type will hold ?
>>
>> I think we inherited this from the old shapefile format, but most
>> data sources QGIS handles don't have this limitation. I also think it
>> does not hold with quite a lot of modern GIS uses (especially web
>> related, think of openstreetmaps for instance).
>>
>> There's this feature request (6th oldest open issue on the tracker)
>> about postgis geometry collections : http://hub.qgis.org/issues/167
>>
>>
>> Best,
>>
>> Olivier
>>
>>
>>
>> _______________________________________________
>> Qgis-developer mailing list
>> Qgis-developer at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>
>
> --
> Dr. Marco Hugentobler
> Sourcepole - Linux & Open Source Solutions
> Weberstrasse 5, CH-8004 Zürich, Switzerland
> marco.hugentobler at sourcepole.ch http://www.sourcepole.ch
> Technical Advisor QGIS Project Steering Committee
>
>
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20150404/90fda9e0/attachment.html>
More information about the Qgis-developer
mailing list