Inside Microsoft SQL Sever 2008: T-SQL Programming, Chapter 14, Spatial Data

  • Article

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.

Technorati Tags: Inside Microsoft SQL Server 2008,T-SQL Programming,SQL Server 2008,T-SQL,Spatial,Spatial Data,Table of Contents,TOC