[SEDONA-235] Create ST_S2_CellId in Sedona

• Type: New Feature
• Status: Resolved
• Priority: High
• Resolution: Fixed
• Fix Version/s: 1.4.0
• Labels: pull-request-available
• Assignee: Zongsi Zhang
• Reporter: Jia Yu
• Created: 30/Jan/23 21:30
• Updated: 28/Feb/23 04:44
• Resolved: 28/Feb/23 04:44

Description

This feature will be mainly used for performing spatial join.

 

Given a specific resolution, ST_S2_CellId on each geometry will yield different results

1. Point / MultiPoint: generate a cell id for each point
2. Polygon / MultiPolygon: generate an array of ids. These cells should fully cover the exact shapes of these polygons - Or, at least the MBRs of these polygons.
3. LineString / MultiLineString: generate an array of ids. These cells should fully cover the exact shapes of these LineStrings - Or, at least the MBRs of these LineStrings.
4. GeometryCollection: for each geometry inside, choose the corresponding solution above.

 

XYZM handling: only deal with XY, ignoring Z and M

Null safety: produce a null given a null geometry input.

 

The PR should demonstrate how to run spatial join using S2 ids and produce accurate results.

Issue Links

• links to: GitHub Pull Request #764