[01:07:59] <heyoni>	 nikki: you were right about the v prefix!
[13:15:41] * audephone waves 
[13:18:18] * audephone wonders if Lydia or anyone can check special nearby and see if the sorting of items or anything is strange? 
[13:20:03] <Harmonia_Amanda>	 strange how?
[13:21:18] * audephone is in NYC and some of the items are somewhat nearby
[13:21:30] <audephone>	 But others not so much
[13:22:11] <audephone>	 Like things in new jersey which is sort of nearby but there definitely are closer items
[13:22:36] <audephone>	 And things in Brooklyn and Harlem 
[13:23:20] <audephone>	 I know work is being done to upgrade elasticsearch to newer version
[13:24:36] <audephone>	 Nearby on English Wikipedia seems also broken
[13:24:37] <multichill>	 audephone: Hi phony aude!
[13:24:45] <audephone>	 :)
[13:25:18] <multichill>	 Do you know if the type of a property is also in sparql aude?
[13:25:40] <multichill>	 I want to get a list of humans without gender sorted by number of external-id properties (descending)
[13:25:41] <audephone>	 I don't know
[13:26:55] <audephone>	 I would need to look at the code or something to find out or ask Stas 
[13:31:42] <multichill>	 Found it!
[13:32:09] <multichill>	 audephone: Good new, found it, bad news, your ontology is outdated :P
[13:32:16] <audephone>	 Oh noes
[13:32:31] <sjoerddebruin>	 Special:nearby seems different yeh
[13:33:04] * audephone hopes it is easy fix
[13:34:22] <WikidataFacts>	 audephone: what’s your query? I tried to write one but it runs into the time limit: https://gist.github.com/anonymous/3e9cdc32a9f0a7975947ef8f0754ddd8
[13:36:54] <audephone>	 WikidataFacts im asking about special nearby
[13:37:06] <WikidataFacts>	 oh, sorry, I meant multichill
[13:37:09] <audephone>	 Yeah
[13:37:42] <sjoerddebruin>	 nothing was changed in the mobilefronted repo on that area
[13:38:26] <audephone>	 There probably are changes in geodata extension 
[13:38:43] <multichill>	 WikidataFacts: What are you trying to do exactly?
[13:38:47] <audephone>	 Or something not changed that needs to be 
[13:39:29] <WikidataFacts>	 multichill: "a list of humans without gender sorted by number of external-id properties" – perhaps I misunderstood your question?
[13:39:49] <multichill>	 Oh right! Yeah :-)
[13:40:07] <sjoerddebruin>	 Maybe https://gerrit.wikimedia.org/r/#/c/292047/
[13:41:34] <audephone>	 Possible 
[13:41:54] <sjoerddebruin>	 the results that are still showing could be cached
[13:42:07] <sjoerddebruin>	 let me try to purge one of them still showing here
[13:42:23] <audephone>	 It's same problem on English Wikipedia 
[13:43:36] <sjoerddebruin>	 that doesn't hide them
[13:43:39] <audephone>	 Nearby on android looks ok but it's the map display
[13:43:57] <audephone>	 And doesn't have sorting the same way
[13:44:23] <sjoerddebruin>	 It used to show max to 500m here due to all the dutch streets
[13:44:30] <sjoerddebruin>	 now the bottom item is 10km away
[13:44:51] <audephone>	 Definitely not right
[13:47:07] * audephone back maybe in an hour and can look into this
[13:54:06] <multichill>	 WikidataFacts: I tried changing the query, it still times out.....
[13:57:15] <multichill>	 http://tinyurl.com/z3c828g
[13:57:57] <WikidataFacts>	 oh, I didn’t know about propertyType
[13:58:13] <multichill>	 That was the thing I just dug up
[13:58:21] <WikidataFacts>	 and yet it’s still too expensive without the wdt:P31/wdt:P279* chain? wow
[13:58:21] <stashbot>	 P31 Fork of P29 (An Untitled Masterwork) - https://phabricator.wikimedia.org/P31
[13:58:21] <stashbot>	 P279 404 and 500 error pages - https://phabricator.wikimedia.org/P279
[13:59:26] <multichill>	 Yeah, it's confusing. If you remove the whole count thing it still times out
[14:02:13] <WikidataFacts>	 even just counting all humans without sex or gender is too expensive: https://query.wikidata.org/#SELECT%20(COUNT(%3Fhuman)%20AS%20%3Fcount)%0AWHERE%0A%7B%0A%20%20%20%3Fhuman%20wdt%3AP31%20wd%3AQ5.%0A%20%20%20MINUS%20%7B%20%3Fhuman%20wdt%3AP21%20%5B%5D.%20%7D%0A%7D
[14:02:33] <multichill>	 yup
[14:35:05] <multichill>	 WikidataFacts: I might take a different approach. I think I'm just doing a tradtional SQL query to find humans that pop up in most constraint reports
[16:38:06] <JohnC_>	 Hi  Is there a way to search for a specific value for a specific property? I'm checking that all the Biosphere Reserves have been imported properly and I know a couple are missing, I have a couple that I suspect that are missing, is there a way to search by a value for a property? Specifically I would like to search for a value that is a URL of the Property UNESCO Biosphere URL.
[16:46:26] * aude broke wikidata :( or more likely hit a specific bug
[16:48:43] <Harmonia_Amanda>	 aude :s
[16:49:17] <aude>	 now it works
[16:56:06] <yurik>	 hi, pls support/review the email i just sent to wikitech-l -- enabling shared data namespace for tabular data
[16:56:10] <yurik>	 aude^ :)
[16:57:21] <aude>	 yurik: ok