SQLでGIS

• STBuffer

例）http://msdn.microsoft.com/ja-jp/magazine/dd434647.aspx

DECLARE @Seattle geography = 'POLYGON(....)';
SELECT c.customerid FROM customer c
  WHERE c.geog.STIntersects(@Seattle.STBuffer(10 * 1609.344));

• STUnion

• GeographyUnionAggregate

SQLSERVER2012から