Project item: Flight Database

Project

Priority

Status

Hours allocated

Needs Research

Top Priority?

Attachments

Return to list
Last Saved:
Not saved yet

Task

Flight database<ul><li>The objective is to build up a database of all future airline/flight numbers/departure/arrival times for a given airport (eg PFO).</li><li>The objective is to get data about every flight scheduled in to/out of Pathos airport (or Geneva airport). &nbsp;So each day going forward, i want to see the flight number, airline, destination/departure airports, schedule time and actual departure/arrival times.</li><li>The flight database is designed to provide data to the AXtools and the ParkNRide projects.</li><li>To do this I want to list all the destinations served by an airport (eg for PFO it is LGW, FRA, LHR, &nbsp;LSN, etc)&nbsp;<ul><li>For each date and route (eg LGW-PFO), return the flight details.</li><li>Look for direct (non-stop) flights only<ul><li>Return the list of flights (date, airline, take-off and landing time, price)</li></ul></li><li>We will match that to a database of flights (airline, route, time) to get a flight number. &nbsp; If a new flight, add a new record to look up the flight number.</li></ul></li></ul>The source could be either kayak.com or <a href="https://aviationstack.com">aviationstack.com (</a>Login: <a href="mailto:nurse_stephen@hotmail.com">nurse_stephen@hotmail.com; </a>Password: Descartes99)