Wikidata:Bot requests/Archive/2013/11

father<=>son

can anyone empty this list? [1] thanks --Rippitippi (talk) 17:24, 5 November 2013 (UTC)

  Done --Zuphilip (talk) 21:26, 9 November 2013 (UTC)
This section was archived on a request by: Zuphilip (⧼Talkpagelinktext) 22:14, 16 November 2013 (UTC)

Replace one value by another

Could anyone replace all occupation (P106) = military (Q8473) by occupation (P106) = soldier (Q4991371) please? Thanks. — Ayack (talk) 15:05, 8 November 2013 (UTC)

  Done
Is "occupation (P106) = Age of Discovery (Q133641)" similar? http://208.80.153.172/wdq/?q=claim[106:133641] ? --Zuphilip (talk) 18:40, 8 November 2013 (UTC)
Yes, please:
Ayack (talk) 19:14, 8 November 2013 (UTC)
  Done  Done (please note that occupation (P106) = explorer (Q11900058) was sometimes already there from different source) --Zuphilip (talk) 22:24, 8 November 2013 (UTC)
This section was archived on a request by: Zuphilip (⧼Talkpagelinktext) 12:13, 18 November 2013 (UTC)
the item Q15147872 is to be merged into Q3240003, but Q15147872 still has a lot of links to it. Can these links be moved to Q3240003, so the request can be processed? -Cycn (talk) 13:04, 13 November 2013 (UTC)
  Done Amir (talk) 04:06, 14 November 2013 (UTC)
This section was archived on a request by: ReviTalk10:02, 19 November 2013 (UTC)

Dmoz

Add the property:P998 in Wikidata from the Wikivoyage(s) relevant pages. Otourly (talk) 12:02, 3 November 2013 (UTC)

  Done --Kizar (talk) 11:05, 4 November 2013 (UTC)
This section was archived on a request by: Pasleim (⧼Talkpagelinktext) 09:03, 26 November 2013 (UTC)

remove aliases

Please remove all aliases in zh which is 沙河堡站, 乌斯河站, 泸沽站 such as this. this 3 page are redirect pages, but they have links to many pages, and these aliases was added by bot by mistake.--GZWDer (talk) 04:59, 1 November 2013 (UTC)

The property could be added based on "ISIL" in de:Template:Infobox Bibliothek and "ISIL" in fr:Template:Infobox Bibliothèque (template have approx. 332 and 69 transclusions, the property just 1 use). --  Docu  at 10:38, 12 August 2013 (UTC)

There are some connected activities to bring the adress data (and ISIL) into the semantic web, see http://datahub.io/dataset/isil-dbpedia and http://datahub.io/dataset/lobid-organisations. Helpful? --Zuphilip (talk) 19:13, 4 November 2013 (UTC)

Importing patron saints into occupations from this list into P417

Would it be possible to import the patron saints list contained in this Wikipedia page.

https://en.wikipedia.org/wiki/Patron_saints_of_occupations_and_activities >> patron saint - occupation1, occupation2
occupation1 and occupation2 >> property patron saint (P417) of occupation1 AND property patron saint (P417) of occupation2 Thanks, --Teolemon (talk) 16:46, 3 November 2013 (UTC)

Real data imports: chemical identifiers

If some bot operators are interested to import sourced data there are databases which offer some open data sets like PubChem, chEMBL, chEBI or KEGG. The job is not easy: download of datasets, extraction of useful data and matching of extracted data with existing wikidata items. If you are interested feel free to contact me. Snipre (talk) 23:06, 4 September 2013 (UTC)

Do they provide data in a machine readable format? and unluckily we don't have enough datatypes to add most of properties of those substances currently. Liangent (talk) 18:58, 30 September 2013 (UTC)
Yes, there are different formats but using a pattern. Snipre (talk) 21:49, 6 November 2013 (UTC)

Migrate from P31/P279 to P1002 (engine configuration) for engine configuration values

Currently we have been indicating engine configuration using Q : subclass of (P279) / instance of (P31) : inline engine (Q12775041), etc. but engine configuration (P1002) was just activated and these claims should be moved to this property:

