[11:20:50] Hi, can anyone tell me, can the Wikidata software, not the data, also be set up on one's own LAMP server, does it make sense at all to do so? I am thinking about what would be a good platform for a database of human rights related cases, how to ensure that it remains reusable, extensible and maximally language-neutral. I wonder if Wikidata would be something to look into. [11:22:49] that’s absolutely possible, yes (the software is called Wikibase) [11:23:34] there’s some information at http://wikiba.se and https://www.mediawiki.org/wiki/Wikibase [11:25:11] Lucas_WMDE, thanks! Would you say it makes sense? Are there use case documented somewere? [11:26:08] yes, there are some existing use-cases [11:26:12] I just don’t know where they are [11:26:41] AFAIK Jens Ohlig would be the best person to talk to about this, but he doesn’t seem to be online right now [11:28:26] Lucas_WMDE, thanks, I tried to call the WMDE office, but the number in the contacts seems to be out of service. [11:31:26] Lucas_WMDE, sent him a friends request on Facebook... [11:55:12] Hi folks [11:55:17] https://stackoverflow.com/questions/52497634/how-to-filter-objects-by-property-on-wikidata-using-sparql [11:55:25] I've just asked this question [11:55:40] Couldn't find soluction for 2 hours [11:55:45] solution* [11:56:17] What was really odd is that here I found nothing too: https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples#Most_beautiful_villages_of_France [11:56:28] pp[s [11:56:43] oops I meant this: https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples [12:09:33] OnkelTem: change "Canada" to "Canada"@en [12:10:21] P1448 is a monolingual text property (where the value consists of a text string and a language) and those are always language-tagged strings in sparql [12:12:31] it's also possible to do ?country wdt:P1448 ?official_name filter (str(?official_name) = "Canada" if you don't know the language, but that is slower [12:14:24] I see... [12:14:35] Incredible [13:49:23] nikki: if you're still here... Why does it return two rows: [13:49:25] https://query.wikidata.org/#SELECT%20DISTINCT%20%3Fcountry%20%3Fofficial_name%20WHERE%20%7B%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3Fcountry%20wdt%3AP31%20wd%3AQ6256.%0A%20%20%3Fcountry%20wdt%3AP1448%20%3Fofficial_name.%0A%20%20%3Fcountry%20wdt%3AP1448%20%22Canada%22%40en.%0A%7D%0ALIMIT%20100 ? [13:49:31] Oh sorry. I should have used some shortener [13:49:45] https://goo.gl/DoWHm8 [13:57:14] OnkelTem: I can't tell you *exactly* why, but it's somehow because you have two lines starting with `?country wdt:P1448` [13:57:41] OnkelTem: instead of ?country wdt:P1448 "Canada"@en, try VALUES( ?official_name ) { ( "Canada"@en ) }. [13:58:18] OnkelTem: that provides a (singleton) set of values to use for ?official_name [14:00:14] to get multiple countries, try VALUES( ?official_name ) { ( "Canada"@en ) ( "Stato italiano"@it ) }. [14:00:19] etc [14:01:25] you can use less punctuation too: values ?official_name { "Canada"@en "Stato italiano"@it } [14:02:14] ah, much nicer. i'm still learning sparql myself. [14:02:52] it seems like any other language, no matter how good you get, there's always more to learn :D [14:03:52] and there's pitfalls that bite you even after years... yea [14:12:49] Great! Thanks folks [14:13:13] I'm so excited to discover this wikidata. Didn't know about it before [15:56:40] IRC office hour is taking place in 6 minutes on wikimedia-office :) [15:57:23] \o/ [15:57:27] #wikimedia-office [15:57:32] oops, forgot the /join :D [16:30:26] hello there! are there some wikidata admins? [16:31:20] yes [16:31:39] Hi! Thank you for answering me! [16:31:44] yw [16:33:12] I would like to ask something in regard deleting items: I have created some items for testing, but i would like to upload many more with the quickstatements tool. And some of them (like 10 items) would be double if i do so. [16:33:45] I thought it would be better to delete the old ones [16:33:45] you should not create items for testing, there is test wikidata for that purpose [16:34:06] It was some time ago [16:51:13] Ok, so I will update them by hand. They are not badly created (not rubish just for "testing"), I just created them some time ago. "testing" was just said too fast. By! [17:09:38] Hi Lucas_WMDE , https://gerrit.wikimedia.org/r/#/c/mediawiki/extensions/Wikibase/+/462153/ can probably be merged :) [17:10:11] ok :) [17:13:12] Lucas_WMDE: thanks :) [17:40:48] woo-hoo! :P [17:54:36] hoo: when are we getting fresh suggestions again? [17:56:22] Hopefully later this week [17:56:54] Great [18:09:24] mmm... why can't https://gerrit.wikimedia.org/r/#/c/mediawiki/extensions/Wikibase/+/462153/ be merged? [18:15:27] no idea… let's try again… [19:27:55] Folks, where can I get a clear reference of functions that I can use in SPARQL queries? [19:28:17] I mean some simple reference [19:32:53] OnkelTem: https://www.wikidata.org/wiki/User:Ijon/Queries is a great guide for SPARQL beginners [19:35:42] aharoni: thank you! [19:36:16] aharoni: I cannot figure out how to limit results for a give language. I thought I already did with bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" [19:36:27] oh, sorry, the question was for all [19:39:00] For example, if I need to get the link to a country Wikipedia page, I do: http://tinyurl.com/yb9wf49r [19:39:53] you can select a particular wiki using ?sitelink schema:isPartOf . [19:40:01] (for enwiki, change the url for others) [19:41:48] and you probably want ?sitelink schema:about ?country . rather than ?sitelink schema:about wd:Q52 . [19:45:53] nikki: yes thank you :) [20:02:58] Guys, how to get all properties of an object? For example, this is a page for Nothern Ireland: https://www.wikidata.org/wiki/Q26 [20:03:10] I would like to see all the properties that I can query [20:03:26] But there is no even "official name" [20:24:51] https://www.wikidata.org/wiki/Special:ListProperties [20:26:41] Reedy: so if I see a page I need to determine its type first? Say this one is of which type: https://www.wikidata.org/wiki/Q26 ? [20:27:05] It's type? [20:27:37] Reedy: well you linked this https://www.wikidata.org/wiki/Special:ListProperties And I asked how can I get a list of properties of country? Of the country [20:27:57] So I thought that if the country is an entity of some type then... well, I can get all the properties or fields and that entity [20:28:12] of that entity* [20:31:31] That's a list of all properties that you can potentially query for any and all items [20:31:43] "instance of" would presuambly be the type [21:09:09] hi, several users of OSM Wiki has complained after installing Wikibase that the autocomplete searchbox now only shows wikibase items, not the titles of the regular pages. Is that a setting somewhere? [21:44:44] yurik: you might need to ask again during european daytime, I don't think anyone's around right now :/ [21:45:02] thx nikki