Wikidata:Bot requests/Archive/2017/01

From Wikidata
Jump to navigation Jump to search

Q23667525

Delete descriptions --Bigbossfarin (talk) 14:36, 20 January 2017 (UTC)

 Not done this was a wrong merge --Pasleim (talk) 15:09, 20 January 2017 (UTC)
This section was archived on a request by: --Pasleim (talk) 15:09, 20 January 2017 (UTC)

Bot flag taken away?

The discussion is moved to Wikidata talk:Bots.--GZWDer (talk) 16:33, 19 January 2017 (UTC)

This section was archived on a request by: Matěj Suchánek (talk) 14:08, 21 January 2017 (UTC)

Units and access dates for items about Spanish beaches

I created between 1000 and 2000 items (like La Caracola (Q28122383)) about beaches in Spain using QuickStatements (Q20084080). However, this tool has some limitations and I couldn't add all the data with it.

We need... 

 for every item
 where
   item (wdt:instance of (P31)/wdt:subclass of (P279)*) (wd:beach (Q40080)) and
   item (wdt:country (P17)) (wd:Spain (Q29))
 do
   (add metre (Q11573) as a unit to all values in item
        for properties length (P2043) and width (P2049) when they don't have a unit) and
   (add (retrieved (P813) +2016-12-17T00:00:00Z/11)
        to all references in item that use reference URL (P854))
 done

These items (the where block) can be retrieved using this simple SPARQL query. --abián 14:49, 4 January 2017 (UTC)

 Doing… Next time, you can use the new version of QuickStatements which already implements these features. Matěj Suchánek (talk) 14:57, 21 January 2017 (UTC)
✓ Done I also removed implicit quantity bounds. Matěj Suchánek (talk) 14:54, 22 January 2017 (UTC)
This section was archived on a request by: Matěj Suchánek (talk) 14:54, 22 January 2017 (UTC)

Replacement P131 -> P159

Hi, a bit similar task, for instance of (P31) business (Q4830453) items to replace located in the administrative territorial entity (P131) with headquarters location (P159) with same statements. At the moment 341 items, ideally to run regularly (once a month maybe sufficient). --Jklamo (talk) 19:30, 27 January 2017 (UTC)

@Jklamo: What if there's already a headquarters location (P159) claim (e.g. Federal Reserve Bank of New York (Q115860))? Anyway, I'm ready to request adding this job to DeltaBot. Matěj Suchánek (talk) 10:50, 28 January 2017 (UTC)
In this case just leave them as they are. But I will add those cases as headquarters location (P159) constraint. Thanks for request for DeltaBot (as well as previous P159 coordinate task).--Jklamo (talk) 13:08, 28 January 2017 (UTC)
 Approved Matěj Suchánek (talk) 14:18, 28 January 2017 (UTC)
This section was archived on a request by: Matěj Suchánek (talk) 14:18, 28 January 2017 (UTC)

Unit replacement

Sorry, I made a mistake in import using incorrect units - centimetre (Q174728) instead of metre (Q11573). The values itself are correct. These items are affected: 

SELECT ?item ?itemLabel ?height WHERE {
  ?item wdt:P31/wdt:P279* wd:Q12280;
        p:P2048 ?statement .
  {
    ?statement psv:P2048 [
      wikibase:quantityAmount ?height; wikibase:quantityUnit wd:Q174728
    ] .
  } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } .
}
Try it!

Anybode can help me to fix this? --Jklamo (talk) 02:36, 28 January 2017 (UTC)

✓ Done Matěj Suchánek (talk) 10:41, 28 January 2017 (UTC)
Hah. I was writing the script for this and when later checked SPARQL query, it was empty :D --Edgars2007 (talk) 11:16, 28 January 2017 (UTC)
This section was archived on a request by: Matěj Suchánek (talk) 10:41, 28 January 2017 (UTC)

Replacement P36 -> P159

Hi,

Could a bot replace all the statements with capital (P36) by same statements with headquarters location (P159) (with references, qualifiers and maybe ranks) on all the 3000+ items with instance of (P31) sublass of association of French communes (Q2707796)?

Most of them were added by Nono314 but after a discussion here on his talk page and with Pymouss (AFK), headquarters location (P159) seems far better (closer to reality and sources).

Cdlt, VIGNERON (talk) 19:17, 27 January 2017 (UTC)

✓ Done Matěj Suchánek (talk) 16:52, 29 January 2017 (UTC)
This section was archived on a request by: Matěj Suchánek (talk) 16:52, 29 January 2017 (UTC)

Mass remove P421 of Q6985 in articles.

