35.37 SDO_UTIL.H3_CENTER

Format

SDO_UTIL.H3_CENTER(
  h3_key IN RAW,
  srid   IN NUMBER DEFAULT NULL
) RETURN MDSYS.SDO_GEOMETRY;

SDO_UTIL.H3_CENTER(
  h3_key IN RAW,
  x      OUT NUMBER,
  y      OUT NUMBER);

Description

Computes the center of the given H3 cell.

Parameters

h3_key

The H3 cell.

srid

Optional srid for the returned geometry. Must be a geodetic (longitude/latitude) coordinate system.

x

The longitude of the center of the given H3 cell.

y

The latitude of the center of the given H3 cell.

Usage Notes

None.

Examples

The following example computes the center of the coarsest (largest) cell containing the North Pole:

SELECT SDO_UTIL.H3_CENTER('08001FFFFFFFFFFF') FROM DUAL;
SDO_GEOMETRY(2001, 4326, SDO_POINT_TYPE(38.023407, 79.2423985, NULL), NULL, NULL)