Export of overall process data quality

Question

Hey there,

according to this article (Data Quality Systems in openLCA | openLCA.org) general process data quality is only for documentary purposes.

I want to make an overall quality assessment table in my LCA report using the ILCD data quality system on process level. Getting all the information manually from every process seems quite unconvenient, but I didn't find any way to batch-export the pedigree scores of all processes.

Is it possible to get an overview over the data quality of all processes so I can copy & paste to excel or word?

In my case sensitivity analysis is scenario based, so I don't assess data quality within the calculation.

Best regards and thanks in advance!

Answer 1

Well, the process data quality is not used in the calculation. You can get the process data quality via sql (in openLCA, developer tools, sql): 

select name, ref_id, dq_entry from tbl_processes

Good luck!

Comments

Hi Andreas, that works! Easy copy&paste of the SQL results in Excel is possible that way. Since I'm not familiar with SQL I never thought of using SQL requests in openLCA...
Thanks a lot for your solution including the code snippet!

Best regards

---

Hi Andreas
I am using openLCA v2.4.1, database ecoinvent_3_10_Cutoff_Unit_Processes_2024_01_22
When I ran 'Select name, ref_id, dq_entry from tbl_processes;' i get the following i.e. the dq_entry is NULL for all processes.

I was expecting to see the Ecoinvent scores listed?

NAME    REF_ID    DQ_ENTRY   
market for integrated circuit, memory type | integrated circuit, memory type | Cutoff, U    b7212201-aef1-3116-9880-0972185b83d5    NULL   
treatment of slag from metallurgical grade silicon production, inert material landfill | slag from metallurgical grade silicon production | Cutoff, U    fddc2785-3e4d-3dd9-95c0-8f4a91f92ecd    NULL   
solder production, paste, Sn63Pb37, for electronics industry | solder, paste, Sn63Pb37, for electronics industry | Cutoff, U    b2b3b67d-6e5a-3797-9c1b-14b6967a6c33    NULL

---

Hi Pete, ecoinvent has scores only for exchanges, not for processes, that's why results are null

---

Ok, can what I want be done this way? many thanks