An entity-relationship model of the flow of waste and resources in city-regions: Improving knowledge management for the circular economy
Artikel i vetenskaplig tidskrift, 2021

Waste and resources management is one of the domains where urban and regional planning can transition towards a Circular Economy, thus slowing environmental degradation. Improving waste and resources management in cities requires an adequate understanding of multiple systems and how they interact. New technologies contribute to improve waste management and resource efficiency, but knowledge silos hinder the possibility of delivering sound holistic solutions. Furthermore, lack of compatibility between data formats and diverse definitions of the same concept reduces information exchange across different urban domains. This paper addresses the challenge of organising and standardising information about waste and resources management in city regions. Given the amount and variety of data constantly captured, data models and standards are a crucial element of Industry 4.0. The paper proposes an Entity-Relationship Model to harmonise definitions and integrate information on waste and resources management. Furthermore, it helps to formalise the components of the system and their relationships. Semi-structured interviews with government officials, mobile app developers and academics provided insights into the specific system and endorsed the model. Finally, the paper illustrates the translation of the ERM into a relational database schema and instantiates Waste Management and industrial Symbiosis cases in Buenos Aires (ARG) and Helsingborg (SWE) to validate its general applicability. The data model for the Circular Flow of Waste and Resources presented here enhances traditional waste management perspectives by introducing Circular Economy strategies and spatial variables in the model. Thus, this research represents a step towards unlocking the true potential of Industry 4.0.

Entity-relationship model

SQL

Circular Cities

Circular economy

Waste Management

Industry 4.0

Författare

Jonathan Edgardo Cohen

Chalmers, Arkitektur och samhällsbyggnadsteknik, Stadsbyggnad

Jorge Gil

Chalmers, Arkitektur och samhällsbyggnadsteknik, Stadsbyggnad

Resources, Conservation and Recycling Advances

26673789 (ISSN)

Vol. 12 200058

Digital Twin Cities Centre

VINNOVA (2019-00041), 2020-02-29 -- 2024-12-31.

Drivkrafter

Hållbar utveckling

Ämneskategorier

Transportteknik och logistik

Ekonomisk geografi

Miljöledning

Miljöanalys och bygginformationsteknik

DOI

10.1016/j.rcradv.2021.200058

Mer information

Senast uppdaterat

2023-04-21