geo_h3cell_parent()

Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel

Calculates the H3 cell parent.

Read more about H3 Cell.

Syntax

geo_h3cell_parent(h3cell,resolution)

Learn more about syntax conventions.

Parameters

Name	Type	Required	Description
h3cell	string	✔️	An H3 Cell token value as it was calculated by geo_point_to_h3cell().
resolution	int		Defines the requested children cells resolution. Supported values are in the range [0, 14]. If unspecified, an immediate children token will be calculated.

Returns

H3 Cell parent token string. If the H3 Cell is invalid or parent resolution is higher than given cell, the query will produce an empty result.

Examples

Run the query

print parent_cell = geo_h3cell_parent('862a1072fffffff')

Output

parent_cell
852a1073fffffff

The following example calculates cell parent at level 1.

Run the query

print parent_cell = geo_h3cell_parent('862a1072fffffff', 1)

Output

parent_cell
812a3ffffffffff

Run the query

print parent_res = geo_h3cell_level(geo_h3cell_parent((geo_point_to_h3cell(1,1,10))))

Output

parent_res
9

Run the query

print parent_res = geo_h3cell_level(geo_h3cell_parent(geo_point_to_h3cell(1,1,10), 3))

Output

parent_res
3

The following example produces an empty result because of the invalid cell input.

Run the query

print invalid = isempty(geo_h3cell_parent('123'))

Output

invalid
1

The following example produces an empty result because of the invalid parent resolution.

Run the query

print invalid = isempty(geo_h3cell_parent('862a1072fffffff', 100))

Output

invalid
1

The following example produces an empty result because parent can't be of a higher resolution than child.

Run the query

print invalid = isempty(geo_h3cell_parent('862a1072fffffff', 15))

Output

invalid
1