States, Provences, Counties

[Air Elbonia]

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]

[AirHanoverInternational]

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?

[pseudoswede]

So the spreadsheet I sent you of all North American airports needs to be redone?  :?

[Air Elbonia]

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.

[pseudoswede]

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.

[AirHanoverInternational]

@ Air Elbonia:
Could you please reply to my question above? I will start Germany then.

[Blue Sky Mine]

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

[AirHanoverInternational]

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:

[waerth]

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

[Blue Sky Mine]

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

[iranair777]

I'll start off with Iran And work my way through the middle east for when I have time

[Air Elbonia]

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 but unless Thailand is hiding a lot more airports, it can probably get away with the regions.

[Blue Sky Mine]

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!

[Seattle]

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.

# 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 but thanks.

[Seattle]

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