22.17 SDO_CS.FROM_GEOHASH

Format

SDO_CS.FROM_GEOHASH(
     geohash IN VARCHAR2, 
     srid    IN NUMBER) RETURN SDO_GEOMETRY;

Description

Returns a spatial geometry (type SDO_GEOMETRY) representing a specified geohash.

Parameters

geohash

Geohash representation of a geometry.

srid

Coordinate system (spatial reference system) to be used in constructing the Oracle Spatial geometry.

Usage Notes

For information about geohash support in Oracle Spatial, see Geohash Support.

Examples

The following example “converts” a specified geohash value to a geometry of SRID 4326.

SELECT sdo_cs.from_GeoHash('u4pruydqqvj', 4326) FROM DUAL;

SDO_GEOMETRY(2002, 4326, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 3), SDO_ORDINATE_ARRAY(10.407439, 57.64911, 10.4074404, 57.6491113))