UN/LOCODE UN/LOCODE 23 May 2018 Yan Zhang Economic Cooperation and Trade Division United Nations Economic Commission for Europe
In In this this pr presen esenta tation tion UN/LOC OD E Background Overview Maintenance Q&A 2
UN/LOC OD E 3
Trade Facilitation for International Trade UN/LOC OD E Simplification Standardization Harmonization Procedures Information flow Service Goods 4
UN/LOC OD E UN/CEFACT – The United Nations Centre for Trade Facilitation and Electronic Business 5
UN/LOC OD E UN/LOCODE – Originally stands for : Code for Ports and Other Locations Since 2001 : Code for Trade and Transport Locations 6
UN/L UN/LOCODE OCODE Bac Backg kground ound UN/LOC OD E Why?? • Identification of location required in International trade and transport Location Name ? 7
UN/L UN/LOCODE OCODE Bac Backg kground ound UN/LOC OD E • Names of locations spelt in different languages!! create confusion and difficulty . 8
UN/LOCODE Background UN/LOC OD E Genève FR Ginevra Geneva Genf IT DE EN Genevra ? RM 9
UN/LOCODE Background UN/LOC OD E A unique and unambiguous way: • a code system for o facilitation of trade procedures & documentation o data exchange in a safer and more economical way • Recommendation No. 16 (third edition in 1998) Geneva = CH GVA 10
In In this this pr presenta esentation tion UN/LOC OD E Background Overview Maintenance Q&A 11
UN/LOCODE UN/L OCODE Ov Over erview view 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 12
UN/L UN/LOCOD OCODE E Ov Over erview view UN/LOC OD E CH GVA 26 alphabets & Numbers (2-9): Country codes based on • Not case-sensitive ISO 3166-1 • 1 confused with l • 0 confused with o 13
UN/LOC OD E Website: http://www.unece.org/cefact/locode/welcome.html 14
UN/L UN/LOCOD OCODE E Websit bsite 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 15
Use of UN/LOCODE UN/LOC OD E UN/LOCODE is used for at least 1.5 billions times for international trade each year. 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) 16
Use of UN/LOCODE UN/LOC OD E • International Trade and Transport – EDIFACT – WCO Data Model – BIC . Maritime Security • Environmental Protection 17
UN/LOCOD UN/L OCODE E De Developme elopment nt 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/LOCODE Directory Publication UN/LOC OD E The latest release is published on the website free-of-charge. Release No. Issue Date Cut-off Date YYYY-1 Beginning of July End of March YYYY-2 End of December End of September 19
UN/LOCODE Entries UN/LOC OD E 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 . UN/LOCODE Entries 120000 100000 80000 60000 40000 20000 0 20
UN/LOCODE Focal Point UN/LOC OD E UN/LOCODE Focal Point Network National Focal Points http://www.unece.org/cefact/locode/focalpoint.html A link on the homepage of UN/LOCODE Institutional Focal Points 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) 21
UN/LOCODE Focal Point Nomination UN/LOC OD E Letters to request for The Secretariat is contacted for Nomination letters sent to the The Secrectariat nomination of FP sent to the further information if necessary Secretariat archives the letters and Missions updates the website. List of UN/LOCODE National Focal Points (http://www.unece.org/cefact/locode/focalpoint.html)
UN/LOCODE Focal Point Network UN/LOC OD E So far, we have 33 UN/LOCODE National Focal Points. 23
In In this this pr presenta esentation tion UN/LOC OD E Background Overview Maintenance Q&A 24
UN/LOCOD UN/L OCODE E Dir Directo ectory UN/LOC OD E Column "SubDiv" (Subdivision) Column "Ch" (Change Indicator) state, province, department, etc + added entry Based contain the ISO 3166-2 # Change in the location name X entry to be removed ¦ entry has been changed Ch LOCODE Name NameWoDiacritics SubDiv Function Status Date IATA Coordinates Remarks Country codes based DE BWZ Bad Wurzach Bad Wurzach BW -23--6-- RL 0901 4754N 00954E on ISO 3166-1 + 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 1 port AA Approved by competent national government agency 2 rail terminal AC Approved by Customs Authority 3 road terminal AF Approved by national facilitation body 4 airport AI Code adopted by international organisation (IATA or ECLAC) 5 postal exchange office AS Approved by national standardisation body RL Recognised location 6 reserved for multimodal functions, ICDs etc. RN Request from credible national sources for locations in their own country 7 reserved for fixed transport functions (e.g. oil platform) RQ Request under consideration B border crossing RR Request rejected QQ Original entry not verified since date indicated 25 XX Entry that will be removed from the next issue of UN/LOCODE
UN/L UN/LOCOD OCODE E Maint Maintenan enance ce 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: 26
Current UN/LOCODE System UN/LOC OD E Front-end : Online Data Maintenance Request Submission (.Net +MS SQL) Back-end: Production & 27 Publication (MS ACCESS)
Current workflow UN/LOC OD E DMRs prepared off-line Country with a National Focal Point (NFP)? • If yes, the DMR is forwarded to NFP for Data Synchronisation validation • If not, the secretariat validate the DMR Bi-annually, free of charge 28
UN/LOCODE DMRs UN/LOC OD E UN/LOCODE Data Maintenance Request (DMR) 9000 8000 7000 6000 Total 5000 Approved 4000 Addition Changes of names 3000 Other changes 2000 Deletion 1000 0 2012-2 2013-1 2013-2 2014-1 2014-2 2015-1 2015-2 2016-1 2016-2 2017-1 2017-2 29
UN/LOCODE DMR System UN/LOC OD E UN/LOCODE Data Maintenance Request system https://apps.unece.org/unlocode/ 30
UN/LOCODE DMR Submission UN/LOC OD E Step 1: New User Registration. Option 1 Option 2 31
UN/LOCODE DMR Submission 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 32
UN/LOCODE DMR Submission UN/LOC OD E Step 2: Login 33
UN/LOCODE DMR Submission UN/LOC OD E Main Menu: 34
UN/LOCODE DMR Submission UN/LOC OD E Step 3 Online request submission • Request for a new code 35
UN/LOCODE DMR Submission 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, Check • 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 Fill in resources. Submit 36
UN/LOCODE DMR Submission UN/LOC OD E Step 3 Online request submission • Request for changes 37
Recommend
More recommend
