Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply for awareness. You can then go away and research the area and report back to me, we’ll then discuss how these new features can benefit us all.
Friday 21st May 2010
Spatial Data Types
SQL Server 2008 now allows you to build spatial capabilities into your applications.
In brief, there are two new data types.
Geography – allows you to implement Round Earth solutions using latitude and longitude coordinates to define areas on the Earth’s surface.
Geometry – allows you to implement Flat Earth solutions. We can now store polygons, points, and lines that are associated with projected planar surfaces and naturally planar data, such as interior spaces.