Location Code

Hi Experts!

How location code of a location is known e.g Edinburgh Airport is having Location code as EDIA01 (the first three characters i.e EDI represents airport code OR because the fourth character is A so its an airport code.)

So How can find out the location code of other locations e.g Amman. Queen Alia International Airport  

OR

Amman, Wasfi Al-Tal Street, Barakeh Commercial Centre # 9

Trying to found out in followings:
http://www.world-airport-codes.com/jordan/queen-alia-international-219.html
http://airportguide.com/airport_ids_paper.php

Please help!
Dinesh KumarAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Here's the Web Service path for airports by airport code
http://www.webservicex.com/airport.asmx?op=getAirportInformationByAirportCode

We're using other parts of this for web service calls from SSIS.
0
Dinesh KumarAuthor Commented:
Thank you for the web service path.

1) I see that we are having a Location ID e.g LGWA01 for Gatwick Airport. so I need how to get LGWA01 ?

2) suppose if there is a city and in that city there is no airport so still that is having some code called location identifier. so if I see the following location which is not airport then what can be its location identifier?

the location e.g is: Amman, Holiday Inn Hotel, Al Madina Al Munnawara Street
0
PortletPaulfreelancerCommented:
IATA? http://www.iata.org/

various codes they control:
http://www.iata.org/services/Pages/codes.aspx

"The official source for codes assigned by IATA"
http://www.iata.org/publications/Pages/code-search.aspx

& also here is a list of 3 letter codes:
http://www.nationsonline.org/oneworld/IATA_Codes/airport_code_list.htm
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Dinesh KumarAuthor Commented:
Thank you for these useful links but I am looking for 6 digit code for Locations

The location can be airport name or city name e.g  the following shows 6 digits code of airport name and cities also.

Airports:

GLAA01      Glasgow Airport
GLAR01      Glasgow Rail
LENC01      Lennoxtown

Cities:

BODW72      ANDERNOS LES BAINS
BODX71      Bordeaux
BOHP71      POOLE

So I am looking for 6 length code instead of 3.

If I get 6 length code I can get airport code from the first three characters.

The six length code is called OAGCode
0
PortletPaulfreelancerCommented:
Sorry, saw airport and flew to the wrong conclusion.
0
Dinesh KumarAuthor Commented:
Ok. no prob.. so do you see any hope!
0
PortletPaulfreelancerCommented:
don't know - not familiar with those location codes - sorry

The only OAG codes I recall are for aircraft types
http://en.wikipedia.org/wiki/Official_Airline_Guide

e.g.
"73G" = BOEING 737
"73G N" = BOEING 737-700
0
Dinesh KumarAuthor Commented:
The locationid of  Queen Alia International Airport , Amman is   AMMA01

This six digits is: first three char are airport code, the 4th one can be any of further four:

A->airport
P->Port
R->Railway Station
C->City/Downtown

The last two characters are station number e.g

01-> station 1 covering all terminals
11->station 1 servicing terminal 1
21->station 1 servicing terminal 2
etc..

Similarly LCAC01 is for Larnaca having address Dromolaxia.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Dinesh KumarAuthor Commented:
Thank you Experts for taking part in this question.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
WCF

From novice to tech pro — start learning today.