H3_HEXSTRING_TO_CELL

Converts an H3 cell ID in hexadecimal format to a BIGINT cell ID.

See also:

• H3_CELL_TO_HEXSTRING

Syntax

H3_HEXSTRING_TO_CELL(<cell_hex_string>)

Arguments

• <cell_hex_string>: A VARCHAR representing the H3 cell ID.

Returns

Returns a BIGINT representing the H3 cell ID. Invalid cell IDs result in an error.

Example

SELECT h3_hexstring_to_cell('83754efffffffff');
-- 592035265791393791