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%C3%BCtzten_... 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.
I've added this detail and recommendation to the open bug https://bugzilla.wikimedia.org/show_bug.cgi?id=38695.
Arthur
On Fri, Sep 7, 2012 at 7:20 AM, André Costa lokal_profil@hotmail.comwrote:
Not wanting to be that guy, but would it be possible to actually get the name parameter change implemented. Or at least be told if there is a reason why this will not happen/can't happen now.
I've attached two images of the Android app in action which illustrates the problem that this is currently causing us. This is what the was majority of lists/maps look like since the few named entries are swamped by the ~90% which don't have a name parameter.
Hopefully, Andre /Lokal_Profil
On 3 September 2012 23:27, Platonides platonides@gmail.com wrote:
On 04/09/12 00:19, André Costa wrote:
Related to this. Is there a way of matching the "name" entry in the database to a combination of list parameters?
To be specific in the case of se-fornmin having name = {{{namn|}}} ({{{raä-nr|}}}, {{{typ|}}}) rather than just the current name = {{{namn|}}}
The problem is that only 7% of the entries in se-fornmin have a {{{namn|}}} parameter. The result in the Android app is empty rows in the list view and empty "ballons" in the map view.
Cheers, Andre / Lokal_Profil
Yes. The entry in fill_monuments would roughly look like this: CONCAT(namn, ' (', `raä-nr`, ', ', typ, ')' ) AS name,
Wiki Loves Monuments mailing list WikiLovesMonuments@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org
Wiki Loves Monuments mailing list WikiLovesMonuments@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org