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_Structured_Data_on_Commons.webm) 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