ST_STARTPOINT

Returns the start Point of a LineString. This function retrieves the initial coordinate in the linear geometry sequence.

Syntax

ST_StartPoint(ls)
StartPoint(ls)

Description

Returns the Point that is the start point of the LineString value ls.

ST_StartPoint() and StartPoint() are synonyms.

Examples

SET @ls = 'LineString(1 1,2 2,3 3)';

SELECT AsText(StartPoint(GeomFromText(@ls)));
+---------------------------------------+
| AsText(StartPoint(GeomFromText(@ls))) |
+---------------------------------------+
| POINT(1 1)                            |
+---------------------------------------+

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}