UN/LOCODE

From Wikipedia, the free encyclopedia
Jump to: navigation, search

UN/LOCODE, the United Nations Code for Trade and Transport Locations, is a geographic coding scheme developed and maintained by United Nations Economic Commission for Europe (UNECE). UN/LOCODE assigns codes to locations used in trade and transport with functions such as seaports, rail and road terminals, airports, Postal Exchange Office and border crossing points. The first issue in 1981 contained codes for 8,000 locations. The version from 2011 contained codes for about 82,000 locations.[1]

Structure[edit]

UN/LOCODEs have five characters. The first two characters are letters. They code a country by the table defined in ISO 3166-1 alpha-2. The three remaining characters code a location within that country. Letters are preferred, but if necessary digits 2 through 9 may be used, excluding "0" and "1" to avoid confusion between "O" and "0" and between "I" and "1".

For each country there can be a maximum of 26*26*26 = 17 576 entries, using only letters, or 34*34*34 = 39 304 entries using letters and digits.

For the US, the 17 576 possible letter combinations have been almost exhausted. In 2006, the Secretariat added 646 entries to the 2006-2 issue of UN/LOCODE, in which the third position of 3-character codes is a digit from 2 to 9. The 2007 issue of UN/LOCODE contains 689 such US entries.

Loose consistency with existing IATA airport codes[edit]

For airports, the three letters following the country code are not always identical to the IATA airport code. According to the Secretariat note for Issue 2006-2, there are 720 locations showing a different IATA code.[2]

Official UN/LOCODE tables[edit]

UN/LOCODEs are released as a table. An individual revision is officially referred to as an "issue". A discussion of the table's structure follows.

Examples[edit]

Examples of locations as shown in Issue 2006-2[3]
Ch LOCODE Name NameWoDiacritics SubDiv Function Status Date IATA Coordinates Remarks
US NYC New York New York NY 12345--- AI 0401 4042N 07400W
DE BER Berlin Berlin BE 12345--- AF 0207 5231N 01323E
DE TXL Berlin-Tegel Apt Berlin-Tegel Apt BE ---4---- AF 9501
FR PAR Paris Paris 75 123-5--- AF 9501
GB PAR Par Par CON 1------- AF 9501
SE GOT Göteborg Goteborg O 1--45--- AI 0207 XWL
= SE Gothenburg = Göteborg Gothenburg = Goteborg
Explanations
  • SE GOT  for Göteborg (Goteborg without diacritics) in Sweden. Subdivision is the Swedish county of Västra Götaland (see ISO 3166-2:SE). Function: port, airport, postal. The IATA code of XWL indicated in the table is that of a train station in the city centre of Göteborg (though not the Central Station), while the IATA code for the main airport (Göteborg-Landvetter Airport) is actually GOT. It also has a separate reference entry showing an alternate spelling of Gothenburg.

Data fields[edit]

The fields are listed in the official order.

Ch (Changes)[edit]

A change from the previous issue is indicated by one of the following characters in the first column:[2]
X  Marked for deletion in the next issue
#  Change in location name (usually spelling)
¦  Other changes in the entry (not location)
+  Entry added to the current issue
=  Reference entry
!  Retained for certain entries in the USA code list ("controlled duplications")

Locode[edit]

The code is represented with a space between the alpha-2 codes of ISO 3166-1 country code and the 3-character element.

Name[edit]

Names of locations should be shown using the 26 letters of the Roman alphabet with, where appropriate, diacritic signs as contained in ISO 10646-1/1993 or ISO 8859-1/1987.

Name Without Diacritics[edit]

The name of the location, but non-practicable Diacritics may be ignored and should not be converted into additional characters(e.g., Göteborg may be read as Goteborg, rather than Goeteborg, Gothenburg, Gotembourg, etc.).
Can contain ' e.g. L'viv

SubDiv (Subdivision)[edit]

