Log P18 edits after direct Nearby uploads implemented

[misaochan]

After #252 is implemented, we will need to log the Wikidata P18 edits made via our app, for collecting metrics (number of edits made), as well as to confirm that we are doing it correctly.

How and where shall these logs be made?

[maskaravivek]

Now that we already have a PR open for making P18 edits(#1495), any ideas on where the logs should be collected?

@nicolas-raoul @misaochan

[misaochan]

Unfortunately I am not sure either. :/ @nicolas-raoul @whym @VojtechDostal @tobias47n9e We would greatly appreciate thoughts on this if possible :)

[VojtechDostal]

Is it possible to automatize edits to wiki pages such as on Wikimedia Commons, eg. https://commons.wikimedia.org/wiki/Commons:Mobile_app/Logs ?

[maskaravivek]

I guess editing a page through the app should be possible. I can check and confirm the feasibility.

What information should be logged if we are able to make edits to this page?

[misaochan]

I would go wth username, wikidata item edited, file title, time that the edit was made. Anything else that anyone would like to add?

Oh, and having a counter that increments for each edit logged would be very helpful for our final report. :)

[maskaravivek]

If maintaining the logs on a commons page sounds good to everyone, I will go ahead and make the changes.

[misaochan]

Sounds good to me. I created the page that Vojtech suggested, we can use that for now.

[nicolas-raoul]

We already apply a "tag" called "mobile app edit" to some of our edits (when uploading or editing an image, as seen in the first two edits here).
Adding the same "tag" to our Wikidata edits would be the most appropriate thing to do, I would say.
Fortunately, the same tag already exists on Wikidata: https://www.wikidata.org/wiki/Special:Tags

Update: Now I realize that there are already 170,764 mobile app edits on Wikidata. So we might want to ask for a tag that only our app would use.

[VojtechDostal]

Tagging edits in Wikidata seems like a very good idea, @nicolas-raoul . It will provide a very important additional metric.

I'm in favour of scrapping the log page on Commons entirely if we are able to use edit tags to measure number of images remaining on Wikidata - and create a list of those images - using the edit tags. However it may be very complicated to deduce (count) this metric with just the edit tag, won't it? Is it possible to list all images (with their file names) added with an edit with a given edit tag?

[nicolas-raoul]

@VojtechDostal Yes, here is the list of recent changes with the "mobile app edit" tag on Wikidata: https://www.wikidata.org/w/index.php?hidebots=1&translations=filter&hidecategorization=1&hideWikibase=1&tagfilter=mobile+app+edit&limit=500&days=30&title=Special:RecentChanges&urlversion=2

[VojtechDostal]

Yes, but will you be able to export it as a list of files added via our app? (Even though some will be later removed, but we still want to count them)?

[misaochan]

How do we go about getting our own Wikidata tag?

[maskaravivek]

I have created a phab task hoping that someone replies about how to get our own Wikidata tag.

https://phabricator.wikimedia.org/T195960

[maskaravivek]

As pointed out in the phabricator discussion, it should be trivial to add the tags by making another API call just after a successful edit is made.

Moreover, I have requested the Wikidata Administrators to create a new tag for us. :)

https://www.wikidata.org/wiki/Wikidata:Administrators%27_noticeboard#Request_for_creating_a_new_tag_for_edits_made_by_Wikimedia_Commons_Android_app

[maskaravivek]

Yay! We have our own tag(wikimedia-commons-app) created for Wikidata edits. Can someone thank the admin in the above thread, I am not sure how to post a reply. :(

[maskaravivek]

I get the following error while adding the wikimedia-commons-app tag using logged in user's token. Does this API require any special permission?

{
    "error": {
        "code": "tags-apply-not-allowed-one",
        "info": "The tag \"'wikimedia-commons-app'\" is not allowed to be manually applied.",
        "*": "See https://www.wikidata.org/w/api.php for API usage. Subscribe to the mediawiki-api-announce mailing list at <https://lists.wikimedia.org/mailman/listinfo/mediawiki-api-announce> for notice of API deprecations and breaking changes."
    },
    "servedby": "mw1221"
}

The same API works for me in the sandbox.
https://www.wikidata.org/wiki/Special:ApiSandbox#action=tag&format=xml&revid=689454815&add=wikimedia-commons-app&token=2b9cbcfd21ea10b557a579a865be9a025b138621%2B%5C

[maskaravivek]

@VojtechDostal @nicolas-raoul Once the logs are in place, this query can be used to track the edits made using the Commons app.

https://www.wikidata.org/w/index.php?hidebots=1&translations=filter&hidecategorization=1&tagfilter=wikimedia-commons-app&limit=500&days=30&hideWikibase=1&title=Special:RecentChanges&urlversion=2

[nicolas-raoul]

@maskaravivek Thanks! I added the URL to the list of things to patrol, at https://commons.wikimedia.org/wiki/Commons:Mobile_app :-)

[misaochan]

Implemented! :)

[misaochan]

I'm having a problem with the log page - it seems that it restricts the logs to the past 30 days. There is no option to choose a larger number of days, and even manually setting the param in the URL defaults to 30.

Am I missing something? @nicolas-raoul

[VojtechDostal]

@urbanecm wrote the following Quarry for us:
https://quarry.wmflabs.org/query/29196

That should work always, not just for the last 30 days

[misaochan]

Woohoo! Thanks @VojtechDostal and @urbanecm . :)

[misaochan]

Thank you! Works now, we have 725 p18 edits! :)

[misaochan]

@urbanecm Hmm, there is another issue - it looks like edits to the same page title count multiple times, for instance Q32110705 is present in 2 rows, so we can't just use the number of rows as our metric. Do you know if it's possible to only count the unique page titles?

[nicolas-raoul]

@misaochan With unique page titles: https://quarry.wmflabs.org/query/37568

[urbanecm]

@misaochan Seems you have what you wanted? :-)

[misaochan]

Woo, thanks guys! :)

[VojtechDostal]

Also we seem to have edits from all continents except Antarctis :)

