Lab 1

Map 1.1 Flight Route Map of Vancouver (YVR) Map 1.2 Flight Route Map of Beijing (PEK)

Lab description

I basically used the SQL selection function in Carto Database to join the airport table with geographic coordinate and route table without coordinate, in order to select an airport of origin with its IATA code, which are YVR for Vancouver and PEK for Beijing in this case, and draw the great circle flight path between the origin and the destination city.

I've been always an aviation geek and enjoyed air travel a lot. I do use personally to create my flying record. This assignment is exactly about one of the hobby I'm passionate about and I find it to be great!

Click here to view my flight records on
Or check my flying map below.