7.42 SDO_GEOR.getBitmapMaskValues
Format
SDO_GEOR.getBitmapMaskValues( georaster IN SDO_GEORASTER, layerNumber IN NUMBER, pyramidLevel IN VARCHAR2, rowNumbers IN SDO_NUMBER_ARRAY, colNumbers IN SDO_NUMBER_ARRAY ) RETURN SDO_NUMBER_ARRAY;
or
SDO_GEOR.getBitmapMaskValues( georaster IN SDO_GEORASTER, layerNumber IN NUMBER, pyramidLevel IN VARCHAR2, ptGeom IN SDO_GEOMETRY ) RETURN SDO_NUMBER_ARRAY;
Description
Gets the values of multiple cells from a bitmap mask.
Parameters
- georaster
-
GeoRaster object.
- layerNumber
-
Number of the layer on which to perform the operation. A value of 0 (zero) indicates the object layer.
- pyramidLevel
-
Pyramid level containing the specified cell.
- rowNumbers
-
Numbers of the rows that contain the cells whose values are to be returned.
- colNumbers
-
Numbers of the columns that contain the cells whose values are to be returned.
- ptGeom
-
Multipoint geometry that identifies the cells whose values are to be returned.
Usage Notes
You can specify the cells by an array of row and column numbers or by a multipoint geometry object.
If there is no bitmap associated with the specified GeoRaster object at the specified raster layer, or the specified cell is in an empty raster block, the function returns a null value.
For an explanation of bitmap masks, see Bitmap Masks.
Examples
The following example gets the value of four cells from the bitmap mask associated with a specified GeoRaster object.
SELECT sdo_geor.getBitmapMaskValues(georaster,0,0,sdo_number_array(0,9,9,10),sdo_number_array(0,9,10,9)) FROM georaster_table WHERE georid=0;
Parent topic: SDO_GEOR Package Reference