Wikidata:Bot requests/Archive/2021/06

Preferred rank for areas of German municipalities

Request date: 3 December 2020, by: 4ing

Link to discussions justifying the request
Task description

Most urban municipality in Germany (Q42744322) and municipality in Germany (Q262166) have two values for area (P2046): one imported from other Wikimedia projects or DBpedia (Q465), and one with Federal Statistical Office (Q764739) as reference (incl. reference URL (P854), title (P1476), archive URL (P1065) etc.). The latter also has point in time (P585) as qualifier. This latter value should be given preferred rank if not already done manually. Example: Borkum (Q25082).

Discussion

Working on this @4ing:. Using the following Query: https://w.wiki/3VEX Vojtěch Dostál (talk) 12:52, 15 June 2021 (UTC)

Task completed (19:25, 15 June 2021 (UTC)) @4ing: I might have left some out - please notify me of such cases if you notice them.

Request process

I think that this discussion is resolved and can be archived. If you disagree, don't hesitate to replace this template with your comment. Vojtěch Dostál (talk) 19:25, 15 June 2021 (UTC)

request to remove "(täsmennyssivu)" and "(sukunimi)" from labels (2021-01-07)

Request date: 7 January 2021, by: 87.95.206.253

Link to discussions justifying the request
Task description

Please remove (täsmennyssivu) and (sukunimi) from Finnish-language primary labels. Either remove them completely or move to AKA sections.
Reason: "(täsmennyssivu)" is fi-wiki's equivalent of en-wiki's "(disambiguation)", and "(sukunimi)" of "(surname)". Those shouldn't be added to primary labels. I've notified two bot operators concerning additions of "(täsmennyssivu)" to labels: special:diff/1336656747 and Topic:W131u7lu86s1qpxl. Thanks!

Licence of data to import (if relevant)
Discussion

