Monthly Archives: January 2012

Ring Orientation, Bigger-than-a-Hemisphere Polygons, and the ReorientObject method in SQL Server 2012

If you’ve ever tried to import spatial data (from an ESRI shapefile, say) into SQL Server, you’ve almost certainly encountered the dreaded “bigger than a hemisphere” error, as follows: Msg 6522, Level 16, State 1, Line 1 A .NET Framework … Continue reading

Posted in Spatial, SQL Server | Tagged , , , | 4 Comments

SQL Spatial Puzzle #3: The Seven Bridges of Königsberg

The old city of Königsberg, capital of East Prussia (now Kaliningrad), was built on either side of the river Pregel, with seven bridges across the river between four separate landmasses. A problem made famous by Swiss mathematician Leonard Euler is … Continue reading

Posted in Spatial, SQL Server | Tagged , , | 2 Comments

SQL Spatial Puzzle #2: The Hunter

(Click here for Puzzle #1 – the disappearing square) There seem to be several variations on this puzzle, but the version I know is as follows: “A hunter starts at a location. He walks one mile south, one mile east, … Continue reading

Posted in Spatial, SQL Server | Tagged , , | Leave a comment

SQL Spatial Puzzle #1: The Disappearing Square

This is the first in what will (hopefully) be a series of posts demonstrating a few light-hearted uses of SQL Server 2008 spatial functions to solve some common mathematical/logical puzzles. To demonstrate the disappearing square puzzle, first of all create … Continue reading

Posted in Spatial, SQL Server | Tagged , , | Leave a comment