snowflake.snowpark.functions.st_xmin¶

snowflake.snowpark.functions.st_xmin(geography_or_geometry_expression: Union[snowflake.snowpark.column.Column, str]) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.41.0/src/snowflake/snowpark/_functions/scalar_functions.py#L3518-L3542)¶

Returns the minimum X coordinate of a GEOGRAPHY or GEOMETRY object.

Parameters:

geography_or_geometry_expression (ColumnOrName) – A GEOGRAPHY or GEOMETRY object.

Returns:

The minimum X coordinate values.

Return type:

Column

Examples::

>>> from snowflake.snowpark.functions import to_geography
>>> df = session.create_dataframe([
...     ["POINT(-180 0)"],
...     ["POINT(180 0)"],
...     ["LINESTRING(-60 30, 60 30)"]
... ], schema=["geom"])
>>> df.select(st_xmin(to_geography(df["geom"])).alias("xmin")).collect()
[Row(XMIN=-180.0), Row(XMIN=-180.0), Row(XMIN=-60.00000000000002)]

Copy