@matmarex: thx for your honest answer. I followed your attempts to make this thing working and I respect the work you dedicated for it.
Let's do the same analysis as before, now for cross-wiki-uploads from 08.03.2016 via Quarry = User:Gunnex/Cross-wiki uploads 08.03.2016, because I worked on that data already intensively since May 2016.
Here, we have less uploads and only 1 day to check (may be influenced also by (un)lucky circumstances), but just to find out a "trend". I posted here already some interim results before but we have now an almost stable data situation.
- 1st run on 10.05.2016. 1.289** rows. 902 living (87 pending deletion), 387 deleted.
- 2nd run on 12.05.2016. 1.309** rows. 846 living (180 pending deletion), 463 deleted.
- 3rd run on 15.05.2016: 1.317** rows. 813 living (252 pending deletion), 504 deleted.
- 4th run on 29.05.2016: 1.291** rows. 643 living (97 pending deletion), 648 deleted.
- 5th run on 01.06.2016: 1.299** rows. 522 living (146 pending deletion), 777 deleted.
- 6th run on 07.06.2016: 1.279** rows. 446 living (73 pending deletion), 833 deleted.
- 7th run on 27.07.2016: 1.276** rows, 363 living (0 pending deletion), 913 deleted.
--> **) including some double entries due to bug T140522
...reaching an overall bad ratio of 71,55 % (copyvios/PS/perm./source/etc.) for this period.
The 913 deleted files were deleted, because (per info available at column "DeletionReason"):
| DeletionReason: | copyvios | no-permission | no-source | no-license | deletion requests* | others** | total |
| Files: | 407 | 82 | 6 | 0 | 401 | 17 | 913 |
|
--> *) multiple issues (copyvios/permission/sources/project scope)
--> **) multiple issues (duplicates, attack images, user errors, project scope, etc.)
Regarding user registration we have:
Uploaded files, depending on registration date:
| Registration date: | 08.03.2016 | 07.03.2016 | 06.03.2016 | 05.03.2016 | 04.03.2016–01.01.2016 | 2015 | 2014 | 2013 | 2012 | 2011 | 2010–2008 | total |
| Files: | 778 | 114 | 11 | 1 | 239 | 63 | 18 | 20 | 3 | 19 | 10 | 1.276 |
| Deleted: | 569 | 95 | 7 | 1 | 157 | 48 | 14 | 10 | 2 | 7 | 3 | 913 |
| Bad ratio (%): | 73,14 | 83,33 | 63,64 | 100,00 | 65,69 | 76,19 | 77,78 | 50,00 | 66,67 | 36,84 | 30,00 | |
|
904 uploads (70,85 %) by fresh users registered 08.03. – 05.03.2016 are standing for 672 deleted files = 73,60 % --> that means, that each 1,36 file uploaded only by these users were "bad".
Again, also older accounts (which may be more familiar with policies of Wikipedia) presents high bad ratios but here we have also a smaller data base to compare.
As you can see via User:Gunnex/Cross-wiki uploads from pt.wikipedia.org I am checking (with some back log) especially cross-wiki uploads from my (ex-) home wiki: ptwiki. It was not surprising to find out that I got here around a 85,00 % bad ratio (10.2015 – 04.2016) for cross-wiki uploads from pt.wikipedia.org
Ok, ptwiki is one the "bad wikis" – but who else?
I managed to adapt the Quarry for 08.03.2016 with a new column, indicating the origin of the cross-wiki upload + did the same for 15.07.–18.07.2016 for comparism.
The numbers:
(ignoring wikis with lower than 10 uploads)
| 08.03.2016 | | | | | 15.07.–18.07.2016 | | | |
| wiki | Uploads | Deleted | Bad ratio (%) | | Uploads | Deleted | Pending deletion | Bad ratio (%)* |
| arwiki | 16 | 14 | 87,50 | | 50 | 17 | 25 | 84,00 |
| cswiki | 12 | 4 | 33,33 | | 17 | 5 | 2 | 41,18 |
| dewiki | 56 | 29 | 51,79 | | 118 | 33 | 43 | 64,41 |
| elwiki | 13 | 3 | 23,08 | | 12 | 5 | 6 | 91,67 |
| enwiki | 549 | 415 | 75,59 | | 700 | 260 | 209 | 67,00 |
| eswiki | 119 | 96 | 80,67 | | 146 | 52 | 54 | 72,60 |
| frwiki | 95 | 58 | 61,05 | | 84 | 23 | 33 | 66,67 |
| huwiki | 40 | 24 | 60,00 | | 38 | 0 | 10 | 26,32 |
| itwiki | 38 | 31 | 81,59 | | 60 | 17 | 22 | 65,00 |
| jawiki | 11 | 8 | 72,73 | | 14 | 4 | 1 | 35,71 |
| mnwiki | 23 | 23 | 100,00 | | na | na | na | na |
| nlwiki | 16 | 13 | 81,25 | | 21 | 6 | 7 | 61,91 |
| plwiki | 3 | 1 | 33,33 | | 52 | 14 | 18 | 61,54 |
| ptwiki | 33 | 28 | 84,85 | | 77 | 28 | 29 | 74,03 |
| ruwiki | 58 | 46 | 79,31 | | 105 | 25 | 37 | 59,05 |
| srwiki | 10 | 9 | 90,00 | | 1 | 0 | 0 | 0,00 |
| svwiki | 10 | 5 | 50,00 | | 12 | 7 | 4 | 91,67 |
| trwiki | 21 | 15 | 71,43 | | 39 | 23 | 14 | 94,87 |
| ukwiki | 29 | 10 | 34,48 | | 29 | 18 | 2 | 68,97 |
| zhwiki | 14 | 11 | 78,57 | | 24 | 12 | 2 | 58,33 |
|
--> *) taking into account also the pending deletion
Well, eswiki was already on my "watch-list" before due to comparable cultural (let's say...) "spontaneity" as ptwiki (in other words: they don't care - and they may have heard about "copyrights" but they are ignoring it), and e.g. arwiki is probadly a typical case of "I don't care + I never heard of "copyrights". On the other hand dewiki, which has the merit of beeing probadly the most reliable wiki-version, but which is also "equipped" with some users who are falling into the group of "I don't care/I heard about it, but.../I don't know" – like also other "big" wikis like fr/it/nl/ru/etc.
Or in other words: all wikis are somehow "bad" and/or "not so good" – some more, some less. And the bad ratios from cross-wiki uploads from enwiki made by users around the world is a quite representative cross-section from user behaviour worldwide (and they confirm the bad ratios mentioned above). So, deactivating the cross-wiki upload tool only on some "critical" wikis (which could be also an option) most likely does not solve the whole mess (and...well... the users may also switch to a wiki with activated tool, gaming the system).
So, citing myself:
So, in other words: the cross-wiki-upload tool is in the vast majority a perfect tool for users who – quicky-like – wants to illustrate/promote/etc. something spontaneous on Wikipedia, ignoring further concerns about copyrights. Just grab it from Internet. It is obvious that WMF is trying to establish a somehow social media-like thing, imitating Facebook & Co... – which is going completely wrong.
And that's a global problem.
Probadly yes (but not by me).