Commons categories now in the database

List overview All Threads
Download

newer

older

Polish Railways Open exhibition

1892 WLM Calendars are in the mail

Maarten Dammers

13 Jan 2013 13 Jan '13

11:52 p.m.

Hi everyone, I noticed quite a few Wikipedia's included a Commons link in their monument lists (almost 40.000 entries at https://commons.wikimedia.org/wiki/Commons:Monuments_database/Statistics). I went ahead and included a new field "commonscat" for each entry in the main table. For existing entries I mapped it, for all the other lists I added commonscat as a field. It's now being used by the categorization bot. For example with https://nl.wikipedia.org/w/index.php?title=Lijst_van_rijksmonumenten_aan_de… I told the bot that all images with id "5940" should be put in https://commons.wikimedia.org/wiki/Category:Nieuwe_Kerk_%28Amsterdam%29 . I haven't actually changed the template at the Dutch Wikipedia yet, that's something for later. https://commons.wikimedia.org/wiki/Commons:Monuments_database/Categorizatio… has been updated. Maarten

Show replies by date

Vicenç Riullop

14 Jan 14 Jan

11:16 a.m.

Great, this is a nice improvement. The parameter is usefull in lists for a link to "see more photos of this monument" and it facilitates a more precise categorization of new photos. Vicenç

...

Date: Sun, 13 Jan 2013 23:52:29 +0100 From: maarten(a)mdammers.nl To: wikilovesmonuments(a)lists.wikimedia.org Subject: [Wiki Loves Monuments] Commons categories now in the database Hi everyone, I noticed quite a few Wikipedia's included a Commons link in their monument lists (almost 40.000 entries at https://commons.wikimedia.org/wiki/Commons:Monuments_database/Statistics). I went ahead and included a new field "commonscat" for each entry in the main table. For existing entries I mapped it, for all the other lists I added commonscat as a field. It's now being used by the categorization bot. For example with https://nl.wikipedia.org/w/index.php?title=Lijst_van_rijksmonumenten_aan_de… I told the bot that all images with id "5940" should be put in https://commons.wikimedia.org/wiki/Category:Nieuwe_Kerk_%28Amsterdam%29 . I haven't actually changed the template at the Dutch Wikipedia yet, that's something for later. https://commons.wikimedia.org/wiki/Commons:Monuments_database/Categorizatio… has been updated. Maarten _______________________________________________ Wiki Loves Monuments mailing list WikiLovesMonuments(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org

Ynhockey

8:32 p.m.

Thanks! This has been a requested feature for ages, it will really help. —Ynhockey. On Mon, Jan 14, 2013 at 12:16 PM, Vicenç Riullop <vriullop(a)hotmail.com>wrote;wrote:

...

Great, this is a nice improvement. The parameter is usefull in lists for a link to "see more photos of this monument" and it facilitates a more precise categorization of new photos. Vicenç

Date: Sun, 13 Jan 2013 23:52:29 +0100 From: maarten(a)mdammers.nl To: wikilovesmonuments(a)lists.wikimedia.org Subject: [Wiki Loves Monuments] Commons categories now in the database

Hi everyone, I noticed quite a few Wikipedia's included a Commons link in their monument lists (almost 40.000 entries at https://commons.wikimedia.org/wiki/Commons:Monuments_database/Statistics).

I went ahead and included a new field "commonscat" for each entry in the main table. For existing entries I mapped it, for all the other lists I added commonscat as a field. It's now being used by the categorization

bot.

For example with

https://nl.wikipedia.org/w/index.php?title=Lijst_van_rijksmonumenten_aan_de…

I told the bot that all images with id "5940" should be put in https://commons.wikimedia.org/wiki/Category:Nieuwe_Kerk_%28Amsterdam%29 . I haven't actually changed the template at the Dutch Wikipedia yet, that's something for later.

https://commons.wikimedia.org/wiki/Commons:Monuments_database/Categorizatio…

has been updated. Maarten _______________________________________________ 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

André Costa

16 Jan 16 Jan

12:43 a.m.

Would it be possible to populate the same field using the commons templates if they are present used on a (unique) category page? I.e. as is done at Category:Aaltohuset <https://commons.wikimedia.org/wiki/Category:Aaltohuset> . Cheers, André On 14 January 2013 19:32, Ynhockey <ynhockey(a)gmail.com> wrote:

...

Thanks! This has been a requested feature for ages, it will really help. —Ynhockey. On Mon, Jan 14, 2013 at 12:16 PM, Vicenç Riullop <vriullop(a)hotmail.com>wrote;wrote:

Great, this is a nice improvement. The parameter is usefull in lists for a link to "see more photos of this monument" and it facilitates a more precise categorization of new photos. Vicenç

Date: Sun, 13 Jan 2013 23:52:29 +0100 From: maarten(a)mdammers.nl To: wikilovesmonuments(a)lists.wikimedia.org Subject: [Wiki Loves Monuments] Commons categories now in the database

