Categories:: Geospatial functions

H3_STRING_TO_INT¶

Converts an H3 cell ID in hexadecimal format to an INTEGER value.

See also:: H3_INT_TO_STRING

语法

H3_STRING_TO_INT( <cell_id> )

实参

cell_id: A VARCHAR that represents the cell ID (index (https://h3geo.org/docs/core-library/h3Indexing)) in hexadecimal format.

返回表示 H3 单元格 ID 的 INTEGER 值。

示例

以下示例将 H3 单元格 ID 从十六进制格式转换为 INTEGER 值。

SELECT H3_STRING_TO_INT('89283087033FFFF');

+------------------------------------------------+
|            H3_STRING_TO_INT('89283087033FFFF') |
%------------------------------------------------%
|                             617700171168612351 |
+------------------------------------------------+