The ISO 1 to 3 character alphabetic and/or numeric code for the administrative division (state, province, department, etc.) of the country, as included in ISO 3166-2/1998. Only the latter part of the complete ISO 3166-2 code element (after the hyphen) is shown.

Function[edit]

Each defined function gets a classifier; the most important are:

  • 1 = port (for any kind of waterborne transport)
  • 2 = rail terminal
  • 3 = road terminal
  • 4 = airport
  • 5 = postal exchange office
  • 6 = Inland Clearance Depot – ICD or "Dry Port", "Inland Clearance Terminal", etc.
  • 7 = fixed transport functions (e.g. oil platform)"; the classifier "7" is reserved for this function. Noting that the description "oil pipeline terminal" would be more relevant, and could be extended to cover also electric power lines and ropeway terminals.
  • B = Border crossing function
  • 0 = function not known, to be specified

Status[edit]

Indicates the status of the entry by a 2-character code. The following codes are used at present:
  • AA: Approved by competent national government agency
  • AC: Approved by Customs Authority
  • AF: Approved by national facilitation body
  • AI: Code adopted by international organisation (IATA or ECLAC)
  • AM: Approved by the UN/LOCODE Maintenance Agency
  • AQ: Entry approved, functions not verified
  • AS: Approved by national standardisation body
  • RL: Recognised location - Existence and representation of location name confirmed by check against nominated gazetteer or other reference work
  • RN: Request from credible national sources for locations in their own country
  • RQ: Request under consideration
  • UR: Entry included on user's request; not officially approved
  • RR: Request rejected
  • QQ: Original entry not verified since date indicated
  • XX: Entry that will be removed from the next issue of UN/LOCODE

Date[edit]

The date the location was added or updated: 0207 is July 2002, 9501 is January 1995, etc.

Observation: The edition published in 2008 contains for additions the value 0701, while in other cases the exact month is used like 9710, 0212.

IATA[edit]

The IATA code for the location is marked if different from the second part of the UN/LOCODE.

Coordinates[edit]

Some entries have coordinates in the database. They are represented as: ddmmN dddmmW, ddmmS dddmmE, etc.

Remarks[edit]

The remarks column can among other things contain a hint to what specifically was changed (See data field - "Change").

Availability[edit]

Availability UN/LOCODE is available on website http://www.unece.org/cefact/locode/welcome.html, where the latest release of UNLOCOD directories and background documents are listed. Complete UN/LOCODE code list may be downloaded in the format of.mdb (MS Access database), .txt (text file) and .csv (Comma-separated values). HTML pages are also displayed on the website by countries.

Data Maintenance Requests[edit]

UN/LOCODE Data Maintenance Request system is web-based (http://apps.unece.org/unlocode/), which enables registered users to submit online requests for new UN/LOCODE entry modifications.

The system provides online functions for

  • Registration of users and password retrieval
  • Submission of requests for new UN/LOCODE entries
  • Submission of requests for modification changes in existing UN/LOCODE entries
  • A guide to explain the use of the system

Errors[edit]

In 2006-07 IQ IRB for Irbil was added while IQ ABL Arbil with almost the same coordinates existed. In the 2007 edition IQ ABL gets marked for deletion and IQ EBL Erbil International Apt is added to the database, but with a different coordinates, reflecting the distance between airport and city. The error is to delete ABL and to insert IRB.[citation needed]}

Occasionally locations are listed twice; this is not necessarily an error. In issue 2006-1, ARSMC San Miguel de Tucumán (functions 2,3) was added while ARTUC Tucumán (function 1) already was in the list. The coordinates are with very little deviation the same. Also in 2006-1, ARSSJ San Salvador de Jujuy was added (function 4) while ARJUJ Jujuy (functions 1,2,3,5) already existed.

US TRI + US BOS, same coor and within TRI different coor

