ST_EndPoint takes a linestring column and returns a point column. The point column represents the last point of the input linestring.
| Function | Syntax | 
|---|---|
| Python | end | 
| SQL | ST | 
| Scala | end | 
For more details, go to the GeoAnalytics for Microsoft Fabric API reference for end_point.
This function implements the OpenGIS Simple Features Implementation Specification for SQL 1.2.1.
Examples
from geoanalytics_fabric.sql import functions as ST, Linestring
df = spark.createDataFrame([(Linestring([[[5,5],[7,6],[6,6],[4,2]]]),)], ["linestring"])
df.select(ST.end_point("linestring").alias("end_point")).show()Result
+-------------+
|    end_point|
+-------------+
|{"x":4,"y":2}|
+-------------+Version table
| Release | Notes | 
|---|---|
| 1.0.0-beta | Python, SQL, and Scala functions introduced |