Handle SRIDs more like Postgres + PostGIS
- Dominant language
- Go
- Stars
- 24.4k
- Forks
- 873
- Avg merge
- 1d 5h
- Merged PRs (30d)
- 108
Description
Dolt recognizes the same set of SRIDs as MySQL does, meaning we're able to create, read, write, and version geometries with those SRIDs. This makes us MySQL compatible, as in we behave in the same was MySQL does for listed and unlisted SRIDs.
However, we should consider adding a `@@dolt_postgis_emulation=1` mode.
This means:
- recognizing all SRIDs listed in PostGIS's `spatial_ref_sys` table (we're missing ~3000)
- converting out of range SRIDs to the nearest, so either `0` or `999009`
- any unlisted but in range SRIDs are accepted as is, and act as if they were SRID 0
- this requires special casing selects onto our information_schema to indicate that these SRIDs exist
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.