Product flows labeled as elementary flows in coal and natural gas extraction and processing

[dt-woods]

There is a reasonable number of product flows turned elementary flows, which is causing provider issues when combined with other datasets.

[dt-woods]

Residual Oil

There are 37 entries of residual oil in the upstream_dict in eLCI (for ELCI_2020), split across coal and natural gas basins.

For coal, the compartment is '31-33: Manufacturing/3241: Petroleum and Coal Products Manufacturing' and the ElementaryFlowPrimeContext is 'technosphere', while for gas, the compartment is 'Technosphere Flows/31-33: Manufacturing/3241: Petroleum and Coal Products Manufacturing' and the ElementaryFlowPrimeContext is 'emission'.

After running olcaschema_genupstream_processes (upstream_dict.py), the gas versions are correctly labeled as PRODUCT_FLOWS, while the coal versions are relabeled as ELEMENTARY_FLOW with prepended "Elementary flows/emissions" to their category.

And, since coal basins appear before gas basins in the dictionary, their version of the residual oil flow is read first, which is then referenced by natural gas, incorrectly labeled as elementary flow.

[dt-woods]

One possible solution is to prepend the "Technosphere Flows/" to any coal basin flow categories with elementary flow prime context "technosphere".

[dt-woods]

Alternatively, we can add "ElementaryFlowPrimeContext" to the merged_summary data frame and check its value.

[m-jamieson]

Probably both of you solutions make sense, right? Agree that they should ultimately be placed under "Technosphere Flows." Adding an additional text against one of the columns also seems ok. Is there a reason we would choose on over the other or avoid doing both? Too belt and suspenders?

[dt-woods]

Chose option 2. Seems to work. Ran it for 2020 and 2022, and the product flows persist. Next problem is flow mapping, which seems to be all over the place.

…

On Mon, Nov 25, 2024, 16:17 Matt Jamieson ***@***.***> wrote: Probably both of you solutions make sense, right? Agree that they should ultimately be placed under "Technosphere Flows." Adding an additional text against one of the columns also seems ok. Is there a reason we would choose on over the other or avoid doing both? Too belt and suspenders? — Reply to this email directly, view it on GitHub <#267 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AHCFB5MP2NWPFVFCPKGOSAL2COHVNAVCNFSM6AAAAABQ2RPBOKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDIOJZGA2TIMJUGM> . You are receiving this because you were assigned.Message ID: ***@***.***>