SDO_UTIL.H3_HEXRING

Format

SDO_UTIL.H3_HEXRING(
      h3_key IN RAW,
      k      IN NUMBER
) RETURN SYS.ODCIRAWLIST;

Description

Produces a hollow ring of cells that are exactly grid distance k from the origin cell.

Parameters

h3_key

The origin H3 cell.

k

The grid distance from the origin cell.

Usage Notes

This function can be queried with the TABLE operator and the result is a collection of H3 identifiers, each returned as a RAW value.

Examples

The following example returns the cells that are exactly grid distance 3 from the specified origin cell:

SELECT *
FROM TABLE(SDO_UTIL.H3_HEXRING('085283473FFFFFFF', 3));