7.93 SDO_GEOR.getStatistics
Format
SDO_GEOR.getStatistics( georaster IN SDO_GEORASTER, layerNumber IN NUMBER ) RETURN SDO_NUMBER_ARRAY;
Description
Returns statistical data associated with a layer.
Parameters
Usage Notes
This function returns statistical data described by the <statisticDatasetType>
element in the GeoRaster metadata XML schema, which is described in GeoRaster Metadata XML Schema. The function returns an array with the following values: MIN
, MAX
, MEAN
, MEDIAN
, MODEVALUE
, and STD
.
To set the statistical data associated with a layer, use the SDO_GEOR.setStatistics procedure.
Examples
The following example returns statistical data for layer 1 of a GeoRaster object. (It refers to a table named GEORASTER_TABLE, whose definition is presented after Example 1-1 in Storage Parameters.)
SELECT sdo_geor.getStatistics(georaster, 1) layer1 FROM georaster_table WHERE georid=4; LAYER1 -------------------------------------------------------------------------------- SDO_NUMBER_ARRAY(0, 255, 100, 127, 95, 25)
Parent topic: SDO_GEOR Package Reference