ST_SetGeoreference syntax, parameters, and examples-ApsaraDB RDS(RDS)-阿里云帮助中心

This function sets the geographic reference information about a raster object.

Syntax

raster ST_SetGeoreference(raster rast, integer srid, integer aop, double A,double B, double C, double D, double E, double F);

Parameters

Parameter name	Description
rast	The raster object.
srid	The spatial reference identifier (SRID).
aop	The AOP is a spatial reference point at the center or upper-left corner of a pixel: Center = 1 Upleft = 2
A-F	The six parameters for an affine transformation: x = Acol + Brow + C y = Dcol + Erow + F

Description

If the raster object is stored in external mode, you need to ensure that the raster object is geographically referenced and the specified SRID can be found in the spatial_ref_sys table. Otherwise, the information about the raster object cannot be updated.

Examples

update rast set rast=ST_SetGeoreference(rast,4326,1,8.4163,0,124,0,-8.4163,36.2) where id=1;

__________________________________
(1 row)