O'Reilly logo

Programming Microsoft® SQL Server™ 2008 by Leonard Lobel, Andrew Brust, and Stephen Forte

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 9. Geospatial Data Types

Leonard Lobel

Geospatial support is a powerful new extension to the core database engine in Microsoft SQL Server 2008. Also referred to simply as spatial, this feature allows you to store and manipulate shapes, sizes, and locations using the new geometry and geography data types and to calculate areas, distances, and intersections over that spatial data. These capabilities enable location awareness for applications in which geographic data can be processed at the database level. In this chapter, we explore the concepts behind spatial data and how this new support in SQL Server 2008 can be used to integrate location intelligence into your database applications.

Note

We use the terms spatial and geospatial interchangeably ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required