jpatokal / openflights

Website for storing flight information, rendering paths on a zoomable world map and calculating statistics, with plenty of free airline, airport and route data.
http://openflights.org
GNU Affero General Public License v3.0
1.41k stars 396 forks source link

Create OF airport for routes with a "\N" airport in routes.dat #337

Open gdoubleu opened 9 years ago

gdoubleu commented 9 years ago

For instance: TGK, KCK, PQM, SVS, WNA, KKI, PKA...

jpatokal commented 9 years ago

Whoah, there's a lot more of these than I expected.

cat data/routes.dat | awk -F , '{print $3,$4}' | grep '\\N' | sort | uniq
ABB \N
ACZ \N
AOG \N
AOQ \N
AVA \N
BNB \N
BNC \N
BPL \N
BTC \N
BUL \N
BUW \N
CBS \N
CFK \N
CKX \N
DCN \N
DEF \N
DHB \N
DOB \N
DQA \N
DRV \N
EBH \N
EDA \N
EKS \N
ERL \N
ETR \N
FVM \N
GCH \N
GLN \N
GMO \N
HOE \N
IAO \N
IKE \N
INB \N
IOQ \N
IOT \N
IUI \N
IWK \N
JAU \N
JIC \N
JJA \N
JKR \N
JUH \N
JUK \N
JUU \N
KAA \N
KAZ \N
KCG \N
KCK \N
KCO \N
KGQ \N
KHQ \N
KHY \N
KHZ \N
KKI \N
KOO \N
KQT \N
KSE \N
KUZ \N
KWF \N
KXU \N
LDS \N
LFM \N
LLB \N
LMA \N
MBI \N
MEU \N
MHC \N
MNA \N
MNS \N
MQJ \N
MZW \N
NER \N
NGK \N
NIQ \N
NKI \N
NLT \N
NOP \N
NSQ \N
OGD \N
OGM \N
OKL \N
OLL \N
ORU \N
ORZ \N
OSM \N
OUZ \N
PBZ \N
PHB \N
PKA \N
PQM \N
QFG \N
QFN \N
QJH \N
QOQ \N
QUO \N
QUV \N
QUW \N
RCY \N
RKA \N
SAE \N
SGG \N
SQS \N
SRK \N
SUK \N
SVK \N
SVR \N
SVS \N
SXI \N
SXK \N
SZE \N
SZI \N
TBI \N
TCR \N
TGI \N
TGK \N
TGP \N
THX \N
TKJ \N
TNW \N
TQA \N
TQI \N
TQL \N
TZL \N
UGB \N
ULZ \N
UPK \N
UTS \N
VLY \N
WAE \N
WNA \N
XEQ \N
YFJ \N
YIE \N
YKT \N
YNP \N
ZBL \N
ZGS \N
ZQZ \N
ZYI \N

I'll need to see if I can pull these programmatically from OurAirports or something.