×

Uh-oh, it looks like your Internet Explorer is out of date.

For a better shopping experience, please upgrade now.

Beginning Spatial with SQL Server 2008 / Edition 1
     

Beginning Spatial with SQL Server 2008 / Edition 1

5.0 1
by Alastair Aitchison
 

ISBN-10: 1430218290

ISBN-13: 9781430218296

Pub. Date: 01/19/2009

Publisher: Apress

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

Overview

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.

Product Details

ISBN-13:
9781430218296
Publisher:
Apress
Publication date:
01/19/2009
Edition description:
2009
Pages:
456
Product dimensions:
6.90(w) x 9.20(h) x 1.00(d)

Table of Contents

A table of contents is not available for this title.

Customer Reviews

Average Review:

Post to your social network

     

Most Helpful Customer Reviews

See all customer reviews

Beginning Spatial with SQL Server 2008 5 out of 5 based on 0 ratings. 1 reviews.
Dustin-Davis More than 1 year ago
I picked up this book because I was doing a project for work that uses geocoding, maps and using some of the SQL 2008 spatial features such as selecting records with geo coordinates with in the bounds of a defined polygon. Of course at the time I didn't know anything about the way SQL spatial features worked so I had a lot of trial and error. Had I read just the first 2 chapters of this book back then, I would have saved so much time. The first two chapters covers everything you need to know about geo spatial. Most interesting was the coverage of elipsoids and geoids that model the unique shape of the earth (no, it isnt round). I skipped ahead a few times to look at chapters covering geocoding. Unfortuneatley, SQL does not geo code, but the chapter does cover how to write your own .NET CLR function to provide geocoding. Seems like it should have been part of SQL server, but oh well. The book goes into great detail about each sub topic and the coverage is excellent. It does get into some .NET development, but not to the point that non developers wouldnt be able to handle it. I recommend this book because it just works. It's an easy and interesting read. I truely thought it would be dry but it isnt.