In [2]:

    

import pandas as pd, json, numpy as np
import matplotlib.pyplot as plt
%matplotlib inline


    

In [1]:

    

from pygeocoder import Geocoder
apik='AIzaSyDybC2OroTE_XDJTuxjKruxFpby5VDhEGk'


    

In [111]:

    

SD={}
citycoords={}
clustercoords={}
error=[]
cerror=[]
SC=json.loads(file('../json/SC2.json','r').read())
cluster=json.loads(file('../json/cluster.json','r').read())


    

In [32]:

    

for c in SC:
    print c,
    #country not parsed yet
    for i in SC[c]:
        if cluster[i] not in clustercoords:
            print cluster[i],
            z=cluster[i]+', '+c
            try: clustercoords[cluster[i]]=Geocoder(apik).geocode(z)
            except: cerror.append(cluster[i])
        if i not in citycoords:
            print i,
            x=i+' airport, '+cluster[i]+', '+c
            try: citycoords[i]=Geocoder(apik).geocode(x)
            except: error.append(i)
    print


    

    




Canada Rouyn YUY Hall Beach YUX Montreal YUL Bearskin Lake XBE Tuktoyaktuk YUB Umiujaq YUD Rankin Inlet YRT Repulse Bay YUT Aklavik LAK Tulita ZFN Blanc-Sablon YBX Brandon YBR Lac Brochet YBT Berens River YBV Baker Lake YBK Campbell River YBL Kugaaruk YBB Baie Comeau YBC Lloydminster YLL Bamfield YBF Saguenay YBG Little Grand Rapids ZGR Kasabonika XKS Gods River ZGI Akulivik AKV St-Augustin YIF Pond Inlet YIO Ivujivik YIK Island Lake YIV Tadoule Lake XTL Masset ZMT Fort Albany YFA Iqaluit YFB Fredericton YFC Flin Flon YFO Fort Hope YFH Snare Lake YFJ Fort Simpson YFS Prince Rupert YPR Peterborough YPQ Puvirnituq YPX Fort Chipewyan YPY Port Alberni YPB Paulatuk YPC Prince Albert YPA Aupaluk YPJ Inukjuak YPH Port-Menier YPN Peawanuck YPO Pickle Lake YPL Pikangikum YPM Nanaimo ZNA Qualicum Beach XQU Chibougamau YMT YMX Bella Coola QBC Fort McMurray YMM Moosonee YMO Makkovik YMN York Landing ZAC Summer Beaver SUR Sanikiluaq YSK Saint John YSJ Postville YSO Fort Smith YSM Lutselk'e YSG XLB Sachs Harbour YSY Summerside YSU Powell River YPW Sandspit YZP Sarnia YZR Coral Harbour YZS Port Hardy YZT Sept-Iles YZV Trail YZZ Toronto YZD Yellowknife YZF Salluit YZG Regina YQR YTZ Trenton YTR Timmins YTS Tasiujaq YTQ Big Trout YTL Thompson YTH Cape Dorset YTE Gjoa Haven YHK Ulukhaktok YHI Hopedale YHO Hamilton YHM Dryden YHD YHE Halifax YHZ Hay River YHY Chevery YHR Poplar Hill YHP YHU Round Lake ZRJ St. Anthony YAY Wapekeka YAX Tofino YAZ Kattiniq YAU Attawapiskat YAT Sault Ste. Marie YAM La Grande-4 YAH Fort Frances YAG Anahim Lake YAA Cat Lake YAC Arctic Bay YAB Bella Bella ZEL Eastmain River ZEM Keewaywin KEW Kelsey KES Stewart ZST Webequie YWP Kingfisher Lake KIF Winnipeg YWG Kangiqsujuaq YWB Williams Lake YWL Wabush YWK Déline YWJ Sandy Lake ZSJ Victoria YWH Kangiqsualujjuaq XGR Kelowna YLW Whatì YLE Kimmirut YLC Fort Mcpherson ZFM Arviat YEK Edmonton YEG Amos YEY Fort Severn YER Inuvik YEV Wunnummin Lake WNN Kamloops YKA Kangirsuk YKG Waterloo YKF Schefferville YKL Waskaganish YKQ Chisasibi YKU Bathurst ZBF Bromont ZBM Shamattawa ZTM Red Lake YRL Gamètì YRA Resolute YRB Rigolet YRG Red Sucker Lake YRS Kapuskasing YYU St. John's YYT Churchill YYQ Goose Bay YYR Mont-Joli YYY YYZ Fort Nelson YYE Smithers YYD Penticton YYF Calgary YYC North Bay YYB Taloyoak YYH YYJ Muskrat Dam MSA High Level YOJ Oxford House YOH Kashechewan ZKE Old Crow YOC Ekati YOA Ottawa YOW Val-d'Or YVO Deer Lake YDF Dawson City YDA Vancouver YDT Nain YDP Dawson Creek YDQ Buffalo Narrows YVT Kuujjuaq YVP Norman Wells YVQ YVR YVZ Bonaventure YVB Qikiqtarjuaq YVM Sachigo Lake ZPB CXH Stephenville YJT South Indian Lake XSI Clyde River YCY Chesterfield Inlet YCS Cross Lake YCR Chilliwack YCW Colville Lake YCK Miramichi YCH Kugluktuk YCO Cochrane YCN Charlo YCL Cambridge Bay YCB Castlegar YCG YCD Moncton YQM Lethbridge YQL Yarmouth YQI Kenora YQK The Pas YQD Windsor YQG Red Deer YQF Quaqtaq YQC Quebec YQB Sydney YQY Gander YQX Quesnel YQZ Grande Prairie YQU Thunder Bay YQT North Battleford YQW Comox YQQ Churchill Falls ZUM Abbotsford YXX Whitehorse YXY Prince George YXS Pangnirtung YXP Terrace YXT London YXU Fort St. John YXJ Medicine Hat YXH Whale Cove YXN Sioux Lookout YXL Sudbury YSB Cranbrook YXC Saskatoon YXE Matagami YNM North Spirit Lake YNO Gatineau YND Norway House YNE Natashquan YNA Wemindji YNC Natuashish YNP Nemiscau YNS St. Theresa Point YST Texada YGB Gods Lake Narrows YGO La Grande Riviere YGL Kingston YGK Fort Good Hope YGH Kuujjuarapik YGW Havre-Saint-Pierre YGV Igloolik YGT Iles-de-la-Madeleine YGR Gaspe YGP Grise Fiord YGZ Gillam YGX
Turkmenistan Türkmenabat CRZ Ashgabat ASB Turkmenbashi KRW Daşoguz TAZ Mary MYP
Saint Helena Ascension Island ASI
Lithuania Vilnius VNO Kaunas KUN Palanga PLQ
Cambodia Phnom Penh PNH Siem Reap REP Sihanoukville KOS
Ethiopia Axum AXU Dire Dawa DIR Ethiopia AMH Semera SZE Lalibela LLI MQX Asosa ASO Awassa AWA Gode GDE Gambela GMB Jimma JIM Jijiga JIJ Addis Ababa ADD Dessie DSE Gondar GDQ Humera HUE Bahir Dar BJR Dembidollo DEM
Aruba Oranjestad AUA
Swaziland
Perú Anta ATA Lima LIM Puerto Maldonado PEM Pucallpa PCL Ilo ILQ Chiclayo CIX Arequipa AQP Juliaca JUL Tacna TCQ Huánuco HUU Iquitos IQT Tingo Maria TGI Piura PIU Talara TYL Cajamarca CJA Jauja JAU Cusco CUZ Tarapoto TPP Trujillo TRU Ayacucho AYP Tumbes TBP Andahuaylas ANS
Argentina Parana PRA San Juan UAQ Neuquen NQN Esquel EQS Santa Fe SFN Termas de Rio Hondo RHD Buenos Aires AEP Rio Grande RGA Comodoro Rivadavia CRD Rio Gallegos RGL Rosario ROS Puerto Iguazu IGR San Rafael AFA El Calafate FTE Posadas PSS San Luis LUQ Cordoba COR Resistencia RES Trelew REL Catamarca CTC Puerto Madryn PMY Mendoza MDZ Mar del Plata MDQ Formosa FMA Tucuman TUC San Carlos de Bariloche BRC Rio Cuarto RCU Ushuaia USH Santiago del Estero SDE Viedma VDM Corrientes CNQ La Rioja IRJ EZE Salta SLA Bahia Blanca BHI Santa Rosa RSA Jujuy JUJ
Bolivia Cobija CIJ Guayaramerin GYA Yacuíba BYC Santa Cruz VVI Riberalta RIB Tarija TJA Sucre SRE Potosí POI Rurenabaque RBQ La Paz LPB Cochabamba CBB Oruro ORU Trinidad TDD
Cameroon N'Gaoundéré NGE Douala DLA Yaounde NSI Maroua MVR Garoua GOU Bafoussam BFX
Burkina Faso Bobo Dioulasso BOY Ouagadougou OUA
Ghana Accra ACC Tamale TML Takoradi TKD Kumasi KMS
Saudi Arabia Dawadmi DWD Dammam DMM Yanbu YNB Taif TIF Arar RAE Al-Qassim ELQ Sharurah SHW Rafha RAH Qaisumah AQI Hofuf HOF Al Wajh EJH Medina MED Saudi Arabia WAE Jizan GIZ EWD Al-Baha ABT Jeddah JED Ha'il HAS Gurayat URY Sakaka AJF Abha AHB Bisha BHH Riyadh RUH Tabuk TUU TUI
Cape Verde Preguiça SNE Sao Vicente VXE São Filipe SFL Praia RAI Boa Vista BVC Vila do Maio MMO Espargos SID
United States Minor Outlying Islands Wake Island AWK Qionghai BAR
Cocos (Keeling) Islands Cocos Islands CCK
Slovenia Ljubljana LJU
Guatemala Guatemala City GUA Puerto Barrios PBR Flores FRS
Guinea Conakry CKY
Wallis And Futuna Futuna Island FUT Wallis WLS
Dominica Canefield DCF Dominica DOM
Liberia Monrovia ROB
Maldives Ifuru IFU Fuvahmulah Island FVM Kadhdhoo Island KDO Thimarafushi Island TMF Kaadedhdhoo Island KDM Maamigili Island VAM Dharavandhoo Island DRV Gan Island GAN Kooddoo Island GKK Male MLE Hanimaadhoo Island HAQ
Pakistan Gwadar GWD Lahore LHE Rahim Yar Khan RYK Sukkur SKZ Dera Ghazi Khan DEA Islamabad ISB Faisalabad LYP Karachi KHI Fort Sandeman PZH Quetta UET Moenjodaro MJD Peshawar PEW Chitral CJL Sialkot SKT Dadu DDU Multan MUX Skardu KDU Gilgit GIL Turbat TUK Panjgur PJG Bahawalpur BHV
Oman Salalah SLL Khasab KHS Muscat MCT
Tanzania Dodoma DOD Musoma MUZ Lake Manyara National Park LKY Zanzibar ZNZ Mafia Island MFA Seronera SEU Mbeya MBI Tanga TGT Mtwara MYW Chake PMA Dar-es-Salaam DAR Mwanza MWZ Bukoba BKZ Songea SGX Kigoma TKQ Nduli IRI Kilimanjaro JRO Tabora TBO Arusha ARK
Palestinian Territory
Saint Kitts And Nevis Nevis NEV Basseterre SKB
Albania Tirana TIA
Gabon Oyem OYE Libreville LBV Port Gentil POG Franceville MVB
Saint Pierre and Miquelon Saint-Pierre FSP Miquelon MQC
Monaco Fontvieille MCM
New Zealand Timaru TIU Queenstown ZQN Whangarei WRE Picton PCN Auckland AKL Westport WSZ Wellington WLG Nelson NSN New Zealand KBZ OHA Whakatane WHK Hokitika HKK Paraparaumu PPQ Rotorua ROT Christchurch CHC Gisborne GIS Wanganui WAG Taupo TUO Dunedin DUD Waitangi CHT Tauranga TRG New Plymouth NPL HLZ Invercargill IVC Napier NPE Blenheim BHE Palmerston North PMR Kaitaia KAT Kerikeri KKE
Yemen Sana'a SAH Riyan RIY Ta'izz TAI Aden ADE Sayun GXF
Denmark Copenhagen CPH Aalborg AAL Aarhus AAR Sonderborg SGD Karup KRP Billund BLL Ronne RNN Esbjerg EBJ
Jamaica Ocho Rios OCJ Montego Bay MBJ KIN
Greenland Tasiilaq AGM Kulusuk KUS Attu QGQ Uummannaq UMD Sisimiut JHS Qaanaaq NAQ Paamiut JFR Nerlerit Inaat CNP JQA Maniitsoq JSU Narsarsuaq UAK Upernavik JUV Nuuk GOH Ilulissat JAV Pituffik THU Aasiaat JEG Ittoqqortoormiit OBY Kangerlussuaq SFJ
Samoa Apia APW
United Arab Emirates Ra'sal-Khaymah RKT Al Ain AAN Dubai DWC Abu Dhabi AUH Sharjah SHJ DXB
Guam Guam GUM
Kosovo Pristina PRN
India Patna PAT Nagpur NAG Kolkata CCU Tirupati TIR Mumbai BOM India AGX Rajkot RAJ Srinagar SXR Varanasi VNS Jammu IXJ Lilabari IXI Leh IXL Madurai IXM Siliguri IXB Chandigarh IXC Agartala IXA Belgaum IXG Allahabad IXD Mangalore IXE Port Blair IXZ Jaipur JAI Ranchi IXR Silchar IXS KNU Aurangabad IXU Khajuraho HJR Chennai MAA Hubli HBX Jodhpur JDH Kozhikode CCJ Delhi DEL Dimapur DMU Dehradun DED BUP Tuticorin TCR Ahmedabad AMD Coimbatore CJB Jamnagar JGA Vijayawada VGA Bangalore BLR Tiruchirapalli TRZ Vadodara BDQ Shillong SHL Thiruvananthapuram TRV Jabalpur JLR Lucknow LKO Gwalior GWL Kullu KUU Indore IDR Amritsar ATQ Cochin COK BKB TEZ Udaipur UDR Andal RDP Bhubaneswar BBI Imphal IMF Visakhapatnam VTZ Jorhat JRH RUP Hyderabad HYD Dibrugarh DIB Diu DIU Raipur RPR Gaya GAY Guwahati GAU Pantnagar PGH Dharamsala DHM Goa GOI Surat STV Aizawl AJL Gorakhpur GOP Bhuj BHJ Bhopal BHO Pune PNQ Rajahmundry RJA Bhavnagar BHU
Azerbaijan Ganja KVD Baku GYD Nakhchivan NAJ Lankaran LLK
Madagascar Madagascar DIE TMM Saint Marie SMS Antananarivo TNR MJN SVB TLE Tôlanaro FTU MOQ Nosy Be NOS
Lesotho Maseru MSU
Saint Vincent and the Grenadines Kingstown SVD Union Island UNI
Kenya Nanyuki NYK Kilaguni ILU Loyengalani LOY Ukunda UKA Amboseli National Park ASV Samburu South UAS Mombasa MBA Nairobi NBO Lodwar LOK Wajir WJR Malindi MYD Kitale KTL Mara Lodges MRE Kisumu KIS WIL Eldoret EDL Kericho KEY Lamu LAU
South Korea Gunsan KUV Muan MWX Ulsan USN Yangyang YNY Gwangju KWJ Daegu TAE Pohang KPO Jinju HIN Cheongju CJJ Seoul ICN GMP Jeju CJU Manzini SHO Wonju WJU Yeosu SYS RSU Busan PUS
Belarus Minsk MSQ
Tajikistan Dushanbe DYU Kulob TJU Khudzhand LBD Kurgan Tyube KQT
Turkey Samsun SZF Kars KSY Mus MSR Erzurum ERZ Istanbul IST Nevsehir NAV Diyarbakir DIY Uşak USQ Erzincan ERC Batman BAL Canakkale CKZ Kayseri ASR Kastamonu KFS Trabzon TZX Konya KYA Mardin MQM Isparta ISE Sivas VAS Tekirdag TEQ Siirt SXZ SAW Kutahya KZR Sanliurfa GNY Van VAN Ordu OGU Dalaman DLM Adiyaman ADF Agri AJI Igdir IGD Izmir ADB Ankara ESB Adana ADA Antalya AYT Malatya MLX Cardak DNZ Bursa YEI Zonguldak ONQ Kahramanmaras KCM Sinop NOP Izmit KCO Edremit EDO Elazig EZS Bodrum BJV Sirnak NKT Gazipasa GZP Gaziantep GZT Merzifon MZH Tokat TJK Antakya HTY
Afghanistan Chakcharan CCN Tarin Kowt TII Bamiyan BIN Kandahar KDH Kabul KBL Bost BST Farah FAH Herat HEA Zaranj ZAJ Mazar-I-Sharif MZR Faizabad FBD
Northern Mariana Islands Rota ROP Saipan SPN
Eritrea Asmara ASM
Solomon Islands Solomon Islands MUA Sege EGM Kirakira IRA Honiara HIR Santa Cruz-Graciosa Bay-Luova SCZ Anua BNY Suavanao VAO Fera Island FRE Ramata RBV CHY Gizo GZO Rennell Island RNL Kagau Island KGE Marau RUS
Saint Lucia Castries SLU Vieux Fort UVF
Mongolia Mongolia COQ Uliastai ULZ Ulan Bator ULN Altai LTI ULG Khovd HVD Arvaikheer AVK
France Limoges LIG Lille LIL Agen AGF Bergerac EGC Carcassonne CCF Bordeaux BOD Nimes FNI Strasbourg SXB Castres DCM Lyon LYS Toulon TLN Quimper UIP Poitiers PIS Le Puy LPY Marseille MRS Lannion LAI Paris BVA Saint Nazaire SNR Brive BVE Chambery CMF Brest BES Tarbes LDE Dole DLE Creil CSF La Rochelle LRH Montpellier MPL Lorient LRT Rennes RNS Figari FSC Beziers BZR Deauville DOL Metz-Nancy ETZ Basel BSL Toulouse TLS Le Touquet-Paris-Plage LTQ Rodez RDZ Aurillac AUR Calvi CLY Pleurtuit DNR CDG ORY Pau PUF Nantes NTE Tours TUF Dijon-Longvic DIJ Grenoble GNB Perpignan PGF XCR Bastia BIA Perigueux PGX Biarritz BIQ MLH Ajaccio AJA Caen CFR Clermont-Ferrand CFE Saint Etienne EBU Nice NCE
Bermuda Bermuda BDA
Slovakia Poprad TAT Piestany PZY Bratislava BTS Kosice KSC
Somalia Galcaio GLK Baidoa BIB Somalia KMU Mogadishu MGQ Bosaso BSA Hargeisa HGA
Laos Laos NEU Oudomsay ODY Pakse PKZ Savannakhet ZVK Xieng Khouang XKH Vientiane VTE Luang Prabang LPQ Luang Namtha LXG
Nauru Yaren District INU
Norway Kristiansund KSU Leknes LKN Alesund AES Forde FDE Stavanger SVG Vardoe VAW Harstad EVE Rost RET Bergen BGO Bodo BOO Stokmarknes SKN Namsos OSY Orsta Volda HOV Longyearbyen LYR Rorvik RVK Værøy VRY Sorkjosen SOJ Mo i Rana MQN Oslo OSL Lakselv LKL Kristiansand KRS Roros RRS Mosjoen MJF Svolvaer SVJ Hasvik HAA Sandnessjoen SSJ Floro FRO Hammerfest HFT Bardufoss BDU Stord SRP Bronnoysund BNN TRF Haugesund HAU Tromso TOS Batsfjord BJF Vadso VDS Sogndal SOG Trondheim TRD Alta ALF Mehamn MEH Honningsvag HVG Kirkenes KKN Berlevag BVG Molde MOL Sandane SDN Notodden NTB Andenes ANX
Malawi Club Makokola CMK Blantyre BLZ Mzuzu ZZU Lilongwe LLW Malawi CEH Dwangwa DWA Likoma Island LIX
Cook Islands Atiu Island AIU Aitutaki AIT Avarua RAR
Benin Cotonou COO
Libya Benghazi BEN Tripoli TIP MJI Tobruk TOB Beida LAQ Misrata MRA
Cuba Baracoa BCA Camaguey CMW Cayo Coco CCC Nueva Gerona GER Cayo Largo del Sur CYO Guantanamo Bay Naval Station NBW Guantánamo GAO Varadero VRA Santiago de Cuba SCU Holguin HOG Bayamo BYM Las Tunas VTU Moa MOA Havana HAV Cienfuegos CFG Santa Clara SNU Manzanillo MZO
Montenegro Tivat TIV Podgorica TGD
Djibouti Djibouti JIB
Togo Lome LFW
China Chongqing CKG Zhangjiakou ZQZ Korla KRL Qianjiang JIQ Nanchong NAO Mianyang MIG Zunyi ZYI Shiyan WDS Xi'an XIY Shangri-La DIG Beijing NAY Anshan AOG Nanning NNG Zhoushan HSN Lianyungang LYG Luoyang LYA Nanchang KHN Daocheng DCY Qingdao TAO Linyi LYI Kashgar KHG Hanzhong HZG Haikou HAK Jinchang JIC Chaoyang CHG Weihai WEH Liping HZH Lanzhou LHW Wenzhou WNZ Daqing DQA Liupanshui LPF Harbin HRB Wuyishan WUS Taiyuan TYN Wuzhou WUZ Wuxi WUX Xiamen XMN Pu'er SYM Wuhai WUA Jining JNG Lhasa LXA Jinzhou JNZ Zhaotong ZAT Sanya SYX Huaihua HJJ Tianjin TSN Shihezi SHP Ningbo NGB Yibin YBP Handan HDG Fuyang FUG Yichang YIH Jingdezhen JDZ Foshan FUO Zhuhai ZUH Tengchong TCZ Zhangye YZY Wenshan WNH Jiamusi JMU Shenzhen SZX Hami City HMI Quzhou JUZ Libo LLB Yongzhou LLF Huizhou HUZ Dalian DLC Jiayuguan JGN Yangzhou YTY Enshi ENH Yingkou YKH Jiagedaqi JGD Lijiang LJG Dongsheng DSN Shanghai SHA Changsha CSX Dali DLU Fuzhou FOC Yan'an ENY Ji'an JGS Dandong DDG Nyingchi LZY Changzhou CZX Wuhan WUH Kuqa KCA Zhengzhou CGO Hotan HTN Longyan LCX Liuzhou LZH Zhongwei ZHY Tacheng TCG Luzhou LZO Ulanhot HLH Hailar HLD Anshun AVA Shenyang SHE Kunming KMG Chengdu CTU SHF Aksu AKU Mudanjiang MDG Dongying DOY PEK Hengyang HNY Xingyi ACX Hefei HFE Mangshi LUM Xining XNN Yanji YNJ Tongren TEN Xiangyang XFN Baishan NBS Shennongjia HPG Xuzhou XUZ Changde CGD Tangshan TVS PVG Changchun CGQ Hohhot HET Turpan TLQ Karamay KRY Nanyang NNY Yichun YIC Songpan JZH Yining YIN Dunhuang DNH Qiqihar NDG Baoshan BSD Yiwu YIW Yulin UYN Meixian MXZ Golog GMQ Heihe HEK Zhanjiang ZHA Bayannur RLK Jinjiang JJN Qingyang IQN Nantong NTG Baotou BAV Arxan YIE Chifeng CIF Jinghong JHG Jieyang SWA Changzhi CIH Bole BPL Huangyan HYN Qiemo IQM Altay AAT Guangzhou CAN Yancheng YNZ Yantai YNT Bangda BPX Ganzhou KOW Weifang WEF Huangshan City TXN Guiyang KWE Fuyuan FYJ Urumqi URC Fuyun FYN Guilin KWL Xichang XIC Datong DAT Huai'an HIA Anqing AQG Guangyuan GYS Dayong DYG Dazhou DAX Tongliao TGO Yuncheng YCU Delingha HXD Xilinhot XIL Shijiazhuang SJW Jixi JXA Jinan TNA Hangzhou HGH Wanzhou WXN Manzhouli NZH Golmud GOQ Tonghua TNH Kangding KGT Nanjing NKG Beihai BHY Yinchuan INC
Armenia Gyumri LWN Yerevan EVN
Dominican Republic Santo Domingo JBQ Punta Cana PUJ La Romana LRM Puerto Plata POP Santiago de los Caballeros STI Samana AZS SDQ
Germany Dresden DRS Augsburg AGB Germany BGN Paderborn PAD Berlin SXF Lubeck LBC Hannover HAJ Hamburg HAM Rostock RLG Dortmund DTM Friedrichshafen FDH Heringsdorf HDF Kassel KSF Saarbrucken SCN Mannheim MHG XFW Straubing RBM Sylt GWT Munich MUC Ramstein RMS Cologne CGN Nurnberg NUE Frankfurt FRA Munster FMO Dusseldorf DUS Weeze NRN Leipzig LEJ Bremen BRE Erfurt ERF TXL Karlsruhe/Baden-Baden FKB Stuttgart STR Memmingen FMM Hahn HHN
Ukraine Simferopol SIP Vinnytsia VIN Lviv LWO Ivano-Frankivsk IFO Odessa ODS Kiev KBP Kherson KHE Kramatorsk KRQ Dnipropetrovsk DNK Kiev IEV Kharkiv HRK Chernivtsi CWC Zaporizhia OZH
Bahrain Bahrain BAH
Tonga Vavau VAV Tongatapu TBU Eua Island EUA
Cayman Islands Cayman Brac CYB George Town GCM Little Cayman LYB
Western Sahara El Aaiun EUN Dakhla VIL
Finland Jyvaskyla JYV Tampere TMP Kokkola KOK Kuopio KUO Vaasa VAA Oulu OUL Rovaniemi RVN Turku TKU Joensuu JOE Savonlinna SVL Kittila KTT Helsinki HEL Mariehamn MHQ Kemi KEM Ivalo IVL Kajaani KAJ Kuusamo KAO
Central African Republic Bangui BGF
Mauritius Port Mathurin RRG Port Louis MRU
Sweden Linkoping LPI Angelholm AGH Hagfors HFS Umea UME Karlstad KSD Stockholm NYO Visby VBY Stockholm BMA Gallivare GEV Hemavan HMV Lycksele LYC Lulea LLA Jonkoping JKG Ostersund OSD Vaxjo VXO Torsby TYF Arvidsjaur AJR Halmstad HAD Trollhattan THN Kiruna KRN Kalmar KLR Borlange BLE Gothenburg GOT Sveg EVG Kramfors KRF Norrkoping NRK Vilhelmina VHM Skovde KVB Malmo MMX Mora MXX Ornskoldsvik OER Skelleftea SFT Pajala PJA Ronneby RNB Sundsvall SDL Orebro ORB Stockholm VST Stockholm ARN
Vietnam Dien Bien Phu DIN Ca Mau CAH Dong Hoi VDH Da Nang DAD Phu Quoc PQC Qui Nhon UIH Hue HUI Pleiku PXU Buon Ma Thuot BMV Ho Chi Minh City SGN Can Tho VCA Hanoi HAN Da Lat DLI Chu Lai VCL Haiphong HPH Con Dao VCS Rach Gia VKG Nha Trang CXR Tuy Hoa TBB
Antigua And Barbuda Antigua ANU
Macedonia Ohrid OHD Skopje SKP
Mali Bamako BKO
Russia Kursk URS Chokurdah CKH Nalchik NAL Belgorod EGO Nadym NYM Nyagan NYA Naryan-Mar NNM Okha OHH Ivanovo IWA Magnitogorsk MQF Khabarovsk KHV Vladivostok VVO Kyzyl KYZ Turukhansk THX Moscow SVO Sovetsky OVS Mineralnye Vody MRV Igarka IAA Uray URJ Lipetsk LPK Blagoveshchensk BQS Yekaterinburg SVX Moscow ZIA Mirny MJZ Tynda TYD Apatity KVK Novosibirsk OVB Udachny PYJ Orenburg REN Kirov KVX Grozny GRV Sochi AER Moscow DME Kotlas KSZ Samara KUF Gorno-Altaysk RGK Cherepovets CEE Chulman NER Chelyabinsk CEK Orsk OSW Petropavlovsk-Kamchatsky PKC Saratov RTW Syktyvkar SCW Khanty-Mansiysk HMA Rostov-on-Don ROV Tiksi IKS Magas IGT Keperveyem KPW Vorkuta VKT Yakutsk YKS Cheboksary CSY Khatanga HTG Komsomolsk na Amur KXK Chita HTA Kirensk KCK Novokuznetsk NOZ Inta INA Bratsk BTK Noyabrsk NOJ Pechora PEX Penza PEZ Petrozavodsk PES Perm PEE Nizhnevartovsk NJC Novy Urengoy NUX Irkutsk IKT Astrakhan ASF Naberezhnye Chelny NBC Krasnoyarsk KJA Krasnodar KRR Voronezh VOZ Volgograd VOG Kurgan KRO St. Petersburg LED Kemerovo KEJ Magadan GDX Ufa UFA Gelendzhik GDZ Yuzhno-Sakhalinsk UUS Omsk OMS Murmansk MMK Ulan-Ude UUD Kazan KZN Ust-Kut UKX Tyumen TJM Usinsk USK Barnaul BAX Anapa AAQ Tambov TBW Tomsk TOF Strezhevoy SWT Norilsk NSK Cherskiy CYX Anadyr DYR Ukhta UCT Surgut SGC Beloyarsk EYK Abakan ABA Kaluga KLF Ulyanovsk ULY Salekhard SLY Nizhny Novgorod GOJ Ulyanovsk ULV Stavropol STW Moscow VKO Elista ESL Kogalym KGP Beslan OGZ Kaliningrad KGD Makhachkala MCX Arkhangelsk ARH Izhevsk IJK
Bulgaria Sofia SOF Plovdiv PDV Varna VAR Burgas BOJ
United States Angoon AGN Pittsburgh AGC Augusta AGS Parkersburg PKB Springdale SPZ Wichita Falls SPS Springfield SPI Bowling Green BWG Baltimore BWI Rupert BYI Juneau JNU Orange County SNA Presque Isle PQI Snyder SNK Salinas SNS St. Paul Island SNP Midland MAF Yuma YUM Sidney SNY Benton Harbor BEH Eveleth EVM Bedford BED Bethel BET La Crosse LSE Valdosta VLD TTN Grand Rapids GRR Green Bay GRB Oxnard OXR Killeen GRK Grand Island GRI Helena HLN Kongiganak KKH Kenosha ENW Coatesville CTH Austin EDC Edenton EDE Klamath Falls LMT Orlando ORL Worcester ORH Chicago ORD Chicago DPA Rapid City RCA Newport ONP Ontario ONT Chlef CFK Philadelphia PNE San Diego SAN Prescott PRC Sacramento SAC SAF Safford SAD Provincetown PVC Chattanooga CHA Monterey MRY Jacksonville JAX Charlottesville CHO Charleston CHS Marco Island MRK Atlanta JAE Jackson JAC Martinsburg MRB Columbia MRC Alpena APN Dubuque DBQ Napa APC Denver APA Naples APF Williston ISN Truckee TKF Baton Rouge HMT Tok TKJ Gillette GCC Dillingham DLG Garden City GCK Duluth DLH Fort Worth AFW Bettles BTT Burlington BTV Butler BTP Baton Rouge BTR Brunswick SSI Butte BTM Battle Creek BTL Barter Island BTI Lanai LNY Lancaster LNS Willoughby LNN Lincoln LNK Pendleton PDT Eugene EUG Brady BBD Bay City BBC Yakutat YAK Broken Bow BBW Tupelo TUP Tucson TUS Tulsa TUL Cheyenne CYS Evansville EVV Fort Yukon FYU Franklin FKL VCT Wausau CWA Clarksburg CKB Everett PAE Paducah PAH Washington DCA West Memphis AWM Marquette MQT Smyrna MQY Fort Wayne FWA Nome OME Allakaket AET Burbank BUR Buffalo BUF Belleville BLV Dublin PSK Portsmouth PSM Morristown MOR Pittsfield PSF Petersburg PSG Mountain Village MOU Minot MOT Mobile MOB Palm Springs PSP Joplin JLN Modesto MOD Manokotak KMO Hana HNM Honolulu HNL Blacksburg BCB Haines HNS Boca Raton BCT Quincy UIN Point Lay PIZ South Lake Tahoe TVL Thief River Falls TVF Traverse City TVC Charleston JZI Sarasota SRQ Toledo TDZ Nightmute NME Lovelock LOL Corvallis CVO Louisville LOU Cincinnati CVG Lancaster WJF Wheeling HLG Elmira ELM White Plains HPN Hooper Bay HPB Koyuk KKA Enid WDG Del Rio DRT Durango DRO Deering DRG Tulsa RVS Allentown CXL Conroe CXO Dothan DHN Scammon Bay SCM Manassas MNZ Oakland County PTK Stockton SCK Port Heiden PTH State College SCE Jamestown JMS Deadhorse SCC Augusta SCB Pottstown PTW Platinum PTU Moline MLI Plattsburgh PBG West Palm Beach PBI Tucson AVW Avoca AVP Stuart SUA Hailey SUN St. Louis SUS Sioux City SUX Lafayette LFT Teterboro TEB Telluride TEX New Orleans NBG Dallas ADS Kodiak ADQ Detroit DET Danville DNV Greenville GMU Milwaukee MWC Bardstown BRY Barrow BRW Brownsville BRO Burlington BRL Brainerd BRD Twin Falls TWF Moses Lake MWH Eagle EAA Rockland RKD Kearney EAR Eau Claire EAU Wenatchee EAT Augusta ESW Kalskag KLG Hobbs HOB Homer HOM Eastsound ESD Springfield VSF Augusta GOL Scottsdale SCF Clovis CVN Chevak VAK Valdosta VAD Porterville PTV Champaign CMI Columbus CMH Hancock CMX Norfolk ORF Des Moines DSM Destin DSI Oshkosh OKS Winston-Salem INT Rocky Mount RWI Indian Springs INS Niagara Falls INL Oklahoma City OKC Nashville BNA Indianapolis IND Greenville GLH Anaktuvuk Pass AKP Akhiok AKK King Salmon AKN Dover-Cheswold DOV Golovin GLV Augusta AUG Austin AUS Chicago AUZ San Luis Obispo SBP Morristown MMU Eastover MMT Salisbury SBY Pueblo PUB Marshall MML Mammoth Lakes MMH Pullman PUW South Bend SBN Nantucket SBM Kerrville ERV Ukiah UKI Kailua-Kona KOA Olga Bay KOY Erie ERI Asheville AVL Valparaiso VPS St Cloud STC St. Louis STL Sterling STK St. Paul STP STS Jackson JXN Chenega NCN Flint FNT Lihue LIH Little Rock LIT Fort Collins FNL Greenville PGV Noatak WTK Tampa TPA Allentown HRL Harrison HRO Kake KAE Kaltag KAL Rhinelander RHI Rome RME Chicago UGN Raton RTN Olathe OJC Kenai ENA Wendover ENV Chicago RFD Oxford OXD Oxford OXC Atlanta ATL Islip ISP Atqasuk ATK Appleton ATW Kinston ISO Artesia ATS Kissimmee ISM Watertown ATY Provo PVU Providence PVD Seattle SEA Selma SEM College Station CLL Port Angeles CLM Farmingdale FRG Friday Harbor FRD San Diego CLD Cleveland CLE Atlanta PDK Iron Mountain Kingsford IMT Charlotte CLT Fryeburg FRY Clarks Point CLP Pensacola PNS Stillwater SWO Newburgh SWF Beaumont BPT Phoenix GYR Augusta DNL Melbourne MLB Miles City MLS Monroe MLU Manley Hot Springs MLY Columbia NRB Riverside RIV Riverton RIW Hastings HSI Huslia HSL Adak Island ADK Rifle RIL Huntsville HSV Winston-Salem RIF Rice Lake RIE Richmond RIC Kokhanok KNK HAO New Stuyahok KNW Lansing HAR Leadville LXV New York JRA Jacksonville VQQ Syracuse SYR Emmonak EMK Ludington LDM Lake Jackson LJN Lancaster FOX Yakima YKM Fort Dodge FOD Topeka FOE Las Vegas VGT Tuscaloosa TCL Westhampton Beach FOK Newtok WWT Wildwood WWD Saratoga SAA Colorado Springs COS Columbia COU Wilmington ILN FSM Iliamna ILI Wales WAA Savannah SAV San Antonio SAT Rutland RUT Muskegon MKG Milwaukee MKE Kansas City MKC Dickinson DIK Muskogee MKO Jackson MKL Lahaina JHM Jamestown JHW Anderson AID Alliance AIA Tunica UTM Kirksville IRK Jackson JAN Rock Springs RKS Sedona SDX Sidney SDY Louisville SDF Oklahoma City PWA Portland PWM Chicago PWK Anchorage MRI Boston BOS Boise BOI Sidney SXY Lynchburg LYH Wilmington ILM Brunswick BQK Pecos City PEQ Rock Hill RKH Cody COD Fort Lauderdale FLL Florence FLO Flagstaff FLG Huron HON Alamosa ALS Blountville TRI Thermal TRM Nantucket TRX East Hampton HTO Hawthorne HTH Houston HOU Huntington HTS Escanaba ESC Raleigh-Durham RDU Hot Springs HSP El Dorado ELD Redding RDD Reading RDG Ely ELY Red Dog RDB Redmond RDM El Paso ELP Lebanon LEB Leesburg LEE Lexington LEX Concord USA Kalamazoo AZO Phoenix AZA St. Augustine UST Skagway SGY Sugar Land SGR St. George SGU Springfield SGF Moab CNY Carlsbad CNM Wichita ICT Sitka SIT Montague SIY Nantucket SIK Tanana TAL Winter Haven GIF Athens AHN Augusta NPT Gunnison GUC Gallup GUP Allentown HUL Holy Cross HCR Bellingham BLI Blythe BLH Kipnuk KPN Lawrenceville LZU Elko EKO Eureka EKA Norman OUN Lufkin LFK Kalispell FCA Minneapolis FCM Fort Myers FMY Kaunakakai MKK Farmington FMN Venetie VEE Detroit YIP Vernal VEL Wainwright AIN Aiken AIK Akron CAK Columbia CAE Punta Gorda PGD Page PGA Portland PDX Ogdensburg OGS Palm Springs UDD Rochester RST Kahului OGG Fort Myers RSW New York JFK Miami MIA Altoona AOO Key West NQX Sand Point SDP Show Low SOW Imperial IPL San Francisco SFO Williamsport IPT Orlando SFB Norfolk NGU St. Mary's KSM Hayden HDN Bloomington BMG Bloomington BMI Sheridan SHR Shreveport SHV Shageluk SHX Staunton SHD Shishmaref SHH Marietta MGE Montgomery MGM Morgantown MGW Laramie LAR Waynesville TBN Cape Lisburne LUR Abingdon VJI Cincinnati LUK Great Falls GTF Panama City ECP Valentine VTN Golden Triangle GTR Tallahassee TLH Grand Canyon GCN Havre HVR Wilmington ILG Rhinelander UCA Ruby RBY Red Bluff RBL Dallas RBD North Bend OTH Ottumwa OTM Long Beach LGB New York LGA Teller TLA La Grande LGD Kotzebue OTZ Altus AXS Wapakoneta AXV Alexandria AXN Ironwood IWD Kiana IAN Houston IAH Niagara Falls IAG Point Hope PHO Port Huron PHN Philadelphia PHL New Haven HVN Newport News PHF Phoenix PHX San Antonio SKF Shaktoolik SKK McAllen MFE Medford MFR Spokane GEG Manhattan MHK Gatlinburg GKT Dodge City DDC Manchester MHT Sacramento MHR Anchorage ANC Aniak ANI Greenwood GWO Miami TMB Kingman IGM El Centro NJK Hayward HWD Augusta HES Denver BJC Wooster BJJ Bemidji BJI Hyannis HYA Hydaburg HYG South Naknek WSN Fayetteville FAY Fargo FAR Nantucket OWD Owatonna OWA Fresno FAT Owensboro OWB Fairbanks FAI Las Vegas LVS Vicksburg VKS Savoonga SVA Livermore LVK Oakland OAK Jacksonville OAJ Concord CCR Pocatello PIH Peoria PIA Hattiesburg PIB Myrtle Beach MYR Mekoryuk MYU St. Petersburg PIE Marysville MYV Mccall MYL Pilot Point PIP Pierre PIR Pittsburgh PIT Chefornak CYF Zephyrhills ZPH White Mountain WMO Winnemucca WMC Kivalina KVL Grand Junction GJT Marion MWA Denver DEN Decatur DEC Amarillo AMA Glasgow GGW Gainesville GNV Victorville VCV Nantucket ACK Brunswick NEA Bentonville XNA Kasigluk KUK Eureka ACV Waco ACT Cleveland NEW Atlantic City ACY Hartford HFD Branson BKG Buckland BKC Cleveland BKL Beckley BKW Valdez VDZ San Angelo SJT San Jose SJC Dawson GDV Memphis MEM Manteo MEO Meridian MEI Pasco PSC Lewiston LWS Youngstown YNG Lewistown LWT Lewisburg LWB Lawrence LWC Texarkana TXK Sacramento SMF Twentynine Palms TNP Tin City TNC Greenville GVT Hawthorne HHR Nantucket JEF Hilton Head Island HHH Selawik WLK Casper CPR St. Louis CPS Wrangell WRG Warner Robins WRB Wrightstown WRI Lakeland LAL Lansing LAN Lafayette LAF Lansing FFT Lamar LAA Fergus Falls FFM Los Angeles LAX Lawton LAW Las Vegas LAS Shreveport DTN Price PUC Detroit DTW Santa Barbara SBA Windsor Locks BDL Fort Worth FTW Cumberland CBE Santa Maria SMX Santa Monica SMO King Salmon SMN Bozeman BZN Carbondale-Murphysboro MDH Johnstown JST Beaumont GGG Chicago MDW Harrisburg MDT Mount Vernon MVW Martha's Vineyard MVY Dallas DFW Morrisville MVL ALO Alamogordo ALM Albany ALB Walla Walla ALW Topeka TOP Troy TOI Toledo TOL Toccoa TOC Torrance TOA Togiak Village TOG False Pass KFP Patuxent River NHK Kotlik KOT Hibbing HIB Ogden HIF Washington IAD Allentown ABE Abilene ABI Ambler ABL Brevig Mission KTS Albuquerque ABQ Aberdeen ABR Albany ABY Birmingham BHM Bar Harbor BHB Eagle EGE Lubbock LBB Latrobe LBE Rapid City RAP North Platte LBF Liberal LBL Scottsbluff BFF Bradford BFD Seattle BFI Mobile BFM Bakersfield BFL Nuiqsut NUI Key West EYW Visalia VIS Indianapolis TYQ Tyler TYR Knoxville TYS Bullhead City IFP Ocala OCF Crescent City CEC Central CEM Clemson CEU Napaskiak PKA Cortez CEZ Hagerstown HGR Columbus CSG Nantucket CSV Ketchikan KTN Sioux Falls FSD Muscatine MUT Jonesboro JBR Kamuela MUE Mountain Home MUO Astoria AST Mountain View NUQ Aspen ASE Alexandria AEX Talladega ASN Marshall ASL Dubois DUJ Juneau UNU Tucson DMA Durant DUA Unalakleet UNK Unalaska DUT Hilo ITO Omaha OMA Ithaca ITH Elim ELI Billings BIL Fort Bliss-El Paso BIF Quinhagak KWN Kwethluk KWT Bismarck BIS Salina SLN Solomon SLJ Saranac Lake SLK Salem SLE Salt Lake City SLC Orlando MCO Macon MCN McCook MCK Kansas City MCI McGrath MCG Merced MCE Grand Forks GFK Glens Falls GFL Mason City MCW Fort Huachuca Sierra Vista FHU Binghamton BGM Bangor BGR Pickens LQK Venice VNC Van Nuys VNY Grand Rapids GPZ Gulfport GPT Corpus Christi CRP Charleston CRW Frederick FDK Jacksonville CRG Napakiak WNA Houston EFD Reno RNO Lake City LCQ Miami OPF Columbus LCK Lake Charles LCH Devils Lake DVL Phoenix DVT Allentown OLF Wilkesboro IKB Nogales OLS Cold Bay CDB Cedar City CDC Cordova CDV Chadron CDR Pellston PLN Manistee MBL Pampa PPA Gambell GAM Galena GAL Gaithersburg GAI Seldovia SOV Saginaw MBS Montrose MTJ Marathon MTH Baltimore MTN Olathe JCI Watertown ART Walnut Ridge ARG Greenville-Spartanburg GSP Gustavus GST Tacoma TIW Goshen GSH Greensboro GSO Jackson HKS Arlington GKY Hoonah HNH King Cove KVC Beluga BVU Beverly BVY Bartlesville BVO Roanoke ROA Rochester ROC Columbus OSU Rogers ROG Oscoda OSC Roswell ROW New Bern EWN New Bedford EWB Stratford BDR New York EWR Laredo LRD Idaho Falls IDA Cape Girardeau CGI Vero Beach VRB Cleveland CGF Columbia CUB Chico CIC New Orleans MSY Cedar Rapids CID Chalkyitsik CIK Massena MSS Minneapolis MSP Missoula MSO Madison MSN Muscle Shoals MSL Sault Sainte Marie CIU Daggett DAG Daytona Beach DAB Dallas DAL Danville DAN Dayton DAY Houston DWH Toksook Bay OOK
Romania Bacau BCM Suceava SCV Satu Mare SUJ Cluj-Napoca CLJ Arad ARW Sibiu SBZ Oradea OMR Constanta CND Craiova CRA Bucharest OTP Timisoara TSR Iasi IAS
Angola Soyo SZA Namibe MSZ Cabinda CAB Saurimo VHC Luena LUO Menongue SPP Ngiva VPE Kuito SVP Lubango SDD Catumbela CBT Luanda LAD Huambo NOV
Chad N'Djamena NDJ
South Africa Sishen SIS Cape Town CPT Nelspruit MQP Pretoria PRY Pietermaritzburg PZB Bloemfontein BFN Johannesburg JNB Kimberley KIM Phalaborwa PHW Hoedspruit HDS Ngala NGL Skukuza SZK Polokwane PTG Londolozi LDZ Plettenberg Bay PBZ George GRJ Margate MGH Johannesburg HLA Phinda PZL East London ELS Durban DUR Sun City NTY Port Elizabeth PLZ Komatipoort KOF Richards Bay RCB Mahikeng MBD Ulusaba ULX Upington UTN Mthatha UTT
Cyprus Tymvou ECN Pafos PFO Larnaca LCA
Caribbean Netherlands Saba SAB Sint Eustatius EUX Bonaire BON
Malaysia Johor Bahru JHB Long Akah LKH Bario BBN Mukah MKM Tawau TWU Kuala Lumpur KUL Kudat KUD Lawas LWY Kuantan KUA Miri MYY Labuan LBU Kuala Lumpur SZB Bakalalan BKM Kota Kinabalu BKI Malacca MKZ Marudi MUR Alor Setar AOR Lahad Datu LDU Kota Bharu KBR Kuala Terengganu TGG Long Seridan ODN Kerteh KTE Belaga BLG Bintulu BTU Langkawi LGK Mulu MZV Sibu SBW Long Datih LGL Ipoh IPH Kuching KCH Limbang LMN Penang PEN Sandakan SDK
Austria Linz LNZ Vienna VIE Graz GRZ Salzburg SZG Klagenfurt KLU Innsbruck INN
Mozambique Maputo MPM Chimoio VPY Beira BEW Pemba POL Tete TET Nacala MNC Vilankulo VNX Nampula APL Quelimane UEL Lichinga VXC Inhambane INH
Uganda Entebbe EBB Arua RUA Uganda PAF
Hungary Budapest BUD Debrecen DEB
Niger Niamey NIM
Brazil Marilia MII Cacoal OAL Uruguaiana URG Campina Grande CPV Paulo Afonso PAV Rio Verde RVD Vilhena BVH Ilheus IOS Pelotas PET Joinville JOI Aracaju RIA OPS Chapeco XAP Rio de Janeiro GIG Bonito BYO Lages LAJ Ipatinga IPN BVB Maraba MAB Teresina THE Uberaba UBA Caxias do Sul CXJ Juazeiro Do Norte JDO Carajas CKS Belem BEL Corumba CMG Vitoria Da Conquista VDC Florianopolis FLN Londrina LDB Rondonopolis ROO Rio de Janeiro SDU Petrolina PNZ Tres Lagoas TJL Alta Floresta AFL Foz do Iguacu IGU Sao Paulo GRU Rio Branco RBR Sao Luis SLZ Divinopolis DIQ Vitoria VIX Campinas VCP Navegantes NVT Maringa MGF Cruzeiro do Sul CZS Manaus MAO Tabatinga TBT Riberao Preto RAO Salvador SSA Uberlandia UDI Natal NAT Altamira ATM Recife REC Dourados DOU Sao Paulo CGH Palmas PMW Teixeira de Freitas TXF Cuiaba CGB Bauru JTC Porto Velho PVH Campo Grande CGR Brasilia BSB Fernando De Noronha FEN Campos dos Goytacazes CAW Passo Fundo PFB Araguaina AUX Caldas Novas CLV Tefe TFF Belo Horizonte PLU Lencois LEC Barreiras BRA Barra Do Garças BPG Porto Seguro BPS Cascavel CAC Araxa AAX Fortaleza FOR Presidente Prudente PPB Goiania GYN Sao Jose Do Rio Preto SJP Porto Alegre POA Juiz de Fora IZA Santarem STM Aracaju AJU Belo Horizonte CNF Montes Claros MOC Governador Valadares GVR Curitiba CWB Aracatuba ARU Imperatriz IMP Joao Pessoa JPA Varginha VAG Cabo Frio CFB Maceio MCZ Ji-Parana JPR Macapa MCP
Faroe Islands Vagar FAE
Kuwait Kuwait City KWI
Panama Chitré CTD Panama City PAC Isla Colón BOC David DAV Panama City PTY Rio Hato RIH Changuinola CHX Balboa BLB Puerto Obaldia PUE
Guyana Georgetown OGL Georgetown GEO
Costa Rica Tambor TMU Puerto Limon LIO Golfito GLF Liberia LIR Quepos XQP TNO Roxana TTQ Palmar Sur PMZ La Fortuna-San Carlos FON Puerto Jimenez PJM Nicoya NOB San Jose SYQ San Jose SJO
Luxembourg Luxembourg LUX
American Samoa Pago Pago PPG
Bahamas Spring Point AXP Bahamas RCY Bahamas CCZ Nassau NAS Stella Maris SML San Salvador ZSA Governor's Harbour GHB Cascais NET George Town GGT South Bimini BIM Treasure Cay TCB South Andros TZN North Eleuthera ELH Rock Sound RSD Marsh Harbour MHH Freeport FPO Matthew Town IGA Cascais CAT San Andros SAQ Bahamas TYM Deadmans Cay LGI The Bight TBI
British Virgin Islands Anegada NGD Beef Island EIS Virgin Gorda VIJ
Gibraltar Gibraltar GIB
Ireland Donegal CFN Knock NOC Shannon SNN Kerry KIR Dublin DUB Cork ORK
Italy Lamezia Terme SUF Florence FLR Rome CIA Treviso TSF Brescia VBS Naples NAP Catania CTA Milan BGY Comiso CIY Perugia PEG Cagliari CAG Reggio Calabria REG Olbia OLB Taranto TAR Turin TRN Ancona AOI Parma PMF Genoa GOA Venice VCE Palermo PMO Milan LIN Pantelleria PNL Bologna BLQ Cuneo CUF Trapani TPS Brindisi BDS Trieste TRS Rimini RMI Elba EBA Lampedusa LMP Pisa PSA Alghero AHO Milan MXP Verona VRN Bari BRI Pescara PSR Rome FCO
Nigeria Akure AKR Lagos LOS Ilorin ILR Sokoto SKO Maiduguri MIU Owerri QOW Ibadan IBA Warri QRW Asaba ABB Yola YOL Benin BNI Jos JOS Enugu ENU Abuja ABV Kaduna KAD Port Harcourt PHC Kano KAN Calabar CBQ Uyo QUO
Ecuador La Toma (Catamayo) LOH Guayaquil GYE Quito UIO San Cristobal SCY Galapagos GPS Coca OCC Cuenca CUE Esmeraldas ESM Salinas SNC Manta MEC Lago Agrio LGQ
Bangladesh Dhaka DAC Saidpur SPD Cox's Bazar CXB Jessore JSR Chittagong CGP Barisal BZL Sylhet ZYL Rajshahi RJH
Brunei Brunei BWN
Australia West Angelas WLP Coober Pedy CPD Burnie BWT Australia FIZ Parkes PKE Barimunya BYP Monkey Mia MJK Albany ALH Mungeranie MNE Port Macquarie PQQ Australia CMA Townsville TSV Australia EDR Launceston LST Lismore LSY Wagga Wagga WGA Australia CBI Canberra CBR Charleville CTL Cooktown CTN Gladstone GLT Aurukun AUU Port Augusta PUG Australia MMM Newcastle NTL Normanton NTN Australia MMG SYD Devonport DPO Hayman Island HIS Mornington ONG Cloudbreak KFE Horn Island HID Mackay MKY Orange OAG Onslow ONS Bamaga ABM Katherine KTR Albury ABX Australia HGD Karratha KTA Broken Hill BHQ BHS Coffs Harbour CFS Merimbula MIM King Island KNS Toowoomba WTB Proserpine PPP Moree MRZ Ayers Rock AYQ Dubbo DBO Boolgeeda OCM Ceduna CED Broome BME Mount Gambier MGB Australia WUN Whyalla WYA Mount Isa ISA Alice Springs ASP Mudgee DGE Leonora LNO Roma RMA Australia JCK Australia CMD Groote Eylandt GTE Australia GTS Hervey Bay HVB Palm Island PMK Argyle GYL Kowanyama KWM Narrandera NRA Grafton GFN Sunshine Coast MCY McArthur River Mine MCV Griffith GFF Lord Howe Island LDH Mildura MQL Hobart HBA Weipa WEI Ballina BNK Kununurra KNX Brisbane BNE Nifty NIF Port Hedland PHE Winton WIN Phosphate Hill PHQ Emerald EMD Doomadgee DMD Bunbury BUY Geraldton GET Australia BUC Tennant Creek TCA Castro MHC Moranbah MOV Moomba MOO Barcaldine BCI Perth PER Olympic Dam OLP Karumba KRB Port Lincoln PLO Carnarvon CVQ Meekathara MKR Australia CVC Newman ZNE Laverton LVO Australia IRG Armidale ARM Narrabri NAA Esperance EPR Darwin DRW Horn Island TIS Chinchilla CCL Tamworth TMW Moruya MYA Busselton BQB Australia BQL Mount Keith WME Flinders Island FLS Rockhampton ROK Australia CAZ Maningrida MNG Taree TRO Bundaberg BDB Coondewanna CJF Paraburdoo PBO Longreach LRE Melbourne AVV Hamilton Island HTI Gove GOV Telfer TEF Blackall BKQ Australia CUQ Monkey Mia DNM Elcho Island ELC Adelaide ADL Learmonth LEA Essendon MEB Melbourne MEL Australia XTO Leinster LER St George SGO Cairns CNS Cloncurry CNJ Cooma OOM Gold Coast OOL Kingscote KGC Kalgoorlie KGI
Iran Urmia OMH Abu Musa Island AEU Yazd AZD Mahshahr MRX Gorgan GBT Birjand XBJ Hamadan HDM Qeshm Island GSM Isfahan IFN Dezful DEF Bushehr BUZ Ahvaz AWZ Lamerd LFM Kermanshah KSH Tehran IKA Assaluyeh PGU Chabahar ZBR Tabriz TBZ Ilam IIL Khorramabad KHD Rasht RAS Ardabil ADU Abadan ABD Mashhad MHD Bandar Lengeh BDH Shiraz SYZ Araak AJK Iran RZR Sabzevar AFZ Sari SRY Bandar Abbas BND Assaluyeh YEH Bojnord BJB Zahedan ZAH Iran NSH Tehran THR Sanandaj SDG Kish Island KIH Lar LRR Kerman KER
Algeria Annaba AAE Tamanrasset TMR Timimoun TMX Jijel GJL Ghardaia GHA Tiaret TID Adrar AZR Touggourt TGR Illizi VVZ Tébessi TEE Bordj Badji Mokhtar BMW Biskra BSK Hassi Messaoud HME Aménas IAM Algeria ELG Laghouat LOO Djanet DJG Batna BLJ Tlemcen TLM Guemar ELU Mecheria MZW In Salah INZ Bejaia BJA Algiers ALG Béchar CBH Ouargla OGX Tindouf TIN Oran ORN Constantine CZL Setif QSF
El Salvador San Salvador SAL
Tuvalu Funafuti FUN
Czech Republic Prague PRG Ostrava OSR Brno BRQ Karlovy Vary KLV
Marshall Islands Kwajalein KWA Majuro MAJ
Chile Copiapo CPO Iquique IQQ Concepcion CCP Santiago SCL La Serena LSC Puerto Williams WPU Porvenir WPR Calama CJC Valdivia ZAL Balmaceda BBA Osorno ZOS Mataveri IPC Antofagasta ANF Temuco ZCO Puerto Montt PMC Arica ARI Punta Arenas PUQ
Puerto Rico Isla De Culebra CPX Mayaguez MAZ Aguadilla BQN Vieques VQS Ponce PSE SIG SJU
Belgium Medan KNO Kortrijk KJK Brussels BRU Liege LGG Antwerp ANR Ostend OST Brussels CRL
Kiribati Kiritimati CXI Tarawa TRW
Haiti Port-au-Prince PAP Cap-Haitien CAP
Belize San Pedro SPR Belize City BZE
Hong Kong Hong Kong HKG
Sierra Leone Freetown FNA Bo KBS
Georgia Batumi BUS Tbilisi TBS Kutaisi KUT
Gambia Banjul BJL
Philippines Surigao SUG Tagbilaran City TAG Davao City DVO Virac VRC Bacolod City BCD Pagadian
PAG Butuan BXU Busuanga USU Tawitawi TWT Angeles City CRK Dipolog DPL Catarman CRM General Santos GES Puerto Princesa City PPS Calbayog CYP Philippines CGM Cebu CEB Cuyo CYU Cauayan City CYZ Cagayan de Oro CGY Naga WNP Basco BSO Manila MNL Dumaguete City DGT Iloilo ILO Masbate MBT Philippines TDG Zamboanga ZAM Kalibo KLO Roxas City RXS Ormoc City OMC Laoag City LAO Ozamiz OZC Cotabato CBO Caticlan MPH Romblon TBH San Jose SJI Tacloban TAC Legazpi LGP Tuguegarao TUG
Moldova Chisinau KIV
French Guiana Cayenne CAY
Morocco Casablanca CMN Guelmim GLN Agadir AGA Errachidia ERH Marrakesh  RAK Tetuan TTU Oujda OUD Tan Tan TTA Essaouira ESU Al Hoceima AHU Tangier TNG Nador NDR Fes FEZ Rabat RBA Zagora OZG Ouarzazate OZZ
Namibia Windhoek ERS Windhoek WDH Luderitz LUD Ondangwa OND Walvis Bay WVB Rundu NDU Mpacha MPA Karasburg KAS Oranjemund OMD
French Polynesia Arutua AXR Fakarava FAV Tikehau TIH Makemo MKP Mataiva MVT Bora Bora BOB Huahine HUH Ua Huka UAH Nuku Hiva NHV French Polynesia TKP Papeete PPT Takaroa TKX Raiatea RFP Manihi XMH Hao HOI Atuona AUQ Rangiroa RGI Totegegie GMR Moorea MOZ Maupiti MAU Ahe AHE Apataki APK Ua Pou UAP French Polynesia RUR French Polynesia TUB
Guinea-Bissau Bissau OXB
Thailand Loei LOE Thailand NAK Koh Samui USM Bangkok DMK Hat Yai HDY Narathiwat NAW Nakhon Phanom KOP Trang TST Roi Et ROI Phrae PRH Chiang Rai CEI Bangkok BKK Nakhon Pathom KDT Nan NNT Nakhon Si Thammarat NST Chumphon CJM Udon Thani UTH Lampang LPT Sukhothai THS Chiang Mai CNX Thailand HGN Rayong UTP Buriram BFV Phuket HKT Ranong UNN Mae Sot MAQ Surat Thani URT Hua Hin HHQ Ubon Ratchathani UBP Krabi KBV Trat TDX Sakon Nakhon SNO Phitsanulok PHS Khon Kaen KKC
Switzerland St. Gallen ACH Geneva GVA Bern BRN Lugano LUG Zurich ZRH
Grenada Point Salines GND
Cote D'ivoire (Ivory Coast) Bingol BGG Ivory Coast SPY Abidjan ABJ Ouango Fitini OFI Ivory Coast HGO Ivory Coast BYK
U.S. Virgin Islands St. Thomas STT St. Croix STX
Seychelles Praslin Island PRI SEZ
Portugal Portugal BGC Corvo CVU FLW Funchal FNC Lisbon LIS Santa Maria SMA Portimao PRM Pico PIX Porto Santo PXO Faro FAO Lajes TER Vila Real VRL Sao Jorge SJZ Graciosa GRW Ponta Delgada PDL Viseu VSE Horta HOR Porto OPO
Estonia Kardla KDL Kuressaare URE Tartu TAY Tallinn TLL
Uruguay Maldonado MDO Montevideo MVD Riohacha RCH Punta del Este PDP
Equatorial Guinea Malabo SSG Bata BSG
Lebanon Beirut BEY
Uzbekistan Fergana FEG Bukhara BHK Karshi KSQ Andizhan AZN Tashkent TAS Urgench UGC Nukus NCU Samarkand SKD Namangan NMA Termez TMJ Navoiy NVI
Egypt Alexandria HBE Cairo CAI Aswan ASW Assiut ATZ Marsa Alam RMF Sohag HMB Abu Simbel ABS Hurghada HRG Luxor LXR Sharm el-Sheikh SSH
Falkland Islands (Malvinas) Mount Pleasant MPN
Rwanda Kamembe KME Kigali KGL Gisenyi GYI
Timor-Leste Dili DIL
Spain Valladolid VLL Barcelona BCN Lanzarote ACE Lleida ILD Reus REU Ibiza IBZ Fuerteventura FUE El Hierro VDE Tenerife TFS Malaga AGP Bilbao BIO Vigo VGO Valencia VLC Vitoria VIT La Palma SPC Santiago SCQ Palma de Mallorca PMI Madrid MAD Morón OZP Melilla MLN Granada GRX La Gomera GMZ Murcia MJV Jerez XRY Girona GRO San Sebastian EAS Las Palmas LPA Seville SVQ Tenerife TFN Santander SDR Almeria LEI Alicante ALC Leon LEN Castellon de la Plana CDT A Coruna LCG Zaragoza ZAZ Asturias OVD Pamplona PNA Mahon MAH Logrono RJL Badajoz BJZ
Colombia Bucaramanga BGA Medellin EOH Armenia AXM Quibdo UIB Saravena RVE Nuquí NQU Puerto Inírida PDA Guapi GPI Yopal EYP Puerto Leguízamo LQM Ipiales IPI Apartado APO Manizales MZL Pereira PEI Valledupar VUP Puerto Carreño PCR Cartago CRC Florencia FLA Tumaco TCO Buenaventura BUN Pitalito PTX Bogota BOG Villagarzon VGZ Pasto PSO Corozal CZU Neiva NVA Santa Marta SMR Cartagena CTG Tame TME Medellin MDE Bahía Solano BSC Mitú MVP Arauca AUC Cali CLO Tolú TLU San Andres Island ADZ Cucuta CUC San José Del Guaviare SJE Villavicencio VVC Leticia LET Puerto Asis PUU Barranquilla BAQ Ibague IBE Cartago SQB Popayan PPN Monteria MTR Barrancabermeja EJA
Reunion St Pierre ZSE Saint-Denis RUN
Burundi Bujumbura BJM
Taiwan Sorriso SMT Taipei TSA Taichung RMQ Hualien HUN Beigan Island MFK Taitung TTT Kaohsiung KHH Chiayi City CYI Taipei TPE Kinmen KNH Tainan TNN Makung MZG Nangan LZN
Turks and Caicos Islands Cockburn Town GDT Providenciales PLS Turks and Caicos Islands XSC
Barbados Bridgetown BGI
Qatar Doha DOH
Palau Airai ROR
Curacao Willemstad CUR
Bhutan Paro PBH
Sudan Kosti KST Port Sudan PZU Geneina EGN El Fasher ELF Dongola DOG Khartoum KRT Nyala UYL Al-Ubayyid EBD Merowe MWE Kassala KSL Ad Damazin RSS
Nepal Lukla LUA Simara SIF Tumling Tar TMI Pokhara PKR Janakpur JKR Bhairawa BWA Jomsom JMO Biratnagar BIR Dhangarhi DHI Kathmandu KTM Bhadrapur BDP Bharatpur BHR Nepalgunj KEP
São Tomé and Principe São Tomé and Principe PCP Sao Tome TMS
Micronesia Pohnpei PNI Kosrae KSA Chuuk TKK Yap YAP
Netherlands Groningen GRQ Maastricht MST Rotterdam RTM Amsterdam AMS Eindhoven EIN
Bosnia And Herzegovina Sarajevo SJJ Banja Luka BNX Mostar OMO Tuzla TZL
Suriname Paramaribo PBM
Anguilla The Valley AXA
Venezuela Caracas CCS Maturin MUN Valencia VLN Venezuela SOM Puerto Ordaz PZO Paraguaná LSP Venezuela LFR STD Barinas BNS Porlamar PMV Venezuela CUM Barcelona BLA Maracaibo MAR El Vigía VIG Venezuela PYH Barquisimeto BRM Los Roques LRV Coro CZE
Israel Tel Aviv TLV Tel Aviv SDV Eilat VDA Haifa HFA Eilat ETH
Indonesia Roti-Rote Island RTI Tahuna-Sangihe Island NAH Sorong SOQ Lhokseumawe LSW Blimbingsari BWX Luwuk LUW Tarakan TRK Labuan Bajo LBJ Palu PLW Wamena WMX Semarang SRG Ranai-Natuna Besar Island NTX Kaimana-Papua Island KNG Jambi DJB Jayapura DJJ Timika TIM Tambolaka TMC Kao-Celebes Island KAZ Sintang SQG Kalimarau BEJ Sibolga FLZ Yogyakarta JOG Padang Sidempuan-Sumatra Island AEG Buol-Celebes Island UOL Bandar Lampung TKG Satar Tacik-Flores Island RTG Pekanbaru PKU Palangkaraya PKY Bau-Bau BUW Ternate TTE Bima BMU Ambon AMQ Karakelong Island MNA Pangkalan Bun PKN Kotabaru KBU Ende ENE Makassar UPG Bandung BDO Banjarmasin BDJ Nabire-Papua Island NBX Waingapu WGP Poso-Celebes Island PSJ Batu Licin-Borneo Island BTW Jakarta HLP Tanjung Pandan TJQ Tanjung Selor-Borneo Island TJS Oksibil-Papua Island OKL Batam BTH Atambua ABU Saumlaki-Yamdena Island SXK Surabaya SUB Langgur LUV Dobo-Kobror Island DOB Sampit Airport SMQ Galela-Celebes Island GLX Jakarta CGK Ketapang KTG Kendari KDI Manado MDC Bengkulu BKS Dumai-Sumatra Island DUM Gotalalamo-Morotai Island OTI Samarinda SRI Toli Toli-Celebes Island TLI Larantuka LKA Putussibau-Borneo Island PSU Bajawa BJW Peureumeue-Sumatra Island MEQ Sabang-We Island SBG Palembang PLM Gunung Sitoli GNS Denpasar DPS Matak Island MWK Kupang KOE Balikpapan BPN Manokwari MKW Lombok LOP Sumbawa Besar SWQ Babo-Papua Island BXB Surakarta SOC Biak BIK Pangkal Pinang PGK Padang PDG Malang MLG Fakfak-Papua Island FKQ Gorontalo GTO Tanjung Pinang TNJ Merauke-Papua Island MKQ Namrole-Buru Island NRE Maumere MOF Pontianak PNK Alor Island ARD Banda Aceh BTJ
Iceland Akureyri AEY Gjögur GJR Hofn HFN Isafjordur IFJ Reykjavik RKV Egilsstadir EGS Sudureyri SUY Bildudalur BIU Vopnafjordur VPN Husavik HZK Grimsey GRY Thorshofn THO Vestmannaeyjar VEY Reykjavik KEF
Zambia Kasama KAA Kalabo KLB Livingstone LVI Mongu MNR Ndola NLA Mfuwe MFU Solwesi SLI Kasompe ZKP Lusaka LUN
Senegal Dakar DKR Cap Skirring CSK Kolda KDA Ziguinchor ZIG
Papua New Guinea Papua New Guinea VAI Lae LAE Madang MAG Gurney GUR Moro MXH Papua New Guinea MDU Mount Hagen HGU Popondetta PNP Tokua RAB Papua New Guinea MAS Tabubil TBG Londolovit LNV Port Moresby POM Kiunga UNG Bulolo BUL Buka Island BUA Goronka GKA Wewak WWK Hoskins HKN Papua New Guinea WBM Tari TIZ Daru DAU
Zimbabwe Bulawayo BUQ Victoria Falls VFA Harare HRE
Jordan Amman AMM Aqaba AQJ
Vanuatu Longana LOD Craig Cove CCV Loh-Linua TOH Port Vila VLI Norsup NUS Luganville SON Lonorore LNE Tongoa Island TGH Vanuatu TAH Lamen Bay LNB Ablow MTV Gaua Island ZGU FTA Sola SLH Dillon's Bay DLY Walaha WLH Pentecost Island SSR
Martinique Fort-de-France FDF
Kazakhstan Taraz DMB Aktobe AKX Astana TSE Zhezkazgan DZN Atyrau GUW Shymkent CIT Almaty ALA Kokshetau KOV Aktau SCO Kostanay KSN Petropavlosk PPK Oral URA Pavlodar PWQ Semipalatinsk PLX Karaganda KGF Oskemen UKK Kyzylorda KZO
Poland Szczecin SZZ Rzeszow RZE Poznan POZ Lublin LUZ Katowice KTW Bydgoszcz BZG Krakow KRK Warsaw WMI Olsztyn SZY Zielona Gora IEG Wroclaw WRO Warsaw WAW Radom RDO Lodz LCJ Gdansk GDN
Mauritania Zouérate OUZ Nouadhibou NDB Nouakchott NKC
Kyrgyzstan Osh OSS Bishkek FRU
Mayotte Dzaoudzi DZA
Iraq Sulaimaniyah ISU Najaf NJF Arbil EBL Basra BSR Baghdad SDA Baghdad BGW
Montserrat Plymouth MNI
New Caledonia Maré MEE Lifou LIF Koumac KOC Ouvea UVE Noumea GEA Touho TOU Ile Des Pins ILP Noumea NOU Tiga TGJ Koné KNQ
Andorra
North Korea Pyongyang FNJ
Paraguay Asuncion ASU Ciudad del Este AGT
Latvia Riga RIX
South Sudan Juba JUB
Japan Akita AXT Amakusa AXJ Saga HSG Japan IWO Iwakuni IWK Masuda IWJ Matsuyama MYJ Hakodate HKD Hachijojima HAC Osaka KIX Hiroshima OIM Sakata SYO Niigata KIJ Japan OIR Ube UBJ Tsushima TSJ Nagoya NGO Nagasaki NGS Fukue FUJ Fukuoka FUK Tokunoshima TKN Tottori TTJ Tokushima TKS Tarama TRA Kumejima UEO Nakashibetsu SHB Nanki Shirahama SHM Yoronjima RNJ Oita OIT Japan KKX Tajima TJH Naha OKA Japan OKE Sapporo OKD Kitakyushu KKJ Okinoshima OKI Okayama OKJ Nankoku KCZ Hanamaki HNA Tokyo HND Sapporo CTS Kumamoto KMJ Miyazaki KMI Aomori AOJ Asahikawa AKJ Yakushima KUM Toyama TOY Komatsu KMQ Kushiro KUH Shizuoka FSZ Ishigaki ISG Amami ASJ Iki IKI Obihiro OBO Osaka ITM Miyako MMY Wajima NTQ Matsumoto MMJ Japan MMD Takamatsu TAK Memanbetsu MMB Kagoshima KOJ Yonago YGJ Misawa MSJ Omitama IBR Kobe UKB Kitaakita ONJ Monbetsu MBE Yamagata GAJ Hiroshima HIJ Izumo IZO Japan TNE Japan KTD Sukagawa FKS Wakkanai WKJ Nagoya NKM Japan OGN Sendai SDJ Tokyo NRT
Croatia Zadar ZAD Split SPU Osijek OSI Pula PUY Zagreb ZAG Bol BWK Rijeka RJK Dubrovnik DBV
Syria Al-Qamishli KAC Damascus DAM
Guadeloupe Pointe-a-Pitre PTP
Burma Sittwe AKY Mawlamyine MNU Kalemyo KMV Loikaw LIW Qinhuangdao BPE Yangon RGN Dawei TVY Mandalay MDL Banmaw BMO Lashio LSH Kanti KHM Kyaukpyu KYP Putao PBU Tachilek THL Qinhuangdao NYU Heho HEH Hommalinn HOX Thandwe SNW Kawthaung KAW Manaung MGU Myeik MGZ Kengtung KET Myitkyina MYT
Honduras Roatan RTB Utila Island UII Puerto Lempira PEU San Pedro Sula SAP Comayagua XPL Tegucigalpa TGU La Ceiba LCE
Malta Luqa MLA
Mexico Poza Rica PAZ Campeche CPE Tijuana TIJ Aguascalientes AGU Oaxaca OAX Culiacan CUL Tapachula TAP Tampico TAM Merida MID Tepic TPQ Zihuatanejo ZIH Mazatlan MZT Matamoros MAM Guerrero Negro GUB Ciudad del Carmen CME Ciudad Obregon CEN Hermosillo HMO Nuevo Laredo NLD Huatulco HUX Uruapan UPN Torreon TRC Atlantic City BLM Puebla PBC Ciudad Juarez CJS LAP Mexicali MXL Lázaro Cárdenas LZC Acapulco ACA Chetumal CTM Puerto Vallarta PVR Durango DGO ZLO Chihuahua CUU Veracruz VER Piedras Negras PDS Cozumel CZM Mexico City TLC Ciudad Constitución CUA Cancun CUN Loreto LTO Colima CLQ San Jose del Cabo SJD Los Mochis LMM Guadalajara GDL Mexico City MEX Silao BJX Ciudad Victoria CVM Mexico CVJ Tuxtla Gutierrez TGZ Guaymas GYM Queretaro QRO Puerto Escondido PXM Monterrey MTY Reynosa REX Saltillo SLW San Luis Potosi SLP Minatitlan MTT Morelia MLM Zacatecas ZCL Villahermosa VSA
Tunisia Tozeur TOE Djerba DJE Tunis TUN Monastir MIR Enfidha NBE Sfax SFA
Nicaragua Bonanza BZA Siuna SIU San Carlos NCR Bluefileds BEF Managua MGA Waspam WSP Puerto Cabezas PUZ
Singapore Singapore SIN
Serbia Nis INI Belgrade BEG Kristianstad KID
Comoros Moroni HAH Ouani AJN Comoros NWA
United Kingdom Bournemouth BOH Exeter EXT Prestwick PIK Newquay NQY Lydd LYX Leeds LBA Glasgow GLA Southampton SOU Papa Westray WRY Belfast BFS Stronsay SOY Liverpool LPL LHR Xiahe GXH Norwich NWI Stornoway SYY Manchester MAN East Midlands EMA Benbecula BEB Lakenheath LKZ Chester CEG Burtonwood BUT Sumburgh LSI Anglesey VLY Londonderry LDY Humberside HUY Tiree TRE Oxford OXF Doncaster DSA Cambridge CBG Inverness INV LCY Kirkwall KOI Isles Of Scilly ISC Coll Island COL Islay ILY Southend SEN Dundee DND Sanday NDY LTN WIC Edinburgh EDI Bristol BRS Barra BRR Lands End LEQ Darlington MME North Connel OBN Coventry CVT Campbeltown CAL Papa Westray PPW STN Cardiff CWL Aberdeen ABZ North Ronaldsay NRL Belfast BHD Birmingham BHX Newcastle NCL LGW
Trinidad And Tobago Port of Spain POS Scarborough TAB
Antarctica
Congo Kindu KND Brazzaville BZV Makabana KMK Congo BUX Congo BKY Kisangani FKI Mbandaka MDK Mbuji Mayi MJM Gemena GMA Congo FMI Kinshasa FIH Goma GOM Pointe Noire PNR Kananga KGA Lubumbashi FBM Kasongo Lunda KGN
Greece Skyros SKU Paros PAS Samos SMI Sitia JSH Athens ATH Thessaloniki SKG Alexandroupolis AXD Kastoria KSO Kasos Island KSJ Karpathos AOK Skiathos JSI Kalymnos JKL Mykonos JMK Chios JKH Preveza PVK Syros Island JSY Ioannina IOA Astypalaia Island JTY Zakynthos ZTH Heraklion HER Ikaria JIK Milos MLO Mytilene MJT Chania CHQ Kefalonia EFL Santorini JTR Kalamata KLX Kastelorizo Island KZS Kos KGS Kozani KZI Lemnos LXS Kavala KVA Naxos JNX Patras GPA Kithira KIT Leros LRS Rhodes RHO Corfu CFU
Sri Lanka Colombo CMB Sigiriya GIU Hambantota HRI
Fiji Nadi NAN Suva SUV Labasa LBS Rotuma RTA Matei TVU Kandavu KDV Bijie BFJ Savusavu SVU Koro Island KXF
Botswana Gaborone GBE Kasane BBK Maun MUB Francistown FRW

