Tag Archives: fun

Gridding Geometries (or, “Creating patchwork animals in SQL Server”)

This is one of those things that I can’t imagine anybody would ever really want to do but, seeing as I haven’t posted anything for a while, I thought I’d write about it just in case it’s of use to … Continue reading

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

Google’s April Fools’ Day 8-bit Map

Today, Google launched its annual April Fool’s joke – go to http://maps.google.com right now and you’ll see a new “Quest” map style in addition to the regular satellite and aerial map styles. Looks a little…. familiar? Here’s the 8-bit tileset … Continue reading

Posted in Spatial | Tagged , | 3 Comments

Creating “The Legend of Zelda” map tiles from Bing Maps aerial imagery

Time for something light-hearted, I feel. Following on from last year’s Bing Maps tribute to Grand Theft Auto, I thought I’d do another videogame-themed map hack inspired by perhaps my most-loved game of all time – the Legend of Zelda. … Continue reading

Posted in Bing Maps | Tagged , , | 17 Comments

Drawing Fractals with SQL Server Spatial

I can’t think of any practical purpose for this code, but here’s a recursive SQLCLR procedure to draw a Sierpinski triangle fractal (or, at least, an approximation of one to a given level of detail) in SQL Server just because … Continue reading

Posted in Spatial, SQL Server | Tagged , , , , , | 1 Comment

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