User talk:Fæ

From Wikimedia Commons, the free media repository
Jump to: navigation, search
Before and after Wikimedia Commons...

My backlog of volunteer tasks can be found at User:Fæ/backlog. This runs as an agile backlog. Low priority tasks may take months to complete.

For questions or requests relating to UK Chapter activities, or if you are connected to the UK Chapter, please email me rather than writing on-wiki or on this page.

Flickr users: In addition to my projects of content creation for Commons, I have been experimenting with how to share collections off-wiki. http://www.flickr.com/groups/wikimedia-commons is a Flickr group created for selected GLAM categories, each image linking back to its Wikimedia Commons source.

Archives.png
2010
2011
2012
2013
2014
2015
Anonymous
Evolution-tasks.png Pending tasks for : edit this list - add to watchlist - purge
  1. Monitor Commons:Requests for comment/Batch categorization requirements
  2. Repair Geograph templates in line with WSC's suggestions #Geograph problem raised: Nov 2012
  3. Consider WSC's request on under-categorized images #Nuther Geograph problem raised: Nov 2012
  4. LACMA M.2007.224.4 seems to be wrong at source.
  5. RFC on D codes (based on a dream).
  6. Explore http://curtis.library.northwestern.edu/curtis/weblinks.html as a possible source
  7. Chisel away at the list on Category talk:Images from USC Digital Library uploaded by Fæ (check needed)
  8. Library of Congress 100mb+ files
    1. An ocean of motion about Spanish commotions or the windy explosion of pot-hous oration LCCN2003681692 105MB Done
    2. Consular games - the game of brag - the game of hazard LCCN2003689149 113MB Done
    3. The eclipse at an end - and political tilting discovered LCCN2003689150 100MB Done
    4. http://lccn.loc.gov/2003689153 101MB
    5. http://lccn.loc.gov/2003689154 100MB
    6. The washing-tub expedition LCCN2003689156 115MB
    7. St. James's volunteers firing at a target at Kilburn Wells LCCN2003689161 140MB Done
    8. The father of the family takeing (sic) his eldest boy from school LCCN2006675448 TIFF (168.4mb)
    9. The dextrous trimmer or Pool Pill Garlick left in the suds LCCN2006676836 TIFF (118.0mb)
    10. Hell in triumph or The devil has got his own LCCN2006677045 TIFF (119.7mb)
    11. Fox's martyrs or The patriots in limbo LCCN2006678061 TIFF (183.9mb)
    12. John Bull fighting the French single handed LCCN2006678160 TIFF (110.8mb)
    13. King Joe disposing of his Spanish crown !!! LCCN2006678169 TIFF (113.4mb)
    14. Puck's palete LCCN2011660542 TIFF (141.1mb)
    15. A " bogus" cremation for the benefit of the "life-long Democrats" LCCN2011661357 TIFF (143.3mb)
    16. Thanksgiving day, 1885 LCCN2011661359 TIFF (142.5mb)
    17. The carol of the "waits" LCCN2011661367 TIFF (143.4mb)
    18. The old and the new year LCCN2011661369 TIFF (138.6mb)
    19. City flowers LCCN2011661371 TIFF (139.7mb)
    20. Our Japanese village LCCN2011661373 TIFF (139.7mb)
    21. Snowed in LCCN2011661375 TIFF (143.4mb)
    22. The angel of peace LCCN2011661377 TIFF (143.9mb)
    23. The Administration sawmill LCCN2011661379 TIFF (138.5mb)
    24. The one man power in our jury system LCCN2011661381 TIFF (143.0mb)
    25. Don't they wish they had never taken hold of it! LCCN2011661383 TIFF (137.4mb)
    26. The pirate publisher - an international burlesque that has has the longest run on record LCCN2011661385 TIFF (141.8mb)
    27. Cleveland's entry into Washington - March 4th. 1885 LCCN2011661387 TIFF (142.4mb)
    28. President Cleveland and his cabinet LCCN2011661426 TIFF (134.5mb)
    29. History repeats itself LCCN2011661430 TIFF (144.4mb)
    30. U.S. Grant LCCN2011661433 TIFF (141.7mb)
    31. The night mare LCCN2006678665 TIFF (140.2mb)
    32. The attack on our outer ramparts - first the house of refuge - then the public schools - then - the Constitution! LCCN2011661440 TIFF (143.7mb)
    33. "Peace" assured LCCN2011661446 TIFF (146.5mb)
    34. A view in Spain LCCN2006678817 TIFF (127.4mb)
    35. "Sheol" LCCN2011661750 TIFF (141.3mb)
    36. Two political paths LCCN2011661754 TIFF (140.9mb)
    37. Scientists assert that all diseases can be prevented by inoculation LCCN2011661758 TIFF (144.3mb)
    38. Harmony and envy LCCN2011661762 TIFF (141.7mb)
    39. The administration's hardest job LCCN2011661766 TIFF (143.5mb)
    40. In memoriam U.S. Grant LCCN2011661768 TIFF (140.2mb)
    41. Puck's political hunting-ground - how he has made game of the politicians LCCN2011661812 TIFF (141.7mb)
    42. Puck's notion of the kind of fancy-dress charity ball that would be a real, solid financial success LCCN2011661816 TIFF (141.1mb)
    43. This is what the "freedom of worship" bill means - can we hold the evil in check? LCCN2011661820 TIFF (141.6mb)
    44. Noxious growths in liberty's grounds LCCN2011661824 TIFF (141.7mb)
    45. The pyrrhic victory of the Mulligan guards in Maine LCCN2011661828 TIFF (147.4mb)
    46. A hard pull LCCN2011661832 TIFF (141.4mb)
    47. Hell broke loose, or, The murder of Louis, vide, the account of that unfortunate monarch's execution LCCN2006680657 TIFF (153.5mb)
    48. The false "friend of the workingman" LCCN2011661836 TIFF (142.3mb)
    49. Helping the rascals in - a burglarious scheme that may be suddenly spoiled LCCN2011661838 TIFF (144.7mb)
    50. Men may come, and men may go; but the work of reform shall go on forever LCCN2011661843 TIFF (141.0mb)
    51. "The Mulligan guard lies, but - surrenders" LCCN2011661847 TIFF (143.8mb)
    52. The transfusion of blood - may the operation prove a success! LCCN2012645151 TIFF (144.8mb)
    53. The World's International and Cotton Centennial Exposition, New Orleans, La., open from Dec. 1st 1884 to May 31st 1885 LCCN2012645153 TIFF (142.2mb)
    54. Crowding the cabinet-making business LCCN2012645155 TIFF (143.0mb)
    55. Puck's review of the past year LCCN2012645159 TIFF (141.1mb)
    56. Preserve your forests from destruction, and protect your country from floods and drought LCCN2012645164 TIFF (140.3mb)
    57. The contest of beauty LCCN2012645168 TIFF (139.9mb)
    58. Arlequin sur l'Hippogryphe a la croisade Lojoliste LCCN2006681091 TIFF (184.6mb)
    59. Het lusthuys van Pater Peters, en de Jesuwijten en Munniken, ontdekt door LCCN2006681092 TIFF (176.8mb)
    60. Passing everything on the road LCCN2012645172 TIFF (142.1mb)
    61. A desperate attempt to solve the mormon question LCCN2012645174 TIFF (140.8mb)
    62. A lenten dream LCCN2012645182 TIFF (143.6mb)
    63. Leap-year LCCN2012645186 TIFF (142.9mb)
    64. Democracy's disastrous egg-dance LCCN2012645191 TIFF (141.8mb)
    65. Blaine O'Maine LCCN2012645195 TIFF (139.8mb)
    66. Boney at Bayonne blowing a Spanish bubble LCCN2006681466 TIFF (117.7mb)
    67. Boney bringing home the truth from Spain LCCN2006681467 TIFF (113.7mb)
    68. Two of a kind LCCN2012645199 TIFF (147.0mb)
    69. A Spanish joke !!! LCCN2006681484 TIFF (112.4mb)
    70. More than she can carry LCCN2012645201 TIFF (143.1mb)
    71. An unpleasant ride through the presidential "haunted forest" LCCN2012645205 TIFF (144.6mb)
    72. The writing on the wall LCCN2012645210 TIFF (141.2mb)
    73. "A sail! A sail!!" LCCN2012645216 TIFF (145.3mb)
    74. A flag the Independents will fight under LCCN2012645250 TIFF (147.0mb)
    75. He can't beat his own record LCCN2012645419 TIFF (143.9mb)
    76. Raising the funds to buy the presidency LCCN2012645430 TIFF (141.8mb)
    77. The new Democratic eucalyptus tree purifies a political morass LCCN2012645434 TIFF (145.0mb)
    78. The universal church of the future - from the present religious outlook LCCN2012645438 TIFF (138.5mb)
    79. The great floods of 1883 - Germany's need and America's aid LCCN2012645440 TIFF (139.2mb)
    80. Our imitative "aristocracy" LCCN2012645446 TIFF (138.2mb)
    81. The end of a bad show LCCN2012645452 TIFF (137.5mb)
    82. "Take the next car!" LCCN2012645454 TIFF (139.2mb)
    83. The U.S. Hotel badly needs a "bouncer" LCCN2012645460 TIFF (138.0mb)
    84. The great advertising ball of the season LCCN2012645462 TIFF (138.3mb)
    85. Democratic harmony under the Jeffersonian banner LCCN2012645468 TIFF (140.4mb)
    86. The greatest show on earth - "who can ride the mule?" LCCN2012645470 TIFF (141.6mb)
    87. Life's ups-and-downs - Puck's improvement on Cole's "Voyage of Life" LCCN2012645495 TIFF (139.9mb)
    88. The operatic war in New York LCCN2012645537 TIFF (136.0mb)
    89. Let us have a good bankruptcy law, as a protection against the "preferred creditor" swindle LCCN2012645556 TIFF (134.6mb)
    90. Thanksgiving LCCN2012645611 TIFF (135.1mb)
    91. How to keep a girl LCCN2012645613 TIFF (135.8mb)
    92. Christmas at Washington LCCN2012645617 TIFF (140.3mb)
    93. The convention makers LCCN2006684142 TIFF (104.3mb)
    94. Reason against unreason LCCN2012645621 TIFF (127.5mb)
    95. Licensed wreckers - in the hands of the receivers LCCN2012645631 TIFF (126.3mb)
    96. Under false colors LCCN2012645633 TIFF (126.9mb)
    97. Rushing the season LCCN2012645638 TIFF (128.4mb)
    98. The declaration of dependence LCCN2012645642 TIFF (127.7mb)
    99. Longfellow LCCN2012647200 TIFF (128.4mb)
    100. Beyond control LCCN2012647204 TIFF (129.9mb)
    101. Speaker Keifer's kaleidoscopic speech, at the N.Y. Chamber of Commerce banquet, held at Delmonico's, May 9th, 1882 LCCN2012647206 TIFF (130.2mb)
    102. Science, or sport? - A modern spectacle after an old model LCCN2012647208 TIFF (129.3mb)
    103. True reform of Parliament,-i.e.-patriots lighting a revolutionary-bonfire in new Palace Yard LCCN2006684995 TIFF (105.2mb)
    104. First annual picnic of the "Knights of Labor" - more fun for the spectators than for the performers LCCN2012647217 TIFF (133.2mb)
    105. The murderer's straight route to heaven - bringing religion into disrepute LCCN2012647219 TIFF (130.9mb)
    106. Venison & Claret, or Sr. Humpy. Haunch, Bart. of Glutton Hall LCCN2006685173 TIFF (118.8mb)
    107. Roast beef & port or Bully Bramble Esqr., Justice of Peace in Wasp Town LCCN2006685175 TIFF (115.3mb)
    108. A summer smoke-cloud LCCN2012647234 TIFF (131.7mb)
    109. Congressional cracksmen LCCN2012647268 TIFF (124.6mb)
    110. Uncle Sam's neglected farm LCCN2012647270 TIFF (127.7mb)
    111. The deadly upas tree of Wall Street LCCN2012647280 TIFF (127.2mb)
    112. Cut-throat business in Wall Street. How the inexperienced lose their heads LCCN2012647282 TIFF (126.4mb)
    113. Garfield LCCN2012647283 TIFF (129.7mb)
    114. Our Indian policy - a house of cards LCCN2012647285 TIFF (128.8mb)
    115. A grand Shakesperian (sic) revival LCCN2012647290 TIFF (130.5mb)
    116. Puck's own Yorktown celebration LCCN2012647294 TIFF (128.6mb)
    117. "Sic 'em!" LCCN2012647297 TIFF (128.0mb)
    118. Escaping from the old shell LCCN2012647300 TIFF (133.9mb)
    119. Broken banks - defaulting cashiers - negligent directors - who is responsible? LCCN2012647302 TIFF (130.0mb)
    120. The " enfant ter(ri)ble" of Europe LCCN2012648777 TIFF (146.2mb)
    121. Throw 'em out! LCCN2012648781 TIFF (149.3mb)
    122. The modern colossus of (rail) roads LCCN2014645351 TIFF (139.3mb)
    123. The freedom of election or hunt-ing for popularity and plumpers for Maxwell LCCN2006688902 TIFF (118.5mb)
    124. Constitutional Club LCCN2006690504 TIFF (143.6mb)
    125. The sour prospect before us, or The ins throwing up LCCN2006690521 TIFF (101.1mb)
    126. The life of William-Cobbett, -written by himself. No. 8 LCCN2007677435 TIFF (110.0mb)
    127. -Affairs. The sweet prospect behind us, or The outs in office LCCN2007677506 TIFF (101.1mb)
    128. Represantant d'une grande nation LCCN2010647164 TIFF (170.2mb)


