Commons talk:Database reports

This is the talk page for discussing improvements to Commons:Database reports.

This is not a forum for general discussion of the page’s subject.
Put new text under old text. Click here to start a new topic.
Please sign and date your posts by typing four tildes (~~~~).
New to Commons? Check out the project scope. Ask questions, get answers.

New request

It might be interesting to have a report listing all other categories subcategories of Category:People by name are in, e.g. Category:Govind Ballabh Pant is also in:

Category:1887 births

and the percentage of subcategories of the later that are subcategories of Category:People by name (normally 100% for Category:1887 births).

As there are probably many categories, it's probably worth limiting this to the more frequent ones.

See en:Wikipedia:People_by_year/Reports/Stats#Most_frequent_other_categories for a similar report. -- Docu at 05:31, 1 December 2010 (UTC)[reply]

New Report

Would it be possible to have an empty categories page like the one at Wikipedia? I know there are several maintenance categories that should be deleted when empty, like these. sısɐuuǝɔıʌ∀ (diskuto) 12:30, 8 September 2011 (UTC)[reply]

Dashboard for my Père-Lachaise project

Hello,

Since 2011, I photograph the Père-Lachaise cemetery. Wikimedia Commons have +10 000 pictures of the cemetery and +3000 graves. As you can imagine, it becomes difficult to quickly know what has already been photographed.

For each division of the cemetery, I created a gallery page (eg. Cemetery Père-Lachaise - Division 11) where I identify grave not yet photographed by a svg. I would like to have some figures about each division:

the number of graves (the number of files for each gallery)
the number of graves not photographed (the number of File:Неизвестная марка.svg for each gallery)

On a monthly base would be really great ;) Pyb (talk) 14:55, 5 November 2014 (UTC)[reply]

Resolution upgrade needed

If useful, someone may want to make this a regular and prettier report. --Nemo 02:30, 28 January 2015 (UTC)[reply]

@Nemo bis:

Done --Steinsplitter (talk) 16:29, 16 June 2015 (UTC)[reply]

Report to find WebM files with bad duration

As brought up at Commons:Help desk/Archive/2019/06#Search videos by duration?: I found a WebM file with an erroneously long duration/small bitrate, which I repaired by rewrapping. Can a report be created to help find other files with the same issue? ChrstphrChvz (talk) 22:42, 1 June 2021 (UTC)[reply]