Back to top

DATASETS

This page contains an overview of every dataset which is used in this project. The datasets are related to two countries and are divided into two categories. The one related to air quality index and the others related to public and private transportation.

Original Datasets

Ds1: Centraline qualità dell'aria - Bologna

Air quality data from 2017 to 2024, relating to the three monitoring stations located in the municipality of Bologna. The data were processed starting from those made available by ARPAE Emilia Romagna, which can be consulted at the following address.

The stations are the following:

  1. Giardini Margherita
  2. Via Chiarini
  3. Porta San Felice

DS1 Overview
Title Metadata Source Distribution
Centraline qualità dell'aria View Dataset Metadata Original Dataset URL CSV    JSON    Excel
DS1 Column Headers
COD_STAZ AGENTE DATA_INIZIO DATA_FINE VALORE UM
PORTA SAN FELICE C6H6 (BENZENE) 2023-10-04T13:01:00+02:00 2023-10-04T14:00:00+02:00 0.7 ug/m3
GIARDINI MARGHERITA O3 (OZONO) 2023-10-04T13:01:00+02:00 2023-10-04T14:00:00+02:00 103 ug/m3

Ds2: parco circolante veicoli - Bologna

Circulating fleet of the Municipality of Bologna divided by postal code of residence of the owner.

    For each postal code the quantities are indicated for:
  • Reference year
  • Fuel
  • Owner age
  • Euro standard
  • Owner/company gender
  • Vehicle age

The data are the result of an agreement between the Municipality of Bologna and ACI whose complete data are available on the pages

DS2 Overview
Title Metadata Source Distribution
Parco circolante veicoli View Dataset Metadata Original Dataset URL CSV    JSON    Excel
DS2 Column Headers
Anno CAP totale_veicoli BENZINA BENZINA E GAS LIQUIDO BENZINA E METANO ELETTRICITA GASOLIO IBRIDO BENZINA IBRIDO GASOLIO METANO ALTRE ALIMENTAZIONI ALIMENTAZIONE NON DEFINITO 18 - 25 ANNI 26 - 35 ANNI 36 - 50 ANNI 51 - 60 ANNI 61 - 70 ANNI 0 - 17 ANNI ETÀ NON CONTEMPLATO ETÀ NON DEFINITO OLTRE 70 ANNI EURO 0 EURO 1 EURO 2 EURO 3 EURO 4 EURO 5 EURO 5B EURO 6 EURO 6A EURO 6B EURO 6C EURO 6D EURO NON CONTEMPLATO EURO NON DEFINITO SESSO FEMMINILE SESSO MASCHILE SESSO ND SOCIETÀ PA SOCIETÀ SAPA SOCIETÀ SAS SOCIETÀ SNC SOCIETÀ SOC SOCIETÀ SPA SOCIETÀ SRL SOCIETÀ SURL SRLS ANZIANITÀ VEICOLO 0 - 1 ANNI ANZIANITÀ VEICOLO 2 – 3 ANNI ANZIANITÀ VEICOLO 4 – 5 ANNI ANZIANITÀ VEICOLO 6 – 7 ANNI ANZIANITÀ VEICOLO 8 – 9 ANNI ANZIANITÀ VEICOLO 10 - 12 ANNI ANZIANITÀ VEICOLO 13 - 15 ANNI ANZIANITÀ VEICOLO OLTRE 15 ANNI ANZIANITÀ VEICOLO NON DEFINITO

Ds3: public transportation per fuel type - Bologna

This dataset contains total urban vehicle fleet - Vehicles in actual service as of 12/31 of each year. Battery hybrids. with storage batteries to power the electric traction motor Diesel hybrids: the heat engine has the sole function of producing the energy needed to operate the electric traction motor without any battery intended for storage The Urban Service includes the Bologna Urban Service and the Other Municipalities Urban Service.

DS3 Overview
Title Metadata Source Distribution
TPER Spa. Parco vetture - Numero mezzi urbani per alimentazione - serie storica View Dataset Metadata Original Dataset URL CSV
DS3 Column Headers
Diesel Diesel Elettrico Gas naturale Gas naturale Totale
Anno Ibrido NON ibrido NON ibrido Ibrido NON ibrido Totale

Ds4: number of passengers on public transportation - Bologna

This dataset contains information about number of passengers in the urban area of the municipality of Bologan. The dataset has numbers related to urban service and interurban service. The numbers shows the situation in 31/12 of every year

