Inside Microsoft SQL Server 2008: T-SQL Programming – Source Code and Spatial Data for Chapter 14

In the previous post, the content for Chapter 14, Spatial Data, was presented.  This post will discuss the sample code and the spatial data associated with the chapter. SOURCE CODE.  The Source Code for Chapter 14 – Spatial Data is located in the zip file: TSQLProgramming20090901.zip (457,765 B) Within the zip file the source code…

0

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

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…

4

My Overheating IBM ThinkPad T60p Laptop

My faithful old IBM T60p laptop has been with me for years.  Over time, and every so slowly, it has been running hotter and hotter (especially when running complex spatial queries on SQL Server 2008 or generating map-based reports using the new SQL Server 2008 R2 Report Builder… ;-).  A few weeks ago it got…

11

A Spatially-Enabled Dinner In Austin, Texas: Some Observations Outside the Office

Not having posted for a while, I thought I’d take a few minutes and provide some thoughts on spatial after successfully negotiating dinner here in Austin, Texas (October 6, 2009).  I’m in town for the Texas GIS Forum, one of my favorite conferences, and always seek out barbeque when I can.  A quick check on…

2

Working with Invalid Data and the SQL Server 2008 Geography Data Type, Part 2

In a long past post, Working with Invalid Data and the SQL Server 2008 Geography Data Type, Part 1b (August 2008), I discussed techniques for dealing with invalid data and the geography data type. In my last post, I listed the new geography validation functions in the SQL Server Spatial Tools project on CodePlex.  In…

10

Update to the SQL Server Spatial Tools project on CodePlex

As Isaac noted in his most recent post, the SQL Server Spatial Tools project on CodePlex has been updated with several new geography functions. This post provides additional detail on the new features: IsValidGeographyFromGeometry IsValidGeographyFromText MakeValidGeographyFromGeometry MakeValidGeographyFromText ConvexHullGeography ConvexHullFromText Here are descriptions for each: bool IsValidGeographyFromGeometry(SqlGeometry geometry) Check if an input geometry can represent a…

2

"Cartographic Adjustment" of Spatial Data for SQL Server Reporting Services, Part 5

The Report Builder, a component of Reporting Services, described in this post will be available as a separate download when the upcoming CTP2 release of SQL Server 2008 Release 2 (R2) is made available to the public, currently scheduled for August 2009.  This was to be the last post in this series but it’s too…

9

"Cartographic Adjustment" of Spatial Data for SQL Server Reporting Services, Part 4

In the previous posts I indicated that this would be the last post in this series but it turned out that I was a bit optimistic. In order to make the final Report Builder post relevant, some interesting data for analysis was needed.  In this post we describe where to find and how to load…

2

"Cartographic Adjustment" of Spatial Data for SQL Server Reporting Services, Part 3

In the previous posts we have covered items 1,2 and 3 of the workflow.  In this post we address item 4. Locate data source and download (Part 1) Load the data into SQL Server (Part 1) Remove unwanted features, simplify Alaska and Hawaii spatial features (Part 2) "Reposition" Alaska and Hawaii cartographically Use the data…

2

"Cartographic Adjustment" of Spatial Data for SQL Server Reporting Services, Part 1

I was recently presented with the problem of taking a US States dataset, in geographic coordinates, and creating a database table whose spatial column would render in a similar fashion to the map, below, with the Alaska and Hawaii insets. The ultimate goal was to use the resulting table in the new map control of…

5