ST_NumGeometries¶

Returns the number of geometries in a geometry collection.

Usage¶

integer ST_NumGeometries(geom: geometry)

Arguments¶

geom (geometry): Input geometry

Description¶

Returns the number of Geometries. If geometry is a GEOMETRYCOLLECTION (or MULTI*) return the number of geometries, for single geometries will return 1.

Examples¶

SELECT ST_NumGeometries(ST_GeomFromWKT('LINESTRING (-29 -27, -30 -29.7, -45 -33)'));

┌──────────────────────────────────────────────────────────────────────────────┐
│ st_numgeometries(st_geomfromwkt(Utf8("LINESTRING (-29 -27, -30 -29.7, -45 -3 │
│                                    3)")))…                                   │
╞══════════════════════════════════════════════════════════════════════════════╡
│                                                                            1 │
└──────────────────────────────────────────────────────────────────────────────┘