Flight database

• The objective is to build up a database of all future airline/flight numbers/departure/arrival times for a given airport (eg PFO).
• The objective is to get data about every flight scheduled in to/out of Pathos airport (or Geneva airport).  So each day going forward, i want to see the flight number, airline, destination/departure airports, schedule time and actual departure/arrival times.
• The flight database is designed to provide data to the AXtools and the ParkNRide projects.
• To do this I want to list all the destinations served by an airport (eg for PFO it is LGW, FRA, LHR,  LSN, etc) 
  • For each date and route (eg LGW-PFO), return the flight details.
  • Look for direct (non-stop) flights only
    • Return the list of flights (date, airline, take-off and landing time, price)
  • We will match that to a database of flights (airline, route, time) to get a flight number.   If a new flight, add a new record to look up the flight number.

The source could be either kayak.com or aviationstack.com (Login: nurse_stephen@hotmail.com; Password: Descartes99)

Separate out the Flight scraping software from the AX Tools and the StephenNurse site and consolidate into a single site. 

Scrape all flights to/from PFO and Larnaca airports and tracks prices over time as well as flight times and actual arrival and depart times