File:Part of Northfield. NYPL1515717.tiff[edit]

Thank you for adjusting the Viele file (last topic).

This file also doesn't belong with the ID, NYPL 1515717.

Thanks for your help!. Vzeebjtf (talk) 20:42, 29 December 2014 (UTC)

When I looked at the last case, I did notice the file I was uploading as a replacement also exists on Commons under the wrong filename. I'm unsure what the cause was, possible lags in file uploads may have caused some sort of interative issue. If you find more cases, please list them here. My volunteer time is limited over the next couple of weeks, and I have a number of things put on my backlog already, so I would rather let some cases build up and then schodule time to investigate this properly, rather than fix odd cases. Thanks for raising this for attention. -- (talk) 21:06, 29 December 2014 (UTC)
OK. Vzeebjtf (talk) 03:11, 30 December 2014 (UTC)

Only partly downloaded:

Some of the filenames in these category have truncated NYPL numbers:

For now. Vzeebjtf (talk) 03:11, 30 December 2014 (UTC) Vzeebjtf (talk) 05:16, 3 January 2015 (UTC) Vzeebjtf (talk) 09:49, 3 January 2015 (UTC) Vzeebjtf (talk) 23:43, 5 January 2015 (UTC) Vzeebjtf (talk) 01:46, 6 January 2015 (UTC) Vzeebjtf (talk) 10:04, 7 January 2015 (UTC) Vzeebjtf (talk) 10:41, 7 January 2015 (UTC) Vzeebjtf (talk) 12:07, 7 January 2015 (UTC) Vzeebjtf (talk) 07:27, 8 January 2015 (UTC) Vzeebjtf (talk) 12:07, 8 January 2015 (UTC)

