Comments - SPATIAL INDEX
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
It would be a great deal if spatial indexes would be possible on on columns that allow NULL values.
Spatial Indexes only on NOT NULL columns are only suitable for about 20% of the gis data we work with.
Don´t know why it has been developed that way. Datasets that have a NULL - Geometry simply can be ignored by the index.
As a MariaDB user I agree, but did you consider using a special geometry value instead of NULL? For example, a POINT(0,0). Of course this can be done if you'll never need a "real" point at 0, 0.
Why not use otherwise-out-of-bounds instead? For geocoordinates measured in degrees, one could use POINT(-720,-720).