Near Real Time Beijing Pollution Data and Olympic Venues: Mapufacture and GeoCommons in Action
August 7th, 2008by Sean Gorman
With several friends competing at the Beijing games the office has been following the stories about pollution and its possible impact on the games very closely. The best analogy a friend of mine gave after a practice at the rowing venue was “it is like training at altitude”. We thought it might be useful to build a map showing the daily pollution levels in different parts of Beijing on a map that included the Olympic venues.
Raj found a Chinese government source for daily pollution levels in Beijing then geocoded it for us. Andrew used Mapufacture to turn the data into a dynamic geocoded feed, so we could put it on the map and have it updated in real time. Finally Bill used Finder to create a data set with all the Olympic venues. The whole thing came together in a day and we’ve embedded the map below. You can also go to Mapufacture and grab the embed for yourself or the KML and keep track of it in Google Earth or another compliant GeoBrowser.
The icons with the Olympic rings are Olympic venues and the orange squares with the Mandarin character for “atmosphere” are pollution sensors. When you click on the environmental data you’ll see totals for three different pollutants:
1) SO2 - Sulfur Dioxide
2) PM10 - Particulate Matter- that is 10 micrometers in diameter or less
3) NO2 - Nitrogen Dioxide
These three measurement compose the API - the air pollution index. The USA and Canada both use AQI, air quality index, which is similar to API but the indices are set according to different formulas based upon concentration. Therefore, one cannot compare API or AQI between countries without knowing what concentration is represented by the indices.
API Rating (Beijing)
0-50 Grade I (Excellent)
51-100 Grade II (Good)
101-200 Grade III (Lightly Polluted)
201-300 Grade IV (Moderately Polluted)
300+ Grade V (Seriously Polluted)
Interestingly Honk Kong uses the same API index but how they rank between “seriously polluted” and “excellent” is far different.
To keep things honest we used the Honk Kong scale for the map we created. If you would like to do some comparisons (knowing the formulas) of API in Beijing to AQI in other cities you can check out the EPA data set in Finder with AQI for major urban counties in the USA.
*Special thanks to Andrew’s wife Corrie for deciphering the enviro science for us. If you would like to get the PhD. version check out her blog on the topic here.
Popularity: 26% [?]







August 7th, 2008 at 12:20 pm
Thanks for this great post.
Do you know any rowers who are blogging the Regatta?
I am collating all rowing blogger posts at http://www.rowperfect.co.uk/news
thanks
Rebecca
August 7th, 2008 at 12:24 pm
[…] partnership we’re looking at the combination of geospatial data with dynamic information and brought in the Olympic venues as additional map […]
August 7th, 2008 at 3:12 pm
Hi Rebecca,
Great idea - I know Susan Francia of the US womens 8+ is running a blog. I’ll keep my eye out for others:
http://www.susanfrancia.com/Whats_New/Whats_New.html
best,
sean
ps - when are we going to be able to buy one of the new fancy rowperfect ergometere?
August 7th, 2008 at 4:13 pm
[…] the Map blogger Sean Gorman and friends have taken Chinese government pollution data and made a mashup map of pollution levels in the areas surrounding Olympic venues in Beijing. Code to embed the map here. Posted by John […]
August 8th, 2008 at 8:21 am
Sean -
Great map…seems like portions of it are not working at the moment?
Oli
August 8th, 2008 at 11:35 am
Hey Oli,
We’ve been getting a few traffic surges, but usually refresh will bring it back. What portions are not getting the job done? You making a come back thought I saw your names in 1x for the Chuck?
best,
sean
August 8th, 2008 at 5:04 pm
Sean -
IE is the issue…the map works 100% fine in Firefox! Seems like the mapufacture javascript does not like Explorer. Again, nicely done!
Don’t call it a comeback! Mama said knock you out.
O.
August 11th, 2008 at 10:03 am
i like this maP! lol…
August 11th, 2008 at 10:30 am
Thanks,
This is the downside of Mac’s
See you at the Chuck. Gonna get Wilkinson to drag my arse down the river. That way I do not have to steer. Well if we get an entry.
sean
October 8th, 2008 at 2:28 am
Interesting to see you comparing the datas
December 16th, 2008 at 4:22 am
it’s a good idear,I’m approvice you.