I see numerous points that on the map show "2" but zoomed in only show "1". Switching to list view confirms that their are duplicates.
Version: unspecified
Severity: normal
I see numerous points that on the map show "2" but zoomed in only show "1". Switching to list view confirms that their are duplicates.
Version: unspecified
Severity: normal
Status | Subtype | Assigned | Task | ||
---|---|---|---|---|---|
Resolved | None | T40648 Wiki Loves Monuments 2012 (tracking) | |||
Resolved | None | T39577 Tracking bug for 1.0beta1 release of WLM app | |||
Resolved | Multichill | T40645 WLM app shows duplicate listings when browsing through Map View |
Do you have examples where this happened? This might be caused by having listings in multiple languages. See https://commons.wikimedia.org/wiki/Commons:Monuments_database/Statistics to see what countries have multiple languages.
The api seems to be sending duplicates:
Look at the result of this for example:
There are 2 with
name="[[Liberty Street Historic District (San Francisco, California)|Liberty Street Historic District]]"
and 2 with
name="[[John McMullen House|John McMullen House]]"
These monuments are listed as both country=us and country=us-ca, something wrong with erfgoedbot.
Ah, found my mistake. It was supposed to take the data from https://en.wikipedia.org/wiki/Special:WhatLinksHere/Template:CHL_row and put it in the monuments_us-ca_(en) table. That goes right, but it looks like I forgot a -ca in the import so the wrong table is being imported. Fixed in https://fisheye.toolserver.org/browse/erfgoed/erfgoedbot/sql/fill_table_monuments_all.sql?r1=769&r2=774
I issued "mysql> delete from monuments_all WHERE country='us-ca';", that might take some time to complete
mysql> delete from monuments_all WHERE country='us-ca';
Query OK, 86926 rows affected (6 min 26.15 sec)