Hi all,
I would like to know how many pics from this award category are coming from each participant country
https://commons.wikimedia.org/wiki/Category:WWI_related_images_from_Wiki_Lov...
could someone help me on this? Is there any tool to calculate it?
Thanks in advance,
Cheers,
Àlex @kippelboy
Hey Alex,
I think http://tools.wmflabs.org/catscan2/quick_intersection.php is the answer to your prayers ;-) you'll have to do the calculation 50 times perhaps, but it should do the trick.
By the way, when do you plan to have the results? Will they be there before the end of November? In that case we can still include them in the Jury Report as one of the Special Awards.
Best, Lodewijk
2013/11/4 Àlex Hinojo alexhinojo@gmail.com
Hi all,
I would like to know how many pics from this award category are coming from each participant country
https://commons.wikimedia.org/wiki/Category:WWI_related_images_from_Wiki_Lov...
could someone help me on this? Is there any tool to calculate it?
Thanks in advance,
Cheers,
Àlex @kippelboy
Wiki Loves Monuments mailing list WikiLovesMonuments@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org
Running it 50 times:
* Armenia 37 * Austria 35 * Belgium 22 * Canada 3 * France 196 * Germany 159 * Israel 2 * Italy 4 * Jordan 15 * The Nederlands 37 * Poland 737 * Romania 223 * Russia 214 * Serbia 19 * Slovakia 18 * South Africa 386 * Spain 11 * Ukraine 54 * UK 61 * US 1 * Uruguay 1
I should review my history textbook :-/
Moroever, there are 170 images not included in any country.
Vicenç
From: lodewijk@effeietsanders.org Date: Mon, 4 Nov 2013 11:39:53 +0100 To: wikilovesmonuments@lists.wikimedia.org Subject: Re: [Wiki Loves Monuments] Wiki Loves Monuments Europeana WW1 related award
Hey Alex, I think http://tools.wmflabs.org/catscan2/quick_intersection.php is the answer to your prayers ;-) you'll have to do the calculation 50 times perhaps, but it should do the trick.
By the way, when do you plan to have the results? Will they be there before the end of November? In that case we can still include them in the Jury Report as one of the Special Awards.
Best,Lodewijk
2013/11/4 Àlex Hinojo alexhinojo@gmail.com
Hi all,
I would like to know how many pics from this award category are coming from each participant country
https://commons.wikimedia.org/wiki/Category:WWI_related_images_from_Wiki_Lov...
could someone help me on this? Is there any tool to calculate it?
Thanks in advance,
Cheers,
Àlex @kippelboy
_______________________________________________
Wiki Loves Monuments mailing list
WikiLovesMonuments@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
http://www.wikilovesmonuments.org
_______________________________________________ Wiki Loves Monuments mailing list WikiLovesMonuments@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org
Thanks Vicenç and Lodewijk!
Regarding the winners announcement: we are on the finalist part, with a selection of 25 best images. Like previous editions we will make a public voting poll system (probably FB, Blog or similar) during the forthcoming days. Hope that we can have the winner before the end of November. :)
2013/11/4 Vicenç Riullop vriullop@hotmail.com
Running it 50 times:
- Armenia 37
- Austria 35
- Belgium 22
- Canada 3
- France 196
- Germany 159
- Israel 2
- Italy 4
- Jordan 15
- The Nederlands 37
- Poland 737
- Romania 223
- Russia 214
- Serbia 19
- Slovakia 18
- South Africa 386
- Spain 11
- Ukraine 54
- UK 61
- US 1
- Uruguay 1
I should review my history textbook :-/
Moroever, there are 170 images not included in any country.
Vicenç
From: lodewijk@effeietsanders.org Date: Mon, 4 Nov 2013 11:39:53 +0100 To: wikilovesmonuments@lists.wikimedia.org Subject: Re: [Wiki Loves Monuments] Wiki Loves Monuments Europeana WW1 related award
Hey Alex,
I think http://tools.wmflabs.org/catscan2/quick_intersection.php is the answer to your prayers ;-) you'll have to do the calculation 50 times perhaps, but it should do the trick.
By the way, when do you plan to have the results? Will they be there before the end of November? In that case we can still include them in the Jury Report as one of the Special Awards.
Best, Lodewijk
2013/11/4 Àlex Hinojo alexhinojo@gmail.com
Hi all,
I would like to know how many pics from this award category are coming from each participant country
https://commons.wikimedia.org/wiki/Category:WWI_related_images_from_Wiki_Lov...
could someone help me on this? Is there any tool to calculate it?
Thanks in advance,
Cheers,
Àlex @kippelboy
Wiki Loves Monuments mailing list WikiLovesMonuments@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org
_______________________________________________ Wiki Loves Monuments mailing list WikiLovesMonuments@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org
Wiki Loves Monuments mailing list WikiLovesMonuments@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org
El 04/11/13 11:36, Àlex Hinojo escribió:
Hi all,
I would like to know how many pics from this award category are coming from each participant country
https://commons.wikimedia.org/wiki/Category:WWI_related_images_from_Wiki_Lov...
could someone help me on this? Is there any tool to calculate it?
select wlm_country, count(*) as count from categorylinks join u_platonides_wlm_p.wlm2013 ON (cl_from=wlm_page) where cl_type='file' and cl_to='WWI_related_images_from_Wiki_Loves_Monuments_2013' GROUP BY wlm_Country ;
+-------------+-------+ | wlm_country | count | +-------------+-------+ | am | 37 | | at | 35 | | az | 3 | | be | 22 | | ca | 3 | | cz | 9 | | de | 159 | | es | 11 | | fr | 216 | | gb | 61 | | hu | 1 | | il | 2 | | in | 39 | | it | 4 | | jo | 16 | | nl | 37 | | pl | 722 | | ro | 222 | | rs | 19 | | ru | 214 | | sk | 18 | | ua | 54 | | us | 1 | | uy | 1 | | za | 385 | +-------------+-------+
wikilovesmonuments@lists.wikimedia.org