ST_ConvexHullAggr( ST_Geometry ) method

Syntax

ST_Geometry::ST_ConvexHullAggr( ST_Geometry geometry_column)

Parameters

• geometry_column – The geometry values to generate the convex hull. Typically this is a column.

Returns

ST_Geometry Returns the convex hull for all the geometries in a group.

Examples

• Example 1 – The following example returns the result Polygon ((3 0, 7 2, 3 6, 0 7, -3 6, -3 3, 0 0, 3 0)).

  SELECT ST_Geometry::ST_ConvexHullAggr( Shape )
  FROM SpatialShapes WHERE ShapeID <= 16

Standards

SQL/MM (ISO/IEC 13249-3: 2006) Vendor extension