9.2 SDO_GEOR_AGGR.getMosaicExtent
Format
SDO_GEOR_AGGR.getMosaicExtent( inGeoRasters IN SYS_REFCURSOR, outSRID IN NUMBER DEFAULT NULL ) RETURN SDO_GEOMETRY;
or
SDO_GEOR_AGGR.getMosaicExtent( georasterTableNames IN VARCHAR2, georasterColumnNames IN VARCHAR2, outSRID IN NUMBER DEFAULT NULL ) RETURN SDO_GEOMETRY;
Description
Calculates and returns the minimum bounding rectangle (MBR) of the spatial extent of a virtual mosaic or a collection of GeoRaster objects.
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. If this parameter is null (the default), 4326 (EPSG SRID value for the WGS 84 (longitude/latitude) coordinate system) is used.
Usage Notes
In calculating the spatial extent of a virtual mosaic or a collection of GeoRaster objects, this function tries to use the spatialExtent
attribute of each GeoRaster object. If the spatialExtent
attribute is null, the extent of the GeoRaster object is calculated based on the object's metadata.
Examples
The following example shows how to get the spatial extent when the virtual mosaic or the collection of GeoRaster objects is a cursor.
declare cur sys_refcursor, begin open cur for select georaster from georaster_table_1 union all select georaster from georaster_table_2; extent := sdo_geor_aggr.getMosaicExtent(cur, 26986); close cur; end; /
The following example shows how to get the mosaic extent by specifying the table column names.
select sdo_geor_aggr.getMosaicExtent('georaster_table_1, georaster_table_2', 'georaster, georaster', 26986) from dual;
Parent topic: SDO_GEOR_AGGR Package Reference