Wikidata:Bot requests/Archive/2015/08

Change reference URL (P854) statements with YouTube link to YouTube video ID (P1651)

Please, could someone change this kind of statement reference URL (P854)https://www.youtube.com/watch?v=XXXXXXXXXXX to YouTube video ID (P1651)XXXXXXXXXXX with a bot? Thank you very much! --★ → Airon 90 08:43, 4 August 2015 (UTC)

There weren't many, so I did them by hand. - Nikki (talk) 09:23, 4 August 2015 (UTC)

Thank you very much! --★ → Airon 90 09:50, 4 August 2015 (UTC)

This section was archived on a request by: --Pasleim (talk) 08:20, 5 August 2015 (UTC)

Harvest Lake ID (Sweden) (P761) from Swedish Wikipedia

Could someone harvest the value for Lake ID (Sweden) (P761) from Swedish Wikipedia (svwiki) where it is available in articles that use the template sv:Mall:Insjöfakta Sverige in the parameter sjöid. A few have been done by hand but there should be more than 50 000 still to do. Thanks, Ainali (talk) 20:06, 19 August 2015 (UTC)

https://tools.wmflabs.org/templatetiger/tt-table4.php?template=Insj%C3%B6fakta%20Sverige&lang=svwiki&where=sj%C3%B6id&is=_&columns=sj%C3%B6id&limit=20 --- Jura 20:11, 19 August 2015 (UTC)

 Done added 57,000 claims. --Pasleim (talk) 23:13, 21 August 2015 (UTC)

This section was archived on a request by: --Pasleim (talk) 23:13, 21 August 2015 (UTC)

Bot to migrate Findagrave cemetery numbers to P2025

Can a bot migrate the Findagrave cemetery numbers to field P2025? Here is an example of the filled in field Q5462169 --Richard Arthur Norton (1958- ) (talk) 23:14, 11 August 2015 (UTC)

Where is the data supposed to be migrated from? - Nikki (talk) 10:21, 12 August 2015 (UTC)

I imported some value from en:Template:Find_a_Grave_cemetery --Pasleim (talk) 20:16, 12 August 2015 (UTC)

@Richard Arthur Norton (1958- ), Pasleim: en.Wikipedia also has |findagrave = in en:Template:Infobox cemetery. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 21:56, 12 August 2015 (UTC)

 Done --Pasleim (talk) 15:00, 26 August 2015 (UTC)

This section was archived on a request by: --Pasleim (talk) 15:00, 26 August 2015 (UTC)

de:Steiermärkische Gemeindestrukturreform

Hi all, want help with importing administrative changes in Styria / Austria. The data is available with this official source. I will prepare the data as needed, but I have no idea what the proper input format is. So in the first round I just need advise. I asked before at Wikidata:Forum#Steirische_Gemeindestrukturreform and Wikidata_talk:Administrative_territorial_entity#How_to_deal_with_structural_administrative_changes, but not much success (is WD to be considered to offer a service? Or is it just another community project?)

The process involved

• merging districts
• merging municipalities
• changing district assignment
• changing identifying keys for the municipalities (new and old) - Gemeindekennziffer
• changing names of municipalities
• splitting old municipalities to two new municipalities
• not everything happened at the same time, main points in time were 1. Jan. 2013 and 1. Jan. 2015
• I want to keep the old structure depending on qualifiers endpoint in time an startpoint for the new property value
• I need assignment of municipalities to districts for the old status as well as for the new status
• municipalities that were merged, ceased to exist (as a municipality). Thus this property should be terminated by qualifier, but the old municipality should be kept as village, former municipality or the like.
• Depending on the structure change, area and population figures will of course change.
• coats of arms were declared invalid at 1. Jan. 2015 for touched municipalities, they will either re-request the old coats of arms or municipalities might also create a new one. (I do not have enough information on that particular point).

To give an example:

Aflenz Kurort was merged with Aflenz Land to new municipality Aflenz:

• in 1.1.2013 the district was merged with another district resulting in a new district object.
• in 1.1.2015 the two municipalities have been merged. I replaced Property:P131 with the newly formed municipality Aflenz.
• forget about the stuff about Heilbad and Kurbad, this is not part of the game.

