search

wayz-of-chang / Very-Impressive-Project

The Most Useful Flight Map in the World
http://flight-map.herokuapp.com/
0 stars 0 forks source link

No route lines shown #1

Closed mhaque02 closed 10 years ago

mhaque02 commented 10 years ago

Imported the database from OpenFlights as seen on the README. I can see all the airports and airlines from the drop down list but once selected them receive a "Route....is invalid" error. See attached image. What could be the issue? maperror

wayz-of-chang commented 10 years ago

It seems the routes that were imported from OpenFlights are not compatible with the application. For reference, the routes should have source and destination as three letter IATA/FAA codes, which should match with the IATA/FAA code of the airports. Reviewing http://openflights.org/data.html, it seems that the data in the aforementioned columns can be either three letters or four letters. It may be that the data is duplicated with both three letter and four letter versions. In that case, the most straightforward thing to do would be to remove the rows where the source and/or destination is four letters. If, however, that is not the case, and the routes are not duplicates, then the routes will need to be normalized (converting all four-letter codes to three-letter codes by matching the code to the airport's four-letter code, and then substituting with the airport's three-letter code).

mhaque02 commented 10 years ago

Thanks! I was able to convert all the 4 letter ICAO codes to 3 letter IATA codes and that bring back the lines connecting the airports. We're actually using it for a custom system that has an airline system built into it, so we are just using our own data that matches up closely with OpenFlights format :)

wayz-of-chang commented 10 years ago

Glad that helped.