ST_PointFromGeoHash-ApsaraDB RDS(RDS)-阿里云帮助中心

Constructs a point from a Geohash string. The returned point is the center point of the geographic area represented by the Geohash string.

Syntax

point  ST_PointFromGeoHash(text  geohash , integer  precision);

Parameter	Description
`geohash`	The Geohash string.
`precision`	The precision at which to construct the point. If not specified, the function returns a point at the full precision of the input Geohash string.

The returned point is the center point of the geographic area represented by the Geohash string.

Construct a point using the default precision

SELECT ST_AsText(ST_PointFromGeoHash('wx47x9u8gumnhzp791zb'));

Result:

          st_astext
-----------------------------
 POINT(116.00000000000007 39.999999999999936)
(1 row)

Construct a point using a custom precision

SELECT ST_AsText(ST_PointFromGeoHash('wx47x9u8gumnhzp791zb',2));

Result:

       st_astext
------------------------
 POINT(118.125 42.1875)
(1 row)