EnvelopeAggregate (geography Data Type)

 

Returns a bounding object for a given set of geography objects. The resulting geography object contains multiple circular arc segments.

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

geography_operand
Is a geography type table column that holds the set of geography objects on which to perform an envelope aggregate operation.

SQL Server return type: geography

A FullGlobe object is returned when the resulting bounding object is bigger than a hemisphere. This method is not precise.

Method returns null if the input has different SRIDs. See Spatial Reference Identifiers (SRIDs).

Method ignores null inputs.

System_CAPS_ICON_note.jpg Note


Method returns null if all inputted values are null.

The following example performs a EnvelopeAggregate on a set of geography location points within a city.

USE AdventureWorks2012

GO

SELECT City,

geography::EnvelopeAggregate(SpatialLocation) AS SpatialLocation

FROM Person.Address

WHERE PostalCode LIKE('981%')

GROUP BY City;

Extended Static Geography Methods

Community Additions

ADD
Show: