>From a quick search through the monument database, there appear to be ~165k monuments with no name:<div><div><br></div><div>mysql&gt; select count(*) from monuments_all where name=&#39;&#39;;</div><div>+----------+</div><div>
| count(*) |</div><div>+----------+</div><div>|   164796 |</div><div>+----------+</div><div><br></div><div>This affects 18 different countries:</div><div><br></div><div><div>mysql&gt; select distinct country from monuments_all where name=&#39;&#39;;</div>
<div>+------------+</div><div>| country    |</div><div>+------------+</div><div>| at         |</div><div>| be-bru     |</div><div>| be-wal     |</div><div>| de-by      |</div><div>| de-he      |</div><div>| de-nrw     |</div>
<div>| de-nrw-bm  |</div><div>| es         |</div><div>| in         |</div><div>| lu         |</div><div>| mt         |</div><div>| mx         |</div><div>| nl         |</div><div>| no         |</div><div>| ro         |</div>
<div>| se-fornmin |</div><div>| sk         |</div><div>| ua         |</div></div><div>+------------+</div><div><br></div><div>All but one of those monuments has data in the &#39;field&#39;:</div><div><div>mysql&gt; select count(*) from monuments_all where name=&#39;&#39; and source=&#39;&#39;;</div>
<div>+----------+</div><div>| count(*) |</div><div>+----------+</div><div>|        1 |</div><div>+----------+</div></div><div><br></div><div>If it&#39;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 &#39;title&#39; field in the source, perhaps with an incremented digit appended to it. For instance:</div>
<div><a href="http://de.wikipedia.org/w/index.php?title=Liste_der_denkmalgesch%C3%BCtzten_Objekte_in_Sedlisk%C3%A1&amp;redirect=no&amp;useskin=monobook&amp;oldid=105722097">http://de.wikipedia.org/w/index.php?title=Liste_der_denkmalgeschützten_Objekte_in_Sedliská&amp;redirect=no&amp;useskin=monobook&amp;oldid=105722097</a></div>
<div>could become:</div><div>Liste der denkmalgeschützten Objekte in Sedliská - 01</div><div><br></div><div>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.</div>
<div><br></div><div>I&#39;ve added this detail and recommendation to the open bug <a href="https://bugzilla.wikimedia.org/show_bug.cgi?id=38695">https://bugzilla.wikimedia.org/show_bug.cgi?id=38695</a>.</div><div><br></div>
<div>Arthur</div><div><br></div><div class="gmail_quote">On Fri, Sep 7, 2012 at 7:20 AM, André Costa <span dir="ltr">&lt;<a href="mailto:lokal_profil@hotmail.com" target="_blank">lokal_profil@hotmail.com</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">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&#39;t happen now.<br>
<br>I&#39;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&#39;t have a name parameter.<br>

<br>Hopefully,<br>Andre /Lokal_Profil<div class="im HOEnZb"><br><br>On 3 September 2012 23:27, Platonides <span dir="ltr">&lt;<a href="mailto:platonides@gmail.com" target="_blank">platonides@gmail.com</a>&gt;</span> wrote:<br>
</div><div class="HOEnZb"><div class="h5"><div class="gmail_quote">
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div>On 04/09/12 00:19, André Costa wrote:<br>
&gt; Related to this. Is there a way of matching the &quot;name&quot; entry in the<br>
&gt; database to a combination of list parameters?<br>
&gt;<br>
&gt; To be specific in the case of se-fornmin having<br>
&gt;   name = {{{namn|}}} ({{{raä-nr|}}}, {{{typ|}}})<br>
&gt; rather than just the current<br>
&gt;   name = {{{namn|}}}<br>
&gt;<br>
&gt; The problem is that only 7% of the entries in se-fornmin have a<br>
&gt; {{{namn|}}} parameter. The result in the Android app is empty rows in<br>
&gt; the list view and empty &quot;ballons&quot; in the map view.<br>
&gt;<br>
&gt; Cheers,<br>
&gt; Andre / Lokal_Profil<br>
<br>
</div>Yes. The entry in fill_monuments would roughly look like this:<br>
CONCAT(namn, &#39; (&#39;, `raä-nr`, &#39;, &#39;, typ, &#39;)&#39; ) AS name,<br>
<div><div><br>
_______________________________________________<br>
Wiki Loves Monuments mailing list<br>
<a href="mailto:WikiLovesMonuments@lists.wikimedia.org" target="_blank">WikiLovesMonuments@lists.wikimedia.org</a><br>
<a href="https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments" target="_blank">https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments</a><br>
<a href="http://www.wikilovesmonuments.org" target="_blank">http://www.wikilovesmonuments.org</a><br>
<br>
</div></div></blockquote></div><br>
</div></div><br>_______________________________________________<br>
Wiki Loves Monuments mailing list<br>
<a href="mailto:WikiLovesMonuments@lists.wikimedia.org">WikiLovesMonuments@lists.wikimedia.org</a><br>
<a href="https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments" target="_blank">https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments</a><br>
<a href="http://www.wikilovesmonuments.org" target="_blank">http://www.wikilovesmonuments.org</a><br></blockquote></div><br><br clear="all"><div><br></div>-- <br>Arthur Richards<div>Software Engineer, Mobile</div><div>[[User:Awjrichards]]</div>
<div>IRC: awjr</div><div>+1-415-839-6885 x6687</div><br>
</div>