a Competence Centre of
Direct access
to database


ecoinvent v3

EcoSpold v2 Data Format

The ecoSpold format version 2 is documented in the ZIP-file. The geographies master file in KML is available for separate download. The ecoSpold format version 2 replaces the ecoSpold format 1 for the next version of the ecoinvent database, scheduled for release in June 2012. A conversion tool to convert ecoSpold 1 files to ecoSpold 2 files is included in the ecoEditor software, which is used for creating and editing datasets for the ecoinvent database version 3.

Additionally, an Excel names converter tool (current version: v32/from Feb 29, 2012) is available to assist in translating ecoinvent v2 process names into ecoinvent v3 product names. With this Excel tool, an existing ecoSpold 1 file created in the ecoSpoldAccess tool using ecoinvent v2 names can be converted to an ecoSpold 1 file using ecoinvent v3 names, which can then be migrated to ecoSpold 2 format using the ecoSpold converter that is part of the ecoEditor for ecoinvent v3. The Excel names converter tool contains detailed instructions inside on how to use the tool. However, please note that if you used the former available offline version of the ecoEditor tool, you will need to replace the converter files in your ecoEditor/xml folder with the files in this zip-file with an updated version of that converter. The correspondence table lists the corresponding flow names of ecoinvent v2 and v3.

Providers of dedicated LCA software, which have widely adopted the ecoSpold 1 format, are assumed to implement import functions for ecoSpold 2 data before the release of the ecoinvent database version 3 in June 2012. Software providers can obtain assistance from ecoinvent for this purpose.

   
The open source ecoSpold data format v1 (ecoSpold (v1)) was launched in 2000 and is today the most widely used data exchange format for LCI data. The ecoinvent Centre was the first to use this data format for their own LCI database. Other databases adopted the format, and all important LCA software tools have an interface to use datasets in ecoSpold format.

However, both LCA and LCA software have developed since the release of ecoSpold (v1), and to take advantage of all the new developments, a revision of the ecoSpold format has become necessary. An ad hoc expert working group was formed by ecoinvent to guide the revision process, and an open hearing has been conducted among users of the ecoSpold format, in order to collect their input and wishes for a new ecoSpold format v2. The result of this hearing and the way the input has been treated can be seen in a public report.

The changes from ecoSpold v1 to v2 can be summarised under the following headings:

(1) Structural change:

In ecoSpold (v1) the three types of datasets (elementary flow, process, and impact category) were all handled within the same dataset structure. In ecoSpold v2, separate dataset definitions are applied for these three. "Process" will be called "Activity". "Elementary flows" will be called "Exchanges with environment". There will be master lists for allowed “Elementary flows" as well as for "Products and Wastes" and "Locations". The references to entries in these master lists will be made through UUIDs. Note: The impact category dataset definition has not yet been fully determined, and will be tackled by the working group at a later stage in the format development.

(2) Facilitating database maintenance and extension:

  • Option for parent-child relationships between activity datasets
  • Option for expressing geographical information using GIS coordinates
  • Option to use formulas and variables in numerical fields
  • Use of UUIDs for internal references in datasets
  • New field to declare macro-economic scenario for forecasted activities

(3) Better support for alternative modelling options and data exchange with the ILCD format:

  • Option to declare the market model (attributional, consequential) used for an activity
  • The direct linking of an activity (process) name and single product output name has become obsolete.
  • Reduction of the number of required fields
  • New field to declare technology level for activities (new, modern, current, old, outdated)
  • New field to declare an activity as a market activity
  • Addition of joker elements to enable simpler extension of the format

(4) Support for mass balances, energy balances and monetary balances:

  • The category/subcategory concept for processes/activities has been dropped. Instead, options have been introduced to declare multiple classification schemes, tags, and multiple properties of exchanges, e.g. price, dry mass, water content, energy content, elementary or substance composition
  • New field to declare annual production volume
  • New output type: “addition to capital goods”
  • New field to declare product transfer coefficients (outputs relative to inputs)

(5) Support for language versions:

  • Option to add language versions for all text fields

(6) Support for better documentation:

  • Option to add images
  • Option to add more than one validator
  • Fields for uncertainty information made more general and adding numerical fields for the pedigree matrix