Move from properties: P31, P279
Move to property: P1002
Values to be moved: Q678276, Q3063504, Q3269254, Q12775041, Q724736, Q10856569, Q341174, Q245272, Q214098, Q1043622, Q1431441, Q946676

A bot which can move all listed Qs above that exist in P31/279 claims to P1002 would be very helpful. Thanks! Joshbaumgartner (talk) 04:56, 30 October 2013 (UTC)

Shouldn't it better be engine configuration (P1002) = straight engine (Q946676) instead of inline engine (Q12775041)? --тнояsтеn 07:29, 30 October 2013 (UTC)
inline engine (Q12775041) is used for aviation engines arranged in one or more banks while straight engine (Q946676) is a term for an engine with a single bank of cylinders, so they both would be appropriate claims depending on the engine in question. However, the scope of my request was merely to move any engine configurations claimed using subclass of (P279) or instance of (P31) to a statement using engine configuration (P1002) instead, not to validate whether such claims are accurate. Joshbaumgartner (talk) 09:48, 3 November 2013 (UTC)
P31/P279 should remain as that's a rather fundamental relation. I have no objection otherwise to adding P1002 to those respective properties, but that should make it apparent that they are duplication, no?... --Izno (talk) 23:06, 6 November 2013 (UTC)

Importing ROME code from frwiki occupations infobox

Would it be possible for a botmaster, and for items that are instance of (P31) profession (Q28640) to:

That would greatly help us improve the quality of occupation infobox and kickstart further work (since the code ROME will have matches with other international and national codes) thanks, --Teolemon (talk) 16:02, 3 November 2013 (UTC)

@Teolemon: for ROME Occupation Code (P867) see Wikidata:Requests for permissions/Bot/SamoaBot 40. Regards, --Ricordisamoa 16:57, 3 November 2013 (UTC)
The sample edit looks good to me. Beware there might be some fields with multiple ROME codes separated by commas, or some with additional text after the code (but separated by spaces and hyphens).--Teolemon (talk) 18:50, 3 November 2013 (UTC)
In addition, Would it be doable to match French labels with a canonical list of ROME Codes (and same for the Canadian and international codes) ? --Teolemon (talk) 17:31, 8 November 2013 (UTC)

Date of death unknown

Use categories such as Date of death unknown, and their equivalents in other languages, to set date of death (P570) to "unknown". --Magnus Manske (talk) 10:02, 8 November 2013 (UTC)

Importing image value from frwiki and enwiki occupations infobox

Would it be possible for a botmaster, and for items that are instance of (P31) profession (Q28640) to:

  • import the "image" parameter from frwiki (fr:Modèle:Infobox Métier) and enwiki (en:Template:Infobox_occupation) into image (P18)

That would greatly help us improve the quality of occupation infobox and kickstart further work (since the code ROME will have matches with other international and national codes) thanks, --Teolemon (talk) 10:01, 9 November 2013 (UTC)

instance of legislation

I'd like to get pages about acts of Parliament/Congress to be tagged as

instance of (P31) => legislation (Q49371).

Could someone do that to all the pages in the following categories? The bot could also add the applies to jurisdiction (P1001) property while it's at it.

--Arctic.gnome (talk) 22:16, 9 November 2013 (UTC)

Birth and death dates from prepared list

I have generated a list of birth and death dates for over 325K people, based on rather stringent regular expression matches in the header section of the respective en.wp article. Each row in the file lists Q item number, en.wp title, the property to update, and the date in Wikidata form. Precision is "day", calendar is Gregorian. Source should be "stated in en.wp". There are 440.724 statements in total to be set. The presence of existing birth/death dates was not checked, and updating should be skipped if a date already exists for an item. --Magnus Manske (talk) 21:16, 13 August 2013 (UTC)

