Bug #88871 Add ST_Transform() function to transform geometry data to different SRID

• Submitted: 12 Dec 2017 9:39
• Modified: 19 Dec 2022 18:11
• Reporter: Yoshiaki Yamasaki
• Status: Closed
• Category: MySQL Server: GIS
• Severity: S4 (Feature request)
• Version: 8.0.3
• OS: Any
• CPU Architecture: Any
• Tags: gis, MySQL

[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] MySQL Verification Team

Hello Yamasaki-San,

Thank you for the feature request!

Thanks,
Umesh

[19 Dec 2022 18:11] Jon Stephens

Fixed in MySQL 8.0.3 by WL#8684 and MySQL 8.0.32 by WL#15164.

Closed.