Queries the upper-left X coordinate 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 assigned, run:
SELECT ST_SRID(raster_obj) FROM raster_table;If no SRID is assigned, call ST_SetSrid to configure one before calling this function.
Syntax
float8 ST_UpperLeftX(raster raster_obj)Parameters
| Parameter | Description |
|---|---|
| raster_obj | The raster object to query. |
Examples
SELECT st_upperleftx(raster_obj), st_upperlefty(raster_obj)
FROM raster_table;
st_upperleftx | st_upperlefty
---------------+---------------
440720 | 3751320