Opened 5 years ago
Last modified 19 hours ago
#33120 assigned New feature
Add OGC-compliant models for GeoDjango running on MySQL 8.0 — at Initial Version
| Reported by: | Jeff Hitchcock | Owned by: | nobody |
|---|---|---|---|
| Component: | GIS | Version: | dev |
| Severity: | Normal | Keywords: | mysql |
| Cc: | Triage Stage: | Accepted | |
| Has patch: | no | Needs documentation: | no |
| Needs tests: | no | Patch needs improvement: | no |
| Easy pickings: | no | UI/UX: | no |
Description
MySQL 8 introduced two new tables that allow the implementation of the SpatialRefSys and GeometryColumns models as well as related functions for adding new SRS entries to the database. Adding these two models and updating related functions to support them would be a good first step to improving GeoDjango's support for MySQL 8.
- Add
MySQLSpatialRefSysmodel connecting to theINFORMATION_SCHEMA.ST_GEOMETRY_COLUMNStable (https://dev.mysql.com/doc/refman/8.0/en/information-schema-st-geometry-columns-table.html) - Add
MySQLGeometryColumnsmodel connecting to theINFORMATION_SCHEMA.ST_GEOMETRY_COLUMNStable (https://dev.mysql.com/doc/refman/8.0/en/information-schema-st-geometry-columns-table.html) - Enable
has_spatialrefsys_tableandsupports_add_srs_entrybackend features if MySQL version is greater than 8.0
Note:
See TracTickets
for help on using tickets.