Page MenuHomeGitPull.it

POI sharing same Wikidata code
ActivePublic

Authored by valerio.bozzolan on Dec 12 2019, 10:43.
MariaDB [landscapefor]> SELECT wikidata_code, GROUP_CONCAT(poi_ID) FROM poi WHERE wikidata_code <> '' GROUP BY wikidata_code HAVING COUNT(*) > 1 ORDER BY COUNT(*) DESC;
+---------------+----------------------+
| wikidata_code | GROUP_CONCAT(poi_ID) |
+---------------+----------------------+
| Q1033649 | 10112,9581 |
| Q10339 | 8970,14599 |
| Q1054748 | 15765,15886 |
| Q1066935 | 10149,8040 |
| Q111942 | 9568,14422 |
| Q122476 | 8283,8241 |
| Q128202 | 10184,14953 |
| Q131148 | 10205,12780 |
| Q13145 | 14844,7312 |
| Q1324513 | 9269,13529 |
| Q1332930 | 11249,11098 |
| Q1380173 | 8297,8150 |
| Q1585931 | 13493,8101 |
| Q162965 | 15266,15071 |
| Q16596814 | 8939,11071 |
| Q1707242 | 6503,8778 |
| Q17798 | 14315,14651 |
| Q178813 | 13469,11651 |
| Q18040 | 14286,14659 |
| Q18356 | 14264,14637 |
| Q18365 | 14267,14644 |
| Q18368 | 14268,14643 |
| Q18416884 | 10661,10770 |
| Q18755063 | 8108,7944 |
| Q1903 | 12755,16045 |
| Q1916826 | 16018,15043 |
| Q19840 | 7271,16180 |
| Q19846 | 7273,16300 |
| Q20099 | 14341,14638 |
| Q20109 | 14344,14649 |
| Q20191 | 14367,14650 |
| Q20251 | 14648,14383 |
| Q2034331 | 15070,15268 |
| Q2047639 | 8439,8348 |
| Q20478 | 14372,14890 |
| Q20494 | 15028,14896 |
| Q2077168 | 11282,11427 |
| Q21013539 | 16553,16579 |
| Q21192547 | 14489,14485 |
| Q21192550 | 9563,10943 |
| Q21552096 | 9265,9266 |
| Q21552273 | 9204,9280 |
| Q224172 | 14350,14902 |
| Q23291 | 14697,14288 |
| Q2506967 | 10965,11857 |
| Q254139 | 14455,14561 |
| Q266604 | 14463,14544 |
| Q266794 | 14457,14554 |
| Q266941 | 14550,14460 |
| Q266975 | 14547,14449 |
| Q268067 | 14257,14470 |
| Q268995 | 14471,14320 |
| Q269516 | 14404,14474 |
| Q269823 | 14445,14482 |
| Q270032 | 14560,14466 |
| Q270189 | 14456,14571 |
| Q270320 | 14979,14556 |
| Q270328 | 14564,15015 |
| Q270492 | 14526,14441 |
| Q270548 | 14512,15014 |
| Q270613 | 14527,14462 |
| Q270782 | 14506,14454 |
| Q271152 | 14511,14451 |
| Q271236 | 14446,14517 |
| Q271358 | 14528,14444 |
| Q28001134 | 7041,7065 |
| Q2967848 | 9398,7825 |
| Q2968191 | 8829,14751 |
| Q30159213 | 12387,12642 |
| Q3328396 | 9366,15991 |
| Q3361323 | 10637,10944 |
| Q3364763 | 13187,13299 |
| Q34805 | 14994,14708 |
| Q35082 | 14754,14340 |
| Q35226 | 14226,14718 |
| Q358729 | 13328,14696 |
| Q3649109 | 8766,10617 |
| Q3657503 | 15804,16428 |
| Q3662426 | 10052,11652 |
| Q3662456 | 9610,9648 |
| Q3718646 | 8912,15404 |
| Q3757770 | 15285,9066 |
| Q3763803 | 9230,9232 |
| Q376739 | 8897,9080 |
| Q3785099 | 14180,14073 |
| Q3867520 | 8925,9025 |
| Q3867716 | 9135,16096 |
| Q3867764 | 8009,8047 |
| Q3867831 | 9173,9172 |
| Q3867851 | 8262,8263 |
| Q3867963 | 9037,8790 |
| Q3867973 | 9024,9005 |
| Q3868051 | 8677,9075 |
| Q3868253 | 8885,8886 |
| Q3868400 | 7993,7994 |
| Q3868487 | 9151,9022 |
| Q3886621 | 15832,16466 |
| Q3886642 | 15944,16441 |
| Q3889575 | 16554,15277 |
| Q3889607 | 14759,6493 |
| Q3889659 | 10800,10632 |
| Q3890190 | 15254,15264 |
| Q3890261 | 15287,15286 |
| Q3890698 | 13602,13612 |
| Q3892388 | 14518,14686 |
| Q3895631 | 14591,13206 |
| Q3895646 | 13216,16177 |
| Q3895647 | 13217,14666 |
| Q3895726 | 14083,13180 |
| Q3934723 | 11345,11336 |
| Q3936898 | 10762,10555 |
| Q3951389 | 10456,10245 |
| Q4011905 | 6985,6977 |
| Q47467390 | 15045,13962 |
| Q50119 | 15133,15132 |
| Q54087650 | 8914,8525 |
| Q54874186 | 9059,9058 |
| Q55354223 | 8004,8003 |
| Q55370383 | 16161,8884 |
| Q55372377 | 14812,8944 |
| Q55375790 | 8823,8840 |
| Q55379362 | 8237,8238 |
| Q55391578 | 9733,9732 |
| Q55686292 | 11359,11360 |
| Q55832719 | 11241,10842 |
| Q574879 | 13491,13490 |
| Q58844 | 13273,14184 |
| Q606494 | 7856,7891 |
| Q635414 | 13324,14116 |
| Q867361 | 13318,7208 |
+---------------+----------------------+
130 rows in set (0.03 sec)