I'm done. Vzeebjtf (talk) 06:01, 9 January 2015 (UTC)

Copyright status: File:- Pure Oil Service Station, Intersection of U.S. 130 Northbound and Collingswood Circle. Southeast side of circle., Collingswood, Camden County, NJ HABS NJ,4-COLWO,2-10.tif[edit]

{Autotranslate|1=File:- Pure Oil Service Station, Intersection of U.S. 130 Northbound and Collingswood Circle. Southeast side of circle., Collingswood, Camden County, NJ HABS NJ,4-COLWO,2-10.tif|base=Image license}} Stefan4 (talk) 23:15, 1 January 2015 (UTC)

Also see COM:AN#Files without a file information page where you were mentioned. --Stefan4 (talk) 23:35, 1 January 2015 (UTC)

Left a comment at AN. Any HABS image is reliably PD, it may be more useful to add these to a backlog category than template them, or filter a SQL generated list and email to me. Smile fasdfdsfoiueire.svg (talk) 00:49, 2 January 2015 (UTC)

I have posted a list of the ones containing the letter combination "HABS" at [1]. Try to fix them once you have time. --Stefan4 (talk) 14:37, 2 January 2015 (UTC)

Though I'm not at home, I did manage to log in to WMFlabs on my tiny netbook and get into SQL. Running the following query probably includes the listed files, plus any other drop outs that may have occurred during my uploads, with a total of 922 files. Not all are from the HABS/HAER archives. It took 22 minutes to run though, so I would not want to refresh this too often in a day. Being able to pull this, or the equivalent, is handy if I do another large upload on Commons. I have urgent other stuff this week, but can probably knock the majority of these out in the week following.

