CartoDB Map of Vancouver Flights

This map was used to determine the path of all flights to and from Vancouver, Canada. It was created in CartoDB.

To create this map, I started by connecting datasets from in order to create a dataset in CartoDB. The airline paths and cities selected were edited using SQL, first by editing the cities so that only Vancouver was shown, then by showing the airway lines and modifying them so they would appear with a more realistic semi-circular path. Finally, code was added to fix broken lines near the International Date Line. This map is styled with a "Toner Background" style.

  • Link to
  • CartoDB Map of Gatwick Airport Flights

    This map was used to determine the path of all flights to and from Gatwick Airport in the London metropolitan area. It was created in CartoDB.

    The same steps used to create the map of Vancouver Airport flights were used to create this map for Gatwick Airport. Of note are the airflights listed between London and Vancouver. Although the flight listed here would be the same as one of the flights in the Vancouver flights map, not all the flights between Vancouver and London are shown on this map. This is because London has more than one major airport, with Heathrow airport on the opposite side of the metropolitan area. Since no flights to or from Gatwick cross the International Date Line, the broken lines in the Pacific did not come into effect, but I entered the code for this step anyway to ensure maximum accuracy. The same map background from the Vancouver map is used here, and the one common airline in the legend (Air Transat) is shown in the same color as it was on the Vancouver Map.

  • Link to
  • CartoDB Drought Map

    This map was based on the article "Make a Thematic Map of Current Drought Conditions" by Akella Mamata from the CartoDB blog. It demonstrates areas of drought in the United States, from least extreme to most extreme. As with the previous two maps, this map was made in CartoDB.

    To begin, I had to add a shapefile from the CartoDB list of files consisting of the United States. I also had to add the Conus Albers Projection from the EPSG website. Finally, drought data from the US Drought Monitor was utilized in order to record the areas that are most at risk of having a drought. Three data layers were used: Two layers used the United States shapefile, while the third layer consisted of the drought data file.

  • Link to "Make a Thematic Map of Current Drought Conditions"
  • Link to EPSG Information on the Conus Albers Projection
  • Link to the "GIS Data Archive" from the US Drought Monitor