DOI: 10.5281/zenodo.10038840
title: Data for Airlines network analysis on an air-rail multimodal system. Journal of Open Aviation Science, 1(2)

description: About

This dataset contains all the input data required to generate the analysis and results of the article Delgado, L., Trapote-Barreira, C., Montlaur, A., Bolić, T., & Gurtner, G. (2023). Airlines’ network analysis on an air-rail multimodal system. Journal of Open Aviation Science, 1(2). https://doi.org/10.59490/joas.2023.7223

The code used is available on GitHub: https://github.com/UoW-ATM/joas_air_rail_network_analysis

The path to the input data can be modified in the scripts provided in the GitHub repository. With the default setting, the input is in a folder called data.

Dataset structure



data_computed



rail_used_emissions.csv

rail_used_emissions_2.csv

routes_emissinos_v2.csv



flights_data4



year=2023



month=05



1st_week_0523.csv







renfe



renfe_mid_long



agency.txt

calendar.txt

calendar_dates.txt

routes.txt

stops.txt

stop_times.txt

trips.txt





aircraftDatabase.csv

airport_static.csv

code_seats.csv

manual_fixed_airports.csv

mat_corrected.csv

type_code_missing.csv


Data description

data_computed

This folder contains pre-computed values by the authors on rail and air emissions. These are estimated:



For rail using EcoPassenger.

For flights  based on the emission model from Montlaur, A., Delgado, L., & Trapote-Barreira, C. (2021). Analytical Models for CO2 Emissions and Travel Time for Short-to-Medium-Haul Flights Considering Available Seats. Sustainability 13.18 (2021) and from some specific flights using EUROCONTROL's IMPACT model.


flights_data4

Information from flights_data4 table from OpenSky. Please refer to the terms of use of OpenSky for the restrictions on the further use of these data.

The file 1st_week_0523.csv contains the information of the table flights_data4 from OpenSky for the week of the 1st May 2023 (01/05/2023 to 07/05/2003). This was downloaded with the SQL query 

SELECT * FROM flights_data4 WHERE lastseen >= 1682899200 AND firstseen <= 1683504000;

Note that the lastseen and firstseen are in UnixTime and correspond to 2023-05-01 00:00:00 UTC and 2023-05-08 00:00:00 UTC respectively. This ensures capturing all flights landing on 01/05/2023 even if they departed the day before and departing on 07/05/2023 even if landing the day after.

renfe

renfe folder contains the General Transit Feed Specification (GTFS) data from the Renfe rail operator with the high-speed, long and medium distances timetables. Note that Renfe provides the data under a Creative Commons Attribution 4.0 license. 

Other datasets



aircraftDatabase.csv : Database containing information on aircraft information (type, manufacturer, license, etc.) as a function of their transponder icao24 code. Obtained from OpenSky.

airport_static.csv: Airport ICAO code, latitude and longitude.

code_seats.csv: allows each aircraft model to be related to the seats in the cabin. It has been extracted from airline websites and other sources.

manual_fixed_airports.csv: List of manually modified airports for arrival/departure to fix wrong rotations from OpenSky data. For each airport ICAO code, it provides the one that should be used instead and some information on that airport (e.g., name)

mat_corrected.csv: identifies the rotation of each aircraft in the week of study. This is especially relevant for fleet analysis as it is necessary to know the start and end airport of each rotation for each day. It has been identified with an ad-hoc algorithm, and some data has been corrected with FlightRadar24 data support.

type_code_missing.csv: relates the transponders' icao24 identifiers missing from OpenSky to the aircraft type (complement aircraftDatabase), compiled from FlightRadar24.