SELECT
  CONCAT("File:",img_name),
  img_timestamp
FROM image
WHERE
  img_user =1086557
  AND NOT EXISTS (SELECT * FROM page WHERE img_name=page_title)

Snapshot of report at: http://commons.wikimedia.org/w/index.php?title=User:F%C3%A6/sandbox&oldid=145413405

P.S. Try to avoid running bots and creating 'missing license' notices on these, they actually then drop off this list as the image page is no longer blank, and I have to make a different query to discover them. -- (talk) 11:01, 5 January 2015 (UTC)

@Stefan4: I'm calling this ✓ Done for the moment. The dozen left are not HABS but other batch uploads and can be gradually fixed by hand, based on others in the same series. -- (talk) 14:05, 20 January 2015 (UTC)

Thanks for fixing this, Fæ! I wish that the WMF would fix the bug in MediaWiki which causes this problem in the first place, but I guess that it is higher priority for them to ban administrators and superprotect pages... --Stefan4 (talk) 14:42, 20 January 2015 (UTC)
Indeed. Each year the list of things the WMF is doing to ensure long term volunteers pause to look around for better ways to use their unpaid free time seems to get longer and sadder. -- (talk) 14:46, 20 January 2015 (UTC)

File:Cartons of soy milk.jpg[edit]

File:Cartons of soy milk.jpg (edit|talk|history|links|watch|logs)
Commons:Deletion requests/File:Cartons of soy milk.jpg 🎂CAKE🎂 09:19, 23 January 2015 (UTC)

Help needed[edit]

Hello Fae,

User:Alan Liefting made a mistake and removed the category Israel form a lot of files so they left a files without a category. he added "Removing from Category:Israel" to the edit summary. Can you made a "hocus pocus" :) with you tools so I can have a list of this that I coud be able to use cat a lot to add the category back? -- Geagea (talk) 03:39, 24 January 2015 (UTC)

I wasn't a mistake. It was a judgement call that I made to clean up Israel related files. I had recategorised some of them. Others are now uncategorised and will be flagged as uncategorised. This will prompt editors to recategorise them correctly. The country categories such as Category:Israel should have very few if any files in it and the Israel category huge numbers of files in it for some time. Alan Liefting (talk) 04:01, 24 January 2015 (UTC)
No Alan, they are not flagged as uncategorised, they simply uncategorised and nobody will know about them. The correct way is to move them to other category - people of Israel, nature of Israel etc. -- Geagea (talk) 04:06, 24 January 2015 (UTC)
There is a bot that goes around flagging pages as uncategorised. Sure, the correct way is to have them categorised into the appropriate subcategory and I did that with some of them. After I removed the Israel category a bot also went through and categorised some based on location. The remainder have to be done manually. Alan Liefting (talk) 04:20, 24 January 2015 (UTC)
This is no solution. They are better to be categories rather then to be un categories. In a working place when all the time new files uploaded you will find all the time files in this category to be classified not to be removed from the category. different from other projects the aim of Commons is to provide a media file repository not to hide it. I have no doubt about your intention to help but uncategorized files are useless. -- Geagea (talk) 04:34, 24 January 2015 (UTC)
A major category with over a thousand files in it is also useless. Alan Liefting (talk) 04:37, 24 January 2015 (UTC)
Better then thousand uncategories files. -- Geagea (talk) 04:46, 24 January 2015 (UTC)
I don't agree. Alan Liefting (talk) 04:47, 24 January 2015 (UTC)
The actual number of uncategorised files after removing Category:Israel is somewhat less than a thousand. Alan Liefting (talk) 05:17, 24 January 2015 (UTC)
@Alan Liefting: I moved this discussion to the village pump. Hopefully you got better explanation. This is {{Categorise}} not {{MetaCat}}, it should include files and categories. The category answers the question of location. -- Geagea (talk) 08:05, 26 January 2015 (UTC)
✓ Done @Geagea: I have created a gallery at User:Fæ/sandboxL. This can help discussion to reach a consensus on what is best, or the text of the list be used for further processing. -- (talk) 08:32, 24 January 2015 (UTC)
Thank you very much Fae. But the point is that I cant use cat a lot in this page. There is anything can be done? -- Geagea (talk) 08:05, 26 January 2015 (UTC)
Ah, cat-a-lot used to be able to take a page of thumbnails (or search results) and categorize them, but this appears to have stopped and never been fixed for a very long time (I have just changed its help page to reflect this fact). If you can establish a consensus, I would be happy to add a temporary category so they can be moved about by anyone. -- (talk) 10:20, 26 January 2015 (UTC)

