Community Portal

Create translation table between EMP codes and EW-MFA materials

Created on Wednesday 27 April 2022, 10:53

Back to task list
  • ID
  • Project
    Metabolism of Cities Data Hub
  • Status
  • Priority
  • Type
    General Research Work
  • Tags
    Data Hub Priority Plan 2021 General data hub improvements MFA integration Multi-scale integration
  • Assigned to
    No one yet
  • Subscribers
    Carolin Bellstedt

You are not logged in

Log In Register

Please join us and let's build things, together!


At the moment we have the "Energy, materials and products (EMP) catalog", see here. It is already largely based on EW-MFA MF1-4 material codes (*). However, it doesn't align precisely. What needs to be done is either:

  • adjust the current EMP codes: This is a bit tricky because we already have quite some data with these codes. And we have expanded on the codes for a reason, namely that we needed to adjust it to our needs.
  • create a translation/correspondence table: A starting point would be to make an overview of the EMP codes in a google spreadsheet and then try to match the EW-MFA codes with those.

WHY: This is needed so that when EW-MFA data is uploaded, the system can relate it to the EMP codes. Later on, this facilitates that we can make Sankey diagrams based on the correct classification, make calculations etc.

(*) See here from page 12.
The breakdown by type of material employs a classification of materials. This EW-MFA classification of materials is hierarchical with main material flow categories (1-digit level). Each main category is further broken down, maximal down to 4-digit-level:

  • 1-digit: material category;
  • 2-digit: material class;
  • 3-digit: material group;
  • 4-digit: material sub-group.

General instructions

Compiling lists, searching for information or compiling new information to further the goals of Metabolism of Cities

Discussion and updates

New task was created