7.107 SDO_GEOR.isSpatialReferenced
Format
SDO_GEOR.isSpatialReferenced( georaster IN SDO_GEORASTER ) RETURN VARCHAR2;
Description
Returns the string TRUE
if the GeoRaster object is spatially referenced, or FALSE
if the GeoRaster object is not spatially referenced.
Usage Notes
The GeoRaster object must have been validated.
Examples
The following example checks if the GeoRaster objects (GEORASTER column) in the GEORASTER_TABLE table are specified as spatially referenced, rectified, and orthorectified. (The GEORASTER_TABLE table definition is presented after Example 1-1 in Storage Parameters.)
SELECT georid, substr(sdo_geor.isSpatialReferenced(georaster),1,20) isSpatialReferenced, substr(sdo_geor.isRectified(georaster),1,20) isRectified, substr(sdo_geor.isOrthoRectified(georaster),1,20) isOrthoRectified FROM georaster_table; GEORID ISSPATIALREFERENCED ISRECTIFIED ISORTHORECTIFIED ---------- -------------------- -------------------- -------------------- 2 TRUE TRUE TRUE 4 TRUE TRUE FALSE
The following example searches for all empty and nongeoreferenced GeoRaster objects.
SELECT georid FROM georaster_table a WHERE sdo_geor.isSpatialReferenced(a.georaster) IS NULL OR sdo_geor.isSpatialReferenced(a.georaster) = 'FALSE';
Parent topic: SDO_GEOR Package Reference