US BFS Bristol                            VA RL -234---- 0212 3636N 08211W cf US JCI, US BSO, US TRI
US BSO Bristol Apt                        TN RL -234---- 0212 3635N 08210W cf US JCI Apt, US BSO Apt, US TRI Apt
US TRI Bristol-Johnson City-Kingsport Apt TN RL -234---- 0212 3635N 08210W cf US JCI, US BSO, US TRI
US TRI Johnson City-Kingsport-Bristol Apt TN RL -234---- 0212 3635N 08210W cf US JCI, US TRI, US BSO
US TRI Kingsport-Bristol-Johnson City Apt TN RL -234---- 0212 3635N 08210W cf US JCI, US TRI, US BSO
US TRI Kingsport Apt                      TN AI ---4---- 0212 3632N 08233W cf US BSO Apt, US JCI Apt

2009-1[edit]

The 2009-1 release added several entries for Ukraine where the longitude is off by a few orders of magnitude. Ranging from 23230E to 38829E, they are outside what would constitute an eastern longitude. Ivano Frankovsk and Chuguyev have two entries now, along with Nikolayev. For all three, the romanized spelling varies.

+  UA IVA Ivano Frankivsk                   26–3----- RL 0901      4855N 24422E
   UA IFO Ivano-Frankovsk                       ---4---- AI 0001
+  UA CHU Chuguev                           63–3----- RL 0901      4950N 36411E
+  UA CGV Chuguyev                          63  -23----- RL 0901      4950N 03641E
   UA NLV Nikolaev                              ---4---- AI 0001
   UA NIK Nikolayev                             1------- AI 9501

Other entries with wrong coordinates:

+  UA BOH Bohorodchany                      26–3----- RL 0901      4848N 24321E
+  UA IZI Iziaslav                          7   --3----- RL 0901      5606N 26492E
+  UA KAM Kamianets-Podilskyi               68–3----- RL 0901      4841N 26345E
+  UA KHA Khartsyzk                         14–3----- RL 0901      4802N 38829E
+  UA KHM Khmelnytskyi                      68–3----- RL 0901      4950N 36411E
+  UA KIR Kirovohrad                        35–3----- RL 0901      4830N 32157E
+  UA KON Konstantinovka—3----- RL 0901      4722N 32170E
+  UA MIR Mironovka                         14–3----- RL 0901      4829N 38150E
+  UA MYR Myronivka                         32–3----- RL 0901      4939N 30590E
+  UA POL Nikopol                           12–3----- RL 0901      4734N 34240E
+  UA LAH Nova Vodolaha                     63–3----- RL 0901      4943N 35520E
+  UA OVI Ovidiopol                         51–3----- RL 0901      4616N 30260E
+  UA CRY Ripky                             74  -----6-- RL 0901      5148N 31600E
+  UA TAL Talne                             71–3----- RL 0901      4853N 30421E
+  UA TRU Truskavets                        46–3----- RL 0901      4917N 23300E
+  UA VOR Vorzel                            32–3----- RL 0901      5033N 30090E
+  UA YAV Yavoriv                           46–3----- RL 0901      4956N 23230E
+  UA ZHO Zhovkva—3----- RL 0901      5040N 23580E

For the US more codes with one letter and the number 9 alone were added. For the range H to M they are:

+  US R9  Harpersville                        VA—3----- RL 0901      4313N 07626W
+  US T9  Henrietta                           MO  -23----- RL 0901      3914N 09356W
+  US U9  Hugo                                MN  -----6-- RL 0901      4509N 09259W
+  US D9  Indian Head                         MD  -----6-- RL 0901      3836N 07709W
+  US F9  Lindenwood                          IL  -----6-- RL 0901      4203N 08901W
+  US T9  Mantua                              OH  -----6-- RL 0901      4117N 08113W
+  US W9  Matthews                            MO  -----6-- RL 0901      3645N 08935W
   US L9  Maylene                             AL—3----- RL 0701      3312N 08652W
+  US N9  Milan                               NM—3----- RL 0901      3510N 10753W
   US D9  Minidoka                            ID  -23----- RL 0701      4245N 11330W
   US C9  Mitchell                            MS—3----- RL 0701      3443N 08851W
