Hi all,
We're holding WLM in Armenia and we wanted to get list of monuments with no photos uploaded to Commons. We have lists on wikis as table, and I thought of using Images linking to [[Template:Cultural Heritage Armenia]] as an indicator of monument having photos. Issue is I'll need to look into wikitext of 140000 images pages uploaded in the past, parse out monument IDs and then compare it to a full list of monuments.
Before spraying some WD40 over my rusted MediaWiki API kungfu, I wanted to check if anyone has done something like that/knows tools for this, so I don't reinvent the wheel.
Would appreciate your thoughts on this.
Best, Aleksey
I have done something similar recently, in a smaller scale (11K images). I used OpenRefine (here a workshop tutorial https://commons.wikimedia.org/wiki/File:Wikidata_Lab_XXXIV_-_OpenRefine_and_...) to obtain the wikitext and extract the QIDs from the template we use to track the monuments depicted in WLM Brazil.
Cheers, Éder Porto
________________________________ De: Aleksey Chalabyan xelgen.am@gmail.com Enviado: terça-feira, 4 de outubro de 2022 14:31 Para: wikilovesmonuments@lists.wikimedia.org wikilovesmonuments@lists.wikimedia.org Assunto: [Wiki Loves Monuments] Getting list of monuments with no images on Commons?
Hi all,
We're holding WLM in Armenia and we wanted to get list of monuments with no photos uploaded to Commons. We have lists on wikis as table, and I thought of using Images linking to [[Template:Cultural Heritage Armenia]] as an indicator of monument having photos. Issue is I'll need to look into wikitext of 140000 images pages uploaded in the past, parse out monument IDs and then compare it to a full list of monuments.
Before spraying some WD40 over my rusted MediaWiki API kungfu, I wanted to check if anyone has done something like that/knows tools for this, so I don't reinvent the wheel.
Would appreciate your thoughts on this.
Best, Aleksey
Hi,
In this particular case it uses template like this
{{Cultural Heritage Armenia|1.1/10}}
And template generates this category
[[Category:Cultural heritage monuments in Armenia with known IDs|
001.1/10]]
And these can be queried using SQL - https://quarry.wmcloud.org/query/67899# (here you can download images with template + template ids as CSV)
Անուշ_և_Սարո.JPG 001.1/10
...
Br, -- Kimmo Virtanen / Zache
On Tue, Oct 4, 2022 at 9:28 PM Éder Porto F Alves eder.porto@hotmail.com wrote:
I have done something similar recently, in a smaller scale (11K images). I used OpenRefine (here a workshop tutorial https://commons.wikimedia.org/wiki/File:Wikidata_Lab_XXXIV_-_OpenRefine_and_...) to obtain the wikitext and extract the QIDs from the template we use to track the monuments depicted in WLM Brazil.
Cheers, Éder Porto
*De:* Aleksey Chalabyan xelgen.am@gmail.com *Enviado:* terça-feira, 4 de outubro de 2022 14:31 *Para:* wikilovesmonuments@lists.wikimedia.org < wikilovesmonuments@lists.wikimedia.org> *Assunto:* [Wiki Loves Monuments] Getting list of monuments with no images on Commons?
Hi all,
We're holding WLM in Armenia and we wanted to get list of monuments with no photos uploaded to Commons. We have lists on wikis as table, and I thought of using Images linking to [[Template:Cultural Heritage Armenia]] as an indicator of monument having photos. Issue is I'll need to look into wikitext of 140000 images pages uploaded in the past, parse out monument IDs and then compare it to a full list of monuments.
Before spraying some WD40 over my rusted MediaWiki API kungfu, I wanted to check if anyone has done something like that/knows tools for this, so I don't reinvent the wheel.
Would appreciate your thoughts on this.
Best, Aleksey _______________________________________________ Wiki Loves Monuments mailing list To unsubscribe send an email to wikilovesmonuments-leave@lists.wikimedia.org http://www.wikilovesmonuments.org
Oh, thanks a ton, you've helped a lot, Kimmo! Didn't realize categories still contain IDs, and something can be fetched out of them.
Kiitos paljon!
Best, Aleksey
2022 թ. հոկ 4, երք, 22:44 Kimmo Virtanen (kimmo.virtanen@gmail.com) օգտատերը գրել է․
Hi,
In this particular case it uses template like this
{{Cultural Heritage Armenia|1.1/10}}
And template generates this category
[[Category:Cultural heritage monuments in Armenia with known IDs|
001.1/10]]
And these can be queried using SQL
- https://quarry.wmcloud.org/query/67899# (here you can download
images with template + template ids as CSV)
Անուշ_և_Սարո.JPG 001.1/10
...
Br, -- Kimmo Virtanen / Zache
On Tue, Oct 4, 2022 at 9:28 PM Éder Porto F Alves eder.porto@hotmail.com wrote:
I have done something similar recently, in a smaller scale (11K images). I used OpenRefine (here a workshop tutorial https://commons.wikimedia.org/wiki/File:Wikidata_Lab_XXXIV_-_OpenRefine_and_...) to obtain the wikitext and extract the QIDs from the template we use to track the monuments depicted in WLM Brazil.
Cheers, Éder Porto
*De:* Aleksey Chalabyan xelgen.am@gmail.com *Enviado:* terça-feira, 4 de outubro de 2022 14:31 *Para:* wikilovesmonuments@lists.wikimedia.org < wikilovesmonuments@lists.wikimedia.org> *Assunto:* [Wiki Loves Monuments] Getting list of monuments with no images on Commons?
Hi all,
We're holding WLM in Armenia and we wanted to get list of monuments with no photos uploaded to Commons. We have lists on wikis as table, and I thought of using Images linking to [[Template:Cultural Heritage Armenia]] as an indicator of monument having photos. Issue is I'll need to look into wikitext of 140000 images pages uploaded in the past, parse out monument IDs and then compare it to a full list of monuments.
Before spraying some WD40 over my rusted MediaWiki API kungfu, I wanted to check if anyone has done something like that/knows tools for this, so I don't reinvent the wheel.
Would appreciate your thoughts on this.
Best, Aleksey _______________________________________________ Wiki Loves Monuments mailing list To unsubscribe send an email to wikilovesmonuments-leave@lists.wikimedia.org http://www.wikilovesmonuments.org
Wiki Loves Monuments mailing list To unsubscribe send an email to wikilovesmonuments-leave@lists.wikimedia.org http://www.wikilovesmonuments.org
wikilovesmonuments@lists.wikimedia.org