Careless me had mass-added UTC+08:00 (Q6985) to alot of items in New Jersey. Can someone mass remove the P421? I have corrected a few, but I don't care about that as well. MechQuester (talk) 05:02, 29 January 2017 (UTC)

✓ Done Matěj Suchánek (talk) 10:26, 29 January 2017 (UTC)
This section was archived on a request by: Matěj Suchánek (talk) 10:26, 29 January 2017 (UTC)

Mis-applied source

To my embarrassment, I have (as User:Pigsonthewing-bot, using QuickStatements) just imported ~2,600 Quora topic ID (P3417) values, with imported from Wikimedia project (P143) as a qualifier, rather than a source. An example is earring (Q168456). Can someone move the data, please? I've fixed the statements for the ongoing uploads. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 15:21, 29 January 2017 (UTC)

It seems, that imported from Wikimedia project (P143) is used more than 22tk times as qualifier. Seems like a regular job for DeltaBot, Pasleim. --Edgars2007 (talk) 15:46, 5 February 2017 (UTC)
✓ Done --Pasleim (talk) 10:21, 6 February 2017 (UTC)
This section was archived on a request by: --Pasleim (talk) 10:21, 6 February 2017 (UTC)

River

Hi, can someone add the rivers to descriptions. For example en:Category:Rivers of Montana. MechQuester (talk) 06:55, 4 January 2017 (UTC)


and also Q19558910 MechQuester (talk) 19:58, 4 January 2017 (UTC)

you could try out Descriptioner --Pasleim (talk) 16:05, 24 January 2017 (UTC)
:This section was archived on a request by: GZWDer (talk) 02:02, 29 August 2017 (UTC)

There used to be a bot that added labels based on sitelinks (enwiki sitelink => en label). I think it stopped running at some point. Maybe some alternative should be found.
--- Jura 08:32, 8 April 2016 (UTC)

I have seen, that Pasleim's bot is doing some job in this area, at least for German and French. --Edgars2007 (talk) 16:20, 9 April 2016 (UTC)
I do it for all the languages, but only for item that have one of these values in instance of (P31):

There is the problem with uppercase/lowercase --ValterVB (talk) 16:30, 9 April 2016 (UTC)

