Since yesterday I started to analyze the country of origin (based on the IP address) from people downloading the various Doppler products. For every IP address hitting the download link I lookup the country from the GEOIP database and I increase a counter in a database record connected to that country and that file.

Then on a separate page (not open for the public) I list that data. But I wanted to have a more graphical overview.

That’s where Windows Live Local comes in. I’m using the standard control for non commercial use, which I embedded on an ASPX page. Then on that page I list the data by country in a table. For every country I lookup the Geographical coordinates using a public webservice provided by geonames.org.

Based on the number of downloads I calculate the size of a ‘blob’ and then I add a ‘pushpin’ on the map at the location of the specific country.

The result (the data you see spans a 2 hours period):

stats.jpg

All is done in C#.

A non real-time version, which is being updated every hour can be found at http://www.dopplerradio.net/doppler-download-distribution

Update:The non real-time version now shows data by city instead of by country. Zoom in and scroll around. Check if you have a fellow Doppler user in your city ;-)

Technorati Tags: ,