[Wiki Loves Monuments] Minor API improvement

[Arthur Richards]

>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.

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 at hotmail.com>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 at 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 at lists.wikimedia.org
>> https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
>> http://www.wikilovesmonuments.org
>>
>>
>
> _______________________________________________
> Wiki Loves Monuments mailing list
> WikiLovesMonuments at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.wikimedia.org/mailman/private/wikilovesmonuments/attachments/20120907/6e4d6eea/attachment.html>