Wikidata:Bot requests/Archive/2014/07

From Wikidata
Jump to navigation Jump to search

Propety

Move links P1298 (P1298) to work location (P937) then delete P1298 (P1298) as [1] --Rippitippi (talk) 23:50, 2 July 2014 (UTC)

✓ Done moved all statements from P1298 to P937. --Pasleim (talk) 18:57, 5 July 2014 (UTC)
This section was archived on a request by: --Pasleim (talk) 18:29, 21 July 2014 (UTC)

Insert categories from it.quote

Import from it.Wikiquote all the categories named Categoria:Luoghi... (except for those already connected, but they are very very few). Label should be "category of a Wikimedia project" (en) and "categoria di un progetto Wikimedia" (it). --Superchilum(talk to me!) 09:23, 8 July 2014 (UTC)

✓ Done --ValterVB (talk) 20:14, 23 July 2014 (UTC)
This section was archived on a request by: --Pasleim (talk) 12:03, 14 September 2014 (UTC)

UN security council resolutions : Wikisource links

UN security council resolutions are on Wikisource in English and French, and titles seem to match Wikidata labels (except for the uppercase in French). So when an item is a p31 of United Nations Security Council resolution (Q877358) the en.wikisource and fr.wikisource pages with corresponding titles can be added. Example : United Nations Security Council Resolution 233 (Q2573400), en:s:United Nations Security Council Resolution 233, fr:s:Résolution 233 du Conseil de sécurité des Nations unies--Zolo (talk) 10:19, 13 July 2014 (UTC)

@Ladsgroup: it might be similar to other tasks your bot has done, would you give it a look ?--Zolo (talk) 07:43, 28 July 2014 (UTC)
✓ Done Amir (talk) 13:03, 28 July 2014 (UTC)
This section was archived on a request by: --Pasleim (talk) 12:04, 14 September 2014 (UTC)

Changing "french actress" to "French actress"

Many descriptions don't use caps for "French". Sample: "french actress" for Q3369081. Others can be found with "Special:search/"french+actress", but I'm not sure how to select only lowercase "french" in descriptions. There is the same issue with other professions and nationalities. Could this be fixed by bot? --- Jura 08:22, 19 July 2014 (UTC)

seems to be done.
This section was archived on a request by: --Pasleim (talk) 20:32, 1 October 2014 (UTC)

Please remove the following images

Hi, I am adding images to Wikipedia and have found hundreds of mistakes in biographic images on Wikidata. Some images in particular keep coming back when they are obviously of no use to any page. They keep popping up in the image suggestions, when there is no actual image, and really slow down the adding of images from Wikidata to Wikipedia. Moreover, the people helping add images get the idea that Wikidata is low quality. I remove them when I find them, but there are more. Could someone please find and delete these images? Thank you, Taketa (talk) 09:40, 29 July 2014 (UTC)

  • No female portrait cs.svg [2]
  • Kardinalcoa.png [3][4][5][6]
  • Bishopcoa.png [7]
  • Kardinalpallium.png [8]
  • Med 1.png
  • Med 2.png [9]
  • Med 3.png [10][11][12]
  • Arc en ciel.png [13][14][15][16]
  • MaillotSuiza.PNG [17]
  • MaillotNoruega.PNG [18]
  • MaillotPolonia.PNG [19]
  • MaillotPortugal.PNG [20]
  • MaillotKaz.PNG [21]
  • MaillotItalia.PNG [22][23]
  • MaillotEEUU.PNG [24]
  • MaillotAustralia.PNG [25]
  • MaillotCroacia.PNG [26]
  • MaillotCanadá.PNG [27]
  • MaillotColombia.PNG [28]
  • MaillotEspaña.PNG [29][30][31]
  • MaillotEslovenia.PNG [32]
  • MaillotAlemania.PNG [33]
  • MaillotFra.PNG [34][35]
  • Flag of the Papal States.gif [36][37]
  • Flag of the United States.svg [38]
  • Flag of Bavaria (striped).svg [39]
  • Flag of Germany (3-2 aspect ratio).svg [40]
  • Flag of Austria-Hungary (1869-1918).svg [41][42][43][44][45][46][47][48][49][50][51][52][53][54][55][56]
  • Flag of Greece (1822-1978).svg [57]
  • Flag of Guadeloupe (local).svg [58][59]
  • Flag of the Kingdom of Yugoslavia.svg [60][61]
  • Flag of Hungary.svg [62]
  • Flag of France.svg [63]
  • Flag of SFR Yugoslavia.svg [64]
  • Flag of England.svg [65]
  • Flag of Cape Verde.svg [66]
  • Flag of Italy (1861-1946).svg [67]
  • Flag of the Democratic Republic of the Congo.svg [68]
  • Flag of Martinique.svg [69]
  • Flag of the German Empire.svg [70]
  • Flag of Armenian SSR.svg [71]
  • Flag of the NSDAP (1920–1945).svg [72]
  • 600px Giallo.png [73]
  • 600px Blu e Bianco2.png [74]
  • 600px Blu.png [75]
  • 600px Rosso e Bianco (strisce).png [76]
  • 600px Celeste e Bianco (Strisce).png [77]
  • 600px Nero e Bianco (Strisce).png [78]
  • 600px Nero e Bianco (V sul petto).png [79]
  • 600px Bianco e Verde (Bordato).png [80]
  • Rose-pink.jpg [81]
  • Blu e Giallo.svg [82]
  • Coat of arms of the Central African Republic-NEW.png [83]
  • Logo du Parti socialiste belge.png [84]
  • Grammy Award Icon.png [85]
  • Fish icon.svg [86][87][88]
