st_ymin function

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 17.1 and above check marked yes Lakehouse//RT

Note

This feature is not available on Databricks SQL Classic warehouses. To learn more about Databricks SQL warehouses, see SQL warehouse types.

Returns the minimum Y coordinate of the input GEOMETRY value, or NULL if the geometry is empty.

Syntax

st_ymin ( geoExpr )

Arguments

  • geoExpr: A GEOMETRY value.

Returns

A value of type DOUBLE, equal to the minimum Y coordinate of the input GEOMETRY value.

The function returns NULL if the input is NULL or if the geometry is empty.

Examples

-- Returns the minimum Y coordinate of a non-empty geometry.
> SELECT st_ymin(st_geomfromtext('LINESTRING(10 34,44 57,30 24)'));
  24.0
-- Returns `NULL` for an empty geometry.
> SELECT st_ymin(st_geomfromtext('POLYGON EMPTY'));
  NULL