ST_YMin¶

Returns the minimum Y coordinate (latitude for geography) of a geometry or geography’s bounding box.

Usage¶

double ST_YMin(geom: geometry)
double ST_YMin(geog: geography)

Arguments¶

geog (geography): Input geography
geom (geometry): Input geometry

Description¶

For geography, the minimum latitude is computed considering spherical geometry (e.g., the minimum latitude of a linestring that crosses the South Pole is -90).

Examples¶

SELECT ST_YMin(ST_GeomFromText('LINESTRING(0 0, 5 4)'));

┌────────────────────────────────────────────────────────┐
│ st_ymin(st_geomfromtext(Utf8("LINESTRING(0 0, 5 4)"))) │
│                         float64                        │
╞════════════════════════════════════════════════════════╡
│                                                    0.0 │
└────────────────────────────────────────────────────────┘

SELECT ST_YMin(ST_GeogFromText('LINESTRING(0 0, 5 4)'));

┌────────────────────────────────────────────────────────┐
│ st_ymin(st_geogfromtext(Utf8("LINESTRING(0 0, 5 4)"))) │
│                         float64                        │
╞════════════════════════════════════════════════════════╡
│                                -2.5444437451708134e-14 │
└────────────────────────────────────────────────────────┘