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
SOLUTION
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Dinesh Kumar
Dinesh Kumar
Flag of India image

ASKER

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
Avatar of PortletPaul
PortletPaul
Flag of Australia image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of Dinesh Kumar
Dinesh Kumar
Flag of India image

ASKER

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
Avatar of PortletPaul
PortletPaul
Flag of Australia image

Sorry, saw airport and flew to the wrong conclusion.
Avatar of Dinesh Kumar
Dinesh Kumar
Flag of India image

ASKER

Ok. no prob.. so do you see any hope!
Avatar of PortletPaul
PortletPaul
Flag of Australia image

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
Avatar of Dinesh Kumar
Dinesh Kumar
Flag of India image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of Dinesh Kumar
Dinesh Kumar
Flag of India image

ASKER

Thank you Experts for taking part in this question.
Microsoft SQL Server
Microsoft SQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo