> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/linestring-properties.md).

# LineString Properties

{% columns %}
{% column %}
{% content-ref url="/pages/9FOWNOsqyeifbLTuOKwh" %}
[ENDPOINT](/docs/server/reference/sql-statements/geometry-constructors/linestring-properties/linestring-properties-endpoint.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Synonym for ST\_ENDPOINT. Returns the last point of a LineString geometry.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/yKUUWKXXuQ1DzEBvINVz" %}
[GLENGTH](/docs/server/reference/sql-statements/geometry-constructors/linestring-properties/glength.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Synonym for ST\_LENGTH. Calculates the length of a LineString or MultiLineString in its associated spatial reference units.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/aNyHbrqJIKeOGAIYsN2e" %}
[NumPoints](/docs/server/reference/sql-statements/geometry-constructors/linestring-properties/linestring-properties-numpoints.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Synonym for ST\_NUMPOINTS. Returns the number of points in a LineString geometry.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/VZt8OqxgFsmXbVVIjiyc" %}
[PointN](/docs/server/reference/sql-statements/geometry-constructors/linestring-properties/linestring-properties-pointn.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Synonym for ST\_POINTN. Returns the N-th point in a LineString geometry, where N is a 1-based index.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/YIqlR952XhTmmkicGumt" %}
[STARTPOINT](/docs/server/reference/sql-statements/geometry-constructors/linestring-properties/linestring-properties-startpoint.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Synonym for ST\_STARTPOINT. Returns the first point of a LineString geometry.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/rmNAUHr1UxEvvxaV9OLu" %}
[ST\_ENDPOINT](/docs/server/reference/sql-statements/geometry-constructors/linestring-properties/st_endpoint.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Returns the end Point of a LineString. This function retrieves the final coordinate in the linear geometry sequence.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/24d4aLlNJPl5AhHBP2b1" %}
[ST\_NUMPOINTS](/docs/server/reference/sql-statements/geometry-constructors/linestring-properties/st_numpoints.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Returns the count of Points in a LineString. This function calculates the total number of vertices defining the line.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/Nn5bip1EWZ9gEarStf6d" %}
[ST\_POINTN](/docs/server/reference/sql-statements/geometry-constructors/linestring-properties/st_pointn.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Returns the N-th Point in a LineString. This function retrieves a specific point from the sequence based on its 1-based index.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/B4Fge69rvW7ME2toVSqn" %}
[ST\_STARTPOINT](/docs/server/reference/sql-statements/geometry-constructors/linestring-properties/st_startpoint.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Returns the start Point of a LineString. This function retrieves the initial coordinate in the linear geometry sequence.
{% endcolumn %}
{% endcolumns %}