Tagishsimon

• Petscan: Female given name, no female gender
• Petscan: human no gender
• WQS Occupation count

Qs

Instead of typing [[Q20747326|Mary Mogg]], you can use {{Q|20747326}}. This renders as:

Mary Mogg (Q20747326)

and has the advantage of displaying the label in the reader's preferred language. Same goes for properties; {{P|496}} renders as:

ORCID iD (P496)

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

Mehr 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)

Oh, Jeez (Q27824086)

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

I 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

https://www.wikidata.org/wiki/Q28017188 yours sincerely, --Maaley (talk) 00:28, 16 December 2016 (UTC)

Item to be delete

In 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

Hi 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)

subject named as (P1810) and described at URL (P973)

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

Woot! 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

Hola, 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

Hello,

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)

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

Try it!

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)

Share your experience and feedback as a Wikimedian in this global survey

Hello! 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.

Take the survey now!

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!

WMF Surveys, 18:57, 29 March 2018 (UTC)

Please stop

Your 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)

• 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

Every 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!

WMF Surveys, 01:40, 13 April 2018 (UTC)

Ping IP

I 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)

Wikidata:Requests for comment/Sort identifier statements on items that are instances of human

Since you work on human data, maybe you are interested in commenting. 77.180.110.58 16:49, 25 April 2018 (UTC)

sex or gender (P21) = Klim (Q581072)

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

Thanks 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

One 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.

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". }
}

Try it!

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 top SELECT ?item ?itemLabel ?nickname ?head_coachLabel ?leagueLabel ?home_venueLabel. To get the actual name of the coach, I've added Label 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 find optional {?item wdt:P1449 ?nickname .} and not worry about the Label bit. (Although in fact you'll see the report actually asks for optional {?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, so SELECT ?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:

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". }
}

Try it!

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, wrapping optional {} around all three triples, and then adding a minus {?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)

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
}

Try it!

--Tagishsimon (talk) 00:47, 26 May 2018 (UTC)

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

Try it!

- College of Charleston Cougars women's basketball not in a league? --Tagishsimon (talk) 00:52, 26 May 2018 (UTC)

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.

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
}

Try it!

--Tagishsimon (talk) 01:15, 26 May 2018 (UTC)

@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
}

Try it!

--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

┌────────────────────────────────────────────────────────────────────────────────────────────────────┘The 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

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
}

Try it!

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)

References - both in case the entry is needed, and in cases where the entry is present

I'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)

┌────────────────────────────────────────────────────────────────────────────────────────────────────┘ 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 finally went to the source

Topic: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)

heritage designation (Q17504995)

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

Hi 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.

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

Try it!

... and then go thru the CSV by hand removing non-English labels. --Tagishsimon (talk) 09:28, 1 July 2018 (UTC)

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)

Data for instances of humans

Thanks 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

Hi, 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?

Just 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)

Weird dupes

I 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

User:Xaris333/Test

Hello. 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)

@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)

Duplicate movies

Hey 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

Any 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)

P921 tagging

Hi, 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.

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

Try it!

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

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").
}

Try it!

with Mycobacterium tuberculosis (Q130971) and those of

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").
}

Try it!

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)

Wikidata - Description for film entry

Hi, 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)

Wikidata:ContentMine/Cambridge Wikidata Workshop 20 October

You might be interested. Charles Matthews (talk) 15:46, 7 October 2018 (UTC)

Wittylama

Getting 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)

Try it!

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)

Try it!

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)

Try it!

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.

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)

Try it!

And again we can see the ?another_statement, for what it's worth

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)

Try it!

and we could scrunch things up bigly with square brackets if we felt like being flash:

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)

Try it!

--Tagishsimon (talk) 02:04, 29 October 2018 (UTC)

Emma K. Wilcox

I 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

I'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

Hi 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)

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

SELECT ?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". }
}

Try it!

--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)

Thank you (and one more question)

Thanks 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

Thanks 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

Pau 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

I 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". }
}

Try it!

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

I 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)

Hello,

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

Wondering 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

Hoi, I mentioned your recent activities on the admin board. Thanks, GerardM (talk) 12:39, 2 March 2019 (UTC)

Translation request

Hello.

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

Please 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

Hello 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?

Greetings. 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

So 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

You 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)

Good 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

Q64748146

FYI, this person is a man.

