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 ...

Get Programming Microsoft® SQL Server® 2012 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.