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