search

marek5050 / UN-Locode-with-Timezone

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

Easy matches are far from accurate #6

Open cristan opened 8 months ago

cristan commented 8 months ago

I have the feeling this will be more for posterity than anything else, but I ran a script which compares the coordinates of the unlocodes with easy_allCountries.csv

The output of the first 100 lines:

https://unlocode.info/ARPRQ (Presidente Roque Sáenz Peña): 883km distance between https://www.google.com/maps?z=12&ll=-34.55000,-58.50000 and https://www.google.com/maps?z=12&ll=-26.7852,-60.4388 https://unlocode.info/ARSAA (San Antonio de Arredondo): 385km distance between https://www.google.com/maps?z=12&ll=-31.48333,-64.51667 and https://www.google.com/maps?z=12&ll=-32.9036,-60.7850 https://unlocode.info/ARSAE (San Antonio Este): 859km distance between https://www.google.com/maps?z=12&ll=-40.80000,-64.73333 and https://www.google.com/maps?z=12&ll=-34.8222,-58.5358 https://unlocode.info/ARSAN (Santa Ana): 1008km distance between https://www.google.com/maps?z=12&ll=-27.33333,-55.58333 and https://www.google.com/maps?z=12&ll=-28.5932,-65.7509 https://unlocode.info/ARSAO (San Antonio de Areco): 488km distance between https://www.google.com/maps?z=12&ll=-34.25000,-59.46667 and https://www.google.com/maps?z=12&ll=-32.1667,-64.0833 https://unlocode.info/ARSAR (Sarandi): 804km distance between https://www.google.com/maps?z=12&ll=-34.66667,-58.33333 and https://www.google.com/maps?z=12&ll=-27.4455,-58.7619 https://unlocode.info/ARSAT (San Martin): 1033km distance between https://www.google.com/maps?z=12&ll=-34.56667,-58.51667 and https://www.google.com/maps?z=12&ll=-25.3000,-57.7333 https://unlocode.info/ARSZQ (Sáenz Peña): 888km distance between https://www.google.com/maps?z=12&ll=-34.60000,-58.53333 and https://www.google.com/maps?z=12&ll=-26.7852,-60.4388 https://unlocode.info/ASPPG (Pago Pago): 3174km distance between https://www.google.com/maps?z=12&ll=14.26667,-170.70000 and https://www.google.com/maps?z=12&ll=-14.2781,-170.7025 https://unlocode.info/ATLOI (Loimersdorf): 540km distance between https://www.google.com/maps?z=12&ll=48.16667,16.83333 and https://www.google.com/maps?z=12&ll=47.3833,9.6988 https://unlocode.info/AUABC (Beulah): 591km distance between https://www.google.com/maps?z=12&ll=-35.93333,142.41667 and https://www.google.com/maps?z=12&ll=-31.6131,138.6962 https://unlocode.info/AUBBL (Beelbangera): 866km distance between https://www.google.com/maps?z=12&ll=-34.26667,146.10000 and https://www.google.com/maps?z=12&ll=-27.4000,141.8126 https://unlocode.info/AUCBD (Carabooda): 3314km distance between https://www.google.com/maps?z=12&ll=-31.60000,115.70000 and https://www.google.com/maps?z=12&ll=-33.8648,151.2077 https://unlocode.info/AUGYZ (Kersbrook): 1610km distance between https://www.google.com/maps?z=12&ll=-34.78333,138.85000 and https://www.google.com/maps?z=12&ll=-28.0320,123.8118 https://unlocode.info/AULOW (Lisarow): 313km distance between https://www.google.com/maps?z=12&ll=-33.38333,151.36667 and https://www.google.com/maps?z=12&ll=-30.8146,149.9983 https://unlocode.info/AULUM (Luddenham): 822km distance between https://www.google.com/maps?z=12&ll=-33.88333,150.68333 and https://www.google.com/maps?z=12&ll=-30.5153,142.9021 https://unlocode.info/AUMCG (McGraths Hill): 706km distance between https://www.google.com/maps?z=12&ll=-33.60000,150.83333 and https://www.google.com/maps?z=12&ll=-37.8200,144.9834 https://unlocode.info/AUNSW (Springwood): 430km distance between https://www.google.com/maps?z=12&ll=-33.70000,150.55000 and https://www.google.com/maps?z=12&ll=-33.0000,146.0000 https://unlocode.info/AUQLD (Kalbar): 1173km distance between https://www.google.com/maps?z=12&ll=-27.93333,152.61667 and https://www.google.com/maps?z=12&ll=-20.0000,145.0000 https://unlocode.info/AURAF (Raffles Bay): 3117km distance between https://www.google.com/maps?z=12&ll=-11.26667,132.38333 and https://www.google.com/maps?z=12&ll=-32.7374,152.0010 https://unlocode.info/AUSMY (Somersby): 3312km distance between https://www.google.com/maps?z=12&ll=-33.36667,151.28333 and https://www.google.com/maps?z=12&ll=-32.0483,115.7511 https://unlocode.info/AUWIL (Willawong): 463km distance between https://www.google.com/maps?z=12&ll=-27.58333,153.00000 and https://www.google.com/maps?z=12&ll=-30.8146,149.9983 https://unlocode.info/AUWLE (Witchcliffe): 3447km distance between https://www.google.com/maps?z=12&ll=-34.03333,115.10000 and https://www.google.com/maps?z=12&ll=-26.6584,150.1882 https://unlocode.info/AUYAN (Yagoona): 2341km distance between https://www.google.com/maps?z=12&ll=-33.90000,151.01667 and https://www.google.com/maps?z=12&ll=-18.0217,135.5420 https://unlocode.info/AUYBU (Yabulu): 864km distance between https://www.google.com/maps?z=12&ll=-19.21667,146.60000 and https://www.google.com/maps?z=12&ll=-24.9039,152.3190 https://unlocode.info/AUYDA (Yenda): 927km distance between https://www.google.com/maps?z=12&ll=-34.26667,146.18333 and https://www.google.com/maps?z=12&ll=-27.1585,151.2634 https://unlocode.info/AUYDN (Yandina): 2121km distance between https://www.google.com/maps?z=12&ll=-26.56667,152.95000 and https://www.google.com/maps?z=12&ll=-9.5799,143.7806 https://unlocode.info/AUYEE (Yeerongpilly): 3676km distance between https://www.google.com/maps?z=12&ll=-27.51667,153.00000 and https://www.google.com/maps?z=12&ll=-29.8325,115.2460 https://unlocode.info/AUYEL (Yeppoon): 2072km distance between https://www.google.com/maps?z=12&ll=-23.21667,151.23333 and https://www.google.com/maps?z=12&ll=-12.0194,135.5710 https://unlocode.info/AUYGB (Yangebup): 2900km distance between https://www.google.com/maps?z=12&ll=-32.11667,115.81667 and https://www.google.com/maps?z=12&ll=-11.6509,133.3807 https://unlocode.info/AUYKB (Yorkeys Knob): 3443km distance between https://www.google.com/maps?z=12&ll=-16.81667,145.71667 and https://www.google.com/maps?z=12&ll=-27.6889,114.2592 https://unlocode.info/AUYKN (Yokine): 262km distance between https://www.google.com/maps?z=12&ll=-31.90000,115.85000 and https://www.google.com/maps?z=12&ll=-33.7167,117.6330 https://unlocode.info/AUYLL (Yolla): 1568km distance between https://www.google.com/maps?z=12&ll=-41.13333,145.71667 and https://www.google.com/maps?z=12&ll=-27.4000,141.8126 https://unlocode.info/AUYLO (Yarloop): 2847km distance between https://www.google.com/maps?z=12&ll=-32.96667,115.88333 and https://www.google.com/maps?z=12&ll=-19.0056,139.8970 https://unlocode.info/AUYMB (Yambuk): 2387km distance between https://www.google.com/maps?z=12&ll=-38.33333,142.05000 and https://www.google.com/maps?z=12&ll=-17.0692,145.4190 https://unlocode.info/AUYMN (Coominya): 3147km distance between https://www.google.com/maps?z=12&ll=-27.38333,152.50000 and https://www.google.com/maps?z=12&ll=-27.2858,120.5511 https://unlocode.info/AUYNA (Yennora): 420km distance between https://www.google.com/maps?z=12&ll=-33.85000,150.96667 and https://www.google.com/maps?z=12&ll=-34.7022,146.5120 https://unlocode.info/AUYOR (York): 3023km distance between https://www.google.com/maps?z=12&ll=-31.88333,116.76667 and https://www.google.com/maps?z=12&ll=-33.3817,149.1330 https://unlocode.info/AUYRN (Cherry Gardens): 2553km distance between https://www.google.com/maps?z=12&ll=-35.06667,138.65000 and https://www.google.com/maps?z=12&ll=-12.3564,134.8980 https://unlocode.info/AUYRR (Yarra Junction): 2786km distance between https://www.google.com/maps?z=12&ll=-37.78333,145.61667 and https://www.google.com/maps?z=12&ll=-14.7344,134.5250 https://unlocode.info/AUYWO (Yarrawonga): 266km distance between https://www.google.com/maps?z=12&ll=-32.36667,149.65000 and https://www.google.com/maps?z=12&ll=-34.5604,150.7889 https://unlocode.info/BOMQK (San Matias): 1031km distance between https://www.google.com/maps?z=12&ll=-11.68333,-66.65000 and https://www.google.com/maps?z=12&ll=-16.3667,-58.4000 https://unlocode.info/BOSLC (San Lucas): 318km distance between https://www.google.com/maps?z=12&ll=-20.10000,-65.11667 and https://www.google.com/maps?z=12&ll=-17.4211,-66.1771 https://unlocode.info/BOSLO (San Lorenzo): 454km distance between https://www.google.com/maps?z=12&ll=-21.43333,-64.78333 and https://www.google.com/maps?z=12&ll=-17.9626,-67.0762 https://unlocode.info/BOSLR (San Lorenzo): 1044km distance between https://www.google.com/maps?z=12&ll=-11.88333,-66.85000 and https://www.google.com/maps?z=12&ll=-18.3247,-59.7682 https://unlocode.info/BOVVI (Viru Viru): 278km distance between https://www.google.com/maps?z=12&ll=-18.38333,-65.65000 and https://www.google.com/maps?z=12&ll=-17.6448,-63.1354 https://unlocode.info/BRAAG (Arapoti): 1401km distance between https://www.google.com/maps?z=12&ll=-14.60000,-41.11667 and https://www.google.com/maps?z=12&ll=-24.1578,-49.8267 https://unlocode.info/BRACA (Araucária): 794km distance between https://www.google.com/maps?z=12&ll=-2.88333,-40.11667 and https://www.google.com/maps?z=12&ll=-7.7907,-34.9102 https://unlocode.info/BRAGR (Alto Garcas): 1059km distance between https://www.google.com/maps?z=12&ll=-16.93333,-53.51667 and https://www.google.com/maps?z=12&ll=-25.3683,-48.7742 https://unlocode.info/BRAIR (Aripuana): 2353km distance between https://www.google.com/maps?z=12&ll=-30.08333,-51.73333 and https://www.google.com/maps?z=12&ll=-10.1864,-59.4575 https://unlocode.info/BRAPQ (Arapiraca): 1387km distance between https://www.google.com/maps?z=12&ll=-7.65000,-49.06667 and https://www.google.com/maps?z=12&ll=-9.7754,-36.6292 https://unlocode.info/BRARA (Araras): 363km distance between https://www.google.com/maps?z=12&ll=-25.58333,-49.40000 and https://www.google.com/maps?z=12&ll=-23.5668,-46.5719 https://unlocode.info/BRAUX (Araguaína): 1031km distance between https://www.google.com/maps?z=12&ll=-16.35000,-49.66667 and https://www.google.com/maps?z=12&ll=-7.1911,-48.2072 https://unlocode.info/BRBMS (Brumado): 369km distance between https://www.google.com/maps?z=12&ll=-16.20000,-44.41667 and https://www.google.com/maps?z=12&ll=-14.2036,-41.6653 https://unlocode.info/BRBPG (Barra do Garças): 1305km distance between https://www.google.com/maps?z=12&ll=-27.53333,-53.86667 and https://www.google.com/maps?z=12&ll=-15.8900,-52.2567 https://unlocode.info/BRBRB (Barreirinhas): 1941km distance between https://www.google.com/maps?z=12&ll=-20.15000,-41.28333 and https://www.google.com/maps?z=12&ll=-2.7556,-42.8259 https://unlocode.info/BRBRE (Boraceia): 264km distance between https://www.google.com/maps?z=12&ll=-22.18333,-48.76667 and https://www.google.com/maps?z=12&ll=-23.5251,-46.6389 https://unlocode.info/BRBRL (Brasiléia): 2714km distance between https://www.google.com/maps?z=12&ll=-11.00000,-68.73333 and https://www.google.com/maps?z=12&ll=-23.4486,-46.6884 https://unlocode.info/BRBRS (Barreiros): 2042km distance between https://www.google.com/maps?z=12&ll=-8.80000,-35.18333 and https://www.google.com/maps?z=12&ll=-23.5500,-46.6167 https://unlocode.info/BRBUT (Buritis): 885km distance between https://www.google.com/maps?z=12&ll=-15.61667,-46.41667 and https://www.google.com/maps?z=12&ll=-23.5702,-46.7263 https://unlocode.info/BRBVM (Belmonte): 1198km distance between https://www.google.com/maps?z=12&ll=-5.11667,-39.71667 and https://www.google.com/maps?z=12&ll=-15.8613,-38.8798 https://unlocode.info/BRCAF (Carauari): 2796km distance between https://www.google.com/maps?z=12&ll=-8.36667,-41.81667 and https://www.google.com/maps?z=12&ll=-4.8828,-66.8958 https://unlocode.info/BRCAG (Campo Alegre): 2435km distance between https://www.google.com/maps?z=12&ll=-26.18333,-49.25000 and https://www.google.com/maps?z=12&ll=-8.2723,-35.9812 https://unlocode.info/BRCBE (Cambe): 471km distance between https://www.google.com/maps?z=12&ll=-23.26667,-51.26667 and https://www.google.com/maps?z=12&ll=-23.6281,-46.6679 https://unlocode.info/BRCBW (Campo Mourao): 457km distance between https://www.google.com/maps?z=12&ll=-27.88333,-50.75000 and https://www.google.com/maps?z=12&ll=-24.0431,-52.3793 https://unlocode.info/BRCCI (Camaçari): 2155km distance between https://www.google.com/maps?z=12&ll=-12.68333,-38.31667 and https://www.google.com/maps?z=12&ll=-27.1806,-52.0527 https://unlocode.info/BRCDJ (Conceição do Araguaia): 1588km distance between https://www.google.com/maps?z=12&ll=-8.78333,-63.70000 and https://www.google.com/maps?z=12&ll=-8.2644,-49.2698 https://unlocode.info/BRCDU (Candido Rodrigues): 333km distance between https://www.google.com/maps?z=12&ll=-21.31667,-48.63333 and https://www.google.com/maps?z=12&ll=-23.7258,-46.7024 https://unlocode.info/BRCFB (Coronel Fabriciano): 383km distance between https://www.google.com/maps?z=12&ll=-19.51667,-42.61667 and https://www.google.com/maps?z=12&ll=-22.9217,-42.0743 https://unlocode.info/BRCFO (Cabo Frio): 1696km distance between https://www.google.com/maps?z=12&ll=-22.86667,-42.01667 and https://www.google.com/maps?z=12&ll=-10.6439,-51.5689 https://unlocode.info/BRCIA (Claudia): 1795km distance between https://www.google.com/maps?z=12&ll=-11.50000,-54.86667 and https://www.google.com/maps?z=12&ll=-12.8227,-38.4073 https://unlocode.info/BRCIC (Caico): 2485km distance between https://www.google.com/maps?z=12&ll=-6.45000,-37.08333 and https://www.google.com/maps?z=12&ll=-25.4574,-49.3779 https://unlocode.info/BRCIZ (Coari): 2872km distance between https://www.google.com/maps?z=12&ll=-11.51667,-38.15000 and https://www.google.com/maps?z=12&ll=-4.0850,-63.1414 https://unlocode.info/BRCLD (Colider): 1707km distance between https://www.google.com/maps?z=12&ll=-10.80000,-55.45000 and https://www.google.com/maps?z=12&ll=-23.5620,-46.4913 https://unlocode.info/BRCLM (Colmeia): 1672km distance between https://www.google.com/maps?z=12&ll=-8.71667,-48.75000 and https://www.google.com/maps?z=12&ll=-23.6333,-46.7667 https://unlocode.info/BRCMB (Cambuci): 533km distance between https://www.google.com/maps?z=12&ll=-21.56667,-41.90000 and https://www.google.com/maps?z=12&ll=-23.5644,-46.6170 https://unlocode.info/BRCMT (Candido Mota): 2280km distance between https://www.google.com/maps?z=12&ll=-22.73333,-50.38333 and https://www.google.com/maps?z=12&ll=-2.2444,-49.4958 https://unlocode.info/BRCNG (Carangola): 557km distance between https://www.google.com/maps?z=12&ll=-20.71667,-42.01667 and https://www.google.com/maps?z=12&ll=-23.4970,-46.5204 https://unlocode.info/BRCNP (Campo Novo do Parecis): 1856km distance between https://www.google.com/maps?z=12&ll=-13.65000,-57.88333 and https://www.google.com/maps?z=12&ll=-22.8968,-43.2253 https://unlocode.info/BRCOM (Campo Maior): 2336km distance between https://www.google.com/maps?z=12&ll=-4.81667,-42.16667 and https://www.google.com/maps?z=12&ll=-24.8518,-48.7352 https://unlocode.info/BRCON (Contenda): 373km distance between https://www.google.com/maps?z=12&ll=-25.66667,-49.51667 and https://www.google.com/maps?z=12&ll=-23.5524,-46.6574 https://unlocode.info/BRCOP (Carmo do Paranaiba): 874km distance between https://www.google.com/maps?z=12&ll=-18.98333,-46.30000 and https://www.google.com/maps?z=12&ll=-26.1413,-49.8176 https://unlocode.info/BRCPV (Campina Grande): 2969km distance between https://www.google.com/maps?z=12&ll=-30.13333,-50.50000 and https://www.google.com/maps?z=12&ll=-7.2306,-35.8811 https://unlocode.info/BRCQA (Camaqua): 1924km distance between https://www.google.com/maps?z=12&ll=-30.85000,-51.80000 and https://www.google.com/maps?z=12&ll=-13.5522,-52.2683 https://unlocode.info/BRCRE (Cordeiro): 490km distance between https://www.google.com/maps?z=12&ll=-22.01667,-42.35000 and https://www.google.com/maps?z=12&ll=-23.6688,-46.7805 https://unlocode.info/BRCRP (Caarapo): 970km distance between https://www.google.com/maps?z=12&ll=-22.63333,-54.81667 and https://www.google.com/maps?z=12&ll=-19.2174,-46.2217 https://unlocode.info/BRCSW (Colorado do Oeste): 2143km distance between https://www.google.com/maps?z=12&ll=-30.60000,-51.75000 and https://www.google.com/maps?z=12&ll=-13.1167,-60.5417 https://unlocode.info/BRCUR (Curtibanos): 566km distance between https://www.google.com/maps?z=12&ll=-27.26667,-50.56667 and https://www.google.com/maps?z=12&ll=-23.6314,-46.6207 https://unlocode.info/BRDTI (Duartina): 760km distance between https://www.google.com/maps?z=12&ll=-22.40000,-49.40000 and https://www.google.com/maps?z=12&ll=-18.2469,-43.6035 https://unlocode.info/BREPA (Engenheiro Passos): 2490km distance between https://www.google.com/maps?z=12&ll=-7.01667,-35.85000 and https://www.google.com/maps?z=12&ll=-25.5775,-48.9712 https://unlocode.info/BRGEL (Santo Angelo): 2612km distance between https://www.google.com/maps?z=12&ll=-5.73333,-47.36667 and https://www.google.com/maps?z=12&ll=-28.2992,-54.2631 https://unlocode.info/BRGRA (Girua): 808km distance between https://www.google.com/maps?z=12&ll=-29.93333,-50.98333 and https://www.google.com/maps?z=12&ll=-23.7698,-46.6711 https://unlocode.info/BRGUA (Guamaré): 2319km distance between https://www.google.com/maps?z=12&ll=-5.10000,-36.31667 and https://www.google.com/maps?z=12&ll=-23.5433,-46.4108 https://unlocode.info/BRIBI (Ibati): 357km distance between https://www.google.com/maps?z=12&ll=-23.83333,-50.18333 and https://www.google.com/maps?z=12&ll=-23.5858,-46.6824 https://unlocode.info/BRIII (Itariri): 338km distance between https://www.google.com/maps?z=12&ll=-24.28333,-47.16667 and https://www.google.com/maps?z=12&ll=-26.7670,-49.1030 https://unlocode.info/BRIPA (Ibipora): 477km distance between https://www.google.com/maps?z=12&ll=-23.26667,-51.05000 and https://www.google.com/maps?z=12&ll=-23.5031,-46.3857 https://unlocode.info/BRIPG (Ipiranga): 1295km distance between https://www.google.com/maps?z=12&ll=-2.73333,-58.03333 and https://www.google.com/maps?z=12&ll=-2.9391,-69.6940 https://unlocode.info/BRIPI (Itapagipe): 1277km distance between https://www.google.com/maps?z=12&ll=-14.13333,-39.73333 and https://www.google.com/maps?z=12&ll=-23.6000,-46.6167 https://unlocode.info/BRIPU (Ipiaú): 1099km distance between https://www.google.com/maps?z=12&ll=-4.30000,-40.71667 and https://www.google.com/maps?z=12&ll=-14.1345,-39.7395 https://unlocode.info/BRISA (Ilha Solteira): 597km distance between https://www.google.com/maps?z=12&ll=-20.41667,-51.33333 and https://www.google.com/maps?z=12&ll=-25.4374,-49.2700

All in all, there were: 3481 who are within 250 km. 2607 who weren't.

If I just check the first 10 differences: Instances where your CSV is more accurate:

Instances where the unlocode location is more accurate:

That ain't a great score. So I guess just using the unlocode locations yields more accurate coordinates (even though that's inaccurate too: finding the 2 inaccurate locations in unlocode was way too easy).

Surprisingly, perfect_allCountries.csv seems to be much more accurate (Close: 13453. Far: 384) good_allCountries.csv is also good (Close: 50403. Far: 4878)