https://query.wikidata.org/embed.html#%23defaultView%3AMap%0Aselect%20%3Fitem%20%3FitemLabel%20%3Fcoord%20where%20%7B%0A%0A%3Fitem%20wdt%3AP625%20%3Fcoord%20.%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%0Avalues%20%3Fitem%20%7B%0A%0Awd%3AQ56648964%0Awd%3AQ56635898%0Awd%3AQ4115189%0Awd%3AQ64616163%0Awd%3AQ64616161%0Awd%3AQ64568125%0Awd%3AQ56606283%0Awd%3AQ56606282%0Awd%3AQ56606284%0Awd%3AQ56606281%0Awd%3AQ56635884%0Awd%3AQ12255004%0Awd%3AQ35425846%0Awd%3AQ61708300%0Awd%3AQ21040643%0Awd%3AQ56635757%0Awd%3AQ65100205%0Awd%3AQ3268905%0Awd%3AQ56635760%0Awd%3AQ33243690%0Awd%3AQ56635823%0Awd%3AQ56635821%0Awd%3AQ56635799%0Awd%3AQ7267870%0Awd%3AQ3354574%0Awd%3AQ37429619%0Awd%3AQ64816155%0Awd%3AQ64815714%0Awd%3AQ64815715%0Awd%3AQ64815719%0Awd%3AQ22978095%0Awd%3AQ64815717%0Awd%3AQ49529358%0Awd%3AQ55461454%0Awd%3AQ22031067%0Awd%3AQ49557123%0Awd%3AQ17809719%0Awd%3AQ17809735%0Awd%3AQ64816260%0Awd%3AQ64816262%0Awd%3AQ64815924%0Awd%3AQ64815960%0Awd%3AQ64815839%0Awd%3AQ4806112%0Awd%3AQ26517765%0Awd%3AQ26557690%0Awd%3AQ56635779%0Awd%3AQ43624864%0Awd%3AQ43472666%0Awd%3AQ38040131%0Awd%3AQ43472335%0Awd%3AQ45295413%0Awd%3AQ43475174%0Awd%3AQ43472019%0Awd%3AQ28855149%0Awd%3AQ33521627%0Awd%3AQ43474627%0Awd%3AQ43473295%0Awd%3AQ21968328%0Awd%3AQ64689020%0Awd%3AQ49481044%0Awd%3AQ23811970%0Awd%3AQ26789413%0Awd%3AQ12041171%0Awd%3AQ45303830%0Awd%3AQ4759462%0Awd%3AQ56635770%0Awd%3AQ56635781%0Awd%3AQ33113496%0Awd%3AQ28075236%0Awd%3AQ1947336%0Awd%3AQ5154865%0Awd%3AQ64142287%0Awd%3AQ1138021%0Awd%3AQ49566332%0Awd%3AQ26788656%0Awd%3AQ26790839%0Awd%3AQ30657602%0Awd%3AQ22905789%0Awd%3AQ957910%0Awd%3AQ3547944%0Awd%3AQ20492559%0Awd%3AQ2832238%0Awd%3AQ21392077%0Awd%3AQ35268035%0Awd%3AQ6975124%0Awd%3AQ6019809%0Awd%3AQ12374678%0Awd%3AQ19276414%0Awd%3AQ4683954%0Awd%3AQ49318679%0Awd%3AQ48761172%0Awd%3AQ64461426%0Awd%3AQ12150126%0Awd%3AQ12158670%0Awd%3AQ12138294%0Awd%3AQ38040110%0Awd%3AQ43474141%0Awd%3AQ43473502%0Awd%3AQ43472995%0Awd%3AQ43473275%0Awd%3AQ45299560%0Awd%3AQ21753153%0Awd%3AQ12138390%0Awd%3AQ12158693%0Awd%3AQ12158665%0Awd%3AQ4871746%0Awd%3AQ43473374%0Awd%3AQ18491753%0Awd%3AQ28832718%0Awd%3AQ5683905%0Awd%3AQ45707549%0Awd%3AQ45707185%0Awd%3AQ45701703%0Awd%3AQ45705589%0Awd%3AQ45705410%0Awd%3AQ45700933%0Awd%3AQ45703754%0Awd%3AQ45704492%0Awd%3AQ45682661%0Awd%3AQ45682452%0Awd%3AQ45683114%0Awd%3AQ45684206%0Awd%3AQ45683001%0Awd%3AQ45682250%0Awd%3AQ45683229%0Awd%3AQ43484229%0Awd%3AQ11065564%0Awd%3AQ12906230%0Awd%3AQ11083120%0Awd%3AQ10895551%0Awd%3AQ32752052%0Awd%3AQ37749402%0Awd%3AQ14016587%0Awd%3AQ14016116%0Awd%3AQ64034609%0Awd%3AQ26224647%0Awd%3AQ45292930%0Awd%3AQ3432745%0Awd%3AQ25230618%0Awd%3AQ12141690%0Awd%3AQ12138334%0Awd%3AQ11949506%0Awd%3AQ12139001%0Awd%3AQ25475902%0Awd%3AQ53867565%0Awd%3AQ21335924%0Awd%3AQ18406368%0Awd%3AQ21336771%0Awd%3AQ37742412%0Awd%3AQ4006355%0Awd%3AQ19836242%0Awd%3AQ31062853%0Awd%3AQ2284919%0Awd%3AQ18019409%0Awd%3AQ26483596%0Awd%3AQ59164607%0Awd%3AQ59164660%0Awd%3AQ26232397%0Awd%3AQ59164687%0Awd%3AQ43484168%0Awd%3AQ45943812%0Awd%3AQ1731378%0Awd%3AQ37749406%0Awd%3AQ31919444%0Awd%3AQ37319288%0Awd%3AQ33316530%0Awd%3AQ33316535%0Awd%3AQ37319274%0Awd%3AQ33316524%0Awd%3AQ37319376%0Awd%3AQ37319407%0Awd%3AQ33316540%0Awd%3AQ37319347%0Awd%3AQ124425%0Awd%3AQ26530678%0Awd%3AQ62070868%0Awd%3AQ62070885%0Awd%3AQ62070987%0Awd%3AQ4236614%0Awd%3AQ26530675%0Awd%3AQ26453246%0Awd%3AQ26530679%0Awd%3AQ26554772%0Awd%3AQ38192374%0Awd%3AQ26514568%0Awd%3AQ26432343%0Awd%3AQ26502113%0Awd%3AQ26579300%0Awd%3AQ26569149%0Awd%3AQ26579326%0Awd%3AQ26502112%0Awd%3AQ26431944%0Awd%3AQ26431941%0Awd%3AQ26599296%0Awd%3AQ26527743%0Awd%3AQ26431865%0Awd%3AQ26431884%0Awd%3AQ26285921%0Awd%3AQ19119896%0Awd%3AQ38096067%0Awd%3AQ49477762%0Awd%3AQ861169%0Awd%3AQ30593499%0Awd%3AQ16516906%0Awd%3AQ16711714%0Awd%3AQ5658665%0Awd%3AQ24021149%0Awd%3AQ2532128%0Awd%3AQ28845865%0Awd%3AQ30188290%0Awd%3AQ2606861%0Awd%3AQ26790397%0Awd%3AQ33225778%0Awd%3AQ61934186%0Awd%3AQ4854838%0Awd%3AQ4841721%0Awd%3AQ7432501%0Awd%3AQ43386686%0Awd%3AQ43388287%0Awd%3AQ974328%0Awd%3AQ49502279%0Awd%3AQ136935%0Awd%3AQ19904974%0Awd%3AQ38036766%0Awd%3AQ23826066%0Awd%3AQ30142814%0Awd%3AQ4309980%0Awd%3AQ16704330%0Awd%3AQ45319928%0Awd%3AQ45320331%0Awd%3AQ30297370%0Awd%3AQ55719938%0Awd%3AQ28705397%0Awd%3AQ24942819%0Awd%3AQ63122307%0Awd%3AQ55174070%0Awd%3AQ56711293%0Awd%3AQ44621545%0Awd%3AQ44621528%0Awd%3AQ44622341%0Awd%3AQ44621488%0Awd%3AQ5093840%0Awd%3AQ45178894%0Awd%3AQ62521201%0Awd%3AQ45179009%0Awd%3AQ58015438%0Awd%3AQ24012159%0Awd%3AQ43396669%0Awd%3AQ63107414%0Awd%3AQ63107413%0Awd%3AQ55674229%0Awd%3AQ43389821%0Awd%3AQ55678558%0Awd%3AQ56887354%0Awd%3AQ11488014%0Awd%3AQ17192810%0Awd%3AQ11554480%0Awd%3AQ11350504%0Awd%3AQ21752805%0Awd%3AQ51952941%0Awd%3AQ1728299%0Awd%3AQ34964236%0Awd%3AQ5653186%0Awd%3AQ58013644%0Awd%3AQ20070618%0Awd%3AQ666987%0Awd%3AQ5597802%0Awd%3AQ4418173%0Awd%3AQ49280690%0Awd%3AQ37754757%0Awd%3AQ57993874%0Awd%3AQ58113229%0Awd%3AQ57952260%0Awd%3AQ57920366%0Awd%3AQ57920372%0Awd%3AQ30297420%0Awd%3AQ26671627%0Awd%3AQ9159242%0Awd%3AQ15912436%0Awd%3AQ2257213%0Awd%3AQ1774606%0Awd%3AQ6815928%0Awd%3AQ7446121%0Awd%3AQ26367801%0Awd%3AQ26586222%0Awd%3AQ1840355%0Awd%3AQ45320164%0Awd%3AQ5313979%0Awd%3AQ41429587%0Awd%3AQ7832538%0Awd%3AQ16965579%0Awd%3AQ5589116%0Awd%3AQ49355571%0Awd%3AQ4883700%0Awd%3AQ50040239%0Awd%3AQ30266375%0Awd%3AQ62029384%0Awd%3AQ11433343%0Awd%3AQ20971064%0Awd%3AQ2989202%0Awd%3AQ27991528%0Awd%3AQ26304070%0Awd%3AQ5049542%0Awd%3AQ26627404%0Awd%3AQ5736362%0Awd%3AQ15223697%0Awd%3AQ26315885%0Awd%3AQ45412489%0Awd%3AQ49368857%0Awd%3AQ49353636%0Awd%3AQ22992072%0Awd%3AQ49361320%0Awd%3AQ46021196%0Awd%3AQ11526050%0Awd%3AQ30922223%0Awd%3AQ30927547%0Awd%3AQ49267642%0Awd%3AQ43395796%0Awd%3AQ4778088%0Awd%3AQ56859281%0Awd%3AQ5846800%0Awd%3AQ49582770%0Awd%3AQ12254153%0Awd%3AQ12263176%0Awd%3AQ3452138%0Awd%3AQ56858856%0Awd%3AQ3450020%0Awd%3AQ7494403%0Awd%3AQ20755185%0Awd%3AQ43051788%0Awd%3AQ43052222%0Awd%3AQ7074598%0Awd%3AQ36131544%0Awd%3AQ28404182%0Awd%3AQ55096462%0Awd%3AQ47510848%0Awd%3AQ11508846%0Awd%3AQ62042923%0Awd%3AQ61911677%0Awd%3AQ61911666%0Awd%3AQ61911629%0Awd%3AQ61911621%0Awd%3AQ5350664%0Awd%3AQ3827036%0Awd%3AQ23301852%0Awd%3AQ23301859%0Awd%3AQ20716864%0Awd%3AQ47176975%0Awd%3AQ45971831%0Awd%3AQ45971931%0Awd%3AQ45971761%0Awd%3AQ45971660%0Awd%3AQ43625958%0Awd%3AQ47517244%0Awd%3AQ4237491%0Awd%3AQ61669785%0Awd%3AQ28815123%0Awd%3AQ49348483%0Awd%3AQ6572869%0Awd%3AQ30254277%0Awd%3AQ36861367%0Awd%3AQ46011191%0Awd%3AQ11201209%0Awd%3AQ15887182%0Awd%3AQ45980759%0Awd%3AQ31204514%0Awd%3AQ43394046%0Awd%3AQ28686538%0Awd%3AQ43052046%0Awd%3AQ15848631%0Awd%3AQ3630402%0Awd%3AQ55596579%0Awd%3AQ12074683%0Awd%3AQ4163260%0Awd%3AQ4070686%0Awd%3AQ43584559%0Awd%3AQ12074552%0Awd%3AQ26782402%0Awd%3AQ43051651%0Awd%3AQ43051769%0Awd%3AQ59550890%0Awd%3AQ30310638%0Awd%3AQ43052149%0Awd%3AQ43052145%0Awd%3AQ43387172%0Awd%3AQ43400100%0Awd%3AQ45385743%0Awd%3AQ43389131%0Awd%3AQ43388850%0Awd%3AQ26897382%0Awd%3AQ43397063%0Awd%3AQ25336723%0Awd%3AQ11911402%0Awd%3AQ1418389%0Awd%3AQ15192650%0Awd%3AQ1050885%0Awd%3AQ31309146%0Awd%3AQ45469253%0Awd%3AQ45465709%0Awd%3AQ45466494%0Awd%3AQ7075069%0Awd%3AQ3024268%0Awd%3AQ3001103%0Awd%3AQ7523099%0Awd%3AQ7522943%0Awd%3AQ1987294%0Awd%3AQ20074872%0Awd%3AQ50413670%0Awd%3AQ31062877%0Awd%3AQ4402648%0Awd%3AQ45734006%0Awd%3AQ45465067%0Awd%3AQ22330045%0Awd%3AQ7222409%0Awd%3AQ5942564%0Awd%3AQ30282285%0Awd%3AQ5159007%0Awd%3AQ22042760%0Awd%3AQ17225938%0Awd%3AQ58293521%0Awd%3AQ4693209%0Awd%3AQ49518422%0Awd%3AQ2352920%0Awd%3AQ43099822%0Awd%3AQ13062235%0Awd%3AQ58820434%0Awd%3AQ12142738%0Awd%3AQ47001588%0Awd%3AQ54662040%0Awd%3AQ49332404%0Awd%3AQ5603679%0Awd%3AQ17551208%0Awd%3AQ3652497%0Awd%3AQ26324779%0Awd%3AQ26581164%0Awd%3AQ26644923%0Awd%3AQ26581168%0Awd%3AQ26324782%0Awd%3AQ26503387%0Awd%3AQ26627421%0Awd%3AQ26324785%0Awd%3AQ26547132%0Awd%3AQ26505153%0Awd%3AQ26333133%0Awd%3AQ26505152%0Awd%3AQ26638030%0Awd%3AQ26321003%0Awd%3AQ26500515%0Awd%3AQ26638920%0Awd%3AQ26333130%0Awd%3AQ26333132%0Awd%3AQ7425807%0Awd%3AQ47631151%0Awd%3AQ2557857%0Awd%3AQ44757291%0Awd%3AQ26419109%0Awd%3AQ1708205%0Awd%3AQ38039068%0Awd%3AQ24238251%0Awd%3AQ27442128%0Awd%3AQ26758436%0Awd%3AQ12493824%0Awd%3AQ45733705%0Awd%3AQ46164834%0Awd%3AQ46212084%0Awd%3AQ55340707%0Awd%3AQ43483588%0Awd%3AQ46235047%0Awd%3AQ46212066%0Awd%3AQ43585164%0Awd%3AQ43585146%0Awd%3AQ43483991%0Awd%3AQ11614578%0Awd%3AQ18411681%0Awd%3AQ35456825%0Awd%3AQ4285705%0Awd%3AQ26643865%0Awd%3AQ26330437%0Awd%3AQ26321021%0Awd%3AQ26638982%0Awd%3AQ26321022%0Awd%3AQ26641845%0Awd%3AQ26513267%0Awd%3AQ26317063%0Awd%3AQ26642369%0Awd%3AQ26513274%0Awd%3AQ26512904%0Awd%3AQ26316648%0Awd%3AQ26629838%0Awd%3AQ26629837%0Awd%3AQ26338101%0Awd%3AQ26586258%0Awd%3AQ24945664%0Awd%3AQ52857451%0Awd%3AQ37181%0Awd%3AQ19879858%0Awd%3AQ7714237%0Awd%3AQ55741499%0Awd%3AQ5196022%0Awd%3AQ35475892%0Awd%3AQ2888740%0Awd%3AQ29104249%0Awd%3AQ142306%0Awd%3AQ7359752%0Awd%3AQ5253814%0Awd%3AQ42294666%0Awd%3AQ709313%0Awd%3AQ273560%0Awd%3AQ5847169%0Awd%3AQ15276643%0Awd%3AQ4880637%0Awd%3AQ49157%0Awd%3AQ49523413%0Awd%3AQ18591889%0Awd%3AQ58039477%0Awd%3AQ7501447%0Awd%3AQ30274371%0Awd%3AQ8061249%0Awd%3AQ30626016%0Awd%3AQ45110151%0Awd%3AQ10877644%0Awd%3AQ31921888%0Awd%3AQ5635178%0Awd%3AQ27022744%0Awd%3AQ45981043%0Awd%3AQ15214022%0Awd%3AQ18162470%0Awd%3AQ1312023%0Awd%3AQ26321006%0Awd%3AQ26639007%0Awd%3AQ26638985%0Awd%3AQ26569784%0Awd%3AQ7716499%0Awd%3AQ26500894%0Awd%3AQ26321117%0Awd%3AQ26321116%0Awd%3AQ7338408%0Awd%3AQ7061108%0Awd%3AQ26316657%0Awd%3AQ26642037%0Awd%3AQ26316656%0Awd%3AQ26316655%0Awd%3AQ26642036%0Awd%3AQ7594807%0Awd%3AQ17551134%0Awd%3AQ17551141%0Awd%3AQ26333157%0Awd%3AQ17551084%0Awd%3AQ26333156%0Awd%3AQ17551091%0Awd%3AQ37883905%0Awd%3AQ5059528%0Awd%3AQ56237519%0Awd%3AQ30281865%0Awd%3AQ5355414%0Awd%3AQ17354968%0Awd%3AQ22005890%0Awd%3AQ5279781%0Awd%3AQ57140626%0Awd%3AQ28206674%0Awd%3AQ55045707%0Awd%3AQ5566638%0Awd%3AQ55049164%0Awd%3AQ55049165%0Awd%3AQ36860299%0Awd%3AQ56856503%0Awd%3AQ24023802%0Awd%3AQ24023803%0Awd%3AQ21244912%0Awd%3AQ15899419%0Awd%3AQ22960693%0Awd%3AQ4138554%0Awd%3AQ4153832%0Awd%3AQ36278415%0Awd%3AQ29788798%0Awd%3AQ47001601%0Awd%3AQ12020562%0Awd%3AQ38228075%0Awd%3AQ49527263%0Awd%3AQ2542939%0Awd%3AQ19459504%0Awd%3AQ32110705%0Awd%3AQ28912416%0Awd%3AQ34946395%0Awd%3AQ29113308%0Awd%3AQ23813297%0Awd%3AQ29584455%0Awd%3AQ30932484%0Awd%3AQ21878739%0Awd%3AQ21878721%0Awd%3AQ3821144%0Awd%3AQ19550813%0Awd%3AQ4142927%0Awd%3AQ17044700%0Awd%3AQ49280590%0Awd%3AQ12064715%0Awd%3AQ19741623%0Awd%3AYmblanter%0Awd%3AQ7692505%0Awd%3AQ26545841%0Awd%3AQ26789428%0Awd%3AQ14916984%0Awd%3AQ45401294%0Awd%3AQ21924652%0Awd%3AQ4145512%0Awd%3AQ11325617%0Awd%3AQ6434242%0Awd%3AQ5355155%0Awd%3AQ45308282%0Awd%3AQ42837494%0Awd%3AQ42837157%0Awd%3AQ42838683%0Awd%3AQ42838568%0Awd%3AQ42838539%0Awd%3AQ42838600%0Awd%3AQ42838630%0Awd%3AQ42837707%0Awd%3AQ3350175%0Awd%3AQ28684297%0Awd%3AQ49296364%0Awd%3AQ30203983%0Awd%3AQ5183861%0Awd%3AQ1049706%0Awd%3AQ26502414%0Awd%3AQ26580559%0Awd%3AQ26502411%0Awd%3AQ26558470%0Awd%3AQ29566861%0Awd%3AQ7285260%0Awd%3AQ33323535%0Awd%3AQ31645649%0Awd%3AQ2634867%0Awd%3AQ5046050%0Awd%3AQ46727132%0Awd%3AQ46734525%0Awd%3AQ46771044%0Awd%3AQ20471319%0Awd%3AQ36174965%0Awd%3AQ3414016%0Awd%3AQ2137835%0Awd%3AQ19871703%0Awd%3AQ5532866%0Awd%3AQ49507399%0Awd%3AQ21923198%0Awd%3AQ34877508%0Awd%3AQ11358343%0Awd%3AQ17224098%0Awd%3AQ34927773%0Awd%3AQ19875627%0Awd%3AQ16952785%0Awd%3AQ13406268%0A%0A%0A%7D%0A%20%20%0A%7D