In [78]:

    

print len(citycoords),len(error),len(clustercoords),len(cerror)


    

    




0 0 0 0

In [86]:

    

citysave=json.loads(file('../json/citysave.json','r').read())


    

In [57]:

    

for i in citycoords:
    citysave[i]['coords']=citycoords[i][0].coordinates
    citysave[i]['country']=citycoords[i][0].country


    

In [58]:

    

file("../json/citysave2.json",'w').write(json.dumps(citysave))


    

In [108]:

    

#load if saved
citysave=json.loads(file('../json/citysave2.json','r').read())


    

In [109]:

    

cities=set()
for c in SC:
    for i in SC[c]:
        cities.add(i)


    

In [110]:

    

for i in set(citysave.keys()):
    if i not in cities:
        print i,
        citysave.pop(i)


    

    




BEM YBS GBB VLS VBV RZS PNT JOK CHN JAL JAA DBA GCI RMN BBO AWD OHO MOG KMA YRQ YRV IOM RVT PBJ TEU DNA SEB EAE RKE KLH EOI VAL SCT JER AKF ENF ATD SWJ GHT YKZ COG PWE YDN YDL YVC SVR LKB KCF ICI AJY MJC JIN KBG BLK DKS ZND AOE IPA SFD YZU YTM YTA YHA KEO KEE KEQ PHB NVK YYL MYG WMN KCJ ACI HZP LAH IUE ACR CBL BZZ NTT KOU LPM CSH CSA FEC KWZ SLX YLH GLO CRI RNA CDP GAF GAE MTW LIQ NNB KMN KVG BDN KRZ SRK ULP ULB

