Monthly Archives: April 2011

In Defence of 3D Charts…

There was a time, not so long ago, when pretty much all business graphics looked like this:   The global hegemony of Microsoft Excel (particularly, Excel 97), deployed onto millions and millions of users’ desktop PCs meant that the world … Continue reading

Posted in General Development, SQL Server | Tagged , | 6 Comments

Categorising Open Street Map Road Types For Display and Routefinding

At the end of one my previous posts, I displayed a set of ways imported from Open Street Map in SQL Server Management Studio. It looked like this: Now, as I stated previously, OSM ways don’t equate to roads. Ways … Continue reading

Posted in Open Street Maps, Spatial, SQL Server | Tagged , | Leave a comment

Nearest-Neighbours, Voronoi Diagrams, and Finding your nearest SQL Server Usergroup

As somebody interested in all things spatial, I was delighted that the community corner at SQLBits8 featured an interactive mapping application. Many people commented on how much work had obviously gone into the user interface: the ability to add “pushpins” … Continue reading

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

The Bing Read Write World

During his session yesterday at the Where 2.0 conference, Blaise Aguera y Arcas showed the first public demo of where Microsoft are going in the mapping space, monikered (slightly oddly, I find) the Read/ Write world. Described as “an indexing, … Continue reading

Posted in Bing Maps | Tagged , | 2 Comments

Bing Maps and HTML5 Audio – Once more, with feeling!

I’ve already written articles demonstrating a couple of new HTML5 features and Bing Maps – notably, the <canvas> element and the geolocation API. In this post, I’ll have a look at one of the other new elements in the HTML5 … Continue reading

Posted in Bing Maps | Tagged , , | Leave a comment

Bing Maps AJAX v7 HeatMap Library

A few months ago, I posted an article demonstrating some work I’d done creating heatmaps of crime data using the Bing Maps v7 AJAX control. At that time, my intention had originally been to package up my heatmap code and … Continue reading

Posted in Bing Maps, Spatial | Tagged , , | 20 Comments

Loading Open Street Map Data in SQL Server Part II: Ways.

In a previous post, I described how to load POI data from Open Street Maps into SQL Server. POIs are, by their very nature, pretty easy to define and store, since they are individual points of interest. In this post … Continue reading

Posted in Open Street Maps, Spatial, SQL Server | Tagged , , , | 16 Comments