FlyerTalk Forums

FlyerTalk Forums (https://www.flyertalk.com/forum/index.php)
-   Travel Technology (https://www.flyertalk.com/forum/travel-technology-169/)
-   -   OpenFlights.org mapping tool now open (https://www.flyertalk.com/forum/travel-technology/865434-openflights-org-mapping-tool-now-open.html)

josmon10 Oct 5, 2010 3:35 pm


Originally Posted by jpatokal (Post 14881960)
I'm afraid not, but here's what the database says for your flights. (I presume you're OK with publishing this, since your profile is public!)

No problem :)

Yes, the odd country out is Hong Kong. I'm with you, though; after countless pages of China & HK stamps in my passports, I also consider Hong Kong to be a different country/territory!

Thank you for your time, jpatokal. I'll keep reporting anything to help you improve OpenFlights (I'm still trying to work everything out...)

malgudi Oct 5, 2010 9:55 pm

Very cool app ^

I exported to a CSV, changed the dates to 0000-00-00 and imported them back again to get rid of the dates :)


Originally Posted by jpatokal (Post 14888803)
No, dates are mandatory. You can always use a date like 1901-01-01 if you want to though.


jpatokal Oct 6, 2010 1:00 am


Originally Posted by Circumknowitall (Post 14890618)
Do clustered airport symbols change colour?

If an airport in a cluster is dominant, its icon is displayed instead. The cluster symbol is used only if all airports within the cluster have roughly the same number of flights.


BTW Thanks for this app, its superb! ^
Ta, donations are always appreciated ;)

cmn.jcs Oct 8, 2010 6:42 am

jpatokal, great tool! Thanks so much for making it.

One thing I've noticed is when entering the equipment type for a flight, the autocomplete doesn't work quite right. For example, if I type in "Boe" it will come up with a list of "Boeing 707 \n Boeing 717 \n etc etc" (with \n being line returns). But when if I continue to type "Boeing 737-" the list doesn't change. It just stays at the first list of the basic model numbers. It's absolutely no big deal, and I can type it out myself, but wanted to let you know.

Thanks again!

EricTheNerd Oct 8, 2010 9:13 am

I was just curious if there was a way to designate a flight pair as a connection. As of now, each segment is listed separately, is it possible to have a connecting flight be listed as a single "flight unit"? I was also curious how one might be able to input a train journey between stations with no code (such as Italian stations). This is an excellent utility by the way.

Thanks!

jackal Oct 10, 2010 5:36 pm

Let me preface this with kudos to jpatokal for creating such a great, modern-looking tool--it blows FlightMemory out of the water in terms of aesthetics, functionality, and design. And it's all done for free!

However, there are a couple of minor things I'd like to make observations about:


Originally Posted by cmn.jcs (Post 14908695)
jpatokal, great tool! Thanks so much for making it.

One thing I've noticed is when entering the equipment type for a flight, the autocomplete doesn't work quite right. For example, if I type in "Boe" it will come up with a list of "Boeing 707 \n Boeing 717 \n etc etc" (with \n being line returns). But when if I continue to type "Boeing 737-" the list doesn't change. It just stays at the first list of the basic model numbers. It's absolutely no big deal, and I can type it out myself, but wanted to let you know.

Thanks again!

I've had the same issue, and it is a minor annoyance. When entering flight information rapidly, I've often had to go back and edit a previous entry because I didn't realize the auto-complete had corrected what I was trying to type back to something that I didn't want.

Also, tabbing through the fields (at least in Firefox) does not work in a logical order, which is frustrating when trying to quickly enter information mouse-free. For example, it goes:

Date
Departure time
Departure city (skipping arrival time)
Arrival city
(then logical order until:)
Plane
Reg
Add (button)
Clear (button)
Exit (button)
(Then a bunch of other items on the page before:)
Arrival time
? next to Trip
Two random links on the page that I can't find
Trip popup menu
Class (radio buttons for Economy, Premium Economy, Business, and First)
Reason (radio buttons for Work, Leisure, Crew, and Other)
? next to Carrier

It should be all in sequential order from top to bottom, then left to right, and finally ending on the Add button.

