snowflake.snowpark.functions.st_x¶

snowflake.snowpark.functions.st_x(geography_or_geometry_expression: Union[snowflake.snowpark.column.Column, str]) → Column[source]¶

Returns the X coordinate of a POINT geometry or geography object.

Parameters:

geography_or_geometry_expression (ColumnOrName) – A POINT geometry or geography objects.

Returns:

The X coordinate value as a numeric column.

Return type:

Column

Examples::
>>> from snowflake.snowpark.functions import col, lit, st_makepoint, to_geography
>>> from snowflake.snowpark.functions import st_makepoint, to_geography
>>> df = session.create_dataframe([[37.5, 45.5], [40.0, 60.0]], schema=["x", "y"])
>>> df.select(st_x(to_geography(st_makepoint(df["x"], df["y"]))).alias("x_coordinate")).collect()
[Row(X_COORDINATE=37.5), Row(X_COORDINATE=40.0)]
Copy
Language: English