UN/LOCODE 23 May 2018 Yan Zhang Economic Cooperation and Trade - - PowerPoint PPT Presentation

UN/LOCODE

23 May 2018

UN/LOCODE

Yan Zhang Economic Cooperation and Trade Division United Nations Economic Commission for Europe

UN/LOC OD E

In In this this pr presen esenta tation tion

Q&A Maintenance Overview Background

2

UN/LOC OD E

3

UN/LOC OD E

Trade Facilitation for International Trade

Simplification Standardization Harmonization Procedures Information flow Goods Service 4

UN/LOC OD E

UN/CEFACT – The United Nations Centre for Trade Facilitation and Electronic Business 5

UN/LOC OD E

Code for Trade and Transport Locations

Code for Ports and Other Locations UN/LOCODE – Originally stands for : Since 2001: 6

UN/LOC OD E

UN/L UN/LOCODE OCODE Bac Backg kground

• und

Why??

• Identification of location required in International trade and transport

Location Name ? 7

UN/LOC OD E

UN/L UN/LOCODE OCODE Bac Backg kground

• und
• Names of locations spelt in different languages!!

create confusion and difficulty. 8

UN/LOC OD E

UN/LOCODE Background

?

Geneva EN

Genève FR Ginevra IT Genevra RM Genf DE

9

UN/LOC OD E

UN/LOCODE Background

A unique and unambiguous way:

• a code system for
• facilitation of trade procedures & documentation
• data exchange in a safer and more economical way
• Recommendation No. 16 (third edition in 1998)

Geneva = CH GVA

10

UN/LOC OD E

In In this this pr presenta esentation tion

Q&A Maintenance Overview Background

11

UN/LOC OD E

Recommendation No.16

• 1. the five-character code system:

I. 2-character country code II. 3-character location code

• 2. used for purposes of trade
• 3. to designate locations

UN/L UN/LOCODE OCODE Ov Over erview view

12

UN/LOC OD E

CH GVA

Country codes based on ISO 3166-1

26 alphabets & Numbers (2-9):

• Not case-sensitive
• 1 confused with l
• 0 confused with o

UN/L UN/LOCOD OCODE E Ov Over erview view

13

UN/LOC OD E

Website: http://www.unece.org/cefact/locode/welcome.html

14

UN/LOC OD E

From website:

