Page MenuHomeGitPull.it

Found POIs sharing same Wikidata code
Open, LowPublic

Description

There are some POIs that have the same Wikidata code, but this can't happen.

Here a list of all the POI IDs with this problem:

SELECT wikidata_code, GROUP_CONCAT(poi_ID) FROM poi WHERE wikidata_code <> '' GROUP BY wikidata_code HAVING COUNT(*) > 1 ORDER BY COUNT(*) DESC;
wikidata_codeGROUP_CONCAT(poi_ID)
Q1779814315,14651
Q178739714600,7288
Q17881313469,11651
Q1804014286,14659
Q1835614637,14264
Q1836514267,14644
Q1836814268,14643
Q1841688410770,10661
Q187550637944,8108
Q190312755,16045
Q191682615043,16018
Q198407271,16180
Q198467273,16300
Q2009914638,14341
Q2010914344,14649
Q2019114650,14367
Q2025114383,14648
Q203433115070,15268
Q20476398348,8439
Q2047814890,14372
Q2049414896,15028
Q207716811282,11427
Q2101353916553,16579
Q2119254714489,14485
Q2119255010943,9563
Q215520969265,9266
Q215522739204,9280
Q22417214350,14902
Q2253614393,14680
Q2328514698,14287
Q2329114288,14697
Q250696711857,10965
Q25413914561,14455
Q26660414544,14463
Q26679414457,14554
Q26694114550,14460
Q26697514449,14547
Q26806714470,14257
Q26899514320,14471
Q26951614404,14474
Q26982314445,14482
Q27003214466,14560
Q27018914456,14571
Q27032014979,14556
Q27032814564,15015
Q27049214526,14441
Q27054815014,14512
Q27061314462,14527
Q27078214454,14506
Q27115214511,14451
Q27123614517,14446
Q27135814444,14528
Q29678487825,9398
Q29681918829,14751
Q3003154614677,14978
Q3015921312387,12642
Q33283969366,15991
Q336132310637,10944
Q336476313299,13187
Q3480514708,14994
Q3508214754,14340
Q3522614226,14718
Q35872914696,13328
Q36491098766,10617
Q366242610052,11652
Q36624569610,9648
Q37186468912,15404
Q37577709066,15285
Q37638039232,9230
Q3767399080,8897
Q378509914180,14073
Q38675208925,9025
Q38677169135,16096
Q38677648009,8047
Q38678319172,9173
Q38678518262,8263
Q38679639037,8790
Q38679739024,9005
Q38680518677,9075
Q38682538886,8885
Q38684007993,7994
Q38684879022,9151
Q388662115832,16466
Q388664215944,16441
Q388957515277,16554
Q388965910632,10800
Q389019015254,15264
Q389026115286,15287
Q389069813602,13612
Q389238814518,14686
Q389542113203,12330
Q389563114591,13206
Q389564616177,13216
Q389564713217,14666
Q389572614083,13180
Q393689810555,10762
Q395138910245,10456
Q4746739015045,13962
Q5011915132,15133
Q540876508525,8914
Q548741869058,9059
Q553542238004,8003
Q5537038316161,8884
Q553723778944,14812
Q553757908840,8823
Q553793628237,8238
Q553915789733,9732
Q5568629211359,11360
Q5583271910842,11241
Q57487913490,13491
Q5884413273,14184
Q6064947856,7891
Q63541413324,14116
Q8673617208,13318

Event Timeline

valerio.bozzolan moved this task from Restricted Project Column to Restricted Project Column on the Restricted Project board.Dec 12 2019, 17:11
valerio.bozzolan moved this task from Restricted Project Column to Restricted Project Column on the Restricted Project board.Dec 12 2019, 21:03
valerio.bozzolan added a comment.EditedDec 13 2019, 08:02

I've corrected some of these automatically with a script. Here the log:

