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_Obje…
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(a)hotmail.com>wrote;wrote:
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(a)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(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
http://www.wikilovesmonuments.org
_______________________________________________
Wiki Loves Monuments mailing list
WikiLovesMonuments(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
http://www.wikilovesmonuments.org
--
Arthur Richards
Software Engineer, Mobile
[[User:Awjrichards]]
IRC: awjr
+1-415-839-6885 x6687