7.63 SDO_GEOR.getGeoreferenceType
Format
SDO_GEOR.getGeoreferenceType( georaster IN SDO_GEORASTER ) RETURN NUMBER;
Description
Returns a number that indicates the georeference type for a GeoRaster object.
Usage Notes
This function returns one of the following numbers to indicate the georeference type: 1 for unknown type or null GeoRaster object, 2 for affine transform, 3 for direct linear transform (DLT), 4 for rational polynomial coefficient (RPC), 5 for cubic polynomial, 6 for quadratic rational polynomial, or 7 for quadratic polynomial.
For an explanation of georeferencing, see Georeferencing.
Examples
The following example returns the georeference type for the GeoRaster objects in a table named GEORASTER_TABLE. (It refers to a table named GEORASTER_TABLE, whose definition is presented after Example 1-1 in Storage Parameters.)
SELECT georid,sdo_geor.getGeoreferenceType(a.georaster) FROM georaster_table a ORDER BY georid; GEORID SDO_GEOR.GETGEOREFERENCETYPE(A.GEORASTER) ---------- ----------------------------------------- 1 1 2 1 3 1 4 1 5 1 7 1 8 2 9 1 10 1 12 1 13 1 14 2 15 1 16 1 17 1 18 1 19 2 20 2 21 4 22 4
Parent topic: SDO_GEOR Package Reference