Agri-footprint 5.0 – fixed issues

by | Dec 15, 2021 | Uncategorized

Since the 14th December 2021 there is a modified version of Agri-footprint 5.0 (version 3) published in openLCA Nexus, and available for download: https://nexus.openlca.org/database/Agri-footprint

This modification was needed to correct the flow “carbon dioxide” (folder “Elementary flows” – “Emission to Air” – “unspecified”). The carbon dioxide flow with REF_ID 084657e6-8b30-4831-95f5-dc19f3704e85 is no longer applied in the processes, instead the carbon dioxide flow with REF_ID 7ae371aa-8532-11e0-9d78-0800200c9a66 is applied. Therefore, this last flow is now considered both in the openLCA method package and the processes. In addition, some problems identified during database validation (button “Validate”) were also fixed.

 

Next steps for Agri-footprint users

Please, backup the previous version of the database containing your model first, in order to be able to retrieve your data if needed.

If you used the flow with REF_ID 084657e6-8b30-4831-95f5-dc19f3704e85 (“carbon dioxide”) in your foreground processes in the previous version of the database, please apply the following steps. Be aware that the script will just work properly in case both flows are available in the previous version of the database (i.e., database with openLCA method package).

  1. Open the SQL Query Browser in openLCA (Tools > Developer Tools > SQL)
  2. Run the following script:

UPDATE tbl_exchanges SET F_FLOW=(select id from tbl_flows where ref_id=’7ae371aa-8532-11e0-9d78-0800200c9a66′) where F_FLOW=(SELECT id from tbl_flows where ref_id=’084657e6-8b30-4831-95f5-dc19f3704e85′);

UPDATE tbl_exchanges set F_FLOW_PROPERTY_FACTOR=(SELECT id from tbl_flow_property_factors where f_flow=(SELECT id from tbl_flows where ref_id=’7ae371aa-8532-11e0-9d78-0800200c9a66′))  where F_FLOW=(SELECT id from tbl_flows where ref_id=’084657e6-8b30-4831-95f5-dc19f3704e85′);

delete from tbl_flow_property_factors WHERE F_FLOW = (select id from tbl_flows where  REF_ID = ‘084657e6-8b30-4831-95f5-dc19f3704e85’);

delete from tbl_flows WHERE REF_ID = ‘084657e6-8b30-4831-95f5-dc19f3704e85’;

  1. Export the foreground processes as a JSON-LD file from the previous version of the database (version 2)
  2. Download the new version of Agri-footprint from Nexus (version 3)
  3. Import the JSON-LD files to the new database version (version 3)

In the new database, one should not find the flow with REF_ID 084657e6-8b30-4831-95f5-dc19f3704e85 (“carbon dioxide”).

If the flow with REF_ID 084657e6-8b30-4831-95f5-dc19f3704e85 (“carbon dioxide”) was not applied in your foreground processes (i.e., the ones created by you), just export the foreground processes from the previous version of the database (version 2) and import to the new version of the database (version 3), steps 3-5 above. To export and import, choose JSON-LD as the format.