Project 1

Project Description

For this project, we created flow maps using airline and route data of flights heading out of a specific airport. To accomplish this, we uploaded the data to our Carto.com datasets. From here, we created a map and proceeded to edit the SQL to select airlines and routes leaving a specific airport. We also had to edit the SQL to get "arcs" for the routes as opposed to straight lines. Even after this initial edit, routes crossing the dateline were still shown as straight lines. To fix this, we broke up the data and created a map around the dataline that went from 0 to 360 degrees. This solved the issue of the remaining straight lines. To make the map more interactive, I added the "HOVER" option which allows you to see what city a line or "route" was headed to.

For my flow map, I chose Vancouver (YVR) and Frankfurt (FRA). Comparing the two maps, it's easy to see that FRA receives more traffic. This difference between the two could be due to demand for their international flights, their location relative to other countries, and the importance of the airport. For example, Frankfurt is well-known as a layover stop for travelers going abroad. This means many different route options are required. In addition, it's location on the European continent gains it access to many different countries on several continents. Vancouver, however, isn't known as a layover airport, so there's less of a demand for varying routes. YVR's location by the Pacific Ocean also acts as a restriction on its flight routes.

The airline and route data were taken from OpenFlights.org