Monthly Archives: February 2012

Updating a SQL Server Table with Nearest Neighbours (Optimised for SQL Server 2012 / SQL Azure)

So I’ve been trying to think of some examples that make use of the Garmin POI data from my last post. Seeing as POI data naturally lends itself to nearest-neighbour queries, I thought I’d write a little about those. The … Continue reading

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

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