Airline Mogul Forum

States, Provences, Counties

Vamerica

  • Airline Senior Manager
  • ****
    • Posts: 2146
  • Welcome Aboard Virgin America
    • View Profile
Reply #15 on: February 29, 2008, 04:06:25 AM
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

  • Airline Senior Manager
  • ****
    • Posts: 2404
  • Hello! Send me a PM!
    • View Profile
Reply #16 on: February 29, 2008, 04:11:48 AM
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.
British Pan Airways (BPA)

Serving London Heathrow to You and the Rest of the World!

Fly with our lie-flat beds in first and business class on all longhaul planes!

~BPA, Relax, Enjoy, Fly.


zkvac

  • Airline Supervisor
  • **
    • Posts: 900
    • View Profile
    • granturismoworld.piczo.com
Reply #17 on: February 29, 2008, 04:46:55 AM
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?
Public World #2119 - VincentAir (Australasia)


Air Elbonia

  • Administrator
  • Airline Senior Manager
  • *****
    • Posts: 2089
    • View Profile
Reply #18 on: February 29, 2008, 04:52:30 AM
Quote from: "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?


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.
Quote
United States:

Minnesota:
874, 928, 138...


[which translates into bemidji, duluth, msp... etc. etc. etc.]
Air Elbonia, First in Time Travel since 2073!  (AEB ID in Game: 333)


zkvac

  • Airline Supervisor
  • **
    • Posts: 900
    • View Profile
    • granturismoworld.piczo.com
Reply #19 on: February 29, 2008, 05:13:35 AM
You know what? I'll give it a go.

EDIT:
Wait, did you have all the Australian airports too?
Public World #2119 - VincentAir (Australasia)


Blue Sky Mine

  • Airline Manager
  • ***
    • Posts: 1093
    • View Profile
Reply #20 on: February 29, 2008, 08:55:51 AM
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

  • Administrator
  • Airline Senior Manager
  • *****
    • Posts: 3805
    • View Profile
Reply #21 on: February 29, 2008, 11:44:44 AM
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

  • Airline Operative
  • *
    • Posts: 416
    • View Profile
Reply #22 on: February 29, 2008, 02:11:23 PM
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 :)
img]http://www.lsn.se/televisionset/ScandalianAnimated.gif[/img]
Your skyrocket to elsewhere


Blue Sky Mine

  • Airline Manager
  • ***
    • Posts: 1093
    • View Profile
Reply #23 on: February 29, 2008, 03:29:33 PM
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

  • Airline Mogul Staff
  • Airline Manager
  • *****
    • Posts: 1067
    • View Profile
Reply #24 on: February 29, 2008, 07:19:53 PM
Quote from: "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.


Ok, will do so.
an (AirHanoverInternational ID:5980)


AirHanoverInternational

  • Airline Mogul Staff
  • Airline Manager
  • *****
    • Posts: 1067
    • View Profile
Reply #25 on: February 29, 2008, 08:07:31 PM
an (AirHanoverInternational ID:5980)


Air Elbonia

  • Administrator
  • Airline Senior Manager
  • *****
    • Posts: 2089
    • View Profile
Reply #26 on: February 29, 2008, 09:59:57 PM
Quote from: "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 :)


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.
Air Elbonia, First in Time Travel since 2073!  (AEB ID in Game: 333)


AirHanoverInternational

  • Airline Mogul Staff
  • Airline Manager
  • *****
    • Posts: 1067
    • View Profile
Reply #27 on: February 29, 2008, 10:14:23 PM
I just copied from Blue's post. Made it easier for me to sort the airports :D
an (AirHanoverInternational ID:5980)


Air Elbonia

  • Administrator
  • Airline Senior Manager
  • *****
    • Posts: 2089
    • View Profile
Reply #28 on: February 29, 2008, 10:23:39 PM
Quote from: "zkvac"
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.
Air Elbonia, First in Time Travel since 2073!  (AEB ID in Game: 333)


zkvac

  • Airline Supervisor
  • **
    • Posts: 900
    • View Profile
    • granturismoworld.piczo.com
Reply #29 on: February 29, 2008, 10:50:46 PM
Ok, I'll give it a go on Sunday if I get a chance (Saturday morning here now).
Public World #2119 - VincentAir (Australasia)


 

SMF spam blocked by CleanTalk