[SEDONA-281] Support geodesic / geography functions

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.4.1
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Jia Yu
• Created: 20/May/23 09:04
• Updated: 04/Jun/23 01:42
• Resolved: 04/Jun/23 01:42

Description

Currently, to work with geography, Sedona users have to use ST_Transform to project CRS to a planar meter-based CRS. This works great for local datasets but shows bad accuracy for global datasets. For example, calculate the distance from Beijing to Seattle.

 

We will add at least 4 Sphere/Spheroid functions to support such calculation and basically achieve the similar effect of having a geography type.

 

ST_AreaSpheroid

ST_LengthSpheroid

ST_DistanceSphere

ST_DistanceSpheroid

Issue Links

• is related to: SEDONA-286 Support optimized distance join on ST_DistanceSpheroid and ST_DistanceSphere
• links to: GitHub Pull Request #835
• links to: GitHub Pull Request #846