[Wiki Loves Monuments] Tool for images based on Monument ID

[Jean-Frédéric]

>
> Is there any tool to know image count based on Monument ID ?
>

So, now that the job has run, there is an up-to-date  `image` table on the
monuments database, indexing 2 575 525 images.

A database query for what your need is straightforward − see that example
for Georgia [1] − but that does not quite scale nor is easily accessible.

Should be fairly easy to build a tool on top of it though.


> Plus, a tool to know user who has covered maximum no of monuments ?
>

I don’t think this exists at the moment (yet! :)


there is my tool, but it knows only Ukraine's monument lists.
> I'm going to adapt it to erfgoed/heritage database first week of October.
>

Thanks Ilya ! Looking forward to  it :)


[1]  Top 10 illustrated monuments in Georgia:
MariaDB [s51138__heritage_p]> SELECT id, COUNT(img_name) as pics FROM image
WHERE country='ge' GROUP BY id ORDER BY pics DESC LIMIT 10;
+------+------+
| id   | pics |
+------+------+
| 4667 |  188 |
| 4657 |  143 |
| 2343 |  124 |
| 3678 |  122 |
| 6490 |  119 |
| 3244 |  100 |
| 1953 |  100 |
| 4842 |   94 |
| 4668 |   93 |
| 875  |   76 |
+------+------+
10 rows in set (0.06 sec)

-- 
Jean-Frédéric
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.wikimedia.org/pipermail/wikilovesmonuments/attachments/20160929/e6287236/attachment.html>