Airline Mogul Forum
Airline Mogul => Game Data => Topic started by: Air Elbonia on February 28, 2008, 05:46:47 pm
-
Alright:
PLEASE READ IN FULL AND KEEP SIDE CONVERSATIONS TO A MINIMUM
So, it has been suggested we get rick-rolling on these geopolitical subdivisions. In an effort to be fair and comprehensive I'm going to make this thread to enable anyone who wish to help gather some basic data in a quick and easy way for me, rick, or someone else to use, for every [or most every] country in the world:
Current List of outstanding countries
5 American Samoa
8 Antarctica
12 Aruba
20 Belarus
21 Belgium
22 Belize
23 Benin
24 Bermuda
25 Bhutan
26 Bolivia
27 Bosnia and Herzegovina
28 Botswana
30 Brazil
32 Brunei Darussalam
33 Bulgaria
34 Burkina Faso
35 Burundi
37 Cameroon
38 Canada
39 Cape Verde
40 Cayman Islands
41 Central African Republic
42 Chad
43 Chile
45 Christmas Island
46 Cocos (Keeling) Islands
47 Colombia
48 Comoros
49 Congo
50 Congo, the Democratic Republic of the
51 Cook Islands
52 Costa Rica
53 Cote d'Ivoire
55 Cuba
56 Cyprus
58 Denmark
59 Djibouti
60 Dominica
61 Dominican Republic
62 Ecuador
63 Egypt
64 El Salvador
65 Equatorial Guinea
66 Eritrea
67 Estonia
68 Ethiopia
70 Faroe Islands
71 Fiji
72 Finland
73 France
74 French Guiana
75 French Polynesia
77 Gabon
78 Gambia
79 Georgia
80 Germany
81 Ghana
82 Gibraltar
83 Greece
84 Greenland
85 Grenada
86 Guadeloupe
87 Guam
88 Guatemala
89 Guernsey
92 Guyana
93 Haiti
96 Honduras
97 Hong Kong
98 Hungary
99 Iceland
100 India
101 Indonesia
102 Iran, Islamic Republic of
103 Iraq
105 Isle of Man
107 Italy
108 Jamaica
109 Japan
110 Jersey
111 Jordan
112 Kazakhstan
113 Kenya
114 Kiribati
115 Korea, Democratic People's Republic of
116 Korea, Republic of
117 Kuwait
118 Kyrgyzstan
120 Latvia
121 Lebanon
122 Lesotho
123 Liberia
124 Libyan Arab Jamahiriya
126 Lithuania
127 Luxembourg
128 Macao
129 Macedonia, the former Yugoslav Republic of
130 Madagascar
131 Malawi
133 Maldives
134 Mali
135 Malta
136 Marshall Islands
137 Martinique
138 Mauritania
139 Mauritius
140 Mayotte
141 Mexico
142 Micronesia, Federated States of
143 Moldova, Republic of
145 Mongolia
148 Morocco
149 Mozambique
150 Myanmar
151 Namibia
152 Nauru
153 Nepal
155 Netherlands Antilles
156 New Caledonia
157 New Zealand
158 Nicaragua
159 Niger
160 Nigeria
161 Niue
162 Norfolk Island
163 Northern Mariana Islands
164 Norway
165 Oman
166 Pakistan
167 Palau
169 Panama
170 Papua New Guinea
171 Paraguay
173 Philippines
175 Poland
176 Portugal
177 Puerto Rico
178 Qatar
179 Reunion
180 Romania
181 Russian Federation
182 Rwanda
183 Saint Helena
184 Saint Kitts and Nevis
185 Saint Lucia
186 Saint Pierre and Miquelon
187 Saint Vincent and the Grenadines
188 Samoa
190 Sao Tome and Principe
191 Saudi Arabia
192 Senegal
194 Seychelles
196 Singapore
197 Slovakia
198 Slovenia
199 Solomon Islands
200 Somalia
201 South Africa
203 Spain
204 Sri Lanka
205 Sudan
206 Suriname
208 Swaziland
209 Sweden
210 Switzerland
211 Syrian Arab Republic
212 Taiwan, Province of China
213 Tajikistan
214 Tanzania, United Republic of
216 Timor-Leste
217 Togo
219 Tonga
220 Trinidad and Tobago
222 Turkey
223 Turkmenistan
224 Turks and Caicos Islands
225 Tuvalu
226 Uganda
227 Ukraine
228 United Arab Emirates
232 Uruguay
233 Uzbekistan
234 Vanuatu
235 Venezuela
236 Viet Nam
238 Virgin Islands, U.S.
239 Wallis and Futuna
240 Western Sahara
241 Yemen
242 Zambia
243 Zimbabwe
Alright. that's the full list of every country in the AM database, and its ID number. HERE's where YOU come in:
Please, if you have the time, select a country from the list, pick its predominate subdivision [states, provinces, counties, islands... whatever is most common and prevalent] and submit it here in the following format:
United Kingdom:
(229, 'Scotland'), (229, 'Wales'), (229, 'Northern Ireland'), (229, 'England')
Parenthesis, quotes, comma, and country ID are needed. ORDER of country id and subregion name is unimportant, as long as it is consistant.
PLEASE follow the above format for submissions, it makes dropping it into the new state/province/etc. database a LOT easier to fit into my present schedule, which is primarily focused on getting multiworlds finished and out.
PLEASE note: Posts nowhere near the above format may be ignored.
PLEASE note: THIS requires no list of actual airports within each region, this merely populates the state/county/region database so that Rick, Myself, and any other admin may update these airports appropriately in a sane manner both front and back. When enough of the database is populated, it will be integrated into submit airport and a few admin pages related to this.
ADDITIONAL: If you DO wish to go to the Nth degree and go hog-wild attempting to help us with getting airports -> states/etc released faster. Please include in your post a second line where it lists the region name, then a full list of airports found within that region BY AIRPORT ID. This is the only format that is easily and readily available to mass update a given region's airports.
i.e. United Kingdom:
(229, 'Scotland'), (229, 'Wales'), (229, 'Northern Ireland'), (229, 'England')
Scotland: 50,44, [rest of the airports here]
-
Just a quick question:
SXF is located in 'Brandenburg' but the airport is assigned to the city of Berlin (Berlin-Schönefeld -> will be renamed as BBI-Berlin Brandenburg International soon) which is also a state (more like an independent city). Also I am not sure about the location of BRE. It may still be located inside boundaries of the state of Bremen but it could be Lower Saxony already. How do we handle these airports?
Second question:
What is the "50,44" in your Scotland line? Thought it was the geographical position - but it is not. :idea: Got it: airport ID in AM not ICAO/IATA, right?
-
So the spreadsheet I sent you of all North American airports needs to be redone? :?
-
So the spreadsheet I sent you of all North American airports needs to be redone? :?
Nope, i'll be working off that when i have free time at work [and otherwise cannot code]. It'd be helpful if you listed the states and DC in the format i stated above though.
-
So the spreadsheet I sent you of all North American airports needs to be redone? :?
Nope, i'll be working off that when i have free time at work [and otherwise cannot code]. It'd be helpful if you listed the states and DC in the format i stated above though.
Sure. May take me day or two. I guess you can cross off US, Canada, and Saint Pierre & Miquelon off your master list.
-
@ Air Elbonia:
Could you please reply to my question above? I will start Germany then.
-
Germany:
(80, 'Schleswig-Holstein'), (80, 'Niedersachsen'), (80, 'Bremen'), (80, 'Hamburg'), (80, 'Mecklenburg-Vorpommern'), (80, 'Brandenburg'), (80, 'Berlin'), (80, 'Sachsen-Anhalt'), (80, 'Sachsen'), (80, 'Thüringen'), (80, 'Hessen'), (80, 'Nordrhein-Westfahlen'), (80, 'Rheinland-Pfalz'), (80, 'Saarland'), (80, 'Baden-Württemberg'), (80, 'Bayern')
~AEB: Input
-
Germany:
(80, 'Schleswig-Holstein'), (80, 'Niedersachsen'), (80, 'Bremen'), (80, 'Hamburg'), (80, 'Mecklenburg-Vorpommern'), (80, 'Brandenburg'), (80, 'Berlin'), (80, 'Sachsen-Anhalt'), (80, 'Sachsen'), (80, 'Thüringen'), (80, 'Hessen'), (80, 'Nordrhein-Westfahlen'), (80, 'Rheinland-Pfalz'), (80, 'Saarland'), (80, 'Baden-Württemberg'), (80, 'Bayern')
Will you also assign the airports to the states? Then I wont start this job :wink:
-
Mmmmm Thailand is divided in 76 provinces .... with most provinces only having 1 airport at best. Another common way to divide Thailand is by the regions, of which there would be only 4. What do you want?
I can do the region here by the way no problem! After March 4th when I return to BKK
Waerth
-
Australia:
(13, 'Western Australia'), (13, 'Northern Territory'), (13, 'Queensland'), (13, 'South Australia'), (13, 'New South Wales'), (13, 'Australian Capital Territory'), (13, 'Victoria'), (13, 'Tasmania')
~AEB: INPUT
-
I'll start off with Iran And work my way through the middle east for when I have time
-
Will you also assign the airports to the states? Then I wont start this job :wink:
to answer your earlier question: the 50, 44, ... those are airport numbers. i just threw out random ones, so i don't even know offhand if it's right.
To answer that last question, We can and will be going through to assign airports to the states, but if you want to help us out, you can undertake that job. As said at the end of the post, just list the state: airport id's seperated by commas.
@ Waerth, regions may be fine, I'll leave it to your perogative if you prefer to do the 76 provinces or the 4-5 regions. Provinces are definitely more educational to me :D but unless Thailand is hiding a lot more airports, it can probably get away with the regions.
-
Germany:
(80, 'Schleswig-Holstein'), (80, 'Niedersachsen'), (80, 'Bremen'), (80, 'Hamburg'), (80, 'Mecklenburg-Vorpommern'), (80, 'Brandenburg'), (80, 'Berlin'), (80, 'Sachsen-Anhalt'), (80, 'Sachsen'), (80, 'Thüringen'), (80, 'Hessen'), (80, 'Nordrhein-Westfahlen'), (80, 'Rheinland-Pfalz'), (80, 'Saarland'), (80, 'Baden-Württemberg'), (80, 'Bayern')
Will you also assign the airports to the states? Then I wont start this job :wink:
Oops...
It looks as if I could do that tomorrow!
-
Canada:
(38, 'British Columbia'), (38, 'Alberta'), (38, 'Manitoba'), (38, 'New Brunswick'), (38, 'Newfoundland and Labrador'), (38, 'Northwest Territories'),
(38, 'Nova Scotia'), (38, 'Nunavut'), (38, 'Ontario'), (38, 'Prince Edward Island'), (38, 'Québec'), (38, 'Saskatchewan'), (38, 'Yukon')
I'll do the airport stuff too and Greece and Bosnia and the US. :P
# AEB: Inserted, you may want to split up the airport bits with a few other players, US is >500 airports, Canada is another 106... Decide amongst yourself/ves how to best work that out :D but thanks.
-
United States of America:
(230, 'Washington'), (230, 'Oregon'), (230, 'California'), (230, 'Alaska'), (230, 'Nevada'), (230, 'Arizona'), (230, 'Idaho'), (230, 'Hawaii'), (230, 'Montana'), (230, 'Wyoming'), (230, 'Utah'), (230, 'Colorado'), (230, 'New Mexico'), (230, 'North Dakota'), (230, 'South Dakota'), (230, 'Nebraska'), (230, 'Kansas'), (230, 'Oklahoma'), (230, 'Texas'), (230, 'Arkansas'), (230, 'Minnesota'), (230, 'Iowa'), (230, 'Missouri'), (230, 'Louisiana'), (230, 'Mississippi'), (230, 'Alabama'), (230, 'Wisconsin'), (230, 'Michigan'), (230, 'Illinois'), (230, 'Kentucky), (230, 'Tennessee'), (230, 'Indiana'), (230, 'Ohio'), (230, 'Georgia'), (230, 'Florida'), (230, 'South Carolina'), (230, 'North Carolina'), (230, 'Virginia'), (230, 'West Virginia'), (230, 'District of Columbia'), (230, 'Pennsylvania'), (230, 'New York'), (230, 'New Jersey'), (230, 'Vertmont'), (230, 'Rhode Island'), (230, 'Connecticut'), (230, 'New Hampshire'), (230, 'Maine'), (230, 'Massachusetts'), (230, 'Delaware'), (230, 'Maryland')
# ~AEB: Inserted
-
New Zealand-
(157, 'North Island'), (157, 'South Island'), (157, 'Minor Island')
# ~AEB: Islands Inserted, Airport ID's please, not names, wherever the list is longer then 1 airport.
North Island-
Ardmore
Auckland
Gisborne
Hamilton
Kaitaia
Kerikeri
Napier
New Plymouth
Palmerston North
Rotorua
Taupo
Tauranga
Wanganui
Wellington
Whakatane
Whangarei
South Island-
Alexandra Aerodrome
Ashburton
Blenheim
Christchurch
Dunedin
Greymouth
Hokitika
Invercargill Airport
Milford Sound
Nelson
Oamaru
Queenstown
Timaru
Wanaka
Westport
Minor Island-
Chatham Islands Airport
Tell me if you need any thing else, and do you want the codes?
-
Greece:
(83, 'Thrace'), (83, 'Macedonia'), (83, 'Epirus'), (83, 'Thessaly'), (83, 'Attica'), (83, 'Sporades'), (83, 'Evia'), (83, 'Sterea Hellas'), (83, 'Peloponnese'), (83, 'North Aegean Islands'), (83, 'Ionian Islands'), (83, 'Crete'), (83, 'Dodecanese'), (83, 'Cyclades')
Bosnia and Herzegovina:
(27, 'Bosnia'), (27, 'Herzegovina')
# ~AEB: Both Inserted. Thanks.
-
Australia:
(13, Northern Territory), (13, Queensland), (13, Western Australia), (13, New South Wales), (13, South Australia), (13, Victoria), (13, Tasmania).
Is that all you need?
-
Australia:
(13, Northern Territory), (13, Queensland), (13, Western Australia), (13, New South Wales), (13, South Australia), (13, Victoria), (13, Tasmania).
Is that all you need?
Already got Australia, but yes. that'd what I need to get the states/provinces/etc into the database, if you want to go to the Nth degree find the airports within those states/provinces/etc and list their airport id's after the territory name.
i.e. United States:
Minnesota:
874, 928, 138...
[which translates into bemidji, duluth, msp... etc. etc. etc.]
-
You know what? I'll give it a go.
EDIT:
Wait, did you have all the Australian airports too?
-
I only listed them the states and added the Northern Territory& Australian Capital Territory.
Now the admins gotta decide: Do you want to include the NT&ACT in the search option or not?(I'd say it's not really necesarry)
-
Netherlands:
(154, 'Friesland'), (154, 'Groningen'), (154, 'Drenthe'), (154, 'Noord-Holland'), (154, 'Flevoland'), (154, 'Zuid-Holland'), (154, 'Overijssel'), (154, 'Gelderland'), (154, 'Utrecht'), (154, 'Zeeland'), (154, 'Noord-Brabant'), (154, 'Limburg')
# ~AEB: States added, airports updated
Airports:
Noord-Holland: 6
Zuid-Holland: 617
Brabant: 20
Overijssel: 2046
Groningen: 611
Limburg: 618
-
I think adding states to small countries might be overkill as that wont say much to the unknowing user, with only one airport per state. Regions might be better, like Sweden that has 25 landskap (states), there are also 21 sub-regions, that has 1 or more states in it, and finally there are the 3 large regions.
In order to easily see what airpoorts are close to where I suggest using the larger of the 3, with 3 regions.
I can do which ever you want for Sweden, and the airports that belongs where :)
-
Hey Hannover International, if you want to you can add the German airports- I don't think I'll have a chance to do that over the weekend.
-
Hey Hannover International, if you want to you can add the German airports- I don't think I'll have a chance to do that over the weekend.
Ok, will do so.
-
Germany:
(80, 'Schleswig-Holstein'), (80, 'Niedersachsen'), (80, 'Bremen'), (80, 'Hamburg'), (80, 'Mecklenburg-Vorpommern'), (80, 'Brandenburg'), (80, 'Berlin'), (80, 'Sachsen-Anhalt'), (80, 'Sachsen'), (80, 'Thüringen'), (80, 'Hessen'), (80, 'Nordrhein-Westfahlen'), (80, 'Rheinland-Pfalz'), (80, 'Saarland'), (80, 'Baden-Württemberg'), (80, 'Bayern')
Schleswig-Holstein: 83,2775,2787
Niedersachsen: 13,79
Bremen: 14
Hamburg: 19
Mecklenburg-Vorpommern: 2028,2109,2745,2779,2781
Brandenburg: 12,2748,2749,2786
Berlin: 10,11
Sachsen-Anhalt: 2777,2784
Sachsen: 74,82,2747
Thüringen: 8,76,2768,2770,2774
Hessen: 18,2750,2773
Nordrhein-Westfahlen: 15,75,81,85,86,88,1158,2772,2778,2782
Rheinland-Pfalz: 78,2448,2783
Saarland: 89
Baden-Württemberg: 77,80,90,2110,2776
Bayern: 9,84,87,2449,2746,2771,2780
This is just for the airports that are currently in the game. There are still some missing. But there are no official data available for them :(
# Updated: awesome.
-
I think adding states to small countries might be overkill as that wont say much to the unknowing user, with only one airport per state. Regions might be better, like Sweden that has 25 landskap (states), there are also 21 sub-regions, that has 1 or more states in it, and finally there are the 3 large regions.
In order to easily see what airpoorts are close to where I suggest using the larger of the 3, with 3 regions.
I can do which ever you want for Sweden, and the airports that belongs where :)
The way i'm envisioning this panning out is that the only place it really attacks you forcefully for any state info is submit airport [and an admin page or two related to airport additions]. Beyond that, specific state(s) will pretty well fall off to a secondary (sortable) column in gate search / rent gate / view gates, with the option to view a specific state only offered wherever a country has >= 50 airports. Unless Sweden is likely to grow by the 25~30 airports needed to hit that level, I'll leave it to your prerogative for whatever is common and useful. If you're gonna do the airports as well that is, otherwise, whatever is easily looked up in GC or the like.
Oh and AHI/et. al. If you're updating for the airport portion, you only need to mention the country then the state/airport id lists, no need to restate the states themselves.
-
I just copied from Blue's post. Made it easier for me to sort the airports :D
-
You know what? I'll give it a go.
EDIT:
Wait, did you have all the Australian airports too?
Just have the states themselves [including ACT], still need the airports done. That'd be amazing, even if you only get one or two states done.
-
Ok, I'll give it a go on Sunday if I get a chance (Saturday morning here now).
-
Greece:
(83, 'Thrace'), (83, 'Macedonia'), (83, 'Epirus'), (83, 'Thessaly'), (83, 'Attica'), (83, 'Sporades'), (83, 'Evia'), (83, 'Sterea Hellas'), (83, 'Peloponnese'), (83, 'North Aegean Islands'), (83, 'Ionian Islands'), (83, 'Crete'), (83, 'Dodecanese'), (83, 'Cyclades')
Bosnia and Herzegovina:
(27, 'Bosnia'), (27, 'Herzegovina')
# ~AEB: Both Inserted. Thanks.
Bosinia: All of them here.... How do you find the airport id? :?
Herzegovina: none
~ AEB: that'll do in this case. Airport ID, it's found on the tail end of view_airport. i.e. view_airport.php?id={Airport ID Here}
-
14 Austria
(14, 'Burgenland'), (14, 'Kärnten'), (14, 'Niederösterreich'), (14, 'Oberösterreich'), (14, 'Salzburg'), (14, 'Steiermark'), (14, 'Tirol'), (14, 'Vorarlberg'), (14, 'Wien')
Kärnten: 126
Niederösterreich: 128
Oberösterreich: 1412
Salzburg: 127
Steiermark: 124
Tirol: 125
-
Australia:
(13, ‘Northern Territory’), (13, ‘Queensland’), (13, ‘Western Australia’), (13, ‘New South Wales’), (13, ‘South Australia’), (13, ‘Victoria’), (13, ‘Tasmania’), (13, ‘Australian Capital Territory’)
Northern Territory: 1310, 699, 666, 1324, 743, 809, 1338, 1314
Queensland: 238, 2196, 1316, 659, 1319, 1320, 1323, 1325, 1329, 693, 1331, 710, 819, 700, 1339, 1342, 820, 821, 822, 823, 824, 1347, 805, 1356, 694, 1359, 1311, 818, 696, 1361
Western Australia: 1312, 692, 1318, 1332, 1326, 1328, 812, 1334, 1335, 1355, 1352, 240, 1350, 1346
New South Wales: 697, 1313, 730, 807, 1315, 709, 1321, 806, 1330, 808, 1336, 1340, 1343, 1344, 1345, 695, 1353, 1351, 804, 236, 1357, 1358, 1360, 1362, 1337
South Australia: 239, 810, 825, 1333, 811, 1354, 1349, 1363
Victoria: 1100, 1327, 1341 237, 275, 733, 1348
Tasmania: 1317, 1322, 689, 732, 1101, 701, 731
Australian Capital Territory: 698
Other: 734 (CCK – Cocos (Keeling) Islands), 925 (AN0 - Davis Station, Antarctica)
The two "other"s are not really part of Australia. The Cocos Keeling Islands may be able to be classified under Northern Territory (they are part of a NT electorate), or maybe Australian Capital Territory. Davis Station may also be able to go under ACT.
-
Updated to here.
awesome. 178 airports down, 2800ish to go. Thanks all who help or are willing to help.
-
Finland:
(72, 'Ahvenanmaa'), (72, Etelä-Suomi'), (72, 'Itä-Suomi'), (72, 'Lappi'), (72, 'Länsi-Suomi'), (72, 'Oulu')
Ahvenanmaa: 1120
Etelä-Suomi: 1110, 156
Itä-Suomi: 1113, 161, 1119, 1121, 1122, 1123
Lappi: 1111, 1112, 1116, 162, 1109
Länsi-Suomi: 1114, 1117, 158, 159, 160
Oulu: 1115, 1118, 157
-
Thanks. Updated to this point. awesome. 22 more airports down.
I'll work on turning on this feature (visibly) when about 1/5th the database is covered.
194 down, minimum of 410 to go before it becomes visible.
-
Switzerland
(210, ’Aargau’) (210, ’Appenzell Innerrhoden’) (210, ’Appenzell Ausserrhoden’) (210, ’Basel-Stadt’) (210, ’Basel-Landschaft’) (210, ’Bern’) (210, ’Fribourg’) (210, ’Genève’) (210, ’Glarus’) (210, ’Graubünden’) (210, ’Jura’) (210, ’Luzern’) (210, ’Neuchâtel’) (210, ’Nidwalden’) (210, ’Obwalden’) (210, ’St. Gallen’) (210, ’Schaffhausen’) (210, ’Schwyz’) (210, ’Solothurn’) (210, ’Thurgau’) (210, ’Ticino’) (210, ’Uri’) (210, ’Valais’) (210, ’Vaud’) (210, ’Zug’) (210, ’Zürich’)
-
Switzerland's states added. Thanks El Barto!
-
Thanks. Updated to this point. awesome. 22 more airports down.
I'll work on turning on this feature (visibly) when about 1/5th the database is covered.
194 down, minimum of 410 to go before it becomes visible.
Nooo, Add it now that Australia's there! :P
Kudos to the guy that does the USA!
-
Czech Republic
(57, 'Bohemia') (57, 'Moravia')
Bohemia: 1487, 1681, 252
Moravia: 1486, 1680
21 Belgium
(21, 'Brussels-Capital Region') (21, 'Flander') (21, 'Walloon')
Brussels-Capital Region: 2202, 1469
Flander:643, 1157
Walloon: 660
-
Afghanistan:
(1, ‘Badakhshan’), (1, ‘Badghis’), (1, ‘Baghlan’), (1, ‘Balkh’), (1, ‘Bamian’), (1, ‘Daykondi’), (1, ‘Farah’), (1, ‘Faryab’), (1, ‘Ghazni’), (1, ‘Ghowr’), (1, ‘Helmand’), (1, ‘Herat’), (1, ‘Jowzjan’), (1, ‘Kabol’), (1, ‘Kandahar’), (1, ‘Kapisa’), (1, ‘Khowst’), (1, ‘Konar’), (1, ‘Kondoz’), (1, ‘Laghman’), (1, ‘Lowgar’), (1, ‘Nangarhar’), (1, ‘Nimruz’), (1, ‘Nurestan’), (1, ‘Oruzgan’), (1, ‘Paktia’), (1, ‘Paktika’), (1, ‘Panjshir’), (1, ‘Parvan’), (1, ‘Samangan’), (1, ‘Sar-e Pol’), (1, ‘Takhar’), (1, ‘Vardak’), (1, ‘Zabol’)
Badakhshan: 2043
Heart: 2041
Kabol: 1666
Kandahar: 2040
Balkh: 2042
-
If you need someone to place the US airports in the right states I'll throw myself under the bus...
-
43.- Chile:
(43,'Arica y Parinacota'),(43,'Tarapaca'),(43,'Antofagasta'),(43,'Atacama'),(43,'Coquimbo'),(43,'Valparaiso'),(43,'Metropolitana'),(43,'Libertador General Bernardo Ohiggins'),(43,'Maule'),(43,'Bio-Bio'),(43,'Araucania'),(43,'Los Rios'),(43,'Los Lagos'),(43,'Aysen'),(43,'Magallanes y la Antartica Chilena')
Arica y Parinacota:363
Tarapacá: 366
Antofagasta:2204,364,2564
Atacama:1596
Coquimbo:367
Valparaíso:1534
Metropolitana:370
Libertador General Bernardo O'higgins:No commercial aviation Activity
Maule:No commercial aviation Activity
Bio-Bio:365
Araucanía:371
Los Ríos:1579,1578
Los Lagos:368
Aysen:1929
Magallanes y la antártica Chilena:369
-
United States:
Florida:
221, 550, 233, 296, 563, 304, 1546, 1552, 2419, 225, 2421, 1415, 2200, 738, 533, 531, 1471, 1091, 1492, 301
-
Caught up to Chile.
-as Floridian airports are identified.... runs off to update them too-
edit: Florida done as well.
245 airports have "states"/"provinces" etc now.
Afghanistan surprised me, I must admit. did not expect to see that one come anytime soon. awesomeness.
-
Unit=provinces
36.- Cambodia:
(36,'Banteay Meanchey'),(36,'Battambang'),(36,'Kampong Cham'),(36,'Kampong Chhnang'),(36,'Kampong Speu'),(36,'Kampong Thom'),(36,'Kampot'),(36,'Kandal'),(36,'Kep'),(36,'Koh Kong'),(36,'Kratié'),(36,'Mondulkiri'),(36,'Oddar Meancheay'),(36,'Pailin'),(36,'Phnom Penh')(36,'Preah Vihear'),(36,'Prey Veng'),(36,'Pursat'),(36,'Ratanakiri'),(36,'Siem Reap'),(36,'Sihanoukville'),(36,'Stung Treng'),(36,'Svay Rieng'),(36,'Takéo')
Battambang: 2751
Phnom Penh: 310
Ratanakiri: 2752
Siem Reap: 902
Stung Treng: 2753
Cambodia ....
~ Done. Thanks AEB ~
-
Unit=provinces
119.- Laos:
(119,'Attapeu'),(119,'Bokeo'),(119,'Bolikhamsai'),(119,'Champasak'),(119,'Houaphan'),(119,'Khammouan'),(119,'Luang Namtha'),(119,'Luang Prabang'),(119,'Oudomxai'),(119,'Phongsali'),(119,'Salavan'),(119,'Savannakhet'),(119,'Vientiane (prefecture)'),(119,'Vientiane'),(119,'Xaignabouli'),(119,'Xekong'),(119,'Xiang Khuang')
Attapeu: 2242
Houaphan: 2241
Luang Prabang: 2072
Oudomxai: 2240
Champasak: 2239
Salavan: 2243
Savannakhet: 2238
Vientiane: 860
Xaignabouli: 2244
Xiang Khuang: 2237
Laos
~ Done. Thanks AEB ~
-
Country: USA
Unit: States
Illinois: 766,634,544,2971,2198,130,551,2972,767,2968,530,765,630
EDIT: ~ Done, Thanks. AEB ~
-
Albania
(3, ‘Berat’), (3, ‘Diber’), (3, ‘Durres’), (3, ‘Elbasan’), (3, ‘Fier’), (3, ‘Gjirokaster’), (3, ‘Korce’), (3, ‘Kukes’), (3, ‘Lezhe’), (3, ‘Shkoder’), (3, ‘Tirane’), (3, ‘Vlore’)
Tirane: 1280
EDIT: Done. Thanks! ~ AEB
-
Algeria
(4, ‘Adrar’), (4, ‘Ain Defla’), (4, ‘Ain Temouchent’), (4, ‘Alger’), (4, ‘Annaba’), (4, ‘Batna’), (4, ‘Bechar’), (4, ‘Bejaia’), (4, ‘Biskra’), (4, ‘Blida’), (4, ‘Bordj Bou Arreridj’), (4, ‘Bouira’), (4, ‘Boumerdes’), (4, ‘Chlef’), (4, ‘Constantine’), (4, ‘Djelfa’), (4, ‘El Bayadh’), (4, ‘El Oued’), (4, ‘El Tarf’), (4, ‘Ghardaia’), (4, ‘Guelma’), (4, ‘Illizi’), (4, ‘Jijel’), (4, ‘Khenchela’), (4, ‘Laghouat’), (4, ‘Mascara’), (4, ‘Medea’), (4, ‘Mila’), (4, ‘Mostaganem’), (4, ‘M'Sila’), (4, ‘Naama’), (4, ‘Oran’), (4, ‘Ouargla’), (4, ‘Oum el Bouaghi’), (4, ‘Relizane’), (4, ‘Saida’), (4, ‘Setif’), (4, ‘Sidi Bel Abbes’), (4, ‘Skikda’), (4, ‘Souk Ahras’), (4, ‘Tamanghasset’), (4, ‘Tebessa’), (4, ‘Tiaret’), (4, ‘Tindouf’), (4, ‘Tipaza’), (4, ‘Tissemsilt’), (4, ‘Tizi Ouzou’), (4, ‘Tlemcen’)
Adrar: 2044
Setif: 2165
Alger: 903
Batna: 2166
Biskra: 2167
Tebessa: 2169
Illizi: 2170, 2173, 2175
Ghardaia: 2171, 2176
Annaba: 1141
El Oued: 2175 *
Laghouat: 2172
Jijel: 2168
Constantine: 2164
Ouargla: 2177
Bejaia: 2178
Tamanghasset: 445
*Note: The airport is called Guemar, not Gemar.
EDIT: Fixed, and Done. thanks. (Guemar didn't carry through however. AHI?)
EDIT by AHI: Sorry, saw it today. But I could not correct the name. I'll PM you.
-
American Samoa (5)
No divisions
Airports: 1034
EDIT: Noted. thanks.
-
Malaysia
(132, 'Johor'), (132, 'Kedah'), (132, 'Kelantan'), (132, 'Melaka'), (132, 'Negeri Sembilan'), (132, 'Pahang'), (132, 'Penang'), (132, 'Perak'), (132, 'Perlis'), (132, 'Selangor'), (132, 'Terengganu'), (132, 'Sabah'), (132, 'Sarawak'),
Johor: 382
Kedah: 1373, 1379
Kelantan: 1374
Melaka: 1384
Negeri Sembilan: (none)
Pahang: 1380, 2726
Penang: 667
Perak: 1383, 2727
Perlis: (none)
Selangor: 625, 1382
Terengganu: 1375, 2728
Sabah: 383, 2744, 1376, 913, 1378, 1377
Sarawak: 2736, 2737, 2743, 914, 384, 2738, 915, 2739, 2740, 2741, 911, 2742, 2729, 912, 2707
EDIT: Done, thanks~ AEB
-
328 airports down...
2700~ to go.
awesome!
In addition, I feel i've personally butchered every province, state, and other thus-far (located out of the US and Canada), as I tend to say the province/et al. aloud to help me remember it for the 30 seconds i need to.
edit: first post updated. We've gathered thusfar the states/provinces/et. al for 21 different countries. awesome job guys.
-
Spain (203)
(203,'Andalucia'), (203,'Aragon'), (203,'Canarias'),(203,'Cantabria'),(203,'Castilla y Leon'),(203,'Castilla-La Macha'),(203,'Cataluña'),(203,'Ceuta'),(203,'Comunidad de Madrid')(203,'Comunidad Foral de Navarra'),(203,'Comunidad Valenciana')(203,'Extremadura'),(203,'Galicia'),(203,'Islas Baleares'),(203,'La Rioja'),(203,'Melilla'),(203,'Pais Vasco'),(203,'Principado de Asturias'),(203,'Region de Murcia')
Andalucia: 93, 2790, 100, 102, 106, 113
Aragon:856
Canarias:1535, 97, 99, 1536, 103, 104, 114, 115
Cantabria:111
Castilla y Leon:2029, 2794, 635.
Castilla-La Macha: 2788
Cataluña:95, 98, 110
Comunidad de Madrid:105, 2792, 2793
Comunidad Foral de Navarra:1538
Comunidad Valenciana:92, 116
Extremadura:2789
Galicia:91, 112, 117
Islas Baleares:101, 107, 109
La Rioja:2791
Melilla:1537
Pais Vaso:96, 673, 2769
Principado de Asturias:94
Region de Murcia:108
edit: ~DONE. AEB~
-
Thanks Maestro,
371 down... :D
-
Portugal (176)
(176,'Alentejo'), (176,'Algarve'), (176,'Açores'), (176,'Centro'), (176,'Lisboa'), (176,'Madeira'), (176,'Norte')
Algarve: 853
Açores: 1519, 1520, 675, 1422, 669, 1521, 1518, 1533
Lisboa: 642
Madeira: 775, 1489
Norte: 658
France (73)
(73,'Alsace') , (73,'Aquitaine') , (73,'Auvergne') , (73,'Brittany') , (73,'Burgundy') , (73,'Centre') , (73,'Champagne-Ardenne') , (73,'Corsica') , (73,'Franche-Comte') , (73,'Ile-de-France') , (73,'Languedoc-Roussillon') , (73,'Limousin') , (73,'Lorraine') ,(73,'Lower Normandy') , (73,'Midi-Pyrenees') , (73,'Nord-Pas-de-Calais') , (73,'Pays de la Loire') , (73,'Picardie') , (73,'Poitou-Charentes') , (73,'Provence-Alpes-Cote d'Azur') , (73,'Rhone-Alpes') , (73,'Upper Normandy')
Alsace: 817
Aquitaine: 814, 774, 771
Auvergne: 1597
Brittany: 628, 773, 772,
Champagne-Ardenne:2277
Corsica: 2113, 1277, 2115, 2114
Ile-de-France:144, 742
Languedoc-Roussilon:815, 638, 1599
Midi-Pyrenees:2186, 619
Nord-Pas-de-Calais:2023
Pays de la Loire:1598
Picardie:816
Poitou-Charentes:813
Provence-Alpes-Cote d'Azur: 2184, 637, 852
Rhone-Alpes:2185, 641
Have some more spare time :lol:
edit: ~AEB~ Thanks again! done, both france and portugal.
-
Angola
(6, ‘Bengo’), (6, ‘Benguela’), (6, ‘Bie’), (6, ‘Cabinda’), (6, ‘Cuando Cubango’), (6, ‘Cuanza Norte’), (6, ‘Cuanza Sul’), (6, ‘Cunene’), (6, ‘Huambo’), (6, ‘Huila’), (6, ‘Luanda’), (6, ‘Lunda Norte’), (6, ‘Lunda Sul’), (6, ‘Malanje’), (6, ‘Moxico’), (6, ‘Namibe’), (6, ‘Uige’), (6, ‘Zaire’)
Luanda: 1143
Huambo: 1606
Huila: 1607
edit: ~AEB~ Thanks again! done
-
Anguilla (7)
No divisions, overseas territory of the UK.
Airports: 2874
Antigua and Barbuda
(9, ‘Barbuda’), (9, ‘Redonda’), (9, ‘Saint George’), (9, ‘Saint John’), (9, ‘Saint Mary’), (9, ‘Saint Paul’), (9, ‘Saint Peter’), (9, ‘Saint Philip’)
Saint George: 406
edit: ~AEB~ Thanks again! done
-
Armenia
(11, ‘Aragatsotn’), (11, ‘Ararat’), (11, ‘Armavir’), (11, ‘Geghark'unik'’), (11, ‘Kotayk'’), (11, ‘Lorri’), (11, ‘Shirak’), (11, ‘Syunik'’), (11, ‘Tavush’), (11, ‘Vayots'’) (11, ‘Dzor’), (11, ‘Yerevan’)
Shirak: 2047
Yerevan: 2048
Aruba
No Divisions, part of the Netherlands
Airports: 407
Azerbaijan
(15, ‘Abseron Rayonu’), (15, ‘Agcabadi Rayonu’), (15, ‘Agdam Rayonu’), (15, ‘Agdas Rayonu’), (15, ‘Agstafa Rayonu’), (15, ‘Agsu Rayonu’), (15, ‘Astara Rayonu’), (15, ‘Balakan Rayonu’), (15, ‘Barda Rayonu’), (15, ‘Beylaqan Rayonu’), (15, ‘Bilasuvar Rayonu’), (15, ‘Cabrayil Rayonu’), (15, ‘Calilabad Rayonu’), (15, ‘Daskasan Rayonu’), (15, ‘Davaci Rayonu’), (15, ‘Fuzuli Rayonu’), (15, ‘Gadabay Rayonu’), (15, ‘Goranboy Rayonu’), (15, ‘Goycay Rayonu’), (15, ‘Haciqabul Rayonu’), (15, ‘Imisli Rayonu’), (15, ‘Ismayilli Rayonu’), (15, ‘Kalbacar Rayonu’), (15, ‘Kurdamir Rayonu’), (15, ‘Lacin Rayonu’), (15, ‘Lankaran Rayonu’), (15, ‘Lerik Rayonu’), (15, ‘Masalli Rayonu’), (15, ‘Neftcala Rayonu’), (15, ‘Oguz Rayonu’), (15, ‘Qabala Rayonu’), (15, ‘Qax Rayonu’), (15, ‘Qazax Rayonu’), (15, ‘Qobustan Rayonu’), (15, ‘Quba Rayonu’), (15, ‘Qubadli Rayonu’), (15, ‘Qusar Rayonu’), (15, ‘Saatli Rayonu’), (15, ‘Sabirabad Rayonu’), (15, ‘Saki Rayonu’), (15, ‘Salyan Rayonu’), (15, ‘Samaxi Rayonu’), (15, ‘Samkir Rayonu’), (15, ‘Samux Rayonu’), (15, ‘Siyazan Rayonu’), (15, ‘Susa Rayonu’), (15, ‘Tartar Rayonu’), (15, ‘Tovuz Rayonu’), (15, ‘Ucar Rayonu’), (15, ‘Xacmaz Rayonu’), (15, ‘Xanlar Rayonu’), (15, ‘Xizi Rayonu’), (15, ‘Xocali Rayonu’), (15, ‘Xocavand Rayonu’), (15, ‘Yardimli Rayonu’), (15, ‘Yevlax Rayonu’), (15, ‘Zangilan Rayonu’), (15, ‘Zaqatala Rayonu’), (15, ‘Zardab Rayonu’), (15, ‘Ali Bayramli Sahari’), (15, ‘Baki Sahari’), (15, ‘Ganca Sahari’), (15, ‘Lankaran Sahari’), (15, ‘Mingacevir Sahari’), (15, ‘Naftalan Sahari’), (15, ‘Saki Sahari’), (15, ‘Sumqayit Sahari’), (15, ‘Susa Sahari’), (15, ‘Xankandi Sahari’), (15, ‘Yevlax Sahari’), (15, ‘Naxcivan Muxtar Respublikasi’)
Baki Sahari: 2147
Ganca Sahari: 2260
Naxcivan Muxtar Respublikasi: 2261
edit: ~AEB~ Thanks again! done; Aruba skipped as no number provided. will catch it later (just one airport, not a big deal at the moment).
-
Estonia
(67, 'Harjumaa') (67, 'Hiiumaa') (67, 'Ida-Virumaa') (67, 'Järvamaa') (67, 'Jõgevamaa') (67, 'Läänemaa') (67, 'Lääne-Virumaa') (67, 'Pärnumaa') (67, 'Põlvamaa') (67, 'Raplamaa') (67, 'Saaremaa') (67, 'Tartumaa') (67, 'Valgamaa') (67, 'Viljandimaa') (67, 'Võrumaa') (67, 'Petserimaa')
Harjumaa: 614
Hiiumaa: 1479
Saaremaa: 1478
Pärnumaa: 1678
EDIT ~ AEB ~ Done. Thanks again. (Sorry for delay)
-
Kudos to the guy that does the USA!
I'm working on it. It's gonna be fun! :lol:
-
Iran:
(102, 'Ardabil'), (102, 'East Azarbaijan'), (102, 'West Azarbaijan'), (102, 'Gilan'), (102, 'Zanjan'), (102, 'Kordestan'), (102, 'Qazvin'), (102, 'Hamadan'), (102, 'Kermanshah'), (102, 'Tehran'), (102, 'Markazi'), (102, 'Qom'), (102, 'Lorestan'), (102, 'Iilam'), (102, 'Golestan'), (102, 'Semnan'), (102, 'Esfahan'), (102, 'Chaharmadhal and Bakhtiari'), (102, 'Khuzestan'), (102, 'North Khorasan'), (102, 'Kohgiluyeh and Boyer Ahmad'), (102, 'Razavi Khorasan'), (102, 'Yasd'), (102, 'Fars'), (102, 'Bushehr'), (102, 'South Khorasan'), (102, 'Kerman'), (102, 'Hormozgan'), (102, 'Sistan and Baluchestan')
Edit: ~ AEB ~ Added after all this time... thanks again
-
Lithuania:
(126, 'Alytus'), (126, 'Kaunas'), (126, 'Klaip?da'), (126, 'Marijampol?'), (126, 'Panev?žys'), (126, 'Šiauliai'), (126, 'Taurag?'), (126, 'Telšiai'), (126, '?tena'), (126, 'Vilnius')
They actually have the word county after each name, because each county in Lithuania is named after a bigger city. Hope this helps. :wink:
Edit: ~ AEB ~ Added after all this time... thanks again
-
Philippines:
(173, 'National Capital Region'), (173, 'Cordillera Administrative Region'), (173, 'Ilocos Region'), (173, 'Cagayan Valley'), (173, 'Central Luzon'), (173, 'Calabarzon'), (173, 'Mimaropa'), (173, 'Bicol Region'), (173, 'Western Visayas'), (173, 'Central Visayas'), (173, 'Eastern Visayas'), (173, 'Zamboanga Peninsula'), (173, 'Northern Mindanao'), (173, 'Davao Region'), (173, 'Soccsksargen'), (173, 'Caraga'), (173, 'Autonomous Region in Muslim Mindanao')
National Capital Region: 472
Cordillera Administrative Region: 827
Ilocos Region: 803, 1096
Cagayan Valley: 1093, 845
Central Luzon: 793, 904
Mimaropa: 905, 843, 836, 847
Bicol Region: 720, 842, 907, 1099
Western Visayas: 719, 906, 792, 826, 837
Central Visayas: 471, 841, 844
Eastern Visayas: 840
Zamboanga Peninsula: 909, 1097, 838
Northern Mindanao: 1095, 1094, 839, 1098
Davao Region: 470
Soccsksargen: 846, 795
Caraga: 910, 1092
Autonomous Region in Muslim Mindanao: 908
Edit: Added by StephenM
-
Brazil:
(30, 'Acre'), (30, 'Alagoas'), (30, 'Amapá'), (30, 'Amazonas'), (30, 'Bahia'), (30, 'Ceará'), (30, 'Distrito Federal'), (30, 'Espírito Santo'), (30, 'Goiás'), (30, 'Maranhão'), (30, 'Mato Grosso'), (30, 'Mato Grosso do Sul'), (30, 'Minas Gerais'), (30, 'Pará'), (30, 'Paraíba'), (30, 'Paraná'), (30, 'Pernanbuco'), (30, 'Piauí'), (30, 'Rio de Janeiro'), (30, 'Rio Grande do Norte'), (30, 'Rio Grande do Sul'), (30, 'Rondônia'), (30, 'Roraima'), (30, 'Santa Catarina'), (30, 'São Paulo'), (30, 'Sergipe'), (30, 'Tocantins')
These are the 26 brazilian states, plus "Distrito Federal", that is a district (like Washigton DC, USA) created to place the new capital city in the 50´s/60´s.
I hope this helps.
P.S. If someone tells me how do I get the airport codes, i can try to put then in their respective states when i got some free time.
-
When you view an airport the ID is shown in the address bar.
-
101 Indonesia
(101, 'Bali'), (101, 'Bangka-Belitung'), (101, 'Banten'), (101, 'Bengkulu'), (101, 'Central Java'), (101, 'Central Kalimantan'), (101, 'Central Sulawesi'), (101, 'East Java'), (101, 'East Kalimantan'), (101, 'East Nusa Tenggara'), (101, 'Gorontalo'), (101, 'Jakarta Special Capital Region'), (101, 'Jambi'), (101, 'Lampung'), (101, 'Maluku'), (101, 'Nanggroe Aceh Darussalam'), (101, 'North Maluku'), (101, 'North Sulawesi'), (101, 'North Sumatra'), (101, 'Papua'), (101, 'Riau'), (101, 'Riau Islands'), (101, 'South East Sulawesi'), (101, 'South Kalimantan'), (101, 'South Sulawesi'), (101, 'South Sumatra'), (101, 'West Java'), (101, 'West Kalimantan'), (101, 'West Nusa Tenggara'), (101, 'West Papua'), (101, 'West Sulawesi'), (101, 'West Sumatra'), (101, 'Yogyakarta Special Region')
There are four provinces received special status: Nanggroe Aceh Darussalam, Yogyakarta Special Region, Papua, and Jakarta Special Capital Region.
Later on I will try to update those airports in Indonesia that haven't been included in the game. In facts there are several airport that is pretty big and popular here that is not included in the game.
Hope can help!
:) :)
-
Argentina:
(10, 'Buenos Aires'), (10, 'Buenos Aires Federal Capital'), (10, 'Catamarca'), (10, 'Chaco'), (10, 'Chubut'), (10, 'Cordoba'), (10, 'Corrientes'), (10, 'Entre Rios'), (10, 'Formosa'), (10, 'Jujuy'), (10, 'La Pampa'), (10, 'La Rioja'), (10, 'Mendoza'), (10, 'Misiones'), (10, 'Neuquen'), (10, 'Rio Negro'), (10, 'Salta'), (10, 'San Juan'), (10, 'San Luis'), (10, 'Santa Cruz'), (10, 'Santa Fe'), (10, 'Santiago del Estero'), (10, 'Tierra del Fuego'), (10, 'Tucuman')
Buenos Aires: 1928,373,2071,377,1969,1968
Buenos Aires Federal Capital: 372
Catamarca: 1955
Chaco: 1919
Chubut: 1954,374,1960,1961,1921,1975,1979,1964
Cordoba: 375,1977
Corrientes: 1764,1971
Entre Rios: 1956,1970
Formosa: 1256
Jujuy: 1765
La Pampa: 1953
La Rioja: 1965
Mendoza: 1461,1967,1986
Misiones: 376,1973
Neuquen: 1922,1957,1918
Rio Negro: 1958,1962,1982,1926,380
Salta: 379
San Juan: 1984
San Luis: 1983
Santa Cruz: 1959,1966,1974,378,1985,1972,1963,1980
Santa Fe: 1981,1920,1976
Santiago del Estero: 1925
Tierra del Fuego: 1978,1462
Tucuman: 381
I didn't get the data, but a number of airport's passenger numbers seem to be out for Argentina. There are also a few missing airports.
Aruba:
No divisions (part of the Kingdom of the Netherlands)
Airports: 407
Edit: Added by StephenM - Thanks
-
China:
(44,'Beijing'), (44,'Tianjin'), (44,'Shanghai'), (44,'Chongqing'), (44,'Heilongjiang'), (44,'Jilin'), (44,'Liaoning'), (44,'Qinghai'), (44,'Gansu'), (44,'Shaanxi'), (44,'Shanxi'), (44,'Henan'), (44,'Hebei'), (44,'Sichuan'), (44,'Yunnan'), (44,'Guizhou'), (44,'Hunan'), (44,'Hubei'), (44,'Shandong'), (44,'Anhui'), (44,'Jiangsu'), (44,'Jiangxi'), (44,'Zhejiang'), (44,'Fujian'), (44,'Guangdong'), (44,'Guangxi'), (44,'Hainan'), (44,'Xinjiang'), (44,'Tibet'), (44,'Inner Mongolia'), (44,'Ningxia')
Subdivision are not significant for:
Hong Kong, Macau and Taiwan
-
Bahamas
(16,'Bahamas')
Bahamas: 408, 409
There are a number of districts in the Bahamas, in fact 21, but as there are only two airports, I don't think it needs dividing.
Similarily, Bahrain (with a grand total of one airport).
Bahrain
(17,'Bahrain')
Bahrain: 488
However, Bangladesh...
Bangladesh
(18,'Barisal'), (18,'Chittagong'), (18,'Dhaka'), (18,'Khulna'), (18,'Rajshahi'), (18,'Sylhet')
Barisal: 2756
Chittagong: 2025
Dhaka: 1594
Khulna: 2757
Rajshahi: 2758, 2759
Sylhet: 1595
Missing: Cox's Bazar Airport, CXB, VGCB (no pax. data can be found), in Chittagong
Also, 2758 and 2759 have exactly the same pax. number - an error?
Barbados
(19,'Barbados')
Barbados: 410
Edit: Added by StephenM - Thanks
-
Will, if you gave me the actual states' keys, I could throw together a query for you for lots of the US airports/states, as well as some other countries as well. :D
-
...
21 Belgium
(21, 'Brussels-Capital Region') (21, 'Flander') (21, 'Walloon')
Brussels-Capital Region: 2202, 1469
Flander:643, 1157
Walloon: 660
This is not entirely correct.
1) Flander and Walloon are incorrect. It's Flanders and Wallonia
2) The airports of Brussels are actually not inside the Brussels Capital Region.
Making this:
21 Belgium
(21, 'Flanders') (21, 'Wallonia') (21, 'Brussels Capitol Region')
Flanders: 643, 1157, 2202
Wallonia: 660, 1469
EDIT: ~ AEB ~ Thanks for the clarification/correction. Applied.
-
Country 155 'Netherlands Antilles' does not excist anymore. 4 islands desided to become an providence of The Netherlands. The others are independent now. All of these islands have one (or more) airports.
-
Country 155 'Netherlands Antilles' does not excist anymore. 4 islands desided to become an providence of The Netherlands. The others are independent now. All of these islands have one (or more) airports.
This has not been officialy been implemented....yet
-
Serbia (193)
(193,'Serbia'), (193,'Vojvodina'), (193,'Kosovo and Metohija')
Serbia: 1191, 1798
Kosovo and Metohija: 1281
Montenegro (146)
(146,'Montenegro')
Montenegro: 1570, 1799
Croatia (54)
(54,'Central Croatia'), (54,'Dalmatia and Istria'), (54,'Slavonia')
Central Croatia: 858
Dalmatia and Istria: 3159, 857, 1841, 1800, 1107, 1279
Slavonia: 3070
Edit: Added by StephenM - Thanks
-
Hungary (98)
(98,'Central Hungary'),(98,'Central Transdanubia'),(98,'Western Transdanubia'),(98,'Southern Transdanubia'),(98,'Northern Hungary'),(98,'Northern Great Plain'),(98,'Southern Great Plain')
Central Hungary: 253
Northern Great Plain: 2074
Western Transdanubia: 1282, 2256
Southern Transdanubia: 2075
Edit: Added by StephenM - Thanks
-
Israel (106)
(106,'North District'),(106,'Haifa District'),(106,'Center District'),(106,'Tel Aviv District'),(106,'Jerusalem District'),(106,'South District')
North District: 889
Haifa District: 890
Center District: No airports
Tel Aviv District: 490, 491, 2195
South District: 489, 2194
Edit: Added by StephenM - Thanks
-
Peru (172)
(172,'Amazonas'),(172,'Ancash'),(172,'Apurimac'),(172,'Arequipa'),(172,'Ayacucho'),(172,'Cajamarca'),(172,'Lima-Callao'),(172,'Cuzco'),(172,'Huancavelica'),(172,'Huanuco'),(172,'Ica'),(172,'Junin'),(172,'La Libertad'),(172,'Lambayeque'),(172,'Loreto'),(172,'Madre de Dios'),(172,'Moquegua'),(172,'Pasco'),(172,'Piura'),(172,'Puno'),(172,'San Martin'),(172,'Tacna'),(172,'Tumbes'),(172,'Ucayali')
Amazonas: No Airport
Ancash: 1948,2398
Apurimac: 1892
Arequipa: 1600
Ayacucho: 1889
Cajamarca: 1891
Cuzco: 1890
Huancavelica: No Airport
Huanuco: 1895
Ica: 2399,1950
Junin: 1899
La Libertad: 1894
Lambayeque: 1900
Lima-Callao: 359
Loreto: 1896,1902
Madre de Dios: 1901
Moquegua: No Airport
Pasco: No Airport
Piura: 1577,1953
Puno: 1898
San Martin: 1949,1952,1897
Tacna: 1893
Tumbes: 1903
Ucayali: 1951
PS : My first post on this forum, just discovered AM 2 hours ago, it 's one of my dreams come true XD... AWESOME GAME!!! :D
Edit: Added by StephenM - Thanks
-
Thailand All 76 Provinces are here!!!
If you want region version, please tell me.
I'll post it ASAP.
Thailand:
(215, 'Chiang Mai'), (215, 'Chiang Rai'), (215, 'Lampang'), (215, 'Lamphun'), (215, 'Mae Hong Son'), (215, 'Nan'), (215, 'Phayao'), (215, 'Phrae'), (215, 'Uttaradit'), (215, 'Kanchanaburi'), (215, 'Phetchaburi'), (215, 'Prachuap Khiri Khan'), (215, 'Ratchaburi'), (215, 'Tak'), (215, 'Amnat Charoen'), (215, 'Buri Ram'), (215, 'Chaiyaphum'), (215, 'Kalasin'), (215, 'Khon Kaen'), (215, 'Loei'), (215, 'Maha Sarakham'), (215, 'Mukdahan'), (215, 'Nakhon Phanom'), (215, 'Nakhon Ratchasima'), (215, 'Nong Bua Lamphu'), (215, 'Nong Khai'), (215, 'Roi Et'), (215, 'Sakon Nakhon'), (215, 'Si Sa Ket'), (215, 'Surin'), (215, 'Ubon Ratchathani'), (215, 'Udon Thani'), (215, 'Yasothon'), (215, 'Ang Thong'), (215, 'Ayutthaya'), (215, 'Bangkok'), (215, 'Chai Nat'), (215, 'Kamphaeng Phet'), (215, 'Lop Buri'), (215, 'Nakhon Nayok'), (215, 'Nakhon Pathom'), (215, 'Nakhon Sawan'), (215, 'Nonthaburi'), (215, 'Pathum Thani'), (215, 'Phetchabun'), (215, 'Phichit'), (215, 'Phitsanulok'), (215, 'Sukhothai'), (215, 'Samut Prakan'), (215, 'Samut Sakhon'), (215, 'Samut Songkhram'), (215, 'Saraburi'), (215, 'Sing Buri'), (215, 'Suphan Buri'), (215, 'Uthai Thani'), (215, 'Chachoengsao'), (215, 'Chanthaburi'), (215, 'Chon Buri'), (215, 'Prachin Buri'), (215, 'Rayong'), (215, 'Sa Kaeo'), (215, 'Trat'), (215, 'Chumphon'), (215, 'Krabi'), (215, 'Nakhon Si Thammarat'), (215, 'Narathiwat'), (215, 'Pattani'), (215, 'Phang Nga'), (215, 'Phatthalung'), (215, 'Phuket'), (215, 'Ranong'), (215, 'Satun'), (215, 'Songkhla'), (215, 'Surat Thani'), (215, 'Trang'), (215, 'Yala)
Amnat Charoen: No Airport
Ang Thong: No Airport
Ayutthaya: No Airport
Bangkok: 2755
Buri Ram: 2232
Chachoengsao: No Airport
Chai Nat: No Airport
Chaiyaphum: No Airport
Chanthaburi: No Airport
Chiang Mai: 243
Chiang Rai: 244
Chon Buri: No Airport
Chumphon: 2304
Kalasin: No Airport
Kamphaeng Phet: No Airport
Kanchanaburi: No Airport
Khon Kaen: 2234
Krabi: 2026
Lampang: 2288
Lamphun: No Airport
Loei: 2296
Lop Buri: No Airport
Mae Hong Son: 2289, 2754
Maha Sarakham: No Airport
Mukdahan: No Airport
Nakhon Nayok: No Airport
Nakhon Pathom: No Airport
Nakhon Phanom: 2294
Nakhon Ratchasima: 2293
Nakhon Sawan: No Airport
Nakhon Si Thammarat: 2298
Nan: 2287
Narathiwat: 2301
Nong Bua Lamphu: No Airport
Nong Khai: No Airport
Nonthaburi: No Airport
Pathum Thani:No Airport
Pattani: No Airport
Phang Nga: No Airport
Phatthalung: No Airport
Phayao: No Airport
Phetchabun: No Airport
Phetchaburi: No Airport
Phichit: No Airport
Phitsanulok: 2285
Phrae: 2286
Phuket: 246
Prachin Buri: No Airport
Prachuap Khiri Khan: 2297
Ranong: 2300
Ratchaburi: No Airport
Rayong: 2235
Roi Et: 2295
Sa Kaeo: No Airport
Sakon Nakhon: 2291
Samut Prakan: 147
Samut Sakhon: No Airport
Samut Songkhram: No Airport
Saraburi: No Airport
Satun: No Airport
Sing Buri: No Airport
Si Sa Ket: No Airport
Songkhla: 245
Sukhothai: 2290
Suphan Buri: No Airport
Surat Thani: 722, 932
Surin: No Airport
Tak: 2303
Trang: 2299
Trat: 2302
Ubon Ratchathani: 2292
Udon Thani: 2236
Uthai Thani: No Airport
Uttaradit: No Airport
Yala: No Airport
Yasothon: No Airport
*Note: 2754, Z35 VTCI Pai Airport > Has IATA code: PYY
*Note2: 147, BKK VTBS Suvarnabhumi Airport - The airport serves Bangkok and Vicinities area but located in Samut Prakarn
-
Thailand
In region form
(215, 'Northern Region'), (215, 'Central Region'), (215, 'North-Eastern Region'), (215, 'Eastern Region'), (215, 'Southern Region')
Northern Region: 243, 244, 2288, 2289, 2754, 2287, 2286
Central Region: 2297, 2303, 2755, 2285, 2290, 147
North-Eastern Region: 2232, 2234, 2296, 2294, 2293, 2295, 2291, 2292, 2236
Eastern Region: 2235, 2302
Southern Region: 2304, 2026, 2298, 2301, 246, 2300, 245, 722, 932, 2299
Edit: Added by StephenM - Thanks
-
Denmark:
(58, 'Hovedstaden'), (58, 'Midtjylland'), (58, 'Nordjylland'), (58, 'Sjælland'), (58, 'Syddanmark')
Hovedstaden: EKCH, EKRN,
Midtjylland: EKAH
Nordjylland: EKTS, EKYT
Sjælland: EKRK
Syddanmark: EKBI, EKSB, EKOD, EKEB
Edit: Added by StephenM - Thanks
-
I would say that small countries don't need regions - e.g. Denmark has ten airports and five regions. No need for regions here. But in the US, there's thousands of airports, there it would be nice to use states. Also, not many people know where the different regions of small countries, so if they say 'an airport in Sjælland' - where's Sjælland? Anyways, I'll be waiting for the regions to be implemented in AM :)
-
Norway (164)
(164, 'Akershus'), (164, 'Aust-Agder'), (164, 'Buskerud'), (164, 'Finnmark'), (164, 'Hedmark'), (164, 'Hordaland'), (164, 'Møre og Romsdal'), (164, 'Nordland'), (164, 'Nord-Trøndelag'), (164, 'Oppland'), (164, 'Oslo'), (164, 'Rogaland'), (164, 'Sogn og Fjordane'), (164, 'Svalbard')* (164, 'Sør-Trøndelag'), (164, 'Telemark'), (164, ' Troms'), (164, 'Vest-Agder'), (164, 'Vestfold'), (164, 'Østfold')
Akershus: 168
Aust-Agder: No airport
Buskerud: No airport
Finnmark: 169, 3232, 639, 3233, 1088, 3230, 1584, 1583, 3231, 1090, 3234
Hedmark: No airport
Hordaland: 170, 3080
Møre og Romsdal: 594, 2030, 1086, 3220
Nordland: 596, 640, 2262, 3223, 599, 3225, 3226, 3228, 3227, 3224, 1089, 2134
Nord-Trøndelag: 595**, 3221, 3222
Oppland: 3217
Oslo: No airport
Rogaland: 1087, 176
Sogn og Fjordane: 3209, 3218, 3219, 3216
Svalbard: 646
Sør-Trøndelag: 2064
Telemark: 3237, 3235
Troms: 3236, 597, 3229
Vest-Agder: 592
Vestfold: 590
Østfold: No airport***
* Svalbard is not a Norwegian fylke, but is listed here as Svalbard Longyear Airport is in AM.
** Trondheim Værnes Airport is in Nord-Trøndelag, but the city it operates for is located in Sør-Trøndelag.
*** Moss Airport Rygge is located in Østfold, but I could'nt find the airport.
Edit: Added by StephenM - Thanks
-
I didn't realise how far behind we got on this project. I've restarted the updates and once the outstanding contributions have been added I'll give an update as to where we are with the states/provinces. We want 50% or more coverage globally.
-
Tunisia (211)
(211, 'Ariana'), (211, 'Béja'), (211, 'Ben Arous'), (211, 'Bizerte'), (211, 'Gabès'), (211, 'Gafsa'), (211, 'Jendouba'), (211, 'Kairouan'), (211, 'Kasserine'), (211, 'Kebili'), (211, 'Kif'), (211, 'Mahdia'), (211, 'Manouba'), (211, 'Medenine'), (211, 'Monastir'), (211, 'Nabeul'), (211, 'Sfax'), (211, 'Sidi Bou Zid'), (211, 'Siliana'), (211, 'Sousse'), (211, 'Tataouine'), (211, 'Tozeur'), (211, 'Tunis'), (211, 'Zaghouan')
Ariana: No airport
Béja: No airport
Ben Aruos: No airport
Bizerte: No airport
Gabès: 3314
Gafsa: 3313
Jendouba: 2188
Kairouan: No airport
Kasserine: No airport
Kebili: No airport
Kif: No airport
Mahdia: No airport
Manouba: No airport
Medenine: 453
Monastir: 454
Nabeul: No airport
Sfax: 2187
Sidi Bou Zid: No airport
Siliana: No airport
Sousse: No airport
Tataouine: No airport
Tozeur: 455
Tunis: 456
Zaghouan: No airport
Edit: Added by StephenM - Thanks
-
All airports up to date, thanks for all the submissions. We are working on getting China completed, the United States has already been added. Any help with some of the other big countries such as Canada and Brazil would be much appreciated.
-
For Canada should I post it by the provinces?
-
For Canada should I post it by the provinces?
Yes, province level is perfect. Thanks.
-
(229, 'Scotland'), (229, 'Wales'), (229, 'East Midlands'), (229, 'East of England'), (229, 'Greater London'), (229, 'North East England'), (229, 'North West England'), (229, 'South East England'), (229, 'South West England'), (229, 'West Midlands'), (229, 'Yorkshire and the Humber'), (229, 'Northern Ireland')
Edit: Missed out NI
Edit: ` changed to '
-
Scotland: 40, 41, 47, 49, 60, 66, 70, 71, 73, 2229, 2215, 2429, 2430, 2433, 2436, 2440, 2441,
Wales: 53, 1391, 2795,
East Midlands: 46,
East of England: 61, 2432,
Greater London: 7, 35, 37, 39, 51, 2431,
North East England: 43, 45, 54,
North West England: 36, 64, 1399, 3072, 3128,
South East England: 52, 67, 1425, 2438, 2439, 2936,
South West England: 42, 55, 56, 65, 69, 72, 2428, 2434, 2435,
West Midlands: 38, 58,
Yorkshire and the Humber: 48, 59, 62,
Northern Ireland: 44, 50, 68,
Think that's the lot.
If needs be, I guess Scotland could be divided up.
Added by StephenM - Thanks
-
Ireland
104 Leinster
104 Munster
104 Ulster
104 Connaught
Leinster-DUB
Munster-WAT,CORK,SNN,KIR
Ulster -CFN
Connaught-GWY,INQ,IIA.IOR,NOC,NNR,SXL
Added by StephenM - Thanks
-
Seychelles (194)
(194, 'Mahé Island'), (194, 'Praslin Island')
Mahé Island: 437
Praslin Island: 2902
Also, please revise the passenger numbers for the airports,
437 handles 675,000 passengers and 2902 handles 212,784 passengers (values from 2008)
Thanks!
Added by StephenM - Thanks
-
Thanks Indian Ocean Airlines! We appreciate your help! Also welcome to the forum. :D
-
Also, please revise the passenger numbers for the airports,
437 handles 675,000 passengers and 2902 handles 212,784 passengers (values from 2008)
Thanks for the data as well. Can you provide us with a source for the information for our records? If you don't want to post a public link, sending a private message is fine too. Thanks again.
-
Also, please revise the passenger numbers for the airports,
437 handles 675,000 passengers and 2902 handles 212,784 passengers (values from 2008)
Thanks for the data as well. Can you provide us with a source for the information for our records? If you don't want to post a public link, sending a private message is fine too. Thanks again.
Sure, the data came from this document: http://www.nsb.gov.sc/Files/Publications/SIF_2009.pdf
Page 20/37 for airport 437.
Page 33/37 for airport 2902.
I've submitted a few airports in Seychelles, they fall under these two additional regions;
(194, 'La Digue and Inner Islands'), (194, 'Outer Islands (Zil Elwannyen Sesel)')
For these airports, the passenger numbers were based on estimates from paper publications which can't be found on the internet
-
Sorry, I know this should be in anothe thread, but does Airline Mogul add airports without an IATA code?
-
Sorry, I know this should be in anothe thread, but does Airline Mogul add airports without an IATA code?
Yes we do (or at least we used to before a little upgrade to the page). The submit_airport page does not allow blank IATA, but you can email us at :staff: with the details, and we will work around it. Thanks.
-
I see you have Dulles airport as located in Chantilly. Dulles airport is located in Dulles, Virginia, which is part of Sterling, Virginia. Chantilly is in Fairfax county, and the only part of dulles in Fairfax would be some of the runways. Although the website may say Chantilly, it is not located in Chantilly. The address of the airport is 45020 Aviation Drive, Sterling, VA 20166 and 20166 is a Sterling ZIP Code. I hope this gets changed, and I have represented my city well :)
-
I see you have Dulles airport as located in Chantilly. Dulles airport is located in Dulles, Virginia, which is part of Sterling, Virginia. Chantilly is in Fairfax county, and the only part of dulles in Fairfax would be some of the runways. Although the website may say Chantilly, it is not located in Chantilly. The address of the airport is 45020 Aviation Drive, Sterling, VA 20166 and 20166 is a Sterling ZIP Code. I hope this gets changed, and I have represented my city well :)
According to the Metropolitan Washington Airports Authority's website...
- The address you have provided is the MWAA Emplyment Dept. address
Metropolitan Washington Airports Authority
Employment Dept. MA-510
1 Aviation Circle
Washington, D.C. 20001-6000
- It is suggested that for GPS, use a Sterling zip code
For door-to-door directions using a GPS device or an internet mapping website, enter this address: 1 Saarinen Circle, Sterling, VA 20166.
- However, facts are...
LOCATION: Dulles, Virginia
LAND
Built on 10,000 acres situated in Loudoun and Fairfax Counties in Virginia, approximately 26 miles from downtown Washington, D.C.
- And of course, on the front page of the website...
Washington Dulles International Airport (IAD) is located in Chantilly, VA on 12,000 acres of land 26 miles from downtown Washington, DC.
So... they don't seem to know where they are located at...
-
Well, all I can say, is that the physical airport main terminals and midfield are in Loudoun County, thus making it impossible to be in Chantilly.
-
Mauritius (139)
(139, 'Grand Port'), (139, 'Black River'), (139, 'Flacq'), (139, 'Moka'), (139, 'Pamplemousses'), (139, 'Plaines Wilhems'), (139, 'Port Louis'), (139, 'Rivière du Rempart'), (139, 'Savanne'), (139, 'Rodrigues'), (139, 'Cargados Carajos Shoals'), (139, 'Agalega Islands')
Grand Port: 431
Rodrigues: 2189
Seychelles (194)
(194, 'Bel Air'), (194, 'Les Mamelles'), (194, 'Mont Buxton'), (194, 'English River'), (194, 'Mont Fleuri'), (194, 'Plaisance'), (194, 'Saint Louis'), (194, 'Roche Caiman'), (194, 'Anse Etoile'), (194, 'Beau Vallon'), (194, 'Glacis'), (194, 'Anse aux Pins'), (194, 'Au Cap'), (194, 'Cascade'), (194, 'Pointe La Rue'), (194, 'Anse Royale'), (194, 'Baie Lazare'), (194, 'Takamaka'), (194, 'Anse Boileau'), (194, 'Port Glaud'), (194, 'Bel Ombre'), (194, 'Gand'Anse Mahé'), (194, 'Baie Sainte Anne (Praslin)'), (194, 'Grand'Anse Praslin'), (194, 'La Digue and Inner Islands'), (194, 'Outer Islands (Zil Elwannyen Sesel)')
Pointe La Rue: 437
Grand'Anse Praslin: 2902
La Digue and Inner Islands: Airports submitted (FSSF, FSSB, FSSD)
Outer Islands (Zil Elwannyen Sesel): Airports submitted (All Other Airports)
City for the airport 437 is Victoria.
Mayotte (140)
(140, 'Pamandzi'), (140, ' Dzaoudzi'), (140, 'Mamoudzou'), (140, 'Dembeni'), (140, 'Bandrele'), (140, 'Kani-Kéli'), (140, 'Bouéni'), (140, 'Chirongui'), (140, 'Sada'), (140, 'Ouangani'), (140, 'Chiconi'), (140, 'Tsingoni'), (140, 'M'Tsangamouji'), (140, 'Acoua'), (140, 'Mtsamboro'), (140, 'Bandraboua'), (140, 'Koungou')
Pamandzi: 2511
Reunion (179)
(179, 'Sainte-Marie'), (179, 'Saint-Pierre'), (179, 'Les Avirons'), (179, 'Bras-Panon'), (179, 'Cilaos'), (179, 'Entre-Deux'), (179, 'L'Étang-Salé'), (179, 'Petite-Île'), (179, 'La Plaine-des-Palmistes'), (179, 'Le Port'), (179, 'La Possession'), (179, 'Saint-André'), (179, 'Saint-Benoît'), (179, 'Sainte-Rose'), (179, 'Sainte-Suzanne'), (179, 'Saint-Joseph'), (179, 'Saint-Leu'), (179, 'Saint-Louis'), (179, 'Saint-Paul'), (179, 'Saint-Denis'), (179, 'Saint-Philippe'), (179, 'Salazie'), (179, 'Le Tampon'), (179, 'Trois-Bassins')
Sainte-Marie: 433
Saint-Pierre: 2512
Sri Lanka (204)
(204, 'Western Province'), (204, 'Southern Province'), (204, 'North Western Province'), (204, 'Central Province'), (204, 'North Central Province'), (204, 'Northern Province'), (204, 'Eastern Province'), (204, 'Uva Province'), (204, 'Sabaragamuwa Province')
Western Province: 516
Southern Province: 2867,2875
Added by StephenM -Thanks
-
Comoros (48)
(48, 'Grande Comore(Ngazidja)'), (48, 'Anjouan(Nzwani)'), (48, 'Moheli(Mwali)')
Grande Comore(Ngazidja): 2734, 2735
Anjouan(Nzwani): 2732
Moheli(Mwali): 2733
Added by StephenM - Thanks
-
Suriname (206)
(206, 'Brokopondo'), (206, 'Commewijne'), (206, 'Coronie'), (206, 'Marowijne'), (206, 'Nickerie'), (206, 'Para'), (206, 'Paramaribo'), (206, 'Saramacca'), (206, 'Sipaliwini'), (206, 'Wanica')
Paramaribo, 1421
Greets RFA
Added by StephenM - Thanks
-
Nederlandse Antillen (155)
This country will cease to excist at October 10th 2010.
Two islands (Curacau and Sint Maarten) will become countries like Aruba.
The other islands will become special counties within the country of the Netherlands.
The split-up will look like this in AM.
Kingdom of the Netherlands
Netherlands (154)
(154, 'Friesland'), (154, 'Groningen'), (154, 'Drenthe'), (154, 'Noord-Holland'), (154, 'Flevoland'), (154, 'Zuid-Holland'), (154, 'Overijssel'), (154, 'Gelderland'), (154, 'Utrecht'), (154, 'Zeeland'), (154, 'Noord-Brabant'), (154, 'Limburg'), (154, 'Nederlandse Antillen'*)
Noord-Holland, 6
Zuid-Holland, 617
Brabant, 20
Overijssel, 2046
Groningen, 611
Limburg, 618
Nederlandse Antillen, 422
Aruba (12)
(12, 'Aruba')
Aruba, 407
Curacao** (?)
(?, 'Curacao')
Curacao, 421
Sint Maarten (?)
(?, 'Sint Maarten')
Sint Maarten, 423
* Officially there will be no provence of Nederlandse Antillen, the left over Islands will be counties not assigned to any provence. Hence the term special counties. In order to keep it understandable for foreigners, I named the group Nederlandse Antillen instead of Speciale Gemeenten.
** The last c is a c with a tail (cedilla), but I couldn`t find it on my keyboard.
Edit by StephenM: We will hold off on the changes until the 10th of October.
-
United Arad Emirates (228)
(228, 'Abu Dhabi'), (228, 'Ajman'), (228, 'Dubai'), (228, 'Fujairah'), (228, 'Ras al-Khaimah'), (228, 'Sharjah'), (228, 'Umm al-Quwain')
Abu Dhabi: 499,1571
Dubai: 500
Fujairah: Fujairah International Airport (OMFJ/FJR) [Airport Submitted]
Ras al-Khaimah: 501
Sharjah: 502
City for 500 is Al Garhoud, not Dubai
Qatar (178)
(178, 'Ad Dawhah'), (178, 'Al Ghuwariyah'), (178, 'Al Jumaliyah'), (178, 'Al Khawr'), (178, 'Al Wakrah'), (178, 'Ar Rayyan'), (178, 'Jariyan al Batnah'), (178, 'Madinat ash Shamal'), (178, 'Umm Salal'), (178, 'Mesaieed')
Ad Dawhah: 495
Added by StephenM - Thanks
-
South Africa (201)
(201, 'Eastern Cape Province'), (201, 'Free State Province'), (201, 'Gauteng Province'), (201, 'KwaZulu-Natal Province'), (201, 'Limpopo Province'), (201, 'Mpumalanga Province'), (201, 'North West Province'), (201, 'Northern Cape Province'), (201, 'Western Cape Province')
Eastern Cape Province: 870, 867, 2900,
Free State Province: 866,
Gauteng Province: 462,1175,
KwaZulu-Natal Province: 865, 2897, 2895, 2898,
Limpopo Province: 2179, 2892, 2896,
Mpumalanga Province: 2094, 2893,
North West Province: 2894, 1177,
Northern Cape Province: 869, 1176
Western Cape Province: 864, 868,
Added by StephenM - Thanks
-
Kenya 113
(113, 'Central Province'), (113, 'Coast Province'), (113, 'Eastern Province'), (113, 'Nairobi Province'), (113, 'North Eastern Province'), (113, 'Nyanza Province'), (113, 'Rift Valley Province'), (113, 'Western Province')
Central Province: None
Coast Province: 3843,3513,167, 3846
Eastern Province: None
Nairobi Province: 166,3842
North Eastern Province: None
Nyanza Province: 3844,
Rift Valley Province: 1148, 3845
Western Province: None
I'll sort some other countries out and post them next week. Sorry about the Seychelles one, got the wrong info :lol:
Added by StephenM - Thanks
-
OK, last one for this week :D
Zimbabwe 243
(243, 'Bulawayo'), (243, 'Harare'), (243, 'Manicaland Province'), (243, 'Mashonaland Central Province'), (243, 'Mashonaland East Province'), (243, 'Mashonaland West Province'), (243, 'Masvingo Province'), (243, 'Matabeleland North Province'), (243, 'Matabeleland South Province'), (243, 'Midlands Province')
Bulawayo: 2193
Harare: 1137
Manicaland Province: None
Mashonaland Central Province: None
Mashonaland East Province: None
Mashonaland West Province: 1138
Masvingo Province: 3208
Matabeleland North Province: 441
Matabeleland South Province: None
Midlands Province: None
Added by StephenM - Thanks
-
OK, here's my contribution to the provinces and regions for the Philippines...
Let me break it down by province instead of just the regions:
Philippines:
(173, 'Abra'), (173, 'Agusan del Norte'), (173, 'Agusan del Sur'), (173, 'Aklan'), (173, 'Albay'), (173, 'Antique'), (173, 'Apayao'), (173, 'Aurora'), (173, 'Basilan'), (173, 'Bataan'), (173, 'Batanes'), (173, 'Batangas'), (173, 'Benguet'), (173, 'Biliran'), (173, 'Bohol'), (173, 'Bukidnon'), (173, 'Bulacan'), (173, 'Cagayan'), (173, 'Camarines Norte'), (173, 'Camarines Sur'), (173, 'Camiguin'), (173, 'Capiz'), (173, 'Catanduanes'), (173, 'Cavite'), (173, 'Cebu'), (173, 'Compostela Valley'), (173, 'Cotabato'), (173, 'Davao del Norte'), (173, 'Davao del Sur'), (173, 'Davao Oriental'), (173, 'Eastern Samar'), (173, 'Guimaras'), (173, 'Ifugao'), (173, 'Ilocos Norte'), (173, 'Ilocos Sur'), (173, 'Iloilo'), (173, 'Isabela'), (173, 'Kalinga'), (173, 'La Union'), (173, 'Laguna'), (173, 'Lanao del Norte'), (173, 'Lanao del Sur'), (173, 'Leyte'), (173, 'Maguindanao'), (173, 'Marinduque'), (173, 'Masbate'), (173, 'Misamis Occidental'), (173, 'Misamis Oriental'), (173, 'Mountain Province'), (173, 'Negros Occidental'), (173, 'Negros Oriental'), (173, 'Northern Samar'), (173, 'Nueva Ecija'), (173, 'Nueva Vizcaya'), (173, 'Occidental Mindoro'), (173, 'Oriental Mindoro'), (173, 'Palawan'), (173, 'Pampanga'), (173, 'Pangasinan'), (173, 'Quezon Province'), (173, 'Quirino'), (173, 'Rizal'), (173, 'Romblon'), (173, 'Samar'), (173, 'Sarangani'), (173, 'Siquijor Province'), (173, 'Sorsogon Province'), (173, 'South Cotabato'), (173, 'Southern Leyte'), (173, 'Sultan Kudarat'), (173, 'Sulu'), (173, 'Surigao del Norte'), (173, 'Surigao del Sur'), (173, 'Tarlac'), (173, 'Tawi Tawi'), (173, 'Zambales'), (173, 'Zamboanga del Norte'), (173, 'Zamboanga del Sur'), (173, 'Zamboanga Sibugay')
[Note: I disregarded the National Capital Region because it has been listed]
For each of the provinces listed, here's the codes:
Abra:
Agusan del Norte: 910
Agusan del Sur:
Aklan: 906, 826
Albay: 720,
Antique:
Apayao:
Aurora: 3475
Basilan:
Bataan: 3477
Batanes: 1093
Batangas:
Benguet: 827
Biliran:
Bohol: 844
Bukidnon:
Bulacan: 3474
Cagayan: 845
Camarines Norte:
Camarines Sur: 907
Camiguin Province: 1095
Capiz: 837
Catanduanes: 1099
Cavite:
Cebu: 471
Compostela Valley:
Cotabato:
Davao del Norte:
Davao del Sur: 470,
Davao Oriental:
Eastern Samar:
Guimaras:
Ifugao:
Ilocos Norte: 803
Ilocos Sur: 3168
Iloilo: 792
Isabela: 3472, 3473
Kalinga:
La Union: 1096
Laguna:
Lanao del Norte: 1094
Lanao del Sur:
Leyte: 840, 3481
Maguindanao: 846
Marinduque: 843
Masbate: 842
Misamis Occidental: 1098
Misamis Oriental: 839
Mountain Province:
Negros Occidental: 719
Negros Oriental: 841
Northern Samar: 3480
Nueva Ecija:
Nueva Vizcaya:
Occidental Mindoro: 847
Oriental Mindoro:
Palawan: 3476, 905, 836
Pampanga: 793
Pangasinan: 3484
Quezon Province:
Quirino:
Rizal:
Romblon: 3478
Samar: 3479
Sarangani:
Siquijor Province:
Sorsogon Province:
South Cotabato: 795
Southern Leyte:
Sultan Kudarat:
Sulu: 3482
Surigao del Norte: 3483
Surigao del Sur:
Tarlac:
Tawi Tawi: 908
Zambales: 904
Zamboanga del Norte: 909
Zamboanga del Sur: 1097, 838
Zamboanga Sibugay:
Along with the existing list, there are more airports than presently listed in AM, and I want to add them to the list, along with amendments to the current list:
(For coordinates of these airports, please check Wikipedia link below. If a code is shown as ____, it means there is no IATA or ICAO code provided to the airport at this time.)
Airport name: Sayak
City: Siargo Island
Province: Surigao del Norte
Airport codes: IATA: IAO; ICAO: RPNS
Passengers served: 10,170
Cargo served: 1
Notes: Change Siargo to Siargao, add ICAO with RPNS
Airport name: Evelio Javier
City: San Jose
Province: Antique
Airport codes: IATA: EUQ ; ICAO: RPVS
Passengers served: 5,000
Cargo served: 0
Notes: New airport for listing
Airport name: Tandag
City: Tandag City
Province: Surigao del Sur
Airport codes: IATA: TDG; ICAO: RPMW
Passengers served: 2,000
Cargo served: 0
Notes: New airport for listing
Airport name: Alabat
City: Perez
Province: Quezon Province
Airport codes: IATA: _____ ; ICAO: RPLY
Passengers served: 600
Cargo served: 0
Notes: New airport for listing
Airport name: Allah Valley
City: Surallah
Province: South Cotabato
Airport codes: IATA: AAV; ICAO: RPMA
Passengers served: 2,000
Cargo served: 0
Notes: New airport for listing
Airport name: Bagabag
City: Bagabag
Province: Nueva Vizcaya
Airport codes: IATA: ______; ICAO: RPUZ
Passengers served: 1,000
Cargo served: 0
Notes: New airport for listing
Airport name: Bantayan
City: Santa Fe
Province: Cebu
Airport codes: IATA: ______; ICAO: RPSB
Passengers served: 1,000
Cargo served: 0
Notes: New airport for listing
Airport name: Naval
City: Naval
Province: Biliran
Airport codes: IATA: ______; ICAO: RPVQ
Passengers served: 1,500
Cargo served: 0
Notes: New airport for listing
Airport name: Bislig
City: Bislig City
Province: Surigao del Sur
Airport codes: IATA: BPH; ICAO: RPMF
Passengers served: 1,500
Cargo served: 0
Notes: New airport for listing
Airport name: Punta Maria
City: Borongan
Province: Eastern Samar
Airport codes: IATA: BPR; ICAO: RPVW
Passengers served: 1,500
Cargo served: 0
Notes: New airport for listing
Airport name: Bulan
City: Bulan
Province: Sorsogon Province
Airport codes: IATA: ______; ICAO: RPUU
Passengers served: 1,000
Cargo served: 0
Notes: New airport for listing
Airport name: Calapan
City: Calapan City
Province: Oriental Mindoro
Airport codes: IATA: ______; ICAO: RPUK
Passengers served: 1,000
Cargo served: 0
Notes: New airport for listing
Airport name: Mapun
City: Cagayan de Tawi Tawi
Province: Tawi Tawi
Airport codes: IATA: CDY; ICAO: RPMU
Passengers served: 1,000
Cargo served: 0
Notes: New airport for listing
Airport name: Catbalogan
City: Catbalogan City
Province: Samar
Airport codes: IATA: _____; ICAO: RPVY
Passengers served: 1,500
Cargo served: 0
Notes: New airport for listing
Airport name: Bagasbas
City: Daet
Province: Camarines Norte
Airport codes: IATA: DTE; ICAO: RPUD
Passengers served: 1,500
Cargo served: 0
Notes: New airport for listing
Airport name: Guiuan
City: Guiuan
Province: Eastern Samar
Airport codes: IATA: _____; ICAO: RPVG
Passengers served: 1,000
Cargo served: 0
Notes: New airport for listing
Airport name: Hilongos
City: Hilongos
Province: Leyte
Airport codes: IATA: _____; ICAO: RPVH
Passengers served: 1,000
Cargo served: 0
Notes: New airport for listing
Airport name: Iba
City: Iba
Province: Zambales
Airport codes: IATA: _____; ICAO: RPUI
Passengers served: 1,000
Cargo served: 0
Notes: New airport for listing
Airport name: Ipil
City: Ipil
Province: Zamboanga Sibugay
Airport codes: IATA: IPE; ICAO: RPMV
Passengers served: 1,500
Cargo served: 0
Notes: New airport for listing
Airport name: Itbayat
City: Itbayat
Province: Batanes
Airport codes: IATA: _____; ICAO: RPLT
Passengers served: 1,000
Cargo served: 0
Notes: New airport for listing
Airport name: Jomalig (Polilio Island)
City: Jomalig
Province: Quezon Province
Airport codes: IATA: _____; ICAO: RPLJ
Passengers served: 1,000
Cargo served: 0
Notes: New airport for listing
Airport name: Liloy
City: Liloy
Province: Zamboanga del Norte
Airport codes: IATA: _____; ICAO: RPMX
Passengers served: 1,000
Cargo served: 0
Notes: New airport for listing
Airport name: Panan-awan
City: Maasin City
Province: Southern Leyte
Airport codes: IATA: _____; ICAO: RPSM
Passengers served: 1,000
Cargo served: 0
Notes: New airport for listing
Airport name: Malabang
City: Malabang
Province: Lanao del Sur
Airport codes: IATA: MLP; ICAO: RPMM
Passengers served: 1,000
Cargo served: 0
Notes: New airport for listing
Airport name: Malaybalay
City: Malaybalay City
Province: Bukidnon
Airport codes: IATA: _____; ICAO: RPMY
Passengers served: 1,500
Cargo served: 0
Notes: New airport for listing
Airport name: Mamburao
City: Mamburao
Province: Occidental Mindoro
Airport codes: IATA: ______; ICAO: RPUM
Passengers served: 1,000
Cargo served: 0
Notes: New airport for listing
Airport name: Wasig (Mansalay)
City: Mansalay
Province: Oriental Mindoro
Airport codes: IATA: ______; ICAO: RPLG
Passengers served: 1,000
Cargo served: 0
Notes: New airport for listing
Airport name: Mati National
City: Mati City
Province: Davao Oriental
Airport codes: IATA: MXI; ICAO: RPMQ
Passengers served: 1,000
Cargo served: 0
Notes: New airport for listing
Airport name: Pinamalayan
City: Pinamalayan
Province: Oriental Mindoro
Airport codes: IATA: _____; ICAO: RPLA
Passengers served: 1,000
Cargo served: 0
Notes: New airport for listing
Airport name: Rosales
City: Rosales
Province: Pangasinan
Airport codes: IATA: _____; ICAO: RPLR
Passengers served: 1,000
Cargo served: 0
Notes: New airport for listing
Airport name: Siocon
City: Siocon City
Province: Zamboanga del Norte
Airport codes: IATA: XSO; ICAO: RPNO
Passengers served: 1,000
Cargo served: 0
Notes: New airport for listing
Airport name: Siquijor
City: Siquijor
Province: Siquijor Province
Airport codes: IATA: _____; ICAO: RPVZ
Passengers served: 1,000
Cargo served: 0
Notes: New airport for listing
Airport name: Sorsogon
City: Sorsogon City
Province: Sorsogon Province
Airport codes: IATA: _____; ICAO: RPLZ
Passengers served: 1,000
Cargo served: 0
Notes: New airport for listing
Airport name: Ubay
City: Ubay
Province: Bohol
Airport codes: IATA: _____; ICAO: RPSN
Passengers served: 1,000
Cargo served: 0
Notes: New airport for listing
Airport name: Aparri
City: Aparri
Province: Cagayan
Airport codes: IATA: _____; ICAO: RPUA
Passengers served: 500
Cargo served: 0
Notes: New airport for listing
Airport name: Cabanatuan
City: Cabanatuan City
Province: Nueva Ecija
Airport codes: IATA: _____; ICAO: RPUC
Passengers served: 1,000
Cargo served: 0
Notes: New airport for listing
Airport name: Casiguran
City: Casiguran
Province: Aurora
Airport codes: IATA: CGG; ICAO: _____
Passengers served: 1,000
Cargo served: 0
Notes: New airport for listing
Airport name: Baganga
City: Baganga
Province: Davao Oriental
Airport codes: IATA: BNQ; ICAO: _____
Passengers served: 1,000
Cargo served: 0
Notes: New airport for listing
Airport name: Jesus Magsaysay Airfield
City: Castillejos
Province: Zambales
Airport codes: IATA: _____; ICAO: RPUJ
Passengers served: 1,000
Cargo served: 0
Notes: New airport for listing
Airport name: Pacific Air-VAL Coron
City: Coron
Province: Palawan
Airport codes: IATA: XCN; ICAO: _____
Passengers served: 1,000
Cargo served: 0
Notes: New airport for listing
Airport name: Del Monte Plantation Airstrip
City: Manolo Fortich
Province: Bukidnon
Airport codes: IATA: _____; ICAO: RPMT
Passengers served: 500
Cargo served: 0
Notes: New airport for listing
Airport name: Dilasag
City: Dilasag
Province: Aurora
Airport codes: IATA: DSG; ICAO: _____
Passengers served: 500
Cargo served: 0
Notes: New airport for listing
Airport name: Dolores
City: Dolores
Province: Eastern Samar
Airport codes: IATA: _____; ICAO: RPVX
Passengers served: 500
Cargo served: 0
Notes: New airport for listing
Airport name: El Nido
City: El Nido
Province: Palawan
Airport codes: IATA: ENI; ICAO: _____
Passengers served: 1,500
Cargo served: 0
Notes: New airport for listing
Airport name: Larap
City: Jose Panganiban
Province: Camarines Norte
Airport codes: IATA: _____; ICAO: RPUP
Passengers served: 1,000
Cargo served: 0
Notes: New airport for listing
Airport name: Lucena
City: Lucena City
Province: Quezon Province
Airport codes: IATA: _____; ICAO: RPUE
Passengers served: 1,500
Cargo served: 0
Notes: New airport for listing
Airport name: Maramag
City: Maramag
Province: Bukidnon
Airport codes: IATA: XMA; ICAO: _____
Passengers served: 500
Cargo served: 0
Notes: New airport for listing
Airport name: Medellin
City: Medellin
Province: Cebu
Airport codes: IATA: _____; ICAO: RPVN
Passengers served: 1,000
Cargo served: 0
Notes: New airport for listing
Airport name: Roxas-Del Pilar
City: Roxas
Province: Palawan
Airport codes: IATA: _____; ICAO: RPVL
Passengers served: 1,500
Cargo served: 0
Notes: New airport for listing
Airport name: Semirara
City: Caluya
Province: Antique
Airport codes: IATA: _____; ICAO: RPSR
Passengers served: 1,000
Cargo served: 0
Notes: New airport for listing
Airport name: Siasi
City: Siasi
Province: Sulu
Airport codes: IATA: SSV; ICAO: _____
Passengers served: 1,000
Cargo served: 0
Notes: New airport for listing
Airport name: Carles
City: Carles
Province: Iloilo
Airport codes: IATA: ICO; ICAO: _____
Passengers served: 1,000
Cargo served: 0
Notes: New airport for listing
Airport name: Kenram (Tacurong)
City: Tacurong City
Province: Sultan Kudarat
Airport codes: IATA: _____; ICAO: RPMK
Passengers served: 1,500
Cargo served: 0
Notes: New airport for listing
Airport name: Tagbita
City: Rizal
Province: Palawan
Airport codes: IATA: TGB; ICAO: _____
Passengers served: 500
Cargo served: 0
Notes: New airport for listing
Airport name: Cesar Lim Rodriguez (Taytay-Sandoval)
City: Taytay
Province: Palawan
Airport codes: IATA: RZP; ICAO: RPSD
Passengers served: 2,000
Cargo served: 0
Notes: New airport for listing
The list above is exhaustive and covers all the airports in the country that currently have the IATA and ICAO codes. Some other airports that do not have ICAO or have outdated ICAO codes are currently not listed, as well as airports currently under construction.
(side comment: this is the most extensive airport listing I have ever made for all Philippine airports, and I will keep you posted when the new airports come out)
Sources:
- http://en.wikipedia.org/wiki/List_of_airports_in_the_Philippines
- http://www.caap.gov.ph/
-
First, thanks for the list of Filipino airports, wishfulanthony.
- The typo for IAO has been corrected.
- Please provide us with the correct passenger data. The pax you listed are not the ones from CAAP. In fact, we have added all reporting airports with commercial services from the CAAP 2009 statistics file on Jun 11, 2010. We know that the CAAP list is no where near exhaustive, and some data is missing. Therefore, if you could find out the realistic data, we would be happy to add them. Thanks. :)
-
Thanks about noting the incorrect passenger data. The problem is that while I tried looking for the correct passenger data for all the new airports, the actual number of passengers served for the past 5 years are not shown, or worse, do not exist! I have just placed the numbers based on my estimates, but I will continue the search for the correct passenger data. If ever I cannot find them, though, I will notify you so that we can conduct a search together in the process.
I may have provided the new airports, but, sometimes, the main passenger data cannot be comprehensive; the cargo data, though, are zero since they do not operate to any of the airports I listed.
-
Maldives (133)
(133, 'Mathi-Uthuru (Upper North) Province'), (133, 'Uthuru (North) Province'), (133, 'Malé Province'), (133, 'Medhu-Uthuru (North Central) Province'), (133, 'Medhu (Central) Province'), (133, 'Mathi-Dhekunu (Upper South) Province'), (133, 'Medhu-Dhekunu (South Central) Province'), (133, 'Dhekunu (South) Province')
Mathi-Uthuru (Upper North) Province: 2257
Uthuru (North) Province: None
Malé Province: 512
Medhu-Uthuru (North Central) Province: None
Medhu (Central) Province: None
Mathi-Dhekunu (Upper South) Province: 2259
Medhu-Dhekunu (South Central) Province: 2258
Dhekunu (South) Province: 2255
Added by StephenM - Thanks
-
Uganda (226)
(226, 'Kalangala'), (226, 'Kampala'), (226, 'Kayunga'), (226, 'Kiboga'), (226 'Luwero'), (226, 'Lyantonde'), (226, 'Masaka'), (226 'Mityana'), (226, 'Mpigi'), (226, 'Mubende'), (226, 'Mukono'), (226, 'Nakaseke'), (226, 'Nakasongola'), (226, 'Rakai'), (226, 'Sembabule'), (226, 'Wakiso'), (226, 'Amuria'), (226, 'Budaka'), (226, 'Bududa'), (226, 'Bugiri'), (226, 'Bukedea'), (226, 'Bukwa'), (226, 'Busia'), (226, 'Butaleja'), (226, 'Iganga'), (226, 'Jinja'), (226, 'Kaberamaido'), (226, 'Kaliro'), (226, 'Kamuli'), (226, 'Kapchorwa'), (226, 'Katakwi'), (226, 'Kumi'), (226, 'Manafwa'), (226, 'Mayuge'), (226, 'Mbale'), (226, 'Namutumba'), (226, 'Pallisa'), (226, 'Sironko'), (226, 'Soroti'), (226, 'Tororo'), (226, 'Abim'), (226, 'Adjumani'), (226, 'Amolatar'), (226, 'Amuru'), (226, 'Apac'), (226, 'Arua'), (226, 'Dokolo'), (226, 'Gulu'), (226, 'Kaabong'), (226, 'Kitgum'), (226, 'Koboko'), (226, 'Kotido'), (226, 'Lira'), (226, 'Maracha-Terego'), (226, 'Moroto'), (226, 'Moyo'), (226, 'Nakapiripirit'), (226, 'Nebbi'), (226, 'Oyam'), (226, 'Pader'), (226, 'Yumbe'), (226, 'Bulisa'), (226, 'Bundibugyo'), (226, 'Bushenyi'), (226, 'Hoima'), (226, 'Ibanda'), (226, 'Isingiro'), (226, 'Kabale'), (226, 'Kabarole'), (226, 'Kamwenge'), (226, 'Kanungu'), (226, 'Kasese'), (226, 'Kibale'), (226, 'Kiruhura'), (226, 'Kisoro'), (226, 'Kyenjojo'), (226, 'Masindi'), (226, 'Mbarara'), (226, 'Ntungamo'), (226, 'Rukungiri')
Mukono: 1150
Added by StephenM - Thanks
-
Swaziland (204)
(204, 'Hhohho'), (204, 'Lubombo'), (204, 'Manzini'), (204, 'Shiselweni')
Manzini: 2899
Lesotho (122)
(122, 'Berea'), (122, 'Butha-Buthe'), (122, 'Butha-Buthe'), (122, 'Leribe'), (122, 'Mafeteng'), (122, 'Maseru'), (122, 'Mohale's Hoek'), (122, 'Mokhotlong'), (122, 'Qacha's Nek'), (122, 'Quthing'), (122, 'Thaba-Tseka')
Maseru: 2901
-
Mozambique (149)
(149, 'Cabo Delgado Province'), (149, 'Gaza Province'), (149, 'Inhambane Province'), (149, 'Manica Province'), (149, 'Maputo City'), (149, 'Maputo Province'), (149, 'Nampula Province'), (149, 'Niassa Province'), (149, 'Sofala Province'), (149, 'Tete Province'), (149, 'Zambezia Province')
Maputo City: 1490
Sofala Province: 2031
Kuwait (117)
(117, 'Al Ahmadi Governorate'), (117, 'Al Farwaniyah Governorate'), (117, 'Al Asimah Governorate'), (117, 'Al Jahra Governorate'), (117, 'Hawalli Governorate'), (117, 'Mubarak Al-Kabeer Governorate')
Al Farwaniyah Governorate: 493
Zambia (242)
(242, 'Central Province'), (242, 'Copperbelt Province'), (242, 'Eastern Province'), (242, 'Luapula Province'), (242, 'Lusaka Province'), (242, 'Northern Province'), (242, 'North-Western Province'), (242, 'Southern Province'), (242, 'Western Province')
Central Province: None
Copperbelt Province: 2722
Eastern Province: 2720, 1145
Luapula Province: None
Lusaka Province: 439
Northern Province: None
North-Western Province: 2723
Southern Province: 2721
Western Province: None
Namibia 151
(151, 'Caprivi Region'), (151, 'Erongo Region'), (151, 'Hardap Region'), (151, 'Karas Region'), (151, 'Kavango Region'), (151, 'Khomas Region'), (151, 'Kunene Region'), (151, 'Ohangwena Region'), (151, 'Omaheke Region'), (151, 'Omusati Region'), (151, 'Oshana Region'), (151, 'Oshikoto Region'), (151, 'Otjozondjupa Region')
Caprivi Region: 3306
Erongo Region: 1591
Hardap Region: None
Karas Region: 3309, 3310
Kavango Region: 3307
Khomas Region: 1477, 873
Kunene Region: None
Ohangwena Region: None
Omaheke Region: None
Omusati Region: None
Oshana Region: 3308
Oshikoto Region: None
Otjozondjupa Region: None
-
Why are we doing all the lous... I mean small countries? Are all the goo... I mean big done? (big/small in airport count)
-
Why are we doing all the lous... I mean small countries? Are all the goo... I mean big done? (big/small in airport count)
Maybe you could help with the big ones?
Brazil
566 Acre
567 Alagoas
568 Amap?
569 Amazonas
570 Bahia
571 Cear?
572 Distrito Federal
573 Esp?rito Santo
574 Goi?s
575 Maranh?o
576 Mato Grosso
577 Mato Grosso do Sul
578 Minas Gerais
579 Par?
580 Para?ba
581 Paran?
582 Pernanbuco
583 Piau?
584 Rio de Janeiro
585 Rio Grande do Norte
586 Rio Grande do Sul
587 Rond?nia
588 Roraima
589 Santa Catarina
590 S?o Paulo
591 Sergipe
592 Tocantins
Canada
29 British Columbia
30 Alberta
31 Manitoba
32 New Brunswick
33 Newfoundland and Labrador
34 Northwest Territories
35 Nova Scotia
36 Nunavut
37 Ontario
38 Prince Edward Island
39 Qu?bec
40 Saskatchewan
41 Yukon
^ States for two of the still missing large countries. You can help with assigning the airports to the states ;)
-
Rwanda (182)
(182, 'Northern Intara/Province'), (182, 'Eastern Intara/Province'), (182, 'Southern Intara/Province'), (182, 'Western Intara/Province'), (182, 'Kigali Intara/Province')
Kigali Intara/Province: 434
Sao Tome and Principe (190)
(190, 'Principe'), (190, 'Sao Tome')
Principe: 2882
Sao Tome: 2880
Cameroon (37)
(37, 'Adamawa (Adamaoua) Region'), (37, 'Centre Region'), (37, 'East (Est) Region'), (37, 'Far North (Extrême-Nord) Region'), (37, 'Littoral Region'), (37, 'North (Nord) Region'), (37, 'Northwest (Nord-Ouest) Region'), (37, 'South (Sud) Region'), (37, 'Southwest (Sud-Ouest) Region'), (37, 'West (Ouest) Region')
Adamawa (Adamaoua) Region: 3457
Centre Region:1149
East (Est) Region: 3459
Far North (Extrême-Nord) Region: 3458
Littoral Region: 1497
North (Nord) Region: 1173
Northwest (Nord-Ouest) Region: 3461
South (Sud) Region: None
Southwest (Sud-Ouest) Region: None
West (Ouest) Region: 3460
-
Why are we doing all the lous... I mean small countries? Are all the goo... I mean big done? (big/small in airport count)
I could do the "goo... big countries" but the "lous... small countries" are more challenging, given the fact that I live in one :)
-
Brunei Darussalam (32)
(32, 'Belait District/Daerah'), (32, 'Brunei and Muara District/Daerah'), (32, 'Temburong District/Daerah'), (32, 'Tutong District/Daerah')
Brunei and Muara District/Daerah: 791
Singapore (196)
(196, 'Central Region'), (196, 'East Region'), (196, 'North Region'), (196, 'North-East Region'), (196, 'West Region')
East Region: 148, 1423
North-East Region: 1424
Eritrea (66)
(66, 'Maekel (Central) Region'), (66, 'Debub (Southern) Region'), (66, 'Gash-Barka Region'), (66, 'Anseba Region'), (66, 'Northern Red Sea Region'), (66, 'Southern Red Sea Region')
Maekel (Central) Region:1155
Northern Red Sea Region: 1605
Luxembourg (127)
(127, 'Diekirch District'), (127, 'Grevenmacher District'), (127, 'Luxembourg District')
Luxembourg District: 768
I'll add a few more this week and next week.
Hope all this helps! :)
-
France:
(73, 'Nord-Pas-De-Calais') (73, 'Picardie') (73, 'Haute-Normandie') (73, 'Ile-De-France') (73, 'Champagne-Ardenne') (73, 'Lorraine') (73, 'Alsace') (73, 'Basse-Normandie') (73, 'Bretagne') (73, 'Pays De La Loire') (73, 'Centre') (73, 'Bourgogne') (73, 'Franche-Comte') (73, 'Poitou-Charentes') (73, 'Limousin') (73, 'Auvergne') (73, 'Rhone-Alpes') (73, 'Aquitaine') (73, 'Midi-Pyrenees') (73, 'Languedoc-Roussillon') (73, 'Alpes-Cote d'Azur') (73, 'Corse')
Japan:
(109, 'Sapporo-ken') (109, 'Nemuro-ken') (109, 'Kagoshima-ken') (109, 'Iwate-ken') (109, 'Fukushima-ken') (109, 'Nagano-ken') (109, 'Niigata-ken') (109, 'Akita-ken') (109, 'Gifu-ken') (109, 'Aomori-ken') (109, 'Yamagata-ken') (109, 'Hy?go-ken') (109, 'Miyagi-ken') (109, 'Ishikawa-ken') (109, 'Hiroshima-ken') (109, 'Hakodate-ken') (109, 'Shizuoka-ken') (109, 'Kumamoto-ken') (109, 'K?chi-ken') (109, 'Ehime-ken') (109, 'Shimane-ken') (109, 'Okayama-ken') (109, 'Tochigi-ken') (109, 'Gunma-ken') (109, '?ita-ken') (109, 'Nagasaki-ken') (109, 'Yamaguchi-ken') (109, 'Ibaraki-ken') (109, 'Mie-ken') (109, 'Chiba-ken') (109 'Fukuoka-ken') (109 '?saka-fu') (109, 'Aichi-ken') (109, 'Wakayama-ken') (109, 'Ky?to-fu') (109, 'Yamanashi-ken') (109, 'Fukui-ken') (109, 'Tokushima-ken') (109 'Saitama-ken') (109, 'Shiga-ken') (109, 'Kanagawa-ken') (109, 'Tottori-ken') (109, 'Okinawa-ken') (109, 'T?ky?-fu')
Sweden:
(209, 'Stockholm') (209, 'Vasterbotten') (209, 'Norrbotten') (209, 'Uppsala') (209, 'Sodermanland') (209, 'Ostergotland') (209, 'Jonkoping') (209, 'Kronoberg') (209, 'Kalmar') (209, 'Gotland') (209, 'Blekinge') (209, 'Skane') (209, 'Halland') (209, 'Vastra Gotaland') (209, 'Varmland') (209, 'Orebro') (209, 'Vastmanland') (209, 'Dalarna') (209, 'Gavleborg') (209, 'Vasternorrland') (209, 'Jamtland')
-
Japan:
"(109 '?saka-fu')"
I apologise for the question marks, it doesn't recognise accented letters. Most of the question marks replaced o's
-
Continuing from my list above...
Sweden:
AGH - 'Gotland'
AJR - 'Norrbotten'
BLE - 'Dalarna'
GSE - 'Vastra Gotaland' (Please note inconsistency in the airport's city list here. Gothenburg and Goteborg are the same city. Goteborg is the Swedish spelling.)
GOT - 'Vastra Gotaland' (Please note inconsistency in the airport's city list here. Gothenburg and Goteborg are the same city. Goteborg is the Swedish spelling.)
HFS - 'Varmland'
HAD - 'Halland'
EVG - 'Jamtland'
HMV - 'Vasterbotten'
HLF - 'Kalmar'
JKG - 'Jonkoping'
KLR - 'Kalmar'
KSD - 'Varmland'
KRN - 'Norrbotten'
KRF - 'Vasternorrland'
KID - 'Skane'
GEV - 'Norrbotten'
LPI - 'Ostergotland'
LLA - 'Norrbotten'
LYC - 'Vasterbotten'
MMX - 'Skane'
MXX - 'Dalarna'
NRK - 'Ostergotland'
ORB - 'Orebro'
OER - 'Vasternorrland'
OSK - 'Kalmar'
OSD - 'Jamtland'
PJA - 'Norrbotten'
RNB - 'Blekinge'
VHM - 'Vasterbotten' (I believe the airport is called 'Vilhelmina' not 'Sagadal')
SFT - 'Vasterbotten'
VXO - 'Kronoberg' (I believe the airport is called 'Vaxjo-Smaland' not just 'Smaland' hence where the IATA 'VXO' comes from.)
NYO - 'Sodermanland' (Continuity error, add hyphen in name between 'Stockholm' and 'Skavsta')
ARN - 'Stockholm'
BMA - 'Stockholm'
VST - 'Vastmanland'
SQO - 'Vasterbotten' (I believe the airport is called 'Storuman' not 'Storumans')
SDL - 'Vasternorrland'
TYF - 'Varmland'
THN - 'Vastra Gotaland'
UME - 'Vasterbotten'
VBY - 'Gotland'
Please note that the Counties have accents, which I have not added.
I will do the same for French and Japanese airports soon.
-
Italy (107)
(38, 'Abruzzo'), (38, 'Aosta Valley'), (38, 'Apulia'), (38, 'Basilicata'), (38, 'Calabria'), (38, 'Campania'), (38, 'Emilia–Romagna'), (38, 'Friuli–Venezia Giulia'), (38, 'Lazio'), (38, 'Liguria'), (38, 'Lombardy'), (38, 'Marche'), (38, 'Molise'), (38, 'Piedmont'), (38, 'Sardinia'), (38, 'Sicilia'), (38, 'Tuscany'), (38, 'Trentino-Alto Adige/Südtirol'), (38, 'Umbria'), (38, 'Veneto')
Airports in the regions:
Abruzzo: 1441
Aosta Valley: 2274
Apulia: 2275, 1453, 1454, 3786
Basillicata: no airport
Calabria: 1276, 2267, 2276
Campania: 153, 3785
Emilia-Romagna: 1458, 2266, 154, 1457
Friuli-Venezia Giulia: 1459
Lazio: 1102, 149
Liguria: 2272, 2108
Lombardy: 2263, 151, 150, 155
Marche: 1452
Molise: no airport
Piedmont: 3787, 2271, 854
Sardinia: 1278, 1455, 1456, 3117
Sicilia: 1105, 1106, 2264, 2265, 1104
Tuscany: 152, 3340, 859, 3341, 2273
Trentino-Alto Adige/Südtiro: 2268
Umbria: 2270
Veneto: 3342, 636, 1190, 1460
-
India:
(100, 'Andaman and Nicobar Islands'), (100, 'Andhra Pradesh'), (100, 'Arunachal Pradesh'), (100, 'Assam'), (100, 'Bihar'), (100, 'Chandigarh'), (100, 'Chhattisgarh'), (100, 'Daman and Diu'), (100, 'Delhi'), (100, 'Goa'), (100, 'Gujarat'), (100, 'Haryana'), (100, 'Himachal Pradesh'), (100, 'Jammu and Kashmir'), (100, 'Jharkhand'), (100, 'Karnataka'), (100, 'Kerala'), (100, 'Lakshadweep'), (100, 'Madhya Pradesh'), (100, 'Maharashtra'), (100, 'Manipur'), (100, 'Meghalaya'), (100, 'Mizoram'), (100, 'Nagaland'), (100, 'Orissa'), (100, 'Pondicherry'), (100, 'Punjab'), (100, 'Rajasthan'), (100, 'Tamil Nadu'), (100, 'Tripura'), (100, 'Uttar Pradesh'), (100, 'Uttarakhand'), (100, 'West Bengal')
Andaman and Nicobar Islands: 2254
Andhra Pradesh: 1496, 2407, 2415, 2417, 2342
Arunachal Pradesh: 2414
Assam: 2379, 508, 2390, 2411, 2413, 3517
Bihar: 3519, 2055
Chandigarh: 2378
Chhattisgarh: 2408
Daman and Diu: 2380
Delhi: 506
Goa: 507
Gujarat: 503, 2335, 2375, 2416, 2389, 2392, 2395, 2406, 2409, 2412, 2416
Himachal Pradesh: 2393, 2397, 2410
Jammu and Kashmir: 2388, 2400, 2339
Jharkhand: 2401
Karnataka: 2385, 876, 2376, 2278
Kerala: 1499, 504, 1781
Lakshadweep: 2372
Madhya Pradesh: 2377, 2384, 2387, 2391, 2338
Maharashtra: 2374, 2396, 511, 3518, 2279, 2404
Manipur: 2386
Mizoram: 2373
Nagaland: 2382
Orissa: 2336,
Pondicherry: 2405
Punjab: 1517, 2402, 3516
Rajasthan: 509, 2337, 2341
Tamil Nadu: 505, 2054, 2403, 2340
Uttar Pradesh: 2333, 2371, 2383, 2394, 2280, 2343
Uttarakhand: 2381, 3515
West Bengal: 510, 2334
Missing ones at AirlineMogul
Andaman and Nicobar Islands: VOCX
Andhra Pradesh: VOCP, VODK, VODG, VOHS, VOPN, VOBZ, VOWA
Arunachal Pradesh: VEAN, VEDZ, VEPG, VEZO
Assam: VECA, VEKR, VERU
Bihar: VEMZ, VEPU, VERL
Chhattisgarh: VABI
Daman and Diu: VADN
Delhi: VIDD
Gujarat: VASN, VIUT
Haryana: VIAM
Jammu and Kashmir: VISR, VIUX
Jharkhand: VECK, VEJS
Karnataka: VOBL, VOYK, VOBI, VOBR, VOMY
Kerala: VOCC
Madhya Pradesh: VAKD, VIST
Maharashtra: VAAK, VAND, VANR, VAOZ, VARG, VASL
Meghalaya: VEBI
Orissa: VEHK, VEJH, VEKN, VERK
Punjab: VIAX, VIBT, VIHX, VIPL
Rajasthan: VIBK, VIJR, VIKO
Tamil Nadu: VOAR, VOTX, VO95, VOSM, VOSX, VOTJ, VOVR
Tripura: VEKR, VEKM, VEKW
Uttar Pradesh: VIBL, VIBY, VIJN, VICX, VILP
West Bengal: VEBG, VEBR, VEBA, VECO, VEHX, VEDX, VEMH, VEPH, VETK
-
YAY! I contributed through the Malaysian list. :)
Sorry, I just had to celebrate because I've finally actually done something for the community for the 3 years I've been playing.
-
Poland (without special polish marks, because database have problems with it):
(175, 'Dolnoslaskie'), (175, 'Kujawsko-Pomorskie'), (175, 'Lubelskie'), (175, 'Lubuskie'), (175, 'Lodzkie'), (175, 'Malopolskie'), (175, 'Mazowieckie'), (175, 'Opolskie'), (175, 'Podkarpackie'), (175, 'Podlaskie'), (175, 'Pomorskie'), (175, 'Slaskie'), (175, 'Swietokrzyskie'), (175, 'Warminsko-Mazurskie'), (175, 'Wielkopolskie'), (175, 'Zachodniopomorskie')
Airports:
Dolnoslaskie: 182
Kujawsko-Pomorskie: 171
Lubelskie: (none)
Lubuskie: 2038
Lodzkie: 175
Malopolskie: 173
Mazowieckie: 180
Opolskie: (none)
Podkarpackie: 178
Podlaskie: (none)
Pomorskie: 172
Slaskie: 174
Swietokrzyskie: (none)
Warminsko-Mazurskie: 2039
Wielkopolskie: 177
Zachodniopomorskie: 179
And the correct names of towns (1st) and airports (2nd): :)
BZG: Bydgoszcz, Port Lotniczy im. Ignacego Jana Paderewskiego
GDN: Gdansk, Port Lotniczy Gdansk im. Lecha Walesy
KRK: Krakow-Balice, Miedzynarodowy Port Lotniczy im. Jana Pawla II
KTW: Katowice-Pyrzowice, Miedzynarodowy Port Lotniczy Katowice
LCJ: Lodz, Port Lotniczy Lodz im. Wladyslawa Reymonta
POZ: Poznan, Port Lotniczy Poznan-Lawica
RZE: Rzeszow-Jasionka, Port Lotniczy Rzeszow-Jasionka
SZZ: Goleniow, Port Lotniczy Szczecin-Goleniow im. NSZZ Solidarnosc
SZY: Szczytno-Szymany, Port Lotniczy Mazury
WAW: Warszawa, Lotnisko Chopina w Warszawie
WRO: Wroclaw, Port Lotniczy Wroclaw
IEG: Babimost, Port Lotniczy Zielona Gora/Babimost
-
Can I do the United Kingdom again but put it into the proper counties rather than just Scotland, England, Northern Ireland and Wales?
-
Can I do the United Kingdom again but put it into the proper counties rather than just Scotland, England, Northern Ireland and Wales?
The United Kingdom does need doing again. Regional government in England (the regional development agencies) is being abolished. The proper top level division is into England, Scotland, Wales and Northern Ireland anyway.
(229, 'Scotland'), (229, 'Wales'), (229, 'England'), (229, 'Northern Ireland')
Scotland: 40, 41, 47, 49, 60, 66, 70, 71, 73, 2229, 2215, 2429, 2430, 2433, 2436, 2440, 2441,
Wales: 53, 1391, 2795,
England: 46, 61, 2432, 7, 35, 37, 39, 51, 2431, 43, 45, 54, 36, 64, 1399, 3072, 3128, 52, 67, 1425, 2438, 2439, 2936, 42, 55, 56, 65, 69, 72, 2428, 2434, 2435, 38, 58, 48, 59, 62,
Northern Ireland: 44, 50, 68,
-
Venezuela: 235
(235, 'Amazonas'), (235, 'Apure'), (235, 'Aragua'), (235, 'Anzoátegui'), (235, 'Barinas'), (235, 'Bolivar'), (235, 'Carabobo'), (235, 'Cojedes'), (235, 'Delta Amacuro'), (235, 'Dependencias Federales'), (235, 'Distrito Capital'), (235, 'Falcón'), (235, 'Guárico'), (235, 'Lara'), (235, 'Mérida'), (235, 'Miranda'), (235, 'Monagas'), (235, 'Nueva Esparta'), (235, 'Portuguesa'), (235, 'Sucre'), (235, 'Táchira'), (235, 'Trujillo'), (235, 'Vargas'), (235, 'Yaracuy'), (235, 'Zulia')
Amazonas: 1888
Apure: 1938, 1943, 1939
Aragua: 1942
Anzoátegui: 1944, 1881
Barinas: 1887
Bolivar: 1933, 1884, 1886
Carabobo: 1870
Cojedes: (none)
Delta Amacuro: (none)
Dependencias Federales: 1941
Distrito Capital: (none)
Falcón: 1935, 1940
Guárico: (none)
Lara: 1882
Mérida: 1883, 1937
Miranda: (none)
Monagas: 1885
Nueva Esparta: 1671
Portuguesa: 1932
Sucre: 1936, 1934
Táchira: 1877, 1879, 1878, 1880
Trujillo: 1946
Vargas: 351
Yaracuy: (none)
Zulia: 1672, 1945
-
Is it possible for you to update the list of done countries? I see Denmark is listed as undone, but in the game it already has provinces.
-
Is it possible for you to update the list of done countries? I see Denmark is listed as undone, but in the game it already has provinces.
I think I put that off due to the tediousness of the task. It should really be updated though alright.
-
180 Romania
(180, 'Muntenia'), (180, 'Moldova'), (180, 'Transilvania'), (180, 'Dobrogea'), (180. 'Banat')
Airports
Muntenia 622, 2456
Moldova 2459, 3205, 3206
Translivania 3423, 1495, 2460, 3386, 2457
Banat 1494
Dobrogea 2458
my little 2 cents on this project
-
Disclaimer - Leningrad region, Sverdlovsk region are real names of these regions, not cities! No need to worry about them.
181 Russian Federation
(181, 'Moscowskaja oblast'), (181,'Leningradskaja oblast'), (181, 'Pskovskaja oblast'), (181, 'Novgorodskaja oblast'), (181, 'Tverskaja oblast'), (181, 'Smolenskaja oblast'), (181, 'Bryanskaja oblast'), (181, 'Kaluzhskaja oblast'), (181, 'Tulskaja oblast'), (181, 'Orlovskaja oblast'), (181, 'Kurskaja oblast'), (181, 'Lipetskaja oblast'), (181, 'Belgorodskaja oblast'), (181, 'Tambovskaja oblast'), (181, 'Voronezhskaja oblast'), (181, 'Volgogradskaja oblast'), (181, 'Rostovskaja oblast'), (181, 'Astrakhanskaja oblast'), (181, 'Kalmykija'), (181, 'Krasnodarsky kraj'), (181, 'Stavropolsky kraj'), (181, 'Adygeja'), (181, 'Karachaevo-Cherkessija'), (181, 'Kabardino - Balkarija'), (181, 'Severnaja Osetia'), (181, 'Ingushetija'), (181, 'Chechnja'), (181, 'Dagestan'), (181, 'Murmanskaja oblast'), (181, 'Karelija'), (181, 'Arkhangelskaja oblast'), (181, 'Vologodskaja oblast'), (181, 'Yaroslavskaja oblast'), (181, 'Kostromskaja oblast'), (181, 'Ivanovskaja oblast'), (181, 'Vladimirskaja oblast'), (181, 'Nizhegorodskaja oblost'), (181, 'Ryazanskaja oblast'), (181, 'Mordovija'), (181, 'Penzenskaja oblast'), (181, 'Saratovskaja oblast'), (181, 'Samarskaja oblast'), (181, 'Uljanovskaja oblast'), (181, 'Tatarstan'), (181, 'Chuvashija'), (181, 'Marij El'), (181, 'Kirovskaja oblast'), (181, 'Udmurtija'), (181, 'Komi'), (181, 'Nenets autonomous district'), (181, 'Permsky kraj'), (181, 'Bashkortostan'), (181, 'Orenburzhskaja oblast'), (181, 'Chelyabinskaja oblast'), (181, 'Kurganskaja oblast'), (181, 'Sverdlovskaja oblast'), (181, 'Tumenskaja oblast'), (181, 'Khanty-Mansijsky autonomous district'), (181, 'Yamalo-Nenets autonomous district'), (181, 'Tomskskaja oblast'), (181, 'Novosibirskaja oblast'), (181, 'Kemerovo district'), (181, 'Altajsky kraj'), (181, 'Altaj'), (181, 'Tuva'), (181, 'Khakasija'), (181, 'Krasnoyarsky kraj'), (181, 'Irkutskaja oblast'), (181, 'Buryatija'), (181, 'Chitinskaja oblast'), (181, 'Sakha (Yakutija)'), (181, 'Amurskaja oblast'), (181, 'Khabarovsky kraj'), (181, 'Primorsky kraj'), (181, 'Jewish autonomous district'), (181, 'Sakhalinskaja oblast'), (181, 'Magadanskaja oblast'), (181, 'Chukotsky autonomous district'), (181, 'Kamchatsky kraj')
Airports are still to go)
08/08 - corrected some names. Regions are renamed to 'Oblast'
P.S. Noobish question - where can I get the list of airports with their ID's?
-
Oblast looks better imho.
-
In case you don't have all of Canada, here it is..
(38, 'British Columbia'), (38, 'Alberta'), (38, 'Manitoba'), (38, 'New Brunswick'), (38, 'Newfoundland and Labrador'), (38, 'Northwest Territories'),
(38, 'Nova Scotia'), (38, 'Nunavut'), (38, 'Ontario'), (38, 'Prince Edward Island'), (38, 'Québec'), (38, 'Saskatchewan'), (38, 'Yukon')
British Columbia:256,892,893,895,896,1395,1398,1443,1444,1446,1448,2996,2999,3005,3009,3040,3047,3048,3049,3051,3053,3059,3103,3164
Alberta:288,316,1392,1396,1410,1411,1445,2252,3004,3014,3016,3045,3054
Saskatchawan:1393,1406,3050,3203
Manitoba:325,1449,2998,3003,3007,3036,3037,3052
Ontario:226,255,899,1394,1400,1401,1450,1451,1603,2447,2510,2992,3006,3008,3015,3031,3032,3033,3039,3043,3046,3060,3066
Québec:274,718,2253,2993,2994,2997,3001,3012,3013,3030,3034,3035,3038,3041,3044,3056,3057,3058,3102,3162,3590
New Brunswick:1407,1408,1447,2995,3000,3105
Nova Scotia:326,3107,3165
Prince Edward Island:897
Newfoundland and Labrador:216,894,1442,1592,3002,3104,3106,3163
Yukon:900
Northwest Territories:901,1416,3010,3011,3042
Nunavut:898,3055
-
Portugal:
(176, 'Açores'), (176, 'Madeira'), (176, 'Algarve'), (176, 'Lisboa'), (176, 'Porto')
Açores: 3296, (1519, 'Santa Cruz das Flores'), (1520, 'Santa Cruz'), 675, 669, (1422, 'Madalena'), 1521, (1533, airport name is Lajes, like the region)
Madeira: 775, 1489
Lisboa: 642
Porto: 658 (region is Porto like the city)
Algarve: 853
You can add Vila Real (has flights to and from Lisboa) and Beja (although this last one is used for maintenance there are several airlines looking forward to make regular pax flight to it, TACV for example)
-
New Province since 25 October 2012
Indonesia:
(101, 'North Kalimantan')
Airports:
Juwata International Airport (not yet available in AM)
-
This is 2018 UPDATED towns, airports?
AFRICA:
Burkina Faso:
(34, 'Ouagadougou'), (34, 'Bobo-Dioulasso'), (34, 'Koudougou'), (34, 'Ouahigouya'), (34, 'Banfora'), (34, 'Dedougou'), (34, 'Kaya'), (34, 'ori'), (34, 'Tenkodogo'), (34, 'Reo'), (34, 'Hounde'), (34, 'Fada N'gourma'), (34, 'Koupela'), (34, 'Kombissiri'), (34, 'Garango'), (34, 'Nouna'), (34, 'Leo'), (34, 'Kongoussi'), (34, 'Diapaga'), (34, 'Kokologo'), (34, 'Gaoua'), (34, 'Zorgo'), (34, 'Yako'), (34, 'Djibo'), (34, 'Titao'), (34, 'Orodara'), (34, 'Po'), (34, 'Tougan'), (34, 'Boulsa'), (34, 'Gourcy'), (34, 'Bousse'), (34, 'Manga'), (34, 'Boromo'), (34, 'Diebougou'), (34, 'Ziniare'), (34, 'Toma'), (34, 'Dano'), (34, 'Salanso'), (34, 'Ouargaye'), (34, 'Bogande'), (34, 'Pama'), (34, 'Pitmoaga'), (34, 'Gorom-Gorom'), (34, 'Gouloure'), (34, 'Batie')
Please explain to me where and how you find the airport ID's?? I can add ALL airports, but I don't know what ID for airport you are talking about? is it a lon/lat thing?
I also have the passenger counts for each town as well. Would you like those listed here as well, or somewhere else?
-
Thanks for the data :)
The airport ID is found in the URL of the view airport page. As far as I remember, Burkina Faso only has one airport, so it's not a critical country
If you have official passenger counts we would be very happy to see, yes!
-
Thanks for the data :)
The airport ID is found in the URL of the view airport page. As far as I remember, Burkina Faso only has one airport, so it's not a critical country
If you have official passenger counts we would be very happy to see, yes!
I'm sorry, I only have population counts, NOT passenger counts. My mistake. :(
And what "view airport page" are you talking about? I don't think I got my data from where you may have gotten yours...however, it was NOT from Wikipedia. lol
-
Airport ID as in the unique number the airport has in the game - in this regard nothing to do with location or airport codes :)