DS4 Overview
Title Metadata Source Distribution
TPER Spa. Numero di viaggiatori trasportati - Bacino di Bologna - serie storica View Dataset Metadata Original Dataset URL CSV
DS4 Column Headers
Servizio Urbano Servizio Urbano Servizio Urbano Servizio Interurbano Totale Bacino Bologna
Anno Bologna Altro comune Totale

Ds5: Air quality survey 2024 - Milano

The dataset shows the data of the Daily Air Quality Report of the Municipality of Milan drawn up by AMAT, based on the data measured and validated daily by Arpa Lombardia from the institutional air quality stations present in the municipal territory.

These stations are as follows:

  1. via Pascal*
  2. p.le Abbiategrasso
  3. viale Liguria
  4. viale Marche
  5. Parco Lambro
  6. via Senato*
  7. Verziere
  8. p.le Zavattari
  9. via Juvara
<<<<<<< Updated upstream ======= >>>>>>> Stashed changes
DS5 Overview
Title Metadata Source Distribution
Rilevazione qualità aria 2024View Dataset MetadataView Dataset MetadataOriginal Dataset URL CSV    JSON    XML
DS5 Column Headers
stazione_id data inquinante valore
1 2017-01-09 NO2 41
3 2017-01-09 NO2 98

Ds6: Low emission buses used for local public transport - Milano

Low-emission buses used for local public transport - indicator per 100 buses and absolute value - Historical series

The dataset shows, starting from 2014, the low-emission buses used for local public transport in the Municipality of Milan (indicator per 100 buses used and absolute value).

Electric buses (hybrid or all-electric traction, including those powered by hydrogen with fuel cell technology) and gas-powered buses (with bi-fuel petrol/methane or petrol/LPG engine) are considered low-emission.

Dataset extrapolated from tables 7.1-7.2 Urban Mobility Istat.

DS6 Overview
Title Metadata Source Distribution
Autobus a basse emissioni View Dataset Metadata Original Dataset URL CSV    JSON    XML
DS6 Column Headers
Anno Autobus a basse emissioni - indicatore per 100 autobus Autobus a basse emissioni - valore assoluto

Ds7: Buses used for local public transport by emission class - Milano

Buses used for local public transport by emission class - Percentage composition - Historical series

The dataset shows, starting from the year 2015, the buses used for local public transport in the municipality of Milan (percentage composition) by emission class (Euro 4 or lower, Euro 5, Euro 6).

DS7 Overview
Title Metadata Source Distribution
Autobus utilizzati per il trasporto pubblico locale per classe di emissione View Dataset Metadata Original Dataset URL CSV    JSON    XML
DS7 Column Headers
Anno Classe di emissione Percentuale autobus utilizzati

Ds8: Annual passengers per inhabitant - Milano

TPL demand - Annual passengers per inhabitant - historical series

The dataset shows, starting from 2013, the demand for local public transport, quantified in annual passengers per inhabitant, in the Municipality of Milan

DS8 Overview
Title Metadata Source Distribution
Domanda di TPL - Passeggeri annui per abitante View Dataset Metadata Original Dataset URL CSV    JSON    XML
DS8 Column Headers
Anno Domanda di TPL - Passeggeri annui per abitante

Ds9: Vehicle fleet 2004-2022 - Milano

The dataset includes the number of vehicles in circulation starting from 2004. The vehicles are divided into the following categories:

  • BUSES
  • TRUCKS FOR THE TRANSPORT OF GOODS
  • SPECIAL VEHICLES - SPECIFIC
  • CARS
  • MOTORCYCLES AND QUADRICYCLES FOR THE TRANSPORT OF GOODS
  • MOTORCYCLES
  • MOTORCYCLES AND SPECIAL QUADRICYCLES - SPECIFIC
  • TRAILERS AND SEMI-TRAILERS FOR THE TRANSPORT OF GOODS
  • TRUCK UNITS OR TRACTORS
  • OTHER VEHICLES
DS9 Overview
Title Metadata Source Distribution
Parco veicoli circolanti 2004-2022 View Dataset Metadata Original Dataset URL CSV    JSON    XML
DS9 Column Headers
Anno AUTOBUS AUTOCARRI TRASPORTO MERCI AUTOVEICOLI SPECIALI - SPECIFICI AUTOVETTURE MOTOCARRI E QUADRICICLI TRASPORTO MERCI MOTOCICLI MOTOVEICOLI E QUADRICICLI SPECIALI - SPECIFICI RIMORCHI E SEMIRIMORCHI  SPECIALI - SPECIFICI RIMORCHI E SEMIRIMORCHI  TRASPORTO MERCI TRATTORI STRADALI O MOTRICI ALTRI VEICOLI

