Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

CollectionAggregate (geography Data Type)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Creates a GeometryCollection instance from a set of geography objects.

Applies to: SQL Server (SQL Server 2012 through current version), Azure SQL Database.

ConvexHullAggregate ( geography_operand )


Is a geography type table column that represents a set of geography objects to be listed in the GeometryCollection instance.

SQL Server return type: geography

Throws a FormatException when there are input values that are not valid. See STIsValid (geography Data Type)

Method returns null when the input is empty or the input has different SRIDs. See Spatial Reference Identifiers (SRIDs)

Method ignores null inputs.

Note Note

Method returns null if all inputted values are null.

The following example returns a GeometryCollection instance that contains a set of geography objects.

USE AdventureWorks2012


SELECT geography::CollectionAggregate(SpatialLocation).ToString() AS SpatialLocation

FROM Person.Address

WHERE City LIKE ('Bothell')

Community Additions

© 2015 Microsoft