New Article – Geographical Visualisations with SQL 2008

My latest Article is up on sql-server-performance. It comes from watching one of the cool videos on TED where the presenter remodelled the World’s landmass based on the number of minutes US news spent on stories from that country – it was quite dramatic.

2004WorldCarbonDioxideEmissionsCDIACIn the article I explore using SQL 2008 Spatial to do something similar with CO2 emissions. I run through the data process, some simple cleanup and the Reduce() method. I then use the STBuffer() to increase or decrease the area of a Geography, starting with just circles and then ending with modifying the countries themselves.

The Article is in two parts:

http://www.sql-server-performance.com/articles/dev/Powerful_Geographical_Visualisations_SQL_2008_Spatial_Part1_p1.aspx

http://www.sql-server-performance.com/articles/dev/Powerful_Geographical_Visualisations_SQL_2008_Spatial_Part2_p1.aspx

Let me know what you think.