Wikidata:Bot requests/Archive/2018/01

‎Convert P1343->P248 qualifier to be P1343-> P805 qualifier

Request date: 13 January 2018, by: Billinghurst

Link to discussions justifying the request
Task description
Licence of data to import (if relevant)

N/A

Discussion

The current use of P1343 -> P248 is generating a constraint violation as P248 is identified as only to be used for references. The above linked conversation stated that P805 was the more appropriate property to use. There will be 10s of thousands of these at a bare minimum as it was the recommended means to link at Wikidata:WikiProject Books  — billinghurst sDrewth 10:51, 13 January 2018 (UTC)

Request process
  Doing… --Pasleim (talk) 13:23, 24 January 2018 (UTC)
  Done --Pasleim (talk) 23:52, 24 January 2018 (UTC)
This section was archived on a request by: --Pasleim (talk) 23:52, 24 January 2018 (UTC)

UK station codes

Please can someone migrate codes for railway stations in the United Kingdom from station code (P296) to the newly-created UK railway station code (P4755)? Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 16:05, 18 January 2018 (UTC)

@Pigsonthewing: - if you can give me a query showing all the codes that need migrated, I'll get it done - don't want to try it off my own bat in case I move the wrong entries. Andrew Gray (talk) 18:07, 21 January 2018 (UTC)

@Andrew Gray: Late reply sorry - I've been travelling. This seems to do the trick:

SELECT ?train_station ?train_stationLabel ?station_code WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  ?train_station wdt:P31 wd:Q55488.
  ?train_station wdt:P17 wd:Q145.
  ?train_station wdt:P296 ?station_code.
}
LIMIT 2500
Try it!

-- Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 19:10, 27 January 2018 (UTC)

@Pigsonthewing: Okay, all running now. Report below to confirm when they're all done... Andrew Gray (talk) 20:18, 27 January 2018 (UTC)
SELECT distinct ?train_station ?train_stationLabel ?station_code_old ?station_code_new WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  ?train_station wdt:P31 wd:Q55488.
  ?train_station wdt:P17 wd:Q145.
  {?train_station wdt:P296 ?station_code_old} UNION { ?train_station wdt:P4755 ?station_code_new }
}
Try it!
See further discussion on my talk page. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 15:51, 28 January 2018 (UTC)
This section was archived on a request by: Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 15:51, 28 January 2018 (UTC)

Some labels in French

Request date: 17 January 2018, by: Moumou82

Link to discussions justifying the request

None

Task description

I would like to ask for support to add labels in French in the following instances:

  • "Tunisian handball player": add "handballeur tunisien" if P21=Q6581097 or "handballeuse tunisienne" if P21=Q6581072
  • "Tunisian volleyball player": add "volleyeur tunisien" if P21=Q6581097 or "volleyeuse tunisienne" if P21=Q6581072

I also would like to harmonize existing labels in French to match the most frequent naming:

  • "footballeur tunisien": change to "joueur de football tunisien"
Licence of data to import (if relevant)
Discussion
Request process

  Done --Pasleim (talk) 17:08, 31 January 2018 (UTC)

This section was archived on a request by: --Pasleim (talk) 17:08, 31 January 2018 (UTC)

Dates: August–December 2017

Merge all date-links of August–December 2017 between at least 1 August–10 December 2017 in the languages Czech, English, French, Portuguese and Spanish. Like this Q42123488 (already fixed). Items usually exist in Spanish, so there's no need to create new items. I've already fixed some. This is just ordinary language-linking, and needs no support from controversial discussions.

J 1982 (talk) 10:47, 12 November 2017 (UTC)

@J 1982: most items can't be merged because frwikinews has two sitelinks for each date, e.g. September 10, 2017 (Q37787943) and Q37802406 --Pasleim (talk) 10:05, 17 December 2017 (UTC)
  • I made a list for 2018. Maybe a bot could attempt to connect periodically (daily, hourly?) new pages to (some of) the items. --- Jura 21:21, 17 December 2017 (UTC)
    • It seems that 20% of the pages already existed (notably pt/fr, some ja/zh). I linked these. All items now have sitelinks. Periodically checking and adding new pages could save us countless duplicates days items generate --- Jura 23:52, 19 December 2017 (UTC)
    • Some wikis appear to create them day-by-day, others for a quarter or an entire year. Some languages have a lot of content on every page, others have empty ones for every day of a month.
      --- Jura 13:13, 21 December 2017 (UTC)
  • I merged a few more items for 2017 and added facet of (P1269) to the item for the second French link. This increased the number of sitelinks on the main items for that year from 1600 to 2900. --- Jura 14:19, 19 December 2017 (UTC)
    • I added more sitelinks for 2017. We know have about 4500. While these items probably provide useful sitelinks to Wikinews, a good use for the items within Wikidata still needs to be found.
      --- Jura 13:13, 21 December 2017 (UTC)
  Done by Jura1 --Pasleim (talk) 10:05, 9 January 2018 (UTC)

OSM tag/ key URLs

Until such time (if ever) that OpenStreetMap tag or key (P1282) is converted to an 'external ID' datatype, please add URL qualifiers to all of its values, like in this example edit. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 13:49, 3 January 2018 (UTC)