SDO_UTIL.H3_UNCOMPACT_CELLS

Format

SDO_UTIL.H3_UNCOMPACT_CELLS(
      compacted_set  IN SYS.ODCIRAWLIST,
      resolution     IN NUMBER
) RETURN SYS.ODCIRAWLIST;

Description

Uncompacts a collection of H3 cells to the specified resolution.

Parameters

compacted_set

The collection of compacted H3 cells to expand.

resolution

The resolution to which the cells are expanded.

Usage Notes

This function can be queried with the TABLE operator. The result is a collection of returned cells, which can be substantially larger than the number of input cells.

Examples

The following example uncompacts two H3 cells to resolution 10:

SELECT *
FROM TABLE(SDO_UTIL.H3_UNCOMPACT_CELLS(
  SYS.ODCIRAWLIST(
    '0892A1072377FFFF',
    '08A2A1072339FFFF'
  ),
  10
));