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
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
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
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
Alastair Aitchison 