Okay, I've added a useful number in the message (3.5% is very different from 5000%), and I've incorporated Adam's early updates.
Code:
BKK-HKG old Aeroplan distance (1172) off of Haversine distance (1049) by 11.7%
DEN-SNA old Aeroplan distance (1311) off of Haversine distance (844) by 55.3%
DXB-VIE old Aeroplan distance (1838) off of Haversine distance (2624) by 30%
FLR-LHR old Aeroplan distance (5354) off of Haversine distance (756) by 608.2%
FLR-SFO old Aeroplan distance (5685) off of Haversine distance (6105) by 6.9%
FRA-VIE old Aeroplan distance (373) off of Haversine distance (385) by 3.1%
ICN-PEK old Aeroplan distance (588) off of Haversine distance (560) by 5%
ICN-ZRH old Aeroplan distance (1280) off of Haversine distance (5433) by 76.4%
ISL-VIE old Aeroplan distance (554) off of Haversine distance (777) by 28.7%
KUL-PEK old Aeroplan distance (1901) off of Haversine distance (2742) by 30.7%
LAX-RAR old Aeroplan distance (4982) off of Haversine distance (4683) by 6.4%
LHR-VIE old Aeroplan distance (552) off of Haversine distance (792) by 30.3%
MUC-TXL old Aeroplan distance (312) off of Haversine distance (298) by 4.7%
PEK-ULN old Aeroplan distance (363) off of Haversine distance (724) by 49.9%
SLC-YYZ new Aeroplan distance (1902) off of Haversine distance (1656) by 14.9%
TPA-YYZ old Aeroplan distance (1057) off of Haversine distance (1096) by 3.6%
VIE-ZAG old Aeroplan distance (171) off of Haversine distance (165) by 3.6%
YEG-YOW new Aeroplan distance (1669) off of Haversine distance (1770) by 5.7%
YEG-YYC old Aeroplan distance (158) off of Haversine distance (152) by 3.9%
I think these should be deleted from the database:
DEN-SNA
DXB-VIE
FLR-LHR
ICN-ZRH
ISL-VIE
KUL-PEK
LHR-VIE
PEK-ULN
SLC-YYZ
YEG-YOW
BKK-HKG probably should be too, but it's substantially closer compared to the others.
So then we're left with:
Code:
BKK-HKG old Aeroplan distance (1172) off of Haversine distance (1049) by 11.7%
FLR-SFO old Aeroplan distance (5685) off of Haversine distance (6105) by 6.9%
FRA-VIE old Aeroplan distance (373) off of Haversine distance (385) by 3.1%
ICN-PEK old Aeroplan distance (588) off of Haversine distance (560) by 5%
LAX-RAR old Aeroplan distance (4982) off of Haversine distance (4683) by 6.4%
MUC-TXL old Aeroplan distance (312) off of Haversine distance (298) by 4.7%
TPA-YYZ old Aeroplan distance (1057) off of Haversine distance (1096) by 3.6%
VIE-ZAG old Aeroplan distance (171) off of Haversine distance (165) by 3.6%
YEG-YYC old Aeroplan distance (158) off of Haversine distance (152) by 3.9%
The bottom two are only off by 6 miles, but the rest are still pretty substantial.