Beginning Spatial with SQL Server 2008

Front Cover
Apress, Jan 20, 2009 - Computers - 456 pages
4 Reviews

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. What you’ll learn Understand the fundamental concepts involved in working with spatial data, including spatial references and coordinate systems. Apply these concepts in the collection and storage of spatial data in SQL Server 2008, using the new geometry and geography field types. Create different types of spatial data objects—points, lines, and polygons—and use these to describe real–world objects. Learn how to analyze spatial data using a range of supported methods, and be aware of a number of different practical applications for these methods. Be shown how to integrate SQL Server with other tools, such as Microsoft Virtual Earth, to display a visual representation of spatial data. Know how to ensure the performance of spatially enabled databases by creating appropriate spatial indexes. Who this book is for

SQL Server developers who wish to use spatial data in Microsoft SQL Server 2008.

 

What people are saying - Write a review

User Review - Flag as inappropriate

A great book! Well written with lots of examples.

User Review - Flag as inappropriate

I'm disappointed to see that he doesn't bother dealing with the possibility of user input beyond qualifying what read-only dataset is of interest. Since I'm writing a two-way web application, that's a significant shortcoming.
It also took a bit of doing to figure out that his GoogleMaps target was API v2, and further disappointment that the book site neither makes that version evident, nor offers any hint of an update. The book is useful, but overpriced, given its lack of durability.
 

Contents

Defining Spatial Information
3
Implementing Spatial Data in SQL Server 2008
33
Working with Spatial Data in the NET Framework
55
Creating Spatial Data Objects
77
Marking Out Geometries Using Virtual Earth
115
Importing Spatial Data
137
Geocoding
157
Syndicating Spatial Data
181
Presenting Spatial Data Using Web Mapping Services
207
Visualizing Query Results in Management Studio
249
Examining Properties of Spatial Objects
261
Modifying Spatial Objects
315
Testing Spatial Relationships
345
Indexing
379
Index
403
Copyright

Other editions - View all

Common terms and phrases

About the author (2009)

Alastair Aitchison has more than eight years of experience as a management information consultant, specializing in the design and deployment of online reporting systems. For the last three years, he has been employed as a reporting and analysis manager at Aviva, the world's fifth largest insurance group. In this role, he has championed the use of spatial data in corporate applications including the geographic analysis of risk patterns, plotting the success of regional marketing campaigns, and understanding the impact of major weather incidents. Alastair is a Microsoft Office Specialist Master Instructor and has delivered numerous training courses to individuals and small groups on a range of software packages.

Bibliographic information