Hi all,
Is there any tool to know image count based on Monument ID ?
Plus, a tool to know user who has covered maximum no of monuments ?
Thanks, Naveen Francis http://wikibooks.in
Hi, 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.
Ilya
On Thu, Sep 29, 2016 at 9:10 AM, Naveen Francis naveenpf@wikimedia.in wrote:
Hi all,
Is there any tool to know image count based on Monument ID ?
Plus, a tool to know user who has covered maximum no of monuments ?
Thanks, Naveen Francis http://wikibooks.in
Wiki Loves Monuments mailing list WikiLovesMonuments@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org
Hi llya,
https://commons.wikimedia.org/wiki/Commons:Monuments_database/Indexed_images
For India, it is showing zero. Is there anything wrong ?
-- naveenpf
Thanks, Naveen Francis http://wikibooks.in
On Thu, Sep 29, 2016 at 11:48 AM, Ilya Korniyko intracer@gmail.com wrote:
Hi, 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.
Ilya
On Thu, Sep 29, 2016 at 9:10 AM, Naveen Francis naveenpf@wikimedia.in wrote:
Hi all,
Is there any tool to know image count based on Monument ID ?
Plus, a tool to know user who has covered maximum no of monuments ?
Thanks, Naveen Francis http://wikibooks.in
Wiki Loves Monuments mailing list WikiLovesMonuments@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org
Wiki Loves Monuments mailing list WikiLovesMonuments@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org
On 29.09.2016 08:56, Naveen Francis wrote:
Hi llya,
https://commons.wikimedia.org/wiki/Commons:Monuments_database/Indexed_images
For India, it is showing zero. Is there anything wrong ?
-- naveenpf
Thanks, Naveen Francis [1]
The category was a redirect (which obviously contains zero images), and I have now corrected it, but the page was not updated since June anyway.
Cheers Yaroslav
I guess that if someone could make a csv with all uploads and their identifiers - these statistics could quite easily be extracted.
Best, Lodewijk
2016-09-29 9:14 GMT+02:00 Yaroslav M. Blanter putevod@mccme.ru:
On 29.09.2016 08:56, Naveen Francis wrote:
Hi llya,
https://commons.wikimedia.org/wiki/Commons:Monuments_databas e/Indexed_images
For India, it is showing zero. Is there anything wrong ?
-- naveenpf
Thanks, Naveen Francis [1]
The category was a redirect (which obviously contains zero images), and I have now corrected it, but the page was not updated since June anyway.
Cheers Yaroslav
Wiki Loves Monuments mailing list WikiLovesMonuments@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org
https://commons.wikimedia.org/wiki/Commons:Monuments_databas e/Indexed_images
For India, it is showing zero. Is there anything wrong ?
The category was a redirect (which obviously contains zero images), and I have now corrected it, but the page was not updated since June anyway.
Was not aware that folks were still relying on that one. I manualyl ran the update job and will reenable the regular job.
For Wiki Loves Earth Biosphere Reserves Romaine set up the Wikidata item numbers as the ID numbers, I feel like this may be helpful but not sure how
On 29 September 2016 at 12:50, Jean-Frédéric jeanfrederic.wiki@gmail.com wrote:
https://commons.wikimedia.org/wiki/Commons:Monuments_databas e/Indexed_images
For India, it is showing zero. Is there anything wrong ?
The category was a redirect (which obviously contains zero images), and I have now corrected it, but the page was not updated since June anyway.
Was not aware that folks were still relying on that one. I manualyl ran the update job and will reenable the regular job.
Wiki Loves Monuments mailing list WikiLovesMonuments@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org
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)
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@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@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org
2016-09-29 12:17 GMT+01:00 Naveen Francis naveenpf@wikimedia.in:
Hi Jean,
For India, it is showing zero now also.
Right, because as Yaroslav said, the category was renamed at some point. I submitted a patch for this https://gerrit.wikimedia.org/r/#/c/313388/
wikilovesmonuments@lists.wikimedia.org