In Part One, I put up graphs of the last 11 years of API readings for Shanghai, China. The graphs were big, crowded, whacky and JPGs, so it is hard for readers to see anything really tangible. So with the power of statistics, let us see how we can make these more useful, shall we?
Reminder: I make no claims of any sort about the accuracy of the source data, which was gathered from the Shanghai Environmental Education Center. The site and the ministry do not go into detail about their methods, testing sites, or any other pertinent details, which ruins the fun. (click to biggify, as usual)
Year on Year 30day avg PM10 for Shanghai China, 2000-2011
This is a year on year graph of the 30 day running average. That’s a mouthful, but it’s relatively simple, each data point is an average of the 29 previous days and itself. This helps smooth things out without decimating the real shifts in Air Quality, good or bad. Click through for SO2 and NO2, and more fun graphs! Continue reading 2011 Shanghai Air Quality Report Card, Part 2→
Shanghaiist recently ran a good piece explaining the basics of air pollution, which is a great segue into my occasional series of posts about Shanghai Air Quality. People are freaking out about the Air Quality again, which happens periodically.
In early 2011 I gathered some data about Shanghai’s air quality, did some simple math, and made a few graphs, wondering if the Shanghai World Expo had been a period of better air quality. Now that we’re a healthy term into 2012, I thought it was a good time to evaluate 2011 for air quality, and perhaps play with a few more graphs to see if we can make sense of Shanghai’s Air Quality in 2011 juxtaposed against the previous 10 years.
For review, Shanghai measures PM10, SO2 and NO2. Data previous to this set measured API in aggregate and always noted “Total Suspended Particulates” as the chief pollutant. So, that’s useless and thus excluded.
Also note that these numbers are not raw (otherwise they’d be in Parts Per Million), they are integers derived by the API formula, explained here. I suppose I could have done the math backwards ad derived the core values, but there are PhD candidates on top of that.
I make no claims of any sort about the accuracy of the source data, which was gathered from the Shanghai Environmental Education Center. The site and the ministry do not go into detail about their methods, testing sites, or any other pertinent details, which ruins the fun.
Here’s the big graph, PM10 for the last 11 years.
Click through to see the SO2 and NO2 graphs, and a much much more! (also click any graph to biggify)
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.
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)
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:
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.
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.
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).
I see a pretty hefty spike in emissions starting in november 2010, don’t you?
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.
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.
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:
Does the SO2 graph look similar?
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.
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.