PANORAMA has the ambition to use datasets originating from (single )project(s) and may even be discontinued are not consistently linked over the life cycle of products within the global economy. PANORAMA would thus showcase how these datasets can be harmonized, leading to a physical-economic database. This harmonized database system can be approached from a material, component, product and waste classification perspective, covering the full economy and national plus international trade.
PANORAMA aims to realize a prototype in an operational environment. The steps within PANORAMA consist of combining, gap filling, and balancing existing datasets. These deliverable depict the steps taking to reach these objectives.
0 - Go-To-Market Strategy
This report gives the blueprint on how the project approaches the valorization of the information, including various prospect for the long-term data curation.
1 - Management And Dissemination Activities
This document details the PANORAMA methodology for communicating the various results to both stakeholders and the general public, and the first steps that will be carried out in order to ensure such tasks are carried out.
2 - Professional Development
The slides that were used to develop an M.Sc.-level Material Flow Analysis lecture to be made available to the partners for use in courses.
3 - Data Harvesting
This report presents the first step towards the development of a complete and harmonized PANORAMA database . It portrays an assessment of the different data sources available, the type of data provided, an overview of the missing data was compiled, and how to select possible data sources for data gap filling.
Most of the data sources used within the Panorama project use very different classification systems to describe the entities they report on. Such sources include but are not limited to the production and trade volumes for different regions, products and industries, final demand statistics, material extraction accounts, product material composition data, etc. Various classifications used in such data sources have several major characteristics that allow distinguishing one from another (the level of detail, the units used, either monetary or physical, the name, the descriptions, etc.). To be able to combine such diverse data sources within the supply and use tables (SUTs) of the Panorama project, concordances between underlying classifications have to be obtained first. In this report, we described which classifications have been used within the project until now and how they have linked to each other.
4 - Data Processing
This deliverable provides information regarding the spatiotemporal data availability for various elements throughout the anthropogenic metal cycle.
The work described in this deliverable relates to the collection and processing of composition and lifetime data, as well as information on end-of-life (EoL) characteristics of the products in the anthropogenic material cycle. A total of 16 elements/substances were selected based on criteria relating to proliferation and criticality.
The initial physical dataset was generated for the EU-28 countries plus the Rest of the World region for the year 2011. It contains highly detailed data on products that were produced in these countries, the international trade, and the households expenditures (all in tonnes), and the composition (in weight fraction) of two elements (tantalum and copper) of said products. Additionally, for each of these data points, a flag was appointed to indicate the quality and the level of transformation applied to the original dataset to be converted into tonnes and/or to the PANORAMA classification system.
5 - Balancing
This report provides a literature review of the existing balancing procedures and indicates which valuable properties hold for each approach. Section 2.1. gives a description of the desired balancing properties and Section 2.2 briefly introduces the different balancing procedures mentioned in the literature review and Section 3 concludes.
This report presents the methodology and first prototype of the PANORAMA database for Denmark (year 2011). Results were then aggregated and compared to other physical stock-flow databases, including Exiobase and ProSUM.
6 - IT Infrastructure
This report describes the first design and implementation procedure for a suitable IT infrastructure for the new information service, based on updating the existing ProSUM Urban Mine and EXIOBASE data models to create a model to manage data on stocks and flows of materials and their compositions across Europe.
WP6 is in charge of managing the datasets which after the application of improved reconciliation procedures, lead to develop a solidly-built professional web application serving balanced stock-flow diagrams for the PANORAMA project. These information services are made available to the panel of end users through a graphic interface with data download functionalities.
As a result of this work in Task 6.2, the present document describes the detailed functional and technical specifications as well as all other aspects useful to the PANORAMA database and data dissemination application, such as hardware, software and human constraints and the corresponding IT infrastructure.
This document is the preparation stage of the PANORAMA website, which corresponds to the macro specification of the digital product. This step is mainly based on the conclusions of the Go-To-Market study presented in the “WPOGTM Upscaling project PANORAMA” report and on the analysis of existing websites related to the study theme.
The information and results of these deliverables reflect only the authors’ view and are property of the PANORAMA consortium. The content of all these documents can be used and distributed provided that the PANORAMA project and the specific document are properly referenced. While these deliverables have been approved by the EIT-Raw Materials, neither the EIT nor the consortium is responsible for any (un)authorized or improper use that may be based on the information they contain.