Faebot[edit]

Hi. I've veen adding categories to some pics, and I found that Faebot added categories but files still remains with {{uncategorized}} included. Is there any way to remove this template? See for example: [2]. Thanks. --Ganímedes (talk) 14:05, 29 November 2014 (UTC)

I believe the template removes itself as soon as you add categories. If there is an example where this failed, give me a link and I'll take a look. Smile fasdfdsfoiueire.svg -- (talk) 15:44, 29 November 2014 (UTC)
I can give you several, there is a long list of media with this problem. See for example:

...

Choose random. I also thought it was automatic, but apparently not always works. Thanks. --Ganímedes (talk) 22:00, 29 November 2014 (UTC)

Hi. Could you check this? There are thousands of pictures whit cats and not-cat advices. Nor maybe you can tell me someone else to talk about this? Thanks. --Ganímedes (talk) 10:01, 4 December 2014 (UTC)
What I can do is have a housekeeping run through of specific projects, like Geograph, and check for those with 2 or more visible categories with the nocat template and pull it out. <off topic trim>
@Ganímedes: I have started Faebot looking at Geograph images for the template {{Uncategorized-Geograph}} and where there are 2 or more visible categories which are do not match any of 'Geograph|Photos by|Images by|Files by|Photographs by|Taken with'. If this is met, then the uncat template gets removed.
Faebot's previous work to add Counties/Unitary Authorities has resulted in many Geograph photos having single meaningful categories such as Shropshire, Hampshire, Aberdeenshire, Lancashire (plucking these from a terminal window), but I hope you agree that if this is the only category, then a human review probably is still needed. Unfortunately this is likely to be a very small fraction of the Geograph images; in fact Faebot has just looked at the first 1,100 images and found no matches yet, it could be because it is doing these in date order, or that prior housekeeping was okay...
Update, two good examples are File:Upside-down sign at Imber Range - geograph.org.uk - 537230.jpg and File:Wayford Manor Gardens - geograph.org.uk - 513255.jpg. The 'hit rate' seems fewer than 0.1% so far. -- (talk) 14:59, 24 January 2015 (UTC)

Deletion statistics[edit]

I asked this question over at the Help desk but you may be able to answer it. Apart from laboriously counting them is there a way of tracking the number of daily file deletions? Cheers. Alan Liefting (talk) 03:31, 25 January 2015 (UTC)

