7.90 SDO_GEOR.getSpectralResolution
Format
SDO_GEOR.getSpectralResolution( georaster IN SDO_GEORASTER ) RETURN NUMBER;
Description
Returns the spectral resolution of a GeoRaster object if it is a hyperspectral or multiband image.
Usage Notes
Taken together, the spectral unit and spectral resolution identify the wavelength interval for a band. For example, if the spectral resolution value is 2 and the spectral unit value is MILLIMETER, the wavelength interval for a band is 2 millimeters.
To set the spectral resolution for a GeoRaster object, use the SDO_GEOR.setSpectralResolution procedure.
Examples
The following example returns the spectral unit and spectral resolution for all spatially referenced GeoRaster objects (GEORASTER column) in the GEORASTER_TABLE table, whose definition is presented after Example 1-1 in Storage Parameters.
SELECT georid, substr(sdo_geor.getSpectralUnit(georaster),1,20) spectralUnit,
sdo_geor.getSpectralResolution(georaster) spectralResolution
FROM georaster_table
WHERE sdo_geor.isSpatialReferenced(georaster)='TRUE';
GEORID SPECTRALUNIT SPECTRALRESOLUTION
---------- -------------------- ------------------
4 MILLIMETER 0.075Parent topic: SDO_GEOR Package Reference