Docker image to access German emission data from thru.de.

Build:

docker build . -t thru

Run:

docker run -p 3306:3306 -p 80:80 thru

This will open a web server with phpMyAdmin on port 80 and a MySQL / MariaDB server on port 3306 (Username/password: thru/thru).

Example usage:

We want to know who the biggest CO₂ polluter in Germany is:

echo "SELECT facility_id FROM releases WHERE substance_name='Carbon dioxide (CO2)' AND year='2021' ORDER BY annual_load DESC limit 1;"|mysql -u thru -h localhost -P 3306 -p thru

Result:

facility_id
30132

Who is 30132?

echo "SELECT name FROM facilities WHERE id=73799"|mysql -u thru -h localhost -P 3306 -p thru

Result:

name
RWE Power AG - Kraftwerk Neurath

The German environmental agency (Umweltbundesamt) publishes emission data about facilities in Germany on the web page thru.de. The data is available in SQLite format. The Dockerfile published here allows converting that data to MySQL and accessing it via SQL commands directly or via phpMyAdmin.

This Dockerfile was written by Hanno Böck. You may want to check out my newsletter on industrial decarbonization.