7.81 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, thewindow
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 1-1 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; /
Parent topic: SDO_GEOR Package Reference