https://bugzilla.wikimedia.org/show_bug.cgi?id=38695
Arthur Richards <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #2 from Arthur Richards <[email protected]> 2012-09-07 17:29:53 UTC --- From a quick search through the monument database, there appear to be ~165k monuments with no name: mysql> select count(*) from monuments_all where name=''; +----------+ | count(*) | +----------+ | 164796 | +----------+ This affects 18 different countries: mysql> select distinct country from monuments_all where name=''; +------------+ | country | +------------+ | at | | be-bru | | be-wal | | de-by | | de-he | | de-nrw | | de-nrw-bm | | es | | in | | lu | | mt | | mx | | nl | | no | | ro | | se-fornmin | | sk | | ua | +------------+ All but one of those monuments has data in the 'field': mysql> select count(*) from monuments_all where name='' and source=''; +----------+ | count(*) | +----------+ | 1 | +----------+ If it's too difficult to otherwise determine a name for the monument, perhaps the data could be updated to construct a name based off of the 'title' field in the source, perhaps with an incremented digit appended to it. For instance: http://de.wikipedia.org/w/index.php?title=Liste_der_denkmalgeschützten_Objekte_in_Sedliská&redirect=no&useskin=monobook&oldid=105722097 could become: Liste der denkmalgeschützten Objekte in Sedliská - 01 Or something like that. Rather than hack something into the android app for this, I recommend that this happen in the database itself. That way everyone using the app, including older versions of the app, would be able to see the updated monuments. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
