buffer
どちらもバッファ結果。
近似円

DECLARE @g GEOGRAPHY;
SET @g = GEOGRAPHY::Point(35, 135, 4326);

SET @g = @g.STBuffer(1);
SELECT @g;

DECLARE @loop INT = @g.STNumPoints();

PRINT @loop

DECLARE @Counter INT = 0
WHILE @Counter < @loop
BEGIN
 DECLARE @pt GEOGRAPHY = @g.STPointN(@Counter + 1);
 PRINT @pt.ToString();

 SET @Counter = @Counter + 1

END


SET @g = GEOGRAPHY::Point(35, 135, 4326);
SET @g =@g.BufferWithTolerance(1, .5, 0)
SELECT @g;

SET @loop = @g.STNumPoints();

PRINT @loop

SET @Counter = 0
WHILE @Counter < @loop
BEGIN
 SET @pt = @g.STPointN(@Counter + 1);
 PRINT @pt.ToString();

 SET @Counter = @Counter + 1

END
カテゴリー: 開発 タグ: パーマリンク