[misaochan]

@VojtechDostal , is there a way to re-run that query to get an updated map? Would be useful for future reports. :)

[urbanecm]

I think that query is executed each time you load it :-).

[VojtechDostal]

@urbanecm Unfortunately, you need to manually update the list of items in the Query (AFAIK, Query cannot read from Quarry). It's getting longer every time (and shorteners don't work any more) but here you are:
url

[misaochan]

Awesome, thanks @VojtechDostal ! Yeah, that is a pretty long URL, haha. 😄 But on the bright side, the map looks great, so many new countries!

How do you obtain the list of items (in the appropriate format) to update it with?

[VojtechDostal]

@misaochan Yeah, it's a really cool visualization of what we have achieved with the app. I get the list from @nicolas-raoul 's quarry (https://quarry.wmflabs.org/query/37568) ... and just add "wd:" in front of QIDs using Excel into each line :)

[misaochan]

Hi @nicolas-raoul @VojtechDostal , I'm trying to collect these stats again for the next PG report, but it seems like things have changed again. A database name needs to be entered, and also I'm pretty sure https://quarry.wmflabs.org/query/37568 itself has been changed? Would appreciate any help with the query. :)

[nicolas-raoul]

I think I fixed it: https://quarry.wmflabs.org/query/56896
I also filtered out a bot which was hijacking our tag (and has been fixed since).

[VojtechDostal]

Been doing some analysis on that for Czech audience :)

