Last edit by: TWA884
Latest version (as of 24-Oct-2021) - available at http://depositfiles.com/files/2c753ofyy.
Airline Route Mapper tool (windows based)
#721
Join Date: May 2014
Programs: krisflyer, Asiana Club
Posts: 63
#724
Join Date: May 2014
Programs: krisflyer, Asiana Club
Posts: 63
#725
Original Poster
Join Date: Oct 2001
Location: Germany
Posts: 3,796
Thanks a lot dragoon17c for producing fresh data files! I know from my own experience how much work went into this
Here are a few notes on data files, since I was the original author of the tool.
The reason for the "assertion failed" error is a missing tab in the file airports.dat in the line for the LLO airport (between the longitude and the airport name). Columns should be separated by tabs, not by spaces. If you are not a programmer, you can easily see this by loading the file into Excel.
The "# Date:" comment in routes.dat is displayed by the tool as the "Data set date", so it should be updated to reflect the date when you collected/updated the data.
There is a hidden feature in the tool to help locate misplaced airports. In the filter dropdown box, select "Custom". Now, Instead of airline codes, enter the following and click OK:
*>2000
Then, select "all airlines" in the filter again. The tool will now select airports which do not have routes shorter than 2000 miles. This often happens with misplaced airports appearing in the wrong part of the world. For example, the SHO airport has a single route (to JNB) which is 7851 miles long. This can't be right. Of course, there are also correctly airports which only have long routes, e. g. IPC. So you have to review each case per hand. You can use a different number instead of "2000". E.g. "*>1000" followed by "All airlines" will select all airports with the shortest route exceeding 1000 miles.
Another useful trick for finding data errors is to open the "Options" dialog box, specify "Only show routes between 6000-9999 miles long", then uncheck all long-range aircraft and click OK. This will display suspiciously long routes flown by short-range aircraft. For example, the newest data file shows HGH-HOG (8749 miles) flown by an A320. This can't be right, even though both HGH and HOG are shown at correct location.
Keep up the good work
Here are a few notes on data files, since I was the original author of the tool.
The reason for the "assertion failed" error is a missing tab in the file airports.dat in the line for the LLO airport (between the longitude and the airport name). Columns should be separated by tabs, not by spaces. If you are not a programmer, you can easily see this by loading the file into Excel.
The "# Date:" comment in routes.dat is displayed by the tool as the "Data set date", so it should be updated to reflect the date when you collected/updated the data.
There is a hidden feature in the tool to help locate misplaced airports. In the filter dropdown box, select "Custom". Now, Instead of airline codes, enter the following and click OK:
*>2000
Then, select "all airlines" in the filter again. The tool will now select airports which do not have routes shorter than 2000 miles. This often happens with misplaced airports appearing in the wrong part of the world. For example, the SHO airport has a single route (to JNB) which is 7851 miles long. This can't be right. Of course, there are also correctly airports which only have long routes, e. g. IPC. So you have to review each case per hand. You can use a different number instead of "2000". E.g. "*>1000" followed by "All airlines" will select all airports with the shortest route exceeding 1000 miles.
Another useful trick for finding data errors is to open the "Options" dialog box, specify "Only show routes between 6000-9999 miles long", then uncheck all long-range aircraft and click OK. This will display suspiciously long routes flown by short-range aircraft. For example, the newest data file shows HGH-HOG (8749 miles) flown by an A320. This can't be right, even though both HGH and HOG are shown at correct location.
Keep up the good work
#726
Join Date: May 2014
Programs: krisflyer, Asiana Club
Posts: 63
Finally you are here.
I immediately fix the error and here is the fixed version:
http://depositfiles.com/files/5lu8tsgz4
Also, Could you please put my version in your homepage, so anyone who visit your website can see the latest version
I immediately fix the error and here is the fixed version:
http://depositfiles.com/files/5lu8tsgz4
Also, Could you please put my version in your homepage, so anyone who visit your website can see the latest version
#727
Join Date: May 2000
Location: Elk Grove, CA (SMF)
Programs: AS MVP Gold, IHG Spire, HH Gold
Posts: 241
Thank you VERY MUCH to both cockpitvisit who originally created this invaluable Tool, and to dragoon17c who has done all the work to keep it alive!! :-)
#728
Join Date: Jun 2003
Location: Lewisville, TX USA
Programs: AA EXP 1MM; Hyatt Globalist; Bonvoy LT Ti; National EE; WDW Passholder
Posts: 838
Finally you are here.
I immediately fix the error and here is the fixed version:
http://depositfiles.com/files/5lu8tsgz4
Also, Could you please put my version in your homepage, so anyone who visit your website can see the latest version
I immediately fix the error and here is the fixed version:
http://depositfiles.com/files/5lu8tsgz4
Also, Could you please put my version in your homepage, so anyone who visit your website can see the latest version
Cheers,
LBBZman
#729
Original Poster
Join Date: Oct 2001
Location: Germany
Posts: 3,796
@dragoon17c: In the future, please send me a private message when you need new data put on the website. I am rarely online on FT these days. Thanks
#730
Join Date: Jun 2009
Location: Metro Detroit
Programs: DL KM
Posts: 628
First of all- thank you for resurrecting this tool. I always found it very useful. Noticed a city pair/airline missing. See below.
@dragoon17c
Data point missing : UA from/To ORD-STT End November/Beginning December
@dragoon17c
Data point missing : UA from/To ORD-STT End November/Beginning December
Last edited by Easy Victor; Oct 7, 2018 at 6:49 pm Reason: added tag
#731
Join Date: May 2014
Programs: krisflyer, Asiana Club
Posts: 63
First of all- thank you for resurrecting this tool. I always found it very useful. Noticed a city pair/airline missing. See below.
@dragoon17c
Data point missing : UA from/To ORD-STT End November/Beginning December
@dragoon17c
Data point missing : UA from/To ORD-STT End November/Beginning December
Seasonal routes is not included due to massive workload and constant changes
#732
FlyerTalk Evangelist
Join Date: Feb 2004
Location: YVR
Programs: AC SE 2MM; UA MP Premier Silver; Marriott Bonvoy LT Titanium Elite; Radisson; Avis PC
Posts: 35,255
I clicked on the deposit files link in the wiki... (https://depositfiles.com/files/5lu8tsgz4)
and I am liking the "Single Woman Seeks a Man" (with picture of woman in bikini), "This Medieval Fantasy Game Has So Many Twists and Curves!" (with picture of a scantily clad princess warrior), and "1 Simple Trick Removes Eye Bags & Lip Lines in Seconds" (with a nasty close-up picture of wrinkly lips).
and I am liking the "Single Woman Seeks a Man" (with picture of woman in bikini), "This Medieval Fantasy Game Has So Many Twists and Curves!" (with picture of a scantily clad princess warrior), and "1 Simple Trick Removes Eye Bags & Lip Lines in Seconds" (with a nasty close-up picture of wrinkly lips).
#734
Join Date: May 2014
Programs: krisflyer, Asiana Club
Posts: 63
http://depositfiles.com/files/7qxijyzuo
new version released!!
Updated most of Asian Airlines and new/canceled routes around the world
new version released!!
Updated most of Asian Airlines and new/canceled routes around the world