About CO₂ Database

What are the CO₂ emissions of things. How can we as a society fight the climate crisis if we hardly know the opponent (CO₂). With the CO₂ database I want to show the different CO₂ emitters and their emissions. Everyone should be able to know and understand what causes how much CO₂.

Contribution

I would love for you to contribute to the CO₂ database. Either by contributing of emitters or by improving the database. You can find the project on Github.

Deployment

The app is deployed on IHPCloud.

DB

The database connection can be found on the IHPCloud settings page. To dump the production db use pg_dump with the settings from IHPCloud.

Get data from production db:

pg_dump --host=database-cloud.XXXXXXXX.eu-central-1.rds.amazonaws.com -U userInIHPCloudDbSettings -W databaseInIHPCloudDbSettings > dump.sql

Import locally (not tested yet):

psql --host=/PATH/TO/PROJECT/DIRECTORY/build/db app < dump.sql