Skip to content

Instantly share code, notes, and snippets.

@ImreSamu
Created August 23, 2017 00:35
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ImreSamu/0f863fc38ece2ae5ef4484879d30b167 to your computer and use it in GitHub Desktop.
Save ImreSamu/0f863fc38ece2ae5ef4484879d30b167 to your computer and use it in GitHub Desktop.
NaturalEarth wikidataId - SparQL query differences. ( Data generated via WIKIDATA SPARQL )
id name ADM0NAME QA status NE_wikidataid proposed wikidataid SPARQL status found wikidata found wikidata name distance
4 Florida Uruguay WD04: Difference Q812 Q842472
84 Busia Uganda WD04: Difference Q1240823 Q1111957
96 Kibuye Rwanda WD04: Difference Q22218005 Q617032
233 Fribourg Switzerland WD04: Difference Q3067114 Q36378
289 Sabaneta Dominican Republic WD04: Difference Q2049091 Q2021983
535 Nazran Russia WD04: Difference Q5222 Q163935
679 Barinas Venezuela WD04: Difference Q2884525 Q695623
695 Melbourne United States of America WD04: Difference Q3141 Q949779
737 Lumberton United States of America WD04: Difference Q401844 Q2029674
805 Douma Syria WD04: Difference Q2389156 Q403446
883 Bristol United Kingdom WD04: Difference Q5146396 Q23154
942 Lamas Peru WD04: Difference Q402874 Q3139869
949 Huaura Peru WD04: Difference Q3236666 Q16576408
996 Sahiwal Pakistan WD04: Difference Q223831 Q523778
1008 Lalitpur Nepal WD04: Difference Q1517030 Q6647
1054 Novomoskovsk Russia WD04: Difference Q246798 Q175161
1066 Plast Russia WD04: Difference Q832664 Q179476
1098 Shilka Russia WD04: Difference Q1845364 Q198306
1145 Tlaxcala Mexico WD04: Difference Q689987 Q614072
1235 Cartago Costa Rica WD04: Difference Q225707 Q30617
1335 Takaoka Japan WD04: Difference Q357197 Q502988
1411 Kavala Greece WD04: Difference Q5563550 Q187352
1564 Camrose Canada WD04: Difference Q2923319 Q775610
1652 Campana Argentina WD04: Difference Q857788 Q1030194
2074 Niagara Falls United States of America WD04: Difference Q34221 Q128133
2087 Barcelona Venezuela WD04: Difference Q1492 Q391221
2119 Santander Spain WD04: Difference Q225393 Q12233
2128 Tarragona Spain WD04: Difference Q1501940 Q15088
2141 Tadmur Syria WD04: Difference Q5747 Q938457
2335 Victoria Falls Zimbabwe WD04: Difference Q43278 Q1393804
2408 Manisa Turkey WD04: Difference Q920866 Q147089
2411 Tarsus Turkey WD04: Difference Q48001 Q134287
2433 Jeju South Korea WD04: Difference Q29130 Q42142
2451 Batman Turkey WD04: Difference Q2695156 Q159835
2452 Van Turkey WD04: Difference Q193468 Q83061
2474 Szeged Hungary WD04: Difference Q719339 Q81581
2517 Singida Tanzania WD04: Difference Q410388 Q153331
2523 Moshi Tanzania WD04: Difference Q6916210 Q271733
2533 Alicante Spain WD04: Difference Q3555926 Q11959
2543 Ruhengeri Rwanda WD04: Difference Q2360921 Q246145
2571 Sicuani Peru WD04: Difference Q2608412 Q4419079
2573 Ayaviri Peru WD04: Difference Q4830995 Q3344141
2575 Desaguadero Peru WD04: Difference Q296697 Q1200491
2579 Chota Peru WD04: Difference Q1076674 Q2964558
2585 Chachapoyas Peru WD04: Difference Q412261 Q757133
2686 Jhang Pakistan WD04: Difference Q6190853 Q1026616
2711 Raub Malaysia WD04: Difference Q2352205 Q19904459
2740 Kisii Kenya WD04: Difference Q452808 Q1007719
2853 Safonovo Russia WD04: Difference Q1921273 Q193575
2863 Nelidovo Russia WD04: Difference Q16877910 Q172366
2874 Zheleznogorsk Russia WD04: Difference Q2233157 Q72536
2910 Sasovo Russia WD04: Difference Q12354972 Q193557
3023 Cadiz Philippines WD04: Difference Q15682 Q1020688
3030 San Pablo Philippines WD04: Difference Q295411 Q76001
3088 Makarov Russia WD04: Difference Q344909 Q157930
3160 Frontera Mexico WD04: Difference Q20261539 Q2448297
3227 Oyo Nigeria WD04: Difference Q363756 Q1023703
3229 Onitsha Nigeria WD04: Difference Q1220095 Q852238
3339 Mataram Indonesia WD04: Difference Q292392 Q14126
3356 Carnot Central African Republic WD04: Difference Q183558 Q521702
3503 Las Tunas Cuba WD04: Difference Q440429 Q115527
3555 Doba Chad WD04: Difference Q293481 Q985618
3556 Pala Chad WD04: Difference Q226429 Q1774419
3560 Split Croatia WD04: Difference Q233272 Q1663
3562 Tanta Egypt WD04: Difference Q357816 Q271771
3724 Kumamoto Japan WD04: Difference Q900963 Q199889
3770 Iwaki Japan WD04: Difference Q341831 Q274384
3771 Nagaoka Japan WD04: Difference Q356996 Q540312
3772 Yamagata Japan WD04: Difference Q773311 Q205526
3830 Tamale Ghana WD04: Difference Q1147853 Q217040
3963 Xanthi Greece WD04: Difference Q5277646 Q210296
4066 Torbat-e Jam Iran WD04: Difference Q1278088 Q765715
4278 Brooks Canada WD04: Difference Q228829 Q1055838
4303 Porto Santana Brazil WD04: Difference Q1994845 Q2105236
4379 San Borja Bolivia WD04: Difference Q409362 Q2307472
4431 Reconquista Argentina WD04: Difference Q79791 Q933165
4513 Cabinda Angola WD04: Difference Q1946951 Q459360
4598 Pinsk Belarus WD04: Difference Q21579783 Q204150
4616 Maun Botswana WD04: Difference Q4285540 Q170732
4801 George Town Cayman Islands WD04: Difference Q382100 Q172996
4812 Oranjestad Aruba WD04: Difference Q246290 Q131243
4901 Providence United States of America WD04: Difference Q54268 Q18383
4952 Cardiff United Kingdom WD04: Difference Q5038359 Q10690
4984 Skien Norway WD04: Difference Q3354033 Q2272
5018 Tula Russia WD04: Difference Q226319 Q2770
5021 Kurgan Russia WD04: Difference Q5737 Q13379
5062 Slyudyanka Russia WD04: Difference Q1843402 Q181550
5064 Zima Russia WD04: Difference Q203391 Q140012
5205 Santa Clara Cuba WD04: Difference Q1713911 Q211590
5239 Panzhihua China WD04: Difference Q713410 Q425415
5286 Kagoshima Japan WD04: Difference Q3537114 Q15674
5288 Wuhai China WD04: Difference Q1378088 Q570768
5306 Akita Japan WD04: Difference Q1872285 Q17139
5409 Coro Venezuela WD04: Difference Q343113 Q1134454
5430 Canton United States of America WD04: Difference Q399799 Q491239
5538 San Luis Argentina WD04: Difference Q225404 Q44243
5547 Oruro Bolivia WD04: Difference Q1221078 Q35246
5614 Myitkyina Myanmar WD04: Difference Q11917400 Q1062370
5634 Tumbes Peru WD04: Difference Q1178003 Q827640
5646 Pisco Peru WD04: Difference Q388502 Q290504
5754 Roxas Philippines WD04: Difference Q356752 Q2209
5844 Bengkulu Indonesia WD04: Difference Q1890 Q8042
5865 Sarh Chad WD04: Difference Q7399223 Q337530
5898 Jambi Indonesia WD04: Difference Q2051 Q7578
5943 Ghat Libya WD04: Difference Q1010155 Q209393
6052 Red Deer Canada WD04: Difference Q79794 Q23025
6107 Resistencia Argentina WD04: Difference Q7315630 Q44206
6146 Myeik Myanmar WD04: Difference Q6947281 Q1018163
6158 Macau Macau S.A.R WD04: Difference Q585538 Q14773
6225 Albuquerque United States of America WD04: Difference Q1933179 Q34804
6258 Sault Ste. Marie United States of America WD04: Difference Q255373 Q986634
6294 Maradi Niger WD04: Difference Q1174235 Q664550
6327 Hammerfest Norway WD04: Difference Q107351 Q721374
6346 Safi Morocco WD04: Difference Q345122 Q183405
6450 Ternate Indonesia WD04: Difference Q333483 Q19151
6452 Raba Indonesia WD04: Difference Q453150 Q7278471
6464 Tianshui China WD04: Difference Q6963191 Q533157
6467 Yulin China WD04: Difference Q299247 Q571918
6552 Sakata Japan WD04: Difference Q425205 Q504690
6690 Rawson Argentina WD04: Difference Q294689 Q44208
6715 Bridgetown Barbados WD04: Difference Q1748747 Q36168
6719 Constantine Algeria WD04: Difference Q3258804 Q187346
6756 Kingstown Saint Vincent and the Grenadines WD04: Difference Q754913 Q41474
6757 Castries Saint Lucia WD04: Difference Q188367 Q41699
6773 Montevideo Uruguay WD04: Difference Q986302 Q1335
6790 Valencia Venezuela WD04: Difference Q8818 Q54880
6810 Valdez United States of America WD04: Difference Q298593 Q80037
6824 Georgetown Guyana WD04: Difference Q178983 Q10717
6838 Trujillo Peru WD04: Difference Q2527815 Q214173
6861 Panama City Panama WD04: Difference Q804 Q3306
6884 Colombo Sri Lanka WD04: Difference Q926688 Q35381
6892 Chita Russia WD04: Difference Q6827 Q53139
6919 Abuja Nigeria WD04: Difference Q3505231 Q3787
6944 Kingston Jamaica WD04: Difference Q919869 Q34692
7039 Halifax Canada WD04: Difference Q218260 Q2141
7056 Posadas Argentina WD04: Difference Q359611 Q44238
7091 Hamilton Bermuda WD04: Difference Q1033394 Q30985
7168 Prague Czech Republic WD04: Difference Q1953283 Q1085
7187 Santo Domingo Dominican Republic WD04: Difference Q1578783 Q34820
7215 Brussels Belgium WD04: Difference Q239 Q9005
7272 Rome Italy WD04: Difference Q6580 Q220
7282 Santiago Chile WD04: Difference Q22034884 Q2887
7319 Wellington New Zealand WD04: Difference Q2728707 Q23661
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment