Beginning Spatial with SQL Server 2008 by Alastair Aitchison (English) Paperback

Publisher Description

Microsoft SQL Server 2008 introduces new geography and geometry spatial datatypes that enable the storage of structured data describing the shape and position of objects in space. This is an interesting and exciting new feature, with many potentially useful applications.Beginning Spatial with SQL Server 2008 covers everything you need to know to begin using these new spatial datatypes, and explains how to apply them in practical situations involving the spatial relationships of people, places, and things on the earth.

• All of the spatial concepts introduced are explained from the ground up, so you need not have any previous knowledge of working with spatial data.
• Every section is illustrated with code examples that you can use directly in SQL Server.
• All of the topics covered in this book apply to all versions of SQL Server 2008, including the freely available SQL Server 2008 Express.

Notes

Grabs reader's attention with compelling, visual examples involving Virtual Earth and Microsoft MapPoint

Covers the ground from concept to implementation through to troubleshooting performance problems

Written by a Microsoft Master Instructor with three years of experience in location-based reporting and geographic analysis

Table of Contents

Working with Spatial Data.- Defining Spatial Information.- Implementing Spatial Data in SQL Server 2008.- Working with Spatial Data in the .NET Framework.- Adding Spatial Data.- Creating Spatial Data Objects.- Marking Out Geometries Using Virtual Earth.- Importing Spatial Data.- Geocoding.- Presenting Spatial Data.- Syndicating Spatial Data.- Presenting Spatial Data Using Web Mapping Services.- Visualizing Query Results in Management Studio.- Analyzing Spatial Data.- Examining Properties of Spatial Objects.- Modifying Spatial Objects.- Testing Spatial Relationships.- Ensuring Spatial Performance.- Indexing.

Long Description

Microsoft SQL Server 2008 introduces new geography and geometry spatial datatypes that enable the storage of structured data describing the shape and position of objects in space. This is an interesting and exciting new feature, with many potentially useful applications. Beginning Spatial with SQL Server 2008 covers everything you need to know to begin using these new spatial datatypes, and explains how to apply them in practical situations involving the spatial relationships of people, places, and things on the earth. All of the spatial concepts introduced are explained from the ground up, so you need not have any previous knowledge of working with spatial data. Every section is illustrated with code examples that you can use directly in SQL Server. All of the topics covered in this book apply to all versions of SQL Server 2008, including the freely available SQL Server 2008 Express.

Feature

Grabs reader's attention with compelling, visual examples involving Virtual Earth and Microsoft MapPoint Covers the ground from concept to implementation through to troubleshooting performance problems Written by a Microsoft Master Instructor with three years of experience in location-based reporting and geographic analysis

Details