Hi,
Wiki Loves Monuments is one of my favorite events related to Wikipedia. Through this event we are getting a huge amount of good photographs. And few days ago we informed that, though this contest we got a big number of Quality images.
I just curious to know is there any statics available (or possible to prepare) about the usage of the contest photographs in wiki projects. What is the number of photographs used in the different language versions of Wikipedia or other sister projects?
* -- **Nasir Khan Saikat* http://profiles.google.com/nasir8891 www.nasirkhn.com
Hi,http://toolserver.org/~prolineserver/glamorous/glamorous.php does a good job of looking that up. http://toolserver.org/~prolineserver/glamorous/glamorous.php?doit=1&cate... will show you all images from the Swedish category for 2012 and what articles they are used in. On the bottom of the page you can also see the number of page views.
/axel ====================================
Axel PetterssonProjektledare GLAM/OutreachWikimedia Sverige jobb/work +46 (0)733 96 55 65 axel.pettersson@wikimedia.se ojobb/non work +46 (0)730 59 58 13
haxpett@hotmail.com
Twitter: @Haxpett Stöd fri kunskap, bli medlem i Wikimedia Sverige.Läs mer på donera.wikimedia.se
From: nasir8891@gmail.com Date: Tue, 5 Feb 2013 15:13:00 +0600 To: wikilovesmonuments@lists.wikimedia.org Subject: [Wiki Loves Monuments] What is the number of photographs used in Wikipedia
Hi,
Wiki Loves Monuments is one of my favorite events related to Wikipedia. Through this event we are getting a huge amount of good photographs. And few days ago we informed that, though this contest we got a big number of Quality images.
I just curious to know is there any statics available (or possible to prepare) about the usage of the contest photographs in wiki projects. What is the number of photographs used in the different language versions of Wikipedia or other sister projects?
-- Nasir Khan Saikat
www.nasirkhn.com
_______________________________________________ Wiki Loves Monuments mailing list WikiLovesMonuments@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org
Axel Pettersson, 05/02/2013 10:57:
Hi, http://toolserver.org/~prolineserver/glamorous/glamorous.php does a good job of looking that up.
However, if used for the general category it may easily kill stats.grok.se (if magnus is not still blocked). :) Here are the results, to avoid overloading it. Winner is https://commons.wikimedia.org/wiki/File:Loos-en-Gohelle_-_Fosse_n%C2%B0_11_-_19_des_mines_de_Lens_%28085%29.JPG with 335 usages.
Nemo
----
Results
Category "Images from Wiki Loves Monuments 2012" has 365636 images. Site Images used de.wikipedia 15952 en.wikipedia 13072 fr.wikipedia 8892 cs.wikipedia 6634 ca.wikipedia 5481 nl.wikipedia 4475 ro.wikipedia 1957 pl.wikipedia 1629 ru.wikipedia 1250 es.wikipedia 1132 sv.wikipedia 1092 et.wikipedia 1062 uk.wikipedia 892 be.wikipedia 831 it.wikipedia 616 sr.wikipedia 584 sk.wikipedia 520 ua.wikimedia 517 no.wikipedia 373 hu.wikipedia 310 he.wikipedia 255 da.wikipedia 246 pt.wikipedia 237 lt.wikipedia 173 be_x_old.wikipedia 159 lb.wikipedia 143 fi.wikipedia 127 hr.wikipedia 108 ja.wikipedia 88 en.wikivoyage 86 eo.wikipedia 81 meta.wikipedia 80 lv.wikipedia 72 vi.wikipedia 65 bg.wikipedia 61 nn.wikipedia 58 sh.wikipedia 54 gl.wikipedia 53 zh.wikipedia 50 pl.wikimedia 40 te.wikipedia 38 af.wikipedia 38 als.wikipedia 38 id.wikipedia 37 ml.wikipedia 37 tr.wikipedia 36 nds.wikipedia 35 ka.wikipedia 31 la.wikipedia 31 de.wikivoyage 29 es.wikinews 28 oc.wikipedia 28 ru.wikinews 26 es.wikivoyage 26 mhr.wikipedia 25 cv.wikipedia 24 vo.wikipedia 24 ms.wikipedia 23 pl.wikinews 22 fa.wikipedia 21 el.wikipedia 21 br.wikipedia 21 kl.wikipedia 20 an.wikipedia 19 sr.wikinews 18 simple.wikipedia 18 sa.wikipedia 18 mk.wikipedia 17 fiu_vro.wikipedia 16 az.wikipedia 14 fr.wikivoyage 14 th.wikipedia 13 hy.wikipedia 13 eu.wikipedia 13 pl.wiktionary 13 ar.wikipedia 13 uz.wikipedia 12 outreach.wikipedia 12 ru.wikivoyage 12 vep.wikipedia 11 ko.wikipedia 11 id.wiktionary 10 mr.wikipedia 10 ta.wikipedia 9 lmo.wikipedia 9 war.wikipedia 9 qu.wikipedia 9 rs.wikimedia 9 io.wikipedia 9 sco.wikipedia 8 os.wikipedia 8 pih.wikipedia 8 sq.wikipedia 8 udm.wikipedia 8 ie.wikipedia 8 mrj.wikipedia 8 incubator.wikipedia 7 tt.wikipedia 7 vls.wikipedia 7 nl.wikivoyage 7 or.wikipedia 7 it.wikivoyage 7 as.wikipedia 7 kn.wikipedia 7 de.wikibooks 6 de.wikiversity 6 bar.wikipedia 6 sl.wikipedia 6 hi.wikipedia 5 pt.wikivoyage 5 ky.wikipedia 5 ilo.wikipedia 5 co.wikimedia 4 is.wikipedia 4 bs.wikipedia 4 xmf.wikipedia 4 pag.wikipedia 4 wikimania2008.wikipedia 4 tl.wikipedia 4 se.wikimedia 3 te.wiktionary 3 bat_smg.wikipedia 3 mn.wikipedia 3 en.wikibooks 3 sw.wikipedia 3 sv.wikivoyage 3 fy.wikipedia 3 ta.wiktionary 2 ve.wikipedia 2 ur.wikipedia 2 es.wikiquote 2 zea.wikipedia 2 krc.wikipedia 2 test.wikipedia 2 arz.wikipedia 2 cy.wikipedia 2 hif.wikipedia 2 en.wikiquote 2 kk.wikipedia 2 pms.wikipedia 2 vec.wikipedia 2 szl.wikipedia 2 en.wiktionary 2 uk.wikinews 2 pl.wikiquote 1 fr.wikibooks 1 readerfeedback_labs.wikimedia 1 sah.wikipedia 1 km.wikipedia 1 lez.wikipedia 1 flaggedrevs_labs.wikimedia 1 wa.wikipedia 1 diq.wikipedia 1 am.wikipedia 1 ext.wikipedia 1 gd.wikipedia 1 es.wikibooks 1 he.wikiquote 1 nap.wikipedia 1 ckb.wikipedia 1 th.wiktionary 1 zu.wikipedia 1 roa_tara.wikipedia 1 se.wikipedia 1 gu.wikipedia 1 my.wikipedia 1 ru.wiktionary 1 glk.wikipedia 1 ku.wikipedia 1 cbk_zam.wikipedia 1 bn.wikipedia 1 pcd.wikipedia 1 kv.wikipedia 1 hsb.wikipedia 1 gn.wikipedia 1 kbd.wikipedia 1 yi.wikipedia 1 lad.wikipedia 1 li.wikipedia 1 mx.wikimedia 1 cs.wikinews 1 pl.wikibooks 1 nv.wikipedia 1 az.wiktionary 1 bo.wikipedia 1 ug.wikipedia 1 kw.wikipedia 1 ia.wikipedia 1 Total image usages 70783 Distinct images used 54282 (14.85% of all images in category)
Thanks for the help :)
* -- **Nasir Khan Saikat* http://profiles.google.com/nasir8891 www.nasirkhn.com
On Tue, Feb 5, 2013 at 4:49 PM, Federico Leva (Nemo) nemowiki@gmail.comwrote:
Axel Pettersson, 05/02/2013 10:57:
Hi,
http://toolserver.org/~**prolineserver/glamorous/**glamorous.phphttp://toolserver.org/~prolineserver/glamorous/glamorous.phpdoes a good job of looking that up.
However, if used for the general category it may easily kill stats.grok.se(if magnus is not still blocked). :) Here are the results, to avoid overloading it. Winner is <https://commons.wikimedia.**org/wiki/File:Loos-en-Gohelle_** -_Fosse_n%C2%B0_11_-_19_des_**mines_de_Lens_%28085%29.JPGhttps://commons.wikimedia.org/wiki/File:Loos-en-Gohelle_-_Fosse_n%C2%B0_11_-_19_des_mines_de_Lens_%28085%29.JPG> with 335 usages.
Nemo
Results
Category "Images from Wiki Loves Monuments 2012" has 365636 images. Site Images used de.wikipedia 15952 en.wikipedia 13072 fr.wikipedia 8892 cs.wikipedia 6634 ca.wikipedia 5481 nl.wikipedia 4475 ro.wikipedia 1957 pl.wikipedia 1629 ru.wikipedia 1250 es.wikipedia 1132 sv.wikipedia 1092 et.wikipedia 1062 uk.wikipedia 892 be.wikipedia 831 it.wikipedia 616 sr.wikipedia 584 sk.wikipedia 520 ua.wikimedia 517 no.wikipedia 373 hu.wikipedia 310 he.wikipedia 255 da.wikipedia 246 pt.wikipedia 237 lt.wikipedia 173 be_x_old.wikipedia 159 lb.wikipedia 143 fi.wikipedia 127 hr.wikipedia 108 ja.wikipedia 88 en.wikivoyage 86 eo.wikipedia 81 meta.wikipedia 80 lv.wikipedia 72 vi.wikipedia 65 bg.wikipedia 61 nn.wikipedia 58 sh.wikipedia 54 gl.wikipedia 53 zh.wikipedia 50 pl.wikimedia 40 te.wikipedia 38 af.wikipedia 38 als.wikipedia 38 id.wikipedia 37 ml.wikipedia 37 tr.wikipedia 36 nds.wikipedia 35 ka.wikipedia 31 la.wikipedia 31 de.wikivoyage 29 es.wikinews 28 oc.wikipedia 28 ru.wikinews 26 es.wikivoyage 26 mhr.wikipedia 25 cv.wikipedia 24 vo.wikipedia 24 ms.wikipedia 23 pl.wikinews 22 fa.wikipedia 21 el.wikipedia 21 br.wikipedia 21 kl.wikipedia 20 an.wikipedia 19 sr.wikinews 18 simple.wikipedia 18 sa.wikipedia 18 mk.wikipedia 17 fiu_vro.wikipedia 16 az.wikipedia 14 fr.wikivoyage 14 th.wikipedia 13 hy.wikipedia 13 eu.wikipedia 13 pl.wiktionary 13 ar.wikipedia 13 uz.wikipedia 12 outreach.wikipedia 12 ru.wikivoyage 12 vep.wikipedia 11 ko.wikipedia 11 id.wiktionary 10 mr.wikipedia 10 ta.wikipedia 9 lmo.wikipedia 9 war.wikipedia 9 qu.wikipedia 9 rs.wikimedia 9 io.wikipedia 9 sco.wikipedia 8 os.wikipedia 8 pih.wikipedia 8 sq.wikipedia 8 udm.wikipedia 8 ie.wikipedia 8 mrj.wikipedia 8 incubator.wikipedia 7 tt.wikipedia 7 vls.wikipedia 7 nl.wikivoyage 7 or.wikipedia 7 it.wikivoyage 7 as.wikipedia 7 kn.wikipedia 7 de.wikibooks 6 de.wikiversity 6 bar.wikipedia 6 sl.wikipedia 6 hi.wikipedia 5 pt.wikivoyage 5 ky.wikipedia 5 ilo.wikipedia 5 co.wikimedia 4 is.wikipedia 4 bs.wikipedia 4 xmf.wikipedia 4 pag.wikipedia 4 wikimania2008.wikipedia 4 tl.wikipedia 4 se.wikimedia 3 te.wiktionary 3 bat_smg.wikipedia 3 mn.wikipedia 3 en.wikibooks 3 sw.wikipedia 3 sv.wikivoyage 3 fy.wikipedia 3 ta.wiktionary 2 ve.wikipedia 2 ur.wikipedia 2 es.wikiquote 2 zea.wikipedia 2 krc.wikipedia 2 test.wikipedia 2 arz.wikipedia 2 cy.wikipedia 2 hif.wikipedia 2 en.wikiquote 2 kk.wikipedia 2 pms.wikipedia 2 vec.wikipedia 2 szl.wikipedia 2 en.wiktionary 2 uk.wikinews 2 pl.wikiquote 1 fr.wikibooks 1 readerfeedback_labs.wikimedia 1 sah.wikipedia 1 km.wikipedia 1 lez.wikipedia 1 flaggedrevs_labs.wikimedia 1 wa.wikipedia 1 diq.wikipedia 1 am.wikipedia 1 ext.wikipedia 1 gd.wikipedia 1 es.wikibooks 1 he.wikiquote 1 nap.wikipedia 1 ckb.wikipedia 1 th.wiktionary 1 zu.wikipedia 1 roa_tara.wikipedia 1 se.wikipedia 1 gu.wikipedia 1 my.wikipedia 1 ru.wiktionary 1 glk.wikipedia 1 ku.wikipedia 1 cbk_zam.wikipedia 1 bn.wikipedia 1 pcd.wikipedia 1 kv.wikipedia 1 hsb.wikipedia 1 gn.wikipedia 1 kbd.wikipedia 1 yi.wikipedia 1 lad.wikipedia 1 li.wikipedia 1 mx.wikimedia 1 cs.wikinews 1 pl.wikibooks 1 nv.wikipedia 1 az.wiktionary 1 bo.wikipedia 1 ug.wikipedia 1 kw.wikipedia 1 ia.wikipedia 1 Total image usages 70783 Distinct images used 54282 (14.85% of all images in category)
______________________________**_________________ Wiki Loves Monuments mailing list WikiLovesMonuments@lists.**wikimedia.orgWikiLovesMonuments@lists.wikimedia.org https://lists.wikimedia.org/**mailman/listinfo/**wikilovesmonumentshttps://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.**org http://www.wikilovesmonuments.org
just for comparison: what is the percentage for the whole of wikimedia commons?
2013/2/5 Nasir Khan nasir8891@gmail.com
Thanks for the help :)
-- **Nasir Khan Saikat* http://profiles.google.com/nasir8891 www.nasirkhn.com
On Tue, Feb 5, 2013 at 4:49 PM, Federico Leva (Nemo) nemowiki@gmail.comwrote:
Axel Pettersson, 05/02/2013 10:57:
Hi,
http://toolserver.org/~**prolineserver/glamorous/**glamorous.phphttp://toolserver.org/~prolineserver/glamorous/glamorous.phpdoes a good job of looking that up.
However, if used for the general category it may easily kill stats.grok.se (if magnus is not still blocked). :) Here are the results, to avoid overloading it. Winner is <https://commons.wikimedia.**org/wiki/File:Loos-en-Gohelle_** -_Fosse_n%C2%B0_11_-_19_des_**mines_de_Lens_%28085%29.JPGhttps://commons.wikimedia.org/wiki/File:Loos-en-Gohelle_-_Fosse_n%C2%B0_11_-_19_des_mines_de_Lens_%28085%29.JPG> with 335 usages.
Nemo
Results
Category "Images from Wiki Loves Monuments 2012" has 365636 images. Site Images used de.wikipedia 15952 en.wikipedia 13072 fr.wikipedia 8892 cs.wikipedia 6634 ca.wikipedia 5481 nl.wikipedia 4475 ro.wikipedia 1957 pl.wikipedia 1629 ru.wikipedia 1250 es.wikipedia 1132 sv.wikipedia 1092 et.wikipedia 1062 uk.wikipedia 892 be.wikipedia 831 it.wikipedia 616 sr.wikipedia 584 sk.wikipedia 520 ua.wikimedia 517 no.wikipedia 373 hu.wikipedia 310 he.wikipedia 255 da.wikipedia 246 pt.wikipedia 237 lt.wikipedia 173 be_x_old.wikipedia 159 lb.wikipedia 143 fi.wikipedia 127 hr.wikipedia 108 ja.wikipedia 88 en.wikivoyage 86 eo.wikipedia 81 meta.wikipedia 80 lv.wikipedia 72 vi.wikipedia 65 bg.wikipedia 61 nn.wikipedia 58 sh.wikipedia 54 gl.wikipedia 53 zh.wikipedia 50 pl.wikimedia 40 te.wikipedia 38 af.wikipedia 38 als.wikipedia 38 id.wikipedia 37 ml.wikipedia 37 tr.wikipedia 36 nds.wikipedia 35 ka.wikipedia 31 la.wikipedia 31 de.wikivoyage 29 es.wikinews 28 oc.wikipedia 28 ru.wikinews 26 es.wikivoyage 26 mhr.wikipedia 25 cv.wikipedia 24 vo.wikipedia 24 ms.wikipedia 23 pl.wikinews 22 fa.wikipedia 21 el.wikipedia 21 br.wikipedia 21 kl.wikipedia 20 an.wikipedia 19 sr.wikinews 18 simple.wikipedia 18 sa.wikipedia 18 mk.wikipedia 17 fiu_vro.wikipedia 16 az.wikipedia 14 fr.wikivoyage 14 th.wikipedia 13 hy.wikipedia 13 eu.wikipedia 13 pl.wiktionary 13 ar.wikipedia 13 uz.wikipedia 12 outreach.wikipedia 12 ru.wikivoyage 12 vep.wikipedia 11 ko.wikipedia 11 id.wiktionary 10 mr.wikipedia 10 ta.wikipedia 9 lmo.wikipedia 9 war.wikipedia 9 qu.wikipedia 9 rs.wikimedia 9 io.wikipedia 9 sco.wikipedia 8 os.wikipedia 8 pih.wikipedia 8 sq.wikipedia 8 udm.wikipedia 8 ie.wikipedia 8 mrj.wikipedia 8 incubator.wikipedia 7 tt.wikipedia 7 vls.wikipedia 7 nl.wikivoyage 7 or.wikipedia 7 it.wikivoyage 7 as.wikipedia 7 kn.wikipedia 7 de.wikibooks 6 de.wikiversity 6 bar.wikipedia 6 sl.wikipedia 6 hi.wikipedia 5 pt.wikivoyage 5 ky.wikipedia 5 ilo.wikipedia 5 co.wikimedia 4 is.wikipedia 4 bs.wikipedia 4 xmf.wikipedia 4 pag.wikipedia 4 wikimania2008.wikipedia 4 tl.wikipedia 4 se.wikimedia 3 te.wiktionary 3 bat_smg.wikipedia 3 mn.wikipedia 3 en.wikibooks 3 sw.wikipedia 3 sv.wikivoyage 3 fy.wikipedia 3 ta.wiktionary 2 ve.wikipedia 2 ur.wikipedia 2 es.wikiquote 2 zea.wikipedia 2 krc.wikipedia 2 test.wikipedia 2 arz.wikipedia 2 cy.wikipedia 2 hif.wikipedia 2 en.wikiquote 2 kk.wikipedia 2 pms.wikipedia 2 vec.wikipedia 2 szl.wikipedia 2 en.wiktionary 2 uk.wikinews 2 pl.wikiquote 1 fr.wikibooks 1 readerfeedback_labs.wikimedia 1 sah.wikipedia 1 km.wikipedia 1 lez.wikipedia 1 flaggedrevs_labs.wikimedia 1 wa.wikipedia 1 diq.wikipedia 1 am.wikipedia 1 ext.wikipedia 1 gd.wikipedia 1 es.wikibooks 1 he.wikiquote 1 nap.wikipedia 1 ckb.wikipedia 1 th.wiktionary 1 zu.wikipedia 1 roa_tara.wikipedia 1 se.wikipedia 1 gu.wikipedia 1 my.wikipedia 1 ru.wiktionary 1 glk.wikipedia 1 ku.wikipedia 1 cbk_zam.wikipedia 1 bn.wikipedia 1 pcd.wikipedia 1 kv.wikipedia 1 hsb.wikipedia 1 gn.wikipedia 1 kbd.wikipedia 1 yi.wikipedia 1 lad.wikipedia 1 li.wikipedia 1 mx.wikimedia 1 cs.wikinews 1 pl.wikibooks 1 nv.wikipedia 1 az.wiktionary 1 bo.wikipedia 1 ug.wikipedia 1 kw.wikipedia 1 ia.wikipedia 1 Total image usages 70783 Distinct images used 54282 (14.85% of all images in category)
______________________________**_________________ Wiki Loves Monuments mailing list WikiLovesMonuments@lists.**wikimedia.orgWikiLovesMonuments@lists.wikimedia.org https://lists.wikimedia.org/**mailman/listinfo/**wikilovesmonumentshttps://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.**org http://www.wikilovesmonuments.org
Wiki Loves Monuments mailing list WikiLovesMonuments@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org
2013/2/5 Lodewijk lodewijk@effeietsanders.org
just for comparison: what is the percentage for the whole of wikimedia commons?
Unless I missed something (my SQL-fu is *very* rustry), around 8,7 million files (=53.6% of Commons) are used at least once in the main space of a Wikimedia project (excluding meta).
mysql> SELECT /* SLOW_OK */ COUNT(DISTINCT gil_to) -> FROM `globalimagelinks` -> WHERE gil_page_namespace_id = 0 AND (gil_wiki!='metawiki'); +------------------------+ | COUNT(DISTINCT gil_to) | +------------------------+ | 8710633 | +------------------------+ 1 row in set (1 hour 10 min 51.32 sec)
I am not sure if this looks legit or if I definitely missed something.
wikilovesmonuments@lists.wikimedia.org