Wikidata:Project chat/Archive/2016/12

From Wikidata
Jump to navigation Jump to search

This page is an archive. Please do not modify it. Use the current page, even to continue an old discussion.


The president of Haiti

Hoi, President of Haiti is a subclass. I regularly wonder what the structure means and increasingly I find the whole classification thing something that I cannot make head or tail out. Why all the intermediate steps and does it make sense to anyone? Thanks, GerardM (talk) 13:11, 29 November 2016 (UTC)

I find the structure quite appropriate. What is your issue with it?--Micru (talk) 13:45, 29 November 2016 (UTC)
This structure means that people who are instance of (P31) President of Haiti (Q3290543) are also instance of (P31) president (Q30461) and automatically but it's not required to add president (Q30461) again.ChristianKl (talk) 16:15, 29 November 2016 (UTC)
I see that subclass of (P279)  head of state (Q48352) got removed from the item, probably because president (Q30461) already has that statement. However, according to the various Wikipedia articles, some presidents aren't the head of state. Sjoerd de Bruin (talk) 19:04, 29 November 2016 (UTC)
My issue is that the structure is something that I find contrived, I do not understand it it is not something that I expect can be explained in a logical way. It is a mess. Thanks, GerardM (talk) 05:46, 30 November 2016 (UTC)
The structure of thinking in terms of classes and instances comes from Computer Science. Do you find the skos basic ontology less contrived? ChristianKl (talk) 23:09, 30 November 2016 (UTC)
That sounds like "it is legacy" and therefore sacrosanct. If it cannot be explained to people like me, what is the point? Thanks, GerardM (talk) 05:32, 1 December 2016 (UTC)

Party secretary property and items

I want to update the information about party secretary on some articles about political parties on Wikipedia (mainly in infoboxes). Since the information is outdated on some places, Wikidata is of course the best way forward. But there seem to be some "confusion" about the properties and some items here. When I try to add a new statement, and begin typing "party secretary", I get the property "party chief representative (P210)". But that seems to specifically refer to a leader in a communist party in many cases (languages and descriptions). On Wikidata there are the items "party secretary (Q836971)", "party chief representative (Q25712839)" and "party chief of the Communist Party of China (Q988456)". On English Wikipedia there are "Party secretary" and "Party Committee Secretary". Can someone help to give some advice on how to clear this out? /PatrikN (talk) 01:07, 30 November 2016 (UTC)

