IATA sub-areas

Discussion in 'Mileage Runs/Travel Hacking' started by effseeoh, Jan 15, 2012.  |  Print Topic

  1. effseeoh

    effseeoh Gold Member

    Messages:
    740
    Likes Received:
    2,458
    Status Points:
    1,145
    Does anyone have a list of airports with their area and sub-area identified?

    Maybe I should've asked this on the trick-it thread as that turns up in some searches. I found this list: http://geodizzy.googlecode.com/svn/trunk/latlong.csv which has a ton of info about each airport in an easily parseable format.
     
  2. Wandering Aramean
    Original Member

    Wandering Aramean Gold Member

    Messages:
    28,233
    Likes Received:
    61,782
    Status Points:
    20,020
    Shouldn't be too hard to map country -> IATA region if you have a list of airports with countries attached. I've got one if you need a starting point.
     
  3. effseeoh

    effseeoh Gold Member

    Messages:
    740
    Likes Received:
    2,458
    Status Points:
    1,145
    I've found a few lists so far, including a list of airports with total passengers too, but it's in pdf. I think I'll be ok now thanks. Just a bit of scripting to convert it into csv and have code, area, sub-area, lat, long, total passengers.
     
  4. effseeoh

    effseeoh Gold Member

    Messages:
    740
    Likes Received:
    2,458
    Status Points:
    1,145
    Ok, I'm getting there:
    $ egrep 'FCO|CMN|LHR|SYD|MEL' ap.csv
    LHR,EGLL,GB,C2,2,EUR,TC2,51.477500,-0.461388,66037578
    FCO,LIRF,IT,C2,2,EUR,TC2,41.804475,12.250797,33723213
    SYD,YSSY,AU,C6,1,SWP,TC3,-33.946110,151.177222,33451383
    MEL,YMML,AU,C6,1,SWP,TC3,-37.673332,144.843333,25248762
    CMN,GMMN,MA,C5,5,EUR,TC2,33.367467,-7.589966,6392789

    Still some anomalies to sort out, e.g. Casablanca (CMN) is in Morocco, which is in Europe as far as IATA is concerned, but the two other sources I have both put it in C5, and for some reason hs's getarea() function puts australia Y ICAO coded airports in C1.
     

Share This Page