The number of file deletions is logged in the wiki-database in a table called filearchive. This makes it possible for the API to check against the SHA1 to see if an uploaded file is digitally identical to one deleted in the past and warn the user/programmer/upload wizard. The table is easy to query using standard SQL, so there is no problem reporting this or charting it publicly, I suspect someone is doing this as one of the standard operations reports but it is quicker for me to go look at it. For example here are the total deletions by day so far this year, and deletions by year for all time. The reports took 1 and 2 seconds to run respectively:
+----------+----------+
| Total    | Date     |
| deletions|          |
+----------+----------+
|     1085 | 20150101 |
|      987 | 20150102 |
|     1075 | 20150103 |
|     1614 | 20150104 |
|     1948 | 20150105 |
|     2102 | 20150106 |
|     1641 | 20150107 |
|     1690 | 20150108 |
|     1111 | 20150109 |
|     1914 | 20150110 |
|     1821 | 20150111 |
|      915 | 20150112 |
|     1232 | 20150113 |
|     1548 | 20150114 |
|     1230 | 20150115 |
|     1086 | 20150116 |
|     1504 | 20150117 |
|     1358 | 20150118 |
|      715 | 20150119 |
|     1562 | 20150120 |
|     1403 | 20150121 |
|     1158 | 20150122 |
|     1493 | 20150123 |
|     1702 | 20150124 |
+----------+----------+

SQL to create table:
SELECT count(*), left(fa_deleted_timestamp,8) AS date FROM filearchive
WHERE left(fa_deleted_timestamp,4)='2015'
GROUP BY left(fa_deleted_timestamp,8);

+----------+------+
|   count  | date |
+----------+------+
|    99878 | 2006 |
|   225224 | 2007 |
|   259536 | 2008 |
|   321421 | 2009 |
|   269746 | 2010 |
|   294296 | 2011 |
|   563439 | 2012 |
|   499236 | 2013 |
|   486534 | 2014 |
|    34575 | 2015 |
+----------+------+
-- (talk) 08:02, 25 January 2015 (UTC)
Thanks a lot for that. And thanks for the promptness. Those numbers are frighteningly high and confirmed my suspicion that we are overworked because of the ease of being able to add inappropriate files. Alan Liefting (talk) 08:35, 25 January 2015 (UTC)
Sure, that's a possible conclusion, but to understand the figures would take some fairly deep analysis of the common events surrounding the deletions. You have to keep in mind some very large bundle deletions and improvements in deletion and tracking tools over the years. For example the URAA discussion resulted in mass undeletions on copyright grounds (filearchive only shows the deleted log, which is not removed on undeletion and so may skew our interpretation) and I recall arranging deletion of 17,000 of my own uploads in one day last year because of a mistake on a batch upload from the previous week; neither of these examples relate to 'inappropriate' files, they are just part of the cut and thrust of getting uploads sorted out as best we can. -- (talk) 08:51, 25 January 2015 (UTC)
Nod, nod. Ok. Alan Liefting (talk) 09:14, 25 January 2015 (UTC)
There is nothing at Commons:Database reports about file deletion stats. Alan Liefting (talk) 09:14, 25 January 2015 (UTC)
@Steinsplitter: has been improving these, I'm sure he can add something like this to the bot. I not that rather than filearchive, using logging is more often chosen. I'm not sure why either way, but that's something to ponder.
By the way, in his time as an administrator, Russavia made 67,112 deletions on Commons. In terms of unnoticed housekeeping that's a fine record. -- (talk) 09:32, 25 January 2015 (UTC)

File:Manufaktura Cuklerkow candu factory in Warsaw (8020427381).jpg[edit]

File:Manufaktura Cuklerkow candu factory in Warsaw (8020427381).jpg (edit|talk|history|links|watch|logs)
Commons:Deletion requests/File:Manufaktura Cuklerkow candu factory in Warsaw (8020427381).jpg Pibwl (talk) 18:16, 25 January 2015 (UTC)

Low-res high importance images[edit]

I think this worked better. --Nemo 19:50, 27 January 2015 (UTC)

Could you explain what this ranking means for us? I presume you are thinking of which images are good for curating or for dodging deletion, but I probably missed some earlier conversation. If we start a regular report, it could be that the formula can be refined to be more meaningful as others review it or start using it. -- (talk) 20:20, 27 January 2015 (UTC)

Categories of collections[edit]

