Difference between revisions of "IS428 AY2018-19T1 Lau Zi Quan"

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
Line 24: Line 24:
 
{| class="wikitable" style="background-color:#FFFFFF;" width="100%"
 
{| class="wikitable" style="background-color:#FFFFFF;" width="100%"
 
|-
 
|-
! style="font-weight: bold;background: #536a87;color:#fbfcfd;width: 30%;" | Dataset
+
! style="font-weight: bold;background: #536a87;color:#fbfcfd;width: 20%;" | Dataset
 
! style="font-weight: bold;background: #536a87;color:#fbfcfd;width: 30%" | Data Attributes
 
! style="font-weight: bold;background: #536a87;color:#fbfcfd;width: 30%" | Data Attributes
 
! style="font-weight: bold;background: #536a87;color:#fbfcfd;" | Rationale Of Usage
 
! style="font-weight: bold;background: #536a87;color:#fbfcfd;" | Rationale Of Usage
 
|-
 
|-
 
| <center>EEA Data.zip</center>
 
| <center>EEA Data.zip</center>
 +
 
||  
 
||  
*
+
[[File:EEA EDA.png|500px|center]]
 
||  
 
||  
 
# Official air quality measurements (5 stations in the city)  
 
# Official air quality measurements (5 stations in the city)  
– as per EU guidelines on air quality monitoring see the data description [https://drive.google.com/file/d/1v5yCL-LdriDwa65qXPbFL7b0tydylDlb/view HERE…]
+
# There is a Metadata.xlsx file which contains information of stations.
 +
# There are a total of 6 Stations.
 +
# Druzhba, Hipodruma, IAOS/Pavlovo and Nadezhda have data from 2013 to 2018
 +
# Mladost only has data in 2018, it may be the replacement the station of OrlovMost which only have data from 2013 to 2015.
 +
# All data from EEA are validated, valid and verified.  
 
|-
 
|-
  
 
| <center>Air Tube.zip</center>
 
| <center>Air Tube.zip</center>
 
||  
 
||  
*
+
[[File:AirTube EDA.png|500px|center]]
 
||  
 
||  
 
# Citizen science air quality measurements
 
# Citizen science air quality measurements
 +
# Because of the information and coverage by official air measurements data are limited, Crowdsourcing from the citizens to gather data are important.
 +
# These sensors are deployed all over Bulgaria across the year 2017 to 2018.
 +
# Data from AirTube are expected to be noisy and requires cleaning and verification.
 
|-
 
|-
 
 
| <center>METEO-data.zip</center>
 
| <center>METEO-data.zip</center>
 
||  
 
||  
*
+
[[File:Meteo EDA.png|500px|center]]
 
||  
 
||  
# Meteorological measurements
+
# Data collected by Meteorological measurements
|-
+
# There are a total of 2449 records in this dataset.
 
+
# This data is collected at Sofia Airport and is measured at a standard 2-meter height. Pressure data is adjusted to sea-level.
| <center>TOPO-DATA</center>
+
# Data have undergone QA and should be without error.
||
 
*
 
||
 
# Topography data
 
 
|-
 
|-
 
|}
 
|}
 
 
<!--DATASET END-->
 
<!--DATASET END-->
  

Revision as of 02:36, 11 November 2018

To be a Visual Detective

Overview

Air pollution is an important risk factor for health in Europe and worldwide. A recent review of the global burden of disease showed that it is one of the top ten risk factors for health globally. Worldwide an estimated 7 million people died prematurely because of pollution; in the European Union (EU) 400,000 people suffer a premature death. The Organisation for Economic Cooperation and Development (OECD) predicts that in 2050 outdoor air pollution will be the top cause of environmentally related deaths worldwide. In addition, air pollution has also been classified as the leading environmental cause of cancer.

Air quality in Bulgaria is a big concern: measurements show that citizens all over the country breathe in air that is considered harmful to health. For example, concentrations of PM2.5 and PM10 are much higher than what the EU and the World Health Organization (WHO) have set to protect health.

Bulgaria had the highest PM2.5 concentrations of all EU-28 member states in urban areas over a three-year average. For PM10, Bulgaria is also leading on the top polluted countries with 77 μg/m3on the daily mean concentration (EU limit value is 50 μg/m3).

According to the WHO, 60 percent of the urban population in Bulgaria is exposed to dangerous (unhealthy) levels of particulate matter (PM10).

Dataset Analysis & Transformation Process


Sofia Dataset

Four major data sets in zipped file format are provided. They can be download by click on this link.

  • Official air quality measurements (5 stations in the city)(EEA Data.zip) – as per EU guidelines on air quality monitoring see the data description HERE…
  • Citizen science air quality measurements (Air Tube.zip) , incl. temperature, humidity and pressure (many stations) and topography (gridded data).
  • Meteorological measurements (1 station)(METEO-data.zip): Temperature; Humidity; Wind speed; Pressure; Rainfall; Visibility
  • Topography data (TOPO-DATA)


Dataset Data Attributes Rationale Of Usage
EEA Data.zip
EEA EDA.png
  1. Official air quality measurements (5 stations in the city)
  2. There is a Metadata.xlsx file which contains information of stations.
  3. There are a total of 6 Stations.
  4. Druzhba, Hipodruma, IAOS/Pavlovo and Nadezhda have data from 2013 to 2018
  5. Mladost only has data in 2018, it may be the replacement the station of OrlovMost which only have data from 2013 to 2015.
  6. All data from EEA are validated, valid and verified.
Air Tube.zip
AirTube EDA.png
  1. Citizen science air quality measurements
  2. Because of the information and coverage by official air measurements data are limited, Crowdsourcing from the citizens to gather data are important.
  3. These sensors are deployed all over Bulgaria across the year 2017 to 2018.
  4. Data from AirTube are expected to be noisy and requires cleaning and verification.
METEO-data.zip
Meteo EDA.png
  1. Data collected by Meteorological measurements
  2. There are a total of 2449 records in this dataset.
  3. This data is collected at Sofia Airport and is measured at a standard 2-meter height. Pressure data is adjusted to sea-level.
  4. Data have undergone QA and should be without error.

Task 1

Task 2

Task 3

Conclusion

Reference

Feedbacks