[SEDONA-39] Fix the Lon/lat order issue in Sedona

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.0.0, 1.0.1, 1.1.0, 1.1.1, 1.2.0, 1.2.1, 1.3.0, 1.3.1, 1.4.0, 1.4.1
• Fix Version/s: 1.5.0
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Jia Yu
• Created: 01/Jun/21 02:52
• Updated: 06/Oct/23 20:10
• Resolved: 06/Oct/23 20:05

Description

Since Sedona 1.0.0, the lon/lat order in ST_Transform is swapped by default. This makes it inconsistent with PostGIS, QGIS, GeoPandas and other similar apps.

 

The following functions should be fixed

Spark RDD:

CRStransform

 

Spark SQL/Flink SQL:

ST_GeoHash

ST_DistanceSphere

ST_DistanceSpheroid

ST_Transform

All RS constructors

All RS predicates

Issue Links

• Blocked: SEDONA-54 ST_Transform from 4326 to 3857 throws exception
• incorporates: SEDONA-356 Change CRS transformation from lat/lon to lon/lat order
• is blocked by: SEDONA-349 Drop the support of typed RDDs
• links to: GitHub Pull Request #639
• links to: GitHub Pull Request #639