Query the upper-left Y coordinate of a raster object using ST_UpperLeftY - ApsaraDB RDS

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

Prerequisites

The raster object must have a spatial reference system identifier (SRID). To check whether an SRID is set, run:

SELECT ST_SRID(raster_obj) FROM raster_table;

If no SRID is set, call ST_SetSrid to assign one before calling this function.

float8 ST_UpperLeftY(raster raster_obj)

Parameter	Description
`raster_obj`	The raster object to query.

Query both the upper-left X and Y coordinates of raster objects:

SELECT st_upperleftx(raster_obj), st_upperlefty(raster_obj)
FROM raster_table;

Output:

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