9.7 SDO_GEOR_AGGR.validateForMosaicSubset
Format
SDO_GEOR_AGGR.validateForMosaicSubset( inGeoRasters IN SYS_REFCURSOR, outSRID IN NUMBER, outResolutions IN SDO_NUMBER_ARRAY, resolutionUnit IN VARCHAR2, resultTableName IN VARCHAR2);
or
SDO_GEOR_AGGR.validateForMosaicSubset( georasterTableNames IN VARCHAR2, georasterColumnNames IN VARCHAR2, outSRID IN NUMBER, outResolutions IN SDO_NUMBER_ARRAY, resolutionUnit IN VARCHAR2, resultTableName IN VARCHAR2);
Description
Checks if it is feasible to do mosaicking or subset query operations over a virtual mosaic or a large collection of GeoRaster objects. Any validation errors and notes are stored in a user-created result table.
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
. - outSRID
-
Coordinate system for the output GeoRaster object. Must be either null or a value from the SRID column of the MDSYS.CS_SRS table.
- outResolutions
-
Resolution of the output GeoRaster data. If null, the default is the resolution of the first encountered source GeoRaster object.
- resolutionUnit
-
The unit of the
outResolutions
parameter. If null, the default is the unit of the output SRID. 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). This parameter is ignored ifoutResolutions
is null. - resultTableName
-
Name of the validation result table. This table must already exist, and it must have the following column definitions:
time timestamp, type varchar2(16), description varchar2(512), table_name varchar2(32), column_name varchar2(1024), rdt_table_name varchar2(32), raster_id number
Usage Notes
The following considerations apply to the resultTableName
parameter value:
-
If the specified table does not exist, an error is generated.
-
If the parameter is not specified or is specified as null, the procedure throws an error at the first validation error found; otherwise, the procedure puts all the validation errors in the table and completes without error.
-
If the specified table is not empty, the procedure appends rows to the existing data in the table; and if there is a unique constraint on any column and if the newly appended data has the same value as existing data in that constrained column, an error is generated.
-
The TYPE column of the table contains a string indicating the type of issue, such as
ERROR
(something that must be fixed) orNOTE
(information that may or may not require some action). The DESCRIPTION column provides details about the issue.
This procedure performs the following validation checks:
-
The source GeoRaster objects must have the same band dimension size.
-
The source GeoRaster objects must have consistent georeference status, that is, either all are georeferenced or all are not georeferenced.
-
If reprojection or rectification to be performed when doing the mosaic, the operation must be feasible.
Examples
The following example checks if a mosaic operation is possible. Any validation errors are stored in the predefined table MOSAIC_ERROR.
EXECUTE sdo_geor_aggr.validateForMosaicSubset('georaster_table_1, georaster_table_2', 'georaster, georaster', 26986, sdo_number_array(30, 30), 'unit=meter', 'mosaic_error'); -- Check the validation results: SELECT table_name table, column_name column, rdt_table_name rdt, raster_id rid, type, description FROM mosaic_error ORDER BY time; TABLE COLUMN RDT RID TYPE DESCRIPTION ---------- -------- ----- --- ----- --------------------------------------- GEORASTER_1 GEORASTER RDT_1 2 ERROR The source georaster object is not georeferenced.
Parent topic: SDO_GEOR_AGGR Package Reference