Hi Taketa, thanks for spotting this. The bot that imports the images uses the image in the page properties. For the first entry in the list, that's [89]. Pinging User:MaxSem, maybe he has ideas on how to fix this upstream, otherwise the bots will just keep adding these images. Multichill (talk) 17:41, 11 August 2014 (UTC)
I removed all these images. In future, I will track the import of such images at User:Pasleim/Implausible/image. --Pasleim (talk) 11:23, 12 September 2014 (UTC)
This section was archived on a request by: --Pasleim (talk) 20:26, 1 October 2014 (UTC)

bulk import Indonesian census data

Hi all. I made a fusion table from the 2010 Indonesian census measuring population of villages (where neighborhoods in big cities are also villages).

It's 77096 rows and structured data; is there a way for me to bulk upload this into WikiData?  – The preceding unsigned comment was added by Ocky7 (talk • contribs). (Moved from Wikidata:Requests for comment/bulk import Indonesian census data--GZWDer (talk) 10:25, 10 July 2014 (UTC))

User:Michiel1972 might want to look into this. I remember him doing something like this on the Dutch Wikipedia. Take for example Kapuk (Q4201177), that links to nl:Kapuk (Cengkareng). That's a bot generated article with the same data from 2010. The matching is usually the hardest part, but looks like every village has a "Code desa". We should probably have a property for that (if we don't have that already). Than we can just import all the data from the Dutch Wikipedia and source it to the original pdf. Multichill (talk) 10:53, 10 July 2014 (UTC)
I see that all site of "BADAN PUSAT STATISTIK" is copyrighted, so I think isn't possible to use the data. --ValterVB (talk) 18:31, 10 July 2014 (UTC)
This section was archived on a request by: Not done, no freely licensed data available. Multichill (talk) 19:12, 22 October 2014 (UTC)

copy names of humen

As the name of a humen is the same in every language, a bot should copy it to every language. Megascheli (talk) 15:31, 11 July 2014 (UTC)

Unfortunately, there are several issues:
  • If the original name is written in Cyrillic and it got transcripted into English (for example), then we can't copy it to other languages based on Latin scripts, because the transcription is language dependant. (e.g. Q7747)
  • word order: there are languages with "first name last name" and others with "last name first name"
  • handling of middle names and nicknames can also be language dependent
In short, it should be possible to copy certain labels but a bot user has to be very careful by doing so. --Pasleim (talk) 00:12, 12 July 2014 (UTC)

Okey, maybe this can be done in languages were are no problems, such as German and English. Megascheli (talk) 12:17, 12 July 2014 (UTC)

No, German and English has different orthographic systems so as transliteration rules. --Infovarius (talk) 10:59, 15 August 2014 (UTC)
This section was archived on a request by: --Pasleim (talk) 18:42, 6 December 2014 (UTC)

Coordinates of headquarters move

This request to related to one of P625 constraint violations, precisely that item with instance of (P31) company (Q783794) should not have coordinate location (P625) as separate statement, but as qualifier of appropriate statement (mostly headquarters location (P159)). So the request is following:

I am doing this by hand, so bot can save my work. --Jklamo (talk) 11:09, 12 July 2014 (UTC)

