Amount of photografed objects by uploader - WikiLovesMonuments - lists.wikimedia.org

List overview All Threads
Download

Amount of photografed objects by uploader

Statistics - list of usernames?

Monuments_database#Statistics

Андрій Бондаренко

18 Sep 2012 18 Sep '12

12:32 p.m.

Dear colleges, Do we have any tool which could count amonut of diffrent monuments, taken by uploader during a competition? For example a am interested to determine how many monuments (with different ID's) did this user<http://toolserver.org/~superzerocool/wlm/usuario.php?pais=ukraine&a… photograph. -- Regards, Andrij

Attachments:

attachment.htm (text/html — 401 bytes)

Reply

Show replies by thread

Platonides

18 Sep 18 Sep

7:31 p.m.

On 18/09/12 12:32, Андрій Бондаренко wrote:

Dear colleges, Do we have any tool which could count amonut of diffrent monuments, taken by uploader during a competition? For example a am interested to determine how many monuments (with different ID's) did this user <http://toolserver.org/~superzerocool/wlm/usuario.php?pais=ukraine&usuario=Investigatio&pagina=18

photograph.

-- Regards, Andrij

I should be able to answer that shortly, but I need hyacinth server (s4-user) fixed first. :(

Reply

Андрій Бондаренко

22 Sep 22 Sep

1:52 p.m.

OK, I'm looking forward. And our jury members have another question - do we have a tool in Commons which allow to download all the photos from a certain category, or, even better, from a certain list of files? 2012/9/18 Platonides <platonides(a)gmail.com>

On 18/09/12 12:32, Андрій Бондаренко wrote:

Dear colleges, Do we have any tool which could count amonut of diffrent monuments, taken by uploader during a competition? For example a am interested to determine how many monuments (with different ID's) did this user <

http://toolserver.org/~superzerocool/wlm/usuario.php?pais=ukraine&usuar…

photograph.

-- Regards, Andrij

I should be able to answer that shortly, but I need hyacinth server (s4-user) fixed first. :( _______________________________________________ Wiki Loves Monuments mailing list WikiLovesMonuments(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org

-- -- Андрій Бондаренко

Reply

Roel Balingit

2:20 p.m.

That's a good question, I hope we do. Roel WMPH On Sat, Sep 22, 2012 at 7:52 PM, Андрій Бондаренко < a1(a)wikimediaukraine.org.ua> wrote:

OK, I'm looking forward. And our jury members have another question - do we have a tool in Commons which allow to download all the photos from a certain category, or, even better, from a certain list of files? 2012/9/18 Platonides <platonides(a)gmail.com>

On 18/09/12 12:32, Андрій Бондаренко wrote:

Dear colleges, Do we have any tool which could count amonut of diffrent monuments, taken by uploader during a competition? For example a am interested to determine how many monuments (with different ID's) did this user <

http://toolserver.org/~superzerocool/wlm/usuario.php?pais=ukraine&usuar…

photograph.

-- Regards, Andrij

I should be able to answer that shortly, but I need hyacinth server (s4-user) fixed first. :( _______________________________________________ Wiki Loves Monuments mailing list WikiLovesMonuments(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org

-- -- Андрій Бондаренко _______________________________________________ Wiki Loves Monuments mailing list WikiLovesMonuments(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org

-- *ROEL BALINGIT* *Treasurer* *______________________________________________________________* *WIKIMEDIA PHILIPPINES* *G/F Gervacia Center, 152 Amorsolo Street, Legaspi Village, 1229 Makati City * *T: +63-2-8123277 | F: +63-2-8127177 | M: +63-917-8807635 * *W: **www.wikimedia.org.ph | E: roel.balingit(a)wikimedia.org.ph*

Reply

Platonides

9:08 p.m.

On Sat, Sep 22, 2012 at 7:52 PM, Андрій Бондаренко wrote: And our jury members have another question - do we have a tool in Commons which allow to download all the photos from a certain category, or, even better, from a certain list of files?

On 22/09/12 14:20, Roel Balingit wrote:

That's a good question, I hope we do. Roel WMPH

Sure, http://toolserver.org/~platonides/catdown/catdown.php

Reply

Platonides

28 Sep 28 Sep

10:41 p.m.

Андрій Бондаренко wrote:

Dear colleges, Do we have any tool which could count amonut of diffrent monuments, taken by uploader during a competition? For example a am interested to determine how many monuments (with different ID's) did this user <http://toolserver.org/~superzerocool/wlm/usuario.php?pais=ukraine&usuario=Investigatio&pagina=18> photograph. -- Regards, Andrij

Sorry for the late response. I needed the db to load the full upload list. Investigatio uploaded 2004 photos, being the most prolific Ucranian uploader. However, he "only" photographed 587 different monuments, being beaten by Віктор (688 monuments). If we look at the presence of those identifiers in the lists, Investigatio has one monument with a "bad" id (Crimea Sevastopol Istorychny boulevard Memorial complex-60.jpg, id 85-000-0057), but Віктор has 364 of them [1], lowering his count of "good ones" to 382 (#3). This kind of information is available for each country at http://toolserver.org/~platonides/wlm/users.php Regards 1- http://toolserver.org/~platonides/wlm/uploads.php?source=commons&author…

Reply

Андрій Бондаренко

11:08 p.m.

Thank you, Platonides! But I have a question If we look at the presence of those identifiers in the lists,

Investigatio has one monument with a "bad" id (Crimea Sevastopol Istorychny boulevard Memorial complex-60.jpg, id 85-000-0057),

Why it is bad? This monument is listed here<http://uk.wikipedia.org/wiki/%D0%92%D1%96%D0%BA%D1%96%D0%BF%D0%B5%D…8C>. -- Regards, Andrij

Reply

Strainu

11:19 p.m.

2012/9/28 Platonides <platonides(a)gmail.com>om>:

Андрій Бондаренко wrote:

Dear colleges, Do we have any tool which could count amonut of diffrent monuments, taken by uploader during a competition? For example a am interested to determine how many monuments (with different ID's) did this user <http://toolserver.org/~superzerocool/wlm/usuario.php?pais=ukraine&usuario=Investigatio&pagina=18> photograph. -- Regards, Andrij

Sorry for the late response. I needed the db to load the full upload list. Investigatio uploaded 2004 photos, being the most prolific Ucranian uploader. However, he "only" photographed 587 different monuments, being beaten by Віктор (688 monuments). If we look at the presence of those identifiers in the lists, Investigatio has one monument with a "bad" id (Crimea Sevastopol Istorychny boulevard Memorial complex-60.jpg, id 85-000-0057), but Віктор has 364 of them [1], lowering his count of "good ones" to 382 (#3). This kind of information is available for each country at http://toolserver.org/~platonides/wlm/users.php

Thanks Platonides. It would help to have a permalink for the form/GET parameters in the form. Regards, Strainu

Reply

Platonides

29 Sep 29 Sep

12:14 a.m.

On 28/09/12 23:19, Strainu wrote:

2012/9/28 Platonides:

This kind of information is available for each country at

Thanks Platonides. It would help to have a permalink for the form/GET parameters in the form. Regards, Strainu

I made it use POST on purpose, since those queries are a bit expensive, and I didn't want the app to be used more than needed. You can use GET parameters to provide the defaults, though: http://toolserver.org/~platonides/wlm/users.php?country=ua&mode=photos

Reply

Platonides

12:19 a.m.

On 28/09/12 23:08, Андрій Бондаренко wrote:

Why it is bad? This monument is listed here <http://uk.wikipedia.org/wiki/%D0%92%D1%96%D0%BA%D1%96%D0%BF%D0%B5%D0%B4%D1%96%D1%8F:%D0%92%D1%96%D0%BA%D1%96_%D0%BB%D1%8E%D0%B1%D0%B8%D1%82%D1%8C_%D0%BF%D0%B0%D0%BC%27%D1%8F%D1%82%D0%BA%D0%B8/%D0%A1%D0%B5%D0%B2%D0%B0%D1%81%D1%82%D0%BE%D0%BF%D0%BE%D0%BB%D1%8C>.

I don't know why it wasn't loaded. It isn't present in the database: mysql> SELECT id FROM monuments_all WHERE id='85-000-0057' AND country = 'ua'; Empty set (0.03 sec) mysql> SELECT id FROM `monuments_ua_(uk)` WHERE id='85-000-0057' ; Empty set (0.04 sec)

Reply

Maarten Dammers

12:27 a.m.

Op 28-9-2012 23:08, ?????? ?????????? schreef:

Thank you, Platonides! But I have a question If we look at the presence of those identifiers in the lists, Investigatio has one monument with a "bad" id (Crimea Sevastopol Istorychny boulevard Memorial complex-60.jpg, id 85-000-0057), Why it is bad? This monument is listed here <http://uk.wikipedia.org/wiki/%D0%92%D1%96%D0%BA%D1%96%D0%BF%D0%B5%D0%B4%D1%96%D1%8F:%D0%92%D1%96%D0%BA%D1%96_%D0%BB%D1%8E%D0%B1%D0%B8%D1%82%D1%8C_%D0%BF%D0%B0%D0%BC%27%D1%8F%D1%82%D0%BA%D0%B8/%D0%A1%D0%B5%D0%B2%D0%B0%D1%81%D1%82%D0%BE%D0%BF%D0%BE%D0%BB%D1%8C>.

It was added after the database update (https://uk.wikipedia.org/w/index.php?diff=10479066&oldid=10470364) so not yet in the database. Will be in the database tomorrow. Maarten

Reply

Андрій Бондаренко

2 Oct 2 Oct

10:24 a.m.

Thank you once more for this splendid tool! One more question - how quickly the results could be updated? Our participants mention that they fix incorrect ID`s but this have no effect for results of "by number of different listed identifiers" statistics. What should I answer them? 2012/9/29 Platonides <platonides(a)gmail.com>

On 28/09/12 23:19, Strainu wrote:

2012/9/28 Platonides:

This kind of information is available for each country at

Thanks Platonides. It would help to have a permalink for the form/GET parameters in the form. Regards, Strainu

I made it use POST on purpose, since those queries are a bit expensive, and I didn't want the app to be used more than needed. You can use GET parameters to provide the defaults, though: http://toolserver.org/~platonides/wlm/users.php?country=ua&mode=photos _______________________________________________ Wiki Loves Monuments mailing list WikiLovesMonuments(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org

-- -- Андрій Бондаренко

Reply

4222

days inactive

4236

days old

wikilovesmonuments@lists.wikimedia.org

Manage subscription

11 comments

6 participants

tags (0)

participants (6)

Maarten Dammers
Platonides
Roel Balingit
Strainu
Андрій Бондаренко
Андрій Бондаренко