LineString Properties

Learn about LINESTRING properties in MariaDB Server. This section details SQL functions for retrieving attributes of linear spatial objects, such as length, number of points, and start/end points.

ENDPOINT

Synonym for ST_ENDPOINT. Returns the last point of a LineString geometry.

GLENGTH

Synonym for ST_LENGTH. Calculates the length of a LineString or MultiLineString in its associated spatial reference units.

NumPoints

Synonym for ST_NUMPOINTS. Returns the number of points in a LineString geometry.

PointN

Synonym for ST_POINTN. Returns the N-th point in a LineString geometry, where N is a 1-based index.

STARTPOINT

Synonym for ST_STARTPOINT. Returns the first point of a LineString geometry.

ST_ENDPOINT

Returns the end Point of a LineString. This function retrieves the final coordinate in the linear geometry sequence.

ST_NUMPOINTS

Returns the count of Points in a LineString. This function calculates the total number of vertices defining the line.

ST_POINTN

Returns the N-th Point in a LineString. This function retrieves a specific point from the sequence based on its 1-based index.

ST_STARTPOINT

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

_{This page is licensed: CC BY-SA / Gnu FDL}