7.138 SDO_GEOR.setModelCoordLocation

Format

SDO_GEOR.setModelCoordLocation(
     georaster      IN OUT SDO_GEORASTER 
     modelCoordLoc  IN VARCHAR2);

Description

Sets the model coordinate location value for a GeoRaster object, or deletes the current model coordinate location value (if any) if the modelCoordLoc parameter is specified as null.

Parameters

georaster

GeoRaster object.

modelCoordLoc

Model coordinate location to set for the GeoRaster object. It must be specified as either null (to delete any current model coordinate location value) or one of the following string values: CENTER (the cell coordinate system is center-based) or UPPERLEFT (the cell coordinate system is based on the upper-left corner).

Usage Notes

This procedure enables you to change the cell coordinate system from CENTER to UPPERLEFT or from UPPERLEFT to CENTER.

This procedure applies only to georeferenced GeoRaster objects, and it automatically adjusts the functional fitting coefficients of the GeoRaster SRS accordingly to reflect the change (to ensure that the relationship between cell coordinates and model coordinates does not change).

To get the model coordinate location value for a GeoRaster object, use the SDO_GEOR.getModelCoordLocation function.

For an explanation of georeferencing using GCPs, see Ground Control Point (GCP) Georeferencing Model.

Examples

The following example changes the cell coordinate system to CENTER for a GeoRaster object.

DECLARE
  grobj sdo_georaster;
BEGIN
  SELECT georaster INTO grobj FROM georaster_table WHERE georid=4 FOR UPDATE;
  sdo_geor.setModelCoordLocation(grobj, 'CENTER');
  UPDATE georaster_table SET georaster = grobj WHERE georid=4;
  COMMIT;
END;
/