Skip to content

H3_CELL_PARENT

Returns the BIGINT ID of the parent of an H3 cell at a given resolution.

Syntax

sql
H3_CELL_PARENT(<cell>, <target_resolution>)

Arguments

  • <cell>: A BIGINT representing the H3 cell ID.
  • <target_resolution>: An integer between 0-15 (inclusive) specifying the H3 resolution of the returned cell.

Returns

A BIGINT representing the ID of the H3 parent cell at the specified target resolution. Resolution outside a valid range results in an error.

Example

sql
SELECT h3_cell_to_hexstring(h3_cell_parent(h3_point_to_cell('POINT(0 0)', 3), 2));
-- 82754ffffffffff