List of aggregate methods

The following is a list of aggregate methods available for use with spatial data. An X in the Round-Earth column indicates that the method is also supported on round-Earth spatial reference systems. The SQL/MM column reflects compliance with the SQL/MM standard (ISO/IEC 13249-3: 2006).

Method	Type	Description	Round-Earth	SQL/MM
ST_AsSVGAggr method	ST_Geometry type	Returns a complete or partial SVG document which renders the geometries in a group.	X	Vendor extension
ST_ConvexHullAggr method	ST_Geometry type	Returns the convex hull for all of the geometries in a group		Vendor extension
ST_EnvelopeAggr method	ST_Geometry type	Returns the bounding rectangle for all of the geometries in a group		Vendor extension
ST_GeomCollectionAggr method	ST_GeomCollection type	Returns a geometry collection containing all of the geometries in a group.	X	Vendor extension
ST_IntersectionAggr method	ST_Geometry type	Returns the spatial intersection of all of the geometries in a group	X	Vendor extension
ST_LineStringAggr method	ST_LineString type	Returns a linestring built from the ordered points in a group.	X	Vendor extension
ST_MultiCurveAggr method	ST_MultiCurve type	Returns a multicurve containing all of the curves in a group.	X	Vendor extension
ST_MultiLineStringAggr method	ST_MultiLineString type	Returns a multilinestring containing all of the linestrings in a group.	X	Vendor extension
ST_MultiPointAggr method	ST_MultiPoint type	Returns a multipoint containing all of the points in a group.	X	Vendor extension
ST_MultiPolygonAggr method	ST_MultiPolygon type	Returns a multipolygon containing all of the polygons in a group.	X	Vendor extension
ST_MultiSurfaceAggr method	ST_MultiSurface type	Returns a multisurface containing all of the surfaces in a group.	X	Vendor extension
ST_UnionAggr method	ST_Geometry type	Returns the spatial union of all of the geometries in a group	X	Vendor extension

Discuss this page in DocCommentXchange.