In [117]:

    

for i in citysave:
    citysave[i]['city']=cluster[i]


    

In [118]:

    

file("../json/citysave3.json",'w').write(json.dumps(citysave))


    

In [178]:

    

I3=json.loads(file('../json/I3.json','r').read())
cnc_path='../../universal/countries/'
cnc=pd.read_csv(cnc_path+'cnc.csv',header=1).set_index('ISO2')


    

In [179]:

    

cnc


    

    
Out[179]:






  

    

      

      
AF
      
AL
      
DZ
      
AS
      
AD
      
AO
      
AI
      
AQ
      
AG
      
AR
      
...
      
UY
      
UZ
      
VU
      
VE
      
VN
      
WF
      
EH
      
YE
      
ZM
      
ZW
    
    

      
ISO2
      

      

      

      

      

      

      

      

      

      

      

      

      

      

      

      

      

      

      

      

      

    
  
  

    

      
pretty
      
Afghanistan
      
Albania
      
Algeria
      
American Samoa
      
Andorra
      
Angola
      
Anguilla
      
Antarctica
      
Antigua & Barbuda
      
Argentina
      
...
      
Uruguay
      
Uzbekistan
      
Vanuatu
      
Venezuela
      
Vietnam
      
Wallis & Futuna
      
Western Sahara
      
