Bug #84384 Upgrade to EPSG Dataset 9.0
Submitted: 2 Jan 2017 14:30 Modified: 6 Jan 2017 19:04
Reporter: Norvald Ryeng Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: GIS Severity:S3 (Non-critical)
Version:8.0.1 OS:Any
Assigned to: CPU Architecture:Any

[2 Jan 2017 14:30] Norvald Ryeng 
Description:
MySQL 8.0.0 DMR contains spatial reference systems (SRSs) from the EPSG Dataset 8.7. EPSG 9.0 has been released with the following changes relevant to MySQL:

- New SRSs have been added
- New conversions between SRSs have been added
- Some SRSs have been deprecated
- Some SRSs have changed name (but not SRID)
- "Long" axes have been renamed "Lon"

How to repeat:
N/A

Suggested fix:
Since the existing 8.7 data is only shipped in a DMR, not in any stable releases, replace it with 9.0 data. Do not keep existing TOWGS84 clauses if there are more suitable transformations to WGS84. Remove deprecated SRSs. Use new "Lon" axis naming and new SRS names.
[6 Jan 2017 19:04] Paul DuBois 
Posted by developer:
 
Noted in 8.0.1 changelog.

The data stored in the data dictionary st_spatial_reference_systems
table has been upgraded from EPSG Dataset 8.7 to EPSG Dataset 9.0.