Search Results sdo_georaster




Overview
Explore in AI Chat

Overview

MDSYS.SDO_GEOR_AGGR is an Oracle Spatial and Graph package responsible for the aggregation of raster data stored in the SDO_GEORASTER object type. Within the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, this package supports applications that rely on geospatial raster imagery, such as Oracle Field Service, Oracle Utilities, and custom GIS-enabled modules that persist raster data as SDO_GEORASTER objects. The package exists in the MDSYS schema, is classified under the ETRM as an OTHER API, and carries a VALID status in the documented 12.2.2 metadata.

The primary business function of SDO_GEOR_AGGR is to mosaic — that is, to merge and assemble multiple GeoRaster objects or subsets of GeoRaster objects into a single, seamless raster. This is essential for workflows such as building large aerial or satellite image coverages, tiling, and maintaining up-to-date image repositories used by operations, dispatch, and asset visualization processes.

Key Procedures and Functions

The ETRM metadata documents eleven procedures and functions within this package. The principal entries include the following:

  • MOSAICSUBSET — Performs the core mosaic operation, aggregating a set of GeoRaster subsets into a resulting GeoRaster object according to specified parameters.
  • GETMOSAICSUBSET — Produces a mosaic result as a subset, typically returning the aggregated raster or a reference to it without persisting the full mosaic.
  • VALIDATEFORMOSAICSUBSET — Validates that the input GeoRaster objects and parameters are suitable for a subsequent mosaic subset operation.
  • GETMOSAICEXTENT — Returns the spatial extent (footprint) that the mosaic of the supplied GeoRaster objects would cover.
  • GETMOSAICRESOLUTIONS — Returns the resolutions available for the mosaic operation based on the constituent GeoRaster objects.
  • APPEND — Appends GeoRaster data to an existing mosaic, supporting incremental aggregation of raster content.

These procedures allow developers to build, validate, and query mosaic results without manually managing raster geometry.

Tables Accessed

The package references several supporting objects through APPS synonyms and MDSYS dependencies. Documented references include DBMS_LOB, DUAL, and PLITBLM, along with spatial types SDO_GEOMETRY, SDO_GEORASTER, SDO_NUMBER_ARRAY, and SDO_RANGE_ARRAY. DBMS_LOB is used for large object manipulation of the raster blocks, while DUAL supplies standard single-row query behavior for utility calls. The actual raster data resides in application tables that store SDO_GEORASTER columns; the package operates on those columns rather than on dedicated metadata tables. No application tables are directly listed in the ETRM excerpt, reflecting the package's role as a utility API rather than a table-bound business process owner.

Usage Notes

SDO_GEOR_AGGR is not exposed through a standard EBS form or concurrent program. It is invoked from custom PL/SQL, database triggers, or concurrent programs that perform batch raster processing. Typical invocation patterns include scheduling a concurrent program to mosaic newly loaded satellite imagery, or calling GETMOSAICEXTENT and GETMOSAICRESOLUTIONS to determine coverage before committing to an expensive mosaic operation. The ETRM notes that the package is referenced by no other packages, confirming that it is a leaf-level API intended to be called directly by application code.

Because the package is owned by MDSYS, appropriate EXECUTE privileges must be granted to the APPS schema. In 12.1.1 and 12.2.2, teams should verify interoperability with the installed Oracle Spatial version, as the availability of individual procedures may vary with the database release. Validation via VALIDATEFORMOSAICSUBSET before executing MOSAICSUBSET or APPEND is a recommended practice.