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:
- Giardini Margherita
- Via Chiarini
- Porta San Felice
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 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 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 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:
- via Pascal*
- p.le Abbiategrasso
- viale Liguria
- viale Marche
- Parco Lambro
- via Senato*
- Verziere
- p.le Zavattari
- via Juvara
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 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 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 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 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 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.
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 |