Another rule that I use: add label if the first letter of sitelink is one of this list:
  • (
  • !
  • ?
  • "
  • $
  • '
  • ,
  • .
  • /
  • 0
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9

If you have other suggestion I can add it --ValterVB (talk) 16:41, 9 April 2016 (UTC)

  •  Comment Just to make sure this is clear: this is mainly for items that exist and where someone added manually a sitelink to, e.g., enwiki, but the items doesn't have a label in the corresponding language yet. It does not concern items that don't have an English label, but no sitelink to English. I don't think search finds such items if they have no label defined at all. It's key that at least a basic label is defined for such items.
    If you are looking for rules to implement, then try the ones used by PetScan (Q23665536). It mainly removes disambiguators in round brackets. I think this works fine for Wikipedia. A large amount of pages are created that way. It might not work well for Wikisource.
    --- Jura 10:50, 10 April 2016 (UTC)
Jura, these rules are applied only on item that have a sitelink but don't have a label in language of the sitelinki. I check for all the sitelink that end with "wiki", excep "commonswiki", "wikidatawiki", "specieswiki", "metawiki" and "mediawikiwiki" and I delete disambiguation with parenthesis. --ValterVB (talk) 12:13, 10 April 2016 (UTC)

{{Section resolved|Sjoerd de Bruin (talk) 07:45, 19 September 2016 (UTC)}}

I think we still should try to do something about this. If we want to be purist and not add them as labels, I think they should be added at least as alias.
--- Jura 13:32, 20 September 2016 (UTC)

Maybe we should move the discussion to WD:PC or WD:RFC to get community consensus on one or the other solution. --Pasleim (talk) 13:59, 20 September 2016 (UTC)
+1 to move this discussion to WD:PC or WD:RFC, as Pasleim proposed. There are now a lot of items about human settlements for which we have labels only in sv and ceb, but it may be reasonable to copy these labels (from Geonames) to many other languages. --XXN, 22:51, 20 November 2016 (UTC)
The ceb/sv.. question has nothing to do with this request.
--- Jura 23:04, 20 November 2016 (UTC)
Hm, yep, it's an idea for a related more complex potential future proposal:) If so, your request is even much simpler (less controversial) and a consensus may be reached and here too.
At least addition of labels from sitelinks where they doesn't contain any type of parenthesis is almost uncontroversial and can be done ASAP. I'd support also addition of labels applying the rule of disambiguators removal, where is appropriate. --XXN, 00:28, 21 November 2016 (UTC)
  • I think PLbot currently is working on this task (not sure if for all languages); previously I've also noticed that Dexbot works on this but only for ar/fa Wikipedias. --XXN, 15:11, 11 December 2016 (UTC)
+BotNinja[1]. --XXN, 13:13, 1 January 2017 (UTC)

add locative as (en) alias

For places with a native label (P1705) in a language that has a locative case, it would be helpful if the form would be added as an alias.
Sample: Q1799#P1705 "Wrocław" > alias "Wrocławiu".
--- Jura 09:47, 18 September 2016 (UTC)
Question: Why? How can this be useful, in English particularly?
Concern: I have never heard of a bot which would successfully work with a fusional language (Q318917). Matěj Suchánek (talk) 07:50, 24 September 2016 (UTC)
The problem is that sometimes locations in Wikipedia (and elsewhere) are given in this form and don't necessarily link to corresponding articles.
Currently, there is no way for people to find this locations on Wikidata.
The bot would just add an alias. Obviously, the input lists would first need to be compiled.
--- Jura 12:56, 24 September 2016 (UTC)
@Matěj Suchánek:: Maybe it's easier to do it this way: Wikidata:Property proposal/locative.
--- Jura 12:37, 6 January 2017 (UTC)

Bloomberg data about people and private companies

We now have the properties Bloomberg person ID (P3052) and Bloomberg company ID (P3377). I consider the underlying data to be very valuable. There are many influential companies who don't have Wikipedia pages and their board members also don't have Wikipedia pages. It would be great if the data would make it's way into Wikidata. ChristianKl (talk) 19:47, 4 January 2017 (UTC)

Import Template:Bio from itwiki

To avoid that the gap gets to big, it might be worth doing another import. There are a series of steps outlined in Help:Import Template:Bio from itwiki.
--- Jura 17:08, 29 July 2016 (UTC)

P625 for items with P776

Coordinates in items with Swedish minor urban area code (P776) are often very poorly imported here. We now have a good source in Småorter 2015 (Q28048805) for many of these items. P776 can be found in column G in this spreadsheet and coordinates in SWEREF 99TM can be found in M and N.

My opinion is that the current P625 can be removed from these items and the coordinates from this source can be used instead. The coordinates can be rounded to nearest second and the data will be good enough for our use. These entities can be as small as 100x100 meters, so rounding it even further does not do the job.

Not all items who should have P776, have it yet. I am working on that right now. But I see no point in waiting the 2-3 years it will take until I have finished that job. (Yes, I think it has to be done by hand.) -- Innocent bystander (talk) 10:01, 22 December 2016 (UTC)

@Innocent bystander: Is there some forumla to convert SWEREF 99TM coordinates to WGS84 coordinates? --Pasleim (talk) 12:34, 17 January 2017 (UTC)
@Pasleim: Well, there is probably somewhere, but User:RoMex has done the work here if it is of some use? Also note that some if these items have two P625-claims. One is enough! -- Innocent bystander (talk) 12:49, 17 January 2017 (UTC)
There is such script available, if that makes life easier than svwiki page. Google search for "SWEREF 99TM to wgs" has some other results. --Edgars2007 (talk) 16:10, 17 January 2017 (UTC)
Since I think we can round this number to nearest second, to be more useful for our templates in Wikipedia, I think any flaws in such an algoritms are of very little concern. -- Innocent bystander (talk) 19:41, 17 January 2017 (UTC)

Add P1082 (population) and P585 (point in time) from PLwiki to Wikidata

Looks like PLwiki has lots of population information other Wiki does not have. It will be useful to have it for all of us. בורה בורה (talk) 18:23, 12 April 2016 (UTC)

It might be helpful to give some supporting links here, to be sure to get the right information from the right place into the right fields. Can you list one pl-article and one corresponding wikidata-item that is manually filled with the desired information? Than I can see if I can get the information filled by a script in the same way. Edoderoo (talk) 18:26, 16 April 2016 (UTC)
Edoderoo sorry for the late reply. I was on vacation. Take for example the article "Żołynia" in PLwiki. It has a population of 5188 as of 2013. However this information does not exist on Wikidata item (Q2363612). There are thousands of examples like this, but you got the idea... PLwiki is really great on population. Share it with us all. בורה בורה (talk) 10:19, 4 May 2016 (UTC)
It would be better to find a reliable source instead. Sjoerd de Bruin (talk) 07:44, 19 September 2016 (UTC)
בורה בורה: No activity for a long time. Marking this one as resolved. Multichill (talk) 11:43, 30 November 2016 (UTC)
Multichill, What do I suppose to say? I put a request, I explain it and it is not done yet... In many Wikidata items I see ENwiki or RUwiki as a source. Why can't PLwiki be a source as well? Please reopen this request and put it back in the queue. I appreciate if you tag me on your reply. בורה בורה (talk) 03:36, 1 December 2016 (UTC)
בורה בורה: You request something, you should keep an eye on it for example by putting this page on your watchlist and reply if someone responds. That way tasks get resolved (or declined) quickly.
I had a look at pl:Żołynia. It uses the template pl:Template:Wieś infobox with the fields "liczba ludności" and "rok". I assume "liczba ludności" would map to population (P1082) and "rok" would be the source for the point in time (P585) qualifier like this example?
I agree with Sjoerd that a real source is preferred over import from Wikipedia, but that doesn't mean we shouldn't import this. We can always add references when a real source becomes available.
@Edoderoo: do you want to have a shot at this one? Multichill (talk) 10:42, 1 December 2016 (UTC)
Thanks for the ping. I can have a look this month to this one. Edoderoo (talk) 10:56, 1 December 2016 (UTC)
Multichill indeed your mapping is correct. I am standing by to see when this is done. Once completed our articles will be populate automatically as we are retrieving the info from Wikidata! בורה בורה (talk) 18:38, 1 December 2016 (UTC)
Multichill, Edoderoo, any progress here? בורה בורה (talk) 19:15, 18 December 2016 (UTC)
Sorry, my bot got blocked and the bot-bit revoked, so for the time being I can create a script, but I can't test nor execute it... Edoderoo (talk) 15:39, 18 January 2017 (UTC)
To clarify this, I asked Edoderoo to create a RfBots for the particular tasks he wants to be doing, but he decided not to do that. --Vogone (talk) 03:36, 19 January 2017 (UTC)

User script to notify participants in a property proposal

Tracked in Phabricator
Task T139898

Normally when a property proposal is closed the participants should be informed with a "ping", however this is done manually and it takes a lot of effort for long discussions. Would it be possible to create a script that would scrap all the user names in a property proposal page and would format the resulting list as a ping? (in groups of 5, because I think that is the limit).--Micru (talk) 20:27, 19 January 2017 (UTC)

This sounds like a good idea. Work that can be done by bots should be done by bots ;) ChristianKl (talk) 10:46, 23 January 2017 (UTC)
See phab:T139898.--GZWDer (talk) 17:23, 24 January 2017 (UTC)

