search

Open-Earth-Foundation / OpenClimate-Schema

Schema for OpenClimate database
Apache License 2.0
7 stars 2 forks source link

Breakdown of emissions based on sectors of actors #18

Open AyinawuT opened 2 years ago

AyinawuT commented 2 years ago

For the emissions table, I decided to break it down by sector. According to the CDP model, an actor can be based in several sectors, and a sector can be associated with several actors. This forms a many-to-many relationship between an actor and a sector. I created a sector table and an associative table with the sector_id and actor_id as a composite key. I then added emissions data to that table to record the emissions of an actor based on the sector. I also have an Emissions_Scope table which records the different emission scopes.

image

evanp commented 2 years ago

I'm going to add these to the database. @AyinawuT is there a good standard vocabulary for sectors that we can use?

AyinawuT commented 2 years ago

I will suggest the SASB standards. They are industry-based, but are sorted by sector. I will check to see if there are other standards that will make sense to use but you can check out the SASB standards for now. https://www.sasb.org/