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_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