Published November 1, 2025 | Version v1
Workflow Open

General workflow to retrieve and further process flight data from the OpenSky database

Authors/Creators

  • 1. ROR icon University of Tübingen

Description

General workflow to retrieve and further process flight data from the OpenSky database, for example for spatial analysis using GIS.

"Opensky_query_example.py" demonstrates an example query of flight data from the Trino database, following the documentation of the utilized library pyopensky by Olive 2019.

"Reduction_example.R" is an R script to reduce the data point frequency of the downloaded data to reduce file size.

"Rbind_csv_example.R" is an R script to combine multiple CSV files of flight data.

 

Files

Files (2.1 kB)

Name Size Download all
md5:22fbada4f4beea0b5b4e7c7126d888eb
712 Bytes Download
md5:0b5ec6c6b9a860ac58d8941dab6779e5
734 Bytes Download
md5:48b2b982f504b00e073b0629c8a75074
668 Bytes Download

Additional details

Software

Programming language
Python , R

References

  • Olive, X., Traffic, a toolbox for processing and analysing air traffic data. J. Open Source Software, 2019, 4, 1518, DOI: 10.21105/joss.01518