Skip to content
πŸŽ‰ Apache Sedona 1.9.1 is out now! πŸ—ΊοΈ Geography SQL functions, Box2D & Box3D types, raster Python UDFs & more. Read the release notes β†’

ST_H3ToParent

Introduction: Returns the result of the H3 function cellToParent(cell, resolution). The requested resolution must be between 0 and the input cell's resolution, inclusive.

Format: ST_H3ToParent(cell: Long, resolution: Int)

Return type: Long

Since: v2.0.0

SQL Example

SELECT ST_H3ToParent(614552609325318143, 5)

Output:

+--------------------------------------------+
|st_h3toparent(614552609325318143, 5)        |
+--------------------------------------------+
|                          601041811137363967|
+--------------------------------------------+