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

Returns the upper-left Y coordinate of a raster object in the spatial reference system.

Prerequisites

The raster object must have a valid spatial reference system identifier (SRID).

float8 ST_UpperLeftY(raster raster_obj)

Parameter	Description
`raster_obj`	The name of the raster object.

The following query returns the upper-left X and Y coordinates for each raster in raster_table.

select st_upperleftx(rast), st_upperlefty(rast)
from raster_table;

Output:

 st_upperleftx | st_upperlefty
---------------+---------------
        440720 |       3751320