Community Wishlist Survey 2023/Multimedia and Commons/Improve patrolling new uploads in Commons

Random proposal ►◄ Multimedia and Commons The survey has concluded. Here are the results!

Improve patrolling new uploads in Commons

Problem: Currently very few uploads in Commons get patrolled, Something along the lines between 4% to 10%.
Proposed solution: I made a tool that helps but I think we need something better, I don't have the capacity to maintain it long-term.
Who would benefit: Patrollers in Commons.
More comments:
Phabricator tickets:
Proposer: Amir (talk) 07:20, 29 January 2023 (UTC)[reply]

MW stores the EXIF info in a database field that can be queryied from the API. A bot could check for the existance of EXIF info, for Facebook-Ids, for copyright notices, for author notices. --C.Suthorn (talk) 12:28, 29 January 2023 (UTC)[reply]
@C.Suthorn can you give me some examples of such keywords? querying exif data is much easier these days. Amir (talk) 19:47, 29 January 2023 (UTC)[reply]
I had some: https://commons.wikimedia.org/w/index.php?title=Special:ListFiles/Gandalfosaurus&ilshowall=1 but they have been deleted by now. In this files "Reuters" and "AFP" was mentioned in the EXIF C.Suthorn (talk) 00:03, 30 January 2023 (UTC)[reply]
@C.Suthorn https://quarry.wmcloud.org/query/70878 This is for Reuters. I'll check the others soon. Amir (talk) 05:49, 30 January 2023 (UTC)[reply]
The metadata approach will also work for video files. While the meta data for video files is not displayed on file description pages, MW does read the meta data (and probably stores it in the database) C.Suthorn (talk) 10:54, 30 January 2023 (UTC)[reply]
That query includes videos too. The table name is historical. Amir (talk) 05:30, 31 January 2023 (UTC)[reply]
Thank for your submission. What functions would you like to add to this tool? --Wargo (talk) 22:58, 4 February 2023 (UTC)[reply]

Support Bluerasberry (talk) 15:24, 11 February 2023 (UTC)[reply]
Support Realmartcraft (talk) 17:08, 11 February 2023 (UTC)[reply]
Support We have to improve patrolling new images. Thingofme (talk) 03:41, 12 February 2023 (UTC)[reply]
Support I'm not a patroller and I'm not sure exactly what this looks like, but addressing the low patrol rate in Commons is important imo, Eiim (talk) 13:55, 13 February 2023 (UTC)[reply]
Support Quiddity (talk) 21:28, 14 February 2023 (UTC)[reply]
Support Ruthven (msg) 15:43, 15 February 2023 (UTC)[reply]
Support Sadads (talk) 01:18, 16 February 2023 (UTC)[reply]
Support cyrfaw (talk) 12:26, 17 February 2023 (UTC)[reply]
Support Dubstar (talk) 18:38, 17 February 2023 (UTC)[reply]
Support Daniel Case (talk) 06:26, 18 February 2023 (UTC)[reply]
Support Lupe (talk) 13:37, 18 February 2023 (UTC)[reply]
Support Albinfo (talk) 21:26, 18 February 2023 (UTC)[reply]
Support Mbrickn (talk) 03:29, 20 February 2023 (UTC)[reply]
Support — Draceane ^talk_contrib. 11:31, 20 February 2023 (UTC)[reply]
Support Jeeputer (talk) 03:22, 21 February 2023 (UTC)[reply]
Support Ταπυρ (گپ) 13:24, 22 February 2023 (UTC)[reply]
Support Morten Haan (talk) 18:27, 22 February 2023 (UTC)[reply]
Support Althair (talk) 04:17, 23 February 2023 (UTC)[reply]
Support SalmanZ (talk) 13:51, 23 February 2023 (UTC)[reply]