Natural RU names

Per this discussion, we need to run a bot that would convert all Russian labels for people's entities into a "normal" form - "[First_name] [Patronymic_or_Middle_name] [Last_name]", instead of "Last, First Patronymic". The existing form of the name should be moved to the "Also known as" column. I suspect that Kyrgyz and Ukranian languages would also benefit from it. --Yurik (talk) 03:14, 22 January 2017 (UTC)

I am working on this. There are some questions which I'll discuss at the forum. --Infovarius (talk) 20:43, 22 January 2017 (UTC)

Census of Population data of Philippines Cities, Municipalities, Provinces and Regions (1903-2007)

  • Source: Philippine Statistics Authority
  • Link: https://archive.org/download/PhilippinesCensusofPopulationLGUs19032007 (As FOI request, Philippines public domain)
  • Description: Census of Population data of Philippines Cities, Municipalities, Provinces and Regions (1903-2007)
  • Structure: Population (P1082)
  • Covers all
    • municipality of the Philippines (Q24764)
    • city of the Philippines (Q104157)
    • province of the Philippines (Q24746)
    • region of the Philippines (Q24698)
  • Example item
    • Municipality : Dasol (Q41917)
    • City : Urdaneta (Q43168)
    • Province : Pangasinan (Q13871)
    • Region: Ilocos Region (Q12933)

Major upload needed, hard to do it manually. 2010 and 2015 data already present --Exec8 (talk) 05:02, 28 January 2017 (UTC)

Delete redirects

Lists like Josve05a's User:Josve05a/dupes tend to be full of redirects with sitelinks. Samples: Q5145525 and Q23812706. Would you delete all sitelinks on these items that are redirects?

Obviously, a solution that would solve this for even more item would be better.
--- Jura 23:41, 12 September 2016 (UTC)

For seeking/finding/implementing a more general solution, I created phab:T145522.
--- Jura 07:38, 14 September 2016 (UTC)
I have cleaned up those lists. I'm almost 100% sure there is a repository with database reports regarding redirects per project. I'll search for it later. Matěj Suchánek (talk) 20:52, 30 January 2017 (UTC)
Retrieved from "https://www.wikidata.org/w/index.php?title=Wikidata:Bot_requests/Archive/2017/01&oldid=1377511558"