SDO_GEOR.getRasterBlocks

Format

SDO_GEOR.getRasterBlocks(
     georaster    IN SDO_GEORASTER,
     pyramidLevel IN NUMBER,
     window       IN SDO_NUMBER_ARRAY
     ) RETURN SDO_RASTERSET;

or

SDO_GEOR.getRasterBlocks(
     georaster    IN SDO_GEORASTER,
     pyramidLevel IN NUMBER,
     window       IN SDO_GEOMETRY
     ) RETURN SDO_RASTERSET;

Description

Returns an object of the SDO_RASTERSET collection type that identifies all blocks of a specified pyramid level that have any spatial interaction with a specified window.

Parameters

georaster

GeoRaster object.

pyramidLevel

Pyramid level from which to return the blocks that have any spatial interaction with the specified window.

window

Window from which to return the blocks that are in pyramidLevel. The data type can be SDO_NUMBER_ARRAY or SDO_GEOMETRY. If the data type is SDO_NUMBER_ARRAY, the parameter identifies the upper-left (row, column) and lower-right (row, column) coordinates of a rectangular window, and raster space is assumed. If the data type is SDO_GEOMETRY, see the Usage Notes for SDO_SRID requirements.

Usage Notes

The SDO_RASTERSET collection type is described in SDO_RASTERSET Collection Type.

If the window parameter data type is SDO_GEOMETRY, the SDO_SRID value must be one of the following:

• Null, to specify raster space

• A value from the SRID column of the MDSYS.CS_SRS table

  If the SDO_SRID values for the window parameter geometry and the model space are different, the window parameter geometry is automatically transformed to the coordinate system of the model space before the operation is performed. (Raster space and model space are explained in GeoRaster Data Model.)

Examples

The following example returns a collection set that identifies all raster blocks that have any spatial interaction with the specified window. (It refers to a table named GEORASTER_TABLE, whose definition is presented after Example: Using storageParam Keywords in Storage Parameters.)

DECLARE
  gr sdo_georaster;
  ds sdo_rasterset;
BEGIN
  SELECT georaster INTO gr FROM georaster_table WHERE georid=2;
  ds := sdo_geor.getRasterBlocks(gr, 0, sdo_number_array(11,65,192,244));
  COMMIT;
END;
/