sqlでgis
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から
sqlでgis.txt · 最終更新: 2019/06/30 12:22 by 127.0.0.1