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_NumGeometries

Introduction: Return the number of sub-geometries in a geography (1 for single geometries).

Format:

ST_NumGeometries (geog: Geography)

Return type: Integer

Since: v1.9.1

SQL Example:

SELECT ST_NumGeometries(ST_GeogFromWKT('MULTIPOINT ((0 0), (1 1))', 4326))

Output:

2