geo_h3cell_parent()
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
Calculates the H3 cell parent.
Read more about H3 Cell.
geo_h3cell_parent(
h3cell,
resolution)
Learn more about syntax conventions.
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. |
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.
print parent_cell = geo_h3cell_parent('862a1072fffffff')
Output
parent_cell |
---|
852a1073fffffff |
The following example calculates cell parent at level 1.
print parent_cell = geo_h3cell_parent('862a1072fffffff', 1)
Output
parent_cell |
---|
812a3ffffffffff |
print parent_res = geo_h3cell_level(geo_h3cell_parent((geo_point_to_h3cell(1,1,10))))
Output
parent_res |
---|
9 |
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.
print invalid = isempty(geo_h3cell_parent('123'))
Output
invalid |
---|
1 |
The following example produces an empty result because of the invalid parent resolution.
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.
print invalid = isempty(geo_h3cell_parent('862a1072fffffff', 15))
Output
invalid |
---|
1 |