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.