ST_SetUpperLeft-AnalyticDB(AnalyticDB)-阿里云帮助中心

Sets the upper-left X and Y coordinates of a raster object in the spatial reference system.

Syntax

raster ST_SetUpperLeft(raster raster_obj, float8 upperleftX, float8 upperleftY)
raster ST_SetUpperLeft(raster raster_obj, float8 upperleftXY)

Parameters

Parameter	Description
`raster_obj`	The raster object.
`upperleftX`	The upper-left X coordinate of the raster object in the spatial reference system.
`upperleftY`	The upper-left Y coordinate of the raster object in the spatial reference system.
`upperleftXY`	The upper-left X and Y coordinates of the raster object in the spatial reference system. Both X and Y are set to this value.

Examples

Set the upper-left coordinates of a raster object to (120, 30) and verify the result:

UPDATE raster_table
SET rast = ST_SetUpperLeft(rast, 120, 30)
WHERE id = 2;

SELECT st_upperleftx(rast), st_upperlefty(rast)
FROM raster_table
WHERE id = 2;

Expected output:

 st_upperleftx | st_upperlefty
---------------+---------------
          120  |            30