7.147 SDO_GEOR.setSpatialResolutions
Format
SDO_GEOR.setSpatialResolutions( georaster IN OUT SDO_GEORASTER, resolutions IN SDO_NUMBER_ARRAY);
Description
Sets the spatial resolution value along each spatial dimension of a GeoRaster object, or deletes the existing values if you specify a null resolutions
parameter.
Parameters
- georaster
-
GeoRaster object.
- resolutions
-
An array of numeric values, one for each spatial dimension. Each value indicates the number of units of measurement associated with the data area represented by that spatial dimension of a pixel. For example, if the spatial resolution values are (10,10) and the unit of measurement for the ground data is meters, each pixel represents an area of 10 meters by 10 meters.
Usage Notes
The GeoRaster object is automatically validated after the operation completes.
If resolutions is not null and if the GeoRaster metadata currently does not contain spatial reference information, this procedure adds spatial reference information with minimum default values.
See also the Usage Notes for the SDO_GEOR.getSpatialResolutions function.
Examples
The following example sets the spatial resolution values along the column and row (X and Y) dimensions of a GeoRaster object. (It refers to a table named GEORASTER_TABLE, whose definition is presented after Example 1-1 in Storage Parameters.)
DECLARE grobj sdo_georaster; BEGIN SELECT georaster INTO grobj FROM georaster_table WHERE georid=4 FOR UPDATE; sdo_geor.setSpatialResolutions(grobj, sdo_number_array(28.5,28.5)); UPDATE georaster_table SET georaster = grobj WHERE georid=4; COMMIT; END; /
Parent topic: SDO_GEOR Package Reference