ST_SetUpperLeft — Sets the value of the upper left corner of the pixel of the raster to projected X and Y coordinates.
raster
ST_SetUpperLeft
(
raster
rast
, double precision
x
, double precision
y
)
;
Set the value of the upper left corner of raster to the projected X and Y coordinates
SELECT ST_SetUpperLeft(rast,-71.01,42.37)
FROM dummy_rast
WHERE rid = 2;