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.
Synonym for ST_ENDPOINT. Returns the last point of a LineString geometry.
Synonym for ST_LENGTH. Calculates the length of a LineString or MultiLineString in its associated spatial reference units.
Synonym for ST_NUMPOINTS. Returns the number of points in a LineString geometry.
Synonym for ST_POINTN. Returns the N-th point in a LineString geometry, where N is a 1-based index.
Synonym for ST_STARTPOINT. Returns the first point of a LineString geometry.
Returns the end Point of a LineString. This function retrieves the final coordinate in the linear geometry sequence.
Returns the count of Points in a LineString. This function calculates the total number of vertices defining the line.
Returns the N-th Point in a LineString. This function retrieves a specific point from the sequence based on its 1-based index.
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
Last updated
Was this helpful?

