8000 GitHub - CoreWP10/un-locode: United Nations Codes for Trade and Transport Locations (UN/LOCODE) and Country Codes
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content

CoreWP10/un-locode

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

23 Commits
 
 
 
 
 
 
 
 

Repository files navigation

UN-LOCODE datapackage

The United Nations Code for Trade and Transport Locations is a code list mantained by UNECE, United Nations agency, to facilitate trade.

Data

Data comes from the UNECE page, released at least once a year. The files released in this package are extracted from the mdb archive to preserve UTF-8 encoding.

Build dataset

Tools: MDBTools and CSVKit.

  • List tables mdb-tables {yyyy}-{r}\ UNLOCODE\ CodeList.mdb
  • Extract from mdb file: mdb-export {yyyy}-{r}\ UNLOCODE\ CodeList.mdb "{yyyy}-{r} UNLOCODE CodeList" > mdb_codelist.csv
  • Clean resulting csv: csvclean mdb_subdivisioncodes.csv
  • Remove country headers in codelist script/rmstr.php old_code-list.csv

Tables:

  • "{yyyy}-{r} UNLOCODE CodeList" > code-list.csv
  • "CountryCodes" > country-codes.csv
  • "FunctionClassifiers" > function-classifiers.csv
  • "StatusIndicators" > status-indicators.csv
  • "SubdivisionCodes" > subdivision-codes.csv

Note: in the strings above {yyyy} is the full year, {r} is the revision (1 or 2)

About

United Nations Codes for Trade and Transport Locations (UN/LOCODE) and Country Codes

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • PHP 100.0%
0