POI sharing same Wikidata code
ActivePublic
Actions

Authored by valerio.bozzolan on Dec 12 2019, 10:43.

Tags

Referenced Files

	F1288: raw.txt
	Dec 13 2019, 08:03

	F1269: raw.txt
	Dec 12 2019, 16:06

	F1258: raw.txt
	Dec 12 2019, 13:02

	F1251: raw.txt
	Dec 12 2019, 10:43

Subscribers

setareh.pedone

	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)

Event Timeline

valerio.bozzolan created this paste.Dec 12 2019, 10:43

valerio.bozzolan created this object with visibility "Landscapefor (Project)".

valerio.bozzolan created this object with edit policy "Landscapefor (Project)".

valerio.bozzolan mentioned this in T72: Found POIs sharing same Wikidata code.Dec 12 2019, 11:03

valerio.bozzolan edited the content of this paste. (Show Details)Dec 12 2019, 13:02

valerio.bozzolan edited the content of this paste. (Show Details)Dec 12 2019, 16:06

valerio.bozzolan changed the visibility from "Landscapefor (Project)" to "Public (No Login Required)".Dec 12 2019, 20:28

valerio.bozzolan changed the edit policy from "Landscapefor (Project)" to "valerio.bozzolan (Valerio Bozzolan)".

valerio.bozzolan edited the content of this paste. (Show Details)Dec 13 2019, 08:03

• incoming.assistenza.ils mentioned this in T389: quale versione di linux scegliere.Jun 3 2020, 11:47

	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)

POI sharing same Wikidata codeActivePublicActions

Event Timeline

POI sharing same Wikidata code
ActivePublic
Actions