Hi, I've notice there are some categories than have no cat. For example, a set related with Category:Collection of The New Art Gallery Walsall and Category:Collection of West Midlands Police Museum (7 categories related to Report each). I tried to fix it, but Faebot return everything to the previous state, so these cats remains uncategorized. There are other categories, like Category:Files from the Expedition Wikipedia project/Reports and subsequents. Thanks. --Ganímedes (talk) 15:03, 28 January 2015 (UTC)

Faebot faithfully follows whatever the settings are at User:Faebot/GLAM_dashboard#Requests. If the parent locations have not been created, they will be redlinks, even if the sub-pages exist. I think this is related to your observation, but I'm not 100% sure this is what you mean. -- (talk) 17:22, 28 January 2015 (UTC)
No, that's not what I mean. All pages with "/Reports/" are uncategorized; see for example: [6]. Like I said, I tried to fix it, but the bot removed the category again. Regards. --Ganímedes (talk) 01:27, 29 January 2015 (UTC)
I'll add this to my backlog. The change would be to ensure that any categories remain on the report page when updates are written. -- (talk) 12:24, 29 January 2015 (UTC)
Very kind of you. Thanks a lot. --Ganímedes (talk) 12:34, 29 January 2015 (UTC)

Images with cats still tagged with {{Uncategorized}}[edit]

Hi Ashley. I do a lot of patrolling of uncatted images like those in Category:Media needing categories as of 6 May 2014. I've found quite a few that were still tagged with {{Uncategorized}} even though they had perfectly good categories; often specific ones, such as paintings with the painter cats. Some of these were from batch uploads done with User:DcoetzeeBot, and others were from different batch uploads, etc. Is there any way to set up a bot that scan through images with {{Uncategorized}}, find the ones that have legit cats, and remove {{Uncategorized}} in those cases? I figure there are likely thousands of images with this issue. Thanks for your time. INeverCry 00:32, 29 January 2015 (UTC)

Sure, Faebot can do this. I currently have a script going through Geograph uploads but only a tiny percentage appear to have 2 or more good categories added (see #Faebot). The problem will be distinguishing useful 'legit' cats from others like "photos by", "taken with", camera types, check categories etc; as we have no solid standards for these.
Not this week, I'll add it to my backlog as something to play with.
To give you an idea how slow Faebot can be, here's a clip from my terminal from the Geograph sniffer:
 Loop 64800 Done so far 3  17:55:50
 Loop 64850 Done so far 3  18:01:18
 Loop 64900 Done so far 3  18:05:57
Graveyard of the signs - geograph.org.uk - 890886.jpg
 Signs in Scotland, No trespassing signs
 Found 2 visible categories, trimming Uncategorized-Geograph template
Updating page [[File:Graveyard of the signs - geograph.org.uk - 890886.jpg]] via API
 Loop 64950 Done so far 4  18:11:49
 Loop 65000 Done so far 4  18:17:37
 Loop 65050 Done so far 4  18:22:54
I could speed this up, by taking an archive dump and running the checks locally, but this takes a bit of serious planning considering how big the files are. It might speed things up to have Faebot's throttle removed, but I am cautious about taking that route. -- (talk) 00:51, 29 January 2015 (UTC)

There is a current bot request for this task: Commons:Bots/Requests/TaxonBot. @Doc Taxon: How are you going with it? Do you want to join forces in any way? --99of9 (talk) 01:26, 29 January 2015 (UTC)

I'll drop the task on the presumption that the proposed bot will sort it out. I can see this is in Tcl and it looks good, but I have no experience in that language. -- (talk) 10:01, 29 January 2015 (UTC)
I'll start it this weekend, user:99of9 wants to have a trial only. -- Doc Taxon (talk) 18:51, 29 January 2015 (UTC)

just FYI[edit]

Hi Fæ, not an important discussion, but as it was your upload: Commons:Administrators' noticeboard#Life_risk. --Túrelio (talk) 09:53, 29 January 2015 (UTC)

Already responded there. Thanks -- (talk) 10:00, 29 January 2015 (UTC)

Category:Thinktank, Birmingham (check needed)[edit]

Working on that now. Many thanks for the uploads. Andy Mabbett (talk) 10:19, 30 January 2015 (UTC)