All Products
Search
Document Center

ApsaraDB RDS:ST_GeoHashFromID

Last Updated:Sep 04, 2023

This topic describes the ST_GeoHashFromID function. This function converts an INT-type value to a Geohash string.

Syntax

cstring  ST_GeoHashFromID(bigint value);

Parameters

Parameter

Description

value

An integer type value.

Description

This function converts an INT-type value to a Geohash string. You can call the ST_GeoHashID function to obtain an INT-type value. For more information, see ST_GeoHashID.

Examples

select ST_GeoHashFromID(
      ST_GeoHashID(ST_GeoHash
                    (ST_GeomFromText('POINT(-115.172816 36.114646)'), 11)::cstring));

------------------
 9qqj7nmxncg