Mashup Datasets

In our study we have produced three Mashup datasets using nine datasets mentioned above.

MD1: Air quality and vehicle data for Bologna

This dataset is a Masuhp of datasets air quality and various vehicle data (power types of private vehicles, public transport buses efficiency, etc.) for Municipality of Bologna, between the years 2017-2024. The original datasets used for the mashup are DS1, 2, 3 & 4.

MD1 Overview
Title Metadata Distribution
Air quality and vehicle data for Bologna (2017-2024) View Dataset Metadata CSV
MD1 Column Headers
DATE C6H6 (BENZENE) CO (MONOSSIDO DI CARBONIO) NO (MONOSSIDO DI AZOTO) NO2 (BIOSSIDO DI AZOTO) NOX (OSSIDI DI AZOTO) PM10 PM2.5 TOTAL VEHICLES BENZINA BENZINA E GAS LIQUIDO BENZINA E METANO ELETTRICITA GASOLIO IBRIDO BENZINA IBRIDO GASOLIO METANO Diesel_Ibrido Diesel_NON ibrido Elettrico_NON ibrido Gas naturale_Ibrido Gas naturale_NON ibrido TOTAL PUBLIC FLEET URBAN PASSENGERS BOLOGNA

MD2: Air quality and vehicle data for Milan

This dataset is a Masuhp of datasets air quality and various vehicle data (power types of private vehicles, public transport buses efficiency, etc.) for Municipality of Milan, between the years 2017-2024. The original datasets used for the mashup are DS5, 6, 7, 8 & 9.

MD2 Overview
Title Metadata Distribution
Air quality and vehicle data for Milan (2017-2024) View Dataset Metadata CSV
MD1 Column Headers
DATE C6H6 (BENZENE) CO (MONOSSIDO DI CARBONIO) NO2 (DIOSSIDO DI AZOTO) O3 (OZONO) PM10 PM25 SO2 (DIOSSIDO DI SULFURIO) Autobus a basse emissioni - indicatore per 100 autobus Autobus a basse emissioni - valore assoluto Bus Euro 4 o inferiore Bus Euro 5 Bus Euro 6 URBAN PASSENGERS MILAN AUTOBUS AUTOCARRI TRASPORTO MERCI AUTOVEICOLI SPECIALI - SPECIFICI AUTOVETTURE MOTOCARRI E QUADRICICLI TRASPORTO MERCI MOTOCICLI MOTOVEICOLI E QUADRICICLI SPECIALI - SPECIFICI RIMORCHI E SEMIRIMORCHI SPECIALI - SPECIFICI RIMORCHI E SEMIRIMORCHI TRASPORTO MERCI TRATTORI STRADALI O MOTRICI ALTRI VEICOLI

MDS1_2: Air quality and vehicle registration data per CAP for Bologna

This dataset is a Masuhp of air quality and registration of vehicles per CAP for Municipality of Bologna Datasets, between the years 2019-2024. The original datasets used for the mashup are DS1 and DS2.

MDS1_2 Overview
Title Metadata Distribution
Air quality and vehicle data for Milan (2017-2024) View Dataset Metadata CSV
MDS1_2 Column Headers
DATE C6H6 (BENZENE)_PORTA SAN FELICE CO (MONOSSIDO DI CARBONIO)_PORTA SAN FELICE NO (MONOSSIDO DI AZOTO)_PORTA SAN FELICE NO2 (BIOSSIDO DI AZOTO)_GIARDINI MARGHERITA NO2 (BIOSSIDO DI AZOTO)_PORTA SAN FELICE NO2 (BIOSSIDO DI AZOTO)_VIA CHIARINI NOX (OSSIDI DI AZOTO)_PORTA SAN FELICE PM10_GIARDINI MARGHERITA PM10_PORTA SAN FELICE PM10_VIA CHIARINI PM2.5_GIARDINI MARGHERITA PM2.5_PORTA SAN FELICE 40121 40122 40123 40124 40125 40126 40127 40128 40129 40131 40132 40133 40134 40135 40136 40137 40138 40139 40141 ND