[Wiki Loves Monuments] Tool for images based on Monument ID
Naveen Francis
naveenpf at wikimedia.in
Thu Sep 29 11:17:19 UTC 2016
Hi Jean,
For India, it is showing zero now also.
And this is also showing zero images
https://en.wikipedia.org/wiki/Wikipedia:WikiProject_India/
Wiki_Loves_Monuments/Unused_ASI_Monuments_images
Thanks,
naveenpf
On Thu, Sep 29, 2016 at 4:36 PM, Jean-Frédéric <jeanfrederic.wiki at gmail.com>
wrote:
> 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 at lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
> http://www.wikilovesmonuments.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.wikimedia.org/pipermail/wikilovesmonuments/attachments/20160929/02556474/attachment-0001.html>
More information about the WikiLovesMonuments
mailing list