Spatial Enhancements in SQL Server 2012
SQL Server 2012 adds many significant improvements to the spatial support that was first introduced with SQL Server 2008. In this section, we’ll explore some of these latest enhancements. Particularly notable is support for curves (arcs), whereas SQL Server 2008 only supported straight lines, or polygons composed of straight lines. As you’ll see, Microsoft also provides methods that test for non-2012-compatible (curved) shapes, and convert circular data to line data for backward compatibility with SQL Server 2008 (as well as other mapping platforms that don’t support curves).
New Spatial Data Classes
The three new shapes in SQL Server 2012 are circular strings, compound curves, and curve polygons. All three ...