fossilfuelregistry / portal

3 stars 0 forks source link

POTENTIAL FIX? Wrong project emissions totals in largest projects table #46

Open OpenOilUG opened 3 years ago

OpenOilUG commented 3 years ago

Some projects display emissions totals bigger than their entire country's emissions estimates: e.g.

JesperWe commented 3 years ago

Maybe because for example Ahmedabad has an oil production of 9 425 billion barrels in the source file?

OpenOilUG commented 3 years ago

Identified as GEM data quality issue: removed from current dev version and will ask.

JesperWe commented 3 years ago

Angola looks wrong too.

OpenOilUG commented 3 years ago

Is the day to year calculations on the GEM sparse OIL fields somehow being doubled? POINT 1 All the projects which now display more than 100% total of country emissions are GEM sparse oil fields. For example: Angola: https://dev.fossilfuelregistry.org/co2-forecast/ao Indonesia: https://dev.fossilfuelregistry.org/co2-forecast/id Iran: https://dev.fossilfuelregistry.org/co2-forecast/ir POINT 2 Countries where fields are constructed from dense data seem to have normal proportions. E.g. Norway https://dev.fossilfuelregistry.org/co2-forecast/no POINT 3 If you divide the offending percentages by 365 they all start to appear within reasonable proportions for what a large field could represent of a country's emissions. And collectively they add up to within budget. See Iran or Angola as examples.

JesperWe commented 3 years ago

Starting investigation with Angola / Kissanje This project comes from the sparse_projects_210815_1218 file. It is not part of the more recent GEM_Final_211025_1623, maybe because it comes from Opgee? It is not removed when reimporting GEM_Final_211025_1623 because it has source_id=16 not 15 which is GEM.

The original unit is e3bblsday, if the correct unit is actually e3bbl obviously the emissions are 1/365, yes. Question is where to correct it? All source_id=16 which have e3bblsday unit?

OpenOilUG commented 3 years ago

mistake is in the unit: should barrels a day not e3bblsday so factor is not 365 but 1,000. solution is to change all souces=15 oil units to barrels a day

JesperWe commented 3 years ago

Done for source_id = 16, 54 projects in total.