• UNECE Recommendation No. 16
• Code List by Country on the website (http://www.unece.org/cefact/locode/welcome.html )
• Download of complete code list on the website in three formats:
• mdb
• txt
• csv
• Link to Online Data Maintenance Request System
• Link to list of UN/LOCODE Focal Points

UN/L UN/LOCOD OCODE E Websit bsite

15

UN/LOC OD E

Use of UN/LOCODE

Note: The figure doesn't include

• national trade which also uses UN/LOCODE
• trade in services
• other applications (like European Maritime Safety agency or FLUX which processes 1.2

million messages per day) which use UN/LOCODE but don't issue trade documents

• the fact that with eBusiness there is more data transmitted and more copies generated

(hence more UN/LOCODES)

UN/LOCODE is used for at least 1.5 billions times for international trade each year. 16

UN/LOC OD E

• International Trade and Transport

– EDIFACT – WCO Data Model – BIC

. Maritime Security

• Environmental Protection

Use of UN/LOCODE

17

UN/LOC OD E

Milestones:

• 2000: Directories are published biannually instead of annually
• 2001: Rename of UN/LOCODE from ‘the United Nations Code for Ports and Other Locations’ to ‘the United Nations

Code for Trade and Transport Locations’

• 2002: Restructuring of the UN/LOCODE database by defining a new model. The UN/LOCODE directories are

generated in formats of text, CSV, HTML and MS Access file and are published in the UNECE website.

• 2004: Launch of UN/LOCODE Online Data Maintenance Request System to enable registered users to submit online

requests for new entries and modification.

• 2015: UN/LOCODE Focal Point Network establishment
• 2017: UN/LOCODE Advisory Group setup

18

UN/L UN/LOCOD OCODE E De Developme elopment nt

UN/LOC OD E

UN/LOCODE Directory Publication

Release No. Issue Date Cut-off Date YYYY-1 Beginning of July End of March YYYY-2 End of December End of September

The latest release is published on the website free-of-charge. 19

UN/LOC OD E

UN/LOCODE Entries

20000 40000 60000 80000 100000 120000

UN/LOCODE Entries Directories Releases: The first issue in 1981 contained codes for 8,000 locations. The latest release 2017-2 includes over 100,000 entries covering 249 countries , dependent territories and special areas . 20

UN/LOC OD E

UN/LOCODE Focal Point

ToRs of UN/LOCODE Focal Points (http://www.unece.org/fileadmin/DAM/cefact/cf_plenary/2016_ple nary/CF_2016_016E_UNLOCODE-FocalPoints.pdf) UN/LOCODE Focal Points tasks:

• One-time review of existing code list
• Validation of new Data Maintenance Requests for each release

(biannually published)

UN/LOCODE Focal Point Network National Focal Points Institutional Focal Points http://www.unece.org/cefact/locode/focalpoint.html 21 A link on the homepage of UN/LOCODE

UN/LOC OD E

UN/LOCODE Focal Point Nomination

List of UN/LOCODE National Focal Points (http://www.unece.org/cefact/locode/focalpoint.html) Letters to request for nomination of FP sent to the Missions The Secretariat is contacted for further information if necessary Nomination letters sent to the Secretariat The Secrectariat archives the letters and updates the website.

UN/LOC OD E

UN/LOCODE Focal Point Network

23 So far, we have 33 UN/LOCODE National Focal Points.

UN/LOC OD E

In In this this pr presenta esentation tion

Q&A Maintenance Overview Background

24

UN/LOC OD E

Column "Ch" (Change Indicator) Ch LOCODE Name NameWoDiacritics SubDiv Function Status Date IATA Coordinates Remarks DE BWZ Bad Wurzach Bad Wurzach BW

• 23--6--

RL 0901 4754N 00954E + FR AC6 Arçonnay Arconnay 72

• -3-----

RL 1301 4824N 00050E ¦ IN DMA Dhamara Dhamara OR 123----- RL 1301 2048N 08654E @Fun # US PFT Pfafftown Pfafftown NC

• -3-----

RL 1301 3609N 08021W X AU GNO Geelong North Geelong North VIC

• -3-----

XX 1301 3806S 14420E Use AU GGN

+ added entry # Change in the location name X entry to be removed ¦ entry has been changed

1 port 2 rail terminal 3 road terminal 4 airport 5 postal exchange office 6 reserved for multimodal functions, ICDs etc. 7 reserved for fixed transport functions (e.g. oil platform) B border crossing 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) AS Approved by national standardisation body RL Recognised location RN Request from credible national sources for locations in their own country RQ Request under consideration RR Request rejected QQ Original entry not verified since date indicated XX Entry that will be removed from the next issue of UN/LOCODE

Column "SubDiv" (Subdivision)

 state, province, department, etc  Based contain the ISO 3166-2

Country codes based

• n ISO 3166-1

UN/L UN/LOCOD OCODE E Dir Directo ectory

25

UN/LOC OD E

Maintenance Policy

• Free of Charge
• Biannual directory publication :
• Online submission of DMRs
• Request for a new code
• Request for modification
• Request for deletion ( Soft deletion)
• Download complete code list on the website in three formats:

UN/L UN/LOCOD OCODE E Maint Maintenan enance ce

26

UN/LOC OD E

Current UN/LOCODE System

Front-end : Online Data Maintenance Request Submission (.Net +MS SQL) Back-end: Production & Publication (MS ACCESS) 27

UN/LOC OD E DMRs prepared off-line

Data Synchronisation Bi-annually, free of charge

Current workflow

Country with a National Focal Point (NFP)?

• If yes, the DMR is forwarded to NFP for

validation

• If not, the secretariat validate the DMR

28

UN/LOC OD E

UN/LOCODE DMRs

Total Approved

Addition Changes of names Other changes Deletion

1000 2000 3000 4000 5000 6000 7000 8000 9000 2012-2 2013-1 2013-2 2014-1 2014-2 2015-1 2015-2 2016-1 2016-2 2017-1 2017-2

UN/LOCODE Data Maintenance Request (DMR) 29

UN/LOC OD E

UN/LOCODE DMR System

https://apps.unece.org/unlocode/ UN/LOCODE Data Maintenance Request system 30

UN/LOC OD E

UN/LOCODE DMR Submission

Step 1: New User Registration. Option 1 Option 2 31

UN/LOC OD E

New User Registration: Mandatory fields:

• Requestor’s

company/organization name

• Contact person name
• E-mail address
• Phone number
• User name
• Password

UN/LOCODE DMR Submission

32

UN/LOC OD E

Step 2: Login

UN/LOCODE DMR Submission

33

UN/LOC OD E

Main Menu:

UN/LOCODE DMR Submission

34

UN/LOC OD E

Step 3 Online request submission

• Request for a new code

UN/LOCODE DMR Submission

35

UN/LOC OD E

Step 3 Online request submission

• Fill in a web form to Request for a new code

Prior to the submission of a request, the requestor is invited to:

• verify the existence of the location,
• copy the exact reference (URL, web-link) to the

website confirming the submitted data into the field ’Web link’ of the form

• fill in the remaining mandatory input fields.

Incomplete or unproved requests will be considered depending on the availability of the Secretariat’s resources. Check Fill in Submit

UN/LOCODE DMR Submission

36

UN/LOC OD E

Step 3 Online request submission

• Request for changes

UN/LOCODE DMR Submission

37

UN/LOC OD E

Step 3 Online request submission

• Request for changes, including changes in location name, other meta data and deletion.

UN/LOCODE DMR Submission

• Changes in place names will be accepted only from official

and authoritative sources.

• Changes of existing LOCODEs will be accepted only

exceptionally and when convincing reasons have been presented, or when it can be established that the existing code has never been put into actual use.

• Changes in subdivisions will be accepted only when evidence is

presented that a published subdivision code is erroneous.

• Changes of functions will be accepted if the existing entry is

incomplete or erroneous

• Completion of coordinates will be encouraged where they are

missing and accepted if the published coordinates are not correct. 38

UN/LOC OD E

In In this this pr presen esenta tation tion

Q&A Maintenance Overview Background

UN/LOC OD E

UN/LOCODE Project

• Revision of Rec. 16 (UN/LOCODE)

Project leader: Mr. Alper Keceli How to join:

• Register as a UN/CEFACT expert
• Send an email to project leader

(alper.keceli@udhb.gov.tr)

• Participate in teleconferences

40

UN/LOC OD E

UN/CEFACT Upcoming Events

• 32nd UN/CEFACT Forum

14-19 October 2018, Hangzhou, China

41

UN/LOC OD E

For

• r Fur

urther ther Inf nfor

• rma

mation tion

• Ms. Yan Zhang

Yan.zhang@unece.org +41 22 917 3010 Palais des Nations, Geneva UN/LOCODE Secretariat Locode@unece.org

42