el.wikipedia article

SELECT 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

Try it!

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.

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

Try it!

--Tagishsimon (talk) 19:52, 14 July 2019 (UTC)

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

It is immense pleasure to get your support by preparing SPARQL query for my request. --Akbarali (talk) 10:51, 20 July 2019 (UTC)

Language

Hello 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

I 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

Hi 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

Share 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,

RMaung (WMF) 17:37, 10 September 2019 (UTC)

Reminder: Community Insights Survey

Share 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,

RMaung (WMF) 19:53, 20 September 2019 (UTC)

Q837766

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

Hello ! 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
}

Try it!

Thanks if you have any time to have a look at it! :) Bouzinac (talk) 15:46, 20 November 2019 (UTC)

Wikimedia list of persons by surname (P734) (Q58408484)

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)

Review this new page

Please review this page https://www.wikidata.org/wiki/Q77359124. Thanks (Shubham Ghodke) 17:50, 12 December 2019 (UTC)

Regarding the tone of your replies

Hi, 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

Hello,

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

Hi, 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

Hello. 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". }
}

Try it!

Xaris333 (talk) 21:02, 6 January 2020 (UTC)

Changes to P31 for journals

Hi Tagishsimon,

Please stop changing P31 while the discussion is still ongoing. --- Jura 10:40, 27 February 2020 (UTC)

Wikisource editions

Hi. 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

Hi! 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)

Wikidata:Requests for deletions#Historic Scotland redundant items

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

Hi! 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

Good to see you around --- Jura 04:32, 19 August 2020 (UTC)

Wikidata:Edit groups/QSv2/40147

Can you please respond? Neveselbert (talk) 20:55, 1 September 2020 (UTC)

Wikidata: (Q12940)

Il 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

Hello 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

At 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

Hi. 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

Hello, 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)

Dear 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

Hello! 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?

Just 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

The 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

Hi, the item is Wikidata Q3631228. Thanks, Krok6kola (talk) 23:09, 19 April 2021 (UTC)

Civiliy

Hi 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

Dear 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

What is your name? What are you doing here?

https://www.wikidata.org/w/index.php?title=Wikidata:Project_chat&diff=1426357994&oldid=1426338885

95.29.11.5 13:36, 22 May 2021 (UTC)

Geneve tramway

Hello, 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". } 
}

Try it!

I hope it is ok for you to discuss here. Cheers, --Bouzinac ^{💬●✒️●💛} 19:41, 30 May 2021 (UTC)

Thank you

Thank 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!!!

For 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

Dear 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.

--Mcptrad (talk) 20:18, 14 July 2021 (UTC)

Automated edits - Tas political houses

Hi, 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

Hi. 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:

1. I go here https://www.wikidata.org/w/index.php?title=Q1566093&oldid=1482794946
2. I want to link to the property P31 with value Q5583816
3. I right click on "Google chrome extension"(which links to Q5583816) and I select "Inspect"
4. I press uparrow(on my keyboard) 10 times and then I press F2(on my keyboard)
5. Here I select and copy "Q1566093$0cb8ee27-4735-e688-0a11-5a3b2316120b"
6. 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

SELECT ?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

Hi, 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)

thanks re Jean Cameron

Thanks for creating wikidata item for Jean Cameron https://www.wikidata.org/wiki/Q110026098 rural postwoman. I have sought an image from Postal Museum (on appropriate licence) and will add once it is in Commons. Kaybeesquared (talk) 21:28, 9 December 2021 (UTC)

list of shipwrecks

Hi,

I see that you added :

• list of shipwrecks in 2019 (Q60541464)is a list of (P360)shipwrecking (Q906512)

and

• list of shipwrecks in 2020 (Q85851288)is a list of (P360)shipwreck (Q852190)

More generally, see this query:

SELECT ?type (COUNT(?item) AS ?ct) WHERE {
  ?item wdt:P31 wd:Q13406463 ; rdfs:label ?itemLabelEN.
  FILTER((LANG(?itemLabelEN)) = "en")
  FILTER(REGEX(?itemLabelEN, "^list of shipwrecks"))
  ?item wdt:P360 ?type.
}
GROUP BY ?type

Try it!

Is it on purpose, is there a subtle distinction I didn't catch? (for the query above, it gather all items where the English label start with "list of shipwrecks" so I kind of expected the same value in is a list of (P360)) or is it just a inconsistency that should be fixed?

