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.
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
Parent topic: SDO_CS Package (Coordinate System Transformation)