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