![](http://3.bp.blogspot.com/_Ba76y6K7kvs/R5F1CAgzazI/AAAAAAAAANI/aSDw6qt4dtk/s320/STBuffer_Flat.png)
![](http://4.bp.blogspot.com/_Ba76y6K7kvs/R5F1CQgza0I/AAAAAAAAANQ/eNKHvwEeFN8/s320/STBuffer_Globe.png)
Using the 'special columns' feature of Geoquery (and a different map...)
DECLARE @g GEOGRAPHY
SET @g = geography::STGeomFromText('LINESTRING(33 -118, 40 -73)', 4326);
SELECT @g, 'Blue' AS [COLOR], 2 AS [Thickness]
UNION ALL SELECT @g.STBuffer(450000), 'Blue' as [COLOR], 1 AS [Thickness]
UNION ALL SELECT @g.STBuffer(1500000), 'Green' as [COLOR], 1 AS [Thickness]
UNION ALL SELECT @g.STBuffer(3000000), 'Purple' as [COLOR], 1 AS [Thickness]
UNION ALL SELECT @g.STBuffer(4000000), 'Orange' as [COLOR], 1 AS [Thickness]
![](http://3.bp.blogspot.com/_Ba76y6K7kvs/R5F7mAgza2I/AAAAAAAAANg/5KG7U1pz_Ww/s320/WorldBase3.png)
![](http://2.bp.blogspot.com/_Ba76y6K7kvs/R5F55wgza1I/AAAAAAAAANY/LWwhkiMX82k/s320/STBuffer_Globe2.png)
No comments:
Post a Comment
Note: only a member of this blog may post a comment.