The Shanghai World Expo ended on October 31st, and I, like most of my fellow Shanghai denizens, noticed an immediate and frightening deterioration in the air quality. Over night, it seemed, things went from relatively clean to crazybad
China recently launched a site that delivers hourly pollution data for 113 cities
, but for prior data, there is but one resource for Shanghai air pollution data
, and I’ve decided to crunch those numbers to see if there are any demonstrable trends, and if I could validate what we all see and feel.
The aforementioned resource delivers 10 years of data, from 2000-2010, for Particulate Matter 10 microns and larger (PM10), Sulphur Dioxide (SO2) and Nitrogen Dioxide (NO2). I will let the graphs speak for themselves, and only explain any math I did or if I have a funny joke. Click on any graph to see a much larger and more detailed graph.
10 Year Analysis
First up is a series of graphs featuring 10 years of daily readings, with a 200pt (day) moving average trendline, which sort of smooths out the peaks. First is Particulate Matter 10microns or larger (PM10)
Graph of daily Particulate Matter (PM10) levels in Shanghai, 2000-2010
The highest recorded PM10 levels were 500, on April 2nd, 2007, and March 21st, 2010. I think that, at least in Shanghai, ‘Crazybad’ is not a value on the scale.
Sulphur Dioxide (SO2) is next:
Graph of daily Sulphur Dioxide (SO2) levels in Shanghai, 2000-2010
The highest recorded S02 levels were 113, on December 15th, 2007, and 112, the day before, December 14th, 2007.
Note that for the NO2 graph below, the data available from 1/1/2000 to 6/1/2000 was for NOx, which is the combination of NO and NO2, which was a much higher number and skewed the graphs.
Graph of daily Nitrogen Dioxide (NO2) levels in Shanghai, 2000-2010
The highest recorded NO2 levels were December 24th, 2003, at 160, and November 22nd, 2003, at 157. This is certainly the most seasonal pollutant.
Year on Year Analysis
Those trendlines help a little bit, but how about we compare years against years? This series stacks all 10 years of readings together. The bright yellow line represents 2010.
As before, click any graph to biggify.
Year on Year comparison graph of PM10 emissions in Shanghai, China, from 2000-2010
Year on Year comparison graph of SO2 emissions in Shanghai, China, from 2000-2010
Year on Year comparison graph of N02 emissions in Shanghai, China, from 2000-2010
I suggest you click on a few of these graphs and notice that the Y value scales are much different (PM10 by far the largest). In these graphs it is easier to see the 2010 performance vs previous years: if you can see color above the yellow line, 2010 was better than at least some other year, if there’s color below, worse. But these graphs still look like Jackson Pollack paintings with all those squiggles. Basic Statistics ho!
Year on Year 30 day trendlines
In this series, I’ve graphed the 30day moving average trendlines for all 1- years. I’ve not wrapped the data, each year is calculated from 1/1 to 12/31 (note the X axis starts at 1/31).
Year on Year 30 day moving average comparison graph of PM10 emissions in Shanghai, China
I see a pretty hefty spike in emissions starting in november 2010, don’t you?
Year on Year 30 day moving average comparison graph of S02 emissions in Shanghai, China
2010 was still a pretty good year for SO2 emissions.
Reminder for the next graph: NO2 data is unavailable from 1/1/2000 to 6/1/2000, hence the flatline.
Year on Year 30 day moving average comparison graph of N02 emissions in Shanghai, China
these numbers clearly show that 2010 was a pretty good year, in comparison to the previous 9, until the post expo trash-burnarama. But let’s smooth those graphs out even more.
Year on Year 90 day trendlines
90 day moving average trendlines really smooth out the peaks, but still offer an accurate visual comparison.
Year on Year 90 day moving average comparison graph of PM10 emissions in Shanghai, China
Now this looks pretty demonstrative. By this data & the graph, the PM10 emissions during the last quarter of 2010 was worse than 7 or 8 out of the last 10 years, depending on when you look. Also, the Expo effect is pretty clear to see. Don’t see it? Here, I’ll point it out for you. Here’s the same graph again, with some cheeky notes:
Year on Year 90 day moving average comparison graph of PM10 emissions in Shanghai, China, with pithy arrows!
Does the SO2 graph look similar?
Year on Year 90 day moving average comparison graph of SO2 emissions in Shanghai, China
I don’t see the same clear drop/increase from the expo influence, but it is the most parabolic line on the graph. Also it shows what we expected based on the daily and 30 day graphs, that at least for this time period, 2010 is one of the best, if not the best year for SO2 emissions.
The last reminder, I promise: There is no NO2 data for the first 1/2 of 2000, hence the flatline in the next graph.
Year on Year 90 day moving average comparison graph of NO2 emissions in Shanghai, China
2010 started well for our NO2 numbers, but as we can see, starting around the end of the Expo, the air quality climbed well into the middle territory, comparatively.
First, the obvious caveats:
- I don’t know how/when/where this data was gathered, so we can’t make any claims to the veracity or accuracy of the data itself. we must simply run with what they publish (until we convince the US Consulate to mount some equipment on their roof as the embassy does in Beijing).
- This data source does not perform particularly stringent or useful tests: they don’t measure PM2.5, which measures much smaller (and more harmful) particulate matter. They also only measure SO2 and NO2, instead of coupling them with their equally damaging cousins, NO and SO (the combinations are typically called NOx and SOx).
Because of these clear issues, I don’t want to draw any huge sweeping conclusions about much of anything, but nonetheless, I think the data shows a few key things:
- Year over year, all emissions trend down, with a few bumps and bruises, including the current walloping we’re all taking in the Post- Expo air.
- Post-Expo air quality has been very bad, and the curve of the change suggests that the various moratoria on industrial activities during the Expo were successful in the short run, but we’re sure paying for it now.
All of these things we knew, or at least intuited, before I crunched these numbers, but at least now we have some pretty pictures. If you’d like the full data set, email me.