Skip to content

Air Quality Data

tl;dr

 Dataset  Dashboard

Description

This digital record contains historical air pollution and air quality data from approximately 20 air monitoring stations in Vienna, spanning the years from 1980 to 2021. The data was provided by the Umweltbundesamt and is stored in its original form in this record. This record forms the basis of an analysis carried out in a bachelor's thesis at the TU Wien.

Grafana Dashboard

Figure 1: Grafana dashboard visualizing the dataset.

The analysis was carried out in a Jupyter Notebook hosted by our IT-department JupyterHub as part of TU Wien's virtual research environment.

Jupyter Notebook

Figure 2: Jupyter Notebook accessing data on DBRepo using the Python Library.

Solution

One of the first use-cases of importing external data into DBRepo which was provided as .csv flat file. We developed a database schema and a web scraper that scrapes live air quality data from the public map of the environment agency of Austria.

DBRepo Features

  • Import complex dataset
  • System versioning
  • Subset exploration
  • Aggregated views
  • Precise & PID of queries tables
  • External data access for analysis

Acknowledgement

This work was part of a cooperation with the Umweltbundesamt.