ST_UpperLeftX
更新时间：
复制 MD 格式
Returns the upper-left X coordinate of a raster object in its spatial reference system.
Prerequisites
The raster object must have a valid spatial reference system identifier (SRID).
Syntax
float8 ST_UpperLeftX(raster raster_obj)Parameters
| Parameter | Description |
|---|---|
raster_obj | The raster object to query. |
Return value
The upper-left X coordinate as a float8 value.
Examples
Query the upper-left X and Y coordinates of all raster objects in raster_table:
SELECT st_upperleftx(rast), st_upperlefty(rast)
FROM raster_table;Output:
st_upperleftx | st_upperlefty
---------------+---------------
440720 | 3751320该文章对您有帮助吗？