This topic describes the ST_GeoHashID function. This function converts a GeoHash string into an INT-type value.
Syntax
bigint ST_GeoHashID(cstring geoHash);
Parameters
Parameter | Description |
geoHash | The Geohash string that you want to convert. |
Description
This function converts a Geohash string into an INT-type value. This facilitates data storage and computing. The system can process 16-character Geohash strings.
Examples
select ST_GeoHashID(ST_GeoHash
(ST_GeomFromText('POINT(-115.172816 36.114646)'), 11)::cstring);
---------------------
2220678768189336756