This still seems to be current. A query gives about 200 items where the coordinates can be (re)moved. Jklamo, what do you think, do it by hand? Multichill (talk) 19:19, 22 October 2014 (UTC)
Yes, still current. It is not hard to remove coordinates (one click), but moving requires at least 10 clicks per item using current UI, so I will welcome bot help. Still there is lot of "hand job" (items of companies with coors, but headquarters location (P159) missing, that needs to be found in article). --Jklamo (talk) 20:37, 22 October 2014 (UTC)
✓ Done --Pasleim (talk) 16:59, 23 November 2014 (UTC)
This section was archived on a request by: --Pasleim (talk) 18:42, 6 December 2014 (UTC)

US population

@ValterVB: a country with public domain public data, so we can try to use them. I do not know what the best source file is but at the county level, we have a fairly simple table with the years 2010-2013 here. --Zolo (talk) 15:10, 21 July 2014 (UTC)

@Zolo: Link don't work. --ValterVB (talk) 18:24, 21 July 2014 (UTC)
@ValterVB:. Ouch, apparently, the table needs apparently to be generated from this URL: http://factfinder2.census.gov/bkmk/table/1.0/en/PEP/2013/PEPANNRES/0400000US01.05000%7C0400000US02.05000%7C0400000US04.05000%7C0400000US05.05000%7C0400000US06.05000%7C0400000US08.05000%7C0400000US09.05000%7C0400000US10.05000%7C0400000US11.05000%7C0400000US12.05000%7C0400000US13.05000%7C0400000US15.05000%7C0400000US16.05000%7C0400000US17.05000%7C0400000US18.05000%7C0400000US19.05000%7C0400000US20.05000%7C0400000US21.05000%7C0400000US22.05000%7C0400000US23.05000%7C0400000US24.05000%7C0400000US25.05000%7C0400000US26.05000%7C0400000US27.05000%7C0400000US28.05000%7C0400000US29.05000%7C0400000US30.05000%7C0400000US31.05000%7C0400000US32.05000%7C0400000US33.05000%7C0400000US34.05000%7C0400000US35.05000%7C0400000US36.05000%7C0400000US37.05000%7C0400000US38.05000%7C0400000US39.05000%7C0400000US40.05000%7C0400000US41.05000%7C0400000US42.05000%7C0400000US44.05000%7C0400000US45.05000%7C0400000US46.05000%7C0400000US47.05000%7C0400000US48.05000%7C0400000US49.05000%7C0400000US50.05000%7C0400000US51.05000%7C0400000US53.05000%7C0400000US54.05000%7C0400000US55.05000%7C0400000US56.05000
Not very nice !
I finally found the same data on in a csv file http://www.census.gov/popest/data/counties/totals/2013/files/CO-EST2013-Alldata.csv
  • column I is the population at April 1 2010, from the 2010 census.
  • columns J, K, L and M are estimates for July 1 of 2010, July 1 2011, July 1 2012 and July 1 2013.
  • when the value of column E is "0" then the row is about a state, otherwise the row is about a county
  • when the row is about a county, the English sitelink should usually be equal to column G + ', ' + column F
