You are viewing documentation about an older version (1.42.0). View latest version

snowflake.snowpark.functions.st_endpoint¶

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

Returns the last point of a LINESTRING or MULTILINESTRING geometry or geography object.

Parameters:: geography_or_geometry_expression (ColumnOrName) – A column containing LINESTRING or MULTILINESTRING geometry or geography data
Returns:: A column containing the endpoint as a POINT geometry or geography object
Return type:: Column

Examples

>>> from snowflake.snowpark.functions import to_geography
>>> df = session.create_dataframe([['LINESTRING(1 1, 2 2, 3 3, 4 4)']], schema=["linestring"])
>>> df.select(st_endpoint(to_geography(df["linestring"])).alias("endpoint")).collect()
[Row(ENDPOINT='{\n  "coordinates": [\n    4.000000000000000e+00,\n    4.000000000000000e+00\n  ],\n  "type": "Point"\n}')]