Flights and Trips

The Flight Log has a number of ways to show information, but understandably, the core component is a list of flights.


The most prominent item on the flights listing is a pair of maps showing every flight I’ve taken since age 18.

Screen Shot 2013-06-10 at 20.13.42

I have a database of all the flights I’ve taken, and I wrote some code to take all of this flight route data and transform it into a format that the the Great Circle Mapper understands, and the Great Circle Mapper generates me a map like the one above. This means that when I add a new flight to the database, my maps are updated automatically.

(As an aside, when I add a flight to the database, it’s hidden at first – only I can see it. This allows me to enter my flights without having the general public aware that I’m traveling until I return home and unhide those flights.)

Of course, while maps are useful, sometimes more details are needed, and for that I’ve included a listing of all of my flights.

Screenshot of a list of flights

Clicking on any flight in the list brings up a flight details page:

Screen Shot 2013-06-10 at 20.20.18

This page shows a map of the flight and a number of details. Many of these details are links – so clicking on First Class, for example, brings you to a page listing all of my first class flights. (The various details will be covered in future posts.) The page also shows some maps of trips (and parts of trips) which have a flight involving these two cities, so this is as good of a time as any to describe how trips work.


At its core, a trip is a complete set of flights, from an origin airport, with a stop at one or more destinations.  Often, but not always, the final destination is the same as the origin, which in everyday speech is a “round trip.”

For the purpose of my flight log, a trip can be divided into one or more sections.  A section is simply all the flights between the origin and the first destination, or between any two consecutive destinations.  So, let’s say that I have a round trip from my home in the Dayton, Ohio area to Los Angeles, with a layover at Dallas/Fort Worth both ways.  This trip would then have two sections – the first containing all of my flights to Los Angeles (the DAY to DFW flight and the DFW to LAX flight) and the second containing all of my flights home (the LAX to DFW flight and the DFW to DAY flight).

If I had a multi-city trip from Dayton to Los Angeles to Seattle to Dayton, there would be three sections – All flights between DAY and LAX, all flights between LAX and SEA, and all flights between SEA and DAY.

All that said, clicking on the Trips link at the top of any Flight Log page will show a list of trips:

Screenshot of a list of trips

Clicking on any of those will show a trip details page:

Screenshot of a trip details page

This particular trip was a multi-city trip, starting and ending in Dayton with stops in Oklahoma City and Rapid City.  As you can see, the map highlights destinations with a ring around a dot, while airports that are simply layovers are just shown as a black dot.

Below the map, all the flights for this trip are shown, grouped by trip section. Clicking any of the airlines and flight numbers will bring up the flight details page as described above.  If you’d like to just see one particular section of the trip, clicking the section number to the left of the flights will do so:

Screenshot of section details

Between the flights and trips pages, my travels are well-described. However, there are still more in-depth flight details included in the Flight Log, which will be covered in my next entry.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s