Cheers, VIGNERON (talk) 12:31, 18 December 2021 (UTC)

Short titles to UK Acts

Hi - I've noticed that you've added a large number of historic UK Acts, and have used the short titles taken from the lists of UK legislation on English Wikipedia. I can't emphasise enough just how much those lists are wrong. Most of those Acts do not have short titles. What someone did when preparing those is take the abbreviated description in the Chronological Tables, and then erroneously added "Act [year]" on the end, which is total nonsense, and is why numerous Acts appear to have the same name.

I am currently going over the list of Acts myself and knocking them into shape, using Wikidata as a backbone. Happy to work with you on this if you're interested? Theknightwho (talk) 00:55, 20 December 2021 (UTC)

Keeping the discussion eleborating

Sorry for keeping the discussion on the project chat so detailed but I am trying to educate some of my fellow norwegian users (and my self). Thanks in advance :) Pmt (talk) 19:54, 27 December 2021 (UTC)

Call for participation in a task-based online experiment

Dear Tagishsimon,

I hope you are doing good,

I am Kholoud, a researcher at King's College London, and I work on a project as part of my PhD research, in which I have developed a personalised recommender system that suggests Wikidata items for the editors based on their past edits. I am collaborating on this project with Elena Simperl and Miaojing Shi.

I am inviting you to a task-based study that will ask you to provide your judgments about the relevance of the items suggested by our system based on your previous edits. Participation is completely voluntary, and your cooperation will enable us to evaluate the accuracy of the recommender system in suggesting relevant items to you. We will analyse the results anonymised, and they will be published to a research venue.

The study will start in late January 2022 or early February 2022, and it should take no more than 30 minutes.

If you agree to participate in this study, please either contact me at kholoud.alghamdi@kcl.ac.uk or use this form https://docs.google.com/forms/d/e/1FAIpQLSees9WzFXR0Vl3mHLkZCaByeFHRrBy51kBca53euq9nt3XWog/viewform?usp=sf_link I will contact you with the link to start the study.

For more information about the study, please read this post: https://www.wikidata.org/wiki/User:Kholoudsaa In case you have further questions or require more information, don't hesitate to contact me through my mentioned email.

Thank you for considering taking part in this research.

Regards

Kholoudsaa (talk) 16:40, 3 January 2022 (UTC)

George Wood, Jacobus Jansonius, quickstatements [2.0]

Five months ago you separated Q108871756 George Wood born 1799 from Q56006595 Jacobus Jansonius. --manually if i understand the record; one day after I posted Wikidata:Project#need Split and Merge (listed among my few recent Contributions).

In November and December, two of the claims that you correctly moved from Jansonius to the new Wood page were re-created for Jansonius by User:Matlin using quickstatements [2.0] --if i understand the record. (I suspect that identifies automated work, perhaps returning to the sources for original creation of the claims by robots.) And last month there is a new claim Prabook ID by Matlin using quickstatements [2.0], which also belongs to the same George Wood.

Perhaps you are able to diagnose something useful to the project. --P64 (talk) 18:29, 25 March 2022 (UTC)

91896 and 91897

Hi! Could you stop and undo your https://quickstatements.toolforge.org/#/batch/91896? It is adding correct English descriptions as labels instead as descriptions. Thanks, --Epìdosis 17:25, 12 July 2022 (UTC)

Same problem in https://quickstatements.toolforge.org/#/batch/91897. --Epìdosis 17:27, 12 July 2022 (UTC)

Thanks for your help

Thanks for your help with the Welsh language Wikipedia: not everyone understands Wikidata Lists!

One further request please! For the last 5 years, I'm using many templates on cywiki to generate whole sentences within articles, live from WD. On the Titanic article you can see a number of them working successfuly. [Just a second for me to blow my trumpet!] However the marks / rating given by eg Rotten Tomatoes looks good, but as it's a table it will not hide on articles where no data is on WD. So in my latest article [Nordstrand (ffilm o 2014)], where no data exists, the sentence 'Cyhoeddodd Florian Eichinger nifer o ffilmiau gan gynnwys y canlynol:' / 'The following ratings have been given:' is visible. It's generated from this troublesome template called Template:Marciau.

