9.3 SDO_GEOR_AGGR.getMosaicResolutions
Format
SDO_GEOR_AGGR.getMosaicResolutions( inGeoRasters IN SYS_REFCURSOR, resolutionUnit IN VARCHAR2 DEFAULT NULL ) RETURN SDO_RANGE_ARRAY;;
or
SDO_GEOR_AGGR.getMosaicResolutions( georasterTableNames IN VARCHAR2, georasterColumnNames IN VARCHAR2, resolutionUnit IN VARCHAR2 DEFAULT NULL ) RETURN SDO_RANGE_ARRAY;
Description
Returns the resolution range of a virtual mosaic or a collection of GeoRaster objects in a specified unit.
Parameters
- inGeoRasters
-
Source GeoRaster objects in a cursor.
- georasterTableNames
-
Names (comma-separated) of the tables containing the source GeoRaster objects.
- georasterColumnNames
-
Names (comma-separated) of the columns of type SDO_GEORASTER in tables corresponding to the table names in
georasterTableNames
. - resolutionUnit
-
Unit of measure for the returned resolution range. If specified, it must be a quoted string in the format
'unit=
value
'
where value is the unit name value (a valid UNIT_OF_MEAS_NAME value from the SDO_UNITS_OF_MEASURE table). If not specified or null, the returned resolution range is in the unit ofmeter
.
Usage Notes
The returned resolution range is in the format of SDO_RANGE_ARRAY(SDO_RANGE(min_x
, max_x
), SDO_RANGE(min_y
, max_y
)). where min_x
, max_x
are the minimum and maximum resolution on the x dimension, and min_y
, max_y
are the minimum and maximum resolution on the y dimension.
The SDO_RANGE_ARRAY type is defined as VARRAY(1048576) OF SDO_RANGE
. The SDO_RANGE type is defined as:
Name Null? Type ----------------------------------------- -------- ------- LB NUMBER UB NUMBER
Examples
The following example gets the spatial resolution of a virtual mosaic or a collection of GeoRaster objects with the returned values in meters.
SELECT sdo_geor_aggr.getMosaicResolutions('georatser_table_1, georaster_table_2', 'georaster, georaster', 'unit=meter') FROM DUAL;
Parent topic: SDO_GEOR_AGGR Package Reference