OpenLCA database USLCI not imported properly

[shirubana]

Hi, just documenting I tried to import the USLCI with this and ended up with an empty database. "2847 exchanges deleted due to no provider or to many providers available"

Not an issue just hoping for a solution during brightcon with this, fixing Chris's importer, or the brightway_olca package

Would love to discuss more to understand what you are doing during the confernece.

[cyrillefrancois]

Hi Silvana, About brightway_olca, actually it only explores the OpenLCA database and does not import stuff in BW. As discute you manage to import your database at the end, look forward if errors occur. About deleted exchanges, I find in the USLCI database that a lot of product flow have no provider, they are only consumed. Most of them are stored in the folder CUTOFF Flows in Flow category. And it seems that some of them can be linked to EcoInvent. If you use the USLCI alone, you will miss all impacts related to these products.

And you did not manage to import the specific folder '2111: Oil and Gas Extraction" as a user database because the code only allows you to specify in 'user_databases' argument root folders (e.g. '21: Mining, Quarrying, and Oil and Gas Extraction').

[cyrillefrancois]

USLCI is available by quarters on uslci-content When importing by quarter, some providers dependencies may be missed. For now, they don't provide the database on every format. For instance, the last quarter n°2 is only available in zolca

[cyrillefrancois]

Many flows do not have provider and are stored in a Flow folder names 'CUT-OFF' Brightway need an input to properly create an exchange, for these flows we may need to create empty activities.

[shirubana]

Hi, I did some more testing and while it imported some processes, beyond the providers known behavior, it randomly did not import some other processes. The example if I recall correctly was Coal at Mine and Coal at Industrial Boiler; the second one uses the Coal at Mine but one of them didn't load at all. Both had at least some entries with defined providers.

[cyrillefrancois]

Hi, I did the testing too, and it managed to import both Mine and Boiler activities, with correct connexion (except 2 CUT-OFF flow from the Boiler). When the import is finished, my BW database has 646 activities (the same number as in OpenLCA). I put here two capture of AB after the import.

[cyrillefrancois]

I find also error on elementary flow coding, elementary flow categories are not well imported. ELCD and EcoInvent based import didn't face this issue. By the way Federal LCA commun use another list of elementary flows, I try to import LCIA method from their website, without success (error 504)