![openlca uses openlca uses](https://www.openlca.org/wp-content/uploads/2016/05/Opensource.svg_.png)
The background DB that I use (ecoinvent 3.5) does not have any flows with type=WASTE_FLOW, so I'm not currently going to implement waste flow calculations. In OpenLCA, I create product system as folows: What I do next is I try to get the impacts for a product system built from a process. These numbers seem to precisely match to what I see in the "Impact analysis" tab for a process.
OPENLCA USES FULL
The result is a full list of impacts for all impact methods and categories for a given process ID. Select im.NAME AS method, ic.NAME AS ic_name, ic.REFERENCE_UNIT, u.NAME AS unit, SUM(fact.VALUE * e.RESULTING_AMOUNT_VALUE) AS impact from TBL_EXCHANGES AS e JOIN TBL_FLOWS AS f ON (f.ID = e.F_FLOW) JOIN TBL_IMPACT_FACTORS AS fact ON (fact.F_FLOW = f.ID) JOIN TBL_UNITS AS u ON (u.ID = fact.F_UNIT) JOIN TBL_IMPACT_CATEGORIES AS ic ON (ic.ID = fact.F_IMPACT_CATEGORY) JOIN TBL_IMPACT_METHODS AS im ON (im.ID = ic.F_IMPACT_METHOD) WHERE e.F_OWNER= GROUP BY im.NAME, ic.NAME, ic.REFERENCE_UNIT, u.NAME These "direct impacts" can be calculated with this SQL (SQL#1):
OPENLCA USES SOFTWARE
Every EXCHANGE is connected to a FLOW, which can be of one of the three types:įor myself, I see the ELEMENTARY_FLOWs connected to a process directly as "direct impacts" of that process, those can be seen in the OpenLCA software when you open a process and go to the "Impact analysis" tab. However, there is a possibility that I am missing something really simple, so I will try to explain my approach, and hope you will correct / add a missing part to it.Īs far as I understand it, the most important relations are:Ī process has multiple EXCHANGES, each representing an INPUT or OUTPUT, depending on the IS_INPUT field value. Maybe if I finally succeed in starting a dev build of the software, I'll get more information by attaching a step-by-step debugger.
![openlca uses openlca uses](https://www.openlca.org/wp-content/uploads/2016/08/logo_UGent200_EN_RGB_colour_2400dpi-1.png)
I tried to look through source code of "olca-modules" but it's a bit hard to follow.
![openlca uses openlca uses](https://www.openlca.org/wp-content/uploads/2018/04/lcacs_distributed_teams.png)
There is something I don't understand in OpenLCA algorithms. I would like to know how OpenLCA builds the inventory for a process, to be able to get the same (or close) numbers by quering the underlying database.