Also, one suggestion for the future: how about tying in the flight entry screen with data from FlightStats (or another flight tracking service)? I usually have to reference the actual departure and arrival times on FlightStats while entering flight data on OpenFlights, causing a lot of tab-flipping (and control-tab/control-shift-tab doesn't always work properly when dealing with text entry fields). Automating this (put in date and flight number and the departure/arrival times are automatically filled in) would be awesome. That would be something I would consider paying for a to-be-developed premium version for, since I know soliciting that data is not free.

With those two fixes (well, and perhaps implementing my suggestion, though I know it's a bit of a pie-in-the-sky one), I think I wouldn't have a single thing about which to complain about OF!

flo-e Oct 25, 2010 10:49 pm

might this be an error: 9R is Satena here in Colombia, however I keep getting Phuket Air?!

Love your tool!

jpatokal Oct 26, 2010 1:01 am


Originally Posted by flo-e (Post 15013822)
might this be an error: 9R is Satena here in Colombia, however I keep getting Phuket Air?!

9R was Phuket Air's IATA code until 2007, but apparently it's now assigned to Satena. Should be fixed now.

jpatokal Oct 26, 2010 1:16 am

Thanks for all the suggestions! There are now tracked in Sourceforge:

Tab order incorrect
Autocomplete aircraft subtypes
[url=https://sourceforge.net/tracker/?func=detail&aid=2815561&group_id=235620&atid=1097 180]Counting connection airports[url] (existing feature request)

Access to FlightStats data costs a minimum of $500/year, so that's not on the cards. :(

Anyway, I'm currently working on the import functionality to fix some long-standing bugs, and autocompletion/usability is next in line after that.

SmilingBoy Oct 26, 2010 1:42 am


Originally Posted by jpatokal (Post 15014261)
Access to FlightStats data costs a minimum of $500/year, so that's not on the cards. :(

Two suggestions:

- could you trawl the Openflights database and check whether that flight had been entered and autocomplete based on this? Alternatively, at least the flight time could be based on historic Openflights data?

- It might make sense to round the arrival time to 5 minutes outside North America. Quite often I enter departure airport, arrival airport and departure time. Then the arrival time gets filled in and in a surprisingly high proportion of cases, the arrival time is almost right (maybe 1 or 2 minutes off). Had it been rounded to 5 minutes, it would often result in the exact right time.

sbm12 Oct 26, 2010 5:59 am


Originally Posted by SmilingBoy (Post 15014326)
- It might make sense to round the arrival time to 5 minutes outside North America. ...Had it been rounded to 5 minutes, it would often result in the exact right time.

Are you suggesting that flights outside the USA only land on the 0s & 5s? That doesn't make much sense at all. :confused:

SmilingBoy Oct 26, 2010 6:38 am


Originally Posted by sbm12 (Post 15014829)
Are you suggesting that flights outside the USA only land on the 0s & 5s? That doesn't make much sense at all. :confused:

At least in Europe they do! Both departure and arrival time is always a round 5 minutes!

I was very surprised when I saw the departure times in the US for the first time.

jackal Oct 26, 2010 7:04 am


Originally Posted by SmilingBoy (Post 15014976)
At least in Europe they do! Both departure and arrival time is always a round 5 minutes!

I was very surprised when I saw the departure times in the US for the first time.

I always fill out my data using the actual arrival and departure times (using FlightStats or another tracking site).

Rather than automatically rounding, I'd much prefer integration with FlightStats (they have an API) that automatically imports the times based on the date and flight number. Rounding would throw me off.

jpatokal Oct 27, 2010 3:23 am


Originally Posted by SmilingBoy (Post 15014326)
could you trawl the Openflights database and check whether that flight had been entered and autocomplete based on this? Alternatively, at least the flight time could be based on historic Openflights data?

Yes, there's a long-pending request to autocomplete arrival and departure airports based on the flight number. I've been holding off on this in order to gather more data, but Openflights' database now contains over 500,000 flights so it's about time to try this out.

I'm a little more leery about flight times, since many users don't enter them and they change constantly, but I'll play around with this as well.

davidwu Nov 4, 2010 10:14 am

Same here, major kudos to jpatokal.

A minor request (not sure if others want this), when exporting to CVS, can the Lat/Lon coords of the airport be included too, or at least for paying users? I've flown some very small airports or strips that I've to use custom code and coords. But I want to keep a local copy of those coords I input online too.


All times are GMT -6. The time now is 9:40 am.


This site is owned, operated, and maintained by MH Sub I, LLC dba Internet Brands. Copyright © 2026 MH Sub I, LLC dba Internet Brands. All rights reserved. Designated trademarks are the property of their respective owners.