January 2009
Intermediate to advanced
792 pages
23h 8m
English
Content preview from Mastering SQL Server® 2008Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Chapter 19
Using Spatial Data
One of the new features of SQL Server 2008 is the support for spatial data. This exciting feature gives you the ability to store data representing positions and geometric structures natively in SQL Server. This can provide significant opportunities for data mining based on previously difficult metrics such as location, distance, and space. With the prevalence of spatially oriented applications and devices in our society—from cartographic applications to global positioning system (GPS) appliances—being able to store spatial data natively in SQL Server can simplify the data services that these systems require.
SQL Server supports the current standards for spatial data storage and functionality; therefore, much of what ...