[misaochan]

@nicolas-raoul Thanks a lot! It works for me now. And according to our results, we have a total of 4564 p18 edits made through our app now, which is pretty impressive IMO! :)

@VojtechDostal Wow, that's super cool, so many pics added for the Czech Republic! (But you do mean p18 and not p17... right? :) )

[misaochan]

Ahh, @nicolas-raoul , I just realized that some QIDs are being counted multiple times (e.g. Q95683884 by Silas), so the number of rows might not be the true number of places with pics added to them. Could we get the fix for unique QIDs again please?

[nicolas-raoul]

@misaochan Sure, here are unique QIDs: https://quarry.wmflabs.org/query/56908 By the way P17 is the country property, right before the image property :-)

@VojtechDostal I tried generating the world map reusing your 2019 SPARQL above, but I get Error: 502, Next Hop Connection Failed, too many points I guess? Maybe make the SPARQL output latitude/longitude rows, then render the map with another tool?

[VojtechDostal]

@misaochan Sure, here are unique QIDs: https://quarry.wmflabs.org/query/56908 By the way P17 is the country property, right before the image property :-)

@VojtechDostal I tried generating the world map reusing your 2019 SPARQL above, but I get Error: 502, Next Hop Connection Failed, too many points I guess? Maybe make the SPARQL output latitude/longitude rows, then render the map with another tool?

