[00:30:12] so this entity https://www.wikidata.org/wiki/Q154950 is a company that has had multiple CEOs. But "SELECT ?CEO WHERE wd:Q154950 wdt:P488 ?CEO" returns only one. [00:40:25] syntaxfree: that's because only one value has preferred rank [00:40:59] you can use p:P488 / ps:P488 to get all values [03:37:21] PROBLEM - Check systemd state on wdqs1010 is CRITICAL: CRITICAL - degraded: The system is operational but one or more units failed. [03:54:37] RECOVERY - Check systemd state on wdqs1010 is OK: OK - running: The system is fully operational [03:58:01] PROBLEM - Check systemd state on wdqs1010 is CRITICAL: CRITICAL - degraded: The system is operational but one or more units failed. [04:24:29] RECOVERY - Check systemd state on wdqs1010 is OK: OK - running: The system is fully operational [04:27:53] PROBLEM - Check systemd state on wdqs1010 is CRITICAL: CRITICAL - degraded: The system is operational but one or more units failed. [04:54:19] RECOVERY - Check systemd state on wdqs1010 is OK: OK - running: The system is fully operational [04:57:45] PROBLEM - Check systemd state on wdqs1010 is CRITICAL: CRITICAL - degraded: The system is operational but one or more units failed. [05:17:09] RECOVERY - Check systemd state on wdqs1010 is OK: OK - running: The system is fully operational [10:52:15] Hi folk [10:53:06] I have two objects that relate, but are not the same. (Q47476948) is an article about the person in object (Q18954211). [10:53:24] I think they should somehow link to each other, but I have no idea how [10:53:34] Any suggestions? [10:53:51] Hi Hanna_P_WMDE [10:55:20] Hanna_P_WMDE - or Jó napot kivanok :) [10:55:49] Yotwen: what about P921? [10:56:19] and P1889 [11:00:29] Nudin - I simply don't know. I'm a newt who added information "as he felt fit" [11:00:59] and I don't feel fit anymore :) [11:01:21] yes that's totally normal, everyone starts like this [11:01:53] you will get a feeling of what properties can be used soon [11:04:05] I'll check the suggested properties and use the one, I feel most fit for the task. [11:04:34] There are colleages around in the same arena, who certainly will help if I screw up [11:06:25] Nudin: BTW: R U happy to display your real-name in the chat? [11:06:53] yes, I edit with real name in Wikipedia/Wikidata [11:07:26] I use Nudin as nick here mostly because my real name is to long for an IRC nick ;) [11:08:12] That's perfectly OK - I only checked my own signature after I asked you [11:08:43] It shows my IP, but not my name - but some people don't seem to know [11:09:09] anyway, thx for the help - C U around [11:48:44] hello? [11:49:43] can someone help me with this query? http://tinyurl.com/y9gk7u54 [11:50:35] trying to query all animal species in the amazon rain forest [12:00:48] it's a shame dbpedia isn't as organized with its prefixes as wikidata. Probably a very difficult problem to get that right from scraped data.. [12:06:33] syntaxfree, hey [12:06:43] can you help me with this query? http://tinyurl.com/y9gk7u54 [12:06:47] trying to query all animal species in the amazon rain forest [12:07:03] CoolerZ: The first triple must be "?animal wdt:P31 wd:Q16521" [12:07:34] but even than you don't get results because habitat-values have not yet imported [12:08:33] there are currently only ~100 animals with habitat-values… :( [12:08:52] Nudin: that won't work, species are instances of taxon. it probably needs to be wdt:P171* [12:09:00] CoolerZ: I can try. Let me first post the question I had here so I don't lose track of what I was doing? [12:09:53] Nudin, why? [12:10:08] why what? [12:10:25] Why haven't the habitat values been imported? [12:10:32] I'm still having issues with p/ps. This modified tutorial example works: https://bit.ly/2DUF7Ta but my analogous query https://bit.ly/2DREvxU doesn't. [12:10:42] also should i use taxon? [12:10:56] You're already getting help but Ima take a look anyway. [12:11:37] because no one did it yet… it's all work to do by volunteers [12:12:08] but wikipedia has that info right? [12:12:12] CoolerZ: Wikidata is done by hand. There's dbpedia, which is scraped from Wikipedia infoboxes and stuff. It's harder to use. [12:12:26] nikki: don't get it [12:12:59] It's still SPARQL though. You just have to learn their language, warts and all. [12:13:49] Nudin: e.g. https://www.wikidata.org/wiki/Q26843 has "instance of taxon", not "instance of animal". to find out that it's an animal, you have to follow the "parent taxon" statements [12:14:15] nikki: that's why I use Taxon [12:14:33] myself I'm trying to really understand SPARQL and connect to the work I was doing with incidence structures and formal concept lattices. Wikidata is much more organized. Once for school I had to track the "...influenced by..." graph of Wikipedia and used dbpedia for that. [12:15:01] ohh, right, you changed the ID... but that won't limit it to animals [12:15:23] so yes, that also finding plants and other taxons but the main issue is anyway that we only have 100 habitat-values [12:16:11] yeah :/ [12:16:51] ok what about "what is the speed of cheetah?" [12:16:56] syntaxfree: you have ps:488 instead of ps:P488 [12:17:46] nikki: what. thanks! [12:18:40] http://tinyurl.com/yca9rc5g [12:18:42] doesn't work [12:18:55] strangely enough tinyurl isn't working on my side. neither on the query.wikidata interface, nor fro CoolerZ's links. [12:21:24] is that also not imported? [12:22:51] I don't see any statements on the item for cheetah about speeds, so it would seem not :( [12:23:42] nikki, what? the second line in where clause, above the label thingy [12:24:00] trying to get speed of lamborghini aventador doesn't work either http://tinyurl.com/y7mrbw6z [12:24:25] I mean there are no statements on https://www.wikidata.org/wiki/Q23907 about the speed [12:24:55] oh [12:25:05] but google returns a speed [12:25:41] google uses a variety of sources, as far as I know [12:25:42] https://screenshots.firefox.com/ubwZ5gDKn9iL4iEj/www.google.com [12:28:43] hey hold on [12:29:06] there is a taxon map range image [12:29:07] https://www.wikidata.org/wiki/Q23907 [12:29:20] isn't that the habitat [12:30:30] Nudin, ? [12:30:44] yes [12:31:13] but that doesn't help you, since it's an image and thus not machine-readable [12:36:16] i think that was generated [12:37:56] is there an easy way to go to the actual wikidata page from the identifier in the query? [12:38:07] in the online editor [12:38:22] the popup doesn't contain any links [14:17:04] wikibase:statements seems to be super slow to query against. [14:17:18] I wanted to find the items with the most statements among a set of 1800 items, and it timed out. [14:17:31] cc SMalyshev [14:18:37] oh! scratch that. I had a typo in a variable name. :-D [14:30:05] :D [19:51:37] PROBLEM - puppet last run on wdqs2001 is CRITICAL: CRITICAL: Catalog fetch fail. Either compilation failed or puppetmaster has issues [19:52:09] PROBLEM - puppet last run on wdqs1009 is CRITICAL: CRITICAL: Catalog fetch fail. Either compilation failed or puppetmaster has issues [19:54:05] PROBLEM - puppet last run on wdqs1005 is CRITICAL: CRITICAL: Catalog fetch fail. Either compilation failed or puppetmaster has issues [19:57:17] RECOVERY - puppet last run on wdqs1009 is OK: OK: Puppet is currently enabled, last run 4 minutes ago with 0 failures [19:58:55] PROBLEM - puppet last run on wdqs1008 is CRITICAL: CRITICAL: Catalog fetch fail. Either compilation failed or puppetmaster has issues [19:59:11] RECOVERY - puppet last run on wdqs1005 is OK: OK: Puppet is currently enabled, last run 2 minutes ago with 0 failures [20:17:17] RECOVERY - puppet last run on wdqs2001 is OK: OK: Puppet is currently enabled, last run 25 seconds ago with 0 failures [20:24:39] RECOVERY - puppet last run on wdqs1008 is OK: OK: Puppet is currently enabled, last run 2 minutes ago with 0 failures [20:36:57] /msg NickServ VERIFY REGISTER Mika77 roojswheedqe [21:02:39] * reosarevok hopes that was not their password [21:04:11] the parameter to the verify register command is what was provided by email [21:05:34] Phew :)