7.91 SDO_GEOR.getSpectralUnit
Format
SDO_GEOR.getSpectralUnit( georaster IN SDO_GEORASTER ) RETURN VARCHAR2;
Description
Returns the unit of measurement for identifying the wavelength interval for a band.
Usage Notes
This function can return one of the following values: METER, MILLIMETER, MICROMETER, NANOMETER.
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 unit for a GeoRaster object, use the SDO_GEOR.setSpectralUnit 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