Skip to content
Apache Sedona 1.9.0 is out now, featuring Spark 4.1 support, proj4sedona CRS transformation, Bing Tile functions, and more!

ST_NPoints

Introduction: Returns the number of points (vertices) in a geography object.

ST_NPoints on a global polyline with 4 vertices

Format:

ST_NPoints (A: Geography)

Return type: Integer

Since: v1.9.1

SQL Example

SELECT ST_NPoints(ST_GeogFromWKT('LINESTRING (0 0, 1 1, 2 2)'));

Output:

3