ST_GeoHashFromID
Converts a bigint value to a Geohash string. Use ST_GeoHashID to obtain the bigint input value.
Syntax
cstring ST_GeoHashFromID(bigint value);Parameters
| Parameter | Description |
|---|---|
value | An array of the integer type. |
Examples
The following example decodes a Geohash integer back to its string representation by chaining ST_GeomFromWKT, ST_GeoHash, ST_GeoHashID, and ST_GeoHashFromID.
select ST_GeoHashFromID(
ST_GeoHashID(ST_GeoHash
(ST_GeomFromWKT('POINT(-115.172816 36.114646)'), 11)::cstring));
------------------
9qqj7nmxncg