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.