States, Provences, Counties

[Vamerica]

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?

[Seattle]

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.

[zkvac]

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?

[Air Elbonia]

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.]

[zkvac]

You know what? I'll give it a go.

EDIT:
Wait, did you have all the Australian airports too?

[Blue Sky Mine]

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)

[MrOrange]

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

[Scandalian Airlines]

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

[Blue Sky Mine]

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.

[AirHanoverInternational]

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.

[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')

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.

[Air Elbonia]

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.

[AirHanoverInternational]

I just copied from Blue's post. Made it easier for me to sort the airports

[Air Elbonia]

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.

[zkvac]

Ok, I'll give it a go on Sunday if I get a chance (Saturday morning here now).