If you can sort this out, I could use the template on quite a few future articles on cywiki; please feel free to edit the Marciau template directly, if you have the time and the energy. Thanks! Llywelyn2000 (talk) 07:36, 6 August 2022 (UTC)

Kyiv

Hi! About creating automated captions on wikidata, pls pay attention - it's Kyiv, not Kiev. Thank you from Ukraine, Franzekafka (talk) 18:16, 27 August 2022 (UTC)

@Franzekafka: Generally, exonymes of most notable cities, countries, rivers etc. have their own history and are based on older forms, and they usually do not copy the latest linguistic evolution of the home language, or political demands. Only the names of small, insignificant places have no exonymes and are only transliterated. I believe Kyiv is not such an insignificant place. --ŠJů (talk) 04:15, 30 December 2022 (UTC)

Date/time

Sorry for not responding at [11]; I was busy the past week. As for your response, I have a few comments.

1. Time can either be expressed as a moment, or as a duration. The meanings of those two concepts correspond to the meanings of a point and a segment on a line, respectively. A point on a line does not have a length; correspondingly, a moment in time does not have a duration.
2. Time is, of course, a fundamental property of the universe; as such, the shortest meaningful duration of time is a Planck time (at least according to our current understanding of physics). Thus, it makes sense (at least to me) to consider this duration a moment/point in time for the purposes of symbolic reasoning.
3. Help:Dates says that the time data type is used to store a point in time; it also enumerates the possible precision values that can be used. However, it does not define what a point in time with a precision means. Without such a definition, any time value specified to a precision less granular than a Planck time is ambiguous. For example, take the year 2020: it is a time interval consisting of a series of Planck times. If you specify a time value of 2020 with year precision, per Help:Dates you've specified a point in time, but which one? It could be any of the Planck times that make up 2020; Help:Dates does not specify which.
4. The above is precisely what I was trying to get across regarding Albacon (Q111974124)dissolved, abolished or demolished date (P576)1998: in and of itself, the moment in which Albacon (Q111974124) was dissolved is not specified unambiguously. Only with two additional facts is that ambiguity removed: Albacon (Q111974124) happens no more than once a year, and Albacon 98 (Q111976591)end time (P582)28 September 1998. From this it can be inferred that the Albacon series of events ended with the final moment of Albacon 98 (which is some Planck time within 28 September 1998), and I agree that it would be reasonable for the constraint checker to make that inference. Note, however, that the inference could not be made were it not for the "no more than once a year" bit: if that were not true, there could just as easily have been another Albacon after 28 September 1998 that no one bothered to add to Wikidata.
5. I hope I've made myself clear in the above points and that you won't simply declare them to be a "muddle". Saying something is a muddle is not constructive; if it doesn't make sense to you, say specifically why it is unclear either so that it can be explained, or so that the author of the supposed muddle can be enlightened.
6. And finally, I've asked you repeatedly why you said some of my statements were "deeply" wrong. Since you insisted on using that particular phrasing (as opposed to just wrong), I also insist on an explanation of why you thought my statements were deeply wrong, as opposed to just regular wrong, and what the difference is.

Silver hr (talk) 14:56, 21 September 2022 (UTC)

Creating duplicates: Q104901003

Hi Taggish,

why have you created Mines Advisory Group (Q104901003) (Q104901003) despite Mines Advisory Group (Q1364617) (Q1364617) has already existed? Please be more careful in future.--Matthew Cunliffe (talk) 16:12, 29 September 2022 (UTC)

PnB Rock

for the first to add the code.. nice work

PnB Rock

for the first to add the code.. nice work

Traditionally, barnstars are a way to show appreciation to another wiki contributor. If you see exemplary work from another contributor, use {{Barnstar}} to thank them, describing what the award is for.

the little fucker in the hood should of had security .... rip .. david adam kess.. always up to code

		The Wikidata Barnstar
		Thank you for your work on the Pnb Rock thanks in the year 2022 4th of October (UTC)

Q4711377

Was Albert Vander Veer (Q4711377) president, or vice president of the AMA? In the list we had two people for the same year. Both have obits that say they were president that year. This guy has two obits at Findagrave. Someone's note at Wikipedia has him as VP, but now a second obit has him as president. RAN (talk) 05:28, 25 October 2022 (UTC)

Nudge nudge, wink wink?

