Categories:

Geospatial Functions

H3_GRID_DISTANCE

Returns the distance between two H3 cells specified by their IDs.

Syntax

H3_GRID_DISTANCE( <cell_id_1> , <cell_id_2> )
Copy

Arguments

cell_id_1

An INTEGER that represents the H3 cell ID (index), or a VARCHAR that represents the cell ID in hexadecimal format.

cell_id_2

An INTEGER that represents the H3 cell ID (index), or a VARCHAR that represents the cell ID in hexadecimal format.

Returns

Returns the INTEGER value representing the distance in grid cells betweeen the two H3 cells.

Usage Notes

The two input cell IDs must use the same resolution.

Examples

The following example returns the distance (in terms of the number of grid cells) between two H3 cells. The example specifies the H3 cell IDs as INTEGER values.

SELECT H3_GRID_DISTANCE(617540519103561727, 617540519052967935);
Copy
+----------------------------------------------------------+
| H3_GRID_DISTANCE(617540519103561727, 617540519052967935) |
|----------------------------------------------------------|
|                                                        5 |
+----------------------------------------------------------+

The following example specifies the hexadecimal values of H3 cell IDs as VARCHAR values:

SELECT H3_GRID_DISTANCE('891f1d48b93ffff', '891f1d4888fffff');
Copy
+--------------------------------------------------------+
| H3_GRID_DISTANCE('891F1D48B93FFFF', '891F1D4888FFFFF') |
|--------------------------------------------------------|
|                                                      5 |
+--------------------------------------------------------+