[QGIS-Developer] Empty or NULL geometry when deleting vertices and sub parts?

[Régis Haubourg]

Hi all,
I'm raising this again, I have opposite opinions regarding what should be
the best behavior when deleting parts of a geometry vs deleting all
vertices. We need to choose EMPTY geometry or NULL geometry. My personal
choice goes to NULL, because I think very few users know about it and test
EMPTY geometries, when it does not seem to provide additional feature than
NULL, at last for spatial database formats.
Any opinion?
Régis

Le mar. 14 mai 2019 à 09:14, Régis Haubourg <regis.haubourg at gmail.com> a
écrit :

> Hi all,
> We encounter different behaviors regarding NULL/Empty geometries and I
> need your wisdom lights:
> (Using postgis provider here)
> - when deleting all the vertices of a geometry we get a NULL geometry
> - when deleting all parts of a multiline, when get an empty geometry
>
> I think we should homogenize the behavior here.
>
> Googling a bit led me into the uncertainties of NULL and Empty concepts
> into the SFS, WKT, WKB standards, but I fail to decide which one is the
> best.
> As an average data administrator, I would choose NULL because I almost
> never test geometries for being Empty and I think this could be a caveat
> for most users.
>
> Someone has any opinion here ?
>
> Best regards
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20190529/76f1af88/attachment.html>