Skip to content
πŸŽ‰ Apache Sedona 1.9.1 is out now! πŸ—ΊοΈ Geography SQL functions, Box2D & Box3D types, raster Python UDFs & more. Read the release notes β†’

ST_NPoints

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

ST_NPoints counts the vertices of a Geography

Format:

ST_NPoints (geog: Geography)

Return type: Integer

Since: v1.9.1

SQL Example:

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

Output:

3