The last person you helped, quite literally wrote the book on SPARQL, hence I limited my answer to the peculiarities of Commons. Infrastruktur (talk) 19:14, 14 November 2022 (UTC)

Local proper nouns in item description

Hi Tagishsimon. When you want to cite some local name (from any statement) in the "description" field and the linked item hasn't its English label, you should use rather the label in the local language (depending on P17) or whatever another label which exists rather than the Q-code as you used here. "bridge in Q56414566" is not just suitable description.

In general, however, the question is whether it makes sense to individually generate such generic descriptions for individual languages. In general, it would be better if (in cases where a specific intelligent description is missing) the default generic description was defined by a general syntactic template that would be applicable to all languages, including an algorithm that would prioritize laguages of alternative labels in case the label is missing in the current language. In general, it is unnecessary for place names or other proper nouns in general to complete labels in all languages, if there exist no exonym in the target language for the item, and the original name is simply copied. It would be better to mark which of the labels contains the official name in its original (local) form, and automatically use this form for those languages that don't have and don't need their own translation or transliteration. IMHO the quickstatements application by Magnus Manske should be replaced by any script which would display default descriptions dynamically using one universal syntactic template, possibly adapted by specific algorithms for selected topic classes. Now, when those descriptions are generated for each language separately, everyone does it differently and at different times and according to different principles and often ill-conceived, it multiplies a lot of errors and illogicalities, which will be very laborious to correct in the future. If the default generic descriptions were dynamically generated by the universal template, then just fix the algorithm error in one place and all outputs will be fixed at the same moment. The "description" need not duplicate the basic statements, the quick summary of statements can be generated independently on the "description" field. The "decription" field should rather distinguish and add what is not unambiguous from the label, while the generic description is rather a basic classification of the item (and usually does not guarantee unambiguity). ŠJů (talk) 00:54, 30 December 2022 (UTC)

A second opinion

Sirs! Good day! As rather experienced users I would like to have your opinion about creating elements for every norwegian person held prisoned by the occupation forces during world war II. The elements will contain Name, place of birth, Date of birth prison-camp and at least 2 or more IDs. The number ogf elements will be if created around 45000 persons. At the time beeing there is no M'n'M planned. The persons are not notable as "ordinary person" but have IDs. I am also pinging, User:ArthurPSmith User:MisterSynergy User:ChristianKl Breg Pmt (talk) 12:40, 11 January 2023 (UTC)

@Pmt: What's the source database? This should probably go through the bot request process actually, but in general if it seems like a good set of source data and you will do something about cross-checking for duplicate items then it should be ok. ArthurPSmith (talk) 14:27, 11 January 2023 (UTC)

The source database is About - Norsk digitalt fangearkiv 1940-1945 - Fanger.no, the ID for the persons will be Norwegian prisoner register person ID (P8269): identification number for Norwegians in captivity during World War II 1940 -1945 and at least Norwegian historical register of persons ID (P4574): Identificator for a person in the Norwegian historical register of persons shall apply. Also the info for place of detention (P2632): place where this person is or was detained is available. 736 persons do have an element with the prisoner ID as they are notable for other reasons on WikiData. Alas bot-processes is above my knowlegde :) Pmt (talk) 16:10, 11 January 2023 (UTC)

I think it's a good idea to add them if the data comes from a reputable source. ChristianKl ❪✉❫ 19:10, 11 January 2023 (UTC)

Requesting adding an identifier to an Italian composer

Apologies in advance. I do not have any access to edit identifiers, therefore I cannot add the IMSLP ID section to [12]. I wonder if you can do this for me. And thank you in advance. Komitsuki (talk) 06:35, 12 January 2023 (UTC)

Rebuilt in stone

What's the best way to code for a viaduct originally with timber spans then being rebuilt in stone? (Eg all these in Cornwall). I tried this as a first stab (diff), but I'm not altogether convinced.

In some cases it's possible we may have an item already existing for the stumps of the original viaduct; but typically not, especially if the rebuilt structure was built around the existing piers of the original structure.

Any thoughts most welcome. Jheald (talk) 15:13, 22 January 2023 (UTC)

Looking at current properties on the set https://w.wiki/6FUB it looks as though so far nobody has really tried to capture this at all, apart perhaps from the Collegewood Viaduct (Q26482831) / Collegewood old viaduct (Q26501588) pair. Jheald (talk) 15:34, 22 January 2023 (UTC)

