Carbon Intensity Update

[OpenOilUG]

The task is to reproduce https://fossilfuelregistry.org/carbon-intensity natively in the database instead of through Power BI.

[OpenOilUG]

The data needed are in the table calculation_constants under following SQL query:

_select constant_type , factor , country , unit , fossil_fuel_type from calculation_constants where constant_type = 'PRODUCTION_CO2_FACTOR' or constant_type = 'METHANEINTENSITY' ;

Note:

• Where factor is methane, the unit needs to be converted to CO2e by using the CH4 CO2e conversion ratios also in the table for GWP100 and GWP20.

• Resulting data similar to table used in PowerBI below - where both methane and CO2 are expresed as CO2e.

• Difference from Power BI visualisation is that when this graphic is embedded in the country page, the country itself should show up visually demarcated so that the graphic illustrates where it stands in relation to the other countries.

CI Reviewed EXP.xlsx