[07:49:45]

natural satellite

[07:49:47] https://cy.wikipedia.org/wiki/Arbennig:Am_y_Pwnc/Q16956 [07:50:05] Still no "lang" attribute to mark non-cy text. :( [09:00:34] noob question: is it possible to add more than one snak in a reference with QuickStatements? [09:10:47] ah yeah the new version supports that, and not the first one apparently [12:22:30] hi [12:22:59] is there a tool to add statements en mass besides quickstatements? [12:28:05] Hello, i cannot merge https://www.wikidata.org/wiki/Q50308533 with this one https://www.wikidata.org/wiki/Q47647413 [12:28:18] help, please [13:57:03] Greta: i was able to merge without a problem [13:57:57] you can use this page: https://www.wikidata.org/wiki/Special:MergeItems [14:56:47] freq: with bots [14:56:57] there is Wikidata:Bots for some more information on that [15:04:14] Hey, Lucas_WMDE :) [15:04:20] hi :) [15:04:25] Could you ask WikidataFacts if he remembers any useful query related to climate change? [15:04:57] hm, he says he doesn’t [15:05:31] Okay [15:08:20] Give him my thanks anyway :) [15:08:30] will do, he says you’re welcome ;) [15:09:51] Tomorrow we celebrate the Open Data Day and, in Madrid, the topic is climate change and sustainable development [15:10:22] I'm giving a talk and a SPARQL workshop [15:10:49] I'll think something, perhaps using federation [15:11:58] *WDQS workshop :) [15:16:28] ooh, cool! [15:17:35] abian: scientific articles about climate change per year might be interesting http://tinyurl.com/y7tp2k7t [15:19:54] Wow, yes, they are! :D [15:20:20] Perhaps comparing with the total number of publications (another line) to see if there's a relative increase [15:21:08] Or representing the quotient (articles about climate change)/total [15:22:08] hm, total number of publications will be expensive [15:22:37] and I suspect it will need to be a quotient, otherwise you wouldn’t see the articles about climate change at all (ratio too small) [15:41:17] abian: number of scientific articles per year seems to be impossible if even this times out http://tinyurl.com/ya9s8da9 [15:41:22] (based on https://twitter.com/WikidataFacts/status/946066633096880130) [15:43:34] Yeah, just tried, it's impossible :/ [15:44:49] Many queries with a statistic/probabilistic nature could be run if there was some random way to access the data (sampling) [15:45:42] But the standard way is far from being random [15:47:08] If there was a pseudorandom way, a low LIMIT could be enough for these queries [17:36:38] 17:34:38 [e17197231623111d295d73cb] [no req] MWException from line 167 of /srv/jenkins-workspace/workspace/mwext-phpunit-coverage-publish/src/includes/Hooks.php: Invalid callback WikibaseQuality\ExternalValidation\WikibaseQualityExternalValidationHooks::onCreateSchema in hooks for LoadExtensionSchemaUpdate [17:37:48] Eek [17:37:58] Lucas_WMDE: ^ [17:39:06] Reedy: looks like https://phabricator.wikimedia.org/T185609 [17:40:09] and I assume you saw it in the coverage post-merge build? see also https://phabricator.wikimedia.org/T185697 [19:23:50] hi, could somebody create a semi-simple sparql query for me? I do a presentation tomorrow and would like to demonstrate with some local stuff … [19:24:18] elya: what to you want to query? [19:25:01] @harmonia_Amanda, thx, I'd like to show a timeline of the mayors of Q1718, with images. [19:25:46] mayors, in this case P6 [19:28:31] Harmonia_Amanda, I came up to this: http://tinyurl.com/ydh2krnh [19:30:10] http://tinyurl.com/y8874m9t [19:33:14] Harmonia_Amanda, beautiful, thank you. [19:33:18] :) [19:36:52] args, Harmonia_Amanda, I think we are too distinct here, there was one person who was mayor 2 times which appears only once ;-) [19:38:40] elya: trying to fix it [19:42:43] http://tinyurl.com/ybacpktc [19:49:00] (and adding data) [19:54:41] Harmonia_Amanda, sorry, too much tabs open ;) – pls have a look at Q1718 … Klaus Bungert (Q1744941 ) should be 2 times in the timeline, shouldn't he? [19:56:34] elya: my fault, I pasted the wrong url [19:56:35] http://tinyurl.com/y6wofmmu [19:58:50] Harmonia_Amanda, ah, great! And you're fast with adding data … I'll go on with it to fill it a bit. Do we have the possibility in timelines to display periods of time, like start to end dates? (just asking) [19:59:16] not with SPARQL [19:59:28] but we can add the end date to the pictures [20:00:16] http://tinyurl.com/ya49gfje [20:02:03] Harmonia_Amanda, nice. I'm with opendata people in this city tomorrow, so hopefully we'll get some more pics for this timeline ;-) [20:02:25] and more precise dates for the elections :p [20:02:46] (SPARQL always display it at "January first" which is really strange [20:04:14] I think we have the years only, mostly. [20:04:40] But it's ok, it demonstrates that wikidata is not complete and maybe will motivate the open data people. [20:04:50] maybe they have a dataset [20:05:56] Harmonia_Amanda, do you know why the timeliine displays ?end before ?date ? [20:06:42] nope, sorry :s [20:09:45] (strangely enough the year 1945 saw a high turn-over for mayors ><) [20:10:13] (like, you are just adding data and brusquely history!) [20:11:08] yeah. after the war the allies were quite quick in changing the mayors, but I'm better with Cologne than Dusseldorf in this case ;-) [20:12:00] Harmonia_Amanda, thank you very much, it will make the presentation nicer tomorrow. [20:16:33] elya: I think I found everyone except Friedrich Wilhelm Becker (1876-1886) [20:16:45] starting in 1815 [20:18:13] Q1338290? [20:18:49] yup ! [20:18:57] I searched all Friedrich [20:19:16] didn't think his usual given name would not be the first, I should have known [20:21:11] they are all here: https://de.wikipedia.org/wiki/Düsseldorf#Oberbürgermeister_seit_1815 [20:33:17] elya: should have everyone with beginning/end dates and previous/next mayor [20:33:57] Harmonia_Amanda, wow. [20:35:26] good luck for your workshop :) [20:37:22] Harmonia_Amanda, thanks [20:41:06] elya: and I hope they will have pictures for those missing :) [20:41:22] I'll report! [20:41:28] :) [20:58:07] wasn't it planned to add wikibase to wikimedia commons? [21:02:11] hi WikidataFacts :) [21:05:41] hello :D [21:05:50] thanks for reminding me that I should be on IRC :D [21:10:33] ^^ [23:55:06] Amir1: uh, want to review https://gerrit.wikimedia.org/r/#/c/416171/ before it has merge conflicts? o.O