Tag Archives: SQL Server

Load Garmin POI data to SQL Server

I’m always looking out for interesting new sources of spatial data to provide examples for use in my books and presentations. Microsoft’s own MSDN documentation demonstrates SQL Server spatial methods only using abstract geometries, such as SET @h = geometry::STGeomFromText(‘POINT(10 … Continue reading

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

Rendering SQL Server spatial data with Mapnik (Part 2 of n, where n is large)

Last year, I wrote what was intended to be the first of a series of posts about Mapnik – a software toolkit for generating beautiful maps from various sets of spatial data. My intention had been to describe how to … Continue reading

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

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 , , , | 5 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

Exporting Spatial Data From SQL Server to ESRI Shapefile

I love the site stats you get from WordPress. This morning I noticed that, in the 9 months that I’ve been writing this blog, nearly 200 people have come to my site after searching for the term “OGR2OGR” in a … Continue reading

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

Spatial Applications in Windows Azure Redux (including Denali)

Several other people have already written on the subject of writing an Azure application that makes use of the SQL Server spatial datatypes. See, for example, Johannes Kebeck’s or Rex Hansen’s articles. However, having tried to answer a question on … Continue reading

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