@Jheald: [13]? Multichill (talk) 15:38, 22 January 2023 (UTC)

@Multichill: Very nice. I like it. Jheald (talk) 15:49, 22 January 2023 (UTC)

Looking for help; what is Pn for an entity description?

Quick read: what is the Pn for an entity description e.g. Q4986825 is "American musical duo"?

Hello there. Sorry to bother you but I can't find this information anywhere and I saw you in recent changes doing a lot of editing of descriptions, and figured you might know what I need to know.

A Lua Module I just set free on Wikipedia accesses wikidata via the Wikibase Extension. For appropriate categorization I have placed the template Uses Wikidata, which requires a Pn for the property the Module is using, on the Module's doc page. I cannot find (not for a lack of trying) what the Pn is for the description of an entity e.g. Q4986825 (Buke and Gase) which has as its English description "American musical duo".

Could you tell me what that Pn is? Fred Gandt (talk) 05:57, 23 January 2023 (UTC)

Yale

Just wondering if you ever heard back from Yale regarding Property:P4169. DS (talk) 03:05, 28 January 2023 (UTC)

Civility warning

• "Your explanation sucks", "Your actions are sociopathic and wrong" Special:Diff/1908032388
• "You are vandalising WD." Special:Diff/1908058865
• "ffs, you are so so wrong" Special:Diff/1908135127

Regardless of the correctness of edits, this is not an acceptable way to have discussions with good faith editors. Please try to find a more collegiate way to interact. Consider making an apology. Bovlb (talk) 22:08, 4 June 2023 (UTC)

I was about to make the same comment. This all seems inappropriate. BrokenSegue (talk) 17:22, 6 June 2023 (UTC)

Block

You have been blocked for a period of 3 days for gross incivility immediately after warning Special:Diff/1910280935. 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 (talk) 16:51, 7 June 2023 (UTC)

@Bovlb: I think that is an uncalled for response, and I expect a more mature response from an administrator than the use of a hammer. Please take this block to the community for confirmation and a consensus.  — billinghurst sDrewth 00:33, 8 June 2023 (UTC)

@ billinghurst: Thanks for following up. I'm a little mystified as to why you see this block as uncalled for. As you can see above, Tagishsimon was grossly uncivil to another editor shortly after receiving a civility warning for very similar behaviour towards a different editor. Tagishsimon should have known that they were on a short leash and should have been able to avoid this. This was an unacceptable way for a Wikidata editor to communicate, and this sort of thing has a very toxic effect on the community. I'm shocked that you don't see this as requiring a response. Perhaps you could explain further.

This is (at least) Tagishsimon's third civility block. The previous two were for 48 hours (enwiki) and 31 hours, so 72 hours seems like a reasonable escalation.

We don't normally entertain unblock requests from uninvolved parties, and Tagishsimon has not made any indication that they feel that this block is unjustified. An unblock request by the blocked user is the normal process for a block to be reviewed by the community. Bovlb (talk) 01:29, 8 June 2023 (UTC)

@Bovlb: What do you think that a full block achieves? What message is it sending? How would you take someone standing over you with a big stick?

This wiki has partial blocks, so how about you use them if a person's contributions in a tiny part of this wiki are an issue. The approach of we will keep hitting you until your behaviour improves used by the Wikipedias, especially English Wikipedia, just causes other issues of leaving or running feral, so best not to follow that, especially as conversation and nuance are usually a lot more effective in actually solving problems.  — billinghurst sDrewth 06:10, 8 June 2023 (UTC)

what kind of partial block would you have suggested? from project chat? from Wikidata namespace? I could support that maybe. But yeah it does seem odd that you would (randomly?) show up to protest someone else's block. BrokenSegue (talk) 06:35, 8 June 2023 (UTC)

As an administrator, I am charged with using my mop to protect the project from disruption. Tagishsimon is a long-standing and normally-productive user with an unfortunate propensity to attack other users out of the blue. Dealing with users like this is one of the hardest tasks we administrators take on, and I'd say it's also probably the most thankless one.