Hi everyone, I noticed quite a few Wikipedia's included a Commons link in their monument lists (almost 40.000 entries at

https://commons.wikimedia.org/wiki/Commons:Monuments_database/Statistics).

I went ahead and included a new field "commonscat" for each entry in

the

main table. For existing entries I mapped it, for all the other lists I added commonscat as a field. It's now being used by the categorization

bot.

For example with

https://nl.wikipedia.org/w/index.php?title=Lijst_van_rijksmonumenten_aan_de…

https://commons.wikimedia.org/wiki/Commons:Monuments_database/Categorizatio…

Maarten Dammers

7:25 p.m.

Hi André, Op 16-1-2013 0:43, André Costa schreef:

...

Technically yes, but I'm afraid of mistakes so I'm not doing it using a bot. I do plan to run some queries to suggest links to create (see .sql for the query): * http://toolserver.org/~multichill/temp/queries/erfgoed/rm_top_images.txt : List of tagged Rijksmonumenten images by number of images with the same id. This can be used to suggest new categories to be created * http://toolserver.org/~multichill/temp/queries/erfgoed/rm_commonscat_to_lin… : List of categories that are tagged with a Rijksmonumenten template. This can be combined with the database to suggest missing links to create just like https://commons.wikimedia.org/wiki/Commons:Monuments_database/Unused_images Maarten

André Costa

19 Jan 19 Jan

5:21 p.m.

You are probably right that having it completely automated would have the potential of causing havok. I think the solution similar to "unused images" is probably the better since it allows a person to make sure the category actually makes sense and (using the first of the two tools) can additionally recommend categories to be created. /André On 16 January 2013 18:25, Maarten Dammers <maarten(a)mdammers.nl> wrote:

...

Hi André, Op 16-1-2013 0:43, André Costa schreef: Would it be possible to populate the same field using the commons templates if they are present used on a (unique) category page? I.e. as is done at Category:Aaltohuset<https://commons.wikimedia.org/wiki/Category:Aaltohus… . Technically yes, but I'm afraid of mistakes so I'm not doing it using a bot. I do plan to run some queries to suggest links to create (see .sql for the query): * http://toolserver.org/~multichill/temp/queries/erfgoed/rm_top_images.txt: List of tagged Rijksmonumenten images by number of images with the same id. This can be used to suggest new categories to be created * http://toolserver.org/~multichill/temp/queries/erfgoed/rm_commonscat_to_lin…: List of categories that are tagged with a Rijksmonumenten template. This can be combined with the database to suggest missing links to create just like https://commons.wikimedia.org/wiki/Commons:Monuments_database/Unused_images Maarten _______________________________________________ Wiki Loves Monuments mailing list WikiLovesMonuments(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org

Cristian Consonni

16 Jan 16 Jan

12:15 p.m.

2013/1/13 Maarten Dammers <maarten(a)mdammers.nl>nl>:

...

Hi Maarten, Thank you for this improvement. As you know Italian monuments' lists are organized by region, so every sublist has a link to the Commons category [[Category:Cultural heritage monuments in <region-name>]]. But in the database[1], under "commoscat" says 0. Why is it like this? Am I missing something? Another thing I have not completely understood is how can you tell the category of single monuments (like the church above), for example in the Italian list some monuments have a category on their own (see, for example [2]) which is, obviously, more precise than the general category "Cultural heritage monuments in <region-name>". Should we had to these entries a commonscat field with the precise cat? is there a way to tell the bot automatically which category is or we should do this by hand? Thanks again for you precious work. Ciao, Cristian [1] https://commons.wikimedia.org/wiki/Commons:Monuments_database/Statistics [2] https://commons.wikimedia.org/wiki/Category:Villa_romana_%28Desenzano_del_G…

Vicenç Riullop

12:30 p.m.

This "commonscat" in the table refers to the "commonscat of the monument", not the commonscat of the list. I've been filling locally this paramater with a bot. The logic is: checking the categories of the images in the list, if any of them is a subcategoy of the "commonscat of the list" then probably this is the "commonscat of the monument". If the monument has an article linked, the commonscat of the article is fine as well. Vicenç

...

From: kikkocristian(a)gmail.com Date: Wed, 16 Jan 2013 12:15:51 +0100 To: wikilovesmonuments(a)lists.wikimedia.org Subject: Re: [Wiki Loves Monuments] Commons categories now in the database 2013/1/13 Maarten Dammers <maarten(a)mdammers.nl>nl>:

Cristian Consonni

2:08 p.m.

2013/1/16 Vicenç Riullop <vriullop(a)hotmail.com>om>:

...

Thanks Vicenç. I'll ask for help to other Italian WLM volunteers and we'll see if we can do it with a bot or if we have to do it by hand. Ciao, Cristian

4112

days inactive

4118

days old

wikilovesmonuments@lists.wikimedia.org

Manage subscription

8 comments

5 participants

tags (0)

participants (5)

André Costa
Cristian Consonni
Maarten Dammers
Vicenç Riullop
Ynhockey