Bug #88871 Add ST_Transform() function to transform geometry data to different SRID
Submitted: 12 Dec 2017 9:39 Modified: 15 Dec 2017 11:46
Reporter: Yoshiaki Yamasaki Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: GIS Severity:S4 (Feature request)
Version:8.0.3 OS:Any
Assigned to: CPU Architecture:Any
Tags: gis, MySQL
Triage: Needs Triage: D5 (Feature request)

[12 Dec 2017 9:39] Yoshiaki Yamasaki
I want to ST_Transform() function to transform geometry data. ArcGIS and PostGIS and Oracle DB has this function.



I guess ST_SRID of MySQL 8.0 can transform geometry data to different SRID. However, I hope to add ST_Transform() function to avoid confusion.

How to repeat:

Suggested fix:
I'm Japanese MySQL Sales Consultant. User of PostGIS in Japan has this concern and he blogged this concern as follows. 

  PostGISユーザがMySQL 8の空間拡張機能を少し触ってみた  * User of PostGIS tried MySQL 8.0 GIS feature.

He has good expectation for MySQL 8.0 GIS feature, but he said "As long as MySQL doesn't have ST_Transform, I don't use MySQL 8.0 GIS feature".
[13 Dec 2017 5:28] Yoshiaki Yamasaki
[13 Dec 2017 5:43] Yoshiaki Yamasaki
I'm sorry I made a mistake. I haven't written "Suggested fix"

My suggested fix is "Add ST_Transform function".
[15 Dec 2017 11:46] Umesh Shastry
Hello Yamasaki-San,

Thank you for the feature request!