[01:49:24] <YairRand>	 Q: Is there any way for a wikidata query to access tabular data on commons? or a list of wiki pages? or a wiki page's content?
[07:48:32] <rom1504>	 I'd say the point of wikidata is to make that data available, so no
[10:27:47] <amisha>	 Hi folks, what's a good way to optimise this sparql query?  http://tinyurl.com/j4qpfgu
[11:12:11] <amisha>	 Hi people, I am trying to find out wikidata items which belongs to subclass of Human settlement, in vicinity of London. But the sparql query is giving me timeout. Is there a way to rescontruct / optimise the query ? 
[11:12:30] <amisha>	 Here's the query : http://tinyurl.com/j4qpfgu
[11:13:19] <nikki>	 I was just trying, but it looks like another case where two things it can do quickly time out when combining them :(
[11:14:06] <nikki>	 it can find everything within 80km of london in about 3 seconds, it can find all human settlements in about 3 seconds, but the subset of those two? nooo that's way too hard
[11:22:00] <amisha>	 That is weird, nikki . Rather combination  should be fast. As it will give us less items
[11:23:23] <nikki>	 you'd think so, yeah. I really don't understand how it works, the things which seem like they would be hard or time consuming, it can do easily and the things which seem like they should be easy, it often finds hard
[11:25:38] <nikki>	 oh! adding "hint:Query hint:optimizer "None" ." after the "where {" seems to help
[11:26:18] <nikki>	 heh now it looks like england has measles :P
[11:28:31] <amisha>	 oh man yes. what's this magic? : )
[11:32:01] <amisha>	 Thanks a lot nikki btw, \o/
[11:32:04] <amisha>	 : )
[11:32:16] <nikki>	 you're welcome :)
[11:32:25] <nikki>	 I'm glad I could find something that worked
[11:34:33] <nikki>	 you might want to add the query to https://www.mediawiki.org/wiki/Wikidata_query_service/Problematic_queries#Optimizer_failures
[11:37:20] <amisha>	 Yep, Adding to it : )
[12:20:59] <Ainali>	 I started some work with buildings ad their constructions but ran in to a wall of mess
[12:21:24] <Ainali>	 Tried to visualize it a bit http://tinyurl.com/h47folf
[12:22:04] <Ainali>	 Ah, labels in English first: http://tinyurl.com/hvz9ojh
[18:12:58] <sjoerddebruin>	 addshore: https://grafana.wikimedia.org/dashboard/db/wikidata-datamodel-terms?var-lang=All doesn't update anymore.
[18:13:06] <addshore>	 oooh
[18:13:20] <addshore>	 sjoerddebruin: can you file a ticket please? :)
[18:13:28] <sjoerddebruin>	 (and don't know if you saw my report of "ar" being default language all the time)
[18:13:32] <addshore>	 I may have to migrate that data to come from the dump instead of the databases
[18:13:41] <addshore>	 I also didnt see that!
[18:14:06] <sjoerddebruin>	 Should I dump both on your workboard?
[18:17:28] <sjoerddebruin>	 Oh wait, found "WMDE-Analytics-Engineering".
[18:23:11] <addshore>	 =]
[18:32:56] <addshore>	 sjoerddebruin: I fixed the ar one! :)
[18:33:03] <sjoerddebruin>	 <3