This topic describes the ST_AsInt function. This function converts an H3-encoded geographic grid object into a long integer representation.
Syntax
bigint ST_AsInt(h3grid grid);
Parameters
Parameter | Description |
grid | The H3 geographic grid object that you want to convert. |
Examples
select st_asint(st_h3frombinary('\x010100ffff9f6826a18408'));
st_asint
--------------------
613792635565375487