35.41 SDO_UTIL.H3_IS_CLASS3

Format

SDO_UTIL.H3_IS_CLASS3(
  resolution IN NUMBER
) RETURN BOOLEAN;

SDO_UTIL.H3_IS_CLASS3(
  h3_key IN RAW
) RETURN BOOLEAN;

Description

Returns a boolean value that determines if the given cells at the given resolution are “Class 3” in Uber’s H3 system.

Parameters

resolution

The H3 level to query.

h3_key

An H3 cell to query.

Usage Notes

The orientation of hexes are rotated by 30 degrees with respect to the layer one level coarser or finer, so all the even-numbered levels have their hexes oriented the same way, and all the odd-numbered levels have their hexes oriented the same way. “Class 3” is Uber’s name for the orientation of the odd-numbered levels.

Examples

The following example shows that the cells at level 7 are oriented to Class 3:

SELECT SDO_UTIL.H3_IS_CLASS3(7) FROM DUAL;
TRUE