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

_______________________________________________
Wiki Loves Monuments mailing list
WikiLovesMonuments@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
http://www.wikilovesmonuments.org