First questions:

• I wanted to give the above url as a reference, but WD didn't allow me to save. So how to proceed?
• For the splitting of municipalities I didn't find data, so this is irrelevant, isn't it? The splitted municipality ceases to exist, and will not get another parent.
• Property:P150 will be updated automatically based on Property:P131 (it is just the other end of the 1:n relation), or are both ends independent and have to be changed both?

best regards --Herzi Pinki (talk) 13:51, 23 August 2015 (UTC)

Thanks a lot to User:Pasleim, done --Herzi Pinki (talk) 19:20, 31 August 2015 (UTC)

This section was archived on a request by: Herzi Pinki (talk) 19:20, 31 August 2015 (UTC)

1052 Wikivoyage banners waiting to be added to Wikidata

The Wikivoyages of all languages have "banners" at the top of each article (example).

Wikidata-aware editors add banners to page banner (P948) directly, but most just add {{pagebanner|Ambay Valley City.jpg}} to the local article (the images themselves are on Commons already).

Your mission, if you accept it, would be extract the image filenames from these 1052 articles and add them as page banner (P948) on the corresponding Wikidata items.

A bot that would do that automatically would be wonderful, but a manual tool to run once in a while would be OK too. If the code is open source, we could run it ourselves and maintain it if needed, that would be great :-)

The regretted Kizar used to do that for us every two months or so, but unfortunately he has not replied to our requests for 1 year.

Any volunteer? Thanks a lot! :-) Syced (talk) 13:50, 30 August 2015 (UTC)

Kizar has come back and ran the script again, so we are good for now, thanks a lot! :-) Syced (talk) 02:58, 31 August 2015 (UTC)

This section was archived on a request by: --Pasleim (talk) 06:51, 31 August 2015 (UTC)

Wikidata:The_Game/Flagged_items

Could a bot remove the sections if, when the user reported a problem with the gender game, the given item doesn't contain instance of (P31)human (Q5) anymore? Hope that will make the page more easily to manage. Sjoerd de Bruin (talk) 09:15, 25 August 2015 (UTC)

 Doing… May take an hour or so. Popcorndude (talk) 19:41, 25 August 2015 (UTC)

 Done any other categories that should be similarly sifted? Popcorndude (talk) 20:00, 25 August 2015 (UTC)

Hm, nope. Well, the ones about merging are not so useful. But I don't want to just throw those away. Thanks for your help. Sjoerd de Bruin (talk) 20:03, 25 August 2015 (UTC)

This section was archived on a request by: --Pasleim (talk) 15:17, 16 September 2015 (UTC)

P373 point to category redirects

I have make a list with Commons category (P373) point to category redirects on Wikimedia Commons: User:Steenth/P373 point to category redirects. Somebody can fix it? --Steenth (talk) 19:14, 29 August 2015 (UTC)

If you have used a script to create that list, you could be able to modify it to produce a code to change P373 using Quickstatements. https://tools.wmflabs.org/wikidata-todo/quick_statements.php

I think this would be a lot simpler than using a bot - in fact, that's the way I use to edit Wikidata with bots.--Pere prlpz (talk) 22:25, 30 August 2015 (UTC)

@Steenth:--Pere prlpz (talk) 22:27, 30 August 2015 (UTC)

As QuickStatements doesn't update links, you'd need to start with Autolist to remove the existing ones. --- Jura 06:59, 31 August 2015 (UTC)

What i is also see. We are missing general bots/tools to change and delete values on statements, set, move and change sitelinks etc. Can someone develop this? --Steenth (talk) 13:48, 31 August 2015 (UTC)

Actually, for Commons, there is a feature called sitelinks that does all that. --- Jura 14:00, 31 August 2015 (UTC)

 Done --Pasleim (talk) 21:59, 16 September 2015 (UTC)

This section was archived on a request by: --Pasleim (talk) 21:59, 16 September 2015 (UTC)

Follow/replace - qualifiers for position held (P39)

Currently the following ones are in use:

• replaces (P1365): 10782
• replaced by (P1366): 10633
• follows (P155): 4323
• followed by (P156): 4024

