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).

Parameters

geom

Oracle Spatial geometry

geohash_length

Length of the geohash result.

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