Query the upper-left X coordinate of a raster object with ST_UpperLeftX - PolarDB

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

Prerequisites

Before you begin, ensure that you have:

float8 ST_UpperLeftX(raster raster_obj)

Parameter	Description
`raster_obj`	The raster object to query.

Query the upper-left X and Y coordinates of all rasters in a table.

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

Expected output:

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