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 if outResolutions 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) or NOTE (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.