SDO_GEOR.generateAreaWeightedMean

Format

SDO_GEOR.generateAreaWeightedMean(
     georaster   IN SDO_GEORASTER, 
     window      IN SDO_GEOMETRY, 
     bandNumber  IN NUMBER, 
     nodata      IN VARCHAR2 DEFAULT 'FALSE' 
     ) RETURN NUMBER;

Description

Computes the area weighted statistical mean value on a specified band of the input GeoRaster object.

Parameters

georaster: GeoRaster object.
window: A polygon geometry object from which to generate statistics. If it is in the model space, it is transformed into raster space. See also the Usage Notes for the SDO_GEOR.generateStatisticsfunction for SDO_SRID requirements.
bandNumber: Band ordinate number of the layer for which to perform the operation.
nodata: Specifies whether or not to compare each cell values with NODATA values defined in the metadata when computing statistics. TRUE causes all pixels with a NODATA value not to be considered; FALSE (the default) causes pixels with NODATA values to be considered as regular pixels. NODATA values and value ranges are discussed in NODATA Values and Value Ranges.

Usage Notes

This function computes area weighted statistical mean value for the cells within a specific window of the input GeoRaster object. It uses the area of the cell as the weight for each cell value when computing the statistical mean value, so that all subcells cut by the window boundary are processed appropriately.

Examples

The following example computes area weighted statistical mean value for the first band of the input GeoRaster object.

SELECT sdo_geor.generateAreaWeightedMean(tmimage,sdo_geometry(2003,
          null,NULL,
          MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 3),
          MDSYS.SDO_ORDINATE_ARRAY(9.5,9.5,12.5,12.5)),0) 
     FROM landsat WHERE id=11;