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.