Airline Timetable Fun

While I’ve made great use of the Air Canada website in recent years, it does suffer from one thing common to most airline sites: it’s great if you know where you want to fly and when, but not very useful if you just want to explore the possibilites of flying, well, wherever.

To this end, I present these XML files for Air Canada and Star Alliance, which I derived from their latest timetables. They contain information about all of the cities that Air Canada and Star Alliance fly between, along with the distance between the cities.

I’d welcome the inventive and talented among the readership to take this file and make something fun, artistic, creative and/or useful from it.

These little applications, for Air Canada and Star Alliance are my contribution. Let the games begin.

Friday, May 24, 2002 - 9:34pm

Comments

Submitted by Dan Brickley (not verified) on Sat, 2002-05-25 10:27.

This is pretty cool :) How did you get the timetable data? Scraping or do they expose it in XML already? I’d love to experiment with this stuff…

Submitted by Peter Rukavina (not verified) on Sat, 2002-05-25 13:43.

Both Air Canada and Star Alliance use software from Goldenware Travel Technologies to handle their timetable publishing tasks. As a result, the PDF versions of the schedules are similarly structured. I was able to convert the PDF versions of each schedule to ASCII text (using the pdftotext part of xpdf), and then parse the individual city pairs out using a perl script that looks for patterns. There’s just enough structure in the schedule files to allow this to happen. Adding the actual flight schedule wouldn’t be much more difficult.

Submitted by Lars Marius Garshol (not verified) on Sun, 2002-05-26 09:31.

I’d be very interested to see the flight schedule information (as well as operating airline, flight code, etc) added. Could you do that?

Submitted by Richard (not verified) on Mon, 2002-12-02 12:05.

The timetable does not seem to be updated.I am missing the GVA-ATH-BKK connections.