Data Pipeline Project

Byte 1: Answering a Question With Fusion Table Data

Global Air Quality Map

This map shows the exposure to small particle air pollution: mapped by city. It is measured using the average annual concentration of small airborne particles known as PM2.5. Use the map below to see how cities across the world compare when it comes to this type of air pollution.

We can see from the map that countries like China, India, Mongolia, Pakistan have purple and pink dots, which means that these regions have really bad air quality. On the other hand, countries with mostly yellow dots like Australia and New Zealand have relatively good air quality according to the annual mean of PM 2.5 and PM 10. From the map, we can learn that most of the air polluted countries are in South Asian and most of them are developing countries.

Question: What is the most air polluted country?


Summarized data: calculate the average data for annual mean PM 2.5 and PM 10 for each country and sort by the concentration of PM 2.5. The below chart shows the results.

From the summarized charts above, we can see that Pakistan, Afghanistan, Eygpt, United Arab Emirates, India and China were some countries that had the worst air quality based on annual mean PM 2.5 and annual mean PM 10 given in the dataset. In fact, the heavily populated South Asian country is home to most polluted cities in the world, according to the data. The chart shows that Pakistan has the worst air quality in the world. However, India and China with large population were also heavily polluted. Industrial activities, burning fossil fuels and household activities might be the main reasons for bad air quality. Therefore, it is necessary to take further steps to improve the air quality.

Example Map Visualization