22.22 SDO_CS.GET_GEOHASH_CELL_HEIGHT

Format

SDO_CS.GET_GEOHASH_CELL_HEIGHT(
     geohash_length  IN NUMBER) RETURN SDO_NUMBER;

Description

Returns the cell height of a specified geohash.

Parameters

geohash_length

Length of the geohash.

Usage Notes

Depending on its length, a geohash can vary in its accuracy. A longer geohash defines a smaller (more accurate) coordinate cell. You can return the cell width and height in meters (assuming WGS84).

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

Examples

The following example returns the cell height in meters if the geohash length is 11..

SELECT sdo_cs.get_GeoHash_cell_height(11) FROM DUAL;

                        .149