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.075
Parent topic: SDO_GEOR Package Reference