I do it differently now... Using Commons Query service - https://www.wikidata.org/wiki/User:Vojt%C4%9Bch_Dost%C3%A1l/app-Czech_uploads

[nicolas-raoul]

Thanks, nice script, I like how it even shows thumbnails!

link

[misaochan]

Thanks a lot guys! The new query works like a charm. Love the world map too, is it OK to upload it to Commons and use it in the report as well @nicolas-raoul ? :)

[VojtechDostal]

Thanks a lot guys! The new query works like a charm. Love the world map too, is it OK to upload it to Commons and use it in the report as well @nicolas-raoul ? :)

Sure, use it as you like, I doubt there is anything copyrightable about the maps :) .

[nicolas-raoul]

Attribution is needed though, I would suggest using license CC-BY-SA and this author:

(example)

[nicolas-raoul]

I believe this can be closed, as quarry achieves the purpose more or less.

[nicolas-raoul]

2023 March 5:

[nicolas-raoul]

Strangely this file in Nigeria appears as a result of the query https://quarry.wmcloud.org/query/56896 but does not seem to have been uploaded via the app: https://commons.wikimedia.org/wiki/File:Old_church_buiding,_Kafanchan.jpg
Same for https://commons.wikimedia.org/w/index.php?title=File:Tour_SAICA_et_tour_Postel.jpg&action=history in Ivory Coast.

By the way:

[VojtechDostal]

@nicolas-raoul Actually that item previously really had an image from the Commons app:
https://www.wikidata.org/w/index.php?title=Q6177061&diff=1582263772&oldid=1460503929

[nicolas-raoul]

@VojtechDostal Interesting! I wonder if the Quarry script could be modified to not count deleted images, and possibly to have a file column that the SPARQL could show instead of the current picture...