Abstract
In this Chapter, we’ll look at various ways of combining spatial data. This could be, for example, collating a column of Points together into a single MultiPoint geometry (using UnionAggregate()) or joining two touching LineStrings together into a single LineString (using STUnion()). Combinations do not have to be additive; you can also, for example, subtract the area of space occupied by one Polygon from another, using STDifference(), or obtain the unique parts of two geometries using STSymDifference(). The common feature of all the methods discussed in this Chapter is that they take two or more inputs and combine them in some way to produce a single output.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2012 Alastair Aitchison
About this chapter
Cite this chapter
Aitchison, A. (2012). Aggregation and Combination. In: Pro Spatial with SQL Server 2012. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-3492-0_11
Download citation
DOI: https://doi.org/10.1007/978-1-4302-3492-0_11
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-3491-3
Online ISBN: 978-1-4302-3492-0
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books