Good idea. If there no other candidates till then, I can try to do it in two weeks from now. --  Docu  at 07:44, 14 August 2013 (UTC)
It would be great if the bot would report errors if there is already a different date set to sport vandalism and mistakes. --Sk!d (talk) 02:01, 15 August 2013 (UTC)
Bot tasks for importing birth and death dates from Wikipedias without sources have previously been opposed, so I don't think you should do this. Byrial (talk) 10:08, 15 August 2013 (UTC)
But if we type the dates in manually it's OK? That doesn't make any sense. --Magnus Manske (talk) 14:00, 15 August 2013 (UTC)
The point is that statements for birth and death dates should have sources. Byrial (talk) 16:04, 15 August 2013 (UTC)
Should have, or need to have? Why would we be more stringent here than on Wikipedia, especially in this early phase? I could easily write code that lists all unsourced dates, so one can add sources if one wishes to do so after the fact. In general, I would put more trust in dates on Wikipedia than on some other random website; you know, the ones we can't add as sources due to the missing URI type anyway. Insisting on sourced dates seems quite bizarre at the moment. --Magnus Manske (talk) 09:01, 16 August 2013 (UTC)
This is not the right place to discuss the principles. Please see Help:Sources, the RFC Wikidata:Requests for comment/References and sources it is based upon. Byrial (talk) 09:18, 16 August 2013 (UTC)
Pages who uses sv:Mall:SvBf do not need an URI. I think it's mainly sv:User:Elinnea who uses it, a user I trust. Also birthplace can be found in this source. -- Lavallentalk(block) 09:41, 16 August 2013 (UTC)
According to Help:Sources, there should be (almost) no unsourced statements added to Wikidata. Yet, when you click on "Random page", the few claims that have sources are usually "imported from [some] Wikipedia", which is what I proposed to do in this case. Also, on the RfC, it says "use common sense", which is why I keep bitchin' on here. --Magnus Manske (talk) 12:04, 16 August 2013 (UTC)
Does Help:Sources support the use of "imported from [some] Wikipedia"? I doubt that... "Imported from" could be good for the traceability of the statements, but it is not a good source. -- Lavallentalk(block) 12:25, 16 August 2013 (UTC)
Well, that's what currently done in reality :-) My point is, we can make Wikidata quickly much more useful by adding these dates and "tracing" them back to Wikipedia, and being at least as reliable as Wikipedia, and then can add a "real source". I can envision a tool that lists, for a Wikidata item, the URLs linked to in all Wikipedia, and maybe the references cited. That would make it easy to add a source for an individual item. Or, we insist that dates are only added with "proper" sources, and lack key information for years to come that is readily available on Wikipedia. --Magnus Manske (talk) 12:41, 16 August 2013 (UTC)
Well, one of the main problems for Wikidata at the moment is the reliability of our statements. Every use of "imported from..." adds badwill to Wikidata. 10000 more statements of this kind for birthdates and birthplaces maybe doesn't make any difference, but we have to start using more intelligence in the statement-import. I guess we do not need reliable sources for statements like "New York is located in USA", but birthdate is definitly above the threshold for statements who need "real" sources. I made a little test now in Kim Amb (Q3357572). It works fine, but I am missing a property for the "header" in the database. -- Lavallentalk(block) 12:51, 16 August 2013 (UTC)
Yes, in some cases (source published as print, and Wikidata item for it exist) you can add a source now. And I really want that all claims on Wikidata are sourced! Meanwhile, it took you over 10 minutes to add the source to these two claims, and you probably knew where to look for the source item on Wikidata. Assuming 5 minutes as a lower boundary per claim, the 440K claims in my list come to over four man-years, without doing anything else. I have no doubt that we will eventually get there; all I want is to get the data in now so Wikidata can be much more useful right away, state where to look for a source (Wikipedia), and add the "real" sources later. This is still the early growth phase here, and I for one think it's a bad idea to bog it down with excessive requirements. --Magnus Manske (talk) 13:31, 16 August 2013 (UTC)
As a side note, type and sex of Q3357572 are "imported from Swedish Wikipedia"... ;-) --Magnus Manske (talk) 13:34, 16 August 2013 (UTC)
True, but not relevant. The sex is common knowledge, and GND type gives no information besides how GND do or would classify him. Byrial (talk) 13:54, 16 August 2013 (UTC)
Common knowledge? Based on what? The first name "Kim"? Hardly. Anyway, my point was to show the situation as it currently is, in contrast to how we would like it to be. --Magnus Manske (talk) 14:08, 16 August 2013 (UTC)
That he has competed in male javelin may give you a clue :). And Kim as a Swedish name is almost always male. (I have a similair problem with my private name, it's female in US but male here in Sweden.) Yes, it took me 10 minutes, mainly because I was not familiar with the properties and the ordinary trouble with the user interface. I had to look in several pages before I found good properties. I also had to create an item for the database. (It is CD/DVD-ROM based.) -- Lavallentalk(block) 14:28, 16 August 2013 (UTC)

────────────────────────────────────────────────────────────────────────────────────────────────────   On hold per Wikidata:Requests for permissions/Bot/SamoaBot 26. --Ricordisamoa 19:26, 19 August 2013 (UTC)

Sanity has prevailed, someone get this started please! (also, I fixed a handful of dates in the list that had swapped digits on Wikipedia). --Magnus Manske (talk) 08:27, 23 August 2013 (UTC)
I've made some test edits: example. --Ricordisamoa 04:13, 27 August 2013 (UTC)
Looks good. Given my offer earlier, if needed, I could be ready this week as well. --  Docu  at 04:21, 27 August 2013 (UTC)
Soooo... anyone on this? --Magnus Manske (talk) 22:12, 16 September 2013 (UTC)
Bump - going on three months now... --Magnus Manske (talk) 12:39, 1 November 2013 (UTC)
  Support Wikidata definitely needs that kind of information. Pyb (talk) 13:31, 5 November 2013 (UTC)
  Support idem. --Coyau (talk) 09:58, 7 November 2013 (UTC)
  Support Better use those 4 person years for something bots can't do (yet). --Daniel Mietchen (talk) 02:18, 11 November 2013 (UTC)

coordinates from dawiki

Here is a file with coordinates from dawiki not imported to wiki data. (from database dumps) --Steenth (talk) 11:47, 10 November 2013 (UTC)

Released ORCID data

A couple of weeks ago w:ORCID released a public data file. It could be useful to cross match records, and link to the researchers profile using ORCID iD (P496). Is it feasible?--Micru (talk) 19:18, 11 November 2013 (UTC)

Wikidata Freebase mappings

There are about 2 Million Freebase to Wikidata ID mappings available under CC0. The Freebase identifier property is meant for this data. I would like to ask

  1. whether we want this data in Wikidata.
  2. if so, whether there is a volunteer to do it.

Cheers, --Denny (talk) 23:17, 11 November 2013 (UTC)

Hi Denny, there are some complaints about your request. --Succu (talk) 22:47, 12 November 2013 (UTC)
Thanks to pointing me there! --Denny (talk) 01:44, 13 November 2013 (UTC)
Sorry, but I'm against supporting Google in this massive way, unless we are all paid by this company. I never found anything useful in Freebase. --Kolja21 (talk) 02:23, 13 November 2013 (UTC)
The proposal is to allow data to be filled in for Freebase ID (P646), just like we do for GND ID (P227) and VIAF ID (P214). I don't think that qualifies as massive support. Even if it did, the notion that we should all be paid by Google to allow an approved Wikidata property to be supplied with data seems quite odd. We don't all get paid by the German National Library or OCLC, after all. Emw (talk) 05:49, 13 November 2013 (UTC)
  Support. This sort of automatic identifier mapping has ample precedent in Wikidata. The proposal is to simply add statements for Freebase ID (P646), a property that's already been approved, using curated Freebase-Wikidata mappings. We do this with VIAF and many other types of identifiers, so I see no problem in doing the same with Freebase identifiers. Emw (talk) 05:49, 13 November 2013 (UTC)
  Support Mapping are very useful in order to discover issues in the database, especially duplicates. I don't see any problem for this big mapping if it's curated automatically. Tpt (talk) 07:18, 13 November 2013 (UTC)
  SupportAyack (talk) 08:57, 13 November 2013 (UTC)
  Support. The only reason not to do this is "fuck the corporations," which isn't a reason at all, and in fact runs contrary to the Wikimedia principle of making our content available for unfettered reüse—a principle that is perhaps more relevant for Wikidata than for any other project. The more we can incorporate data from other databases, the better chance we have of becoming the Web's definitive free knowledge base. (Full disclosure: I own a couple of stocks in Google; however, I rather doubt that anything we do here will significantly increase their bottom line.) — PinkAmpers&(Je vous invite à me parler) 03:31, 14 November 2013 (UTC)
  Support, like Emw. Conny (talk) 08:40, 14 November 2013 (UTC).

Is that a continuous process - and will the procedure, now or in the future, in any way, put a significant workload on our servers ? Alexpl (talk) 17:32, 14 November 2013 (UTC)

Hi Alexpl. I expect this to be a one-time upload and then minor work to maintain the mappings. Since both projects are committed to stable identifiers, this should only happen when fixing mappings. There is no additional workload expected on the Wikimedia servers besides that. --Denny (talk) 18:04, 14 November 2013 (UTC)
  Wait - Interlinking can't hurt, but this shouldn't be a high priority task. There are many much more important bot tasks that should be done before this. --Tobias1984 (talk) 21:40, 14 November 2013 (UTC)

Import P402 values

Hi! Here is a list of states which have a given OpenStreetMap relation ID (P402). --Bigbossfarin (talk) 19:37, 13 November 2013 (UTC)

Source: http://wiki.openstreetmap.org/wiki/Countries_of_the_world

state (Q7275) OpenStreetMap relation ID (P402)
Algeria 192756
Angola 195267
Benin 192784
Botswana 195274
Burkina Faso 192783
Burundi 195269
Cameroon 192830
Cape Verde 535774
Central African Republic 192790
Chad 192788
Comoros 535790
Cote d'Ivoire 192779
Democratic Republic of the Congo 192795
Republic of the Congo 192794
Djibouti 192801
Egypt 1473947
Equatorial 192791
Eritrea 296961
Ethiopia 192800
Gabon 192793
Gambia 192774
Ghana 192781
Guinea 192778
Guinea-Bissau 192776
Kenya 192798
Lesotho 88206
Liberia 192780
Libya 192758
Madagascar 447325
Malawi 195290
Mali 192785
Mauritania 192763
Mauritius 535828
Morocco 192691
Mozambique 195273
Namibia 195266
Niger 192786
Nigeria 192787
Rwanda 171496
Sao Tome and Principe 535880
Senegal 192775
Seychelles 536765
Sierra Leone 192777
Somalia 192799
South Africa 87565
South Sudan 1656678
Sudan 192789
Swaziland 88210
Tanzania 195270
Togo 192782
Tunisia 192757
Uganda 192796
Zambia 195271
Zimbabwe 95272
Afghanistan 303427
Bahrain 378734
Bangladesh 184640
Bhutan 184629
Brunei 2103120
Burma 50371
Cambodia 49898
China 270056
East Timor 305142
India 304716
Indonesia 304751
Iran 304938
Iraq 304934
Israel 1473946
Japan 382313
Jordan 184818
Kuwait 305099
Kyrgyzstan 178009
Laos 49903
Lebanon 184843
Malaysia 2108121
Maldives 536773
Mongolia 161033
Nepal 184633
North Korea 192734
Oman 305138
Pakistan 307573
Palestine 1703814
Philippines 443174
Qatar 305095
Saudi Arabia 307584
Singapore 536780
Sri Lanka 536807
South Korea 307756
Syria 184840
Taiwan 449220
Tajikistan 214626
Thailand 2067731
Turkmenistan 223026
United Arab Emirates 307763
Uzbekistan 196240
Vietnam 49915
Yemen 305092
Akrotiri 3267302
Åland Islands 2375170
Albania 53292
Andorra 9407
Armenia 364066
Austria 16239
Azerbaijan 364110
Belarus 59065
Belgium 52411
Bosnia and Herzegovina 214908
Bulgaria 186382
Croatia 214885
Cyprus 307787
Czech Republic 51684
Denmark 50046
Dhekelia 3267303
Estonia 79510
Faroe Islands 52939
Finland 54224
France 1403916
Georgia 28699
Germany 51477
Greece 192307
Guernsey 270009
Hungary 21335
Iceland 299133
Isle of Man 62269
Ireland 62273
Italy 365331
Jersey (British Crown) 367988
Kazakhstan 214665
Latvia 72594
Liechtenstein 1155955
Lithuania 72596
Luxembourg 28711
Macedonia 53293
Malta 365307
Moldova 58974
Monaco 1124039
Montenegro 53296
Netherlands 47796
Norway 1059668
Poland 49715
Portugal 295480
Romania 90689
Russia 60189
San Marino 54624
Serbia 1741311
Slovakia 14296
Slovenia 218657
Spain 1311341
Sweden 52822
Switzerland 51701
Turkey 174737
Ukraine 60199
United Kingdom 51684
Vatican City State 36989
Argentina 286393
Bolivia 252645
Brazil 59470
Chile 167454
Colombia 120027
Ecuador 108089
French Guiana 1260551
Guyana 287083
Paraguay 287077
Peru 288247
Suriname 287082
Uruguay 287072
Venezuela 272644
I'm hijacking this thread to say that the relation for France is only "metropolitan" France (that is without overseas department). It should include at least overseas department (and I think also other dependencies). --Zolo (talk) 15:50, 15 November 2013 (UTC)

I have found several items with only links to deleted pages or redirects: [2]. these 30 pages was with link only to simplewiki. There're more with only links to deleted pages or redirects. Can someone make a bot to do that?--GZWDer (talk) 16:01, 15 November 2013 (UTC)

Now that legal citation of this text (P1031) exists, I'd like to add that property based on infoboxes on en.wiki. The parameter used is ether "citation" or "citations" or "ParallelCitations". The tricky part is that the citations parameter often has more than one citation in it separated by commas or semicolons, so rather than adding the entire contents as one string, we would have to split them up and add one item for each citation. Also, some infoboxes list the citations inside a Template:Plainlist. Would it be possible to split up the citations from infoboxes like this? If so, the infoboxes affected are:

We could also add

instance of => legal case (Q2334719)

to all of these while we're at it. Thanks! --Arctic.gnome (talk) 19:57, 19 November 2013 (UTC)

The occupation and professions now has a dedicated page with all tasks that could be done by bots.

The occupation and professions now has a dedicated page with all tasks that could be done by bots. Those are not formal requests, but rather a list of everything that could be done using bots, as well as a list of ongoing tasks already accepted. Feel free to enrich it, and take on tasks by filling a formal request here. --Teolemon (talk) 12:26, 21 November 2013 (UTC)

Create items about doi sources

Per Wikidata:Requests for comment/Source items and supporting Wikipedia sources, all data in en:Category:Cite doi templates should be moved to Wikidata like Q10893476. We should make a bot to do that.--GZWDer (talk) 06:44, 24 November 2013 (UTC)

And also {{Cite isbn/XXXXXX}}.--GZWDer (talk) 06:47, 24 November 2013 (UTC)
  Oppose Someone has something to do? What exactly? --Succu (talk) 20:28, 25 November 2013 (UTC)
Succu, on that RFC there was the discussion of supporting the bibliographic information from Wikipedia sources, in a way that once entered here, they would be available for using it on all Wikipedias and also here in Wikidata to source statements. I'm not sure if once imported it will be possible to use them in Wikipedia until Bugzilla47930 is solved, but at least we can use them here to source statements. Out of curiosity, what exactly are you opposing? --Micru (talk) 10:56, 26 November 2013 (UTC)
We should create these items if we need them as sources and not import bot generated citations, often unused in enwiki. --Succu (talk) 11:27, 26 November 2013 (UTC)

Items for parallels and meridians

There are articles for latitudes and longitudes in Wikipedia, and there are Wikidata items for them, e.g. 38th parallel north (Q483102), 122nd meridian west (Q543229). Their description and interwiki linking needs to be automated.
In English, the number's suffix depends on the number.
In Russian, the number's suffix depends on whether it's a parallel or a meridian.
--AVRS (talk) 14:56, 26 November 2013 (UTC)

Adding IDEO Job ID (P1043) from this spreadsheet

I've made a list of IDEO codes and their associated French job name (as well as a supporting source URL). Can someone add IDEO Job ID (P1043) for items with an exact match in this professions list (you just need to make sure that the job name is the same as the French label)?

--Teolemon (talk) 20:49, 30 November 2013 (UTC)