Remove Q65934092 from 13651 because it's OK 15088 
Remove Q56071 from 15102 because it's OK 7293 
Remove Q1393382 from 15774 because it's OK 15207 
Remove Q1145261 from 15656 because it's OK 6484 
Remove Q3328410 from 8145 because it's OK 7855 
Remove Q16920958 from 13470 because it's OK 7203 
Remove Q207070 from 15103 because it's OK 7294 
Remove Q73002622 from 10349 because it's OK 10348 
Remove Q72703760 from 16457 because it's OK 12358 
Remove Q3958082 from 15762 because it's OK 14439 
Remove Q2836365 from 15852 because it's OK 6452 
Remove Q3819018 from 8958 because it's OK 6510 
Remove Q3895386 from 7114 because it's OK 6888 
Remove Q56084 from 15110 because it's OK 7304 
Remove Q52797722 from 15107 because it's OK 7309 
Remove Q3895421 from 13203 because it's OK 12330 
Remove Q3862288 from 14572 because it's OK 15011 
Remove Q23636 from 14364 because it's OK 15128 
Remove Q3763912 from 10238 because it's OK 6703 
Remove Q1551179 from 9465 because it's OK 7962 
Remove Q3867564 from 8074 because it's OK 8076 
Remove Q3867611 from 6552 because it's OK 8084 
Remove Q20008344 from 15345 because it's OK 8788 
Remove Q49537787 from 15847 because it's OK 12193 
Remove Q67375491 from 12813 because it's OK 12662 
Remove Q269476 from 14473 because it's OK 14400 
Remove Q1062079 from 8781 because it's OK 6454 
Remove Q1054755 from 15798 because it's OK 6952 
Remove Q55354232 from 10057 because it's OK 7972 
Remove Q1954221 from 13690 because it's OK 8154 
Remove Q3618782 from 8211 because it's OK 8210 
Remove Q3852977 from 15850 because it's OK 12205 
Remove Q20144 from 14888 because it's OK 14269 
Remove Q1787397 from 14600 because it's OK 7288 
Remove Q207161 from 14366 because it's OK 7295 
Remove Q55673199 from 8042 because it's OK 8043 
Remove Q19833 from 15759 because it's OK 14215 
Remove Q30024653 from 14645 because it's OK 14232 
Remove Q35036 from 14995 because it's OK 14321 
Remove Q3868188 from 9055 because it's OK 6479 
Remove Q67014843 from 15903 because it's OK 6822 
Remove Q56080 from 15108 because it's OK 7300 
Remove Q59271 from 15109 because it's OK 7302 
Remove Q272777 from 7211 because it's OK 7809 
Remove Q19545320 from 15815 because it's OK 15915 
Remove Q3662684 from 9850 because it's OK 16107 
Remove Q69321138 from 6567 because it's OK 6488 
Remove Q3757702 from 15767 because it's OK 6947 
Remove Q15602246 from 13476 because it's OK 7219 
Remove Q3661559 from 10545 because it's OK 10546 
Remove Q67375630 from 10811 because it's OK 10849 
Remove Q14943279 from 12890 because it's OK 12211 
Remove Q23285 from 14698 because it's OK 14287 
Remove Q3833022 from 14490 because it's OK 15008 
Remove Q55354006 from 7879 because it's OK 7880 
Remove Q68664914 from 11548 because it's OK 11547 
Remove Q3867567 from 15922 because it's OK 14769 
Remove Q3674029 from 8907 because it's OK 15056 
Remove Q3662864 from 9900 because it's OK 16111 
Remove Q3623078 from 8782 because it's OK 6457 
Remove Q2052064 from 13238 because it's OK 6991 
Remove Q25409844 from 15978 because it's OK 8305 
Remove Q50147 from 14877 because it's OK 15140 
Remove Q207185 from 15104 because it's OK 7296 
Remove Q71249877 from 7143 because it's OK 11879 
Remove Q4011905 from 6977 because it's OK 6525 
Remove Q4011905 from 6985 because it's OK 6525 
Remove Q3867950 from 8251 because it's OK 8185 
Remove Q68664084 from 8614 because it's OK 8601 
Remove Q3672295 from 13785 because it's OK 8785 
Remove Q67375422 from 10370 because it's OK 10371 
Remove Q3072384 from 14579 because it's OK 15005 
Remove Q30027754 from 7297 because it's OK 15105 
Remove Q71253577 from 11065 because it's OK 11064 
Remove Q3895658 from 13219 because it's OK 15857 
Remove Q28001134 from 7041 because it's OK 6521 
Remove Q28001134 from 7065 because it's OK 6521 
Remove Q55371816 from 9087 because it's OK 6831 
Remove Q3895382 from 15901 because it's OK 12182 
Remove Q3889607 from 6493 because it's OK 13775 
Remove Q3889607 from 14759 because it's OK 13775 
Remove Q227641 from 14503 because it's OK 15016 
Remove Q206927 from 14331 because it's OK 7291 
Remove Q67381687 from 8588 because it's OK 10884 
Remove Q3934723 from 11336 because it's OK 11337 
Remove Q3934723 from 11345 because it's OK 11337 
Remove Q201902 from 6453 because it's OK 12170 
Remove Q20559 from 14886 because it's OK 14959 
Remove Q55375101 from 9396 because it's OK 12809 
Remove Q269831 from 14475 because it's OK 14970 
Remove Q3361341 from 10123 because it's OK 10021 
Remove Q3890561 from 14766 because it's OK 12061 
Remove Q1787362 from 13211 because it's OK 7284 
Remove Q70855509 from 6559 because it's OK 6710 
Remove Q30022003 from 14601 because it's OK 14240 
Remove Q22536 from 14680 because it's OK 14393 
Remove Q30031546 from 14677 because it's OK 14978 
Remove Q3976010 from 16219 because it's OK 11085 
Remove Q271264 from 14510 because it's OK 14965 
Remove Q776666 from 8811 because it's OK 15042 
Remove Q66054836 from 12192 because it's OK 11976 
Remove Q1775124 from 14852 because it's OK 6640 
Remove Q94980 from 7308 because it's OK 14850 
Remove Q49538469 from 15860 because it's OK 12147 
Remove Q3867939 from 8828 because it's OK 14807 
Remove Q53112383 from 15764 because it's OK 6885 
Remove Q3867374 from 12732 because it's OK 11995 
Remove Q1280 from 15996 because it's OK 6603 
Remove Q3908055 from 12169 because it's OK 15388 
Remove Q1787344 from 14700 because it's OK 7287 
Remove Q610004 from 12370 because it's OK 12734
setareh.pedone updated the task description. (Show Details)Dec 19 2019, 17:01
valerio.bozzolan edited projects, added Restricted Project; removed Restricted Project.Jan 9 2020, 11:32
valerio.bozzolan moved this task from Restricted Project Column to Restricted Project Column on the Restricted Project board.
valerio.bozzolan added a comment.EditedJan 13 2020, 19:03

Here the situation updated:

https://gitpull.it/T74#1367

valerio.bozzolan updated the task description. (Show Details)

I will process all the Check unexisting etc.

valerio.bozzolan moved this task from Restricted Project Column to Restricted Project Column on the Restricted Project board.Mar 19 2020, 15:30
valerio.bozzolan triaged this task as Low priority.May 1 2020, 18:32
valerio.bozzolan moved this task from Restricted Project Column to Restricted Project Column on the Restricted Project board.Thu, Jul 16, 07:35