[09:33:26] ping reosarevok [09:44:08] I'm looking for help with a query, again :-) [09:44:13] The query is here: [09:44:41] http://tinyurl.com/ybowe3or [09:45:00] I'm looking for retrieving each propery 'Exact Match' of the adjacent station. [09:45:19] I'm able to retrieve the wikidata url, but I don't know how to retrieve a specific property from the entity. [09:47:31] drupol: something like this? http://tinyurl.com/y796yxzu [09:49:40] Oh man... yes [09:49:55] Now checking how you did [09:50:34] Weird, I did it before asking here [09:50:37] And I had errors [09:50:50] But ok, it means that I'm starting to understand how sparql is working :-) [09:50:54] Thanks a million pintoch ! [09:50:57] @pintoch++ [09:51:08] you're welcome :) [10:08:31] Yay :) [10:08:50] (was in a sauna :D but I see you got help anyway, drupol) [10:08:59] Lucky you [10:09:04] Yeah [10:09:07] And thanks to that, I did this: [10:09:16] https://github.com/iRail/iRail/issues/334#issuecomment-354538037 [10:09:22] I know you like real life example :-) [12:25:05] hey [12:37:13] hi [12:41:24] complicated stuff here [12:43:38] okay [12:51:29] who's is wat [12:57:21] Wat is your commands [13:00:04] account # [13:23:59] need logged in data sheet deletions [13:27:02] who is this? [14:08:27] * reosarevok reads backlog, rolls eyes [15:04:59] This is more how I like it. :) https://www.wikidata.org/w/index.php?title=Wikidata%3ADatabase_reports%2Fwithout_claims_by_site%2Fnlwiki&type=revision&diff=615105784&oldid=615017063 [15:24:00] Adding https://www.wikidata.org/wiki/Property:P577 is also enough to ruin suggestions. :( [15:24:42] sjoerddebruin: I just added the recoin gadget. Can you check if it works for you too if you enable it? [15:26:10] Works for me. [15:27:49] Good. I had it as a user script for a while, but a gadget is much nicer [15:29:08] Same. [15:29:25] Actually much more clever suggestions... [15:34:38] Uh oh [15:35:12] Getting 503's [15:35:14] Yeah [15:35:26] "Ops Clinic Duty: -" [15:35:27] :/ [15:35:36] Oh, there we go. [15:39:02] hi folks, i was wondering whether it was possible to create a query asking about items of different 'subproperties'. perhaps you that are more experiened with sparql than me know a way to do it. [15:39:02] let me explain... [15:39:02] the property i'd like to use to retrieve (in this case) human is 'location'. so i'd like to obtain ppl born, dead, lived, educated at, worked... in a particular place. should I write the query concatenating all the subproperties or can I write 'located' with a specific sign to make it more loose? at the same time i'd like to know the subproperty that brought this item to the results. is it possible to write queries that open l [15:39:04] ike this? [15:46:15] marmick: Are the properties somehow linked together? Than you can query for it [15:46:57] marmick: https://www.wikidata.org/wiki/Property:P19 looks like this is a subproperty of location so you can look for that [15:47:06] yes, they are all subproperties [15:47:09] of location [15:47:37] https://www.wikidata.org/wiki/Special:EntityData/P19.rdf is sometimes useful for figuring out what you want in sparql [15:47:44] i would like to ask "all people that X-location in There" [15:47:55] and X-location could be 'born in', 'worked at', etc. etc. [15:48:03] without having to specify all the subproperties one by one [15:48:37] in the query [15:48:38] ok [15:49:49] for instance, work location (P937), born at (P19), etc. there are several [15:51:08] here's with 'born in' (https://pastebin.com/dFQfBzTx) [15:51:45] but it does not work if i use 'located at' (https://www.wikidata.org/wiki/Property:P276), because it is too general... [15:52:09] but i would like to receive results for all the subproperties that apply (like born at) [15:52:22] (born in, worked at,...) [15:53:52] marmick: http://tinyurl.com/yb49rb36 [15:54:24] i can't see the query [15:54:48] Look at the bottom left [15:55:51] yes [15:56:09] trying to understand it now :) [15:56:48] most of them are P19 (place of birth) [15:56:57] I see! it seems to work! thansk multichill [15:57:11] It's just a start of course, but you can expand on it [15:57:24] the key is the directClaim part [15:57:30] i didn't know about this [15:58:04] So it gets the properties that are subproperty of location. The directclaim part is to get wd:P123 to wdt:P123 and the wdt:P123 part can be used again in ?someitem wdt:P123 ?target [15:58:29] yes [15:59:00] If you look in the rdf and search for "directclaim", you see the other options [16:00:50] yes [16:00:57] what if i wanted people that received a prize that was conferred by an entity located at the place? that's a bit more complicated,or, not possible? [16:04:40] i think i should look for the properties structure [16:04:57] to create the most general queries i can [16:05:06] but your query gave me the right idea, thanks! :) [16:58:41] multichill: aren't you basically talking about shape expressions in the project chat? [17:11:44] sjoerddebruin: Shape expressions? I must have missed that. Do you have a link? [17:22:09] multichill: http://shex.io [17:22:32] was discussed on Wikicite https://etherpad.wikimedia.org/p/WikiCite17Day2Session3B [17:40:50] sjoerddebruin: So we got the markup language to model this? Great, at least we have some standard to work with. But that doesn't make a tool or did someone actually already do this for Wikidata? [17:42:00] Hm, maybe https://media.ccc.de/v/wikidatacon2017-10032-using_shape_expressions_for_data_quality_and_consistency_in_wikidata?