Support for geo and spatial types/operations

[simonaubertbd]

Hello all,

Well, that's a big one. I have noticed geo and spatial support by databases is more than a mess.
There is the ISO/IEC 13249-3:2003 (SQL/MM-Spatial)

If I have a look at https://www.ogc.org/publications/standard/sfs/
we should find

There is also this page https://archive.org/details/iso13249-3-2016/page/10/mode/2up

Would be great to see firebird be compliant with that, it would be a huge differentiator with competitors.

Best regards,

Simon

[dyemanov]

Duplicates #1025, although they're a bit different regarding design/implementation - OpenGIS vs SQL/MM-Spatial.

[simonaubertbd]

@dyemanov oh, I didn' find the one you mentioned :(

About OpenGIS vs SQL/MM-Spatial, I wonder how it would be able to support both standards since they don't seem incompatible. Right now, the databases are divided in three : some support opengis, some support spatial sql, some don't support anything. It become hard to have a standard code that works on several databases.