35.38 SDO_UTIL.H3_HEX_AREA

Format

SDO_UTIL.H3_HEX_AREA(
  resolution IN NUMBER,
  unit       IN VARCHAR2 DEFAULT 'SQ_KM',
  measure    IN VARCHAR2 DEFAULT 'AVERAGE'
) RETURN NUMBER;

Description

Returns the minimum (‘MIN’), maximum (‘MAX’), or average (‘AVG’) area of hexes for the given H3 level.

Parameters

resolution

The H3 level to query.

unit

The unit of area measurement to use (see Table 6-26).

measure

One of the following supported values: MIN, MAX, AVG, or AVERAGE.

Usage Notes

Note that the pentagons have their own statistics. If you want the area of a specific cell, rather than values for the entire level, use SDO_GEOM.SDO_AREA(SDO_UTIL.H3_BOUNDARY(h3_key),0.00001).

Examples

The following example shows the area of the largest H3 cell (largest level-0 cell):

SELECT SDO_UTIL.H3_HEX_AREA(0, 'SQ_MILE', 'MAX') FROM DUAL;
1937932.68