6.12 Geohash Support

A geohash is a standard String encoding of a longitude/latitude point.

Some third-party software without advanced geospatial capabilities may be compatible with geohashes, since they support some types of simple, limited analysis of geographic data. For example, the approximate distance between objects can be guessed, based on the length of common prefix of the geohashes.

For more information about geohash, see https://en.wikipedia.org/wiki/Geohash.

To support geohashes, the SDO_GEOMETRY type cannot be used directly. Instead, you can use the SDO_CS package (documented in SDO_CS Package (Coordinate System Transformation) ) to convert between SDO_GEOMETRY and gaohash format, and to perform other geohash-related operations. That package contains the following subprograms related to geohash support: