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
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))
Parent topic: SDO_CS Package (Coordinate System Transformation)