Yes, I could have used a partial block. The evidence above is from two pages in two namespaces. (I haven't dug into their recent contributions in search of more.) A block from Wikipedia and User talk namespaces would likely have protected the project from further disruption in the short term. Would it have been effective in the long term to discourage Tagishsimon from continuing this behaviour after the block expires? I don't know. It's hard to say. We've had at least one case here on Wikidata where a namespace-based partial block of a long-standing user went very wrong, and we all had to work extremely hard to fix it. I might be wrong, but I think things were better for a while after Tagishsimon's previous block, so that's weak evidence that it is effective on some timescale.

But BrokenSegue brings up a very good question. Why are you here, protesting and negotiating this block and in such a strangely aggressive way? From a rough estimate, we block around 18 users every day. Have you intervened in any of those cases? We currently have four open unblock requests going back to March and April that are well overdue for resolution. Have you intervened in any of them? Why do you have so little interest in reviewing the evidence provided above? Why are you so strangely silent on the core issue of Tagishsimon's incivility? Tagishsimon has shown no inclination to appeal this block, so why are you trying to do it on their behalf? Is there something else going on here that the community should know about? Bovlb (talk) 08:44, 8 June 2023 (UTC)

I endorse this block. All my interactions from Tagishsimon have been soured by his attitude and so if a total timeout doesn't help him make an adjustment, I don't know what else is to be done for him. Elizium23 (talk) 10:59, 8 June 2023 (UTC)

In answer to the questions

• I commented here as this is where the context of the conversation is for the words and action of the blocking administrator CONTEXT.
• The remainder is irrelevant to my commentary and my initial request. Please focus on your roles, and stop trying to divert and to justify. It is unseemly your approach here on a user's talk page.

Is my initial request unreasonable and going to be undertaken?  — billinghurst sDrewth 22:34, 8 June 2023 (UTC)

By "initial request", I assume you mean "Please take this block to the community for confirmation and a consensus". If Tagishsimon were to make an unblock request (that was not immediately granted), then I would be happy to do so. (There is currently a thread I started on WD:AN for publicising unblock requests, and happily the backlog I mentioned above is now much shorter.) Without an unblock request, I see no reason to do so.

You're welcome to take it to the community yourself, but I predict that others will have the same reaction: to ask why you are trying to negotiate the unblocking of someone who is not seeking an unblock. As I pointed out before, it's not normal to entertain unblock requests from a third party. So far as I know, this is common across all WMF projects, so it should not be a surprise to you. The main purpose of an unblock request is to provide some assurance that the block is not necessary to protect the project from disruption. It would be difficult for a third party request to provide that assurance, and yours certainly does not.

Have you reviewed the evidence supporting this block? Do you believe it was acceptable behaviour and deserves no sanction?

Why did you choose to take an interest in this specific block? What drew it to your attention? Bovlb (talk) 23:20, 8 June 2023 (UTC)

Welcome back

Good to see you around --- Quesotiotyo (talk) 20:27, 25 July 2023 (UTC)

Manuscripts

Hi Tagishsimon, thanks for responding to my TwiX thread. I'm already aware of the collection of properties for describing manuscripts within the WikiProject Books and I aim at making it a more systematic and comprehensive data model. Denoting mandatory and optional statements is one thing I'd like to make clearer, but also I want to stress the difference of manuscripts from written works (and their relevance for these).

What I do not yet know is how to best go about it. I feel I would need to present the community with a large and detailed blogpost with subsections for each possible point of discussion. Or I could focus on aspects of the data model and discuss those one after another to reach conclusions. At any rate, would you be interested in participating in such a discussion? Or do you know any "stakeholders" in the manuscript sector here on Wikidata?

Best, Jonathan Groß (talk) 20:06, 5 October 2023 (UTC)

Scottish scheduled monument query...

Hi there, I'm looking at doing some work on updating the scheduled monuments in Scotland data, drawing from the HES data. In the process of doing so, I've come across one or two challenges, and I know you've done some work in this area so thought you might be able to help! In this instance I'm looking to understand more about the modelling of Q117885510 and Q1613640 as part of https://portal.historicenvironment.scot/designation/SM90161 - wondered if you might be in a position to give me some pointers? The chapel and castle have had their separate designations removed, and superseded by the scheduled monument listing. My gut feeling is that merging the items would be inappropriate, but maybe a new item of which the Castle "is part" might be more in the right direction? Not sure.... Lirazelf (talk) 14:57, 28 November 2023 (UTC)

Why did you merge European Forest Institute regional offices?

Hi - from https://efi.int/contact there are a number of different regional offices of EFI in various countries. Several of them had ROR and GRID ID's and were listed as separate items in Wikidata. However a few days ago they were merged - for example here, with the comment "same". They perhaps needed some better metadata to indicate how they were different, but shouldn't the distinct external id's have been a good enough reason to keep them separated? ArthurPSmith (talk) 17:17, 7 December 2023 (UTC)

An idea of user interface for queries based on query fragments

Hi, I ping you here as a frequent helper on the "Request a query page", you might have interesting insight for this project.

I think that some people find difficult to write queries even with the help of the query helper. I wonder if it’s a question of having too "low level" primitive. On the other hand there is an opportunity for "higher level" primitives to write queries through "query fragment". Over the years I wrote a couple of templates, see Help:Partial query that help with this (the list is the actual state, it’s of course open for extension and in no way ideal of complete)

But writing template for writing a query is of course too difficult for most users too. So I have the project of writing a user interface, as a gadget, for this. The idea is that when you edit (or view, or other entry points, an open webpage, a query service ui plugin, whatever) a wikipage there is an option to open the editor. The editor dynamically load these fragments, and a query is (at first draft) a list of these fragments with a set of parameters. There is a button to load the results, another to save your query on the page, generate a listeria query with this on the page …

Please let me know if you are interested into testing or … anything ! author  TomT0m / talk page 09:34, 12 January 2024 (UTC)

Language tables

I appreciate your interest in presenting tables of languages. I think I have a similar problem, as I want to build small database for comparing expressions in different languages, to assist with item for this sense (P5137) statements and make individual table cells editable. See for an example presentation Maybe we can cooperate to solve these problems. I'm trying to use Lua to access the individual table cells and store the database file in Commons.

So, I want one language per column and one short expression or phrase per row and I want to be able to add languages and phrases as time permits and the work proceeds. Would this be useful to you too? --SM5POR (talk) 09:43, 6 February 2024 (UTC)

Invitation to participate in the WQT UI requirements elicitation online workshop

Dear Tagishsimon,

I hope you are doing well,

We are a group of researchers from King’s College London working on developing WQT (Wikidata Quality Toolkit), which will support a diverse set of editors in curating and validating Wikidata content.

We are inviting you to participate in an online workshop aimed at understanding the requirements for designing effective and easy-to-use user interfaces (UI) for three tools within WQT that can support the daily activities of Wikidata editors: recommending items to edit based on their personal preferences, finding items that need better references, and generating entity schemas automatically for better item quality.

The main activity during this workshop will be UI mockup sketching. To facilitate this, we encourage you to attend the workshop using a tablet or laptop with PowerPoint installed or any other drawing tools you prefer. This will allow for a more interactive and productive session as we delve into the UI mockup sketching activities.

Participation is completely voluntary. You should only take part if you want to and choosing not to take part will not disadvantage you in any way. However, your cooperation will be valuable for the WQT design. Please note that all data and responses collected during the workshop will be used solely for the purpose of improving the WQT and understanding editor requirements. We will analyze the results in an anonymized form, ensuring your privacy is protected. Personal information will be kept confidential and will be deleted once it has served its purpose in this research.

The online workshop, which will be held on April 5th, should take no more than 3 hours.

If you agree to participate in this workshop, please either contact me at kholoud.alghamdi@kcl.ac.uk or use this form to register your interest https://forms.office.com/e/9mrE8rXZVg Then, I will contact you with all the instructions for the workshop.

For more information about my project, please read this page: https://king-s-knowledge-graph-lab.github.io/WikidataQualityToolkit/

If you have further questions or require more information, don't hesitate to contact me at the email address mentioned above.

Thank you for considering taking part in this project.

Regards Kholoudsaa (talk) 16:57, 19 March 2024 (UTC)

ASM Mammal Diversity Database

Hello, great work, but... a couple of mismatches, eg, [14] and [15], thanks, Maculosae tegmine lyncis (talk) 22:43, 11 April 2024 (UTC)

Unnecessary precision for the adresses

Hello. The changes you made on the streets in France are welcomed (Q121504666 for exemple), but don't say "arrondissement des Andelys". It is an administrative cut for the elections, not an administrative region like Normandie. It don't mean anything. Ty Rémi sim (talk) 19:44, 14 April 2024 (UTC)