This repository have datasets with all flights in Brazil registered by ANAC (Agência Nacional de Aviação Civil - National Civil Aviation Agency), all airports involved in these flights and a undirected graph with the number of flights between two airports.

Sources:

• Flights in Brazil by ANAC.
• List of public aerodromes by ANAC.
• Airport Codes by DataHub.io (note: the latitude and longitude columns have their values swapped).

After merging the datasets, the geocoder package was used to fill in the empty values.

You can find the datasets in data/.

All flights in Brazil by ANAC. ANAC does not provide the data dictionary. You can use lrzip to decompress the file.

All airports on ANAC flight records.

It's an undirected graph.

The id of each node is the ICAO airport code.

• extract.py - Download all CSV files and puts them in the data/extract folder.
• transform_to_anac_csv.py - Merges all files downloaded from ANAC, rename the columns and create anac.csv.
• transform_to_airports_csv.py - Creates a dataset with all airports (airports.csv).
• transform_to_graphml.py - Creates an undirected graph (air_traffic.graphml).

In your environment:

# Install requirements for scripts
pip install -r requirements.txt

# Download csv files from sources
python3 extract.py

# Transform to final files
python3 transform_to_anac_csv.py
python3 transform_to_airports_csv.py
python3 transform_to_graphml.py

If you have Docker and Makefile installed on your machine, you can execute the make build command to create the image, followed by make shell to access a container and execute the aforementioned steps to generate the files.

To convert the data/anac.csv file into data/anac.csv.lrz, you must execute the following commands:

sudo apt install lrzip
lrzip -z data/anac.csv

Contributions are more than welcome. Fork, improve and make a pull request. For bugs, ideas for improvement or other, please create an issue.

This project is licensed under the CDLA-Sharing-1.0 License - see the LICENSE file for details.