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

Returns the minimum X-coordinate of a raster object's bounding box, optionally at a specified pyramid level.

Syntax

float8 ST_XMin(raster raster_obj)
float8 ST_XMin(raster raster_obj, integer pyramid)

Parameter	Description
`raster_obj`	The raster object.
`pyramid`	The pyramid level. Valid values start from 0.

ST_XMin returns 0 if the raster object has not been georeferenced.

Query the minimum X-coordinate of a raster column:

SELECT ST_XMin(rast)
FROM raster_table;

Result:

 st_xmin
----------
      120

Query the minimum X-coordinate at pyramid level 1:

SELECT ST_XMin(rast, 1)
FROM raster_table;