Data for Airlines network analysis on an air-rail multimodal system. Journal of Open Aviation Science, 1(2)

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 CO₂ 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.