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:
None 
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
Description:
I want to ST_Transform() function to transform geometry data. ArcGIS and PostGIS and Oracle DB has this function.

  ST_Transform(ArcGIS)
  http://webhelp.esri.com/arcgisdesktop/9.3/index.cfm?TopicName=ST_Transform

  ST_Transform(PostGIS)
  https://postgis.net/docs/ST_Transform.html

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:
N/A

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.
  https://qiita.com/yellow_73/items/985b8961d22013bc0f3f

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!

Thanks,
Umesh