ST_Collect_Agg

Collects all geometries in a geometry column into a single multi-geometry (MultiPoint, MultiLineString, MultiPolygon, or GeometryCollection). Unlike ST_Union_Agg, this function does not dissolve boundaries between geometries - it simply collects them into a multi-geometry.

Signatures

ST_Collect_Agg (A: geometryColumn)

Parameters

geometryColumn

required

The input geometry.

Return type

The resulting geometry.

Examples

SELECT ST_Collect_Agg(geom) FROM (
  SELECT ST_GeomFromWKT('POINT(1 2)') AS geom
  UNION ALL
  SELECT ST_GeomFromWKT('POINT(3 4)') AS geom
  UNION ALL
  SELECT ST_GeomFromWKT('POINT(5 6)') AS geom
)

MULTIPOINT ((1 2), (3 4), (5 6))

with GROUP BY

SELECT category, ST_Collect_Agg(geom) FROM geometries GROUP BY category

ST_Analyze_Aggr

ST_Envelope_Agg

⌘I

Wherobots Cloud REST API

WherobotsDB

Vector tiles (PMTiles)

Havasu (Iceberg) table management

GeoStats and Map Matching

Rasterflow

Signatures

Parameters

Return type

Examples

with GROUP BY

​Signatures

​Parameters

​Return type

​Examples

​with GROUP BY

Signatures

Parameters

Return type

Examples

with GROUP BY