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.