search

marek5050 / UN-Locode-with-Timezone

UN Locodes with additional lat, long, and timezone information
7 stars 2 forks source link

readme

UN Locodes with coordinates and timezones

.github/workflows/actions.yml

The repository contains the latest UN-Locode-with-Timezone information.

Sources

The GeoNames geographical database covers all countries and contains over eleven million placenames that are available for download free of charge. https://www.geonames.org

The "United Nations Code for Trade and Transport Locations" is commonly more known as "UN/LOCODE". Although managed and maintained by the UNECE, it is the product of a wide collaboration in the framework of the joint trade facilitation effort undertaken within the United Nations.

https://www.unece.org/cefact/locode/service/location.html Last updated: Fri Sep 4 17:20:02 EDT 2020

==> ./data/all_data.csv <==
name,country_code,subdivision,unlocode,location,asciiname,coordinates,latitude,longitude,timezone,modification date
Andorra la Vella,AD,,ADALV,ALV,Andorra la Vella,4230N 00131E,42.5078,1.5211,Europe/Andorra,2020-03-03
Arandis,,,ADI,ADI,Arandis Airport,,-22.4622,14.9800,Africa/Windhoek,2011-02-17
Al Ain,AE,,AEAAN,AAN,Al Ain City,,24.1917,55.7606,Asia/Dubai,2019-05-29
Abu Dhabi,AE,AZ,AEAUH,AUH,Abu Dhabi,2428N 05422E,24.4512,54.3970,Asia/Dubai,2019-09-05
Al Dhafra,AE,,AEDHF,DHF,Al Dhafra Air Base,2414N 05432E,24.2484,54.5485,Asia/Dubai,2013-05-18
Dubai World Central Apt,AE,,AEDWC,DWC,Dubai World Central - Al Maktoum International Airport,2453N 05510E,24.8978,55.1591,Asia/Dubai,2014-04-15
Dubai,AE,DU,AEDXB,DXB,Dubai,2515N 05516E,25.0772,55.3093,Asia/Dubai,2019-08-28
Al Fujayrah,AE,FU,AEFJR,FJR,Al Fujairah City,2507N 05620E,25.1164,56.3414,Asia/Dubai,2019-05-29
Minhad,AE,,AENHD,NHD,Al Minhad Air Base,,25.0267,55.3695,Asia/Dubai,2013-06-16

==> ./data/easy_allCountries.csv <==
name,country_code,subdivision,unlocode,location,asciiname,coordinates,latitude,longitude,timezone,modification date
Andorra la Vella,AD,,ADALV,ALV,Andorra la Vella,4230N 00131E,42.5078,1.5211,Europe/Andorra,2020-03-03
Arandis,,,ADI,ADI,Arandis Airport,,-22.4622,14.9800,Africa/Windhoek,2011-02-17
Al Ain,AE,,AEAAN,AAN,Al Ain City,,24.1917,55.7606,Asia/Dubai,2019-05-29
Abu Dhabi,AE,AZ,AEAUH,AUH,Abu Dhabi,2428N 05422E,24.4512,54.3970,Asia/Dubai,2019-09-05
Al Dhafra,AE,,AEDHF,DHF,Al Dhafra Air Base,2414N 05432E,24.2484,54.5485,Asia/Dubai,2013-05-18
Dubai World Central Apt,AE,,AEDWC,DWC,Dubai World Central - Al Maktoum International Airport,2453N 05510E,24.8978,55.1591,Asia/Dubai,2014-04-15
Dubai,AE,DU,AEDXB,DXB,Dubai,2515N 05516E,25.0772,55.3093,Asia/Dubai,2019-08-28
Al Fujayrah,AE,FU,AEFJR,FJR,Al Fujairah City,2507N 05620E,25.1164,56.3414,Asia/Dubai,2019-05-29
Minhad,AE,,AENHD,NHD,Al Minhad Air Base,,25.0267,55.3695,Asia/Dubai,2013-06-16

==> ./data/good_allCountries.csv <==
name,country_code,subdivision,unlocode,location,asciiname,coordinates,latitude,longitude,timezone,modification date
's-Gravenwezel,BE,,BEGWE,GWE,'s-Gravenwezel,5116N 00433E,51.2627,4.5611,Europe/Brussels,2020-05-25
's-Gravenzande,NL,,NLGRZ,GRZ,'s-Gravenzande,5200N 00410E,52.0017,4.1653,Europe/Amsterdam,2017-10-17
's-Heerenberg,NL,,NLHRB,HRB,'s-Heerenberg,5153N 00615E,51.8767,6.2588,Europe/Amsterdam,2017-10-17
's-Hertogenbosch,NL,,NLHTB,HTB,'s-Hertogenbosch,5142N 00519E,51.6992,5.3042,Europe/Amsterdam,2020-01-13
't Zand,NL,,NLTZA,TZA,'t Zand,,52.8367,4.7556,Europe/Amsterdam,2017-10-17
150 Mile House,CA,,CAMHS,MHS,150 Mile House,5207N 12157W,52.1165,-121.8528,America/Vancouver,2008-04-11
A Baiuca,ES,,ESAXO,AXO,A Baiuca,4318N 00830W,43.3096,-8.5020,Europe/Madrid,2009-02-20
A Cañiza,ES,,ESA2C,A2C,A Caniza,4212N 00828W,42.2167,-8.2667,Europe/Madrid,2012-02-23
A Guarda,ES,,ESUAR,UAR,A Guarda,4154N 00852W,41.9013,-8.8742,Europe/Madrid,2012-03-04

==> ./data/perfect_allCountries.csv <==
name,country_code,subdivision,unlocode,location,asciiname,coordinates,latitude,longitude,timezone,modification date
Aadorf,CH,TG,CHARF,ARF,Aadorf,4729N 00854E,47.4920,8.9010,Europe/Zurich,2013-03-28
Aarau,CH,AG,CHAAR,AAR,Aarau,,47.3925,8.0442,Europe/Zurich,2020-06-29
Aarberg,CH,BE,CHABG,ABG,Aarberg,4703N 00717E,47.0444,7.2758,Europe/Zurich,2013-02-28
Aarburg,CH,AG,CHAAB,AAB,Aarburg,4718N 00753E,47.3207,7.8999,Europe/Zurich,2019-09-11
Aaronsburg,US,PA,USAA7,AA7,Aaronsburg,4053N 07727W,40.8998,-77.4533,America/New_York,2017-05-23
Aarwangen,CH,BE,CHAWG,AWG,Aarwangen,4714N 00745E,47.2385,7.7685,Europe/Zurich,2013-03-01
Abbeville,US,AL,USABB,ABB,Abbeville,,31.5718,-85.2505,America/Chicago,2017-03-09
Abbeville,US,MS,USAV4,AV4,Abbeville,3430N 08930W,34.5032,-89.5031,America/Chicago,2017-03-09
Abbeville,US,SC,USABF,ABF,Abbeville,,34.1782,-82.3790,America/New_York,2017-03-09