35.63 SDO_UTIL.LINEAR_KEY_BOUNDARY

Format

SDO_UTIL.LINEAR_KEY_BOUNDARY(
  linear_key IN RAW, 
  min_x      IN NUMBER DEFAULT 0.0, 
  min_y      IN NUMBER DEFAULT 0.0, 
  max_x      IN NUMBER DEFAULT 0.0, 
  max_y      IN NUMBER DEFAULT 0.0, 
  srid       IN NUMBER DEFAULT NULL 
) RETURN MDSYS.SDO_GEOMETRY;

Description

Returns the boundary of the tile represented by linear_key.

Parameters

linear_key

Linear (Hilbert) key for a geometry at the specified level.

min_x

Minimum value along the x-axis to consider in generating the key.

min_y

Minimum value along the y-axis to consider in generating the key.

max_x

Maximum value along the x-axis to consider in generating the key.

max_y

Maximum value along the y-axis to consider in generating the key.

srid

SRID value.

Usage Notes

The function returns the geometry of the cell represented by the linear key.

See Usage Notes in SDO_UTIL.LINEAR_KEY for more information.

Examples

The following example uses a lvl value of 17, and specifies substantial degree of parallel execution through the optimizer hint (/*+ append parallel(16) */). The obtained geometries are persisted in the results table.

ALTER SESSION ENABLE PARALLEL DML;
DROP TABLE results;
CREATE TABLE results (cnt NUMBER, cell_geometry SDO_GEOMETRY);
INSERT /*+ append parallel(16) */ INTO results NOLOGGING 
SELECT  count(*) cnt,
              sdo_util.linear_key_boundary (cell_id,-180,-180,180,180)
FROM (SELECT sdo_util.linear_key (geom, -180,-180,180,180,17) as cell_id
             FROM lon_lat_geoms)
GROUP BY cell_id;