In a shameless bit of self-promotion, I’d like to call attention to the new book, Inside Microsoft SQL Server 2008: T-SQL Programming (Microsoft Press).

You can get further information on the book at Itzik’s blog or by going to Microsoft Press, but I wanted highlight Chapter 14 on spatial data in this post. Isaac Kunen and I collaborated on this chapter and together turned out 81 pages of action packed reading… ;-). While this chapter is designed to be a stand alone treatise on SQL Server Spatial, it is also a nice compliment to Alastair Aitchison’s book, Beginning Spatial with SQL Server 2008.

There are three main components to this chapter:

1. The chapter content, presented here by the table of contents

2. Source code for the chapter examples

3. Sample spatial data for use with the source code

Here is the table of contents for the chapter:

**Chapter 14**

**Spatial Data**

**Introduction to Spatial Data**

**Basic Spatial Data Concepts**

Vector Data and the OGC Simple Features Type Model

Planar and Geographic Coordinates

Spatial Reference Identifiers

Standards

Working on the Ellipsoid

**Data**

Common Forms of Data

Finding Spatial Data

Loading Spatial Data

Sample Spatial Data

**Getting Started with Spatial Data**

Creating a Table with a Spatial Column

Well-Known Text

Constructing Spatial Objects from Strings and Inserting into a Table

Basic Object Interaction Tests

Basic Spatial Operations

Intersecting Spatial Objects

Union of Spatial Objects

Generalization of Spatial Objects

Proximity Queries

Distance between Spatial Objects

Spatial Buffers

Comparing Spatial Buffers and Distance-Based Calculations to Test

Proximity

The GEOGRAPHY Type

The Geography Type and SRIDs

The Geography Type and Coordinate Ordering

Coordinate Systems and Units of Measure

The Extent of Geography Objects

Spatial Data Validity

Data Validity Issues with Geometry Data

Measuring Length and Area

Comparing Length Measurements between GEOMETRY and GEOGRAPHY Instances

Comparing Area Measurements between GEOMETRY and GEOGRAPHY Instances

Indexing Spatial Data

Spatial Index Basics

SQL Server Spatial Indexes

Using Spatial Indexes

Geography Indexes

Query Plans

Integration with Spatial Methods

Using Spatial Data to Solve Problems

Loading Spatial Data

Shape2SQL

MapPoint 2009 Add-In for SQL Server

Loading Spatial Data from Text Files

Common Workflow Patterns

Using the GEOMETRY MakeValid Method

Forcing Polygon Ring Orientation

Moving Geometry Data to Geography Data

Using MakeValidGeographyFromGeometry

Finding Site Locations within Geographic Regions

Find High Schools with 2 KM of Interstate 5 in King County,

Washington State

Find Schools Within 4 KM of the Intersection of Interstate 5 and

Interstate 405 in King County, Washington State

Nearest Neighbor Searches

Find the Nearest GeoNames Data around a Point Location

Find Zip Codes around a Point Location

Spatial Joins

Processing Spatial Data

Processing the Highways Table in the Sample_USA Database

The WorkFlow

**Extending Spatial Support with CLR Routines**

Types on the Client

User Defined Aggregate: Union and Dissolve

Sinks and Builders: Linear Transformations

**Conclusion**

My next post will cover the associated source code for the examples and the sample spatial data.

I’d like to save a tree. Does this book come in e-book (electronic) format? A link would be appreciated if possible.

For the electronic format for this book, you might try http://my.safaribooksonline.com/

that post like very meaningful and have useful information, thanks for sharing.

<a href="http://www.borders.com/…/TitleDetail >water bound</a>

Does this book come in e-book (electronic) format? A link would be appreciated if possible.