There are only two labels with täsmennyssivu (https://w.wiki/3VKz) and one label with sukinimi (https://w.wiki/3VK$). So this can be fixed manually.Vojtěch Dostál (talk) 19:34, 15 June 2021 (UTC)

Request process
I think that this discussion is resolved and can be archived. If you disagree, don't hesitate to replace this template with your comment. Vojtěch Dostál (talk) 19:34, 15 June 2021 (UTC)

Fix values of P248 in references (2021-06-13)

Request date: 13 June 2021, by: Epìdosis

Link to discussions justifying the request
Task description

@Ladsgroup: In order to respect more strictly the value-type constraint (Q21510865) of stated in (P248), the following substitutions in references (unfortunately not doable through QS) are needed. --Epìdosis 20:08, 13 June 2021 (UTC)

Note: Before the first substitution (regarding Accademia delle Scienze di Torino ID (P8153)), #Accademia delle Scienze di Torino multiple references should be solved.

Query Remove Add
Sparql output (query) stated in (P248)Academy of Sciences of Turin (Q2822396) stated in (P248)www.accademiadellescienze.it (Q107212659)
Sparql output (query) stated in (P248)Accademia della Crusca (Q338489) stated in (P248)Catalogo degli accademici della Crusca (Q107212594)
Sparql output (query) stated in (P248)Académie Nationale de Médecine (Q337555) stated in (P248)www.academie-medecine.fr (Q107213173)
Sparql output (query) stated in (P248)Hungarian Academy of Sciences (Q265058) stated in (P248)mta.hu (Q107213548)
Sparql output (query) stated in (P248)Montpellier Academy of Sciences and Letters (Q2822394) stated in (P248)Montpellier Academy of Sciences and Letters (Q107214470)
Sparql output (query) stated in (P248)Académie des sciences d'outre-mer (Q337512) stated in (P248)www.academieoutremer.fr (Q107214481)
Sparql output (query) stated in (P248)Académie Française (Q161806) stated in (P248)academie-francaise.fr (Q107214508)
Sparql output (query) stated in (P248)Académie Française (Q161806) stated in (P248)academie-francaise.fr (Q107214508)
Sparql output (query) stated in (P248)Comité des travaux historiques et scientifiques (Q2985434) stated in (P248)annuaire prosopographique: la France savante (Q55740543)
Sparql output (query) stated in (P248)Académie des Sciences Morales et Politiques (Q337543) stated in (P248)academiesciencesmoralesetpolitiques.fr (Q107214612)
Sparql output (query) stated in (P248)Académie des sciences morales, des lettres et des arts de Versailles (Q2822337) stated in (P248)www.academiedeversailles.com (Q107214646)
Discussion

@Sapfan: Maybe we could add some more to the table? (Czech archives) Vojtěch Dostál (talk) 19:46, 14 June 2021 (UTC)

Thanks for letting me know! See below my list (copied from an earlier request which is still open) - can we add it? Unfortunately, there is an extra "IF", because I cannot guarantee that all the archive references should point to vital records.
If stated in (P248) is and title (P1476) begins with then change stated in (P248) to
Prague City Archives (Q19672898) Archiv hl. m. Prahy, Matrika Collection of Registry Books at Prague City Archives (Q105319160)
Prague City Archives (Q19672898) Archiv hl. m. Prahy, Soupis pražských List of residents in Prague 1830-1910 (1920) (Q105322358)
Moravian regional archive (Q12038677) Moravský zemský archiv, Matrika Collection of Registry Books at Moravian Regional Archive (Q102116996)
State Regional Archives Litoměřice (Q18920590) SOA Litoměřice, Matrika Collection of Registry Books at Litoměřice State Archive (Q105319095)
State Regional Archives in Pilsen (Q21953079) SOA Plzeň, Matrika Collection of Registry Books at Pilsen State Archive (Q105319092)
State Regional Archives in Prague (Q12056840) SOA Praha, Matrika Collection of Registry Books at Prague State Archive (Q105319086)
Regional State Archives in Třeboň (Q12056841) SOA Třeboň, Matrika Collection of Registry Books at Třeboň State Archive (Q105319089)
Státní oblastní archiv v Hradci Králové (Q17156873) SOA Zámrsk, Matrika Collection of Registry Books at Zámrsk State Archive (Q105319097)
Regional Archives in Opava (Q10860553) Zemský archiv v Opavě, Matrika Collection of Registry Books at Opava Regional Archive (Q105319099)
Museum of Czech Literature (Q5979897) Kartotéka Jaroslava Kunce Kunc Jaroslav (Q82329263)

Thanks in advance! --Sapfan (talk) 20:07, 14 June 2021 (UTC)

@Epìdosis@Sapfan@Vojtěch Dostál I started the first table, the second one is not that complicated. I will do that too. It'll just take some time. Amir (talk) 09:35, 19 June 2021 (UTC)

@Ladsgroup: Another one just emerged. Thanks, --Epìdosis 15:30, 25 June 2021 (UTC)

I continue adding others in the table below. --Epìdosis 12:28, 26 June 2021 (UTC)
@Epìdosis Started the clean up. Amir (talk) 15:54, 26 June 2021 (UTC)
Query Remove Add
Sparql output (query) stated in (P248)Munzinger-Archiv (Q974352) stated in (P248)Munzinger Personen (Q107343683)
Sparql output (query) stated in (P248)National Library of Australia (Q623578) stated in (P248)Trove (Q18609226)
Sparql output (query) stated in (P248)Museo Galileo (Q1668196) stated in (P248)Archivio di Autorità del Museo Galileo (Q105263158)
Sparql output (query) stated in (P248)Bibliothèque interuniversitaire de Santé (Q867925) stated in (P248)Base biographique (Q105958830)
Sparql output (query) stated in (P248)Nationalmuseum (Q842858) stated in (P248)Catalogue of the Nationalmuseum (Q107354917)
Sparql output (query) stated in (P248)Biblioteca Nacional de España (Q750403) stated in (P248)datos.bne.es (Q50358336)
Request process
Epìdosis All of your cases are done, unless they grew after fixing. @Sapfan @Vojtěch Dostál: I started the bot to fix your cases some examples Amir (talk) 20:02, 31 July 2021 (UTC)
Hi @Amir! Thanks for picking it up and starting the changes. I wanted to give thumbs up (because it mostly looks good), but please look at Eduard Ringelsberg (Q98736213). You have also converted Prague City Archives (Q19672898) into Collection of Registry Books at Prague City Archives (Q105319160) where the target should have been List of residents in Prague 1830-1910 (1920) (Q105322358), namely under sibling (P3373). The difference between the two is in the first part of the title (P1476), as written in the table. Also, you will see under the same property, that some of the Q have not been changed. Can you please fix this part of the logic? Thanks! --Sapfan (talk) 20:18, 31 July 2021 (UTC)
@Sapfan Hi, sorry it took me so long. The problem was actually more confusing that it looks. I had the logic to handle the title. The problem was that there was another ref in that statement (or that item) that had the other title so it got the greenlight from that ref. Fixed it now. Amir (talk) 17:12, 25 September 2021 (UTC)
Thank you, @Amir! I can see that most of the wrong assignments are now corrected. Let's close the request as proposed. Sapfan (talk) 18:09, 3 October 2021 (UTC)

@Epìdosis@Sapfan@Vojtěch Dostál This is done. Amir (talk) 22:37, 2 October 2021 (UTC) Task completed (22:37, 2 October 2021 (UTC))

I think that this discussion is resolved and can be archived. If you disagree, don't hesitate to replace this template with your comment. Amir (talk) 22:37, 2 October 2021 (UTC)

request to import podcast identifiers (2021-01-03)

Request date: 3 January 2021, by: Sdkb

Link to discussions justifying the request
Task description

Several properties have recently been created (see e.g. Castbox show ID (P9005) for podcast identifiers), which are being used for the new w:Template: Podcast platform links on Wikipedia. I was told to come here to get help importing the identifiers for a bunch of podcast items.

Licence of data to import (if relevant)
Discussion

@Sdkb: Please use https://pltools.toolforge.org/harvesttemplates/ , this doesn't need to be done by a bot.Vojtěch Dostál (talk) 12:32, 15 June 2021 (UTC)

@Vojtěch Dostál: thanks for looking at this. I just looked at Harvest Templates and have no clue how it would fetch external database data on podcast identifiers. Could you advise? {{u|Sdkb}}talk 15:48, 15 June 2021 (UTC)
@Sdkb: I thought you meant to ask bots to import data from w:Template: Podcast platform links. Is that incorrect? In that case, where do you want to import the data from, and using what key to assign the identifiers to items?Vojtěch Dostál (talk) 19:24, 15 June 2021 (UTC)
@Vojtěch Dostál: Sorry for the confusion. The podcast platform links template uses data from Wikidata, so I'm looking for Wikidata to mass-import the various identifiers it includes, such as Apple podcasts ID. I'd hope at least some of those could be imported from e.g. Apple itself, but beyond that I'm not sure. {{u|Sdkb}}talk 19:32, 15 June 2021 (UTC)
@Sdkb: Hmm, I am not sure you were advised correctly by @Sic19:. This page is, to my knowledge, reserved for mostly mindless works which require bots. However, what you have in mind is a dataset import, a much more complex endeavour consisting of several steps - acquisition of CC0-licensed data, cleaning, pairing to existing entities, import etc. Your proposal is a Wikidata version of someone on Wikipedia asking for an article to be written :-) Vojtěch Dostál (talk) 19:39, 15 June 2021 (UTC)
@Vojtěch Dostál: Ah, thanks for the info. Given the backlog at w:WP:Requested articles, I'm guessing if the analogy holds my odds aren't too great of it being taken up anytime soon. But I'll look at the dataset imports page and see if there's a place to add a request. {{u|Sdkb}}talk 19:47, 15 June 2021 (UTC)
@Sdkb: If you can be a little more specific about what dataset you want imported and how it could be done I might be interested in picking it up. But generically importing any data using unknown means (how we would link the datasets) it's a bit too much to do. BrokenSegue (talk) 23:54, 15 June 2021 (UTC)
@BrokenSegue: The most significant IDs are probably Apple, Google, and Spotify, so if any of those seem to have open data, those would be the ones to import. The structures at those places are explained at Apple Podcasts podcast ID (P5842), Google Podcasts show ID (P9003), and Spotify show ID (P5916). If that's enough for you to go off of, it'd be fantastic to see those properties showing up more often at Wikidata items, and would in turn allow us to start using w:Template: Podcast platform links more widely on Wikipedia. But if the data isn't open or something, we might just be out of luck; the next step would have to be reaching out to the platforms for help (they should theoretically be eager to help us, as it gets their name onto a bunch of podcast Wikipedia pages). {{u|Sdkb}}talk 01:42, 16 June 2021 (UTC)
Request process