Tagishsimon
Qs
editInstead of typing [[Q20747326|Mary Mogg]]
, you can use {{Q|20747326}}
. This renders as:
and has the advantage of displaying the label in the reader's preferred language. Same goes for properties; {{P|496}}
renders as:
Cheers, Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 19:38, 27 September 2016 (UTC)
- Thanks. I'm taking first steps, as you see. Related to the experimental w:User:Tagishsimon/test, a listing of ODNB women with no wikipedia article. --Tagishsimon (talk) 20:07, 27 September 2016 (UTC)
Beleidigungen
editMehr hast du nicht auf dem Kasten? --Succu (talk) 23:17, 2 November 2016 (UTC)
- Grow up. --Tagishsimon (talk) 23:19, 2 November 2016 (UTC)
- Soll ich größer oder erwachsener werden. Beides ist nicht mehr möglich. --Succu (talk) 23:22, 2 November 2016 (UTC)
Why did you tag a Southpark episode of being human and female? Multichill (talk) 15:23, 11 November 2016 (UTC)
- By not noticing it in a large petscan listing. You need to be able to deal with a small number of errors in a large number of automated edits ... eventually a human will come along and fix it. --Tagishsimon (talk) 15:26, 11 November 2016 (UTC)
Items for women
editI saw your comment about women wrongly tagged as male. A serious issue, but I suspect there are more with no gender at all; see the column in Wikidata:Database reports/Humans with missing claims, and please fix a few from time to time. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 20:57, 12 December 2016 (UTC)
- Thanks. That's handy. --Tagishsimon (talk) 21:03, 12 December 2016 (UTC)
Kindly let me know what I Have to do in the below link and what is the cause of its creation
edithttps://www.wikidata.org/wiki/Q28017188 yours sincerely, --Maaley (talk) 00:28, 16 December 2016 (UTC)
Item to be delete
editIn RFD there are one or more item proposed for the deletion created by you. If you do not agree you can participate in the debate --ValterVB (talk) 23:38, 3 March 2017 (UTC)
Romans
editHi Tagishisimon. Thanks for your help with adding name statements to people items. BTW, you might want to look into the convention for (some) Romans: Wikidata:WikiProject_Names/Help#Roman_names. Those with these wont have P735/P734.
--- Jura 07:33, 17 December 2017 (UTC)
- Idem. --Romulanus (talk) 10:20, 17 December 2017 (UTC)
- Thanks Jura & Romulanus. I'll roll my edits back in line with Wikidata:WikiProject_Names/Help#Roman_names. --Tagishsimon (talk) 11:04, 17 December 2017 (UTC)
Not sure if I steered you in slightly the wrong direction, but you should watch out when using subject named as (P1810) and described at URL (P973): on an item like Given Lubinda (Q5565823) you have them the wrong way around at the moment: subject named as (P1810) should only be used as a qualifier, and described at URL (P973) should not be used as one. You can see the definition at the property constraint (P2302) section of each Property (or if you turn on the checkConstraints Gadget in your Preferences --Oravrattas (talk) 21:56, 22 December 2017 (UTC)
- I'll be switching them around :) --Tagishsimon (talk) 23:34, 22 December 2017 (UTC)
Heads of State
editWoot! The Heads of State Report is looking a lot better now. Thanks for filling in all those gaps! --Oravrattas (talk) 07:11, 31 December 2017 (UTC)
Creación de un nuevo actor de doblaje
editHola, gracias por tu respuesta!! Ya había leído ese artículo pero la verdad no se que hacer, no se como o donde he de dar de alta la información o si he de usar una plantilla ya diseñada o si he de partir de 0, me gustaría tener un formato similar al del actor Pepe Mediavilla. Gracias por tu ayuda. Javi.abengozar (talk) 08:32, 27 January 2018 (UTC)
@Javi.abengozar: comenzar en la página a la que me he vinculado - [1]. Agregue el nombre y la breve descripción, pulse Aceptar. En la siguiente página, presiona "Agregar declaración". En el campo Propiedad, comience a escribir "instancia de". Seleccione la "instancia de" que se ofrece como menú desplegable debajo del campo de propiedad. Ahora seleccione el valor, en este caso "ser humano". Presione el botón Publicar. En resumen, debe "Agregar declaración", seleccionar la propiedad que desea, luego agregar el valor de esa propiedad, por lo tanto, "sexo o género", "país de nacionalidad", etc. Tal vez vaya a una página existente y presione "editar" contra una propiedad existente para ver cómo se comporta la interfaz de usuario. Espero que ayude. Disculpas por google-translate español! --Tagishsimon (talk) 11:59, 27 January 2018 (UTC)
Chinese given name
editHello,
On December 17 you added a lot of given name (P735) to Chinese people like this [2]. But the Chinese people's first name is their family name, isn't it? For example, Mao Zedong (Q5816) is called "Mao", not "Zedong". Some of his children are called Mao too. What do you think? It seems that you corrected Roman people, why not Chinese ones? --El Caro (talk) 14:51, 26 March 2018 (UTC)
- @El Caro: Agreed. Why? No-one pointed out the Chinese error, and it didn't occur to me. I've had a wander through my edits & removed some more. --Tagishsimon (talk) 18:00, 26 March 2018 (UTC)
- This is where we are right now - at least for the current state of China;
I'll add older incarnations of the state later.Added. --Tagishsimon (talk) 18:19, 26 March 2018 (UTC)
- This is where we are right now - at least for the current state of China;
- Try it!
SELECT ?item ?itemLabel ?givenLabel WHERE { {?item wdt:P27 wd:Q148 .} UNION {?item wdt:P27 ?state . ?state wdt:P31 wd:Q50068795 . } ?item wdt:P735 ?given . SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } order by ?givenLabel
- Thank you! --El Caro (talk) 06:37, 27 March 2018 (UTC)
- Thanks, El Caro. I've now been through the complete list & removed all probably incorrect given names; with luck, we're now good. --Tagishsimon (talk) 14:17, 27 March 2018 (UTC)
- Thank you! --El Caro (talk) 06:37, 27 March 2018 (UTC)
Share your experience and feedback as a Wikimedian in this global survey
editHello! The Wikimedia Foundation is asking for your feedback in a survey. We want to know how well we are supporting your work on and off wiki, and how we can change or improve things in the future. The opinions you share will directly affect the current and future work of the Wikimedia Foundation. You have been randomly selected to take this survey as we would like to hear from your Wikimedia community. The survey is available in various languages and will take between 20 and 40 minutes.
You can find more information about this survey on the project page and see how your feedback helps the Wikimedia Foundation support editors like you. This survey is hosted by a third-party service and governed by this privacy statement (in English). Please visit our frequently asked questions page to find more information about this survey. If you need additional help, or if you wish to opt-out of future communications about this survey, send an email through the EmailUser feature to WMF Surveys to remove you from the list.
Thank you!
Please stop
editYour current edits are very flawed, and also flooding the RC without a bot/flood flag. Please stop. Thanks. --Yair rand (talk) 04:03, 12 April 2018 (UTC)
- What's the flaw? --Tagishsimon (talk) 04:07, 12 April 2018 (UTC)
- Edits to items like Q4 and Q30 are importing nonsense. Among other edits, label imports are violating WD:L. Those are just the ones I noticed in a few seconds of looking. In any case, doing so many edits unflagged is itself problematic and against policy. --Yair rand (talk) 04:12, 12 April 2018 (UTC)
- I grant you 4 & 30. They seem to be outliers. The rest? Better to have the en.wiki article title as a label, than no label. You're now doing more harm than good - [3] for instance? --Tagishsimon (talk) 04:16, 12 April 2018 (UTC)
- You can't just copy the enwiki article title and assume it will be a valid label: Rules are different on capitalization, disambiguating bracketed text and text after commas in place names, and other issues. "Chengqu Subdistrict, Yuanshi County" is not the correct label, per WD:L. Making so many edits so fast makes it impossible to check for incorrect additions. --Yair rand (talk) 04:21, 12 April 2018 (UTC)
- I don't assume it is the best label. I presume it is better than no label, and that if it can be improved, it will be. --Tagishsimon (talk) 04:25, 12 April 2018 (UTC)
- Really? [4], [5] And the problems with these were? --Tagishsimon (talk) 04:27, 12 April 2018 (UTC)
- The options are not "don't do it at all" or "do it with lots of flaws", they're "do it well" or "do it with thousands of mistakes, and then spend countless hours cleaning it up". I don't know how we're going to track down all the edits like this and this, but it's probably going to involve a whole lot more manual effort than went into making the problematic edits in the first place. While m:Cunningham's Law may apply to incorrect label capitalizations, it's not a fair way to get things fixed. Please don't make edits on a large scale that you're not willing to take responsibility for. (Sorry, I'm being a bit harsher than I intended, but I'm going to have to spend a lot of time looking through your edits because of this, which is formally always the bot operator's responsibility, but...) --Yair rand (talk) 04:42, 12 April 2018 (UTC)
- I'm quite prepared to take responsibility for my edits. I'm not prepared to tolerate the best driving out the good. Are you /seriously/ telling me that you're reverting abouse you don't like capitalisation? I grant 4, 30 & 40 are egregious, as is the football. What about [6], [7]? --Tagishsimon (talk) 04:52, 12 April 2018 (UTC)
- I had already added the label for Q9034636 with the correct capitalization before your prior post, but I don't intend to fix up all of them. It is generally easier to add the correct version than it is to fix a wrong one, as we generally want to avoid bots undoing the more correct work of a human editor. It's more efficient to rollback, since there are too many to easily fix up manually. Unless you're volunteering to go through the rest and fix up the capitalizations manually? --Yair rand (talk) 04:58, 12 April 2018 (UTC)
- It would certainly seem to me that I could do it faster than you, having the original input information to hand. We disagree, however, that capitalisation necessitates rollback. --Tagishsimon (talk) 05:06, 12 April 2018 (UTC)
- If you're willing to go through them and fix them, I don't need to rollback the edits. Are you willing to go through the edits and fix the various issues? --Yair rand (talk) 05:13, 12 April 2018 (UTC)
- It would certainly seem to me that I could do it faster than you, having the original input information to hand. We disagree, however, that capitalisation necessitates rollback. --Tagishsimon (talk) 05:06, 12 April 2018 (UTC)
- I had already added the label for Q9034636 with the correct capitalization before your prior post, but I don't intend to fix up all of them. It is generally easier to add the correct version than it is to fix a wrong one, as we generally want to avoid bots undoing the more correct work of a human editor. It's more efficient to rollback, since there are too many to easily fix up manually. Unless you're volunteering to go through the rest and fix up the capitalizations manually? --Yair rand (talk) 04:58, 12 April 2018 (UTC)
- I'm quite prepared to take responsibility for my edits. I'm not prepared to tolerate the best driving out the good. Are you /seriously/ telling me that you're reverting abouse you don't like capitalisation? I grant 4, 30 & 40 are egregious, as is the football. What about [6], [7]? --Tagishsimon (talk) 04:52, 12 April 2018 (UTC)
- The options are not "don't do it at all" or "do it with lots of flaws", they're "do it well" or "do it with thousands of mistakes, and then spend countless hours cleaning it up". I don't know how we're going to track down all the edits like this and this, but it's probably going to involve a whole lot more manual effort than went into making the problematic edits in the first place. While m:Cunningham's Law may apply to incorrect label capitalizations, it's not a fair way to get things fixed. Please don't make edits on a large scale that you're not willing to take responsibility for. (Sorry, I'm being a bit harsher than I intended, but I'm going to have to spend a lot of time looking through your edits because of this, which is formally always the bot operator's responsibility, but...) --Yair rand (talk) 04:42, 12 April 2018 (UTC)
- Really? [4], [5] And the problems with these were? --Tagishsimon (talk) 04:27, 12 April 2018 (UTC)
- I don't assume it is the best label. I presume it is better than no label, and that if it can be improved, it will be. --Tagishsimon (talk) 04:25, 12 April 2018 (UTC)
- You can't just copy the enwiki article title and assume it will be a valid label: Rules are different on capitalization, disambiguating bracketed text and text after commas in place names, and other issues. "Chengqu Subdistrict, Yuanshi County" is not the correct label, per WD:L. Making so many edits so fast makes it impossible to check for incorrect additions. --Yair rand (talk) 04:21, 12 April 2018 (UTC)
- I grant you 4 & 30. They seem to be outliers. The rest? Better to have the en.wiki article title as a label, than no label. You're now doing more harm than good - [3] for instance? --Tagishsimon (talk) 04:16, 12 April 2018 (UTC)
- I think it's a good idea to attempt to do something about these items (with a sitelink in a language, but no label in the same). However, most of these were skipped by various bot operators on purpose. It might be worth opening a discussion on project chat on how to go about these.
--- Jura 06:47, 12 April 2018 (UTC)
Reminder: Share your feedback in this Wikimedia survey
editEvery response for this survey can help the Wikimedia Foundation improve your experience on the Wikimedia projects. So far, we have heard from just 29% of Wikimedia contributors. The survey is available in various languages and will take between 20 and 40 minutes to be completed. Take the survey now.
If you have already taken the survey, we are sorry you've received this reminder. We have design the survey to make it impossible to identify which users have taken the survey, so we have to send reminders to everyone. If you wish to opt-out of the next reminder or any other survey, send an email through EmailUser feature to WMF Surveys. You can also send any questions you have to this user email. Learn more about this survey on the project page. This survey is hosted by a third-party service and governed by this Wikimedia Foundation privacy statement. Thanks!
Ping IP
editI never saw a ping, seems not to work for IPs. Thanks for all your help!!! 77.180.35.91 17:01, 23 April 2018 (UTC)
- So please, get an account. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 12:22, 5 May 2018 (UTC)
Since you work on human data, maybe you are interested in commenting. 77.180.110.58 16:49, 25 April 2018 (UTC)
Hello, please review edits like [8]. — Ivan A. Krestinin (talk) 09:12, 5 May 2018 (UTC)
- @Ivan A. Krestinin: Yes, that's fairly poor. Another ten examples found & fixed; zero left. Thanks for letting me know. --Tagishsimon (talk) 11:40, 5 May 2018 (UTC)
Taking you up on your offer to help
editThanks for your help in connection with my project chat request about creating a list of Q values.
Before I asked my current question, I want to point out that your query led to some ancillary issues.
The way the table was originally created, it doesn't have a count of lines, and when I saw that your output had 351 entries when I was thinking there should be 349 lead me to realize that to additional items have been added so I have updated the count on that page.
The second issue is that the editor who helped create the templates is no longer active. While they were generally fine and have worked for the purposes for which they were intended, the fact that you had a number of failed hits revealed that the original editor used a canonical form of the article title. If you teams have a nonstandard title, and while the standard title always exists, in some cases it is a redirect. That's what caused your query to have a small number of failed items. I've gone to the template and replaced the redirects with a direct link so while I do not anticipate having to run the query again, if it were or if someone else were to run a similar query, they would not run into that problem.
While that wasn't your intention, thank you for highlighting a couple issues that have now been resolved.
On to my question.
I'm still unhappy (not with you) that the system requires a nonstandard way of identifying the main category. It's a pain, and one of the reasons I thought I'd look into quick statements.
However, I tried creating some quick statements to add the main category and failed miserably. I'm copying the statements below:
Q30325978 P910 "Category:Cal Poly Mustangs women's basketball"
Q30325977 P910 "Category:Cal State Fullerton Titans women's basketball"
Q30325901 P910 "Category:Cal State Northridge Matadors women's basketball"
Q5684359 P910 "Category:Hawaii Rainbow Wahine basketball"
Q21565045 P910 "Category:Long Beach State 49ers women's basketball"
Q30592518 P910 "Category:UC Davis Aggies women's basketball"
Q30325980 P910 "Category:UC Irvine Anteaters women's basketball"
Q30325939 P910 "Category:UC Riverside Highlanders women's basketball"
Q30325905 P910 "Category:UC Santa Barbara Gauchos women's basketball"
In my first attempt, I didn't have the quotes around the category and that failed so I thought that was the problem but after adding the quotes it still fails. Can you tell me what I'm missing?--Sphilbrick (talk) 21:41, 14 May 2018 (UTC)
- @Sphilbrick: sorry, I'm stumped, too. I've tried all sorts of variations, but all yield "invalid snak data", which error message doesn't lead to any greater insight. Very odd. @Magnus Manske: - what are we missing? --Tagishsimon (talk) 22:20, 14 May 2018 (UTC)
- Wow, going after the big guns! I guess I don't have to feel embarrassed that I missed something trivial.--Sphilbrick (talk) 23:34, 14 May 2018 (UTC)
Finding errors
editOne other question: I'm running some quick statements in batch mode. Several went fine but a recent batch 2601, says it has two errors. I don't know how to look and see the errors. link--Sphilbrick (talk) 14:04, 15 May 2018 (UTC)
- @Sphilbrick: Sadly, the documentation says, of batch mode, "But there are also drawbacks: You can only see the total number of errors, not the statements that produced an error. Actually, you can not see any statement." :(
- Equally, I can probably knock up a SPARQL query, if that'll help you track down the couple of records which didn't get actioned ... you'd need to tell me what the batch was doing. --Tagishsimon (talk) 23:26, 15 May 2018 (UTC)
- That's OK, I just assumed it would be easy to track down. I have to look at many of these items manually for other reasons, so I may figure it out then, and if not, I don't think the world will end. Thanks for pointing me to the documentation, which also explains some other things.--Sphilbrick (talk) 01:41, 16 May 2018 (UTC)
--Sphilbrick (talk) 18:41, 25 May 2018 (UTC)== Checking my work ==
With your help, I've been working on adding data to articles about NCAA Division I women's basketball teams in the US.
I've reached the point where I'd like to do a couple things that I think are related. I'd like tolearn how to run a report to output the results, for example create a list of all nicknames. Before I do that, I'd like to double check my work by running a report to identify the elements I have added to see which ones I'm missing and/or made a mistake.
I'm not quite sure where to start. Do I create a report or a query are these the same things?
You may recall that you created a report for me to generate a Q values from the article titles (as an aside, that report had a small glitch arising from redirects which I believe I fixed).
I'm not sure whether I start with that report and ask for different output, whether I create a report that starts with the Q values (which I have in a spreadsheet somewhere) or do something else.
As a specific example, some of the teams have a description and in some cases it is blank. I want to fill in the blank ones with quick statements (which I know how to do), but I'd like to make a list of all the Q values with blank descriptions. However, rather than simply figure out how to do a report that lists only the blank descriptions I'd like a report that lists all descriptions so I can inspect the existing ones to see if there are any that need correcting, then sort the list to get all the blank ones and then extract the Q values and do quick statements.
Does this approach makes sense?
Then I like to rinse and repeat for home venues (I filled in most but I know there are a few that are missing), nicknames, and other properties.
Thanks in advance for all the help you've already provided — let me know if I should post this in the chat rather than directly to you.--Sphilbrick (talk) 14:43, 25 May 2018 (UTC)
- If I'm reading correctly, this is outside your normal editing times, so I posted at Chat.--Sphilbrick (talk) 17:29, 25 May 2018 (UTC)
- @Sphilbrick: The big first question is, whether there are some values which are found only on your records, such that we can find your set of records to interrogate further; or whether we have to work from the list of Q values. Right now, I'm working from the 339 Q values - the 11 or so that were astray are still astray ... you can add them. Or you can identify that a record with statements X = value Y and statement P = value Q will always be one of your teams, and we'll do a more conventional select.
- With that preamble, here's a report showing a handful of values for each of your teams.
- Try it!
SELECT ?item ?itemLabel ?nickname ?head_coachLabel ?leagueLabel ?home_venueLabel WHERE { VALUES ?item {wd:Q4705232 wd:Q5461417 wd:Q5547760 wd:Q6365108 wd:Q6815890 wd:Q6868282 wd:Q7010204 wd:Q7056976 wd:Q7566589 wd:Q16201949 wd:Q16164975 wd:Q16202097 wd:Q16154463 wd:Q16147656 wd:Q16822493 wd:Q16823123 wd:Q17002222 wd:Q16972809 wd:Q17007074 wd:Q16969626 wd:Q19576850 wd:Q21531595 wd:Q21550167 wd:Q22096806 wd:Q25000663 wd:Q28444659 wd:Q28444662 wd:Q28868362 wd:Q29468792 wd:Q29468768 wd:Q29470713 wd:Q29469017 wd:Q29641529 wd:Q29791438 wd:Q29791447 wd:Q30325928 wd:Q30325823 wd:Q30326010 wd:Q30325964 wd:Q30325923 wd:Q30325998 wd:Q30325830 wd:Q30325941 wd:Q30325887 wd:Q30325898 wd:Q30325871 wd:Q30326014 wd:Q30325815 wd:Q30325986 wd:Q30325824 wd:Q30325889 wd:Q30325915 wd:Q30325875 wd:Q30325893 wd:Q30325831 wd:Q30325804 wd:Q30325973 wd:Q30325983 wd:Q30325988 wd:Q30325921 wd:Q30593141 wd:Q5547572 wd:Q6694561 wd:Q6837807 wd:Q6861792 wd:Q7598727 wd:Q7700100 wd:Q7707441 wd:Q7707839 wd:Q16154307 wd:Q16154256 wd:Q16154314 wd:Q16971255 wd:Q17507741 wd:Q19578136 wd:Q19864208 wd:Q20657621 wd:Q21546434 wd:Q28206758 wd:Q28444629 wd:Q29092785 wd:Q29094771 wd:Q29092793 wd:Q29468946 wd:Q29468780 wd:Q29641538 wd:Q30325908 wd:Q30325897 wd:Q30325822 wd:Q30325965 wd:Q30325917 wd:Q30325975 wd:Q30325882 wd:Q30325877 wd:Q30325968 wd:Q30325926 wd:Q30325914 wd:Q30325910 wd:Q30325873 wd:Q30325939 wd:Q19576965 wd:Q19577169 wd:Q19577277 wd:Q19578059 wd:Q22095719 wd:Q22096531 wd:Q23303100 wd:Q25005059 wd:Q29093013 wd:Q29092990 wd:Q29096404 wd:Q29468958 wd:Q29469127 wd:Q29470718 wd:Q29470716 wd:Q29791434 wd:Q30325932 wd:Q30325946 wd:Q30325978 wd:Q30325918 wd:Q30325909 wd:Q30325884 wd:Q30325907 wd:Q30325985 wd:Q30325806 wd:Q30326001 wd:Q30325913 wd:Q30326003 wd:Q30325996 wd:Q30325874 wd:Q30325929 wd:Q30325829 wd:Q30325872 wd:Q30325805 wd:Q30325809 wd:Q30632927 wd:Q30593394 wd:Q16154177 wd:Q52623210 wd:Q29092977 wd:Q29075948 wd:Q29468773 wd:Q29468769 wd:Q29469021 wd:Q29468791 wd:Q29468782 wd:Q29572582 wd:Q29791436 wd:Q29791431 wd:Q29791432 wd:Q30325896 wd:Q30325888 wd:Q30325999 wd:Q30325991 wd:Q30325883 wd:Q30325927 wd:Q30325930 wd:Q30325995 wd:Q30325919 wd:Q30325922 wd:Q30325879 wd:Q30325885 wd:Q30325989 wd:Q30325992 wd:Q30325905 wd:Q30325960 wd:Q30325808 wd:Q30325811 wd:Q30588386 wd:Q30591624 wd:Q30588521 wd:Q5161554 wd:Q5684359 wd:Q6064630 wd:Q6480880 wd:Q7058420 wd:Q7587318 wd:Q7895967 wd:Q16147605 wd:Q16201295 wd:Q16154116 wd:Q16154474 wd:Q16823182 wd:Q16961952 wd:Q16958990 wd:Q16982691 wd:Q16983723 wd:Q19577165 wd:Q19577174 wd:Q19577972 wd:Q20708371 wd:Q22096783 wd:Q28444648 wd:Q29095277 wd:Q29468771 wd:Q29468775 wd:Q29468778 wd:Q29470819 wd:Q29468781 wd:Q29470721 wd:Q29791430 wd:Q29791433 wd:Q29791435 wd:Q29791444 wd:Q30326011 wd:Q30325894 wd:Q30325816 wd:Q30325916 wd:Q30325827 wd:Q30325958 wd:Q30326008 wd:Q30325895 wd:Q30325943 wd:Q30325997 wd:Q30325812 wd:Q30325937 wd:Q30325947 wd:Q30325961 wd:Q30325906 wd:Q30325890 wd:Q30325972 wd:Q30325980 wd:Q30325931 wd:Q30325940 wd:Q30325900 wd:Q4951157 wd:Q5547840 wd:Q6984699 wd:Q7082333 wd:Q7569490 wd:Q7864012 wd:Q16151501 wd:Q16153415 wd:Q16201351 wd:Q16154193 wd:Q16205772 wd:Q16247862 wd:Q16969601 wd:Q16980215 wd:Q30325899 wd:Q30325902 wd:Q30325814 wd:Q30593139 wd:Q30593140 wd:Q30588227 wd:Q30592518 wd:Q4836897 wd:Q4947831 wd:Q5002584 wd:Q5020513 wd:Q5148748 wd:Q5330300 wd:Q5367124 wd:Q6365004 wd:Q6392430 wd:Q6460014 wd:Q7054636 wd:Q7080913 wd:Q7260974 wd:Q7566995 wd:Q7708113 wd:Q7863949 wd:Q7914438 wd:Q16154049 wd:Q16164964 wd:Q16970007 wd:Q16970019 wd:Q19577159 wd:Q19577406 wd:Q19577742 wd:Q19863871 wd:Q21565045 wd:Q22096156 wd:Q28449390 wd:Q28444660 wd:Q28805615 wd:Q28805614 wd:Q29092781 wd:Q29093805 wd:Q29092789 wd:Q29468783 wd:Q29470715 wd:Q29572324 wd:Q29641524 wd:Q29791446 wd:Q29791441 wd:Q30325977 wd:Q30325901 wd:Q30326007 wd:Q30325911 wd:Q30325810 wd:Q30325825 wd:Q30325821 wd:Q30325944 wd:Q30325876 wd:Q30325903 wd:Q30325924 wd:Q30325807 wd:Q30325880 wd:Q30325826 wd:Q30325828 wd:Q30325820 wd:Q30325813 wd:Q30325987 wd:Q30325962 wd:Q30325942 wd:Q30325886 wd:Q30591635 wd:Q30632926 wd:Q5131581 wd:Q5305591 wd:Q5547006 wd:Q5916456 wd:Q5999493 wd:Q6465106 wd:Q6781515 wd:Q6879755 wd:Q7163258 wd:Q7199343 wd:Q8027124 wd:Q16154459 wd:Q16954373 wd:Q16969737 wd:Q16971251 wd:Q18749589 wd:Q19867545 wd:Q20710750 wd:Q22097431 wd:Q22095802 wd:Q22095699 wd:Q22094777 wd:Q22073508 wd:Q23013781 wd:Q23302579 wd:Q24312890 wd:Q24765379 wd:Q28444649 wd:Q28444632 wd:Q28543867 } optional {?item wdt:P1449 ?nickname .} optional {?item wdt:P286 ?head_coach .} optional {?item wdt:P118 ?league .} optional {?item wdt:P115 ?home_venue .} SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
- It's fairly straightforward to adapt. There's a select statement, which I'll come back to - defines the columns in the report. There's a
Values ?item {}
statement, stuffed with the Qids of items you're interested in. This is where to add the missing 11.
- Statements/claims we want to check for are found in lines like
optional {?item wdt:P286 ?head_coach .}
- this example finds the Qid in the head coach (P286) statement, and sticks it into a variable called ?head_coach. But notice the select at the topSELECT ?item ?itemLabel ?nickname ?head_coachLabel ?leagueLabel ?home_venueLabel
. To get the actual name of the coach, I've addedLabel
to the end of the variable name, so,?head_coachLabel
. By contrast, nickname is a string rather than a Qid, and so we can just findoptional {?item wdt:P1449 ?nickname .}
and not worry about the Label bit. (Although in fact you'll see the report actually asks foroptional {?item wdt:P1449 ?nickname . FILTER(LANG(?nickname) = "en").}
- the filter bit is making sure we get the EN.language nickname, rather than a nickname in another language. Probably over the top for this report, bit still).
- Most of the statements have an
optional {}
wrapper, since we don't know if the item has the value. Without the optional, we would restrict ourselves to returning items that do have the value.
- What else can I tell you?
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
is a thing which gets Labels for values.
- More usefully. If you now want to find what's going on with another value, such as for official website (P856), then you would add a row in the report saying
optional {?item wdt:P856 ?website .}
and the?website
variable in the select statement, soSELECT ?item ?itemLabel ?nickname ?head_coachLabel ?leagueLabel ?home_venueLabel ?website
... it's not a QID and so it does not need Label appending to it. (It's not clickable in the results; we'd need to add another line to make it so -bind(IRI(?website) as ?clickable)
and use ?clickable in the select rather than website ... probably best done as a job lot, so:
- Try it!
SELECT ?item ?itemLabel ?nickname ?head_coachLabel ?leagueLabel ?home_venueLabel ?clickable WHERE { VALUES ?item {wd:Q4705232 wd:Q5461417 wd:Q5547760 wd:Q6365108 wd:Q6815890 wd:Q6868282 wd:Q7010204 wd:Q7056976 wd:Q7566589 wd:Q16201949 wd:Q16164975 wd:Q16202097 wd:Q16154463 wd:Q16147656 wd:Q16822493 wd:Q16823123 wd:Q17002222 wd:Q16972809 wd:Q17007074 wd:Q16969626 wd:Q19576850 wd:Q21531595 wd:Q21550167 wd:Q22096806 wd:Q25000663 wd:Q28444659 wd:Q28444662 wd:Q28868362 wd:Q29468792 wd:Q29468768 wd:Q29470713 wd:Q29469017 wd:Q29641529 wd:Q29791438 wd:Q29791447 wd:Q30325928 wd:Q30325823 wd:Q30326010 wd:Q30325964 wd:Q30325923 wd:Q30325998 wd:Q30325830 wd:Q30325941 wd:Q30325887 wd:Q30325898 wd:Q30325871 wd:Q30326014 wd:Q30325815 wd:Q30325986 wd:Q30325824 wd:Q30325889 wd:Q30325915 wd:Q30325875 wd:Q30325893 wd:Q30325831 wd:Q30325804 wd:Q30325973 wd:Q30325983 wd:Q30325988 wd:Q30325921 wd:Q30593141 wd:Q5547572 wd:Q6694561 wd:Q6837807 wd:Q6861792 wd:Q7598727 wd:Q7700100 wd:Q7707441 wd:Q7707839 wd:Q16154307 wd:Q16154256 wd:Q16154314 wd:Q16971255 wd:Q17507741 wd:Q19578136 wd:Q19864208 wd:Q20657621 wd:Q21546434 wd:Q28206758 wd:Q28444629 wd:Q29092785 wd:Q29094771 wd:Q29092793 wd:Q29468946 wd:Q29468780 wd:Q29641538 wd:Q30325908 wd:Q30325897 wd:Q30325822 wd:Q30325965 wd:Q30325917 wd:Q30325975 wd:Q30325882 wd:Q30325877 wd:Q30325968 wd:Q30325926 wd:Q30325914 wd:Q30325910 wd:Q30325873 wd:Q30325939 wd:Q19576965 wd:Q19577169 wd:Q19577277 wd:Q19578059 wd:Q22095719 wd:Q22096531 wd:Q23303100 wd:Q25005059 wd:Q29093013 wd:Q29092990 wd:Q29096404 wd:Q29468958 wd:Q29469127 wd:Q29470718 wd:Q29470716 wd:Q29791434 wd:Q30325932 wd:Q30325946 wd:Q30325978 wd:Q30325918 wd:Q30325909 wd:Q30325884 wd:Q30325907 wd:Q30325985 wd:Q30325806 wd:Q30326001 wd:Q30325913 wd:Q30326003 wd:Q30325996 wd:Q30325874 wd:Q30325929 wd:Q30325829 wd:Q30325872 wd:Q30325805 wd:Q30325809 wd:Q30632927 wd:Q30593394 wd:Q16154177 wd:Q52623210 wd:Q29092977 wd:Q29075948 wd:Q29468773 wd:Q29468769 wd:Q29469021 wd:Q29468791 wd:Q29468782 wd:Q29572582 wd:Q29791436 wd:Q29791431 wd:Q29791432 wd:Q30325896 wd:Q30325888 wd:Q30325999 wd:Q30325991 wd:Q30325883 wd:Q30325927 wd:Q30325930 wd:Q30325995 wd:Q30325919 wd:Q30325922 wd:Q30325879 wd:Q30325885 wd:Q30325989 wd:Q30325992 wd:Q30325905 wd:Q30325960 wd:Q30325808 wd:Q30325811 wd:Q30588386 wd:Q30591624 wd:Q30588521 wd:Q5161554 wd:Q5684359 wd:Q6064630 wd:Q6480880 wd:Q7058420 wd:Q7587318 wd:Q7895967 wd:Q16147605 wd:Q16201295 wd:Q16154116 wd:Q16154474 wd:Q16823182 wd:Q16961952 wd:Q16958990 wd:Q16982691 wd:Q16983723 wd:Q19577165 wd:Q19577174 wd:Q19577972 wd:Q20708371 wd:Q22096783 wd:Q28444648 wd:Q29095277 wd:Q29468771 wd:Q29468775 wd:Q29468778 wd:Q29470819 wd:Q29468781 wd:Q29470721 wd:Q29791430 wd:Q29791433 wd:Q29791435 wd:Q29791444 wd:Q30326011 wd:Q30325894 wd:Q30325816 wd:Q30325916 wd:Q30325827 wd:Q30325958 wd:Q30326008 wd:Q30325895 wd:Q30325943 wd:Q30325997 wd:Q30325812 wd:Q30325937 wd:Q30325947 wd:Q30325961 wd:Q30325906 wd:Q30325890 wd:Q30325972 wd:Q30325980 wd:Q30325931 wd:Q30325940 wd:Q30325900 wd:Q4951157 wd:Q5547840 wd:Q6984699 wd:Q7082333 wd:Q7569490 wd:Q7864012 wd:Q16151501 wd:Q16153415 wd:Q16201351 wd:Q16154193 wd:Q16205772 wd:Q16247862 wd:Q16969601 wd:Q16980215 wd:Q30325899 wd:Q30325902 wd:Q30325814 wd:Q30593139 wd:Q30593140 wd:Q30588227 wd:Q30592518 wd:Q4836897 wd:Q4947831 wd:Q5002584 wd:Q5020513 wd:Q5148748 wd:Q5330300 wd:Q5367124 wd:Q6365004 wd:Q6392430 wd:Q6460014 wd:Q7054636 wd:Q7080913 wd:Q7260974 wd:Q7566995 wd:Q7708113 wd:Q7863949 wd:Q7914438 wd:Q16154049 wd:Q16164964 wd:Q16970007 wd:Q16970019 wd:Q19577159 wd:Q19577406 wd:Q19577742 wd:Q19863871 wd:Q21565045 wd:Q22096156 wd:Q28449390 wd:Q28444660 wd:Q28805615 wd:Q28805614 wd:Q29092781 wd:Q29093805 wd:Q29092789 wd:Q29468783 wd:Q29470715 wd:Q29572324 wd:Q29641524 wd:Q29791446 wd:Q29791441 wd:Q30325977 wd:Q30325901 wd:Q30326007 wd:Q30325911 wd:Q30325810 wd:Q30325825 wd:Q30325821 wd:Q30325944 wd:Q30325876 wd:Q30325903 wd:Q30325924 wd:Q30325807 wd:Q30325880 wd:Q30325826 wd:Q30325828 wd:Q30325820 wd:Q30325813 wd:Q30325987 wd:Q30325962 wd:Q30325942 wd:Q30325886 wd:Q30591635 wd:Q30632926 wd:Q5131581 wd:Q5305591 wd:Q5547006 wd:Q5916456 wd:Q5999493 wd:Q6465106 wd:Q6781515 wd:Q6879755 wd:Q7163258 wd:Q7199343 wd:Q8027124 wd:Q16154459 wd:Q16954373 wd:Q16969737 wd:Q16971251 wd:Q18749589 wd:Q19867545 wd:Q20710750 wd:Q22097431 wd:Q22095802 wd:Q22095699 wd:Q22094777 wd:Q22073508 wd:Q23013781 wd:Q23302579 wd:Q24312890 wd:Q24765379 wd:Q28444649 wd:Q28444632 wd:Q28543867 } optional {?item wdt:P1449 ?nickname . FILTER(LANG(?nickname) = "en")} optional {?item wdt:P286 ?head_coach .} optional {?item wdt:P118 ?league .} optional {?item wdt:P115 ?home_venue .} optional {?item wdt:P856 ?website . bind(IRI(?website) as ?clickable)} SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
- There are other tricks we can play. Want to see just those without a head coach? Add a line saying
minus {?item wdt:P286 [] .}
... and much the same for any property you want to minus. Want to insist that a value be present? Add a line in the form?item wdt:P286 ?head_coach .
(or remove the optional {} from a line to get to the same place). Fullstops at the end of lines of code are important. Follow the pattern in the report and you'll be fine. - Happy to convene a SPARQL tutorial here - come back with questions. But 1) add the missing values to the Values list, or, 2) let me know whether there are values we can rely on to distinguish your teams, so we can dispense with the Values statements and 3) I found that the SPARQL reports service sometimes says "server error" when running my report ... ask it to run it again and it comes back with results. Don't know what's happeneing there. Indigestion, probably. --Tagishsimon (talk) 17:54, 25 May 2018 (UTC)
- Looks great so far, let me try to absorb it.--Sphilbrick (talk) 18:41, 25 May 2018 (UTC)
- Sucess! I manged to fill in all the blank descriptions, and correct some I had incorrectly capitalized. Now to try new things. Thanks!--Sphilbrick (talk) 00:26, 26 May 2018 (UTC)
- @Sphilbrick: Good work. Excellent to see the thoroughness of your approach to this set of items. Kudos. By way of a thank-you, here's a basic query which returns 348 teams ... I'm guessing they're your set. If there are any missing, then the missing item will be missing one of the three values. Anyway: might allow you to dispense with the unsightly
Values {}
list ... you can build on this query per the queries above. If there are missing items, wrappingoptional {}
around all three triples, and then adding aminus {?item wdt:P31 wd:Q13393265 .}
will reveal the one missing its Q13393265 (if there is one) ... and the same pattern will reveal the other two Qids ... what I'm trying to say is, do one minus statement at a time :) --Tagishsimon (talk) 00:47, 26 May 2018 (UTC)
- @Sphilbrick: Good work. Excellent to see the thoroughness of your approach to this set of items. Kudos. By way of a thank-you, here's a basic query which returns 348 teams ... I'm guessing they're your set. If there are any missing, then the missing item will be missing one of the three values. Anyway: might allow you to dispense with the unsightly
- --Tagishsimon (talk) 00:47, 26 May 2018 (UTC)Try it!
SELECT distinct ?item ?itemLabel WHERE { ?item wdt:P31 wd:Q54190181 . #instance of: NCAA Division I women's basketball team SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } # get labels }
- - College of Charleston Cougars women's basketball not in a league? --Tagishsimon (talk) 00:52, 26 May 2018 (UTC)Try it!
SELECT distinct ?item ?itemLabel ?leagueLabel WHERE { ?item wdt:P31 wd:Q54190181 . #instance of: NCAA Division I women's basketball team optional {?item wdt:P118 ?league .} #get the league, presuming the item has one SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } # get labels } order by ?leagueLabel ?itemLabel
- Heh, I was recently wondering if there was a cleaner way to identify all the subject entries and I knew that I had added competition class: women's basketball to, well, I thought all of them. However, given that I'm doing error checking it occurred to me that I might've missed some and I didn't want to perpetuate my errors. I do have a clean list of all 351 Q values. I'll search those for competition class and if I get lucky I'll find the three that are missing that entry, add them and then I can use the query you designed. Time to take a break for the evening but I'll try in the morning.--Sphilbrick (talk) 00:55, 26 May 2018 (UTC)
- "College of Charleston Cougars women's basketball not in a league?" Yes they are. Which is exactly why I am doing the error checking. I added a lot of things manually and one can get into a zone which is both good and bad. I obviously miss that one. It's slightly odd because I was building quick statements to add leagues, I save the entries in a spreadsheet I'll have to check to see what I missed. They are the first item in the league in my list sorted by leak so I probably picked up one too few rows. Will fix in the morning.
- @Sphilbrick: Not sure how many team's we're trying to get to. I found 3 that were missing the competition class property, and added it - Cal State Northridge Matadors (Q5018231), Quinnipiac Bobcats (Q7272308), Cal State Fullerton Titans (Q3529523) - and added the league to Charleston.
However we seem to be at 352 results right now. Is that good or bad?- sorted below - we have 351. - I used the query below to find the three (and having fixed them, they're no longer in the report). But. There seem to be four other teams which you might or might not want to take a look at.
- --Tagishsimon (talk) 01:15, 26 May 2018 (UTC)Try it!
SELECT distinct ?item ?itemLabel WHERE { ?item wdt:P31 wd:Q13393265 . #instance of: basketball team ?item wdt:P31 wd:Q2367225 . #instance of: university and college sports club optional {?item wdt:P2094 wd:Q2887217 .} #competition class: women's basketball ?item wdt:P641 wd:Q5372 . #sport: basketball minus {?item wdt:P2094 [] .} #SHOW ONLY WHERE competition class: women's basketball IS MISSING SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } # get labels }
- @Sphilbrick: Not sure how many team's we're trying to get to. I found 3 that were missing the competition class property, and added it - Cal State Northridge Matadors (Q5018231), Quinnipiac Bobcats (Q7272308), Cal State Fullerton Titans (Q3529523) - and added the league to Charleston.
- @Sphilbrick: I've tracked down the 352 / 351 difference to Fordham Rams women's basketball (Q29468783) which appears twice in the report that has the league column, since there are two leagues associated with this team. It appears only once in the report without the league column. So, we have a handle, of a sort, on the 351. I kinda feel we're missing an item such as "NCAA Division I women's basketball team" ... if we had such an item (which would have the subclass of (P279) values of basketball team (Q13393265) and university and college sports club (Q2367225)), then each of the 351 teams could have a P31 of whatever is the Qid of "NCAA Division I women's basketball team" (and would not need the P31s they currently have); and we would then have an absolute handle on the teams. Right now it is possible that a team which is not part of the NCAA Division I women's could be given the three values we're using to distinguish the 351. Hope that makes sense? --Tagishsimon (talk) 01:34, 26 May 2018 (UTC)
Here's an uber report which selects for all of the properties I've found (and note the three that were 'found' this evening use represents (P1268) rather than part of (P361) to set out their link with the university). Right now I've commented (#) out some of the optionals, since if you fetch all values, the results switch from a grid to a list ... albeit you can export the list as CSV and it'll be back in grid format in your spreadsheet. Where an item has more than one value for a property, you will get one row per item/value, as we saw with Fordham Rams women's basketball (Q29468783). So, you can turn things on or off with this report by adding or removing the #.
Late news: I've implemented NCAA Division I women's basketball team (Q54190181). So now we can just search for ?item wdt:P31 wd:Q54190181 .
SELECT distinct ?item ?P361Label ?P571 ?P1449 ?P17Label ?P118Label ?P115Label ?P2094Label ?P641Label ?P856 ?P910Label ?P1268Label
WHERE
{ ?item wdt:P31 wd:Q54190181 . #instance of: NCAA Division I women's basketball team
optional {?item wdt:P361 ?P361 .}
optional {?item wdt:P571 ?P571 .}
optional {?item wdt:P1449 ?P1449 .}
optional {?item wdt:P17 ?P17 .}
optional {?item wdt:P118 ?P118 .}
optional {?item wdt:P115 ?P115 .}
optional {?item wdt:P2094 ?P2094 .}
optional {?item wdt:P641 ?P641 .}
# optional {?item wdt:P856 ?P856 .}
# optional {?item wdt:P910 ?P910 .}
# optional {?item wdt:P1268 ?P1268 .}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } # get labels
}
--Tagishsimon (talk) 01:56, 26 May 2018 (UTC)
- We are on the same page! As I went to bed last evening, I wondered if this should be such a property. Thanks for creating it.
- Regarding colleges Charleston — you may recall I ran a couple things in batch mode and a couple didn't work — my best guess is that this was one of them because I found the quick statement in my spreadsheet. I read it again and it seemed to work okay.--Sphilbrick (talk) 10:55, 26 May 2018 (UTC)
- @Sphilbrick: Good that we're on the same page. I'll leave you to double-check the P279 properties assigned to NCAA Division I women's basketball team (Q54190181) ... one of them is college sports team (Q18558301) which only featured on two of the 351 team items. I've added some more statements to NCAA Division I women's basketball team (Q54190181) and am sitting here thinking that it feels perfectly right to have removed basketball team and university and college sports club from the 351 items, because they are represented in Q54190181 ... but it does not feel right to remove from the 351 the other statements I've added to Q54190181 - sport=basketball, competition class=women's basketball, country=USA. Anyway: it's all yours now. I have to go & paint something white. --Tagishsimon (talk) 11:11, 26 May 2018 (UTC)
This thread is too long section break
editThe meta query is very helpful. I've already used it to identify and correct some errors; some still left to handle.
There is one issue that I want to run by you before making changes. A few queue values had their "instance of" change to the new NCAA Division I women's basketball team (Q54190181), But I think these should not have been changed.
I think it's as simple as reverting but before I do so I wanted to bring them to your attention to make sure that simple reversion was sufficient and so that you could also see if there's something else wrong with these entries that cause them to be picked up by your algorithm. There may be something else that's wrong with them.
Cal State Fullerton Titans These are sports other than women's basketball. http://www.wikidata.org/entity/Q3529523
Cal State Northridge Matadors Similarly, I suspect this is the entry for men's basketball and football http://www.wikidata.org/entity/Q5018231
There are two Quinnipiac Bobcat entries. My guess is the first of the two is the men's team. The history of show that I haven't had any edits to it. The second one I believe is the correct one that I'm interested in. https://www.wikidata.org/wiki/Q7272308
https://www.wikidata.org/wiki/Q3529523
Now I have to go plant some trees.--Sphilbrick (talk) 12:33, 26 May 2018 (UTC)
- @Sphilbrick: Planting trees good. I envy you. Meanwhile:
- Quinnipiac Bobcats (Q7272308) has been reverted to before I touched it. The en.wiki article is about all the teams, not just the women's basketball.
- Quinnipiac Bobcats women's basketball (Q29468780) is good.
- Cal State Fullerton Titans (Q3529523) has been reverted to before I touched it. The en.wiki article is about all the teams, not just the women's basketball.
- Cal State Fullerton Titans women's basketball (Q30325977) is good.
- Cal State Northridge Matadors (Q5018231) has been reverted to before I touched it. The en.wiki article is about all the teams, not just the women's basketball.
- Cal State Northridge Matadors women's basketball (Q30325901) is good.
- and, by a miracle I do not understand, we still have 351 results from
- and I shall once again go and paint things white. (I think there are things wrong with the three reverted items; they don't represent that which is described in their articles; but equally they're filed under 'someone else's problem' ... and I forget how I selected them before my quickstatements frenzy, so we'll let that slide.). Did you see the note on chat - Property NCAA.com team ID (P3692) exists, and possibly these teams have a P3692 value? --Tagishsimon (talk) 13:58, 26 May 2018 (UTC)Try it!
SELECT distinct ?item ?itemLabel WHERE { ?item wdt:P31 wd:Q54190181 . #instance of: NCAA Division I women's basketball team SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } # get labels }
References - both in case the entry is needed, and in cases where the entry is present
editI'm so close I can taste it but I'm still not quite there. (As an aside asked my question about URL references at chat rather than to you personally because I thought it might be of general interest to readers. Now that I sort of see how to do that, I want to add some entries but they are quite working correctly.)
Many basketball teams have a site typically called something like quick facts. This page typically a PDF, supports many of the Wikidata entries.
For example, here is the site for USC:
http://usctrojans.com/documents/2017/6/20/quick_facts.pdf
A page like that can be used to support the statement about:
- NCAA Division I women's basketball team (Sometimes, not always)
- Nickname
- home venue
- Inception (Sometimes, not always)
- league
- Competition class
- sport
- Twitter handle (Sometimes, not always)
My goal is to set up a spreadsheet, Where I can enter that you value for the team, add the nickname, the twitter handle, and generate quick statements to add all of the items.
This isn't working out as well as I had hoped.
For example, I tried the suggestion for Stanford and it seemed to work when I tried to create the exact same thing for USC it didn't seem to work.
I'd swear (but I must be wrong) I'd copy and paste an entry into quick statements and have it fail try again and have it work.
Let me mockup what I think would be the way to do this for USC and maybe you can help me figure out what I'm doing wrong. (I said USC but I'm using the Q value for the sandbox until I figure this out)
Q4115189 P31 Q54190181 S854 "http://usctrojans.com/documents/2017/6/20/quick_facts.pdf"
Q4115189 P1449 "Trojans" S854 "http://usctrojans.com/documents/2017/6/20/quick_facts.pdf"
Q4115189 P115 S854 "http://usctrojans.com/documents/2017/6/20/quick_facts.pdf"
The first line works.
The second one fails.
The third one fails perhaps because I didn't provide an entry for home venue but the home venue is already filled and I simply want to add the reference.--Sphilbrick (talk) 14:43, 27 May 2018 (UTC)
- @Sphilbrick: third one first: you need to add the value and the reference as a job lot. Cannot tack a reference onto a pre-existing value. (Think you probably have to, or are best to, delete the value, and then reinsert it with the ref. I'll look at 2 now. --Tagishsimon (talk) 14:58, 27 May 2018 (UTC)
- @Sphilbrick: Second one is, you need to specify the language of the nickname, in the form
en:"Trojans"
- Q4115189 P1449 en:"Trojans" S854 "http://usctrojans.com/documents/2017/6/20/quick_facts.pdf"
- Let me know if that clears it all up. White paint is calling... --Tagishsimon (talk) 15:09, 27 May 2018 (UTC)
- That's helpful. I sort of wondered about language, but didn't know how to cure it. BYW, I helped plant almost 100 trees yesterday. Good luck with the paint. --Sphilbrick (talk) 15:16, 27 May 2018 (UTC)
- @Sphilbrick: couple of weeks before I get to commune with trees again. Well done. Meanwhile I wondered if the language thing was what was frustrating our attempt to use quickstatements to load categories, investigated, found it was not, but did find the answer. We were trying:
- Q30325980 P910 "Category:UC Irvine Anteaters women's basketball"
- when we should have been trying
- Q30325980 P910 Q25025660
- because P910 stores the Qid of the Category, not the string. Okay. Paint. Gone for a while. --Tagishsimon (talk) 15:36, 27 May 2018 (UTC)
- That's helpful. I sort of wondered about language, but didn't know how to cure it. BYW, I helped plant almost 100 trees yesterday. Good luck with the paint. --Sphilbrick (talk) 15:16, 27 May 2018 (UTC)
- @Sphilbrick: Second one is, you need to specify the language of the nickname, in the form
I'm almost there. I handle home venue by creating a lookup table. (Same for league)
I think the last thing remaining is inception. It seems like 1969 is acceptable input when doing manual entry, but it doesn't like it as a quickstatement
e.g.
Q4115189 P571 1976 S854 "http://usctrojans.com/documents/2017/6/20/quick_facts.pdf"
(Thanks for the answer re cat)--Sphilbrick (talk) 16:15, 27 May 2018 (UTC)
- Good news! I figured it out myself:
- Q4115189 P571 +1976-00-00T00:00:00Z/9 S854 "http://usctrojans.com/documents/2017/6/20/quick_facts.pdf"
"Maybe there's hope for me yet. :) --Sphilbrick (talk) 16:24, 27 May 2018 (UTC)
- @Sphilbrick: That's the one. Nothing like having a task you want done, to force you to learn you some SPARQL & Quickstatements & excel tricks. It's ace when these textual incantations do what we want them to. And, excellent to see a corner of wikidata made very neat & complete. --Tagishsimon (talk) 18:00, 27 May 2018 (UTC)
- @Sphilbrick: There's something going on with your commons categories. UConn Huskies women's basketball (Q5161554) points to
- https://commons.wikimedia.org/wiki/Category:UConn_Huskies_women%27s_basketball
- but the extant category is at
- https://commons.wikimedia.org/wiki/Category:Connecticut_Huskies_women%27s_basketball
- https://commons.wikimedia.org/wiki/Category:NCAA_women%27s_basketball_teams is, presumably, your friend. --Tagishsimon (talk) 18:13, 27 May 2018 (UTC)
- I'm intrigued that you noticed that. I'm not sure how closely you are following my edits, but while I've made a lot of edits to women's basketball teams I don't believe I've made any edits involving categories. Well, a couple exceptions. One a few seconds ago, after seeing your note, and I got it wrong initially. I also tried a few days or maybe weeks ago when I first started working on this but I wasn't happy and I'm still unhappy at the irrational difference between the way entries are made for Wikipedia categories and Commons categories. As a consequence, I resolved not to work on categories. I know I could track down who added the wrong category to Q5161554, but it was someone else. I corrected it after a false start.
- I'm making decent progress (thanks to your help) but have no intention of working on categories (at least not in the near term).--Sphilbrick (talk) 00:40, 29 May 2018 (UTC)
- It's a very small corner, but I just now finished my pass through the 351 articles. Some wikidata entries not populated, but because the source material is deficient. Thanks for your help.--Sphilbrick (talk) 13:19, 6 June 2018 (UTC)
- I'm making decent progress (thanks to your help) but have no intention of working on categories (at least not in the near term).--Sphilbrick (talk) 00:40, 29 May 2018 (UTC)
I finally went to the source
editTopic:Ue2kyvfyb366sgqd — NotARabbit (talk) 00:27, 30 May 2018 (UTC)
- @NotARabbit: Good; I hope Magnus has the time to answer. Some sort of odd timeout, but hard to explain given the alactrity of the WQS report. I was seeing the same thing with the WiR redlist Soviet Union report - I updated Belarus, which worked, but if you look at the edit history of Soviet Union...sad. --Tagishsimon (talk) 00:42, 30 May 2018 (UTC)
- @NotARabbit: So now we know. Plus it's working. Plus, presumably, Magnus has improved his code. Excellent job, NotARabbit & Magnus. --Tagishsimon (talk) 00:12, 1 June 2018 (UTC)
Hi, whi did you change all the heritage designation (Q17504995) to listed in a community heritage register (Q18342392)? There is two level of protection in the municipalities of British Columbia. listed in a community heritage register (Q18342392) simply acknoledge that the building have a heritage value. heritage designation (Q17504995) mean that the property is protected by the municipality. It's explaned here. Can you change it back? --Fralambert (talk) 12:42, 27 June 2018 (UTC)
- @Fralambert, Jmabel: See Wikidata:Project chat#Relation between these two topics. Get back to me when there's a consensus on the way forwards. thx --Tagishsimon (talk) 12:51, 27 June 2018 (UTC)
Labels for films
editHi Tagishsimon, I noticed that you added English titles to films. What are you using for these? Please bear in mind that the original title should use title statement (P1476) and the English label should be the English title of a movie.
--- Jura 05:36, 1 July 2018 (UTC)
- @Jura1: I'm taking labels from non-En languages, that happen to be in English, where the En label is missing. I'm not doing any translations, but assuming that an English title found as a non-En label will do for the En label.
- ... and then go thru the CSV by hand removing non-English labels. --Tagishsimon (talk) 09:28, 1 July 2018 (UTC)Try it!
SELECT ?item ?Les WHERE { ?item wdt:P31/wdt:P279* wd:Q11424. filter not exists {?item rdfs:label ?Len. filter(lang(?Len)="en")} ?item rdfs:label ?Les. filter(lang(?Les)="es") } order by ?Les
- Sounds good, even though the actual English title might be different. Spanish film labels are a bit of a mess.
- I noticed you also did some Danish films (some consisting of a mere given name, which may not really be English).
- I couldn't convince a Danish speaking film editor to set the original language of those films.
--- Jura 09:57, 1 July 2018 (UTC)- I took a view on whether given names were sufficiently familiar to the English ear. I grant, absolutely, the possibility that some of the films might have been released in the UK with a different title, but reckon that cost is outweighed by the value of the majority. I've been through #it #fr #es #de #da & #sv so far, which has yielded ~20k labels. --Tagishsimon (talk) 10:06, 1 July 2018 (UTC)
- I should have thought of that earlier ;) Good work.
--- Jura 12:15, 1 July 2018 (UTC)
- I should have thought of that earlier ;) Good work.
- I took a view on whether given names were sufficiently familiar to the English ear. I grant, absolutely, the possibility that some of the films might have been released in the UK with a different title, but reckon that cost is outweighed by the value of the majority. I've been through #it #fr #es #de #da & #sv so far, which has yielded ~20k labels. --Tagishsimon (talk) 10:06, 1 July 2018 (UTC)
Data for instances of humans
editThanks for your help with data related to Baltisches Biographisches Lexikon digital and also with SPARQL requests related to that and to ISNI.
Maybe you are interested in Wikidata:Property proposal/Deutsche Biographie person ID, it could be a connector to a further source of data, to the de:Deutsche Biographie (DB). In the DB all (?) items in ADB and NDB that have their own article are supposed to get a GND and can be linked by that parameter. But it has to be the GND provided by the Deutsche Biographie, not the one from the authority file. Ideally both are the same, but there could be differences. The DB advises to use their GND ID not the SFZ. The de:Vorlage:Deutsche Biographie has just been switched from SFZ/GND mixed support to GND-only. 2.247.58.206 18:35, 8 July 2018 (UTC)
- Hi Tagishsimon, this IP is a known troll, blocked multiple times on German Wikipedia (de:Vorlage Diskussion:Deutsche Biographie). Cheers --Kolja21 (talk) 18:52, 8 July 2018 (UTC)
Wrong labels
editHi, Tagishsimon. I deduce you're the one who added the English labels to some people in Ancient Rome. I'm afraid those labels are wrong. In Spanish, the names of the Romans are translated (in fact, there are a number of translation rules), but in English (as far as I know) the Latin original is maintained. I've already corrected this mistake I've seen. I'm just telling you so that you'll keep it in mind the next time you make a similar edition. Thanks.
Un saludo. --Romulanus (talk) 09:37, 9 July 2018 (UTC)
- @Romulanus: Thank you; I was not aware of that naming rule. I am right now trying to improve EN label coverage by copying values from other languages into EN (and trying to improve EN descriptions by constructing these based on item properties). It's always a worry that I'll introduce systematic errors through lack of knowledge / competence. I'll take on board your advice on Romans, which will, I hope, cut off one avenue of error. This report shows that we have no people items where the EN and ES labels are the same ... predicated on the item having a country of citizenship (P27) of Ancient Rome (Q1747689). So, hopefully, it shows that I have not made the error elsewhere, or that you've already corrected those I did make. Thank you for correcting those you found, and for letting me know. --Tagishsimon (talk) 16:23, 9 July 2018 (UTC)
- Ok. In that case (for the Romans and as far as I know), you can use French, German (in fact, any Germanic language) when there is no label in English. Obviously, you can also use Latin. But never Spanish, Catalan, Galician, Italian.... unless you know the rules of translation of these languages.
- Un saludo. --Romulanus (talk) 23:57, 9 July 2018 (UTC)
citizenship: qualify a start date?
editJust a question re addition for UKI peoples. Was it considered whether there should be a start/finish date to qualify the item? Something to assist the distinguishing of consecutive citizenries changed, rather than co-joined. — billinghurst sDrewth 04:46, 13 July 2018 (UTC)
- @billinghurst: I'm not sure I understand the distinction you draw between consecutive and co-joined ... but I think you are right that we could and should use end and start dates for those people living during the transition between the Kingdom of England and the Kingdom of GB in 1707; or between the Kingdom of GB and Kingdom of GB+NI in 1927. I'll get around to doing that; but please let me know what I'm missing on consecutive vs co-joined. thanks --Tagishsimon (talk) 07:37, 13 July 2018 (UTC)
- co-joined = dual nationality. I couldn't think of that term whilst typing earlier. One is nationality that changes due to processes not the person, the other is the person having choices/, decisions, etc. I can think that Brits have the former with GB -> UKI -> UK; there would also be Australians going from colonists -> Federation as British subjects -> Oz citizens (later legn.) Not that the latter has been well-decided in WD about that citizenry should b represented. — billinghurst sDrewth 08:54, 13 July 2018 (UTC)
- @billinghurst: Not that the latter has been well-decided in Australia, either - you're probably familiar with w:en:2017–18 Australian parliamentary eligibility crisis :). Thanks, distinction is clear now. And yes, not surprising that question of respresentation of the citizenship status of individuals from the former parts of the British Empire has not been settled (again: IRL imitates WD in w:en:Windrush scandal). I'll keep playing with UKians. Might not get around to Oz et al. --Tagishsimon (talk) 09:09, 13 July 2018 (UTC)
- Illustrative only, conversation was just about qualifying what we know. — billinghurst sDrewth 09:27, 13 July 2018 (UTC)
- @billinghurst: Not that the latter has been well-decided in Australia, either - you're probably familiar with w:en:2017–18 Australian parliamentary eligibility crisis :). Thanks, distinction is clear now. And yes, not surprising that question of respresentation of the citizenship status of individuals from the former parts of the British Empire has not been settled (again: IRL imitates WD in w:en:Windrush scandal). I'll keep playing with UKians. Might not get around to Oz et al. --Tagishsimon (talk) 09:09, 13 July 2018 (UTC)
- co-joined = dual nationality. I couldn't think of that term whilst typing earlier. One is nationality that changes due to processes not the person, the other is the person having choices/, decisions, etc. I can think that Brits have the former with GB -> UKI -> UK; there would also be Australians going from colonists -> Federation as British subjects -> Oz citizens (later legn.) Not that the latter has been well-decided in WD about that citizenry should b represented. — billinghurst sDrewth 08:54, 13 July 2018 (UTC)
Weird dupes
editI noticed your ping. You might want to keep an eye on the recent changes for other accounts or ip's. Multichill (talk) 15:35, 11 August 2018 (UTC)
- Thanks; will do. I'm sure we've not seen the last. --Tagishsimon (talk) 15:48, 11 August 2018 (UTC)
Preffered rank
editHello. Can you change the query to show only the preffered rank for population? Some items have a lot of values with population (P1082) but not a recent census. So for that items, will show nothing.
Cases:
- If one value is in preffered rank -> show that value only
- If all values are in normal rank -> show nothing because no value is in preffered rank (for example, must not show population for Arsos, Larnaca (Q4796610))
- If one values is in normal rank and all the other is deprecated rank -> show nothing because no value is in preffered rank
Xaris333 (talk) 14:36, 14 August 2018 (UTC)
- @Xaris333: We're talking User:Xaris333/Test, yes? I've not done the preferred rank thing ... I had a look at Arsos, Larnaca (Q4796610) ... all of the ranks look the same (and I'm a bit too tired right now to do any reading on how preferred rank actually works). So I took a different approach, which is to look for the most recent population statistic for each item. (And I threw in a population date column, which you may or may not want to keep). Let me know if that works for you. Is live on User:Xaris333/Test as of a moment or two ago.
- I can & will come back to doing it by preferred rank maybe in the next 24 hours. Maybe in 5 minutes time. We'll see. --Tagishsimon (talk) 19:59, 14 August 2018 (UTC)
- @Xaris333: Oh. THat was easier than I thought. This is the Preferred Rank version ... it is as I write this note the current version. This is the 'most recent population' version which I discussed above.
- I am understanding your three cases, above to boil down to "show preferred rank only", or perhaps "show preferred rank only, but only if there is a single preferred rank". Right now I am doing the first of those - showing you the "show preferred rank only" without checking if more than 1 have a preferred rank. So, next, I'll look at that issue: can an item statement have 2 preferred ranks? If so, then yes, we can not show any values, or we can chose one of the preferred values, and/or we can produce a flag so you know which have 2 preferred values. --Tagishsimon (talk) 20:11, 14 August 2018 (UTC)
- I learn that there can be two preferred rank values ... I'll come back later once I've worked out how to deal with that. --Tagishsimon (talk) 20:17, 14 August 2018 (UTC)
- But have not found an effective way of not showing population when this happens, whilst still showing the item. More later. -Tagishsimon (talk) 20:50, 14 August 2018 (UTC)
- I learn that there can be two preferred rank values ... I'll come back later once I've worked out how to deal with that. --Tagishsimon (talk) 20:17, 14 August 2018 (UTC)
@Xaris333: So maybe this is the version you want. To recap, as far as I remember:
- show only preferred rank, and only where there is a single preferred rank
- This is the Preferred Rank version which does not care how many preferred ranks
- This is the 'most recent population' version - does not look at preferred ranks at all.
Have a look at the results, especially for the either of the prefferred rank versions ... I'm not 100% sure, but I really am too tired this evening to do any more checking. --Tagishsimon (talk) 21:00, 14 August 2018 (UTC)
Many thanks for your time!! I didn't realize it was so difficult. The case "This is the Preferred Rank version which does not care how many preferred ranks" is what I wanted. Xaris333 (talk) 01:44, 15 August 2018 (UTC)
- But is not working on wikipedia :( w:el:Επαρχία Λάρνακας#Πληθυσμός, έκταση και υψόμετρο ανά δήμο/κοινότητα. Άρσος must have no value. Xaris333 (talk) 01:49, 15 August 2018 (UTC)
- @Xaris333: You used the second query, not the third. Now changed. Let me know if you spot problems - you know the data better than me, and I don't yet guarantee my work. Eventually we'll get there :). Oh, and note in particuar that the column line in the wikidata list needs to draw its population data from ?population and not from P1082. --Tagishsimon (talk) 01:57, 15 August 2018 (UTC)
- Looks fine now! Many thanks!! Xaris333 (talk) 02:01, 15 August 2018 (UTC)
- @Xaris333: You used the second query, not the third. Now changed. Let me know if you spot problems - you know the data better than me, and I don't yet guarantee my work. Eventually we'll get there :). Oh, and note in particuar that the column line in the wikidata list needs to draw its population data from ?population and not from P1082. --Tagishsimon (talk) 01:57, 15 August 2018 (UTC)
Duplicate movies
editHey there! You've posted in pt.wiki's Project Talk, but was reverted, regarding the duplicate movies "Unknown Caller (filme)" (Q25444931) and "Unknown Caller (2014)" (Q25445221), which were the same film. I've redirected the (2014) one to the (filme) one, so now you can merge the Wikidata items. Best regards! Guilhermebm (talk) 16:21, 27 August 2018 (UTC)
- Many thanks, Guilhermebm, that's much appreciated. Wikidata merge now done. --Tagishsimon (talk) 16:41, 27 August 2018 (UTC)
Film directors
editAny particular reason you're removing uses of director (P57) from lots of movie items? Some of the items I checked seemed like they had nothing wrong with the presence of that property. Mahir256 (talk) 21:05, 1 September 2018 (UTC)
- @Mahir256: Other than the director linked to in the film item having predeceased the film by 25 - 1000 years. --Tagishsimon (talk) 21:08, 1 September 2018 (UTC)
- Oh, I must have missed that. Carry on then, but perhaps adding back P57 with the real director is in order after your removals? Mahir256 (talk) 21:17, 1 September 2018 (UTC)
- @Mahir256: Thanks. Yup, I'll be looking at that next. Right now, some I'm replacing by hand (based on comparison of the director's P106 values - lots of sportspeople are alleged by us to have a second line in film direction, with no supporting en.wikipedia corroboration); some I'm deleting (generally after date-wise comparisons). And whilst trying to avoid errors, inevitably I'll make some; there are instances of films being released decades after the death of a director; instances of cricketers turned film-maker. I suspect there are not yet items for many of those being deleted, but that's an issue for another week. --Tagishsimon (talk) 21:43, 1 September 2018 (UTC)
- Oh, I must have missed that. Carry on then, but perhaps adding back P57 with the real director is in order after your removals? Mahir256 (talk) 21:17, 1 September 2018 (UTC)
P921 tagging
editHi, I'm glad that you are interested in contributing annotations with main subject (P921) but think you should be a bit more circumspect in terms of how you do it. For instance, your batch 4333 on Malaria is being run over a set of articles that has already been tagged (example), while your batch 4334 on Tuberculosis is not distinguishing between tuberculosis (Q12204) and Mycobacterium tuberculosis (Q130971) and again ignoring existing annotations (example). I suggest you stop and revert both batches and critically review similar ones that you may have set up. Feel free to check out the kinds of queries I am using to generate my P921 batches. --Daniel Mietchen (talk) 02:43, 15 September 2018 (UTC)
- @Daniel Mietchen: It's about time I sorted out the above mess. I wonder if you'd be good enough to comment on an initial proposed action dealing with the 4334 Tuberculosis set.
- fwiw, I did consider tuberculosis (Q12204) and Mycobacterium tuberculosis (Q130971) before running my QS batch, and decided that as Mycobacterium tuberculosis causes tuberculosis, it was valid to tag the items with P921=Q12204. I'll accept that that was a poor judgement.
- The below query identifies ~210 articles covering (to my eye) both Q12204 and Q130971 whilst ~900 articles mention only Q130971. My proposal is to remove P921=Q12204 from the "just MT" set but leave P921=Q12204 on the "both" set. Thoughts please.
- Try it!
SELECT ?item ?itemLabel ?regex WHERE { ?item wdt:P921 wd:Q130971. ?item wdt:P921 wd:Q12204. ?item rdfs:label ?itemLabel. filter(lang(?itemLabel)="en"). filter(contains(?itemLabel,"Mycobacterium tuberculosis")) bind(if(regex(?itemLabel, ".*(tuberculosis).*(tuberculosis).*"),"both","just MT") as ?regex) } order by ?regex ?itemLabel
- I'll come back with a proposal on the maleria 4333 set next. thx --Tagishsimon (talk) 23:59, 28 November 2018 (UTC)
- I would tag the results of
- Try it!
SELECT DISTINCT ?item ?title WHERE { hint:Query hint:optimizer "None". { SERVICE wikibase:mwapi { bd:serviceParam wikibase:api "Search"; wikibase:endpoint "www.wikidata.org"; mwapi:srsearch "mycobacterium tuberculosis haswbstatement:P31=Q13442814". ?page_title wikibase:apiOutput mwapi:title. } } BIND(IRI(CONCAT(STR(wd:), ?page_title)) AS ?item) FILTER NOT EXISTS { ?item wdt:P921 wd:Q130971. } ?item wdt:P31 wd:Q13442814; wdt:P1476 ?title. FILTER CONTAINS(LCASE(?title), "mycobacterium"). FILTER CONTAINS(LCASE(?title), "tuberculosis"). }
- with Mycobacterium tuberculosis (Q130971) and those of
- Try it!
SELECT DISTINCT ?item ?title WHERE { hint:Query hint:optimizer "None". { SERVICE wikibase:mwapi { bd:serviceParam wikibase:api "Search"; wikibase:endpoint "www.wikidata.org"; mwapi:srsearch "tuberculosis -mycobacterium haswbstatement:P31=Q13442814". ?page_title wikibase:apiOutput mwapi:title. } } BIND(IRI(CONCAT(STR(wd:), ?page_title)) AS ?item) FILTER NOT EXISTS { ?item wdt:P921 wd:Q12204. } ?item wdt:P31 wd:Q13442814; wdt:P1476 ?title. FILTER CONTAINS(LCASE(?title), "tuberculosis"). }
- with tuberculosis (Q12204) and then use a variant of your query to tag the remaining ones that have both. --Daniel Mietchen (talk) 05:38, 1 December 2018 (UTC)
- I would tag the results of
Wikidata - Description for film entry
editHi, I noticed you don't add the description whether the film is a "South Korean" or "Chinese". Previously, you have removed it twice after my edits. Is this the standard format to use? When I do a search, it helps to have this info.Jjaey (talk) 03:55, 5 October 2018 (UTC)
https://www.wikidata.org/wiki/Q51879925
- @Jjaey: You are right that the ideal form of description for films includes the country of origin, so for Long Day's Journey into Night (Q51879925) that should be "2018 Chinese film directed by Bi Gan". I have added "2018 film directed by Bi Gan", which is suboptimal.
- I have not, so far as I'm aware, amended a desciption of "2018 Chinese film directed by Bi Gan" to "2018 film directed by Bi Gan", nor done likewise on any other film. I run a report looking for films with no EN description, and add descriptions which include the P31, the publication date and the director, where they're available. I don't (currently) add the country, because the report I use (iirc) times out if I try to get the country value as well as director and publication date. I will, sometime, do an exercise to add countries; but right now I'm mainly busy elsewhere.
- If you can point to a diff showing that I've removed desription with a country, please point me to it ... it would be a mistake on my part, and as I say, not something I think I've done, so I'd be interested to see ... the only reason I can see why that would happen is that a country description was added between the point where I run the report I use, and the point where I run a quickstatements batch to add labels.
- And in conclusion, yes, country name should be in the film title. hth. --Tagishsimon (talk) 07:15, 5 October 2018 (UTC)
- I'm not sure about that. I'd avoid doing that based on statements on items as countries tend to be incomplete. --- Jura 07:18, 5 October 2018 (UTC)
- Hi, these are the ones you edited, https://www.wikidata.org/w/index.php?title=Q27951909&type=revision&diff=705901624&oldid=705578244 and https://www.wikidata.org/w/index.php?title=Q19349399&type=revision&diff=707008816&oldid=706863832.
- Actually all my edits are done manually and I cross-check with the article, other language articles and other info if required. I also have some edits with the country removed or changed by some other editors (from South Korean to Korean) that's why I have cut down on time spent changing the description because if someone is going to undo it, then there is no point doing it in the first place.
- I see your edits is done through #quickstatements, so it is unintentional. I just want to clarify so I know I am doing the right things. Thanks.Jjaey (talk) 03:59, 6 October 2018 (UTC)
- @Jjaey: Thanks for the diffs; guilty as charged. At a quick look, those were at the start of my "if no EN description then add machine-generated description" campaign. At that time there were tens of thousands of films with no EN description, and so consequent quickstatement jobs took several days to complete, giving enough time for you to have added your edit after my report and before quickstatements had got around to the films in question. I apologise that your edits were collateral damage arising from my work. The good news is that, now, typically, there are only ever double-digit numbers of films with no EN description and so the report to quickstatement completed process takes a minute or two, and such collisions are that much less likely. I confirm that, by my understanding, you are doing the right thing by way of your film descriptions; and also by raising the question here with me. I'd encourage you to continue striving for the ideal description and pushing back where, for instance, country is being removed or incorrectly amended. thanks --Tagishsimon (talk) 11:40, 6 October 2018 (UTC)
- Hi, it's ok, no harm done. Anyway, good work done. To do it manually will be very time consuming. Thanks.Jjaey (talk) 04:22, 7 October 2018 (UTC)
You might be interested. Charles Matthews (talk) 15:46, 7 October 2018 (UTC)
Wittylama
editGetting qualifier or reference data for properties of items is a bit confusing until it clicks. The key to the whole thing (for me, at least) is the data model diagram. You need to stare at this until it makes sense, no matter how long it takes :)
Getting a property value is easy. You ask the report service for the wdt: value. You can see that on the diagram - start in the item circle, follow the wdt: arrow line, and arrive at the simple value. You can also see from the same diagram that there's nowhere you can go from the simple value; you are at journey's end.
If you want a Property Qualifier, you need to ask for a pq: value. To do that, you need to follow the path from the item circle to the statement circle using the p: path. From the statement circle you can then take a variety of paths, such as the ps: path (which will give you the same value as the wdt: path did) or the pq: path which will give you the simple value for the qualifier.
The statement itself is just a long & unique URI cobbled together by wikidata, the only purpose of which is to allow things like qualifiers to be hung from it.
So in report terms, it looks kinda like this (and here I'm reporting on the set of YYYY Sweet Adelines International chorus competition items, rather than on items of winners such as Q7386689#P2522, but the principle is the same):
SELECT ?item ?itemLabel (year(?when) as ?year) ?winnerLabel ?score
WHERE
{
?item wdt:P31 wd:Q57776091. # the item is an instance of a Sweet Adelines International chorus competition
?item wdt:P585 ?when. # it has a when statement
?item p:P1346 ?statement. # it has a p: value for P1346, which points to a statement - the unique URI
?statement ps:P1346 ?winner. # the statement has a ps: value i.e. the winner's identity
?statement pq:P1351 ?score. # the statement has a pq:P1351 value, which is the score
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} order by desc(?year)
And there's no reason why you should not see the statement - that might help
SELECT ?item ?itemLabel (year(?when) as ?year) ?statement ?winnerLabel ?score
WHERE
{
?item wdt:P31 wd:Q57776091. # the item is an instance of a Sweet Adelines International chorus competition
?item wdt:P585 ?when. # it has a when statement
?item p:P1346 ?statement. # it has a p: value for P1346, which points to a statement - the unique URI
?statement ps:P1346 ?winner. # the statement has a ps: value i.e. the winner's identity
?statement pq:P1351 ?score. # the statement has a pq:P1351 value, which is the score
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} order by desc(?year)
and you can also write the query more efficiently with some clever square brackets, which do away with the need to explicitly reference the statement:
SELECT ?item ?itemLabel (year(?when) as ?year) ?winnerLabel ?score
WHERE
{
?item wdt:P31 wd:Q57776091. # the item is an instance of a Sweet Adelines International chorus competition
?item wdt:P585 ?when. # it has a when statement
?item p:P1346 [ps:P1346 ?winner ; pq:P1351 ?score] .
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} order by desc(?year)
Hope all that helps; ping me here or on twitter for more. (References kinda work the same way, but there's some more complexity there. We could look at that when you've grokked this bit. --Tagishsimon (talk) 01:29, 29 October 2018 (UTC)
- Ah, go on then. Let's do references too. So here we need to hop from the ?statement to ?another_statement via a prov:wasDerivedFrom path. The ?another_statement is another of the machine generated long URIs, cobbled together to provide somewhere from which to hang references. Once we've got the ?another_statement, we can ask for pr: (Property Reference) values, and in your example, you have a Ref_URL and a Retrieved date - P854 and P813.
- Again, follow the logic on the diagram; we go from the item to a statement using p:, and then from the statement to the reference_node circle (which in the code below I've called ?another_statement) using prov:wasDerivedFrom ... and from there to the simple values of the references using pr: - specifically pr:P854 to get the ref_url and pr:P813 to get the retrieved date.
- Try it!
SELECT ?item ?itemLabel (year(?when) as ?year) ?winnerLabel ?score ?ref_url ?retrieved WHERE { ?item wdt:P31 wd:Q57776091. # the item is an instance of a Sweet Adelines International chorus competition ?item wdt:P585 ?when. # it has a when statement ?item p:P1346 ?statement. # it has a p: value for P1346, which points to a statement - the unique URI ?statement ps:P1346 ?winner. # the statement has a ps: value i.e. the winner's identity ?statement pq:P1351 ?score. # the statement has a pq:P1351 value, which is the score ?statement prov:wasDerivedFrom ?another_statement. ?another_statement pr:P854 ?ref_url. ?another_statement pr:P813 ?retrieved. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } order by desc(?year)
- And again we can see the ?another_statement, for what it's worth
- Try it!
SELECT ?item ?itemLabel (year(?when) as ?year) ?winnerLabel ?score ?another_statement ?ref_url ?retrieved WHERE { ?item wdt:P31 wd:Q57776091. # the item is an instance of a Sweet Adelines International chorus competition ?item wdt:P585 ?when. # it has a when statement ?item p:P1346 ?statement. # it has a p: value for P1346, which points to a statement - the unique URI ?statement ps:P1346 ?winner. # the statement has a ps: value i.e. the winner's identity ?statement pq:P1351 ?score. # the statement has a pq:P1351 value, which is the score ?statement prov:wasDerivedFrom ?another_statement. ?another_statement pr:P854 ?ref_url. ?another_statement pr:P813 ?retrieved. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } order by desc(?year)
- and we could scrunch things up bigly with square brackets if we felt like being flash:
- --Tagishsimon (talk) 02:04, 29 October 2018 (UTC)Try it!
SELECT ?item ?itemLabel (year(?when) as ?year) ?winnerLabel ?score ?ref_url ?retrieved WHERE { ?item wdt:P31 wd:Q57776091. # the item is an instance of a Sweet Adelines International chorus competition ?item wdt:P585 ?when. # it has a when statement ?item p:P1346 [ps:P1346 ?winner ; pq:P1351 ?score; prov:wasDerivedFrom [pr:P854 ?ref_url; pr:P813 ?retrieved] ] . SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } order by desc(?year)
Emma K. Wilcox
editI created Emma K. Wilcox (Q58921976). You created Emma K. Wilcox (Q58922313) . Can you either merge them, or delete one of them (I don't care which).. I'm not familiar enough with Wikidata to correct this. Thanks. Maile66 (talk) 01:23, 21 November 2018 (UTC)
- @Maile66: Done - thanks. --Tagishsimon (talk) 01:38, 21 November 2018 (UTC)
Kei Nakazawa
editI've been going through old Wikipedia Women In Red Meetup lists and adding what info I can to the relevant Wikidata entries. I have found two instances of Kei Nakazawa but an edit conflict that I don't understand has prevented me from merging them. The two Q nos are Q11366594 and Q11366349. Your assistance would be appreciated. --Oronsay (talk) 07:11, 30 December 2018 (UTC)
- @Oronsay: They seem to be different people; they won't merge because each has a Japanese wiki link. Google translate gives me:
- The Nakazawa group (Nakazawa Kei, 22 September 1970 - 24 April 2009 ) is a poet . Real name, Keisa Nakazawa.
- Nakazawa Kei (Nakazaru Kei, October 6, 1959 -) is a Japanese novelist , Hosei University professor. Real name, Emiko Honda
- In general, it's links to language wikis on both items which frustrates merges; but where that happens, it's worth digging to check why there are two articles. hth --Tagishsimon (talk) 16:05, 30 December 2018 (UTC)
- Thanks for your help. I'm sorry I bothered you with this. I should've looked more closely before asking for your help. There's always more to learn! Have a Happy New Year! --Oronsay (talk) 23:44, 30 December 2018 (UTC)
- @Oronsay: No probs. I'm glad that you did ask, 'cos happy to help. You have a good new year too. --Tagishsimon (talk) 23:50, 30 December 2018 (UTC)
Run in background mode on QuickStatements
editHi Tagishsimon, how long does the background mode on QS take to kick off? I waited for 3 minutes and nothing seemed to be happening. So I ran it manually. Ganeshk (talk) 16:04, 31 December 2018 (UTC)
- @Ganeshk: Presuming you've pressed the right buttons and presuming the list to be proceesed is not super-long - e.g. not 10s of thousands of rows - then it /should/ be pretty immediate. That, at least, has been my experience. It does seem to have done your batch #6607 --Tagishsimon (talk) 16:09, 31 December 2018 (UTC)
- I stopped the batch 6607 since it did not seem to be starting. It was only 123 items. Ganeshk (talk) 16:10, 31 December 2018 (UTC)
- I will try again and let you know how it goes. Ganeshk (talk) 16:10, 31 December 2018 (UTC)
- @Ganeshk: It had done 121 rows. The mode you're using timeslices between all the batchjobs in the queue, so it starts quickly, and proceeds dependng on the load. Load looks quite light right now - only one other job running. Good luck. --Tagishsimon (talk) 16:12, 31 December 2018 (UTC)
- Let's track 6609. Ganeshk (talk) 16:18, 31 December 2018 (UTC)
- @Ganeshk: On reflection ... 6607 didn't do anything. 6609 looks stalled. I suspect batch mode is temporarily borked. Back to running it from your client, then. --Tagishsimon (talk) 16:29, 31 December 2018 (UTC)
- 6570 seems to be crawling along. I suspect if you left it long enough, it might perk up. But it doesn't look right to me. --Tagishsimon (talk) 16:32, 31 December 2018 (UTC)
- @Ganeshk: On reflection ... 6607 didn't do anything. 6609 looks stalled. I suspect batch mode is temporarily borked. Back to running it from your client, then. --Tagishsimon (talk) 16:29, 31 December 2018 (UTC)
- Right, stopped it now and am running it manually. Ganeshk (talk) 16:38, 31 December 2018 (UTC)
- @Ganeshk: Good plan. --Tagishsimon (talk) 16:39, 31 December 2018 (UTC)
BBLD
editSELECT ?item ?itemLabel ?BBLD ?prop ?ref ?refLabel
WHERE
{
# values ?item {wd:Q323699}
?item p:P2580 ?statement .
?statement ps:P2580 ?BBLD .
optional {?statement prov:wasDerivedFrom ?statement2 .
?statement2 ?prop ?ref
filter(contains(str(?prop),"reference/P"))
filter(!contains(str(?prop),"813"))
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
--Tagishsimon (talk) 21:23, 17 January 2019 (UTC)
- GREAT! would not have been able to write that! Sorted version [9] , because in your version the result, (weird to me), shows some are in the beginning and some in the very end of the results, in between all the items with no references. 77.13.102.139 21:47, 17 January 2019 (UTC)
- I'm being a bit slow tonight. The BBLD ID itself can be used to form a P854 style reference, yes? If so I could run a quickstatements job and add P854s to them all. Let me know. I've amended the query to show the ?BBLD ID. --Tagishsimon (talk) 21:48, 17 January 2019 (UTC)
- I think the refs should all be removed. Back references to the source do not make sense for linkable external IDs, they would be circular, not? 77.13.102.139 21:52, 17 January 2019 (UTC)
- As I said, being slow tonight :). Yes, you're right - the ID provides a link to the source. Do you want me to remove the refs or will you? --Tagishsimon (talk) 21:55, 17 January 2019 (UTC)
- Would be happy you do it! Thank you! 77.13.102.139 22:30, 17 January 2019 (UTC)
- As I said, being slow tonight :). Yes, you're right - the ID provides a link to the source. Do you want me to remove the refs or will you? --Tagishsimon (talk) 21:55, 17 January 2019 (UTC)
- I think the refs should all be removed. Back references to the source do not make sense for linkable external IDs, they would be circular, not? 77.13.102.139 21:52, 17 January 2019 (UTC)
- I'm being a bit slow tonight. The BBLD ID itself can be used to form a P854 style reference, yes? If so I could run a quickstatements job and add P854s to them all. Let me know. I've amended the query to show the ?BBLD ID. --Tagishsimon (talk) 21:48, 17 January 2019 (UTC)
Thank you (and one more question)
editThanks for your help today! I went through all the examples you shared, and I realized I was being too greedy. All of the writers I'm looking at now write in English (they are in a contemporary American corpus), so I thought I could limit the query that way. I managed to get what seemed like a reasonable list when I specified US citizen with writer/author, but when I tried to set P103 (I tried P1412, too) and set it to English (which I thought would be more inclusive), I got many fewer results. This surprised me, and made me think I must be doing something wrong. What is the correct way to use these?
Data Model 3a
editThanks for adding the "Level 3a" example at Special:Diff/844614459. There's some text further down, under "Membership Items" that also explains this, so it might be worth harmonising those a bit more now. It might just be a little too early in the morning, but I can't quite find a good split for what should go up beside your example, and what should stay in this section. Any suggestions? --Oravrattas (talk) 08:12, 28 January 2019 (UTC)
- @Oravrattas: Still early in the morning for me, but I've added a sentence fragment pointing the membership item text at the holding political office example, which might suffice. --Tagishsimon (talk) 10:55, 28 January 2019 (UTC)
- Yep, that works well! --Oravrattas (talk) 19:30, 28 January 2019 (UTC)
Pau Ribes
editPau Ribes is a man, and not a woman. Can you stop changing his gender in Wikidata? Please, inquire about the athlete or look for images if you wish and then, you can see that he is a man. Swaurt (talk) 15:03, 9 February 2019 (UTC)
- @Swaurt: You should probably go and fix https://en.wikipedia.org/wiki/Pau_Ribes --Tagishsimon (talk) 15:36, 9 February 2019 (UTC)
P21=Arie Goral-Sternheim
editI noticed that one of your patches added a statement <item>sex or gender (P21)Arie Goral-Sternheim (Q658107) to several items. The following query finds 110 items with that statement.
SELECT ?item ?itemLabel
WHERE
{
?item wdt:P21 wd:Q658107 .
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
You probably meant to use some other value? --Shinnin (talk) 15:40, 15 February 2019 (UTC)
- @Shinnin:. Oh dear. Yes, the difference between Q658107 and Q6581072. Thanks for spotting that. Quickstatements seems to be 500 - Internal Server Error right now; I'll fix them as soon as it's recovered. --Tagishsimon (talk) 16:20, 15 February 2019 (UTC)
Katrina van Grouw
editI just came across the new Wikipedia article on Katrina. Her Wikidata - https://www.wikidata.org/wiki/Q61798588 - has her occupations in Instance of. I don't know how to transfer the references. Would you please fix this. Many thanks. Oronsay (talk) 06:29, 22 February 2019 (UTC)
- @Oronsay: I think there is a javescript tool that would help, but I don't have it. By hand works. I think you actually did the heavy lifting on this one. I've sorted the P31. thx. --Tagishsimon (talk) 11:25, 22 February 2019 (UTC)
Pay attention to the difference between "line producer" (Q1826375) and "film producer" (Q3282637)
editHello,
You added to Q60560040 the value Q3282637 for Property:P106
See here >>> https://www.wikidata.org/w/index.php?title=Q60560040&oldid=841068423
In fact it's not true. He's not a film producer but an executive producer (often call line producer)
See the difference:
https://www.wikidata.org/wiki/Q3282637 film producer
https://www.wikidata.org/wiki/Q1826375 executive producer (film line producer)
So I removed Q3282637 and added "line producer" in french and english labels.
Best regards
ORCID as Description
editWondering why you're updating descriptions to include ORCID. Is that the only available distinctive info? I'm not sure ORCID is very useful as description, unless there is another with the same name only distinguished by ORCID. Just asking. Trilotat (talk) 23:11, 1 March 2019 (UTC)
- @Trilotat: That's exactly the case. I spend a lot of time adding new items for en wikipedia articles on humans. To do so, it is necessary to search for items having the same name. Pretty much all such searches will pull up one or several ORCID person items, or CBDB person items, since these have been added in tens and hundreds of thousands. Because these have no descriptions, it is necessary to waste time inspecting each of them to find out they are not the footballer/politician/whatever that I'm searching for. Adding descriptions including the ORCID ID provides a means of disambiguating this item from that item, within the search results, without having to waste time calling up the full item. For the majority of ORCID items, ORCID is the only available property; for CBDB, the dynasty & CBDB ID. Clearly this is more useful than having a blank description. Clearly, also it's suboptimal and we live in hope that eventually better descriptions will be added. --Tagishsimon (talk) 23:23, 1 March 2019 (UTC)
- That makes perfect sense. I will add a more specific description as I gain details. Thanks. Trilotat (talk) 23:49, 1 March 2019 (UTC)
Edit warring
editHoi, I mentioned your recent activities on the admin board. Thanks, GerardM (talk) 12:39, 2 March 2019 (UTC)
Translation request
editHello.
Can you create the article en:Climate of Azerbaijan in Nynorsk and Bokmal?
Thank you.
Sondrion (talk) 16:52, 6 March 2019 (UTC)
- @Sondrion: Sadly not. No knowledge of those languages. --Tagishsimon (talk) 17:13, 6 March 2019 (UTC)
- I understand. Thank you for your reply. Sondrion (talk) 17:16, 6 March 2019 (UTC)
Bill Hartigan and Ted Hook
editPlease sort out Bill Hartigan for me. There should be two, but the Wikidata entry, Q16095644, is a combination of:
- William Anthony Neville "Bill" Hartigan (born 9 November 1934) - Bill Hartigan on Wikipedia
- William Anthony (Bill) Hartigan (1908-1989) - the person referenced in the Identifier: Australian Dictionary of Biography ID (ADB ID)
I didn't want to lose the Identifier info. Many thanks, in anticipation. Oronsay (talk) 04:33, 7 March 2019 (UTC)
- The same thing has happened with Ted Hook Q18808805:
- The ADB ID is for Edwin John (Ted) Hook (1762-1826) lawyer and public servant, but it's linked to Wikipedia article, Ted Hook - Edwin John "Ted" Hook CBE (3 April 1910 – 2 April 1990) was a senior Australian public servant.
- More thanks! Oronsay (talk) 05:53, 7 March 2019 (UTC)
- @Oronsay: First one is fixed, I hope - Bill Hartigan (Q16095644) & William Anthony Hartigan (Q61989289). Not seeing the second one. The ADB from Ted Hook (Q18808805) is hook-edwin-john-ted-12653 who is entitled "Hook, Edwin John (Ted) (1910–1990)", which matches the en.wiki article and the wikidata record. The Trove record is for the same person. I'm not finding an "Edwin John (Ted) Hook (1762-1826)" in ADB at all. COme back to me on that one if there's still a problem & I'm missing the wood for the trees. --Tagishsimon (talk) 08:43, 7 March 2019 (UTC)
- Many, many apologies. Another look at all the sources and I see that the list I was looking at had copied the YOB/YOD from the person above and I failed to observe the error. I will be more careful in future. Sorry for bothering you and wasting your time... but thank you for fixing the Hartigans. Oronsay (talk) 21:25, 7 March 2019 (UTC)
- @Oronsay: No probs. Always happy to hear from you :) --Tagishsimon (talk) 21:31, 7 March 2019 (UTC)
Listeria: Sitelinks
editHello Tagishsimon, I've seen you once fixed Wikidata:University of Tübingen/Listeria/UTübingen people. I've tried to add "sitelinks":
- ?item wikibase:sitelinks ?sl.
It didn't work. Can you tell me what went wrong? --Einsteiger-Zwo (talk) 03:09, 20 March 2019 (UTC)
- @Einsteiger-Zwo: The query needed the variable ?sl to be in the select statement. diff All fixed now. --Tagishsimon (talk) 03:23, 20 March 2019 (UTC)
- Awesome. Thanks for your quick reply! --Einsteiger-Zwo (talk) 03:41, 20 March 2019 (UTC)
Advice how to webscrape?
editGreetings. I'm sorry to bother you, but you've been helpful and I don't know where to search for help here. Do you know how to webscrape? I'm hoping to pull data from the lexicon at National Geologic Map Database. I've not found any projects or pages here that might help in that endeavor. I have two simple goals.
- I'd like to pull the lithostratigraphic unit (Q3550897) name and the urls for each unit. I can edit the links to isolate the Geolex ID (P6202) for WikiData.
- I'd like to create articles for each unit and eventually, perhaps using mix-n-match (though I have no clue how), I'd like to start plugging in additional relevant data for each lithostratigraphic unit, e.g. located in the administrative territorial entity (P131), part of (P361), has part(s) (P527), described by source (P1343), a la Moenkopi Formation (Q1671517).
Can you offer any advice or point me to a project that might be engaged in this sort of effort? Thanks. Trilotat (talk) 02:00, 30 March 2019 (UTC)
- @Trilotat: I'm ashamed to say I'm a dunce in the scraping area; nor do I know of any organised support for scraping on wikidata. All that I do know is that Oravrattas is the king of scraping ... he might be the best person to consult. My limited experience is that it helps to know enough ruby/perl/python or whichever chosen language, and then know about libraries such as nokogiri or beautiful soup ... before you can make much headway. So the barrier for idiots like me seems quite high on both of those fronts; unlike the SPARQL situation, where there was a steady flow of queries in the request a query page which I could take to pieces, examine, and start to understand.
- On which score, we have unfinished business in that area. Do you want me to pick up on it, or has the moment passed? --Tagishsimon (talk) 02:41, 30 March 2019 (UTC)
- Kind to offer, but I've "moved on." I will return to the retractions effort, but I'm on geoscience stuff now. Thanks so much. Trilotat (talk) 03:34, 30 March 2019 (UTC)
Streets
editSo many "street in Qid"... :) I understand that you are trying to get English label for the most exact division, but look at 3 fails. May be use city label always? And in cases where it would be ambiguous still, add something (at worst, Qid of district). --Infovarius (talk) 08:44, 2 April 2019 (UTC)
- @Infovarius: Agreed. The QId fails are, well, a bit of a fail. I'll hunt them down and sort them out, and also consider city rather than district. --Tagishsimon (talk) 12:19, 2 April 2019 (UTC)
Maggie M'Gill
editYou merged Maggie M'Gill the wrong way. The song title is Maggie M'Gill, not Maggie McGill. - 2600:1702:31B0:9CE0:199D:E941:12DC:7F33 02:02, 12 April 2019 (UTC)
- Thanks. Easy fixed. --Tagishsimon (talk) 02:31, 12 April 2019 (UTC)
Thank you. - 2600:1702:31B0:9CE0:199D:E941:12DC:7F33 02:48, 12 April 2019 (UTC)
Constraints on mass (P2067)
editGood morning! I do not know if you are the right person, but if you are, can you help me with constrain for mass (P2067). What I am trying to do is to set two constraints for instance of (P31) for human (Q5) only. If it is human (Q5) for mass (P2067) i woul like to have the constraints Reference is needed and that point in time (P585) also be set. I do not know if this is wanted or usefull of course, but if "agreed" i think it will be usefull. BregPmt (talk) 04:53, 10 May 2019 (UTC)
Liz Bouk
editQ64748146
FYI, this person is a man.
el.wikipedia article
editSELECT DISTINCT ?item ?itemLabel ?constituencyLabel ?partyLabel ?start ?electionLabel ?end ?causeLabel {
?item p:P39 ?positionStatement .
?positionStatement ps:P39 wd:Q19801674 .
?positionStatement pq:P2937 wd:Q64918130.
OPTIONAL { ?positionStatement pq:P768 ?constituency . }
OPTIONAL { ?positionStatement pq:P4100|pq:P102 ?party . }
OPTIONAL { ?positionStatement pq:P580 ?start . }
OPTIONAL { ?positionStatement pq:P2715 ?election . }
OPTIONAL { ?positionStatement pq:P582 ?end . }
OPTIONAL { ?positionStatement pq:P1534 ?cause . }
SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' }
}
ORDER BY ?start
Can you change that to also have at the results the el.wikipedia article, if exist? Xaris333 (talk) 13:28, 14 July 2019 (UTC)
- @Xaris333: This, if I understand correctly; site link & URL added if they exist.
- --Tagishsimon (talk) 19:52, 14 July 2019 (UTC)Try it!
SELECT DISTINCT ?item ?itemLabel ?constituencyLabel ?partyLabel ?start ?electionLabel ?end ?causeLabel ?sitelink ?article { ?item p:P39 ?positionStatement . ?positionStatement ps:P39 wd:Q19801674 . ?positionStatement pq:P2937 wd:Q64918130. OPTIONAL { ?positionStatement pq:P768 ?constituency . } OPTIONAL { ?positionStatement pq:P4100|pq:P102 ?party . } OPTIONAL { ?positionStatement pq:P580 ?start . } OPTIONAL { ?positionStatement pq:P2715 ?election . } OPTIONAL { ?positionStatement pq:P582 ?end . } OPTIONAL { ?positionStatement pq:P1534 ?cause . } OPTIONAL { ?sitelink ^schema:name ?article . ?article schema:about ?item ; schema:isPartOf <https://el.wikipedia.org/> . } SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' } } ORDER BY ?start
Thanks. But why the results are not showing in a table with columns like the first one? Xaris333 (talk) 20:03, 14 July 2019 (UTC)
- @Xaris333: Either too many columns, or the column labels are too long. Try shortening variable names, or else download into a spreadsheet and you get a conventional table back. --Tagishsimon (talk) 20:23, 14 July 2019 (UTC)
Thank you for preparing SPARQL query
editIt is immense pleasure to get your support by preparing SPARQL query for my request. --Akbarali (talk) 10:51, 20 July 2019 (UTC)
Language
editHello Tagishsimon, this kind of language might be acceptable somewhere else, but not on Wikidata. Intimidating behaviour or harassment is not acceptable on Wikidata. Consider yourself warned. Multichill (talk) 13:22, 28 July 2019 (UTC)
Redirect issue
editI have just found Q65931564 Miklós Hornok and Q65931212 Miklos Hornok and can't merge them because the latter is linked to what is now a redirect to the former on Wikipedia. Your assistance with this would be appreciated. Oronsay (talk) 04:34, 6 August 2019 (UTC)
Inverted names
editHi Tagishsimon,
It seems you copied Hungarian labels to English without inverting them where applicable (English is given name followed by family name, not family name followed by given name): e.g. [10] similar to the one I reverted the other day. Could you have a look and fix them were applicable? --- Jura 09:19, 23 August 2019 (UTC)
- Did you identify/fix these? --- Jura 04:02, 30 September 2019 (UTC)
Community Insights Survey
editShare your experience in this survey
Hi Tagishsimon,
The Wikimedia Foundation is asking for your feedback in a survey about your experience with Wikidata and Wikimedia. The purpose of this survey is to learn how well the Foundation is supporting your work on wiki and how we can change or improve things in the future. The opinions you share will directly affect the current and future work of the Wikimedia Foundation.
Please take 15 to 25 minutes to give your feedback through this survey. It is available in various languages.
This survey is hosted by a third-party and governed by this privacy statement (in English).
Find more information about this project. Email us if you have any questions, or if you don't want to receive future messages about taking this survey.
Sincerely,
Reminder: Community Insights Survey
editShare your experience in this survey
Hi Tagishsimon,
A couple of weeks ago, we invited you to take the Community Insights Survey. It is the Wikimedia Foundation’s annual survey of our global communities. We want to learn how well we support your work on wiki. We are 10% towards our goal for participation. If you have not already taken the survey, you can help us reach our goal! Your voice matters to us.
Please take 15 to 25 minutes to give your feedback through this survey. It is available in various languages.
This survey is hosted by a third-party and governed by this privacy statement (in English).
Find more information about this project. Email us if you have any questions, or if you don't want to receive future messages about taking this survey.
Sincerely,
Hello, you added Q837766 to a lot of geographic objects, which I think is incorrect, since it's a sub-class of Q167037 and requires a group of people. Regards IllCom (talk) 08:32, 28 September 2019 (UTC)
- I don't get why you are adding that qualifier? Isn't it already on P31 of the item? --- Jura 10:51, 28 September 2019 (UTC)
- Care to explain? --- Jura 04:02, 30 September 2019 (UTC)
- OI! --IllCom (talk) 11:44, 12 October 2019 (UTC)
Dude! --IllCom (talk) 09:13, 29 November 2019 (UTC)
Query time out
editHello ! Could you perhaps help me on why this once-worked-well query times out now ?
#defaultView:Map
SELECT ?item ?country ?coord {
VALUES ?country { wd:Q1050 } . #select a country here, works also with any administrative territory having the 4 east, west, south and north bounds
?country p:P1332 [ ps:P1332 ?north; psv:P1332 ?nValue ];
p:P1333 [ ps:P1333 ?south; psv:P1333 ?sValue ];
p:P1334 [ ps:P1334 ?east; psv:P1334 ?eValue ];
p:P1335 [ ps:P1335 ?west; psv:P1335 ?wValue ].
?nValue wikibase:geoLatitude ?nLat . hint:Prior hint:rangeSafe true .
?sValue wikibase:geoLatitude ?sLat . hint:Prior hint:rangeSafe true .
?eValue wikibase:geoLongitude ?eLon . hint:Prior hint:rangeSafe true .
?wValue wikibase:geoLongitude ?wLon . hint:Prior hint:rangeSafe true .
?item p:P625 [ a wikibase:BestRank; ps:P625 ?coord; psv:P625 ?cValue ] .
?cValue wikibase:geoLatitude ?lat . hint:Prior hint:rangeSafe true .
?cValue wikibase:geoLongitude ?lon . hint:Prior hint:rangeSafe true .
?cValue wikibase:geoGlobe ?globe . hint:Prior hint:rangeSafe true .
BIND(COALESCE(?globe,wd:Q2) as ?Globe)
FILTER (?Globe =wd:Q2) #select only Earth-like coordinates
MINUS { ?item wdt:P17 [] } . #has the item any P17 value ? should be the
MINUS { ?item (wdt:P31/wdt:P279*) wd:Q4830453. } # exclude ENTREPRISES
MINUS { ?item (wdt:P31/wdt:P279*) wd:Q15893266. } # exclude old entities
MINUS { ?item wdt:P576 _:b2. } # remove items with P576 (dissolved, abolished or demolished) as a main property
FILTER( ?sLat < ?lat && ?lat < ?nLat ) . #it's here that filter inside the south and north bounds
FILTER( ?wLon < ?lon && ?lon < ?eLon ) .#it's here that filter inside the east, west bounds
}
Thanks if you have any time to have a look at it! :) Bouzinac (talk) 15:46, 20 November 2019 (UTC)
Hi Tagishsimon,
At some point you created a series of items with the above as P31-value, e.g. Q58410226 for an enwiki page w:Abrell. Usually such pages are linked to items with "family name" as P31.
Not sure what I should write about them. Is this something you plan to continue? --- Jura 11:31, 23 November 2019 (UTC)
- If not, I'd merge them with family name items. --- Jura 20:32, 24 November 2019 (UTC)
- @Moebeus: what's your view on this? --- Jura 12:23, 27 November 2019 (UTC)
- @Jura1: Hi there! I only started seeing these a little while back, but I have to admit I find it makes sense and I have been trying to follow the model ever since. When a en:wiki page has the footer "This page lists people with the surname NNNN" I agree that it makes sense to have the QItem be a wikimedia list article and not a "family name" item. Often times, these also mix several spelling variants of a name as well, so there's that. That said, if there's consensus this is the wrong way to go about it, I'll be happy to stop. We should probably include the given name items in this discussion as well Q66474017? EDIT: the list items need to have the "is a list of" property and be properly named of course, if not it will be confusing. Moebeus (talk) 12:39, 27 November 2019 (UTC)
- Oh, I missed those. I don't see an advantage of linking w:Sabine_(given_name) from Q67755930 instead of Q18182622. Why just en? At which point should it be moved? I don't think we should go into reading and re-reading content of a Wikipedia article. Lists in Wikipedia are generally identified by their names ("list of"). Stubs and articles can contain lists without being lists. Other than articles on itwiki (e.g. it:Sabino_(nome)), Wikipedia articles on names are generally summary pages or stubs. Depending on what people add, this could change.
- BTW, itwiki has another specificity: lists that are titled "list", e.g. it:Persone_di_cognome_Russo. I'd link those to actual list items here. We could use Q58408484 for that. --- Jura 13:05, 27 November 2019 (UTC)
- "Why just en" - I don't really have a good answer, other than to say that there clearly is a difference between the en English article being purely a list, and i.e. the Norwegian one being an in-depth article about the name. Also, there's the inclusion in Category:Lists_of_people_sharing_a_surname if that counts for something. I'll also add that there a quite a few Russian wiki articles that are also clearly defined as "list of names" following the same pattern as the English. Should we maybe move this discussion to the talk page of Q58408484 before Tagishsimon get mad at us? Moebeus (talk) 13:47, 27 November 2019 (UTC)
- The problem we had with ruwiki is that its pages are disambiguation pages .. It will probably make it even harder if we have to explain that there is also a third type of pages on enwiki.
- BTW he created the item .. Still, maybe something for Wikidata talk:WikiProject Names. --- Jura 19:01, 29 November 2019 (UTC)
- @Jura1: Hi there! I only started seeing these a little while back, but I have to admit I find it makes sense and I have been trying to follow the model ever since. When a en:wiki page has the footer "This page lists people with the surname NNNN" I agree that it makes sense to have the QItem be a wikimedia list article and not a "family name" item. Often times, these also mix several spelling variants of a name as well, so there's that. That said, if there's consensus this is the wrong way to go about it, I'll be happy to stop. We should probably include the given name items in this discussion as well Q66474017? EDIT: the list items need to have the "is a list of" property and be properly named of course, if not it will be confusing. Moebeus (talk) 12:39, 27 November 2019 (UTC)
Review this new page
editPlease review this page https://www.wikidata.org/wiki/Q77359124. Thanks (Shubham Ghodke) 17:50, 12 December 2019 (UTC)
Regarding the tone of your replies
editHi, I tried several times to ask you nicely to calm down and keep a friendly and constructive tone in your communication with me. It seems this have unfortunately not had any to me noticeable effect. I there once again ask you to consider your writings before posting. Alternatively please stop posting any replies to my communications from here on going. Thanks in advance.--So9q (talk) 09:33, 17 December 2019 (UTC)
Please be more friendly
editHello,
your answer in the ProjectChat to a question was not friendly. Please be more friendly if you want to tell somebody that you have another point of view to a topic. I think things can be also said in more friendly words. This is better for all involved persons. If the climate of communication in Wikidata is bad then people dont want to be involved in the project. Because it is a community project at first every one is welcome as far as the one is not only here active for vandalism. -- Hogü-456 (talk) 21:44, 17 December 2019 (UTC)
Surnames
editHi, I'd like to thank you for your contributions to Wikidata!
However this edit strikes me as weird. You see, nl is a very peculiar language in terms of transliterating Cyrillic names; its rules differ enormously from what is normal for, say, ru→en transliteration. Russian Гончарук might turn into Gontsjaroek in Dutch but it has to be Goncharuk in English (and if it's a person of Ukrainian sitizenship, then Honcharuk is a proper spelling). Writing a person's name in Wikidata in English has to be truthful because other Latin-script-languages users look up to it and often copy it without change -- as happened multiple times in Q4143287 after your edit.
I am aware that this edit of yours was a year and a half ago and you definitely are more skilled by now. What I'm asking here is please check what you do, alright? Thanks. -- Ата (talk) 20:49, 5 January 2020 (UTC)
Change query
editHello. Can you change with query to find all items that have a reference with reference URL (P854) -> http://www.cystat.gov.cy/mof/cystat/statistics.nsf/All/59681B67FE82FD39C2257AD90053F3FA/$file/POP_CEN_11-POP_PLACE_RESID-EL-171115.xls?OpenElement with also (at the same reference) title (P1476) -> Απογραφή πληθυσμού 2011 (Greek language) and title (P1476) -> Census of population 2011 (English language).
SELECT DISTINCT ?item ?itemLabel {
?item ?prop ?statement.
?statement prov:wasDerivedFrom ?ref.
?ref pr:P854 <http://www.cystat.gov.cy/mof/cystat/statistics.nsf/All/59681B67FE82FD39C2257AD90053F3FA/$file/POP_CEN_11-POP_PLACE_RESID-EL-171115.xls?OpenElement>.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Xaris333 (talk) 21:02, 6 January 2020 (UTC)
Changes to P31 for journals
editHi Tagishsimon,
Please stop changing P31 while the discussion is still ongoing. --- Jura 10:40, 27 February 2020 (UTC)
Wikisource editions
editHi. Back in 2018 in this edit to Ode Upon Liberty (Q19081908) you labelled the edition of a work as a poem. This is problematic as it contravenes Wikidata:WikiProject Books where an edition, typically what we have at enWS, is one item and the conceptual components itself are another, so in this case the poem—which is typically about what the WPs write articles.
I am fixing this up, though thought that I had better flag the issue to you. [Wave by the way, I hope matters are okay in the old Blighty] — billinghurst sDrewth 02:59, 24 March 2020 (UTC)
No personal attacks
editHi! I noticed that you made a comment that didn't seem very civil, so I did you a favour and removed it. Collaboration is a core principle of WMF projects, so please interact in a more polite and respectful manner in future. Cheers, Bovlb (talk) 01:31, 27 March 2020 (UTC)
- Stick your tone policing where the sun doesn't shine, sonny. --Tagishsimon (talk) 01:37, 27 March 2020 (UTC)
You have been blocked for a period of 31h for repeating personal attacks immediately after warning. Once this block has expired, you are welcome to make useful contributions. If you believe this block is unjustified, you may contest it by editing this page and adding the following template with a suitable reason: {{unblock|1=<the reason for your unblock request>}} . If you are logged in, and the option has not been disabled, you may also email the blocking administrator (or any administrator from this list) by using this form. See Wikidata:Guide to appealing blocks for more information.
|
- @Bovlb: Had I called you an arsehole, Bovlb, that would have been a personal attack. Arguing that a campaign against aliases is not useful way to spend time is not a personal attack. You have misused your admin powers; ideally you should resign your adminship. --Tagishsimon (talk) 10:52, 27 March 2020 (UTC)
- If you feel this block was inappropriate, then you are welcome to make an unblock request, and see if you can persuade another admin to unblock you. (They don't need my permission.) If you do so, I would recommend that you focus on demonstrating that you understand why you were blocked, and why it will not reoccur. I based this block on this edit where you reinstated a comment that you had just received a warning for. In any unblock request, you should probably explain why you chose to reinsert the comment unmodified instead of refactoring it to convey your point with more civility. In addition, you should be aware that I did not take this other edit into account when making the block (because I believe admins need to be thick-skinned to do their jobs), but any admin reviewing this block might choose to take it into account. Cheers, Bovlb (talk) 15:30, 27 March 2020 (UTC)
- @Bovlb: Had I called you an arsehole, Bovlb, that would have been a personal attack. Arguing that a campaign against aliases is not useful way to spend time is not a personal attack. You have misused your admin powers; ideally you should resign your adminship. --Tagishsimon (talk) 10:52, 27 March 2020 (UTC)
Hey Tagishsimon, I pinged you at Wikidata:Requests for deletions#Historic Scotland redundant items a couple of days ago, for more input. Can you please comment there? I would like to close the section soon. Thanks, MisterSynergy (talk) 13:05, 4 April 2020 (UTC)
Change image
editHi! Please change Vani Bhojan Wikidata image. Vani Bhojan Zee Cine awards.jpg TO Vani Bhojan Oh My Kadavule Press Meet.jpg please change and please expand Vani Bhojan wikidata. Please I hope you change and expand Vani Bhojan wikidata. Please reply me kindly please reply me. Thanks!! Susenaes (talk) 02:20, 28 June 2020 (UTC)
Welcome back
editGood to see you around --- Jura 04:32, 19 August 2020 (UTC)
Can you please respond? Neveselbert (talk) 20:55, 1 September 2020 (UTC)
Wikidata: (Q12940)
editIl existe un article Wikisource en français sur Jacques Chaban-Delmas. Je n’arrive pas à le relier à wikidata et à Wikipedia en français. Il est relier à une mauvaise page Wikidata. Cordialement CélineChauvin
We sent you an e-mail
editHello Tagishsimon,
Really sorry for the inconvenience. This is a gentle note to request that you check your email. We sent you a message titled "The Community Insights survey is coming!". If you have questions, email surveys@wikimedia.org.
You can see my explanation here.
MediaWiki message delivery (talk) 18:46, 25 September 2020 (UTC)
Thanks for helping with my Wikipedia-related query
editAt Wikidata:Request a query I asked for assistance and you gave a great answer. Thank you so much for saving me so much time. Blue Rasberry (talk) 00:53, 21 October 2020 (UTC)
Report request, unless you have a better idea
editHi. At enWS we are starting to get enough biographical work of non-authors that we are needing to compile person portal pages for them where we list the biographical works that we have. Issue is that I don't have a good means to identify the WD items that have multiple enWS works. [From an enWS sense, this is the equivalent of a listing of the "works about" section of author pages in our Author: ns]
What I was looking to have is a report that can pull:
- Person item
- Count of described by source (P1343) that have statement is subject of (P805) qualifier enWS-linked (that is reverse checked to an item with an enWS link, the enWS item hopefully has a depicts (P180))—I am guessing that I would start with a minimum count of 3 or 4 so I can focus on priority pages
- Where no enWS page (as this will exclude existing portal: and author: ns pages)
Note: I am wondering on whether I need to check/fix the Q-article item depicts (P180) <-> Q-person item described by source (P1343) <=> Qxxxxx / statement is subject of (P805) first.
I am going to look to learn about ListeriaBot to see how/whether that can help me. Though if you have better ideas or valuable thoughts, then really to happy to hear them.
- John Barry (Q1593841)—example of a person item with two biographical articles at enWS, non-author
- Aidan of Lindisfarne (Q132148)—three biographical articles at enWS
I hope that makes sense. Thanks for your thoughts here. — billinghurst sDrewth 00:19, 25 December 2020 (UTC)
Universal Code of Conduct consultation
editHello, I am writing to you to personally invite you to the ongoing consultation about the new Wikimedia movement's Universal Code of Conduct. Your feedback as a skilled user is of great value for us, and we are extremely interested in hearing your say.
You might express your opinion at any given time and in any way you may consider useful (for example, publicly at the consultation page or on my talk page, or privately via email). If you wish or feel more comfortable, we can also set up an online meeting in order to discuss your opinions and ideas.
Please remember that there is no such thing as a “stupid opinion” or “worthless idea”, so be bold and feel free to express yourself. :) Also, if you wish you can help us involving other users you know and that you think might be interested in having their say in this!
Hope to hear from you soon! --Sannita (WMF) (talk) 17:16, 29 January 2021 (UTC)
Edits at Retail trade (Q104713043) and Wholesale trade (Q104710947)
editDear Tagishsimon,
I strongly suppose your edits to the above items were indeed aimed to retail (Q126793) and wholesale (Q220695). Though it looks like this, these items are not duplicates: The latter are the "real-world" items (with lots of page links and external ids), while the former are of type PM20 subject category (Q92707903). Hierarchically interlinked, they are part of the PM20 subject category system (Q92732036). It's purpose is to give access to the folders of w:20th Century Press Archives, a large collection of newspaper clippings, organized in dossiers/folders, and covering the first half of the last century. You can view that whole system on one page here. All subject folders of the archive have a geographic and a subject facet. While the geographic facet was well covered with existing Wikidata items, the subjet facet is not, because most of the categories only make sense as baskets within the specific hierarchy and do not have a corresponding "real world entity". (The examples above are in that respect rather exceptional).
In the examples above, it is unfortunate that the names for the real items and the categories are very similar, particularly in matching workflows. The description ("subject category of the 20th Century Press Archives") should make it clearer, but does not show up in all tools. I sometimes had the same problem with titles of scholarly works. The upper case start of the item's label may give an indication, that something may be special with that item.
The whole activity of creating the subject categories and folders is part of the Wikidata:WikiProject 20th Century Press Archives, which aims at linking every folder of the press archives to Wikidata, in order to provide access to its sources to Wikimedia projects and the general public. Please feel free to ask me anything about the project. Cheers, --Jneubert (talk) 11:21, 11 February 2021 (UTC)
Harvest Templates
editHello! Please tell, how does it work? Check out this screenshot opens? Then nothing happens, maybe I filled in incorrectly. I want to import the population from this category.--Takhirgeran Umar (talk) 10:51, 13 February 2021 (UTC)
Removal of property constraints?
editJust checking why you removed the "requires statement" suggestion constraints from Companies House company ID (P2622)? --SilentSpike (talk) 22:04, 17 February 2021 (UTC)
- I see there's a conversation on the talk page there. Will respond there. --SilentSpike (talk) 15:38, 18 February 2021 (UTC)
[WMF Board of Trustees - Call for feedback: Community Board seats] Meetings with the Wikidata community
editThe Wikimedia Foundation Board of Trustees is organizing a call for feedback about community selection processes between February 1 and March 14. While the Wikimedia Foundation and the movement have grown about five times in the past ten years, the Board’s structure and processes have remained basically the same. As the Board is designed today, we have a problem of capacity, performance, and lack of representation of the movement’s diversity. Our current processes to select individual volunteer and affiliate seats have some limitations. Direct elections tend to favor candidates from the leading language communities, regardless of how relevant their skills and experience might be in serving as a Board member, or contributing to the ability of the Board to perform its specific responsibilities. It is also a fact that the current processes have favored volunteers from North America and Western Europe. In the upcoming months, we need to renew three community seats and appoint three more community members in the new seats. This call for feedback is to see what processes can we all collaboratively design to promote and choose candidates that represent our movement and are prepared with the experience, skills, and insight to perform as trustees?
In this regard, two rounds of feedback meetings are being hosted to collect feedback from the Wikidata community. Two rounds are being hosted with the same agenda, to accomodate people from various time zones across the globe. We will be discussing ideas proposed by the Board and the community to address the above mentioned problems. Please sign-up according to whatever is most comfortable to you. You are welcome to participate in both as well!
- Round 1 - Feb 24, 4:00 pm UTC
- Round 2 - Mar 3, 4:00 am UTC
- Sign-up and meeting details: Wikimedia Foundation Board of Trustees/Call for feedback: Community Board seats/Conversations/Wikidata
Also, please share this with other volunteers who might be interested in this. Let me know if you have any questions. KCVelaga (WMF), 14:33, 21 February 2021 (UTC)
Your question on Chat
editHi, the item is Wikidata Q3631228. Thanks, Krok6kola (talk) 23:09, 19 April 2021 (UTC)
Civiliy
editHi Tagishsimon. I was reading a recent post you made to Wikidata:Project chat, where you said, "So long as we're clear that your ridiculous proposed solution is based on your misunderstanding of the problem and your lack of awareness of the extant solution, then we're good." Notwithstanding the merits of the proposal you're responding to, do you think that it is helpful for you to phrase your response in that way? I'm sure the OP could learn a lot from your knowledge and experience, but is this putting a roadblock in their path instead? Please think about it. Cheers, Bovlb (talk) 22:45, 24 April 2021 (UTC)
- I agree with Bovlb (talk • contribs • logs) here and find this behavior concerning. To me it also looks like a pattern. Please, change to be more welcoming to new users and generally be more friendly with people with whom you diagree. Bovlb (talk • contribs • logs) already shortly blocked you last year. ChristianKl ❪✉❫ 18:30, 26 April 2021 (UTC)
Call for participation in the interview study with Wikidata editors
editDear Tagishsimon,
I hope you are doing good,
I am Kholoud, a researcher at the King’s College London, and I work on a project as part of my PhD research that develops a personalized recommendation system to suggest Wikidata items for the editors based on their interests and preferences. I am collaborating on this project with Elena Simperl and Miaojing Shi.
I would love to talk with you to know about your current ways to choose the items you work on in Wikidata and understand the factors that might influence such a decision. Your cooperation will give us valuable insights into building a recommender system that can help improve your editing experience.
Participation is completely voluntary. You have the option to withdraw at any time. Your data will be processed under the terms of UK data protection law (including the UK General Data Protection Regulation (UK GDPR) and the Data Protection Act 2018). The information and data that you provide will remain confidential; it will only be stored on the password-protected computer of the researchers. We will use the results anonymized (?) to provide insights into the practices of the editors in item selection processes for editing and publish the results of the study to a research venue. If you decide to take part, we will ask you to sign a consent form, and you will be given a copy of this consent form to keep.
If you’re interested in participating and have 15-20 minutes to chat (I promise to keep the time!), please either contact me on kholoudsaa@gmail.com or use this form https://docs.google.com/forms/d/e/1FAIpQLSdmmFHaiB20nK14wrQJgfrA18PtmdagyeRib3xGtvzkdn3Lgw/viewform?usp=sf_link with your choice of the times that work for you. I’ll follow up with you to figure out what method is the best way for us to connect.
Please contact me using the email mentioned above if you have any questions or require more information about this project.
Thank you for considering taking part in this research.
Regards
Kholoud
What
editWhat is your name? What are you doing here?
https://www.wikidata.org/w/index.php?title=Wikidata:Project_chat&diff=1426357994&oldid=1426338885
Geneve tramway
editHello, I hope you are doing fine. Following your wonderful code, I'm guessing I've hit a snag, and perhaps you did too, with the Geneva tram route 15 (Q3238583). If you look closely at this map, from Gare Cornavin (Q107032253) southwards, you would spot oneways stations in the brown line 15. Has there been solutions to modelize that ? Other question : is there possibility to densify red dot when multiples lines are calling at the station (one line, small dot, multiples lines/transfer station, big dot) ?
The Geneve code :
#defaultView:Map{"hide":["?coordinates", "?line", "?rgb"]}
SELECT DISTINCT ?coordinates ?line ?item ?itemLabel ?connectLabel ?image ?opening ?rgb
WITH {
SELECT ?item (SAMPLE(?coordinates) AS ?coordinates) (sample(?lat1) as ?lat1) (sample(?lon1) as ?lon1)
WHERE {
?item wdt:P31 wd:Q2175765 ;
wdt:P361 wd:Q676266 ;
wdt:P81 wd:Q3238583 ;
wdt:P625 ?coordinates ;
p:P625 / psv:P625 / wikibase:geoLatitude ?lat1 ;
p:P625 / psv:P625 / wikibase:geoLongitude ?lon1 .
MINUS { ?item(wdt:P576|wdt:P582|wdt:P3999) ?dispar. }
MINUS { ?item wdt:P5817 ?interdit VALUES ?interdit {wd:Q811683 wd:Q63065035 wd:Q12377751 wd:Q30108381 wd:Q11639308} }
} GROUP BY ?item
} AS %stations
WITH {
SELECT ?nextstation (sample(?lat2) as ?lat2) (sample(?lon2) as ?lon2) WHERE {
?nextstation wdt:P31 wd:Q2175765 ;wdt:P81 wd:Q3238583;
wdt:P361 wd:Q676266 ;
p:P625 / psv:P625 / wikibase:geoLatitude ?lat2 ;
p:P625 / psv:P625 / wikibase:geoLongitude ?lon2 .
} GROUP BY ?nextstation
} AS %nextstations
WITH {
SELECT ?line ?connect ?rgb WHERE {
INCLUDE %stations .
INCLUDE %nextstations .
?item p:P197 ?nextstationstatement .
?nextstationstatement ps:P197 ?nextstation ;
pq:P81 ?connect .
?connect wdt:P465 ?rgb.
FILTER(STR(?item) < STR(?nextstation)) .
BIND(CONCAT('LINESTRING (', STR(?lon1), ' ', STR(?lat1), ',', STR(?lon2), ' ', STR(?lat2), ')') AS ?str) .
BIND(STRDT(?str, geo:wktLiteral) AS ?line)
}
} AS %lines
WHERE {
{ INCLUDE %stations } UNION { INCLUDE %lines }.
SERVICE wikibase:label { bd:serviceParam wikibase:language "fr,de". }
}
I hope it is ok for you to discuss here. Cheers, --Bouzinac 💬●✒️●💛 19:41, 30 May 2021 (UTC)
Thank you
editThank you for your answer to Wikidata:Project_chat/Archive/2021/05#Annoying_merge_limit and sorry for not responding sooner! I have made a new post at Wikidata:Project_chat#Re:_Annoying_merge_limit. Utfor (talk) 13:06, 26 June 2021 (UTC)
A massive thank you!!!
editFor helping me with "QUERY TO DOWNLOAD ALL MEMBERS OF PARLIAMENTS". --79.145.4.0 17:31, 11 July 2021 (UTC)
A new question on Spanish Congress parliamentary members
editDear Tagishsimon,
I have done the WQS manual and now understand everything you did with my previous question. There is a problem, however. I need not only the parliamentary group but also the political party. I have managed to make this work:
SELECT ?memberLabel ?partyLabel ?start WHERE {
?member wdt:P39 wd:Q18171345 . ?member p:P102 ?statement. ?statement ps:P102 ?party. ?statement pq:P580 ?start. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
But I do not know how I should combine it with the previous query. Is it possible to do so? You see in the previous query all qualifiers were related to position-held (P39) / member od Spanish Congress (Q18171345). But political party seems to be related to another property (member of political party: P102). I need the political parties of all members of the Spanish Congress and the start date while being able to retrieve what you managed to do?
Coudl you please help me?
Sorry to bother you so much. But I really need this.
Thanks so much.
Automated edits - Tas political houses
editHi, I notice some of your automated edits have introduced a few accidental errors - see my corrections on Members of the Tasmanian Legislative Council, 2017–2023 (Q30681628) and Members of the Tasmanian House of Assembly, 2018–2021 (Q55641048). There may been some others caught by the same trap that need fixing! -- Chuq (talk) 06:14, 9 August 2021 (UTC)
Node string usability
editHi. Do you have a practical way of finding a node string in a simple way?
I'm trying to find a technique in Firefox(v. 91.0.1) that works for me without too much hassle:
- I go here https://www.wikidata.org/w/index.php?title=Q1566093&oldid=1482794946
- I want to link to the property P31 with value Q5583816
- I right click on "Google chrome extension"(which links to Q5583816) and I select "Inspect"
- I press uparrow(on my keyboard) 10 times and then I press F2(on my keyboard)
- Here I select and copy "Q1566093$0cb8ee27-4735-e688-0a11-5a3b2316120b"
- Now on any Wikidata item whether it is a regular Wikidata item or Wikidata property or a permalink, I just add to the end of the URL "#Q1566093$0cb8ee27-4735-e688-0a11-5a3b2316120b" and then it will link to a specific value of a property if there are multiple ones.
Do you know of an easier way to get a node string? Even if there is no easier way I am still happy you told me it's possible by giving me the first permalink to a property value on project chat and I'm thankful for that! Oduci (talk) 14:25, 20 August 2021 (UTC)
query doesn't work
editSELECT ?cast WHERE {
SERVICE wikibase:mwapi { bd:serviceParam wikibase:endpoint "en.wikipedia.org" . bd:serviceParam wikibase:api "Generator" . bd:serviceParam mwapi:generator "search" . bd:serviceParam mwapi:gsrsearch 'deepcat:"Islands in fiction"' . bd:serviceParam mwapi:gsrlimit "max" . ?cast wikibase:apiOutputItem mwapi:item . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . }
} } I'm trying to get a list of items listed at Category:Islands in fiction (except Fictional islands) and it's subcategories. Any idea why i don't get any results? --Trade (talk) 23:37, 5 September 2021 (UTC)
Constraint violation
editHi, stumpled over this https://www.wikidata.org/w/index.php?title=Q96712619&diff=1296791310&oldid=1296791293 while doing some statistics. Should they be moved to the reference or is the constraint bogus?--So9q (talk) 20:05, 13 October 2021 (UTC)