There is a more detailed explanation here
--Zolo (talk) 20:29, 21 July 2014 (UTC)
@ValterVB: Now I have work for this week end :) I add only census or also estimated? --ValterVB (talk) 20:45, 21 July 2014 (UTC)
I would add them all ! I do not know which one should have rank = "preferred" though, so I asked at en:Wikipedia talk:WikiProject United States#Population data in Wikidata. --Zolo (talk) 21:22, 21 July 2014 (UTC)
@Zolo: I'm ready, Can I add rank = "preferred" for Censusu 2010? For it.wiki we haven't this problem, because with our lua module we can select more recent date or preferred date and other possibility --ValterVB (talk) 20:31, 18 August 2014 (UTC)
@ValterVB:. Thanks, I think you can. --Zolo (talk) 05:32, 20 August 2014 (UTC)
@ValterVB:, any update ? --Zolo (talk) 08:17, 2 September 2014 (UTC)
@Zolo: Sorry, just a bit busy with movies :) I'll start next days. --ValterVB (talk) 20:53, 2 September 2014 (UTC)
@Zolo: Can you check Aleutians West Census Area (Q185533)? If is OK I will do all like this. --ValterVB (talk) 19:26, 4 September 2014 (UTC)
@ValterVB:. That looks fine to me, except the precision +/- 1. I think it should be +/- 0 (the figures are certainly not accurate to the unit, but they are communicated as exact round numbers).
For +/-1 appear because I have made edit by hand and not with bot, final version is without +- like in Moncalieri (Q9474). --ValterVB (talk) 20:30, 4 September 2014 (UTC)
Also I see that you did not provide an URL for 2010, perhaps because there is already an URL in 2010 United States Census (Q523716). But the more intuitive URL for the 2010 census is a different one: http://www.census.gov/2010census/ . So I would also add the reference URL (P854): http://www.census.gov/popest/data/counties/totals/2013/files/CO-EST2013-Alldata.csv for the 2010 census figures. in the source for the 2010 census. For the source of other years, I think you can add author (P50): United States Census Bureau (Q637413), or something like this, as I did for July 2010. It will look better when transcluded in Wikipedia. --Zolo (talk) 20:16, 4 September 2014 (UTC)
@Zolo: I will do. --ValterVB (talk) 20:30, 4 September 2014 (UTC)
@ValterVB: I see that you have done it, thanks ! If you have time some day, it would certainly be good to do the same thing for smaller administrative units, but I cannot find a single file with everything (there are data here, but it is scattered in more than 50 tables). --Zolo (talk) 18:41, 11 September 2014 (UTC)
@Zolo: I made only one item ;) I can't use my bot until this problem is fixed. --ValterVB (talk) 18:49, 11 September 2014 (UTC)
@ValterVB: Oh I looked at only one item :D. Guess it means the script is ready though ;)--Zolo (talk) 18:51, 11 September 2014 (UTC)
@Zolo:Yes, only one click to start :) --ValterVB (talk) 18:59, 11 September 2014 (UTC)

@ValterVB, Zolo: On Aleutians West Census Area (Q185533), for 2010, stated in (P248) : 2010 United States Census (Q523716) and reference URL (P854) : http://www.census.gov/popest/data/counties/totals/2013/files/CO-EST2013-Alldata.csv are two distinct references. Shouldn't they be grouped in one only? — Ayack (talk) 08:15, 12 September 2014 (UTC)

@Ayack:: yes agree I had not noticed that. --Zolo (talk) 08:44, 12 September 2014 (UTC)
✓ Done. --ValterVB (talk) 08:50, 20 September 2014 (UTC)
Thanks user:ValterVB ! There seems to be a bug preventing me from reading the source at the moment, but I see that there are 2 references per value, did you take into account Ayack's suggstion to put several fields in a single reference ? Also, I think we forgot about that, but Help:sources says that we should provide retrieved (P813) when citing webpages. Would that still be possible to add it ? If not, I don't think that is too much of a problem here, as these data should remaing pretty stable. --Zolo (talk) 10:49, 20 September 2014 (UTC)
This section was archived on a request by: --Pasleim (talk) 18:42, 6 December 2014 (UTC)

Items with inconsistent sitelinks

Hi, it would be great if someone could have a bot run over the items listed at the bottom of Wikidata:True duplicates. These items have at least one sitelink which another item also has (typically all of them are on another item). Because of the restriction that a sitelink can only be on a single item, these are invalid and the data stored in them is not usable by the pages that are linked.

A bot should go over all of these invalid items and merge them with the other item(s) that have these sitelinks (or just blank/ delete the items if they don't have any value compared to the other item containing the data).

I'll rerun the script which created that list today and publish the new data over the weekend, thus the list will be up to date again on Monday (or earlier). Cheers, Hoo man (talk) 08:50, 11 July 2014 (UTC)

A list like User:Byrial/Duplicates would be even more useful. Thanks, --Ricordisamoa 16:27, 17 July 2014 (UTC)
Sadly that's not possible with the current version of the script which we use to gather that list. The list on Wikidata:True duplicates has been updated now, btw. - Hoo man (talk) 13:30, 18 July 2014 (UTC)

Ecoregions and anatomy

Two tasks, that I hope are not very difficult:

import "id" as WWF ecoregion code (P1294)
else
from the "name" in the template get the corresponding item and link it with ecoregion (WWF) (P1425) (there can be more than one)

Thanks!--Micru (talk) 14:56, 17 July 2014 (UTC)

Retrieved from "https://www.wikidata.org/w/index.php?title=Wikidata:Bot_requests/Archive/2014/07&oldid=188666114"