In search for some knowledge about CircularString I stumble on the following content:
“A CIRCULARSTRING line is a sequence of an odd number of at least three points, which are connected to form a curved arc. For example, consider the following Transact-SQL:
DECLARE @g geography = ‘CIRCULARSTRING(-4.115 55.778, -3.399 56.990, -2.237 54.009)’
This creates a geography instance that represents a curved line like this:
Taken from: http://cm-bloggers.blogspot.com/2011/01/sql-server-denali-promising-earth.html
This technical article gives you the wrong idea.
Try the code in SQL Denali CTP3 and you’ll find the why:
DECLARE @g1 geography = ‘CIRCULARSTRING(-4.115 55.778, -3.399 56.990, -2.237 54.009)’
CircularString does not “form a curved arc”; CircularString creates a CIRCULAR ARC, meaning all three points required to define the string will be equidistant to the center of a circle.
Latest posts by Javier Loria (see all)
- Everything is not what it seems - July 19, 2011
- Empower your users with an OUTSTANDING Time Dimension - April 23, 2010
- Spatial data in SQL Server 2008 and SQL 2008 R2: A real world application - April 23, 2010