Generally, this is done the other way around: Individuals have statements using position held (P39) to link to the position, with qualifier of (P642) to the organization (if no specific . --Yair rand (talk) 01:42, 30 November 2016 (UTC)
Often but certainly not always. There are many items where there is an item for the specific position eg maharaja of Anwar. Thanks, GerardM (talk) 07:31, 30 November 2016 (UTC)
Thanks for the reply, but it really doesn't answer my question and as I understand, Wikidata is not bidirectional, so it have to be done both ways.
But I found an interesting discussion from when the property were created I think (here). There Zolo says "I am not quite sure about the scope (individualize by country ? Extend to non-communist countries ?" and that is exactly the case now, why I bring it up, since here in the Nordic countries where I live almost all parties have a party secretary and that has nothing to do with communism. It might be best to call the property party chief representative, but then the labels and descriptions should be changed I think, to be more general and eventually only mention communism as an example or subclass. Likewise party secretary might just be seen as a subclass of party chief representative.
Apart from that, I think some of the items I mentioned shall be merged.
Lastly, since there have been some discussion about this before, I don't know if this it the best place to discuss this, or e.g. the property talk would be better.
/PatrikN (talk) 13:51, 30 November 2016 (UTC)
If you want to say that the leader of Social Democrats (Q212101) is Mette Frederiksen, chairperson (P488) sounds like the relevant property.
party chief representative (P210) is something different. It is not supposed to be used on items about parties but on items about a territory or an organization. For example, there is a Communist Party secretary for Shanghai or a Communist Party Secretary in Peking University. It is the guy who represents the party there. Such a thing exists in communist countries, I think it existed in fascist countries.
In Democratic countries you may have a leader of the Democratic Leader for California or for Harvard, but that does not work the same way and I don't think this property should be used for these cases. -Zolo (talk) 14:32, 30 November 2016 (UTC)
Well, then I think a new property should be created, since the usage in Democratic countries are quite different, even though they relate in some way. On Wikipedia there are also two different articles, where e.g. Party secretary is described as "a senior official within a political party with responsibility for the organizational and daily political work with responsibility for the organizational and daily political work".
Looking at Socialdemokratiet at the Danish Wikipedia (or the local article for some other party in the Nordic countries), there is the chairperson/leader, then two Deputy leaders in this case and then party secretary (Partisekretær).
Looking at pages that link to party chief representative (P210), it's almost just about communist countries, so there should not be much work in changing anything that should be related to the new property.
Will it be possible to restrict the use of P210 to what you described and/or can it be possible to restrict the new to be used in relation to political parties and as a property for persons (holding this position)?
I think it should be created with labels just like party secretary (Q836971). Shall I do it or will you do it? And shall there be links between the item and property?
/PatrikN (talk) 15:30, 30 November 2016 (UTC)
We need or, or a few properties, to describe the leader of an organization, but I don't really see the need for a specific new property for political parties. There are so many different cases, and so many imaginable labels that it sounds like an unending task. I think we should rater use ageneric property like chairperson (P488) that can apply to political parties as well as other types organizations, and add qualifiers like Social Democrats (Q212101)chairperson (P488)  Mette Frederiksen (Q5015) / subject has role (P2868)party secretary (Q836971). -Zolo (talk) 09:00, 1 December 2016 (UTC)

Using external IDs as redirects to Wikidata items

Is there a standalone tool that makes it possible to use external IDs as "redirects" to Wikidata items? Using the GND ID (P227) "116814683" to link to the item Ernst Graf (Q15892138) for example. Jonathan Groß (talk) 16:21, 1 December 2016 (UTC) ?
--- Jura 16:27, 1 December 2016 (UTC)

Which one


< 2016–17 Premier League (Q23009701) View with Reasonator View with SQID > edition number (P393) View with SQID < 25 >


< 2016–17 Premier League (Q23009701) View with Reasonator View with SQID > series ordinal (P1545) View with SQID < 25 >


< 2016–17 Premier League (Q23009701) View with Reasonator View with SQID > part of (P361) View with SQID < Premier League (Q9448) View with Reasonator View with SQID >


< 2016–17 Premier League (Q23009701) View with Reasonator View with SQID > subclass of (P279) View with SQID < Premier League (Q9448) View with Reasonator View with SQID >

Xaris333 (talk) 16:59, 28 November 2016 (UTC)

. It's neither a part (a physical part ? what would be the sum of all the part ? The sequence of all championship?) nor a subclass (what would be its instances?). We have Help:BMP who provides guidelines on what instance of and part of means.
But you're right that there is a series of actual competition and that we should provide a way to model this, if possible consistent across different domains. Maybe we should create a "series of england football national championship" with
The rationale is that an event can appear in several series and that the number in the series depends of the series we consider. So we must bind the number with the series (it's a ternary relation for the mathematicians or computer guys amongs us) and the right way to do this is to put everything in a single statement. author  TomT0m / talk page 20:56, 28 November 2016 (UTC)

@TomT0m: So I must create items like "series of Premier League" for each league of each country? Xaris333 (talk) 11:43, 29 November 2016 (UTC)


< series of Ligue 1 (Q27927008) View with Reasonator View with SQID > has parts of the class (P2670) View with SQID < Ligue 1 (Q13394) View with Reasonator View with SQID >


< series of Ligue 1 (Q27927008) View with Reasonator View with SQID > has part (P527) View with SQID < 1932–33 French Division 1 (Q616704) View with Reasonator View with SQID >
series ordinal (P1545) View with SQID < "1" >



< 2016–17 Ligue 1 (Q22683328) View with Reasonator View with SQID > series (P179) View with SQID < series of Ligue 1 (Q27927008) View with Reasonator View with SQID >
series ordinal (P1545) View with SQID < "79" >


< Ligue 1 (Q13394) View with Reasonator View with SQID > series (P179) View with SQID < series of Ligue 1 (Q27927008) View with Reasonator View with SQID >

Are these all the cases? Are they correct? Xaris333 (talk) 15:20, 29 November 2016 (UTC)

Cant we have the 2016–17 Premier League (Q23009701) as instance of (P31) Premier League (Q9448) with edition number (P393) as a qualifier -- Unnited meta (talk) 16:21, 30 November 2016 (UTC)

@Xaris333, Unnited meta: Anyway it's kind of useless to try to explicit the number as it can be computed (by a query or in lua by a Module:PropertyPath :
SELECT ?championship ?championshipLabel (COUNT(DISTINCT ?earlierChampionship) AS ?count) WHERE {
  ?championship wdt:P31 wd:Q9448.

  ?earlierChampionship wdt:P31 wd:Q9448;
                       wdt:P155* ?championship.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
GROUP BY ?championship ?championshipLabel
ORDER BY ?count

Try it! author  TomT0m / talk page 18:59, 30 November 2016 (UTC) (once the data are complete, of course, not all championship have the required P31 atm.) author  TomT0m / talk page 19:00, 30 November 2016 (UTC)

Turned around :
select ?championship ?championshipLabel (?total - ?numbefore as ?rank) where {
      select (count(?allchampionship) as ?total) where {
        ?allchampionship wdt:P31 wd:Q9448.
      SELECT ?championship (COUNT(?earlierChampionship) AS ?numbefore) WHERE {
        ?championship wdt:P31 wd:Q9448.

        ?earlierChampionship wdt:P31 wd:Q9448;
                             wdt:P155+ ?championship.
      GROUP BY ?championship
    SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } 
ORDER BY ?rank
Try it!

@TomT0m, Unnited meta: Maybe is better to have:

< 2014-15 Premier League (Q16011788) View with Reasonator View with SQID > instance of (P31) View with SQID < sports season of a sports club (Q1539532) View with Reasonator View with SQID >
of (P642) View with SQID < Premier League (Q9448) View with Reasonator View with SQID >

or you think is better to have both

< 2014-15 Premier League (Q16011788) View with Reasonator View with SQID > instance of (P31) View with SQID < sports season of a sports club (Q1539532) View with Reasonator View with SQID >
< 2014-15 Premier League (Q16011788) View with Reasonator View with SQID > instance of (P31) View with SQID < Premier League (Q9448) View with Reasonator View with SQID >

Xaris333 (talk) 12:36, 1 December 2016 (UTC)

Nice queries!

I considered the sports season to be for a specific team in that season. For eg: Manchester United won the treble in the 1998-99 English season so 1998–99 Manchester United F.C. season (Q939916) is instance of (P31) sports season of a sports club (Q1539532). So though the season duration matches with that of the Premier League, a season generally consists of other competitions as well

--Unnited meta (talk) 17:26, 1 December 2016 (UTC)

@Unnited meta: So what is 2014-15 Premier League (Q16011788)? Maybe football championship (Q15838706)? Or domestic association football season (Q5290181)? Xaris333 (talk) 19:23, 1 December 2016 (UTC)

2016–17 Premier League (Q23009701) instance of (P31) Premier League (Q9448)

Premier League (Q9448) subclass of (P279) national association football league (Q15991303) -> subclass of (P279) sports league (Q623109)

Premier League (Q9448) subclass of (P279) football championship (Q15838706) -> subclass of (P279) sport competition (Q13406554) -> subclass of (P279) competition (Q476300)

football championship (Q15838706) is also subclass of (P279) tournament (Q500834)

I didn't realize we had domestic association football season (Q5290181), in which case 1998–99 Manchester United F.C. season (Q939916) instance of (P31) domestic association football season (Q5290181) which is a subclass of (P279) sports season of a sports club (Q1539532) --Unnited meta (talk) 16:59, 2 December 2016 (UTC)

>50k dead links - can someone be proactive?

The Olympics part of was taken offline yesterday. The effect here is being discussed at en:Wikipedia_talk:WikiProject_Olympics#Warning on closing down and migrating and Property talk:P1447. There are over 50k, maybe 85k, now broken links to that dead website.

We now can either just sit back and wait to see what they create at the new, upcoming IOC site next year, and then try to migrate our links via a bot or similar, or we could be proactive, and get someone, high up the WMF/WD/WP management food chain who knows about bots and WikiData, to be involved/aware of the new site setup so that the transition could be more seamless and less painful. The-Pope (talk) 15:20, 2 December 2016 (UTC)

  • Seems to be still online at the moment. has at least some copies of their records so we can replace the link with an link if it really goes away. ArthurPSmith (talk) 15:46, 2 December 2016 (UTC)
  • Bill Mahon of Sports-Reference has commented in this enwiki thread, and what he says is quite promising since he seems to care about our problem. In my opinion it would be the best to tell him what we need for migration; I could imagine that if they provide a mapping between old and new identifiers(or URLs) we’d already be on the safe side. I also guess it would be useful to start with the ~95.000 Wikidata items with Sports-Reference identifiers, and modify Wikipedia links soon thereafter. —MisterSynergy (talk) 17:25, 2 December 2016 (UTC)

Archiving the properties for deletion page

Sections at Wikidata:Properties for deletion which have been marked as resolved for more than a few days need to be archived. Can a bot, or otherwise, an admin, do this, please? Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 15:43, 2 December 2016 (UTC)

What's wrong with your hands? Sjoerd de Bruin (talk) 17:25, 2 December 2016 (UTC)
Yet another snark from you, Sjoerd, and no positive contribution. This is tiresome. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 21:08, 8 December 2016 (UTC)
I put there {{Autoarchive resolved section}}, that should archive the marked ones. Matěj Suchánek (talk) 21:57, 2 December 2016 (UTC)
@Matěj Suchánek: Thank you. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 21:08, 8 December 2016 (UTC)
I archived them manually, but for the next time it could be automatic.--Micru (talk) 22:06, 2 December 2016 (UTC)
@Micru: Thank you. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 21:08, 8 December 2016 (UTC)
This section was archived on a request by: Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 21:09, 8 December 2016 (UTC)

Request a volunteer?

Sometimes I am looking for easy tasks to do, maybe we could have a page with Wikidata:Request a volunteer listing simple tasks that any user could accomplish in a short time. What do you think?--Micru (talk) 22:10, 2 December 2016 (UTC)

Tasks to do by what means? --Succu (talk) 22:11, 2 December 2016 (UTC)
Short tasks that can be done manually, or semi-automated. For fully automated tasks we already have Wikidata:Bot requests.--Micru (talk) 22:25, 2 December 2016 (UTC)
Do you think that you would want to do manual tasks that someone writes on such a page? ChristianKl (talk) 00:22, 3 December 2016 (UTC)
  • As you are asking for it: Wikidata:WikiProject_Movies/Tools has a list of tasks .. maybe there is one that interests you. You could also think about an aspect of films we don't cover yet and suggested how we can close that gap.
    --- Jura 22:31, 2 December 2016 (UTC)
@Micru: volunteers are always wanted to work on these, these or these:) --XXN, 11:01, 3 December 2016 (UTC)

Wikidata:Requests for comment/Picture of the day

Will this get implemented one day? MechQuester (talk) 02:47, 4 December 2016 (UTC)

Spaces in formatted URLs

On File Format Wiki page ID (P3381) none of the examples work because in the formatted URL the spaces have been replaced by plus signs. Curiously, when you go to the property's documentation, where its Wikidata property examples are transcluded, the spaces are kept and the links work! Any ideas to create working links? Thanks! --Azertus (talk) 22:48, 2 December 2016 (UTC)

For now I've added instructions to use underscores instead of spaces, but it would be nice if this was not necessary... --Azertus (talk) 14:43, 4 December 2016 (UTC)

Sources for new coordinates?

Hi all. I'm trying to add coordinates for some articles that don't currently have them either here or on Wikipedia. What's the best way of finding coordinates for the articles, and importing them to Wikidata? I know using Google Maps for this is not an option due to copyright. At the moment I'm using OpenStreetMap, e.g. [1], but I gather that this might have problematic copyright as Wikidata's CC-0 license means we're not following OSM's CC-BY license? But then, shouldn't the same problem also be true for coordinates imported from Wikipedia? Thanks. Mike Peel (talk) 13:04, 4 December 2016 (UTC)

I don't know about other countries, but in the US, facts cannot be copyrighted, only the expression of facts. If you went into Google Earth, looked visually at an item of interest, and read off the coordinates of the center of the item, the resulting coordinates would be a fact, not expression, and not subject to Google's copyright. Can you give a link to the policy, discussion, etc., which makes you think we can't look up coordinates on Google Maps? Jc3s5h (talk) 15:20, 4 December 2016 (UTC)
In Europe there are database rights, which I understand are an issue, particularly with Google Maps. See . Thanks. Mike Peel (talk) 19:11, 4 December 2016 (UTC)
If you look at the area with Google maps and don't copy the specific coordinate of a city like Berlin that Google uses but use any coordiante that's right, I don't think you would violate Google's suis genesis database rights. ChristianKl (talk) 00:28, 5 December 2016 (UTC)

How to add films as part of Petscan?

What is the code for films if I wanted to add instance of film? MechQuester (talk) 01:09, 5 December 2016 (UTC)

never mind. I figured it out. MechQuester (talk) 01:12, 5 December 2016 (UTC)

Adding pronunciation to an item

Is the audio property meant for things like this? See diff]. Thanks in advance, Jane023 (talk) 14:46, 28 November 2016 (UTC)

No, IMHO this should be done with pronunciation audio (P443). Lymantria (talk) 14:58, 28 November 2016 (UTC)
Thanks! Jane023 (talk) 15:41, 28 November 2016 (UTC)
Pronunciations are problematic. We do not have the right environment to indicate what it should be. It is much more useful at the time when we support Wiktionary. Thanks, GerardM (talk) 12:04, 5 December 2016 (UTC)

Deprecation of gender-specific sibling properties

Where was the deprecation of no label (P7) and no label (P9) decided? Coincidentally, I'd just today read up on the discussions I could find about this issue and my take-away was that no consensus was reached yet. I'm not commenting on the proposal itself, just curious to know where the discussion happened. --Azertus (talk) 16:09, 3 December 2016 (UTC)

Wikidata:Requests for comment/Make family member properties gender neutral --Pasleim (talk) 16:16, 3 December 2016 (UTC)
The RfC Make family member properties gender neutral has been being linked above your watchlist for a longer time now. There is also Wikidata:Property proposal/sibling. —MisterSynergy (talk) 16:18, 3 December 2016 (UTC)
They might be kept as subproperties wherever gender is not a problem. Thierry Caro (talk) 14:44, 4 December 2016 (UTC)
Sorry, but unclosed and inconclusive RfC cannot be reason for deprecation of properties with 10,000+ uses on WD and multiple uses in multiple templates on wikis.--Jklamo (talk) 02:30, 5 December 2016 (UTC)
I totally agree. My personal approach is that I do not add any siblings but prefer to add fathers and mothers. Thanks, GerardM (talk) 12:06, 5 December 2016 (UTC)
I tend to agree (coincidental similar opening due to edit conflict!). At the very least any proposal to deprecate these properties should come with a solid plan to migrate to the new property (probably bot-assisted). Adding the (deprecated) label to such a highly visible property doesn't reflect well on the project. To a casual visitor to one of our items this would probably not instill much confidence in our ability to responsibly curate their possible future edits/work on here.
Also, "But the plans were on display...", they were indeed at the RFC page and now I remember I indeed visited it. But the opinion seemed to be very much split at the time of my visit. It is indeed listed on the Watchlist as well, but I know my eyes are trained to scan and select the information I want from that page and neurologically we are probably effectively blind to such other additions to the page. I would support a more visible process for proposals (properties, RFCs, etc.) that are about to close. Instead of closing a property, maybe it could be marked instead, starting a deadline of a couple of days during which it is advertised even more clearly (e.g. using colour on the Watchlist) or by notifications one can subscribe to. --Azertus (talk) 12:20, 5 December 2016 (UTC)
  • At the time I created the property and posted in Bot request there were 8 votes in favor and 2 against (included my own in against). I didn't close the RfC because there still open discussion about father/mother and stepfather/stepmother. ChristianKl (talk) 13:27, 5 December 2016 (UTC)

P625: Why is 60 seconds possible?

Hello WD, could someone please help to clearify the question i asked at Property talk:P625? Thank you, --Aschroet (talk) 09:13, 5 December 2016 (UTC)

@Lea Lacroix (WMDE): Could you point anyone from the team to take a look at this? Matěj Suchánek (talk) 17:18, 5 December 2016 (UTC)


Could I get some advice on personification, please. Two instances: Anna Livia (Q27957442) (which I confess right now conflates a couple of different concepts, a fictional character from Finnegans Wake, and the personification of the River Liffey), and 'La Pepa', by & large the female personification of the w:en:Spanish Constitution of 1812.

It would be useful to have items for both Anna Livia in its personification sense, and for La Pepa, since they give rise to the naming of the Anna Livia Bridge (Q4767235) and the La Constitución de 1812 Bridge (Q6464357), and both of these will benefit from an appropriate named after (P138). Per Anna Livia (Q27957442), I understand we have a value anthropomorphism (Q132987), but how do we say what the item is a personification of? Do we use named after (P138) in the Anna Livia (Q27957442) item to point to Liffey (Q208009) and named after (P138) in a to-be-created 'La Pepa' item to point to Spanish Constitution of 1812 (Q1421412). Or what? thanks --Tagishsimon (talk) 10:35, 5 December 2016 (UTC)

Allowed values constraint

Are we missing an "allowed values constraint"? To be used on properties as follows:

< constraint status (P2316) > property constraint (P2302) View with SQID < allowed values constraint >
item search < Q21502408 >

I'm also not sure which property should go in the place of "item" (class (P2308)?). I'm probably missing something obvious here, so apologies in advance.

By the way, I got led into this rabbit hole by checking if the qualifier constraint status (P2316) could be used with any other value besides mandatory constraint (Q21502408). The answer appears to be no, but this is not yet reflected by a property constraint, hence the above question.

ETA: I believe there might need to be a "non-mandatory constraint" item as well. At least Template:Constraint:Type has a mandatory=true switch, the absence of which can't be modeled as of yet? --Azertus (talk) 14:52, 5 December 2016 (UTC)

Wikidata weekly summary #238

One building succeeding another

Hello, I have a question about which property to use. Gleaston Castle was (probably) built to replace Aldingham Castle. The structures are a couple of hundred metres apart so Property:P167 doesn't quite fit the bill. Should I use Property:P155? Richard Nevell (talk) 19:56, 5 December 2016 (UTC)

replaces (P1365)/replaced by (P1366) could fit. Matěj Suchánek (talk) 10:30, 6 December 2016 (UTC)

External images of museum objects

Proably asked before, but when we add museum collections, how can we add the url of the external image of an object? For example Should we use described at URL (P973) with instance of (P31) is image (Q478798)? Or should we per museum create a property and save the objectid that is converted to the image? Or are external links to copyrighted images prohibited within Wikidata? --Hannolans (talk) 16:40, 6 December 2016 (UTC)

I would link to using described at URL (P973) and not deep link to the file. I don't think these file deep links are very stable and what is exactly the use case for these deep links? Somehow embedding external images in the representation of a Wikidata item? Wikimedia hot linking hosted images, but I think other sites are less happy about that. Multichill (talk) 17:42, 6 December 2016 (UTC)

Help needed: central military items curreently mixed-up

as i don't have the time to check/repair this mess myself, can please someone else have a look at Special:Contributions/GiorgiXIII? the user has mixed-up and/or emptied some central military items.
Affected items are: military (Q8473), field army (Q51977), armed forces (Q772547), no label (Q27966033), no label (Q3505278). the first three are used by hundreds/thousands of other items.
Holger1959 (talk) 00:43, 6 December 2016 (UTC)

@Holger1959: is it OK now again? Jared Preston (talk) 13:55, 6 December 2016 (UTC)
@Jared Preston: thanks for restoring the old situation. looks good as far i can say. (though individual sitelinks might need to be moved from A to B in the future, but blanking and creating new items shouldn't be necessary, i think) Holger1959 (talk) 04:27, 7 December 2016 (UTC)
Hm, I can't distinguish between the first three... And I see many errors in using the first. --Infovarius (talk) 10:38, 7 December 2016 (UTC)


Merge this pages please and Sorry wor bad english, because I´m from Czech repbulic. -- 13:58, 8 December 2016 (UTC)

We won't merge, because a disambiguation page isn't a given name. There is no reason to merge. --Harmonia Amanda (talk) 14:12, 8 December 2016 (UTC)
Please, there are same name. -- 14:24, 8 December 2016 (UTC)
No, they are not. Josef (Q15730712) is a given name, Josef (Q4205987) is a disambiguation page, the Wikipedia articles list things others than people sharing the same given name. The two shouldn't be merged. --Harmonia Amanda (talk) 14:42, 8 December 2016 (UTC)
Ok, but english was in worse Wikidata page. -- 14:46, 8 December 2016 (UTC)

Coyau is dead.

it's with great sadness that I inform you that Coyau (talkcontribslogs) is deceased. He was one of the most prolific contributors here and participated in Wikipedia, Wikisource and Commons as well. He will be sorely missed. --Harmonia Amanda (talk) 12:14, 6 December 2016 (UTC)

Oh, my condolences and deepest sympathy! What happened? Jared Preston (talk) 13:53, 6 December 2016 (UTC)
We don't know yet. We are waiting for the autopsy. Pyb (talk) 16:25, 6 December 2016 (UTC)
Fuck. How old was he then? Jared Preston (talk) 22:17, 6 December 2016 (UTC)
@Jared Preston: Do you think „Fuck“ is a appropriate wording? I'm sorry of the loss of Coyau's family. --Succu (talk) 22:29, 6 December 2016 (UTC)
I am just completely surprised at the news. Jared Preston (talk) 22:39, 6 December 2016 (UTC)
He was 38. -Ash Crow (talk) 13:14, 7 December 2016 (UTC)
My deep condolences to his family and his friends. He will be remembered as an important and prolific contributor to free knowledge, and badly missed. Thank you for bringing these sad news. --Denny (talk) 23:17, 6 December 2016 (UTC)
+1 very sad news, indeed. Holger1959 (talk) 04:29, 7 December 2016 (UTC)
I'm very sad to hear this too. Can we leave condolences somewhere in a place where his family and friends can see/read them? Spinster 💬 14:22, 7 December 2016 (UTC)
Maybe on his user page on the French Wikipedia. I will send the link to his mother. Pyb (talk) 18:59, 7 December 2016 (UTC)
@Denny: You can use Wikidata:Deceased editors. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 19:53, 8 December 2016 (UTC)
My condolences as well to his close friends and family :( He has helped greatly in sharing free knowledge here with us on Wikidata and other Wikimedia projects and made a difference in this world. --Lydia Pintscher (WMDE) (talk) 19:10, 8 December 2016 (UTC)
Sad news. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 19:53, 8 December 2016 (UTC)

Discography without artist

See PSID=618791 for a list of items for a discography that doesn't specify the artist yet. I'll fill out a few meself as well. Edoderoo (talk)

Thanks to everyone that helped to get this list shorter. You amazed me, and made my day! Edoderoo (talk) 20:25, 8 December 2016 (UTC)

Why can't I create WikiProject:United_Nations

Hi all

I want to create a Wikiproject specifically for importing the huge amount of data that the UN produces, the Wikiproject is also running on Wikipedia and Commons for articles and media content. I'm trying to create from the draft page I started here but it won't let me for some reason. Could someone explain what I'm doing wrong or create it for me if some special permission is required?

Many thanks

--John Cummings (talk) 13:41, 8 December 2016 (UTC)

There is no WikiProject name space here at Wikidata. The projects here are named like Wikidata:WikiProject Danmark, see Category:WikiProjects for an overview. So the name for yours (which I didn't look at) should probably be Wikidata:WikiProject United Nations. --YMS (talk) 14:17, 8 December 2016 (UTC)
Ah, thanks YMS (talkcontribslogs), that makes sense. --John Cummings (talk) 14:31, 8 December 2016 (UTC)
Already done by me. MechQuester (talk) 04:49, 9 December 2016 (UTC)

PetScan + Query

Is there any way to pipe PetScan results into Query? Specifically, I would like to obtain P31 of all items using a set of templates. Do you know some alternative way to do it? Thanks, Paucabot (talk) 17:02, 8 December 2016 (UTC)

Not directly. You can save Petscan results at Pagepile ("Format" at Output tab) and then use Tabernacle. --Edgars2007 (talk) 17:10, 8 December 2016 (UTC)
Thanks, @Edgars2007: I didn't know this tool! Paucabot (talk) 19:54, 8 December 2016 (UTC)

WDQ is dead?

How can I get the number of items with some claim by API now? Earlier it was done by URL like[2936]&noitems=1 --Infovarius (talk) 13:47, 5 December 2016 (UTC)

There is the query service at You can access it as an API as described at mw:Wikidata query service/User Manual#SPARQL_endpoint (linked from the "Help" menu) and there is also a link to a WDQ syntax translator (in the "Tools" menu). This query should give you the number of items. This is the same thing as an API request. - Nikki (talk) 16:02, 5 December 2016 (UTC)
Oh, much more difficult... But anyway, thanks for API. --Infovarius (talk) 12:28, 7 December 2016 (UTC)
Hmm but this results "Warning: file_get_contents( failed to open stream: HTTP request failed! HTTP/1.1 504 Gateway Time-out in /data/project/listeria/ on line 418" when updating Wikidata:Database reports/WMF projects. --Liuxinyu970226 (talk) 14:52, 9 December 2016 (UTC)

Preventing incorrect merges

Is there any way to add a warning or note to prevent repeated merge of two items that are not the same? Zdravljica (Q169215) and Zdravljica (Q27965845) have been merged twice today, but if you look at the content, these are completely different items. Both are Slovene songs, and they have the same title, but the lyrics and authors are different. --EncycloPetey (talk) 20:02, 5 December 2016 (UTC)

You can link the two items with different from (P1889) to make clear that they aren't the same. It would also make sense to add more statements such as author (P50). ChristianKl (talk) 21:09, 5 December 2016 (UTC)
  • If you can find a way to add a site link for the same language in both that will prevent the merge (for example if each has a page linked in the slovenian language wiki). ArthurPSmith (talk) 21:13, 5 December 2016 (UTC)
@ChristianKl: Thanks. I tried to find something like this, but the software never offered this when I searched.
@ArthurPSmith: That would only be possible if I knew enough Slovene to go looking for the different texts, could understand the publication data, and thus add the new text at the Slovene Wikisource. Unfortunately, I do not know Slovene well enough to do that. --EncycloPetey (talk) 02:04, 6 December 2016 (UTC)
I haven't tried these "games" that causes these merges, but it definitly look like they need a "yes, I know what I am doing"-button
@ArthurPSmith: That didn't stop Grimsta (Q4356886) and Grimsta (Q2608131) from being merged. -- Innocent bystander (talk) 07:36, 6 December 2016 (UTC)
Whatever these "Games" are, they're responsible for more problems than just incorrect merges. Several times now, I've seen them responsible for adding Britannica On-line ID "links" to articles where either (a) no such article exists at Britannica on-line, or (b) the wrong article title was linked. --EncycloPetey (talk) 08:55, 6 December 2016 (UTC)
@Innocent bystander: You added the "different from" statement after the merge, so it's not really a surprise that the statement could not prevent the merge. If you would have added it before, it would have, simply because you cannot merge items that link to each other already. --YMS (talk) 14:58, 8 December 2016 (UTC)
@YMS: I responded to User:ArthurPSmith. The two items about a place called "Grimsta" both had a svwiki-sitelink, but were still merged. Both also had good P31-claims that could have helped identify them as two different subjects. The only things they have in common, is the spelling of their names (I doubt they are pronounced the same) and that they are located in Stockholm County, Sweden. -- Innocent bystander (talk) 15:21, 8 December 2016 (UTC)
Wow so "Distributed Game" "Merge items" just threw out the incompatible sv link without a second thought? That seems quite dangerous - who's responsible for it? ArthurPSmith (talk) 14:26, 9 December 2016 (UTC)

We need your input about gadgets and UI stability

Hello all,

We're starting a consultation about gadgets and how we can improve our workflows to avoid breaking user scripts when we're modifying Wikidata's interface. We would be very happy if the gadgets/user scripts developers could take time to answers these few questions, even if of course anyone is welcomed to add suggestions or questions.

Thank you very much! Lea Lacroix (WMDE) (talk) 15:52, 9 December 2016 (UTC)

Stained glass versus stained glass windows

We have stained glass (Q1473346) and it seems to cover everything related to stained glass: stained glass as a material, stained glass as an artistic technique, windows and other objects made using stained glass... Sometimes it's used with instance of (P31) to say that an item is a stained glass window, sometimes it's used with material used (P186) to mean that something is made from stained glass. Some of the labels seem to mean the material, others seem to specifically mean windows. It all seems to be a bit of a mess.

I think the right thing to do is to split it because a stained glass window is a type of window (made of stained glass) and searching for windows should find stained glass windows too, but stained glass as a material isn't a type of window, so it doesn't make sense to use the same item for both things. A while ago I made stained glass window (Q21061279), but that's unfortunately as far as I got.

The sitelinks on Q1473346 that I can understand are about stained glass in general, so I think the labels which specifically mean a window should be moved to Q21061279 (along with any statements and sitelinks which are specific to windows), but I'm not sure which those are. Can anyone help me clean this up?

(@Oursana: pinging you in case you're interested or want to comment :))

- Nikki (talk) 21:24, 9 December 2016 (UTC)

As happens very often the site links do not fit exactly. One has also to consider whether stained glass (Q1473346) only means the technique, not the material.
As the technique is broadly used with windows this project could be about both, as are many site links.
The sitelinks are at least not all about stained glass in general, de is about stained glass windows, for what we habe no special word. Glasmalerei means the technique which is only used with church windows, so I would not split. Same with en:work=window and material.
fr:Vitrail is very similar to en and does not mean the window
in it it is the window and not the technique
in nl it is colored glass, not the technique, not a window.
I am not quite sure if your stained glass window (Q21061279) item passes WD:N--Oursana (talk) 21:49, 9 December 2016 (UTC)

Compositions without a composer

On PSid=621087 there is a list of compositions that do miss a composer. For those that would like to edit a few... Edoderoo (talk) 15:56, 10 December 2016 (UTC)

It seems that some are false positives, where instance of (P31) should be changed to subclass of (P279). Others conflate manuscript (Q87167) and musical composition (Q207628). Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 18:22, 10 December 2016 (UTC)
Now all done. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 18:35, 10 December 2016 (UTC)

changing descriptions

Hi, I was wondering if there is a quick way (or perhaps an semi-automated tool) that can quickly change descriptions. MechQuester (talk) 06:25, 10 December 2016 (UTC)

QuickStatements (Q20084080)MisterSynergy (talk) 06:37, 10 December 2016 (UTC)
Thanks. that looks like it has a high learning curve. sigh. MechQuester (talk) 02:09, 12 December 2016 (UTC)

How to describe the use of a railway station?

I want to establish whether a train station is used for both passenger and freight traffic or only one of those. The best I could come up with is connecting service (P1192) with freight train (Q954927) and/or passenger train (Q1363599). Does anyone use any other method?--Strainu (talk) 00:06, 11 December 2016 (UTC)

instance of (P31) train station
qualifier: of (P642) passenger transport (Q2072431)--Oursana (talk) 02:30, 11 December 2016 (UTC)
I wouldn't use connecting service (P1192) because freight train (Q954927) and passenger train (Q1363599) aren't instances of no label (Q16323955). Either use a qualifier like Oursana suggested or create two new items "passenger railway station" and "freight traffic station" and use them instead of railway station (Q55488). --Pasleim (talk) 18:07, 11 December 2016 (UTC)
Second solution. the of (P642) View with SQID qualifier is undefined. We should instead (I think we discussed that but don't remember when or if a proposal occured) create a property about the kind of stuff a vehicle carries.
This would give something like
  • < freight train > subclass of (P279) View with SQID < train >
  • < freight train > has quality (P1552) View with SQID object or value >
    kind of carried stuff search < freight >
  • < freight traffic station > type of vehicle search < freight train >
    . I'll propose the necessary properties. author  TomT0m / talk page 19:13, 11 December 2016 (UTC)
It seems that those two properties fits partly : designed to carry (P3349) View with SQID and item operated (P121) View with SQID. author  TomT0m / talk page 19:18, 11 December 2016 (UTC)
Actually there is a property proposal for what is actually carried : Wikidata:Property_proposal/people_or_cargo_transported. Please support if you find this useful for your problem. author  TomT0m / talk page 19:37, 11 December 2016 (UTC)

Dead links

Dead web links in URL or external-id datatype statements can be marked with deprecated rank. Do we also add qualifiers to indicate the reason of deprecation? If so, which ones? Do we have a relevant help page? —MisterSynergy (talk) 08:49, 11 December 2016 (UTC)

There is reason for deprecation (P2241) for deprecated statements. But I don't see any dead link item yet. Matěj Suchánek (talk) 09:08, 11 December 2016 (UTC)
Thanks, this is what I was looking for. Current uses can be identified by this query. I’ll manage to find something suitable. —MisterSynergy (talk) 09:34, 11 December 2016 (UTC)
@MisterSynergy: It's a bit of the wild west at the moment with regards to reason for deprecation qualifiers. I'd suggest to be liberal with choosing a suitable item, even to create your own if necessary. I've been collecting some as instances of Wikidata reason for deprecation (Q27949697), a subclass of Wikidata internal entity (Q21281405) which contains other interesting stuff.
There's two types of items used: the ones created especially/only for use with reason for deprecation (P2241) (such as not been able to confirm this claim (Q21655367)), which are the ones I've been marking. The second are items for concepts that can more or less double as a reason (such as ambiguity (Q1140419)) and whose use will (or won't) grow organically until maybe they are adopted as a standard. I've been considering marking those as well as instances of a yet-to-be-named subclass of Wikidata reason for deprecation (Q27949697) or Wikidata internal entity (Q21281405) (maybe "concept used in Wikidata qualifier statements"), but a query like yours may be a better way to look for them or collect them. --Azertus (talk) 13:13, 11 December 2016 (UTC)
Thanks for commenting. This time I chose withdrawn identifier value (Q21441764) from the items already in use with this property, since this pretty much describes the situation: dead/invalid links in external-id statements. Getting these reason items managed properly by subclassing etc. sound like a good idea to me! —MisterSynergy (talk) 13:20, 11 December 2016 (UTC)

Finding Wikidata IDs for a list of organisations

I have a spreadsheet, with two columns: column A has the names of organisations, column B the URLs of their websites. What's the easiest way to get the relevant Wikidata IDs (if any - most should have them) in column C, and Wikidata labels, in English, labels in column D? Will Google Sheets do it? How? Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 19:29, 10 December 2016 (UTC)

Solved it, using Google Sheets, with the 'Wikipedia and Wikidata Tools' add-on. The formula is =WIKIDATAQID(XXX), where "XXX" is the cell holding the organisation name, which must match a Wikipedia article title exactly. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 21:14, 10 December 2016 (UTC)
Hi Andy - name is not a good discriminator for organizations, you really should be checking at least country and possibly location as well, there are a lot of organizations with the same name in different places. ArthurPSmith (talk) 14:04, 12 December 2016 (UTC)
This was a first pass; they were manually checked afterwards. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 16:26, 12 December 2016 (UTC)
I have a similar question: how can I programmatically access an API to get a (list of) Wikidata URIs for a specified search term? This would be like the functionality the search box offers, only in a machine accessible way. Markus Meyer  – The preceding unsigned comment was added by Hobbit76 (talk • contribs) at 12:52, 18 December 2016‎ (UTC).

Wikidata weekly summary #239

QuickStatements & date of reference

I'm adding statements using QuickStatements. An example line is:

Q978124	P463	Q19861084	S854	""	S813	+2016-12-10T00:00:00Z/11

The P463 and S854 values are added correctly, but that for S813 is missing. Is it me, or can't the tool do this? Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 15:12, 11 December 2016 (UTC)

It has been reported many times now, and has not been fixed yet. -- Innocent bystander (talk) 15:19, 11 December 2016 (UTC)
Thanks. I had a vague recollection, and did search here, but found nothing. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 16:07, 11 December 2016 (UTC)
@Pigsonthewing: If you try the new version, it already works there (per what Magnus said on Twitter). Matěj Suchánek (talk) 13:37, 12 December 2016 (UTC)
This section was archived on a request by: XXXXX Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 17:39, 18 December 2016 (UTC)

Extracting Q IDs from random text

Is there a tool which takes load of random text - say, several lines like:

(diff | hist) . . Alice Moderno (Q16488592)‎; 21:46 . . (+444)‎ . . Example1 (talk | contribs)‎ (‎Added reference to claim: place of birth (P19): Paris (Q90)) (Tag: reCh [1.1])
(diff | hist) . . (Q27994566)‎; 21:46 . . (+355)‎ . . Example2 (talk | contribs)‎ (‎Created claim: Commons category (P373): Towers_in_Vasto, #quickstatements) (Tag: Widar [1.4])

- and extract from it just the QIDs? Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 21:49, 11 December 2016 (UTC)

I use the freeware PSPAD editor for such task, using the regular expression tool to remove all unwanted text, thus stripping all except Qxxxx strings. Michiel1972 (talk) 22:07, 11 December 2016 (UTC)
@Michiel1972: Thank you. Could you share your regex, please? Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 23:07, 11 December 2016 (UTC)
Q[\d]+ will select the Q numbers, I think. Ah, But you need the inverse. --Tagishsimon (talk) 13:02, 12 December 2016 (UTC) hth --Tagishsimon (talk) 13:01, 12 December 2016 (UTC)
In Pspad, paste the text, then open replace dialogue. Checkbox regular expressions set to yes, and paste this as 'Find': ^(.*?)\(Q(\d*?)\)(.*?)$ and 'Replace': Q$2 Michiel1972 (talk) 21:26, 12 December 2016 (UTC)
Thank you. I already have Notepad++ (Q2033) installed, and your regexes work in that, too. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 21:36, 12 December 2016 (UTC)
There is an entity extraction tool called DBpedia Spotlight, which does more or less what you want. There was an online demo, but I don't know if it is still working.--Micru (talk) 12:49, 12 December 2016 (UTC)
I usually use in "list" mode (regex=^.+?(Q\d+).+, flags=gm, list=$1\n) and to remove duplicates. --Lockal (talk) 11:59, 13 December 2016 (UTC)
This section was archived on a request by: XXXXX Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 17:39, 18 December 2016 (UTC)

FCI dog breed number

I was thinking it could make sense to add a dog breeds FCI number to wikidata but I'm not quite sure what would be the best way to go about doing that. TommyG (talk) 16:43, 12 December 2016 (UTC)

@TommyG: You can use catalog code (P528) with a catalog (P972) qualifier, like this. If there will be sufficient breeds to warrant it, I'll put a property proposal together for you; but as they only seem to recognise 332 (plus 11 provisionally), I doubt it. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 18:36, 12 December 2016 (UTC)
@TommyG: I'm preparing a dataset to upload those now. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 19:05, 12 December 2016 (UTC)
@TommyG: All done; please check a random sample. Note that Pyrenean Shepherd (Q37786), for example, has two values, and may require splitting. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 20:45, 12 December 2016 (UTC)
Thanks, looks correct from a random selection of breeds I've checked. I wanted to try to use it for this, but it turns out the file naming of the source wasn't nearly as consistent as I first thought. I'll just settle for displaying the FCI # in the infobox for now. :-) TommyG (talk) 21:42, 12 December 2016 (UTC)
This section was archived on a request by: XXXXX Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 17:39, 18 December 2016 (UTC)

Redirecting from Wikidata items to sister projects

Hello everybody! Is there a tool which redirects you from a Wikidata item to a specific language wiki link enwiki? For example, how would I generate a link from Ward W. Briggs (Q2549066) to w:en:Ward W. Briggs?

Many thanks in advance! Jonathan Groß (talk) 10:48, 13 December 2016 (UTC)

Special:GoToLinkedPage :) --Lydia Pintscher (WMDE) (talk) 10:55, 13 December 2016 (UTC)
@Lydia Pintscher (WMDE): Thank you. How does that translate into a wikilink? Jonathan Groß (talk) 11:03, 13 December 2016 (UTC)
Ah, got it: Special:GoToLinkedPage/enwiki/Q2549066. Thanks again. Jonathan Groß (talk) 11:07, 13 December 2016 (UTC)
This section was archived on a request by: XXXXX Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 17:40, 18 December 2016 (UTC)

Julian/Gregorian calendar in the UI

Can I get an update on Julian/Gregorian calendar issues please - did the underlying data model and/or the UI change once again?

I just visited a past discussion from Sep 2014 and checked my corrections made to Julian dates. Most of these entries are now misconverted by the infobox templates on the Russian wiki, though they used to show correct Old Style (Julian) and New Style (Gregorian) dates.

So right now, if I enter a date and mark it as having a Julian calendar in the UI, is this truely a Julian date - and not just a tag to a Gregorian date that says "show both Julian and Gregorian dates", as it used to be in 2014?

And what the hell is Q26932615 "statement with mainsnak date marked as Julian that is more precise than 1 year"?

--DmitryKo (talk) 23:34, 17 December 2016 (UTC)

Ah, never mind, found the explanation: Wikidata:Project chat/Archive/2015/07#calendar model screwup.
So, quite a few posts here assumed that calendar model and the UI are seriously flawed, that bots are mistreating Julian dates and that calendar conversion is broken, but it still took a year to actually recognize these flaws and another year to fix the code? Oh well... --DmitryKo (talk) 00:30, 18 December 2016 (UTC)
And you know what? The UI for calendar conversion is still broken.
Assume I want to correct a Julian date that was entered using the previous data model ("dates are always in proleptic Gregorian, and "Julian" only controls the display". If I just roll the date 10 days back, the calendar mode automatically changes to Gregorian without any warning. When I click "Change to Julian", it doesn't really change the calendar mode stored with the data - it only sets the "Set manually" option and changes the item in te list of the available calendars! If you save your edit right now, it would be Julian day and month stored as a Grigorian date. You need to make one more step by actually entering something in the edit field - then the calendar mode does really change, and "Change to Julian/Gregorian" link starts working too.
If I click "Calendar" - "Set manually" before I actually make changes to the date, then existing calendar mode is respected and calendar conversion does work too. But how am I supposed to know this? The date is already entered in Julian calendar - my expectation is that existing calendar mode would not automatically change when I make edits. Gregorian calendar was only adopted in 1917 for Russia - why the UI needs to force the Gregorian calendar on me then require non-obvious extra steps to change it back to Julian?
Nah, it's too much hassle for fixing the problem than I didn't create. --DmitryKo (talk) 01:46, 18 December 2016 (UTC)
If we only fixed problems that we ourselves created, then Wikidata would still be nothing but an undeveloped concept. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 17:34, 18 December 2016 (UTC)
This section was archived on a request by:
--- Jura 08:12, 18 December 2016 (UTC)


hello  – The preceding unsigned comment was added by Nicheze (talk • contribs) at 02:54, 18 December 2016‎ (UTC).

@Nicheze: Hi. —Justin (koavf)TCM 03:02, 18 December 2016 (UTC)
This section was archived on a request by: XXXXX Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 17:40, 18 December 2016 (UTC)

What government data is of best interest?


I am currently at the OGP Hackathon and I've been asked: "There is a government in Central Europe that may have the possibility to publish government data to Wikidata, and the budget to do it (either by publishing a dump for us to reuse or even directly maintain it up to date on Wikidata through the API), which data do you think would be the most interesting or useful?". I told him I would ask the community so, here I am :) What is your opinion on this? If you had 5 wishes, what would they be? -Ash Crow (talk) 17:21, 8 December 2016 (UTC)

Hi, thanks for posting this; I'll make sure that a summary of the answers also gets transmitted to the OGD/LOD people at the Swiss government. --Beat Estermann (talk) 08:16, 13 December 2016 (UTC)
  • Hi @Ash Crow:: Well, just some (personal) suggestions:
  • (1) basic geographic name data (location of places, sites of interest, etc; if we don't have it yet). Solid local references (other than "Geonames") to any existing ones would be good as well.
  • (2) country or culture specific library catalog metadata,
  • (3) basic data on elected or high ranking public officials,
  • (4) statistics: population statistics on any location (present or historic), a dataset like Q21644845 ;). Eventually we should be able to absorbe more statistics, but this might need more development. In some parts Wikipedia includes lots of these and eventually we should be able to provide this from Wikidata
  • (5) anything country specific WikiProject Movies lacks ;)
At first sight it might appear obscure, but I think well-maintained datasets like the Czech notable tree dataset can be of great interest.
Things that need updates on a more regular basis than every year might need some additional thought on how to go about that.
--- Jura 17:52, 8 December 2016 (UTC)
  • All data about adminsitrative divisions (population, altitude, surface,...) and historic and current data about economy (debt, GDP,...) but calculated according to an international standard. At least Snipre (talk) 21:50, 8 December 2016 (UTC)
  • Statistic, geographic and cultural data. Just an answer a question: all this data will be under Creative Commons CC0 ? --ValterVB (talk) 08:48, 9 December 2016 (UTC)
He said it would not be a problem. -Ash Crow (talk) 09:23, 9 December 2016 (UTC)
  • General wishs:
(1) Switch the general default for database license of government data from requiring citations of the data source to not requiring citation, so that Wikidata can import more data ::without licensing issues.
(2) Generally make sure that databases uses their own ID to refer to items instead of simply using strings.
(3) If there's money for the project, I think it would make a lot of sense if they don't just publish a dumb but directly submit the data to Wikidata.
  • Specific wishes:
(1) Historic population. That data is valuable for Wikipedia importing Wikidata data.
(2) Historical data about life expectancy. If you be really nice if this data would be available at a highly granular level that more detailed than just the country level.
(3) The European patent database - Names of patents, area of the patent, links to inventors and companies, direct link via an ID to the full patent on the official website.
(4) The European trademark database - Names of patents, area of the patent, links to the trademark owners, direct link via an ID to the full patent on the official website.
(5) Registers of lobbyists in Brussels and the individual EU states. Including links to the bills for which the lobbyists lobbied if such data is available.
ChristianKl (talk) 22:20, 9 December 2016 (UTC)
  • Hi @Ash Crow: Five example-oriented wishes:
(1) All (former) heads of governments
(2) All population data from the very beginning of the country to the latest
(3) All universities in that country
(4) All ministries (and ministers) of that country (perhaps organized as a cabinet)
(5) All geographical divisions of that country
The idea is that I'd expect high quality data since the data comes from the very authoritative source ;-) Fadirra (talk) 15:01, 12 December 2016 (UTC)

LUA and the #coordinates-parser

Anybody here who has had experience with Scribunto and the #Coordinates-parser? -- Innocent bystander (talk) 04:11, 12 December 2016 (UTC)

Isn't it better to tell your problem directly? (And yes, I do.) Matěj Suchánek (talk) 13:35, 12 December 2016 (UTC)
Thanks Matěj, I try to make our local version of Module:Wikidata support coordinates at svwiki. You can find it at sv:Modul:Wikidata2. A sandbox-version can be found at sv:Modul:Sandlådan/Innocent bystander/WD, where you can play around without breaking any article. -- Innocent bystander (talk) 12:32, 13 December 2016 (UTC)
Made some improvements, come back if it could be better. Matěj Suchánek (talk) 13:36, 13 December 2016 (UTC)

Issue with property creation

Both of:

have been closed as "no support". There are no objections and - as I noted in each proposal - the IDs are in use on en.Wikipedia, in over a thousand articles for each. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 17:46, 12 December 2016 (UTC)

  • There are no explicit objections but many queries about this being duplicative; there are also no statements of support, so "no support" seems quite accurate to me. ArthurPSmith (talk) 14:07, 13 December 2016 (UTC)
    • The properties are not duplicative; either of each other nor any other property. Indeed, during the discussions I said "They are used in different Wikipedia templates. They are described differently on the [Library of Congress] website. A structure can have both types of ID, which will have different values."; this was not rebutted. As proponent, I obviously support the creation of the properties. There is no policy requiring a quantitative level of support. Indeed, I said during one of the discussions "There is no quantitative requirement for support for property creation; please feel free to cite a policy or RfC if you believe such a requirement exists" and no response was forthcoming. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 16:59, 13 December 2016 (UTC)

Merge please

Help:Merge says that it's a proposal that's not been finalised, so I don't know whether I should follow its suggestions.

Please merge Q19841468 and Q8078936. One has the Dutch Wikipedia's article about a place in Iceland, together with a Commons-hosted picture of the place, while the other has the English and Icelandic Wikipedias' articles about the same place. Aside from the shared name, the English and Dutch articles even use the same image. Nyttend (talk) 01:09, 13 December 2016 (UTC)

@Nyttend:, done. MechQuester (talk) 03:17, 13 December 2016 (UTC)
oh and its in preferences. Go to preferences, gadgets, and its the 1st item. MechQuester (talk) 03:18, 13 December 2016 (UTC)

Batch data ingestion: how to's, guidelines, case reports


I'm presently testing, reviewing, and further developing guidelines in view of the batch ingestion of data into Wikidata. So far, I am aware of the work of Spinster and John Cummings (Wikidata:Data_Import_Guide) in this area. I've started to list case reports and links to instructions on WikiProject Cultural Heritage. My next step will consist in writing guidelines in view of the large-scale ingestion of data about heritage institutions, with the intention, of course, to improve guidelines at a more abstract level in the longer run in order to support all kinds of batch data ingestion.

Thus, I would be thankful to anyone who can point me to previous work in this area: Are there any further how to's, guidelines, or case reports regarding batch ingestion of data into Wikidata?

In a similar vein, if you could point me to any how to's or case reports regarding the use of Wikidata on Wikipedia (e.g. in infoboxes or lists) that would be useful as well in order to guide further activities in this area. E.g. in what areas is the use of Wikidata data in Infoboxes most advanced across different language versions of Wikipedia?

--Beat Estermann (talk) 08:34, 13 December 2016 (UTC)

What is missing in the current documentation is the use of help:sources as reference policy in order to create an uniform reference system (help:sources is not managing all possible cases and improvements has to be done in order to simplify the rules but a common system is necessary to provide an unique way to extract data). Then I would like to see a section about data preprocessing in order to avoid constraint violations. Before any huge importation a data comparison should be done with existing data in WD in order to detect constraint violation before the importation.
When data importation can add thousands of new statements in some hours, we should not assume that manual curation of data is the solution to clean duplicates or wrong match between items and new data. Snipre (talk) 10:14, 13 December 2016 (UTC)
@Snipre: What exactly needs to be improved on the Help:Sources page in your view? And could you elaborate a bit more about the aspect of constraint violations? I'm not sure whether I grasp that entirely. - Today, I've written some instructions for the preparation in view of batch data ingestion about heritage institutions. Please have a look. Is there anything that needs to be improved? - I was wondering whether we should standardize the way source databases / datasets are described on Wikidata. Maybe starting with the information contained in the overview table I created. If we want to move in the direction of semi-automatized data ingestion from external sources (e.g. ensuring regular updates), a standardized way for describing data sources would be helpful. - Has there any work be done in this direction? --Beat Estermann (talk) 18:00, 13 December 2016 (UTC)

Mirit/Desa Mirit

I have the suspicion that Mirit (Q10994291) and no label (Q25116070) refer to the same location, as "desa" means village in Indonesian. Could someone confirm? --Micru (talk) 11:29, 13 December 2016 (UTC)

Stats on quantities

Propertyas statement
as qualifieras referenceTotal
Elo rating (P1087)10283511028351
number of points/goals/set scored (P1351)272627547627819
number of matches played (P1350)2976232554623556
population (P1082)47438913474393
elevation above sea level (P2044)384756425385181
ranking (P1352)38691321272135998
mass (P2067)184567171184585
height (P2048)9492446294972
area (P2046)80981480985
length (P2043)5736157157932
all other3187417414536392922

Addshore compiled some nice stats about uses of quantity properties (see Phab:T152615). Above the list of the top 10.
--- Jura 13:47, 13 December 2016 (UTC)

Conversion to external-id

Should ISOCAT id (P2263) be converted to an external ID? --Azertus (talk) 15:48, 18 December 2016 (UTC)

It has a formatter URL, so yes. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 17:32, 18 December 2016 (UTC)
This section was archived on a request by: The request was moved along to Wikidata:Administrators' noticeboard#Conversion to external-id. --Azertus (talk) 19:12, 19 December 2016 (UTC)

Is there a way to use the WikiData object description in a template?

Hi guys, I'm wondering of there's a way to use the WikiData object description in a wikipedia template. We have infobox for persons, and I would like the description to be automatically used, just like when using a properties values with syntax like this: {{#property:P569}}. --StanProg (talk) 13:03, 13 December 2016 (UTC)

This is possible with Module:Wikidata (Q12069631); syntax: {{#invoke:Wikidata|descriptionIn|en}} (in which en stands for English description – you can choose any other available language as well). —MisterSynergy (talk) 13:20, 13 December 2016 (UTC)
Please be careful with using the description. It sometimes contains sensitive attributions such as assumed religious affiliation or ethnicity that may not be appropriate for the subject unless properly sourced. --RexxS (talk) 18:32, 13 December 2016 (UTC)
The WikiData description is also used in the mobile app, alongside with the search resutls. Edoderoo (talk) 07:44, 14 December 2016 (UTC)

New way to edit wikitext

James Forrester (Product Manager, Editing department, Wikimedia Foundation) --19:32, 14 December 2016 (UTC)

No and unknown value in QuickStatements (Q20084080)

Does anyone know if QuickStatements has a syntax for adding no value or unknown value claims? --Azertus (talk) 16:39, 10 December 2016 (UTC)

The author of that tool is User:Magnus_Manske. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 17:58, 10 December 2016 (UTC)
I know. I bet he'd appreciate it when users don't come running to him with every first question they can think of. --Azertus (talk) 19:50, 10 December 2016 (UTC)
You're welcome. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 17:36, 18 December 2016 (UTC)
The old version did not have this functionality; Magnus has put out a first draft of a new version in the past couple of weeks (see User:Magnus Manske/quick statements2) which still doesn't support it, I think, but now is a good time to ask :-) Andrew Gray (talk) 18:50, 10 December 2016 (UTC)
Thanks, maybe I will! But would you/others find this useful as well? I've (obviously) found a use for it, but I couldn't say I'd be creating thousands (let alone hundreds) of edits with it as soon as that functionality were to be added. --Azertus (talk) 19:50, 10 December 2016 (UTC)
I will likely have some time to invest into that tool rewrite over the weekend. I'll keep this in mind :-) --Magnus Manske (talk) 14:51, 15 December 2016 (UTC)

Symbol definitions with math datatype

I've posted this question here but maybe it should be announced wider. I don't think that laws and mathematical objects consist of (Property:527) some parametres. It's trigon which consists of hypotenuse (Q104962) and pair of cathetus (Q110812)'s, not Pythagorean theorem (Q11518). The symbols refer to formula which consists not only of the expression but also of the definitions. (Also, there are drawings (image (P18)) with some symbols, which maybe require definition too). The definitions must be put somehow into the qualifiers or formula datatype itself, but I can't imagine what the data structure for it should be. At least, as a temporal solution we should invent something other than Property:P527 to bolt onto Property:P2534. Ignatus (talk) 22:54, 10 December 2016 (UTC)

@Ignatus: I was hoping for the new datatype to provide some way to link these but found it doesn't really help. Maybe a better way to link Q35875#P2534 to the statements at Q35875#P527 can be found (currently has part (P527) with qualifier defining formula (P2534) which seems a misuse of that property). It would probably be an enumeration with the same values, but with different properties/qualifiers. Adding all as qualifiers on Q35875#P2534 wont work, as we can't have qualifiers on qualifiers.
--- Jura 10:27, 12 December 2016 (UTC)
We need defining formula (P2534) + has part (P527) (P2534 with links to items). Who can help to do this? --Fractaler (talk) 11:05, 12 December 2016 (UTC)
Currently, I don't think we can do much better than Q35875#P527 except by using two new dedicated properties.
--- Jura 11:56, 12 December 2016 (UTC)
Development team can help? --Fractaler (talk) 08:04, 13 December 2016 (UTC)
We can make some extra math-type property like "Related symbols" with such qualifiers as "relates to" (item, e.g. catet), "described parameter" (property, e.g. length), "symbolic tradition" (item for different schools related to different corresponding values of P2541) etc., but I don't believe we'll have a universal way to make a good legend from all this without multilingual text descriptions at least. Ignatus (talk) 07:54, 16 December 2016 (UTC)
@Ignatus: Of course there is, this is maths :) If we can't do this for maths, we can't for anything else. We could do stuffs as we do in computing: with operations and functions, domain and range, etc. author  TomT0m / talk page 09:01, 18 December 2016 (UTC)
Also need: cathetus (Q110812) < hypotenuse (Q104962). But bot can calculate, that (cathetus (Q110812)+cathetus (Q110812)) > hypotenuse (Q104962) --Fractaler (talk) 14:45, 16 December 2016 (UTC)

Two foot and 600 mm gauge (Q18980194) vs. 600 mm track gauge (Q10676739)

Multichill (talk) Thryduulf (talk) 21:38, 2 November 2013 (UTC) -revi (talkcontribslogs)-- 01:13, 3 November 2013 (UTC) (was Hym411) User:JarrahTree (talk) 06:32, 3 November 2013 (UTC) A.Bernhard (talk) 08:28, 9 November 2013 (UTC) Micru (talk) 12:36, 9 November 2013 (UTC) Steenth (talk) YLSS (talk) 13:59, 25 November 2013 (UTC) Konggaru (talk) 12:31, 14 December 2013 (UTC) Elmarbu (talk) 21:48, 17 December 2013 (UTC) Nitrolinken (talk) 16:30, 14 February 2014 (UTC) George23820 Talk‎ 17:39, 17 August 2014 (UTC) Daniele.Brundu (talk) 21:34, 30 August 2015 (UTC) Dannebrog Spy (talk) 16:13, 9 December 2015 (UTC) Knoxhale 18:39, 26 June 2016 (UTC) happy5214 22:48, 8 July 2016 (UTC) Jklamo (talk) 07:32, 15 August 2016 (UTC) Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits DarTar (talk) 16:36, 5 September 2016 (UTC) Pizza1016 (talk | contribs) 01:33, 10 November 2016 (UTC) Sascha GPD (talk) 23:00, 1 February 2017 (UTC) Liuxinyu970226 (talk) 09:09, 2 February 2017 (UTC) A1AA1A (talk) 18:17, 21 May 2017 (UTC) Mauricio V. Genta (talk) 13:56, 9 June 2017 (UTC) Sam Wilson 10:26, 18 June 2017 (UTC) Danielt998 (talk) 05:01, 28 August 2017 (UTC) Maxim75 (talk) 06:04, 22 September 2017 (UTC) NCFriend (talk) 12:29, 2 August 2017 (UTC) Fabio Bettani (talk) 17:48, 3 June 2018 (UTC) Pictogram voting comment.svg Notified participants of WikiProject Railways

Is there any reason that both can't be merged? --Liuxinyu970226 (talk) 14:39, 17 December 2016 (UTC)

These are two separate, albeit very similar, gauges, and therefore these gauges should have different items. I would actually either re-purpose the 2 ft/600 mm item as only a 2 ft item, or delete it entirely and create a new 2 ft gauge item. 2 ft = 609.6 mm ≠ 600 mm. FWIW, enwiki covers both gauges with one article, which may be the reason for the current setup. -happy5214 20:27, 17 December 2016 (UTC)

Kurdish Traduction

Hello, Someone could take a look here. Thanks in advance!--Ghybu (talk) 17:59, 18 December 2016 (UTC)

Best way to link an item (e.g. manuscript) to a register/list of historically significant items

I need to add statements to items in the Memory of the World Register (e.g. Diary of Anne Frank (Q6911) ) to indicate that they appear on the register.

The only related properties seem to be those listed below, but none of them would be correct uses:

Does anyone know of a property which would be more appropriate to use?

If not, should we create a new property for this? or modify the scope of one of the above properties to allow it to include this type of use?

I would vote for expanding the scope of heritage designation (P1435), as many of the possible values are effectively registers/list (e.g. listed buildings in the UK).

This will come up several more times just in the data I'm helping to import from UNESCO, so I'm sure it will apply to lots more similar lists & registers. Many thanks NavinoEvans (talk) 14:17, 18 December 2016 (UTC)

That sounds like a good generic approach that works well in a lot of circumstances. However, the Memory of the World Register doesn't yet have any decent ID or code to use, and the 'names' of the items according the UNESCO data are quite inconsistent (can include bits of description, or different languages in brackets) - so probably not a good idea for this data set.
Once UNESCO have their own ID system, I completely agree this would be better with it's own property.
Even when there is an ID property though, I think we also need something like heritage designation (P1435) = Memory of the World Register (Q16024238) (or similar). This is how it is for World Heritage Sites and Listed buildings for example. It also is a more logical statement to put the start and end time qualifiers showing the period is was on the register. NavinoEvans (talk) 00:08, 19 December 2016 (UTC)
OK, I agree. Do you think expanding is better, or a new one, considering also intangible cultural heritage status (P3259) exists? For the sake of consistency, it deserves it's own and can be expanded with the unique ID later. – Susanna Ånäs (Susannaanas) (talk) 16:20, 19 December 2016 (UTC)

Merge Q13548416 to Q394431

I don't know my way around Wikidata too well, so I'm reluctant to try to do this myself for fear of breaking something, but Q13548416 (two entries, later-created, in June 2013) should be merged to Q394431 (seventeen entries, earlier-created in December 2012). Both data sets deal with articles on the given name Agnes (English). The two articles in Q13548416 are the Czech (Anežka) and Slovak (Anežka) counterparts. TJRC (talk) 20:39, 18 December 2016 (UTC)

It looks like those two are separate things, even if they're talking about different language versions of the same last name. They are linked to each-other through the "aka" property; see the other similar items linked through that property. -- Ajraddatz (talk) 20:43, 18 December 2016 (UTC)

2017 source edit

Im seeing those kind of tags. What are they? MechQuester (talk) 01:10, 19 December 2016 (UTC)

The answer may be here (source). - Kareyac (talk) 07:01, 19 December 2016 (UTC)

Wikidata weekly summary #240

Citoid script

"autofill" link, for reference with PubMed ID

I have created a user script for editing references that can automatically populate parts of the reference using the citoid api if a reference contains reference URL (P854), PubMed ID (P698) or DOI (P356). If (and only if) one of those properties is present, an "autofill" link is added next to the "remove" link/button.

Currently, it can only add the reference title, publication date and retrieved date. I am working on adding support for publisher / published in and other parts of the reference (not sure yet how to handle author). At this point, perhaps the script is already useful and welcome people to try / give feedback / report issues either here or User talk:Aude/citoid.js.

To try the script, add importScript('User:Aude/citoid.js'); to your common.js (e.g. like what I have in User:Aude/common.js) Aude (talk) 03:32, 19 December 2016 (UTC)

Not to detract from the good work done on this, but I'm confused. If we have a PID for the ref, why would we add other metadata, which can be fetched programmatically by anyone who wants it? And if such metadata is needed, why not have a bot fetch it? Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 11:56, 19 December 2016 (UTC)
I'm also not understanding the use case for this. My understanding is that the way of using journal articles in references is to create an item for the journal article and reference it with stated in (P248). The PubMed ID (P698) should be on the item for the article. Gstupp (talk) 17:29, 19 December 2016 (UTC)
Thanks for the feedback. I have removed support for PubMed ID for now. Need to think about supporting a different workflow for journal citations. (searching for existing item / creating new item) Aude (talk) 04:20, 21 December 2016 (UTC)
Hi Aude, are you aware of the activities of Wikidata:WikiProject Source MetaData? --Succu (talk) 21:33, 19 December 2016 (UTC)
I am somewhat aware of the wikiproject. Looks like a good place to ask questions about how to handle different types of citations. Aude (talk) 04:24, 21 December 2016 (UTC)

Interesting! Gotta try that. --Atlasowa (talk) 21:55, 19 December 2016 (UTC)

Atlasowa, mind to try that for An updated classification for Apocynaceae (Q19004382)? --Succu (talk) 22:15, 19 December 2016 (UTC)
Hm, [2] looks strange... --Atlasowa (talk) 21:49, 20 December 2016 (UTC)
For me it looks like that Crossref (Q5188229) is not very reliable to be used that way. You'll find all kinds of oddities: HTML code in titles, uppercase authors, missing endpages... --Succu (talk) 22:01, 20 December 2016 (UTC)

Parser function Statements enabled

Hello all,

As previously announced during the birthday, a new feature, {{#statements:…}} and the related LUA functions, have been enabled on Wikidata and all other wikis.

You can see the differences between the previous function (property, which will stay usable) and statements on this page. Feel free to test it and provide feedbacks on the related ticket. Lea Lacroix (WMDE) (talk) 14:53, 19 December 2016 (UTC)

Thanks, very interesting! A proper description/help page including more details about its functionality would be valuable. This example page is not enough for me, to be honest. —MisterSynergy (talk) 15:24, 19 December 2016 (UTC)
OMG! That page links to a separate version of Wikidata WITH different properties. You are just going to confuse all but the most talented. Took me ages to work out the issue.  — billinghurst sDrewth 03:28, 21 December 2016 (UTC)

Thanks for your feedbacks. We're working on the documentation. Lea Lacroix (WMDE) (talk) 08:20, 21 December 2016 (UTC)

Wikidata <-> Wikipedia + local spam blacklists

The last comment (about spam blacklist). If it's really true, then do we have something in mind for this? --Edgars2007 (talk) 08:09, 20 December 2016 (UTC)

There are enough learned wikipeople with credentials at enWP and here looking at the issue. I trust them to escalate the matter if it is problematic.  — billinghurst sDrewth 14:54, 20 December 2016 (UTC)
don't know why you would want to import the en-wiki-drama here. they have been known to have to go to RfC to un-blacklist an archive site. Slowking4 (talk) 02:20, 21 December 2016 (UTC)
@Slowking, maybe I read it in a different way. The "official" template pulls WD data, and that WD data hits their blacklist in a secondary edit meaning that the page cannot be further edited. The easy solution for enWP is to revert the template and use manual data. It needs a fix, and it needs to be easy and sustainable, so it is quite pertinent for the wiki to know and to assist with solutions. In this case the people involved in that discussion all have advanced rights and good knowledge and I trust them to reach a sensible conclusion. So I don't see it as importing enWP drama.  — billinghurst sDrewth 03:59, 21 December 2016 (UTC)
yes, let them manage their blacklist. but we differ about the trust. given this history [3] Slowking4 (talk) 13:59, 21 December 2016 (UTC)

Help pages

Heading trimmed from "Lack of implementation of help pages; so the implementation at sites is left to limited set of experts "

I truly cherish this project and the potential for it, and how it supports my work at my main project of English Wikisource. That said, it gives me some of the biggest <facepalm> moments.

At this point of time there has been large effort in populating data; and making available a whole lot of tools to power and super power users to pull data. There seems to be little to no effort expended in helping users to implement data pulls at the wikis into articles, especially aimed at the general user, or the simple templater. It seems that things are caught up in the politics of Wikidata whereas the use and usability of Wikidata is stuck at a lower level, just left or forgotten.

We have no evident (or at least readily findable/linked) help on {{#property}} nor the new {{#statements}}. The closest that we have is an example page at a test wiki which is simply linked above, from a phabricator ticket, and an external notice.

For Wikidata it could be said "You have built; they have come". The issue is that the bridges are too high, too slippery; the pipelines are buried and there are no maps to where they lie for Joe WMFer to do his work. Others wander around inside ooing and ahhing, but then walk out into the light not being able to incorporate your vision with their reality.

The site needs clear examples of how to use the #property/#statements. It needs examples of how you would configure their use eg. how #statements that return an image can be formatted.

The site needs some examples of how to utilise Modules: Wikibase / Wikidata, and even looking to positively generate these and version control them, so other sites, especially the smaller sites can easily import/copy them and keep them up-to-date. Also keeping an eye on developments of these modules at the big wikis so features are brought back and a central copy is kept.

The site needs some clear examples with how to update infobox templates. It needs guidance to other sites administrators on how to utilise Wikidata to make their sites shine!

As a reasonably competent user, and maker of templates I simply find it hard. How to pull a label in a language, how to pull a wikilink, how to pull a badge. This sort of thing shouldn't need to be "ask a developer", it should clearly and neatly identified in Help pages here.  — billinghurst sDrewth 03:52, 21 December 2016 (UTC)

Agree, are you also offering to help out or is it time to create {{Sofixit}}? ;-)
@Multichill: I believe that I try to be a helpful PITA. For the bits that I can contribute, that I will, though those bits are probably "nanna-help". It has to be more useful than ... AAAGGH! <Unanswered questions in IRC.> FFS <try again damn damn damn> Please could we do some help pages. At the same time I do do plenty around the wikis, and documenting help is not my most valuable strength.  — billinghurst sDrewth 12:17, 21 December 2016 (UTC)
Documentation tends to be the thing done last or not at all. How to turn this into something actionable? I'm willing to help. Multichill (talk) 10:52, 21 December 2016 (UTC)
I both agree and would be willing to help as well; could a Wikidata:WikiProject Help pages be useful for coordination & discussion? —MisterSynergy (talk) 10:59, 21 December 2016 (UTC)
Yes, though I think that it is more than help pages. It is also a means to propagate knowledge, and to be seen to lead on the use and management of Wikidata-related modules. We should be looking to be centre of excellence in the use of our data.  — billinghurst sDrewth 12:17, 21 December 2016 (UTC)

How to select distinct films with release dates in actors filmography?

I tried this, but it gives me some film more then one time, because it has different release dates in different countries:

SELECT ?itemLabel ?date #(MIN(?date) AS ?mindate)
    ?item wdt:P161 wd:Q193212 .
    ?item wdt:P577 ?date .
    SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}#  GROUP BY ?item

I tried to write


But it did not helped, probably because it takes in account that ?date is distinct.

When I try to use group by aggregation, it gives me "Bad aggregate" error. How to write it properly, so I have distinct films with first release date in filmography? --Bunyk (talk) 00:12, 23 December 2016 (UTC)

Oh, I see, I need to group by ?itemLabel, not ?item.

SELECT ?itemLabel (MAX(?date) AS ?maxdate)
  	?item wdt:P161 wd:Q193212 .
    ?item wdt:P577 ?date .

	SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}  GROUP BY ?itemLabel

Try it!

Sorry for disturbing. --Bunyk (talk) 00:39, 23 December 2016 (UTC)

@Bunyk: generally you might want to use (MIN(YEAR(?date)) as ?released)
--- Jura 09:47, 23 December 2016 (UTC)
This section was archived on a request by: Matěj Suchánek (talk) 14:53, 27 December 2016 (UTC)

Move/rename a page

Citizens Advice (Q5122657) – The organization has been renamed to Citizens Advice. --Senator2029 (talk) 17:01, 26 December 2016 (UTC)

changed --Pasleim (talk) 18:42, 26 December 2016 (UTC)
This section was archived on a request by: Matěj Suchánek (talk) 14:53, 27 December 2016 (UTC)

Left to right codes

Is there no bot to correct wrong input left to right input data in statements (like in Q21705939, statement NUKAT)? Steak (talk) 21:51, 26 December 2016 (UTC)

WD:Bot requests. Matěj Suchánek (talk) 09:30, 27 December 2016 (UTC)
This section was archived on a request by: Matěj Suchánek (talk) 14:53, 27 December 2016 (UTC)

Linked data fragment enabled on the Query Service

Hello all,

The SPARQL endpoint we are running at has several measures in place in order to ensure it stays up and running and available for everyone, for example the 30 sec query timeout. This is necessary but also prevents some useful queries from being run. One way around this is Linked Data Fragments. It allows for some of the query computation to be done on the client-side instead of our server.

We have set this up now for testing and would appreciate your testing and feedback. You can find out more about Linked Data Fragments and documentation for our installation.

Thanks a lot to @Smalyshev (WMF): for working on this great improvement! Lea Lacroix (WMDE) (talk) 11:28, 20 December 2016 (UTC)

Also, you can see a demo of client-side SPARQL evaluation and LDF server usage here: Please not - it's in no way a production service for anything, just a proof-of-concept deployment of LDF client. If you like how it works, you can get it from the source and deploy it on your own setup. I'll be glad to help with any questions. --Smalyshev (WMF) (talk) 19:52, 20 December 2016 (UTC)
Good job Stas!
I'm afraid saying that something is not production and a proof-of-concept falls on deaf ears in the wiki universe. If it's out there, people will use it. Multichill (talk) 10:58, 21 December 2016 (UTC)
Well, I just want people to be aware it's a demo, and in a random moment in the future it may be shut down. Unless somebody finds a lot of value in it and makes a case for setting it up in labs as a permanent fixture (right now it's kind of hacked together). It probably will never be in production, and it's not intended to be SPARQL service, rather than a demo showing off "that's what you can do", but we'll see what happens :) --Smalyshev (WMF) (talk) 18:58, 21 December 2016 (UTC)

How to describe that Q184535 is the insparation of the book Q760771

In the Acknowledgement of the book Q760771 Too much happiness Alice Munro writes about how she discovered Q184535 Sophia Kovalevsky. She tells us that she

I am right now adding locations of graves to a cemetery and would like that the Wikidata object for Q184535 Sophia Kovalevsky should have a property that connects her to the book Q760771 Too much happiness Question what properties should be set - Salgo60 (talk) 03:57, 22 December 2016 (UTC)

There are the properties "inspire by" and "notable work".
--- Jura 05:49, 22 December 2016 (UTC)

Germany National Football Team (Q43310)

Hello. In 1974 FIFA World Cup (Q166121) the winner (P1346) is Germany National Football Team (Q43310). But the name of the national team that period was West Germany national team. Not just Germany. Is there a way to show that? Xaris333 (talk) 21:26, 20 December 2016 (UTC)

I would think that you would need to create an new item for it, and set that item to be a predecessor of existing team. Then make the changes to reflect the new items.  — billinghurst sDrewth 03:54, 21 December 2016 (UTC)

That is not helpful. I use templates that fetch data from wikidata. If I had an item called West Germany national team, would not linked to the artile that I want (Germany national team). Xaris333 (talk) 10:32, 21 December 2016 (UTC)

Germany didn't exist as a country back then, and as such it would be wrong to use Germany national team.--Micru (talk) 11:18, 21 December 2016 (UTC)
I agree. But all Wikipedias have only one artile. Xaris333 (talk) 12:37, 21 December 2016 (UTC)
The name always was Deutsche Fußballnationalmannschaft, and the German Football Association (Q154191) was and is the German football association. It was established 1900, and existed since then (only briefly not recognized by the FIFA). Sänger (talk) 17:44, 21 December 2016 (UTC)
So we can't have two items. Xaris333 (talk) 12:01, 22 December 2016 (UTC)

Problems with the capital property

A discussion on the English Wikipedia on a list provincial capitals in Thailand (w:en:Talk:Provinces_of_Thailand#Province_capitals) made me notice that the recent bot-imported statements are somewhat misleading.

The English description of capital (P36) states location [..] of governmental seat of the [..] administrative territorial entity, whereas the German description translates to "most representative city, not necessarily seat of administration". There are three different kinds of capitals - de jure, representative city and seat of administration which thus all get intermixed in this property. In Thailand there is no de jure capital for any of the provinces, the city with same name as province is usually the most representative city (though not necessarily the largest), but recently in several provinces the administration was moved outside the town and thus into a different municipality. And to make things worse - Thailand has local administrative units (municipality and similar), but also there are also central administrative divisions at the same level as the local one, often even having the same boundaries. To give a concrete example:

Using no label (P794) as qualifier with administrative centre (Q1306755) or capital (Q5119) could be used to separate the two different meanings of capital, though that still doesn't encode the fact that its not a de jure capital. If using the local government for capital (P36), the subdistrict could be added with qualifier located in the administrative territorial entity (P131) to avoid listing more than one seat of administration valid at the same time. Any comments? Ahoerstemeier (talk) 12:03, 21 December 2016 (UTC)

I'm from Netherlands (Q55) and the capital (P36) is Amsterdam (Q727), the seat of goverment is in The Hague (Q36600). That seems to be very confusing to a lot of people, but at least is properly documented in the Constitution of the Netherlands (Q2299064).
I would look for sources to support the statements. Maybe the Thai goverment has a website with this information?
Updated the description for capital (P36) in English. Better? The German one is a bit long. Multichill (talk) 12:54, 21 December 2016 (UTC)
As a German, I am well aware of the fact that Netherlands are the AFAIK only country where official capital and seat of administration differ. The way it is used for Netherlands (Q55) would mean that we need another property for the seat of administration? Ahoerstemeier (talk) 13:41, 21 December 2016 (UTC)
South African Republic also have a very complex "capital-structure".
The meaning of "Seat" in legal terms can be very weak. Many Swedish companies have Stockholm as their "seat" (where the General Assembly meets and where the board have its office). But that does not stop organisations to locate their Board and/or the General Assembly in the neighbour municipalities to Stockholm City. -- Innocent bystander (talk) 18:26, 21 December 2016 (UTC)
Problem with the new description: Not all capitals are cities. --Yair rand (talk) 18:02, 22 December 2016 (UTC)

Names overview & vernacular names modelling

Q1: I would like to get an overview of how names are being modelled and where there are gaps. The question is about persons' names as well as place names. Where such overview could be found, or where could such overview be gathered.

Q2: I am trying to write up a description of how vernacular place names would ideally be represented in Wikidata. I have

  • A place
  • A geographic representation of the place (coordinates or an area)
  • A textual representation of a place name in a dialect of a language
  • The same written in the standard language of the dialect
  • Time of collection of the name
  • Other more detailed data would reside in the original repository

Which properties should I use? I think neither native label (P1705) (rules unclear) nor official name (P1448) (not an official name) nor name in native language (P1559) (people only) are suitable. If I understand correctly, native label (P1705) should be used with one value only, and the language qualifiers are restricted to languages. How to add the dialect?

Q3: I am planning to limit modelling to using only one Q-item, even though the source data repository will use unique URIs for the place names. Also, I plan not to get mixed up with with lexemes. What do you think of these choices?

Cheers, Susanna Ånäs (Susannaanas) (talk) 16:07, 14 December 2016 (UTC)

  • Maybe @Thiemo Mättig (WMDE): wants to comment.
    Obviously, I don't think we want exclude languoids that are not native or official at a given place, that are partially identical with Académie française-French, and/or that don't have a word for "MediaWiki Interface". Apparently, there is some preference for these.
    Default choice may be to use name (P2561) with language code "mis" and qualifier P407 to specify the languoid.
    --- Jura 17:07, 14 December 2016 (UTC)

Would you agree with the following, or how would you alter it? I'll transfer it to Wikiproject Historical Place after comments.

Thanks! – Susanna Ånäs (Susannaanas) (talk) 13:29, 18 December 2016 (UTC)

  • It's for a specific building somewhere in Tuusula (Q214773)? Yes, except maybe P580/P582. If the dates are to define when it was built/destroyed, P571/P576 should be used.
    --- Jura 13:48, 18 December 2016 (UTC)
    • I made changes to the example accordingly. I will post another example illustrating the limits that need to be tackled. – Susanna Ånäs (Susannaanas) (talk) 15:00, 18 December 2016 (UTC)
      • For languoids with available (sub-)codes, I think you should do a request to have it added. This even if they are slow and somewhat arbitrary about their creation. Once created, "mis" can be converted. If it's not created, P407 will stay.
        --- Jura 15:10, 18 December 2016 (UTC)

Any suggestions? I run out of levels.

Thanks for your support! – Susanna Ånäs (Susannaanas) (talk) 15:37, 18 December 2016 (UTC)

  • It seems that for Finnish ("fi"), no subtags are currently available. Depending on the scope of your project, you might want to take steps per w:IETF language tag for those to be created.
    --- Jura 18:44, 18 December 2016 (UTC)
    • I think that might be an idea worth investigating! Thanks! – Susanna Ånäs (Susannaanas) (talk) 16:05, 19 December 2016 (UTC)
      • @Susannaanas: Alternatively, you could propose on wd:pp a qualifier "dialect of text" to qualify the monolingual texts.--Micru (talk) 17:04, 19 December 2016 (UTC)
        • I think it would not eliminate the need for the additional qualifier for a qualifier. I am trying to avoid the need of creating an additional item for the name. – Susanna Ånäs (Susannaanas) (talk) 19:35, 19 December 2016 (UTC)
          • Why do you think it's a worthy goal ? author  TomT0m / talk page 14:47, 20 December 2016 (UTC)
            • I'm trying to prove it is possible to model place names without extra items, but I am afraid I am proving myself wrong. I think this would result in a best practise of creating additional items for place names, which would then be a discussion to open. The role of the lexical items should perhaps be considered as part of this. – Susanna Ånäs (Susannaanas) (talk) 07:58, 22 December 2016 (UTC)
              • I think the above should work, but if you are seeking to create separate entities, you might want to wait for the new lexeme entity type. Not quite sure when this will be available for doing full statements though. Maybe 2018?
                --- Jura 12:43, 24 December 2016 (UTC)
There is a version of Finnish available in Meänkieli (Q13357) with the code fit but it mainly apply to Sweden. Also the code fkv exists. I expect fkv to be about Kven (Q165795), but I fail to confirm that. -- Innocent bystander (talk) 11:02, 22 December 2016 (UTC)

Should Commons Creator templates have items?

There is a discussion here where some editors claim that Commons Creator templates should have Wikidata items. In my opinion this is not necessary as we already link them with Commons Creator page (P1472), plus it is not clear that they are notable enough as WD:N states that "If a link is a template, the item must contain at least two such sitelinks". In the hypothetical case that they were considered relevant, there would be a bunch of items that would not contain anything else than a sitelink to the template and a statement linking with the creator. More input appreciated.--Micru (talk) 15:35, 16 December 2016 (UTC)

You forget what these templates are there for; they indicate the creators of files on Commons so they DO link to other things. It is not hypothetical, it makes sense to have all Creator templates based on Wikidata items. Thanks, GerardM (talk) 12:50, 18 December 2016 (UTC)
GerardM, Creator templates are already based on Wikidata items. The problem is how to connect them. You can read more about it on the table that Jarekt has posted on the property proposal page where he outlines the pros/cons of each approach.--Micru (talk) 16:38, 18 December 2016 (UTC)
How many of those templates exist? ChristianKl (talk) 10:09, 24 December 2016 (UTC)

Best player and best young player

Hello. Pls read 2013 FIFA Confederations Cup (Q220231) and the article in English Wikipedia w:2013 FIFA Confederations Cup. I can add in the Wikidata page the top goal scorer with statistical leader (P3279) with qualifier criterion used (P1013) (goal (Q18530)). Is there a way to add the best player of the tournament and the best young player of the tournament? Xaris333 (talk) 21:59, 19 December 2016 (UTC)

@Xaris333: What is the criterion used to determine the "best young player" or the "best player"? Is there a jury? Is it based on statistics? If so, which ones?--Micru (talk) 22:35, 20 December 2016 (UTC)
@Micru: I don't know. Maybe some specialists select the best player. Or is the player who was the man of the match at more matches. See w:2013 FIFA Confederations Cup statistics#Man of the Match. Xaris333 (talk) 22:45, 20 December 2016 (UTC)
@Xaris333: Without knowing more about it, it is hard to propose a method. A possible option could be to use statistical leader (P3279) and then create an item to use with criterion used (P1013), like "man of the match" or whatever criterion they had used.--Micru (talk) 10:23, 21 December 2016 (UTC)
@Micru: Is not clear what are the method. Sometimes are the goals, sometime the hat-trick or to keep a clean sheet under resounding pressure. There are 2 items about that: man of the match (Q1378679) and most valuable player (Q652965). Xaris333 (talk) 10:29, 21 December 2016 (UTC)
If it's awarded, use award received (P166), with qualifiers. If it's calculated, and we have the data, do nothing. If we don't (and won't) have the data needed to calculate it, propose a property. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 11:46, 21 December 2016 (UTC)
award received (P166) is for the a person or organisation item, not for the event. Xaris333 (talk) 12:39, 21 December 2016 (UTC)
Yes; add the details to the person, with a qualifier showing which match/ season it was for. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 20:49, 22 December 2016 (UTC)
@Pigsonthewing: And how that can helps? How someone can find who was the MVP for the event? This information must be on the event item.Xaris333 (talk) 22:40, 22 December 2016 (UTC)
By using queries. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 13:10, 23 December 2016 (UTC)
@Pigsonthewing: So we can have statistical leader (P3279) to an event item but not the MVP player... That is not logical. Xaris333 (talk) 13:58, 23 December 2016 (UTC)
If I use

will be correct? Xaris333 (talk) 14:58, 23 December 2016 (UTC)

Wikidata:Property proposal/Most valuable player Done. Xaris333 (talk) 14:47, 21 December 2016 (UTC)

Data donation of (currently) non-public data

I have an offer of a data donation from an academic project at the University of Oxford. These are presently in a private, offline database: the public site containing the data will be available in Summer 2017. We'd like to share the data before that, so that by the time the site is launched there are already things in Wikipedia/Wikidata built with the data. Is the lack of a public source for the data a problem, and if so, can it be solved by making the CSV file public before the import? Thanks in advance for any help. MartinPoulter (talk) 14:07, 21 December 2016 (UTC)

@MartinPoulter: Do we need a new property? Will the URLs which we may want to give as citations be fixed before the site goes live? Feel free to email me privately, if you don't want to give details in public. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 22:16, 21 December 2016 (UTC)
  • If you would write an academic paper you could refer to a CSV as a data source, so I see no reason why you shouldn't be able to point to it as a source in Wikidata. On the other hand it's worthwhile to think about whether you want to an internal ID in your dataset and maybe propose a relevant property for authority control in Wikidata. ChristianKl (talk) 18:21, 22 December 2016 (UTC)
  • Maybe you could even store the CSV at Commons, now that there is a data namespace there.
    --- Jura 12:41, 24 December 2016 (UTC)

Creating an identifier that has two parts

It would be useful for Wikidata to include, as a location property, the Historic Environment Record (HER), which is an identifer for sites in the British Isles of archaeological or other historic significance. However, HERs work in an unusual way. The counties and districts of the UK maintain their own HER records. For example Maes Knoll Camp (Q6729282) is in district Bath and North East Somerset (Q810793) and has HER number MBN658. Identifying the record requires both the HER number and the county/district. There could be a different site in another county with HER number MBN658. There are 84 authorities issuing HERs just for England.

So one cannot slot the HER number into a URL to get an identifier unless an identifier for the district is also included. For example the full record for Maes Knoll Camp (Q6729282) is at and other records from Bath and North East Somerset can be accessed by inserting the HER into$1, but to get sites in Oxfordshire the template would be$1. A minority of counties do not share their data with, so for example for Wiltshire, although they have HER numbers and an online database, there is no way to fit the HER into a URL.

It seems possible but complicated to have these identifier represented in Wikidata, but I'm not clear on how best to propose this property. I'm hoping it's not necessary to create 85+ different external identifiers of Wiltshire HER, Oxfordshire HER and so on. Thanks in advance for any help, MartinPoulter (talk) 15:04, 21 December 2016 (UTC)

The way we have handled this sort of thing in the past is to put the trailing part of the URL in as the "identifier" - i.e. here it would be the string 'uid=MBN658&resourceID=1036' and the formatter URL would be$1. Definitely not ideal but I think just about our only option for now. ArthurPSmith (talk) 21:27, 21 December 2016 (UTC)
Note one other option would be to contract the identifier in some sensible way (do they have a standard for this already?) such as '1036/MBN658' and then we could update the wikidata externalid url service to redirect to the right spot. I don't like to have too many things dependent on that though... ArthurPSmith (talk) 21:30, 21 December 2016 (UTC)
We should get rid of this kind of pseudo identifiers that are actually only a part of an URL. We should use Data type URL for this kind of external resource. --Succu (talk) 21:41, 21 December 2016 (UTC)
that would work too - could we move the "data type URL" properties into the same box with the external identifiers? ArthurPSmith (talk) 22:12, 21 December 2016 (UTC)
@MartinPoulter: Create an item for each HER, then use catalog code (P528), qualified with catalog (P972), setting the value for the latter to the item for the relevant HER. Use the full URL in reference URL (P854). Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 22:11, 21 December 2016 (UTC)
  • I think the x-id datatype is being worked on again. Maybe an enhancements will allow this. If you could formulate one for the developers?
    --- Jura 11:54, 24 December 2016 (UTC)

Fetch data from wikidata with Template:Infobox football league

Hello. I am trying for a long time to use templates in Wikipedia that fetch data from Wikidata. I really need your help with a template. I am working on Greek Wikipedia but I will use only the English edition of everything to be understandable. I will use as an example Cypriot Second Division (Q2186582) w:Cypriot Second Division.

The template is w:Template:Infobox football league. The most important problems are with parameters:

  • most_champs: Name of the club with the most championships
  • champions: Name of most recent champion
  • season: Years of most recent champion
  • current: a wikilink to the name of the article on the current season
  • first: the first season of the league

And those are the solutions I have found to fetch that data from Wikidata.

< Cypriot Second Division (Q2186582) View with Reasonator View with SQID > winner (P1346) View with SQID < APOP Paphos FC (Q3628068) View with Reasonator View with SQID >
number of wins (P1355) View with SQID < 6 >

That means that APOP had won 6 times the league. A module w:el:Module:ΠερισσότερεςκατακτήσειςΑριθμός (means "mostchampions") check all the items that are listed in winner (P1346), compared their number of wins (P1355) and show the one (or more than one) that have the biggest number of number of wins (P1355). Furthermore, it is show the number of wins of that team in brackets.

< Cypriot Second Division (Q2186582) View with Reasonator View with SQID > has part (P527) View with SQID < 2016–17 Cypriot Second Division (Q24067920) View with Reasonator View with SQID >
edition number (P393) View with SQID < "62" >

That means that 2016–17 Cypriot Second Division is the 62nd edition of the Cypriot Second Division (Q2186582). A module w:el:Module:Τρέχονπρωτάθλημα (means "currentseason") check all the items that are listed in has part (P527), compared their edition number (P393) and show the one that have the biggest number of edition number (P393). (With the same way a module w:el:Module:Πρώτηπερίοδος (means "first season") check all the items that are listed in has part (P527) and show the one that have the number one at edition number (P393). That is parameter first.)

< Cypriot Second Division (Q2186582) View with Reasonator View with SQID > has part (P527) View with SQID < 2015–16 Cypriot Second Division (Q19905070) View with Reasonator View with SQID >
edition number (P393) View with SQID < "61" >
< Cypriot Second Division (Q2186582) View with Reasonator View with SQID > has part (P527) View with SQID < 2016–17 Cypriot Second Division (Q24067920) View with Reasonator View with SQID >
edition number (P393) View with SQID < "62" >

As I said before, in the item of the league I am using winner (P1346) to list all the teams that have win the league. Furthermore, I am using the qualifier victory (P2522) to each team to list all the season they won. For example,

< Cypriot Second Division (Q2186582) View with Reasonator View with SQID > winner (P1346) View with SQID < APOP Paphos FC (Q3628068) View with Reasonator View with SQID >
victory (P2522) View with SQID < 1965–66 Cypriot Second Division (Q23783042) View with Reasonator View with SQID >
< Cypriot Second Division (Q2186582) View with Reasonator View with SQID > winner (P1346) View with SQID < APOP Paphos FC (Q3628068) View with Reasonator View with SQID >
victory (P2522) View with SQID < 1970–71 Cypriot Second Division (Q17605362) View with Reasonator View with SQID >

Then a module w:el:Module:Προηγούμενοςπρωταθλητής (means "lastchampions"): a) check all the items that are listed in has part (P527), compared their edition number (P393) and find the one that have the biggest number - 1 of edition number (P393). b) check all the items that are listed in winner (P1346) and show the one that have as a qualifier with victory (P2522) the season that had found in a). (that is the parameter champion)

I know that most of them are too complicated. They are working but I know that some properties are not using in the right way they are supposed to be used in the items page. I need any ideas how to improved that. In a previous conversation about the list of season someone suggest to have an item with the list of all seasons of a league for example. I am ready to discuss new ideas and to trying to apply them. Xaris333 (talk) 12:41, 22 December 2016 (UTC)

  • Lots of squids in your comment (from claim templates) .. makes it really hard to read. Maybe after Xmas.
    --- Jura 11:50, 24 December 2016 (UTC)

Describe Q4973552 Marion Pritchard

Q4973552 was involved in the helping jews during 2nd WW. I need help how to describe her in Wikidata

Thanks - Salgo60 (talk) 14:51, 23 December 2016 (UTC)

For the interview, database and HM museum links, described at URL (P973) (and/ or use them as citations). Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 10:49, 24 December 2016 (UTC)

Percentage qualifier

Is there a qualifier to use to use the percentage some people or organizations have with the property owned by (P127)? Xaris333 (talk) 21:40, 23 December 2016 (UTC)

applies to part (P518) -> percentage (Q11229)? Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 10:51, 24 December 2016 (UTC)
Q336735#P127. Matěj Suchánek (talk) 11:26, 24 December 2016 (UTC)
proportion (P1107) is certainly the right qualifier, but I don't think we should use it with a "percent" unit. Proportion does not need a unit. If clients want to display "0.65" as a "65%" or as "650 per rmille", that's up to them. Adding "percent" inside the statement is in no way necessary for that and it adds needless complexity to the data structure (which is bad for queries and for maintenance). --Zolo (talk) 13:10, 24 December 2016 (UTC)

Population of towns

Hello, Are there any data dumps on populations of towns in the US? Would be nice to have a bot to fill them in quickly.MechQuester (talk) 00:37, 26 December 2016 (UTC)

Have a look at Wikidata:Requests for permissions/Bot/CensusBot. --LydiaPintscher (talk) 11:46, 26 December 2016 (UTC)


I'm looking for a property that describes the target of a scientific survey - e.g., for Lick–Carnegie Exoplanet Survey (Q6543515) the target would be extrasolar planet (Q44559). We have target (P533), but that seems to be more focused on military targets. Would it be appropriate to use that property anyway, or is there another one that would be better suited (or is this something for a new property proposal)? Thanks. Mike Peel (talk) 08:32, 26 December 2016 (UTC)

Or maybe main subject (P921) would be more appropriate... By the way, if anyone has any suggestions for a property along the lines of "observed with" (e.g., survey observed with a given telescope), that would also be appreciated. Thanks. Mike Peel (talk) 08:53, 26 December 2016 (UTC)
@Mike Peel: P921 would seem best. For "observed with", you could use item operated (P121). Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 10:08, 26 December 2016 (UTC)
Thanks @Pigsonthewing! I'll use those properties, unless anyone disagrees. :-) Thanks. Mike Peel (talk) 12:05, 26 December 2016 (UTC)

Centuries and birth dates

Would anyone be able to help out at date of birth (P569)? See Property talk:P569#Century problems 2. It is intensely frustrating that it is really difficult to work out what pages are allowing specific years and centuries to be added to birth dates. What bit of software is allowing "20. century" and outputting it as 2000s? I can see 'Precision' but not where the century stuff is going on. Surely it should be easier to track things down in Wikidata than this? Carcharoth (talk) 11:37, 26 December 2016 (UTC)

This is a bug in the Listeria tool [4]. @Magnus Manske: Could you have a look at it? --Pasleim (talk) 12:57, 26 December 2016 (UTC)

Wikidata weekly summary #241

Merge should be merged into -- but I'm not up to the task. I fixed the first conflict reported by Special:MergeItems but don't know what to do about the next. --Pjacobi (talk) 19:07, 26 December 2016 (UTC)

 Not done The items link to each other which indicates they shouldn't be merged. → ← Moved the German link to the other item. Matěj Suchánek (talk) 19:19, 26 December 2016 (UTC)

Christmassy Query request

Could we make a query with all the countries, monarchies west of Bethlehem at the year 0CE? Could we also make a query of all the kings who lived at that time? Thanks, GerardM (talk) 08:17, 27 December 2016 (UTC)

@GerardM: Better to ask at WD:RAQ. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 10:17, 27 December 2016 (UTC)

no label (Q19263582)

The en label is shown to me to be "Dangal". When I try to change it to "Nitesh Tiwari" I get the error message "Could not save due to an error. Item Q16908467 already has label "Nitesh Tiwari" associated with language code en, using the same description text." Strange, isn't it? --Jobu0101 (talk) 09:21, 27 December 2016 (UTC)

It's the way it's meant to be. Should the two items be merged?
--- Jura 09:41, 27 December 2016 (UTC)
@Jura1: Oh, I didn't realize that Nitesh Tiwari (Q16908467) is not no label (Q19263582). Yeah, I'll merge them. I also did not know that it is not allowed to have two items with the same label an description. But taht absolutely makes sense. --Jobu0101 (talk) 10:34, 27 December 2016 (UTC)

next IRC office hour on January 5th

Hey folks :)

We'll do the next office hour on IRC on the 5th of January at 19:00 Berlin time in #wikimedia-office. See here for your time. As usual we'll take a look back at the last quarter and see what's coming up next. Please let me know if there are any other topics you'd like to put on the agenda.

Cheers --Lydia Pintscher (WMDE) (talk) 15:54, 27 December 2016 (UTC)

how to find out missing articles in other languages ?

I am wondering if there is an efficient way to know which articles from an article list (e.g. in English Wikipedia) do exist already in a different language (e.g. Arabic) or not? I am supporting a website which includes unavailable Articles on Wiki:ar, which do exist in Wiki:en to incorage people to translate those articles. One suggested me to use this Wiki Converter, but it stops working very often, specially by an imput of more than 100 articles and is very time consuming. I'll be thankfull for any help!--Sky xe (talk) 18:28, 27 December 2016 (UTC)

It depends on where the list is.
If you can build a Wikidata Query with a list of articles on English Wikipedia, you can filter that list by articles that don't exists in another Wikipedia. This list has a version with articles missing in Arabic Wikipedia for Arabic films. For help with queries, see Wikidata:SPARQL query service/Wikidata Query Help.
--- Jura 13:26, 28 December 2016 (UTC)

Databases, ID's and subject item of this property (P1629)

There has been some discussion on this here and here (see history, it has been removed). Although the discussion seemed to be ended, there still were some reverts on this issue. To really finalize discussion I made a proposal here. Please share your opinions. Lymantria (talk) 10:35, 28 December 2016 (UTC)

Not removed, archved. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 10:44, 28 December 2016 (UTC)
Removed from direct visuality I meant. My apologies. Lymantria (talk) 10:46, 28 December 2016 (UTC)
I am a little confused. When I saw that user:Pigsonthewing had archived the discussion instead of answering, I took that as an admission that he was in the wrong. He did not have much choice in this since, as the discussion progressed, it became embarrassingly clear that he had been much too harsh. Preferably, he should have been more gracious about conceding. But now it appears he wants to be even more harsh? - Brya (talk) 11:50, 28 December 2016 (UTC)
Poppycock. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 14:42, 28 December 2016 (UTC)

Audio books within the books project …

Hi all. I started a conversation at Wikidata talk:WikiProject Books‎ with regard how we consider audiobooks as editions within the concept of a "book". There has been no comment there from that clique, so I am wondering whether the general populace would like to add to that discussion there. Thanks.  — billinghurst sDrewth 11:12, 25 December 2016 (UTC)

I think it totally works indeed. The kind of edition will be stored in the instance of (P31) statement about the audiobook. author  TomT0m / talk page 09:47, 29 December 2016 (UTC)

Constraints and deprecated values

Selma Vaz Dias (Q15428159), for example, has two values for Theatricalia person ID (P2469), one of which is deprecated (having been redirected to the other on the target website). Nonetheless, the item appears in Wikidata:Database reports/Constraint violations/P2469#Single value.

How can we ensure that this does not happen?

Perhaps the constraint code:

{{Constraint:Single value|mandatory=true}}

could be modified like:

{{Constraint:Single value|mandatory=true|allow-deprecated=true}}

or that could be the default? Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 11:00, 26 December 2016 (UTC)

I'd suggest to use {{Complex constraint}} instead, as you can fine grain control the ranking of relevant claims with SPARQL. author  TomT0m / talk page 09:40, 29 December 2016 (UTC)

Any tool that can en-mass update labels?

Im looking to see if there are tools to quickly updated the English labels for items. MechQuester (talk) 06:18, 28 December 2016 (UTC)

@MechQuester: you can try out QuickStatements (Q20084080) --Edgars2007 (talk) 14:59, 29 December 2016 (UTC)

Requested Moves

Help:Wikidata datamodel seems like it should be just "Help:Data model", or possibly "Help:Data model (Wikidata)". Same for Help:Wikidata test systems See: where none of the numerous other Help: pages are prefixed with Wikidata.

Too, the data model help page should contain references to the technical articles that describe the creation/evolution of the Wikidata data model. As is, its a bit too terse.

Rjlabs (talk) 19:02, 29 December 2016 (UTC)

Place of living

Do we have a property to show where a person is living or had lived his life? Xaris333 (talk) 01:40, 30 December 2016 (UTC)

We have residence (P551). —Wylve (talk) 02:52, 30 December 2016 (UTC)
Thanks! Xaris333 (talk) 04:20, 30 December 2016 (UTC)

Understanding language fallback chain

As a user with preferred language different from English, I consider the language fallback chain to be an important feature. I had some hard time trying to understand why it did not always work as expected and I have summarized my experience in a diff to Help (1) and (2). May I ask for some review and cleanup followed by marking for translation? Petr Matas 02:44, 30 December 2016 (UTC). Updated 03:07, 30 December 2016 (UTC)

Accented characters in regex

Is this the correct way to add accented characters to a regex? Is there a way to include all such characters? Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 13:46, 27 December 2016 (UTC)

Since all characters are allowed except spaces, you may want to write [^\s]+ --Pasleim (talk) 14:00, 27 December 2016 (UTC)
Belatedly, thank you; that works well in this case. But I'm still curious about the answer to my original question, for cases where only alphabetic, or only alphanumeric, characters are wanted. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 15:24, 28 December 2016 (UTC)
Well, this is different from library to library. For PCRE, per what I found by googling, this one could work: [A-Za-zÀ-ÿ]. Matěj Suchánek (talk) 18:58, 30 December 2016 (UTC)
[À-ÿ] matches all characters in the range between À (ASCII 192) and ÿ (ASCII 255) but character like ăąćčěğıłńřśşșšțůž aren't in that range and to make it worse, they are even split up on multiple unicode blocks. So I would be surprised if there is in a library an easy way to match all accented characters. --Pasleim (talk) 19:40, 30 December 2016 (UTC)
@Pasleim: Understood; thanks. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 19:49, 30 December 2016 (UTC)
I was quite blind, thanks for this analysis. Matěj Suchánek (talk) 20:48, 30 December 2016 (UTC)

Adding a source

I have some thoughts about adding a source in Wikidata. In Wikipedia, there are the w:Template:Cite web, w:Template:Cite book, w:Template:Cite journal. I am wondering how can we can use the source for Wikidata to fill the templates on Wikipedia automatic if the data on the Wikidata item has a source to a statement.

The parameters use of the template (and other cite templates) are:

Few of them has "Wikidata property to indicate a source" as a statement. [5]

Are those the correct properties for each parameter? What about the parameters I wasn't able to find a property? Do we have one?

I am not familiar with reference in Wikidata, may others users are already familiar to all of them....

Maybe we can have expand Help:Sources page including all these with examples. I think is better to consider all the parameters that can be use in each type of source. And to consider that Wikipedia can use our source (ok, we are now Wikipedia but they have a lot of experience of those thing and it is better to help each other).

And what about is we have more than one source in a statement? Which property (qualifier) is for which one?

And for example if I have one source for start time (P580) and one other for end time (P582) how can I show which source goes for each one? Both P580 and P581 are properties for an item? Or should I use these properties only to item own page?

Xaris333 (talk) 00:11, 30 December 2016 (UTC)

One conflict is that a Wikipedia publication date is the local time at the place of publication, while a Wikidata publication date is Universal Time. User:Jc3s5h 00:49‎, 30 December 2016 (UTC)
How serious is this problem (if it is one)? Matěj Suchánek (talk) 20:46, 30 December 2016 (UTC)
It's just one manifestation of Wikidata's inability to represent a date in a time zone other than UTC. Most dates in Wikidata are wrong. Jc3s5h (talk) 04:15, 31 December 2016 (UTC)
If a date is given with day precision, one has to ignore all information which make more precise claims including the time zone. The time zone parameter is only needed for dates/times with at least hour precision. So Wikidata doesn't say anything if a date is in UTC or in local time. Basically a specific day is a time period of 50 hours, from 12:00a.m. in UTC+14:00 (Q7130) to 11:59p.m. in UTC−12:00 (Q2146). --Pasleim (talk) 09:14, 31 December 2016 (UTC)
@Pasleim: is not correct. There are two detailed documents about how information is represented in Wikidata one for JSON and one for RDF. Both say days are universal time. For JSON, one requests a change to the documentation through Phabricator and I have done so with ticket T146499. . For RDF one requests a change to the documentation on the talk page. I have made requests in both places and the request have neither been acted upon nor opposed. Jc3s5h (talk) 15:26, 31 December 2016 (UTC)
Added some. This is what we have so far in cswiki. Matěj Suchánek (talk) 20:46, 30 December 2016 (UTC)
Do you think is there a property for "journal"? Xaris333 (talk) 02:28, 31 December 2016 (UTC)
for journal we have published in (P1433) --Pasleim (talk) 09:14, 31 December 2016 (UTC)
Thanks. Xaris333 (talk) 12:05, 31 December 2016 (UTC)

President of a football team

How can I show in a person item that he is/was the president of a football team? chairperson (P488) is adding to the football team item. Xaris333 (talk) 00:52, 30 December 2016 (UTC)

I think that position held (P39) can be used for this. Matěj Suchánek (talk) 18:52, 30 December 2016 (UTC)
You means P39 --> "Presidents of Real Madrid"? Xaris333 (talk) 02:01, 31 December 2016 (UTC)
That would be best. However, items for specific presidents usually don't exist, so this need is often replaced by using position held (P39): president (qualifier of (P642): the club). Matěj Suchánek (talk) 09:55, 31 December 2016 (UTC)
Thanks! Xaris333 (talk) 12:04, 31 December 2016 (UTC)

Help for queries


1) Can anyone limit this query [6] to items that have links in

2) Can anyone change this query [7] to find the items that has the property official website (P856) with any value, with the qualifier language of work or name (P407) with any value?

Xaris333 (talk) 20:13, 28 December 2016 (UTC)

--- Jura 20:25, 28 December 2016 (UTC)

@Jura1: thanks. Can the second one change to find the items that has the property official website (P856) with any value, without the qualifier language of work or name (P407)? Xaris333 (talk) 20:28, 28 December 2016 (UTC)

Sure, just replace "/" with "?claim . ?claim" and insert "FILTER NOT EXISTS {}".
--- Jura 12:00, 29 December 2016 (UTC)

@Jura1: Thanks. See [10]. Is there a way to include the items that have an item in head coach (P286) with deprecated rank? I mean if the item had only one value with P286 and this value is in deprecated rank, is must included be in my results. If the item has two values, on deprecated and the other not deprecated (normal or preferred) then the item should not be included be in my results. Xaris333 (talk) 16:10, 29 December 2016 (UTC)

@Xaris333: Your query doesn't return any results, so it doesn't make sense to amend it... or do you want to make another query? By the way, you can visit a dedicated page for this next time. Matěj Suchánek (talk) 20:57, 30 December 2016 (UTC)
  • Here we go: [11]. I included a sample of the filter syntax as well.
    --- Jura 10:15, 31 December 2016 (UTC)
Thanks! Xaris333 (talk) 23:52, 31 December 2016 (UTC)

P1448 and language

Hello. Using official name (P1448) you have to put the language. Is that working as a qualifier? And if yes, which one? A template fetch the data to Wikipedia from wikidata and I am trying to show the language that it is written as well. Xaris333 (talk) 02:15, 31 December 2016 (UTC)

The language of a monolingual text-claim is stored in datavalue.value.language where the text itself is stored in datavalue.value.text. The language is stored with a code (en for English for example.) Your can extract the language from the code by the help of the language-parser. If the language isn't supported by MediaWiki, the code used is "mis", and the language should be added in a qualifier. -- Innocent bystander (talk) 11:49, 31 December 2016 (UTC)
Ok. Thanks. Xaris333 (talk) 23:54, 31 December 2016 (UTC)