(numbers are from Wikidata:Database_reports/Constraint_violations/P39#Properties_statistics)

I'm never sure which pair is the right one, but could we change them to have a single set? --- Jura 15:07, 31 August 2015 (UTC)

AFAIK P1365 and P1366 pair is the right one, as they are used for replacements rather than for a series. Matěj Suchánek (talk) 15:11, 31 August 2015 (UTC)

My bot is already replacing P155/156 for P1365/1366 while it adds new qualifiers and positions (all in the same edit). Louperivois (talk) 17:08, 31 August 2015 (UTC)

Looking at the constraint report from one month back, it seems that the number of "follow" has remained stable/slightly increased, while the number of "replace" has grown a lot.

@Louperivois:: To avoid that they remain there forever, would you do a bot-run just to fix the ones with "follow"? --- Jura 10:13, 1 September 2015 (UTC)

List --- Jura 18:33, 16 September 2015 (UTC)

 Done --Pasleim (talk) 22:42, 16 September 2015 (UTC)

This section was archived on a request by: --Pasleim (talk) 22:42, 16 September 2015 (UTC)

Comparing and sourcing coordinate location (P625) on instance of (P31) = commune of France (Q484170) items

Hi,

Right now, all instance of (P31) = commune of France (Q484170) items have coordinate location (P625).

Most of the times it is imported (imported from Wikimedia project (P143)) from a Wikipedia and most Wikipedias took the coordinates -directly or indirectly- from the only official source : the Répertoire Géographique des Communes (here on data.gouv.fr, the open platform for french public data or here on ign.fr, official website of Institut national de l'information géographique et forestière (Q1665102)).

Could a bot look if the coordinates are the same on Wikidata and the RGC, and in the positive case, add stated in (P248) = répertoire géographique des communes (Q20894925) (and maybe a qualifiers as the RGC is update annualy).

Cdlt, VIGNERON (talk) 19:01, 31 August 2015 (UTC)

 Done --Pasleim (talk) 05:50, 18 September 2015 (UTC)

This section was archived on a request by: --Pasleim (talk) 05:50, 18 September 2015 (UTC)

Thank you very much Pasleim! Just out of curiosity, on how many communes did PLbot add a reference? Cdlt, VIGNERON (talk) 07:59, 18 September 2015 (UTC)

On 31156 items. --Pasleim (talk) 08:13, 18 September 2015 (UTC)

Taxon names

Where we have a taxon name (P225) and no label in a western-alphabet language, could we use a bot to apply the taxon name as a label in that language? Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 18:25, 22 August 2015 (UTC)

Isn't User:Succu working on that? --Pasleim (talk) 08:01, 25 August 2015 (UTC)

See Adding missing labels for all biological species, genus, families, etc --Succu (talk) 08:08, 25 August 2015 (UTC)

That seems to require wider discussion. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 19:46, 26 August 2015 (UTC)

This section was archived on a request by: Sjoerd de Bruin (talk) 12:23, 3 December 2015 (UTC)

One image for P158 and P94

I noticed there are a lot of items in which seal image (P158) has the same value as coat of arms image (P94). Browsing articles of localities in a wikipedia which imports from wikidata elements such as seals and coats of arms, i saw many articles with 2 coats of arms (and one flag). For example look at Quito (Q2900): both seal image (P158) and coat of arms image (P94) uses image Coat of Arms of Quito.svg. It's necessary to find all items in which value of seal image (P158) is the same as of coat of arms image (P94) and to remove value for seal image (P158) (usually image which is duplicated is a coat of arms). --92.115.106.250 23:06, 14 August 2015 (UTC)

This doesn't look as simple as you present it. Take for example New York City (Q60), with your proposed logic the wrong field would be removed. I also see cases where it's not clear if we're talking about a seal or a coat of arms. The English Wikipedia seems to be mixing up the two too, see for example en:Villanueva de San Juan. Probably better to get the seal/coat of arms/flags people involved here. Maybe through Wikidata:WikiProject Heraldry? This doesn't look like something that could be fixed with a bot. Multichill (talk) 09:13, 15 August 2015 (UTC)

Bot operator can put one more condition before removal, to be safe. For example if value of P158 is identical to value of P94, AND if value of seal image (P158) contains strings such as "CoA" / "coat of arms" / "CoatOfArms", THEN remove seal image as it is not seal. This can clean about half of problematic items. The rest can be analyzed by humans. --92.115.106.250 09:46, 15 August 2015 (UTC)

This reminds me that I fixed a few items where a bot had inverted flag and seal image. --- Jura 07:13, 16 August 2015 (UTC)

For an overview: Property talk:P158/list. As most seem to be COA, I tend to agree with 92.115.106.250. --- Jura 15:48, 17 August 2015 (UTC)

Actually, I think it should be deleted and re-created: Wikidata:Properties_for_deletion#seal_image_.28P158.29. --- Jura 06:48, 19 August 2015 (UTC)

This section was archived on a request by: --- Jura 12:06, 4 December 2015 (UTC)

Propagating labels from en/de/fr/es for artists to other euro languages

Hi, I have worked on propagating labels from the ULAN and RKD matches to en/de/fr/es and now I would like "for each label that is the same in those languages to be copied to other western euro languages that have blank labels today". Any takers? The ULAN/RKD matches to use can be downloaded from Mix-n-Match. I suppose you could also run a bot for all humans whose label is the same in all of those langauges - this will of course pick up more than what is in the ULAN & RKD. Thx Jane023 (talk) 11:29, 18 August 2015 (UTC)

How do you intend to do with persons who have origin from countries with a language which uses Cyrillic script (Q8209)? -- Innocent bystander (talk) 12:33, 18 August 2015 (UTC)

Not. I only want the Western languages (Italian, Swedish, Danish, Hungarian, Luxembourg, Frisian, Catalan, etc). Those countries with special alphabets will have to use their own databases. The advantage is that most top museums interface with the ULAN so you can probably get their cross-reference and do it yourself. For example, the Dutch Rijksmuseum keeps artwork titles and creator names in English and Dutch (but by using the RKD list I know that I have those covered anyway, so I didn't need it). Jane023 (talk) 13:53, 18 August 2015 (UTC)

The problem is if the original name was Russian and it was transliterated to English. In that case you can't copy the English name to other western euro languages. An example: The name of Yury Annenkov (Q1362480) is written in all languages different because all languages use a different transliteration system. Also the ULAN record [1] doesn't help. It lists many different spellings but without the corresponding language. --Pasleim (talk) 14:05, 18 August 2015 (UTC)

No that is not a problem. I only selected the names that were the same in both RKD and ULAN and which had blank labels in Dutch and in English. Then I selected all the names in both RKD and ULAN that had the same labels in Dutch and in English (so more than the first pass, including many handwritten names). This already excludes lots of names that for example have the Dutch patronymic in Dutch and don't in English. Next I added all in that subset to German labels only if the German label was missing, ditto French, and ditto Spanish. Now I want the same exercise for the other languages. Please note you first have to exclude all non-null labels per language. There are no Cyrillic characters in any names at all in the subset of the dataset I am talking about. Jane023 (talk) 17:00, 18 August 2015 (UTC)

Perhaps the bot could ignore anything with a label in a Cyrillic script; or where given name (P735) doesn't match the existing western-script label; or where two western-script labels are different?? Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 14:45, 18 August 2015 (UTC)

I know that Lithuanian often transcribe from a latin to latin scripts. See Brūss Springstīns as an example. -- Innocent bystander (talk) 17:27, 18 August 2015 (UTC)

See #labels for people's names, above, for a similar request. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 14:41, 18 August 2015 (UTC)

To be clear, this work has already been done, and I just want to have it repeated for other euro languages. Check the history of my edits or check the history of specific items. I did not touch Yury Annenkov (Q1362480) for example. Jane023 (talk) 17:05, 18 August 2015 (UTC)

Here are some links illustrating how this is useful by adding names over Q numbers to female artists indexed in the RKD: de:Benutzerin:Jane023/Frauen_in_RKDartsts and en:User:Jane023/Female_RKDartists. If I set up this listeria bot in one of the languages that hasn't been done yet you will see mostly Q numbers for names. Jane023 (talk) 17:58, 18 August 2015 (UTC)

This has been done yesterday on steroids (aliases have also been added, so not just labels) by User:Multichill. --Jane023 (talk) 12:17, 6 December 2015 (UTC)

This section was archived on a request by: Add Names as labels (Q21640602) can help if there is still need. --- Jura 12:24, 4 December 2015 (UTC)

labels for people's names

I use nameGuzzler to add the names of people in all western-script languages, like this. Could we get a bot to do this, if not for all instances of humans, then at least for some types, or in certain circumstances (for example, if there of the labels using western scripts are the same then copy it to the rest)? Or we could do it for anyone with a given name of one of a long list (say, Andrew, Brenda, Christopher...). Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 16:42, 6 August 2015 (UTC)

There are many tricky cases. Names can be written in different ways in different languages, e.g. Christopher Columbus (Q7322), Julius Caesar (Q1048), Aristotle (Q868) and even when the given name is sounding English, it still can be a transliteration from a Cyrillic language and so the name shouldn't be copied, e.g. Andrew Pavlovsky (Q290393). --Pasleim (talk) 10:31, 15 August 2015 (UTC)

So let's try to whittle those away, and do the rest - maybe based on birthplace, or the existence of three Wikipedia articles with the same title, or whatever. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 11:54, 15 August 2015 (UTC)

New properties

The adoption of new properties is limited by the fact that neither here on Wikidata nor elsewhere on other projects are there specific actions designed to monitor them carefully. I suggest that we start tagging all existing properties with their creation date using inception (P571) and that we then keep going when new ones are created after that. Can a bot do both things? The monitoring of new ones could be based on a daily check, I would say. Thierry Caro (talk) 04:07, 24 August 2015 (UTC)

What do you plan to do if all properties have a inception (P571) claim? A list of new properties you get by https://www.wikidata.org/wiki/Special:NewPages?namespace=120 --Pasleim (talk) 08:00, 25 August 2015 (UTC)

I know, but this is not usable on Wikipedias, except through a straight link. If we want to generate lists of useful properties on projects there, we should fill the properties of properties better here, starting with a creation date for instance. Thierry Caro (talk) 13:05, 25 August 2015 (UTC)

Add links to Arabic sister projects

Hey, Is there a way to add articles of sister projects in Arabic (wikiquote, books, source, .. ) to wikidata by a bot ? For example this article in Arabic wikiquote is linked to the Arabic article in wikipedia by a template. But if we take a look to the wikidata article there is no link to the Arabic wikiquote article. Or if you can at least extract a list of same name articles in Arabic wikiquote/wikisource/wikibooks and wikipedia but not linked in wikidata. --Helmoony (talk) 20:15, 25 August 2015 (UTC)

US places with names in the format "<locality>, <US state name>"

These could converted to "<locality>" and the label added as alias. Sample: diff.

For places with labels in the format "<locality>" and enwiki articles in the format "<locality>, <US state name>", the enwiki title could be added as alias. --- Jura 12:30, 26 August 2015 (UTC)

Better to add a description because aliases aren't seen in the search drop-down. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 22:11, 28 August 2015 (UTC)

Adding description is another option, but not part of this request. Please keep it focused and provide a reference for the reminder of your comment. --- Jura 06:57, 29 August 2015 (UTC)

I'm focussed on making the best improvements to Wikidata. Your proposal would remove visibility of the state-name from the search drop-down, which would be a negative effect. As such, I would object to it, unless modified. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 10:23, 29 August 2015 (UTC)

But you don't have any reference to support your POV? --- Jura 10:35, 29 August 2015 (UTC)

Many place names in the US are repeated in the US in several different states, so in any environment where one is choosing a US place name from a menu it is essential to include the state in the menu. Example: Manchester (Q48370), Manchester (Q1905654), Manchester (Q753909), Manchester (Q9027296), and all the others listed at w:Manchester (disambiguation). Jc3s5h (talk) 12:02, 29 August 2015 (UTC)

It doesn't actually support Pig's POV. --- Jura 12:06, 29 August 2015 (UTC)