[00:29:41] <yurik>	 SMalyshev, do you know why ?instanceOfLabel is blank, while ?instanceOf has a value?   http://tinyurl.com/jz6uwux
[00:30:42] <SMalyshev>	 yurik: you don't actually have ?instanceOfLabel in projection list as far as I can see
[00:31:30] <yurik>	 SMalyshev, GROUP_CONCAT(?instanceOfLabel; separator=', ') - shouldn't it be resolved to the label?
[00:31:35] <yurik>	 by the labeling service
[00:31:42] <SMalyshev>	 nope
[00:31:49] <SMalyshev>	 it can't parse complex expressions
[00:32:09] <SMalyshev>	 you need to actually mention it as a variable to be picked up
[00:32:19] <yurik>	 but i don't want to group-by it
[00:32:45] <yurik>	 SMalyshev, is there a way to force it to be generated?
[00:32:58] <SMalyshev>	 yes, write it inside the service clause
[00:33:34] <SMalyshev>	 see: https://www.mediawiki.org/wiki/Wikidata_query_service/User_Manual#Label_service
[00:33:51] <yurik>	 ?place rdfs:label ?placeLabel ?
[00:34:16] <SMalyshev>	 yes
[00:34:25] <yurik>	 SMalyshev, what if its optional?
[00:34:38] <SMalyshev>	 I don't understand
[00:35:42] <yurik>	 SMalyshev, http://tinyurl.com/zbuk4tn -- instanceOf is optional - will having it inside the service make it required?
[00:35:56] <SMalyshev>	 no
[00:37:16] <yurik>	 SMalyshev, what about other labels - the moment i mention instanceOf explicitly, the 3 labels for ?item  disappear. Do i have to now explicitly list them?
[00:37:48] <SMalyshev>	 probably... yeah if you fill in the service clause you have to specify them 
[01:05:52] <yurik>	 SMalyshev, thx, https://www.wikidata.org/wiki/User:Yurik/Admin_regions
[04:59:55] <yurik>	 is there a reason we have both P131 and P150?  Shouldn't there be just one (P131), as it makes no sense (IMO) to duplicate the link?
[09:42:33] <multichill>	 nikki: Do you know if the creation date of an item is available in SPARQL?
[09:51:54] <Thiemo_WMDE>	 multichill: As far as I'm aware of: no, it's not.
[09:52:22] <Thiemo_WMDE>	 Wait... we are exporting the relevant metadata via RDF. But I'm not sure if this is available via SPARQL.
[09:53:04] <multichill>	 https://query.wikidata.org/#SELECT%20%3Fproperty%20%3Fvalue%20WHERE%20%7B%0A%20%20wd%3AQ27895261%20%3Fproperty%20%3Fvalue%0A%7D
[09:53:10] <multichill>	 Looks like only date modified
[09:53:19] <multichill>	 Would be great to have data created in there for statistics
[09:53:45] <multichill>	 Thiemo_WMDE: Do you know if creation date is already in RDF?
[09:54:47] <multichill>	 (if not, I can file a bug for the RDF part and probably another one for the SPARQL part)
[09:55:57] <Thiemo_WMDE>	 I had a quick look at the code. It exports the latest revision and does not know about the creation date. So yes, please create tickets. Thanks!
[10:28:45] <multichill>	 Thiemo_WMDE: Created https://phabricator.wikimedia.org/T151538 , just wondering if I got the parent/child right. Parent needs to be done before a child or the other way around? :P
[10:29:33] <Thiemo_WMDE>	 Unclosed childs block a parent from being closed (in theory).
[10:29:52] <Thiemo_WMDE>	 Childs are the smaller, actiona
[10:29:58] <Thiemo_WMDE>	 …actionable tasks.
[10:30:15] <multichill>	 Confusing. I would say a parent precedes a child ;-)
[10:32:34] <Nemo_bis>	 yes, the new phabricator terminology is confusing
[10:33:50] <Nemo_bis>	 multichill: see https://phabricator.wikimedia.org/T140335
[11:14:18] <hoo>	 DanielK_WMDE: Are you ok with https://phabricator.wikimedia.org/T151356#2819574 ?
[11:14:28] <hoo>	 I wold like to get this done and deployed today
[11:14:35] <hoo>	 so that we can have json dumps again
[11:16:45] <Dereckson>	 *deployed* *today* ?
[11:17:23] <Dereckson>	 hoo: if it's not an UBN, next deployment day is Monday 28
[11:17:33] <Dereckson>	 US Holiday (Thanksgiving) on Thursday and Friday
[11:17:39] <Dereckson>	 so not a lot of ops available
[11:17:42] <hoo>	 Aw, shoot
[11:17:51] <hoo>	 Well, guess I could make it UBN then
[11:32:21] <DanielK_WMDE>	 hoo: will look in a minute
[11:45:55] <DanielK_WMDE>	 Jonas_WMDE: https://www.wikidata.org/w/api.php?action=help&modules=wbsetclaimvalue  https://www.wikidata.org/w/api.php?action=help&modules=wbsetclaim
[12:09:33] <nikki>	 planemad: you're from mapbox, right? I'm wondering about what I wrote in my comment on https://www.wikidata.org/wiki/Wikidata:Project_chat#Streets_in_Wikidata.3F
[12:11:43] <nikki>	 (basically I wondering if there's a way to query both wikidata and osm for things like that, and if not, if there's any obvious way to make it possible)
[12:13:08] <nikki>	 the only thing I can think of right now is a script which would fetch everything using the overpass api and then look up all the items and count how many... which would work fine for small amounts of data but not for large amounts
[12:46:12] <multichill>	 nikki: Do you have any experience with subqueries? I want to query to make Venn diagrams. I'm wondering what the best approach is here...
[12:49:02] <multichill>	 A = some query, B = some query, A  ∩ B for the interesct...
[12:51:43] <nikki>	 not much experience
[12:53:08] <nikki>	 I would probably try two separate subqueries with the intersection after them both
[12:55:32] <multichill>	 Any idea how to do the intersection?
[13:01:43] <nikki>	 wouldn't it be something like filter (?itema = ?itemb)?
[13:21:54] <hoo>	 Glorian_WMDE: Can you poke Daniel to come here?
[13:41:46] <planemad>	 nikki, reading up
[13:43:38] <planemad>	 nikki, there are multiple ways to get a list of street names from osm. a more challenging problem is to find which of the names are of people
[13:44:35] <nikki>	 yeah, it'd be nice to have a way to join some osm query with a wikidata sparql query
[13:47:00] <planemad>	 we've done an interesting experiment in the past to check the gender of a street name using a service called namsor https://www.mapbox.com/blog/streets-and-gender/
[13:51:12] <planemad>	 if you want a list of street names, i would recommend tile-reduce. it can crunch gbs of osm data in js and dump a list based on the logic https://github.com/mapbox/tile-reduce
[16:25:43] <abhigup>	 Can we use wikidata for chatbot implementation
[16:25:53] <abhigup>	 ?
[16:36:16] <abhigup>	 Can we use wikidata to implement chatbot?
[16:41:34] <multichill>	 abhigup: It has already been done and it's on Facebook
[16:42:46] <multichill>	 https://www.youtube.com/watch?v=en8n7Yja7kE&feature=youtu.be
[16:42:56] <hoo>	 DanielK_WMDE: Could you look into https://phabricator.wikimedia.org/T151356#2819574
[16:43:02] <hoo>	 Is that ok with you?
[16:49:02] <Thiemo_WMDE>	 addshore: are you going to fix the 6 other i18n issues the same user reported?
[16:49:21] <addshore>	 Thiemo_WMDE: oooh, I didn't spot them when I made that first patch!
[16:49:33] <Thiemo_WMDE>	 i can do it this time if you want.
[16:49:51] <abhigup>	 thanks <hoo> for response. I am just checking out
[16:50:07] <addshore>	 Thiemo_WMDE: thats would be great!
[18:55:10] <multichill>	 sjoerddebruin: I guess you have been away? https://www.wikidata.org/wiki/Wikidata:Database_reports/without_claims_by_site/nlwiki seems to be a bit stalled
[18:55:26] <sjoerddebruin>	 multichill: I was at my parents yeah.
[19:02:02] <sjoerddebruin>	 I shouldn't be the only one doing this, of course.
[19:08:33] <multichill>	 sjoerddebruin: I'm working on it too!
[19:08:56] <multichill>	 Actually, I got a bit distracted. Found a bunch of items that don't have any sitelinks or statements
[19:09:41] <multichill>	 Now running a query to see how many items we're talking about. I think about 10.000
[19:09:52] <sjoerddebruin>	 Hmmm
[19:10:05] <sjoerddebruin>	 Always merge to lowest item. :P https://www.wikidata.org/w/index.php?title=Q3264451&action=history
[19:10:44] <multichill>	 Stuff like https://www.wikidata.org/wiki/Q240603 (merge gone wrong) and https://www.wikidata.org/wiki/Q307704 (last sitelink removed)
[19:10:48] <multichill>	 Didn't we have reports for those?
[19:11:04] <multichill>	 11521
[19:11:11] <sjoerddebruin>	 We used to have a bot to redirect those...
[19:11:55] <sjoerddebruin>	 but some are undetectable due to removing also the labels and stuff
[19:13:12] <multichill>	 Might be a good additional task for https://www.wikidata.org/wiki/Wikidata:Requests_for_permissions/Bot/NoclaimsBot :-)
[19:17:29] <multichill>	 sjoerddebruin: https://www.wikidata.org/wiki/User:Multichill/Kladblok that is the list
[19:17:37] <multichill>	 I'll see if I can make something easy out of it
[19:18:24] <sjoerddebruin>	 Hmm. https://www.wikidata.org/wiki/Special:Undelete/Q4022669
[19:19:18] <sjoerddebruin>	 Wow, now I'm hitting https://www.wikidata.org/wiki/Q19962652
[19:19:46] <multichill>	 sjoerddebruin: Hitting? Why are you hitting a priest? ;-)
[19:20:02] <sjoerddebruin>	 Via https://www.wikidata.org/wiki/Q991848
[19:21:57] <multichill>	 I would like to include more information in the deletion summary automagically. Like: Empty item, last sitelink to http://en.wikipedia.org/wiki/Special:Search?go=Go&search=:xx:bladiebla was removed by http://en.wikipedia.org/wiki/Special:Search?go=Go&search=user:blaa
[19:22:34] <multichill>	 Interesting that got expanded :P
[19:23:26] <sjoerddebruin>	 If people use the gadget to move sitelinks, it will mention the new item.
[19:31:15] <sjoerddebruin>	 Ugh (Dutch descriptions) https://www.wikidata.org/w/index.php?search=&search=%224+n%2Fa%22&title=Special:Search&go=OK&searchToken=4o8jv6q4vvfmzqk2wxwz2nlij
[19:31:51] <multichill>	 sjoerddebruin: I updated https://www.wikidata.org/wiki/User:Multichill/Kladblok to include the edit summary of the last revision
[19:35:02] <multichill>	 hoo|away: Didn't you have some sort of bot to work on that ? ^^
[19:35:11] <sjoerddebruin>	 multichill: Wikidata made me hate categories like https://nl.wikipedia.org/wiki/Categorie:Muziekinstrumentbouwer that mix up companies and people.
[19:35:11] <sjoerddebruin>	 enwiki is doing it good though
[19:36:02] <multichill>	 Or publisher
[19:38:52] <multichill>	 sjoerddebruin: I'll just write some sort of regular bot to clean up and report
[19:39:53] <multichill>	 Quite a few items like https://www.wikidata.org/wiki/Q25768334
[19:40:40] <sjoerddebruin>	 https://www.wikidata.org/w/index.php?limit=50&title=Special%3AContributions&contribs=user&target=Atudu&namespace=&tagfilter=&newOnly=1&year=2016&month=-1
[19:41:53] <multichill>	 Yup, seems to have done that for quite some time
[19:42:07] <multichill>	 Can you leave him a nice message?
[19:42:20] <sjoerddebruin>	 Her*
[19:42:33] <multichill>	 Or her
[19:43:18] <multichill>	 Can probably tag a bunch of them as taxon
[19:43:31] <sjoerddebruin>	 They still don't have a notablity then though
[19:44:41] <multichill>	 Yeah, but at least the taxon people will have a shot at it
[19:45:14] <sjoerddebruin>	 Seems like typing errors though.
[19:45:15] <sjoerddebruin>	 https://www.wikidata.org/wiki/Q27300785
[19:45:22] <sjoerddebruin>	 https://www.wikidata.org/wiki/Q2716758
[19:52:13] <multichill>	 Amir1: Any idea why your bot did this edit and why it didn't set an edit summary? https://www.wikidata.org/w/index.php?title=Q19269140&type=revision&diff=352205988&oldid=207246350
[19:56:00] <Stryn>	 :O https://www.wikidata.org/w/index.php?limit=200&title=Special%3AContributions&contribs=user&target=Dexbot&namespace=&tagfilter=&year=2016&month=6
[19:56:14] <sjoerddebruin>	 ;_;
[19:59:33] <multichill>	 Yeah, a whole bunch of those edits
[20:18:53] <Amir1>	 multichill: hey, let me check. that looks strange
[20:19:43] <multichill>	 Amir1: [20:56] <Stryn> :O https://www.wikidata.org/w/index.php?limit=200&title=Special%3AContributions&contribs=user&target=Dexbot&namespace=&tagfilter=&year=2016&month=6
[20:21:35] <Amir1>	 multichill: Stryn All of them are disambig pages in plwikiquote 
[20:21:53] <Amir1>	 probably the bot wanted to merge the sitelinks with another item but got left out somehow
[20:22:04] <Amir1>	 this is for a very long time, It's a blur 
[20:22:48] <Amir1>	 in wikimania time, probably someone asked for it there
[20:24:57] <Amir1>	 e.g. this is correct: https://www.wikidata.org/w/index.php?title=Q15264253&diff=prev&oldid=352204815 this is disambig in surname item
[21:24:00] <multichill>	 Amir1: Whole bunch of them are at https://www.wikidata.org/wiki/User:Multichill/Kladblok
[21:24:05] <multichill>	 No sitelinks, no statements
[21:30:56] <Krinkle>	 Someome familiar with wikidata/interwiki/sites table - https://phabricator.wikimedia.org/T126146#2819350
[21:36:51] <multichill>	 Joy, the no/nb problem. 
[22:57:10] <nazer>	 #wikidata