Skip to main content
Aggregate Function: Collect all geometries into a multi-geometry. Unlike ST_Union_Aggr, this function does not dissolve boundaries between geometries. It simply collects all geometries into a MultiPoint, MultiLineString, MultiPolygon, or GeometryCollection based on the input geometry types. SQL reference: ST_Collect_Agg

Signature

Parameters

ColumnOrName
required
Geometry column to aggregate.

Returns

Column
Multi-geometry representing the collection of all geometries in the column.