22.31 SDO_CS.TO_GEOHASH
Format
SDO_CS.TO_GEOHASH( geom IN SDO_GEOMETRY, geohash_length IN NUMBER) RETURN VARCHAR2;
Description
Returns the geohash representation of a spatial geometry (type SDO_GEOMETRY).
Usage Notes
For information about geohash support in Oracle Spatial, see Geohash Support.
Examples
The following examples show the effect of the is_legacy
parameter value on the results. The first example returns the SRID values of all geodetic legacy coordinate reference systems that have the same WKT numeric values as the coordinate reference system with the SRID value of 8307.
SELECT sdo_cs.to_GeoHash(sdo_geometry(2001, 4326, sdo_point_type(10.40744, 57.64911, null), null, null), 11) FROM DUAL;from dual; u4pruydqqvj
Parent topic: SDO_CS Package (Coordinate System Transformation)