+  US R9  Morgan                              PA  -----6-- RL 0901      3955N 07939W
+  US V9  Morrisville                         NJ—3--6-- RL 0901      3958N 07503W
   US H9  Mount Hope                          OH—3--6-- RL 0701      4037N 08147W
   US F9  Munroe Falls                        OH  -23----- RL 0701      4109N 08126W

Problems[edit]

Some entries do not have coordinates, so it is not clear where they actually refer to. If an IATA code changes, then the UN/LOCODE could also be considered to have changed.

MS MNI Montserrat Montserrat AI ---4---- 9601

For Kochi / Cochin the postal function has KOC (1998) and all other functions have COK (2003).

IN KOC Kochi  Kochi     AI ----5--- 9805
IN COK Cochin Cochin KL AA 1234-6-- 0307 0958N 07614E

Jerusalem is not listed under any nation. Private organizations have used the LOCODE IL1JE as a placeholder.

Release history[edit]

Notes
+  Additions to the current issue
¦  Other changes
#  Change in location (spelling or other)
X  Entries marked for deletion in the next issue
Issue Date Entries Changes Notes
+ ¦ # X Total
2002-1 [4] 2002 35,460 2,503 597 100 24 3,224 Based on 2006-1, entries should be 34,766
2002-2 [5] 2002-07-29 [6] 36,005 1,235 252 93 6 1,586 Based on 2006-1, entries should be 35,977
2003-1 [7] 2002-12-20 [6] 38,000 707 523 2,779 2 4,011 Based on 2006-1, entries should be 36,678
2003-2 [8] 2003-08-01 [6] 40,000 2,402 1,099 283 324 4,108 Based on 2006-1, entries should be 39,078
2004-1 [9] 2004-02-18 [10] 47,725 1,958 694 208 167 3,027 Based on 2006-1, entries should be 40,712
2004-2 [11] 2004-07-27 [10] 50,000 1,707 87 26 5 1,825 Based on 2006-1, entries should be 42,252
2005-1 [12] 2005-02-28 [10] 50,000 2,291 196 46 16 2,549 Based on 2006-1, entries should be 44,538
2005-2 [13] 2005 50,000 929 178 55 8 1,170 Based on 2006-1, entries should be 45,451
2006-1 [14] 2006-06-09 [10] 48,553 3,110 42 43 11 3,206
2006-2 [2] 2007-04-30 [10] 54,705 6,400 79 15 157 6,651
2007 [15] 2008-03-20 [10] 58,875 4,327 753 153 24 5,257
2009-1 [16] 2009-09-23 [10] 71,665 13,271 0 0 8 13,279
2009-2 [17] 2010-02-08 [10] 76,375 4,377 347 85 165 4,974
2010-1 [18] 2010-10-29 [10] 79,973 3,800 121 32 55 4,008
2010-2 [19] 2010-12-18 [10] 81,464 1,538 23 0 47 1,608
2011-1 [1] 2011-09-22 82,358 567 654 1,819 477 3,517
2011-2 [20] 2012-02-28 [10] 83,287 1,655 0 7 0 1,662 loc112sec.pdf: "main code list has now over 84 000 entries"
2012-1 [21] 2012-09-14 [22] 88,300 5,311 495 142 3 5,951 The loc121txt/loc121sec.pdf says: "UN/LOCODE 2012-1 includes 83 287 entries."
2012-2 [23] 2013-03-07 [24] 2,299 479 221 116 3,115 The loc122sec.pdf says: "main code list has now over 90 000 entries and the database contains a total of over 100 000 records", "2012-2 includes 90 645 entries"
2013-1 [25] 2013-07-05 [26] 4,709 503 97 2,175 7,484 The loc131sec.pdf says: "2013-1 main code list has now over 90 000 entries and the database contains a total of over 100 000 records", "2013-1 includes 95 721 entries"
2013-2 [27] 2013-12-20 [28] 95,066 1,518 1,482 36 55 3,091

