Avatar of Dinesh Kumar
Dinesh KumarFlag for India asked on

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!
WCFMicrosoft SQL ServerOracle DatabaseSSIS

Avatar of undefined
Last Comment
Dinesh Kumar

8/22/2022 - Mon
SOLUTION
Jim Horn

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
Dinesh Kumar

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
SOLUTION
PortletPaul

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
Dinesh Kumar

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
PortletPaul

Sorry, saw airport and flew to the wrong conclusion.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
ASKER
Dinesh Kumar

Ok. no prob.. so do you see any hope!
PortletPaul

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
ASKER CERTIFIED SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
Dinesh Kumar

Thank you Experts for taking part in this question.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.