dolthub / dolthub/dolt

Handle SRIDs more like Postgres + PostGIS

Open
#5,988 2 comments 0 reactions 0 assignees View on GitHub
enhancement spatial types
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.