ST_EndPoint
Name
ST_EndPoint — Returns the last point of a LineString or CircularLineString.
Synopsis
geometry
ST_EndPoint
(
geometry
g
)
;
Description
Returns the last point of a
LINESTRING
or
CIRCULARLINESTRING
geometry
as a
POINT
.
Returns
NULL
if the input
is not a
LINESTRING
or
CIRCULARLINESTRING
.
This method implements the SQL/MM specification.
SQL-MM 3: 7.1.4
This function supports 3d and will not drop the z-index.
This method supports Circular Strings and Curves.
Examples
End point of a LineString
postgis=# SELECT ST_AsText(ST_EndPoint('LINESTRING(1 1, 2 2, 3 3)'::geometry)); st_astext ------------ POINT(3 3)
End point of a non-LineString is NULL
SELECT ST_EndPoint('POINT(1 1)'::geometry) IS NULL AS is_null; is_null ---------- t
End point of a 3D LineString
--3d endpoint SELECT ST_AsEWKT(ST_EndPoint('LINESTRING(1 1 2, 1 2 3, 0 0 5)')); st_asewkt -------------- POINT(0 0 5)
End point of a CircularString
SELECT ST_AsText(ST_EndPoint('CIRCULARSTRING(5 2,-3 1.999999, -2 1, -4 2, 6 3)'::geometry)); st_astext ------------ POINT(6 3)