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

Example:

SELECT ST_H3ToParent(614552609325318143, 5)

Output:

+----+--------------------+
| op |             EXPR$0 |
+----+--------------------+
| +I | 601041811137363967 |
+----+--------------------+