Project 1

Lab description

Lab one was created from two datasets, the first one being plane routes and the second airports. Both datasets were combined into one map and a sql query was written to combine and display airplane routes from airports around the world. The map was then shared to my public website for anyone to read.

The top map shows airports and airline routes out of Vancouver using a 2D map. Each airline is defined by a different color making it easier to distinguish. The second map is of a similar concept but based in Buffalo, NY. The data is chopped at the dateline for each map. This allows for long lines traveling across the world easier to see.

OpenFlights.org, www.cartodb.com