[SEDONA-145] Fix ST_AsEWKT to reserve the Z coordinate

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.3.0
• Labels: pull-request-available
• Assignee: Kengo Seki
• Reporter: Kengo Seki
• Created: 17/Aug/22 01:44
• Updated: 22/Oct/22 16:14
• Resolved: 22/Oct/22 16:14

Description

Currently, ST_AsEWKT drops the Z coordinate, while ST_AsText reserves it.

scala> spark.sql("SELECT ST_AsText(ST_Point(0.0, 0.0, 0.0))").show()
+----------------------------------+
|st_astext(st_point(0.0, 0.0, 0.0))|
+----------------------------------+
|                    POINT Z(0 0 0)|
+----------------------------------+

scala> spark.sql("SELECT ST_AsEWKT(ST_Point(0.0, 0.0, 0.0))").show()
+----------------------------------+
|st_asewkt(st_point(0.0, 0.0, 0.0))|
+----------------------------------+
|                       POINT (0 0)|
+----------------------------------+

As far as I can see, Sedona's 3D support is limited as of now, but a few functions (e.g., ST_3DDistance) support it, so the Z coordinate should be reserved.

Issue Links

• links to: GitHub Pull Request #665