Yemen
      
Zambia
      
Zimbabwe
    
  

1 rows × 227 columns

In [137]:

    

for i in citysave:
    country=citysave[i]['country']
    if country==None:print i,citysave[i]['city']
    #citysave[i]['iso2']=cnc.loc['ISO2'][country]
    #citysave[i]['pretty']=cnc.loc['pretty'][country]


    

    




IXJ Jammu
IXL Leh
PRN Pristina
AWK Wake Island
SXR Srinagar
KDU Skardu
GIL Gilgit

In [140]:

    

#manual fix
citysave['IXJ']['country']='India'
citysave['IXL']['country']='India'
citysave['PRN']['country']='Kosovo'
citysave['AWK']['country']='United States'
citysave['SXR']['country']='India'
citysave['KDU']['country']='Pakistan'
citysave['GIL']['country']='Pakistan'


    

In [157]:

    

for c in SC:
    for i in SC[c]:
        if i in citysave:
            if citysave[i]['country']!=c:
                citysave[i]['country']=c
                print i,citysave[i]['city'],':',citysave[i]['country'],c


    

In [180]:

    

for i in citysave:
    country=I3[citysave[i]['country']]
    citysave[i]['iso2']=country
    citysave[i]['pretty']=cnc.loc['pretty'][country]


    

In [181]:

    

file("../json/citysave4.json",'w').write(json.dumps(citysave))


    

In [182]:

    

unicities={}
for i in cluster:
    if cluster[i] not in unicities:
        unicities[cluster[i]]=citysave[i]['country']
citycoords={}
for i in cluster:
    if cluster[i] not in citycoords:
        citycoords[citysave[i]['city']]=citysave[i]['coords']


    

In [183]:

    

file('../json/citycoords.json','w').write(json.dumps(citycoords))
file('../json/unicities.json','w').write(json.dumps(unicities))


    

In [195]:

    

print len(citysave),len(citycoords)


    

    




3749 3414