Table of Contents

Class SpatialEndPoint

Namespace
YndigoBlue.Velocity.Functions
Assembly
YndigoBlue.Velocity.dll

Represents the ST_EndPoint spatial accessor function that returns the last point of a linestring geometry.

public class SpatialEndPoint : Function, IElement, ICheckItem, IDefaultItem, IFilterItem
Inheritance
SpatialEndPoint
Implements

Remarks

Warning

Spatial functions are not available in the Community Edition of Velocity. They require the Full Edition.

The ST_EndPoint function returns a point geometry representing the last vertex of a linestring. For multi-linestrings or non-linestring geometries, behavior varies by database implementation (may return null or the endpoint of the last component). For Geometry types in planar coordinate systems, this is useful for analyzing line direction, connectivity analysis, network routing, or extracting terminal points from linear features. OGC-compliant.

SpatialEndPoint diagram showing last vertex extraction

Return Type: Point geometry.

Equivalent to: ST_PointN(line, ST_NumPoints(line))

InputST_EndPoint Result
Open LineStringLast vertex
Closed LineString (ring)Last vertex (= first vertex)
MultiLineStringEnd of first line only
Point, PolygonNULL

Constructors

SpatialEndPoint(Geometry)

Initializes a new instance of ST_EndPoint with a linestring geometry literal.

SpatialEndPoint(Column)

Initializes a new instance of ST_EndPoint with a linestring geometry column.

SpatialEndPoint(Function)

Initializes a new instance of ST_EndPoint for a function result.

SpatialEndPoint(Geography)

Initializes a new instance of ST_EndPoint with a linestring geography literal.