Return to Metabolism of Cities

“How to” with Metabolism of Cities

Your Circularity journey on Metabolism of Cities

The CityLoops Data Hub

How to add data to the CityLoops Data Hub

Collecting geospatial information

How to process data

Aggregation and disaggregation

Data Hub processing: geospatial data

Geospatial spreadsheets

Data Hub processing: spreadsheet data

Flow data processing

Stock data processing

Population data processing

Data gap analysis

How to analyse data

How to benchmark indicators

How to interpret the circularity dashboards

Flow Diagram Builder

Eurostat Library and Grid

Existing reports

Urban Circularity Assessment – Handbook

Why should cities carry out the UCA?

What is the UCA?

What are the UCA materials?

What are the outputs?

What are the steps of the UCA?

Part 1a: Material Flow Accounting

Defining urban context

Data collection

Step 1: Select if materials are extracted, imported and/or exported

Step 2: Determine if data from the SCA can be reused

Step 3: Find local data to satisfy your data needs

Step 4a: If you don’t have or can’t find local data, try to use provided data sources

Step 7: Determine which waste treatment methods exist within your municipal boundaries

Step 8: Determine if you have data for the waste categories and fill in the amounts

Data processing

Step 4b: Downscale the data from Step 4a with the correct proxies

Step 5: Fill in your final values in tonnes for two years

Step 6: Note meta information of the data

Part 1b: Material Stock Accounting

Step 1: Find locations, land use and floor areas of buildings

Step 2: Gather building typologies

Step 3: Determine building typology’s material composition

Step 4: Calculate material stock and spatialise it

Part 2: Measuring indicators

Part 3: Assessing Circularity

Step 1: Data gap and quality analysis

Step 2: Interpretation of indicators

Step 3: Assessing the circularity of the city

Sector-Wide Circularity Assessment – Handbook

Why should cities carry out the SCA?

What is the SCA?

What are the sectors and materials?

What are the outputs?

What are the steps of the SCA?

Step 1: Data collection

Layer 1: Urban context

Economic activities in the city

Policy documents

Layer 2: Sector economic activities

GDP and/or GVA per NACE code

Employees per material

Geo-localisation of infrastructure

Layer 3: Material flows and stocks

Extraction / harvesting

Construction manufacturing

Biomass manufacturing

Construction waste

Imports and Exports

Step 2: Data processing

Step 3: Data analysis

Generation of Sankey diagram

Selection and calculation of indicators

Background and glossary of indicators

Generation of insights

Insights from Sankey diagram

Insights from single datasets

Insights from data quality assessment

Insights from indicators

Step 5: Fill in your final values in tonnes for two years

Where:

“A. Data collection” sheet
- 1. Domestic extraction > columns I and J;
- 1. Imports&Exports > columns J, K, L and M;
- 1. Waste > orange fields in columns E-K;

How: When you arrive at Step 5, you will have done a lot of work already around data collection and processing. Now it’s time to fill in your final values:

Ensure that you have your values ready in tonnes, on the city level and for 2 reference years.
Fill in the data into the above mentioned locations. Again, in general, we recommend linking data within different tabs or amongst each other in sheets through the IMPORTRANGE function of google sheets.
- Link the data from the sheets where you did data conversions.
- Link data from the data processing sheet where you did downscaling.