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;