[Clipart] stats about uploads

Mon Jan 17 13:23:41 PST 2011

Hi folk!

Again with data of 12/dic/2010, i made some stats:

total of user uploads (all format, png, svg) : 15,878,655  (1)
total of user uploads (only svg):                   13,399,497  (2)

artist  more uploaded (consider PNG and SVG):
=========================================
user_name     OD     PORC     FILES     RATIO
johnny_automatic     1837674     11.57     3547     518 download per file
Anonymous     1014888     6.39     2840     357
nicubunu     566791     3.57     1274     445
Gerald_G     465473     2.93     809     575
ryanlerch     348889     2.20     362     964
Machovka     287024     1.81     460     624
Chrisdesign     261503     1.65     268     976
liftarn     260321     1.64     333     782
molumen     259944     1.64     271     959
warszawianka     221324     1.39     548     404
rg1024     198725     1.25     359     554
ArtFavor     189209     1.19     1004     188
papapishu     189132     1.19     392     482
inky2010     184757     1.16     525     352
zeimusu     154229     0.97     194     795
yves_guillou     148600     0.94     400     372
jean_victor_balin     147421     0.93     320     461
rejon     132341     0.83     1296     102
mystica     117743     0.74     212     555
Peileppe     115617     0.73     126     918
pitr     111383     0.70     185     602
shokunin     98899     0.62     219     452
laobc     98035     0.62     208     471
netalloy     93916     0.59     267     352
cibo00     89611     0.56     185     484

conclusion: johnny_automatic is god!

ARTISTS BY RATIO ( number of uploads / number of files)
============================================

BEST(4).
username RATIO FILES
----------------------------
rgtaylor_csc     6305     7
axcesar     4846     2
ajith     4623     1
gabe_anguiano     4520     1
Darth_Gimp     4410     5
bubba     4268     1
juanjo     4074     4
no_hope     4039     1
adolflow     3755     1
Fadookie     3716     1
hce     3708     1
Voxxi     3584     1
brucewestfall     3207     1
stephantom     3166     1
msewtz     3162     1
mola     3112     1
Lynx     3077     1
Ts-Pc     2981     1
dokuro     2981     1
manders2006     2944     1
hatemeidc7     2929     1
lagartoflojo     2911     1
grimgiant     2900     2
xxv     2898     1
gopher     2888     3

Conclusion: sometime less is more..

WORST (5)
user_name     RATIO
---------------------------
xavowski     7
lemasney     7
yodomark     15
Ulomar     16
Spirit_Walker     16
nascent26     30
yasinergene     35
Lone Coder     38
sitphong     62
kdegames     62
radiopiromania     62
elmodos     63
miltiadis     73
matheus     73
Rombicovh     84
CrLz     89
majo     90
stvdns     90
vicing     91
Ariniko     94
morits     96
schicchero     97
jars     102
rejon     102
arnelsx     102

Conclusion: fortunately, Rejon is more better community manager than drawner
;-)

UPLOADS per DAY (6)

the num of uploads is accumulative (old clip arts have more uploads)
cliparts by num_upload divided by days in open-clipart (sorry but we have
not upload date  before 2006/2/11 (aprox 5,000 cliparts)

user    clipart-id    nº of download per day
=================================
fitorec     86989     191
leandrosciola at gmail.com     63763     49
jaschon     92725     48
inky2010     86479     39
Martouf     81865     36
inky2010     93463     36
inky2010     93445     35
inky2010     87949     31
vwanweb     81331     28
inky2010     94393     25
Ts-Pc     85075     24
russel     74179     23
mireille     93655     23
rg1024     94723     23
luciancaetano     63895     23
shokunin     68317     22
gustavorezende     74497     22
netalloy     88201     22
inky2010     94459     21
14thWarrior     83479     21
mola     79399     20
netalloy     87961     20
netalloy     88753     20
mireille     93487     20
inky2010     94243     20
leandrosciola at gmail.com     64771     19
rones     88717     18
inky2010     90895     18
momoko     8780     18
rones     68203     18

conclusion: leandrosciola!! inky2010!! netalloy!!

SQL ( before chovny ask it ;-)

(1) select sum(file_num_download) from ocal_files where
upload_config='media'
(2) select sum(file_num_download) from ocal_files where
upload_config='media' and filename rlike ".svg"

(3) select user_name, sum(file_num_download) as OD, round(
(sum(file_num_download)/15878655)*100,2) as PORC, count(id) as FILES,
round(sum(file_num_download)/count(id),0) as RATIO from ocal_files where
upload_config='media' group by user_name order by OD Desc limit 25

(4) select user_name, round(sum(file_num_download)/count(id),0) as RATIO,
count(id) AS FILES from ocal_files where upload_config='media' group by
user_name order by RATIO Desc limit 25

(5) select user_name, round(sum(file_num_download)/count(id),0) as RATIO
from ocal_files where upload_config='media' group by user_name order by
RATIO ASC limit 25

(6) SELECT user_name,id, round(file_num_download /  datediff ( curdate(),
upload_date ),0) as RATIO from ocal_files WHERE upload_date> 0 Order by
RATIO DESC
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freedesktop.org/archives/clipart/attachments/20110117/9c6e2ed5/attachment.html>