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

Returns the minimum Y-coordinate value of a raster object.

Syntax

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

Parameter	Description
`raster_obj`	The raster object to query.
`pyramid`	The pyramid level to query. Values start from 0.

If the raster object is georeferenced, the function returns its minimum Y-coordinate value.
If the raster object is not georeferenced, the function returns 0.

Query the minimum Y-coordinate value of the rast column in raster_table:

SELECT ST_YMin(rast)
FROM raster_table;

Output:

 st_ymin
----------
      30