See also[edit]

References[edit]

  1. ^ a b "Secretariat Note to the users of UN/LOCODE 2011-1" (PDF). UNECE. 2011-09-22. 
  2. ^ a b c "Secretariat Note to the users of UN/LOCODE 2006-2" (PDF). UNECE. 2007-04-30. 
  3. ^ "UN/LOCODE (United Nations Code for Trade and Transport Locations), Issue 2006-2". 30 April 2007. Archived from the original on 5 May 2007. 
  4. ^ "Secretariat Note to the users of UN/LOCODE 2002-1" (PDF). UNECE. 2002. 
  5. ^ "Secretariat Note to the users of UN/LOCODE 2002-2" (PDF). UNECE. 2002-07-29. 
  6. ^ a b c "UN/CEFACT: News". UNECE. Archived from the original on 2003-08-01. 
  7. ^ "Secretariat Note to the users of UN/LOCODE 2003-1" (PDF). UNECE. 2002-12-20. 
  8. ^ "Secretariat Note to the users of UN/LOCODE 2003-2" (PDF). UNECE. 1 August 2003. 
  9. ^ "Secretariat Note to the users of UN/LOCODE 2004-1" (PDF). UNECE. 2004-02-18. 
  10. ^ a b c d e f g h i j k "UN/CEFACT: News Archive". UNECE. Retrieved 2012-08-26. 
  11. ^ "Secretariat Note to the users of UN/LOCODE 2004-2" (PDF). UNECE. 2004-07-27. 
  12. ^ "Secretariat Note to the users of UN/LOCODE 2005-1" (PDF). UNECE. 2005-02-28. 
  13. ^ "Secretariat Note to the users of UN/LOCODE 2005-2" (PDF). UNECE. 2005. Archived from the original on 2006-03-03. 
  14. ^ "Secretariat Note to the users of UN/LOCODE 2006-1" (PDF). UNECE. 2006-06-09. 
  15. ^ "Secretariat Note to the users of UN/LOCODE 2007" (PDF). UNECE. 2008-03-20. 
  16. ^ "Secretariat Note to the users of UN/LOCODE 2009-1" (PDF). UNECE. 2009-09-23. 
  17. ^ "Secretariat Note to the users of UN/LOCODE 2009-2" (PDF). UNECE. 2010-02-08. Archived from the original on 2010-04-14. 
  18. ^ "Secretariat Note to the users of UN/LOCODE 2010-1" (PDF). UNECE. 2010-10-29. 
  19. ^ "Secretariat Note to the users of UN/LOCODE 2010-2" (PDF). UNECE. 2010-12-18. 
  20. ^ "Secretariat Note to the users of UN/LOCODE 2011-2" (PDF). UNECE. 2012-02-28. 
  21. ^ "Secretariat Note to the users of UN/LOCODE 2012-1" (PDF). UNECE. 2012-09-14. 
  22. ^ "UN Centre for Trade Facilitation and E-business (UN/CEFACT)". UNECE. Retrieved 2012-10-07. 
  23. ^ "Secretariat Note to the users of UN/LOCODE 2012-2" (PDF). UNECE. 2013-03-09. 
  24. ^ "UN Centre for Trade Facilitation and E-business (UN/CEFACT)". UNECE. Retrieved 2013-03-09. 
  25. ^ "Secretariat Note to the users of UN/LOCODE 2013-1" (PDF). UNECE. 2013-08-21. 
  26. ^ "UN Centre for Trade Facilitation and E-business (UN/CEFACT)". UNECE. Retrieved 2013-08-21. 
  27. ^ "Secretariat Note to the users of UN/LOCODE 2013-2" (PDF). UNECE. 2013-12-20. 
  28. ^ "UN Centre for Trade Facilitation and E-business (UN/CEFACT)". UNECE. Retrieved 2013-12-20. 

External links[edit]