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 ([email protected]) օգտատերը գրել է․ > 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 <[email protected]> > 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 <[email protected]> >> *Enviado:* terça-feira, 4 de outubro de 2022 14:31 >> *Para:* [email protected] < >> [email protected]> >> *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 >> [email protected] >> http://www.wikilovesmonuments.org >> > _______________________________________________ > Wiki Loves Monuments mailing list > To unsubscribe send an email to > [email protected] > http://www.wikilovesmonuments.org
_______________________________________________ Wiki Loves Monuments mailing list To unsubscribe send an email to [email protected] http://www.wikilovesmonuments.org
