35.38 SDO_UTIL.H3_BASE_CELL

Format

SDO_UTIL.H3_BASE_CELL(
  h3_key IN RAW
) RETURN NUMBER;

Description

Returns the H3 base cell (64-bit, 8 byte RAW) corresponding to the given H3 cell.

Parameters

h3_key

The given H3 cell.

Usage Notes

Note that a hexagon cannot be subdivided exactly into smaller hexagons. As a result, some cells are not entirely contained in their base cell.

Examples

The following example shows the base cell containing Paris:

SELECT SDO_UTIL.H3_BASE_CELL('0877AA5145FFFFFF') FROM DUAL;
SDO_UTIL.H3_BASE_CELL('0877AA5145FFFFFF')
-----------------------------------------
                                       61

The following example shows the base cell containing the North Pole:

SELECT SDO_UTIL.H3_BASE_CELL('08F0326233AB0399') FROM DUAL;
SDO_UTIL.H3_BASE_CELL('08F0326233AB0399')
-----------------------------------------
                                        1