[06:38:11] Is there any way, through the database tables, to figure out which properties are used on which items? I was thinking of using the pagelinks table, but that includes pagelinks that are in references – I just want property links in the main snak. [07:19:11] (And the issue with WDQS here is that there’s too much stuff for it to work properly) [13:10:45] addshore: does average statements per item include identifiers? [13:12:32] yes [13:13:23] Okay, cool. :) [14:01:28] hello [14:07:04] I would like to know if there is a way i could retreive the list of properties, but arranged into the same categories as they are ordered on this page: https://www.wikidata.org/wiki/Wikidata:List_of_properties using a sparql query [14:07:43] or to put it another way, lets say i want to get just the properties in the "generic" section back as json [14:09:31] i have looked through a lot of docs and i have stumbled on wikimedia:Group but i dont know if i am barking up the wrong tree or not [14:38:04] oMikekiMo: You can query sparql for properties and what instance they are [14:39:40] multichill: any idea how I can search in the GTAA? [14:41:01] Oh, got it. [14:41:06] Not really easy. :| [15:07:28] thank you multichill, that gives me a thread i can pull on. [15:07:57] ti have been able to get properties back, but i am having trouble formating the list [16:12:23] oMikekiMo: Check out http://tinyurl.com/ya8l2my7 [16:12:27] Might be useful for you [16:55:56] Hey DanielK_WMDE_, is there anything helpful I can do with your patch for the MediaInfo changes? It looks like Thiemo has some issues with it still? [16:59:28] (for reference, https://gerrit.wikimedia.org/r/386422) [17:04:04] reminder: IRC office hour starts in 1 hour, on #wikimedia-office :) [17:09:32] Sudden office hour... [17:10:02] Is it WIkidata office hour or something else? [17:10:13] Wikidata it seems, only announced yesterday. [17:11:32] it’s been in my calendar for ages… did we not publicly announce it properly? [17:12:17] Hm, it was in the summary of 25 september. [17:12:17] Mostly there is a separate e-mail. [17:12:28] oh, okay [17:12:44] is there any point in sending one now? for people who are online but not on IRC, perhaps? [17:13:07] There is still time. :) [17:13:25] okay, I’ll do it :) [17:14:18] there was a tweet, with the wrong time zone :D [17:14:49] Oh boy. [17:15:23] oh noes [17:16:16] marktraceur: I'll sort it out with thiemo. Thinking about it some more, it may be a bit too abstract. Maybe we want to hook into "find entity by some api request parameters", not into "find entity for sitelink". That would be closer to your original idea. [17:18:36] okay, let’s hope the email goes through the ML soon [17:19:11] It is here. [17:19:14] DanielK_WMDE_: Well, I guess the good news is we may already have a patch for it then... [17:19:57] marktraceur: possibly :) can you give me the link? I'll see if that's what I had in mind... [17:20:34] marktraceur: i'd like to avoid using MW style hooks, or at least only use them in bootstrap/wiring code, if possible [17:21:18] DanielK_WMDE_: Ah, I misunderstood then. I may have been out of MW PHP development for too long... [17:21:47] sjoerddebruin: Reminds me. What authority control db's were you talking about that should be synced again? [17:21:48] DanielK_WMDE_: https://gerrit.wikimedia.org/r/386693 and https://gerrit.wikimedia.org/r/386692 were my original attempt [17:22:09] DanielK_WMDE_: Unless you meant the new API module I tried to write, which was significantly worse IMO [17:22:27] multichill: I would love to have a VIAF <-> NTA update, but maybe we can ask Magnus as he performs checks as "was removed from item before" etc. [17:22:45] I see various identifiers growing with 1k per day by Reinheitsgebot. [17:22:57] marktraceur: DI is generally preferred over wgHooks - in core, that transition is far away. in wikibase, we use DI for nearly everything, and only use wgHooks as an option of last resort. [17:24:06] sjoerddebruin: Let's do that, I wouldn't like to add stuff that someone just removed [17:25:02] multichill: https://www.wikidata.org/wiki/Wikidata:Property_proposal/MuIS_ID does this seem reasonable to you? (asking since it's connected to the museum thing) [17:25:17] (it's already marked as ready but not seen by that many people so just in case) [17:26:07] DanielK_WMDE_: I'm still fumbling a bit with the version of DI you guys are using, I guess it has more to do with the services stuff [17:28:34] multichill: asked Magnus in a perfectly 280 characters tweet. [17:28:38] marktraceur: for app logic, DI in wikibase works exactly like MediaWikiServices. But the wiring is hardcoded, there is no way to dynamically re-define services. [17:29:25] marktraceur: DI itself, ignoring any frameworks or factories, is really just the consequence of "don't use global state, ever": everything you want to use has to be injected into the constructor. [17:30:23] marktraceur: I added a comment to https://gerrit.wikimedia.org/r/#/c/386693/1 to explains what I think could eb done instead of my original proposal. [17:33:53] multichill: seems like there is some cleaning to do though https://www.wikidata.org/wiki/Wikidata:Database_reports/Constraint_violations/P1006 [17:45:14] reosarevok: Looks good. I'll create it later, first have some food [17:45:23] ooh. Thanks :) [17:46:07] sjoerddebruin: I see a lot of these doubles where one of the links is broken so someone has been cleaning up indeed ;-) [17:46:47] Bot could probably do it quite easy based on pages like http://opc4.kb.nl/PPN?PPN=339698268 [17:46:54] (does it throw a 404?) [17:51:20] 200 :( [17:52:13] Just grepping for "TITEL NIET IN DATABASE AANWEZIG ???" works [17:52:28] :D [17:53:11] reosarevok: Do you also have specific Estonian authority control for artists? :-) [17:54:19] sjoerddebruin: That's an easy bot job. Loop over the sparql query that produces https://www.wikidata.org/wiki/Wikidata:Database_reports/Constraint_violations/P1006#.22Single_value.22_violations . For each link, check for the string and if you find it either delete or deprecate it [17:54:46] reosarevok: IIRC, no, and that was actually one of the things we were hope to improve via WD [17:54:50] .... lol [17:54:56] * reosarevok is clearly too sleepy [17:54:59] multichill: ^ [17:55:33] For example, to have a quick overview via a SPARQL query of all the artists in the collection who have been dead for long enough, in order to know what we can put in Commons [17:56:38] Seems that this muis museum system does not have artist pages - neither does the library system, for writers / musicians :'( [17:56:39] That's nice indeed [17:57:15] That's a shame. Have I shared https://www.wikidata.org/wiki/Wikidata:WikiProject_sum_of_all_paintings/Creator_no_authority_control with you before reosarevok? [17:57:28] I don't think you have [17:58:08] When we start adding works from new countries, gaps start to appear here :-) [17:58:44] We do have an "Eesti kunsti ja arhitektuuri biograafiline leksikon" (Estonian art and architecture's biographic lexicon) which should be a pretty legitimate source of things like birth and death dates, but not sure we have a decent external ID [17:59:00] (that's an actual paper book) [17:59:14] I can ask the museum people though, maybe I'm missing stuff, I'm fairly new to all art not related to music :p [17:59:18] Sounds promising. We actually have quite a few paper books turned into a website with id's [17:59:47] office hour in #wikimedia-office now :) [17:59:51] IIRC we have permission to basically mirror these books into etwiki [17:59:55] But that doesn't help :p [18:00:01] (with this specific issue) [18:00:55] Hmmm! [18:01:01] multichill: https://digikogu.ekm.ee/authors/author_id-1057 [18:01:10] The Estonian Art Museum does have it ! [18:01:21] Of course, that probably won't be good for all the artists we want, but definitely better than nothing [18:01:58] For Estonian people it has some more info, https://digikogu.ekm.ee/authors/author_id-431 [18:02:43] I guess this means I should request one more property? :p [18:03:16] It's possible that some of these are in VIAF too, but I think only the Estonian National Library feeds into VIAF, not the art stuff [18:04:17] Hi there. I just notice the half of the [[Template:Infobox polyhedron]] parameter doesnt exit yet as a Wikidata property. Does it sound reasonable to propose that ones? [18:04:17] 10[3] 04https://www.wikidata.org/wiki/Template:Infobox_polyhedron [18:04:50] https://en.wikipedia.org/wiki/Template:Infobox_polyhedron probably :p [18:05:28] Hi there, I am User:Sturm! :) [18:06:00] marktraceur: I talked to Thiemo. He prefers my patch as proposed over my new idea. He'll take over the patch, I will provide review. I hope to get this done this week. Please ping me if this gets stuck. [18:28:05] sjoerddebruin: For the NTA fixing, can you file a request on the bot's board? Should be an easy starting tast for someone wanting to get involved with bots [18:42:57] DanielK_WMDE_: Sounds good! [18:45:01] multichill: thanks :) (saw it's added now) [18:52:23] reosarevok: Yup, at https://www.wikidata.org/wiki/Property:P4525 . Can you add the Estonian part and maybe more? [18:54:27] reosarevok: Oh, and https://www.wikidata.org/wiki/Q18593264 and https://www.wikidata.org/wiki/Q12370563 . Is that about the same concept? [18:54:58] Hmmmm [18:55:02] I... think so? [18:56:59] The etwiki page claims, in a rough translation: A "museaal" is an item with cultural value inventarised in a museum. A collection of "museaals" is named a museum collection. [18:57:10] So, it seems like we could even merge the two items [18:57:25] I could ask my museum contacts first though :) [18:57:42] The existing one is a bit of a made up item [18:57:43] I would say it is the same. [18:58:16] spinster: Do you know if AAT has a high level concept like this ^^ [18:58:52] Let me take a look [18:59:43] Basically a high level concept for every object that is in a museum collection [19:00:25] No, it doesn't [19:00:56] "museaal" seems to be a subclass of "items of collections or exhibitions" imo [19:01:12] MoMA kinda fucks things up by including fonts and computer games. ;) [19:01:54] Yeah, I guess it's not exactly the same maybe in that this is specifically about museums but maybe a "collection" for Q18593264 can be a very unspecified thing? [19:02:59] indeed, that's what I would think as well [19:10:36] Lydia_WMDE: So in the office hour you repeated things which are all or at least most of it in the news letter. I read that news letter most of the time so for me this turned out a bit boring. [19:10:52] I wonder if this duplication is intentional and how other people feel about this [19:11:48] multichill: it is a re-hash to an extend but it helps put things into a longer-term perspective and helps people who don't read the weekly summary [19:11:59] but i am happy to change things around if you or someone else has ideas [19:12:15] Just thinking out loud here [19:12:20] *nod* [19:12:23] all ears :D [19:12:42] and yeah if you are always close to the news then there probably isn't much news for you in there :/ [19:13:07] but then again we try to have all the important things in the weekly summaries so that is to be expected [19:13:26] also if people want we can spend more time on specific discussion topics [19:13:37] multichill: fixed the Estonian stuff I could see on https://www.wikidata.org/wiki/Wikidata:WikiProject_sum_of_all_paintings/Missing_inventory_number (one wasn't in Estonia at all!) [19:13:39] we've done that sometimes in the past when people brought specific topics [19:13:57] (but in Este, Italy :p ) [19:14:08] like "what do people think about X" or "how do we solve Y" [19:21:59] multichill: why don't we have identifiers for beer yet? [19:22:07] The whole office hour was a bit last minute catch up anyway. Happy to be fully up to speed [19:23:29] multichill: did you see the link I sent earlier? https://digikogu.ekm.ee/authors/author_id-2 [19:23:36] reosarevok: Nice! Plenty of fixing to be done. I was just browsing through http://opendata.muis.ee/ [19:23:38] (so we do have *some* sort of authcontrol in EE) [19:23:59] Looks like they do have author information [19:24:26] they do have author information, they just don't have an actual page for the author we could link to - unless I missed it [19:26:36] reosarevok: So https://www.muis.ee/rdf/object/262747 is the object in RDF [19:26:55] * reosarevok checks [19:27:31] By the way, the image rights are known to be generally BS [19:27:43] And they have the author as a string, not as a link to another object [19:28:02] I don't understand the language anyway, so I'll just ignore that part ;-) [19:29:38] I added the RDF thing to https://www.wikidata.org/wiki/Property:P4525 [19:30:10] Seems you forgot the /rdf/ part? [19:31:39] That's to force it. Source says [19:31:47] Oh [19:31:49] Ok :) [19:32:15] Bit like we have http://www.wikidata.org/entity/Q12370563 and https://www.wikidata.org/wiki/Special:EntityData/Q12370563.rdf [19:32:59] Seems person-group is RDF-only [19:33:17] Which is annoying. But they do have *some* identifier for the museums themselves, then, it seems [19:34:18] But yeah, can't find anything for the artists [19:34:54] Do you think it makes sense to start another property request for the Estonian Art Museum artist ID? [19:35:22] (seems that they also have IDs for the works, https://digikogu.ekm.ee/no_category/oid-10326 - but that one is actually kinda "superseded" by MuIS, although I guess having both would make sense [19:35:23] ) [19:36:24] It seems to be linked so you can sync it easily [19:37:21] reosarevok: I wonder what the plans are for person like https://www.muis.ee/rdf/person-group/42620 . That would be interesting to link to if they're going to invest time in it [19:38:19] AFAICT most people in museums here kinda hate the MuIS platform, so I get the feeling they're not very responsive to stuff like this, but honestly, no clue [19:39:32] Is it some kind of forced top down thing from the national (nationalistic?) goverment? [19:39:49] That's usually a good approach to piss off the local heritage professionals [19:41:32] reosarevok: So every work in a museum in Estonia should have an id in that database? [19:42:00] I think yes (to both questions) [19:42:06] Whether they *do* have it, I dunno [19:42:26] I'll set up a complex constraint for that. Let's see what it catches [19:43:57] I've added the missing ones from https://www.wikidata.org/wiki/Wikidata:Europeana_Art_History_Challenge/Estonia - except for Q21257263 which is, as we discussed the other day, kinda messy [19:44:12] (the current inventory number is for only one of the copies, we have entries for several others on the talk page) [19:44:26] Can you check http://tinyurl.com/ybn4totf ? [19:45:08] Sure [19:45:43] (there's a ton of stuff in Commons using MuIS links, too, but I'm not sure how that stuff works, they don't seem to have WD items) [19:46:02] Quite a few artworks already link to Wikidata [19:46:38] More than 100.000 images in https://commons.wikimedia.org/wiki/Category:Artworks_with_Wikidata_item with a link to Wikidata [19:47:30] If you intersect that with https://commons.wikimedia.org/wiki/Category:Images_with_link_to_Muis.ee , you'll know where to add it [19:48:34] Only 5 according to https://petscan.wmflabs.org/?psid=1475214 reosarevok [19:49:10] I think all of those are there [19:49:36] But as you can see there's a ton more. Some are photos (most, probably) [19:49:39] But some are paintings [19:50:21] Starting from Commons is a PITA. Just start with the clean(er) data from the database [19:50:37] heh [19:50:38] ok [19:50:55] We'll do most of this starting January, just trying to get an idea of how to start for now and some examples :) [19:51:03] At some point the paintings will start popping up at https://www.wikidata.org/wiki/Wikidata:WikiProject_sum_of_all_paintings/Image_suggestions if they have some form of decent metadata on Commons [19:51:28] Ok :) they mostly have {{Creator}} at least, and I think museum to [19:51:29] 10[4] 10https://www.wikidata.org/wiki/Template:Creator [19:51:29] *too [19:52:08] Can't find https://www.wikidata.org/wiki/Q27826773 - I guess the National Archives might not be there (or not yet?) [19:52:26] (that's just some official paperwork though so eh) [19:52:48] Make sure the paintings use the artwork template instead of information and have the creator and/or institution templae [19:54:58] Heh [19:55:22] reosarevok: And https://commons.wikimedia.org/wiki/Category:Paintings_in_Estonia seems to be very very incomplete [19:55:24] https://www.wikidata.org/wiki/Q21294968 has two entries, but it's again some printing (https://www.muis.ee/museaalview/251670 - weird poetry stuff) so not surprising [19:56:00] I'd expect that category can be populated based on WD later on? I mean, if we know a painting is in Estonia and has a Commons image... :) [19:57:09] I wouldn't invest a lot in categories right now [20:06:33] Sure [20:06:45] If all the data is there categories are trivial to bot-add [20:06:48] I'd hope [20:07:25] Ok so your query is a bit shorter now :) [20:09:34] The flag I tried and failed to find a few days ago already, two have multiple IDs and need more work separating them into parts probably, and some are old legal texts I can't find [20:21:46] So not really worth setting up a constraint right now, right? [20:22:16] Maybe not. Maybe for stuff in *art* museums? [20:22:30] After all, the ones there that don't have an ID do need extra work [20:22:43] (but are in the DB) [20:36:33] sjoerddebruin: Weren't you working on the Dutch mayors? [20:36:39] I was. [20:42:16] So Den Bosch, no mayor object yet? [20:55:45] Nope. https://www.wikidata.org/wiki/User:Sjoerddebruin/Dutch_politics/Mayors [20:56:48] Still working on fixing combinations of villages and municipalities, then I want to look at bot tasks. [20:58:27] Is everyone in WD Dutch? :D [21:00:18] Yes, of course. :) [21:00:50] Also fun with merged municipalities [21:01:06] Probably best to take now and work back in time? [21:07:02] Hmm [21:07:15] sjoerddebruin: https://www.wikidata.org/wiki/Q6627739 vs https://www.wikidata.org/wiki/Q15731141 - should instance be position? [21:07:46] I wasn't aware of "public office" when I created those items [21:08:17] So public office is ok then? :) Nice [21:09:33] And there should be a separate "mayor" item for each country? [21:09:54] * reosarevok was actually asked about having some sort of "add Estonian politicians to WD" event [21:10:27] Hm, I'm not sure anymore actually. [21:10:42] But it is nice to combine with the lists and categories. [21:21:22] * reosarevok creates one for himself for Estonian mayors (standard mayor class plus Estonia) [21:21:33] ... so much missing data, so little time [21:24:27] and you only got one life [21:42:16] Heh [21:42:32] "head of Tartu County". Instance of human, sex or gender male [21:42:40] a) sexist much? b) sigh [21:42:42] * reosarevok fixes [21:44:19] b) sign :) [21:48:41] sjoerddebruin: what do I do with something like this? https://www.wikidata.org/wiki/Q24545692 [21:48:58] I'm assuming I shouldn't hijack it for the position itself? [21:49:10] Hm? [21:49:25] Well, it's "Mayor of (Estonian city)" [21:49:35] But it claims to be "a list of" [21:49:58] At the same time, the etwiki article is just for the concept of mayor, despite most of it being indeed a list of past ones [21:50:08] (of mayor of Viljandi, that is) [21:50:39] Should I just remove the "instance of list article" and add "public office", or add a second, public office entry? [21:51:06] (sorry if you're not the best person to ask this from, but :) ) [21:51:22] (by the status of Estonian politics stuff, I can tell we have no local expert at least :D ) [21:51:48] I would keep lists. [21:53:07] The main thing is that the article is not specifically "List of mayors of Viljandi" (and it specifically starts with "The mayor of Viljandi runs the Viljandi city council") [21:53:39] Ah! [21:53:41] So I'm not sure this is really the right classification for it... but I'm not sure what the convention is :) After all, that's literally all the article explains about the position before jumping into a historical list [21:53:51] Yeah, then they shouldn't be classified as lists. [21:55:14] Ok :) [21:55:23] Oh sigh [21:55:46] Is there a way to clear all those dozens of descriptions in each language? [21:58:08] * reosarevok assumes there has to be some sort of bot or tool :) [22:05:50] Hi, is there a tool for the same thing but for Labels and Also known as ? https://tools.wmflabs.org/dexbot/tools/changed_descriptions.php?lang=ar [22:08:05] hello4 [22:22:52] does wmf.8 deployment branch still has wmf.7 for wikidata? [22:26:31] addshore, aude ^ ? [22:27:40] sjoerddebruin: any idea about emptying all descriptions? (all mentioning the mayors are a "Wikimedia list" [22:27:42] ) [22:28:15] There is a script, but I also think there is a bot running.] [22:28:26] Also, sigh at the inconsistency in "position held" for https://www.wikidata.org/wiki/Q439102 - wonder which one is preferable [22:32:14] Hi, is there a tool for the same thing as for Descriptions but for Labels and Also known as ? https://tools.wmflabs.org/dexbot/tools/changed_descriptions.php?lang=ar [23:12:51] SMalyshev: I'm not sure! Can't check now, can check tommorrow [23:13:23] addshore: ok, thanks! looks like Wikidata is still on old version even in wmf.8, this is strange [23:13:59] Hmm, maybe no branch was cut of the Wikidata build? [23:14:31] I see the branch on wikibase repo, but not sure about the build... there were many changes recently [23:14:47] maybe something changed? maybe build was not run? I don't know... [23:14:47] SMalyshev: https://github.com/wikimedia/mediawiki-extensions-Wikidata/branches [23:15:01] No .8 branch for the build, so I guess it is still on .7 [23:15:03] yeah looks like no new branch [23:15:16] Could you file a ticket and cc Aude and I? [23:15:26] ok will do [23:18:30] I was expecting a branch to be cut from the build :( sad times [23:20:00] https://phabricator.wikimedia.org/T180539