[00:05:44] Even the JSON document goes nuts, the 'descriptions' is now an array and not an object anymore [00:12:23] The property P107 in it now doesn't have a "datatype" value either. Eh, who needs those anyway. [00:41:26] Papierkorb: looks like someone restored a really old version of the item :/ should be fixed now [00:41:55] nikki: It broke my transform process too. 80 minutes of my cpu heating the room :D [00:43:19] well that's one way to keep warm :D [01:48:58] oki, now you can use wikidata query directly in the premade graphs - should be much nicer/cleaner for everyone :) [01:49:29] can someone suggest a good wikidata query that has a year/date column, and several value columns that can be shown as lines? [01:49:30] https://www.mediawiki.org/wiki/Template:Graph:Lines [01:49:47] cc: SMalyshev [02:08:33] Hello. Can anyone help me with queries? [02:11:34] wikidata092, depends, you should post a link to your query (use tinyurl at the top right), and there might be someone to elp [02:12:50] I just want to know how to write "items that have not P2002" and "item that have at least one value in P2002" [02:14:29] wikidata092, items that don't have something is probably be too many, won't it? [02:14:36] you should severelly restrict it [02:15:30] as for items that have somethig -- in the where clause you would have ?item wdt:P2002 ?value . [02:16:39] Yes. I have more things to search with. For example, P31 with Q2222 etc [02:17:46] wikidata092, this might help? http://stackoverflow.com/questions/7097307/selecting-using-sparql-based-on-triple-does-not-exist [02:19:28] Do you know how to change ?item wdt:P2002 ?value to be "items that have not P2002"? [02:23:31] wikidata092, see the link above -- MINUS { ?item wdt:P2002 ?value . } i guess [02:27:04] Great. Is there a way to limit it to the items that have links to el.wiki? [02:58:50] I want to add at P856 quallier P407 with anyvalue. [02:58:56] https://query.wikidata.org/#%23Cats%0ASELECT%20%3Fitem%20%3FitemLabel%0AWHERE%0A%7B%0A%09%3Fitem%20wdt%3AP31%20wd%3AQ476028%20.%0A%20%20%09%3Fitem%20wdt%3AP17%20wd%3AQ21%20.%0A%20%20%20%20%3Fitem%20wdt%3AP856%20%3Fvalue%20.%0A%09SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22el%22%20%7D%0A%7D [02:59:01] Is that possible? [03:13:57] wikidata092, i am really bad with the query language - only know some basics, so not sure. My only suggestions is to take a look at the Help menu at the top of the query [03:14:04] there are a few good help links [03:14:26] Ok. Thanks for you help! [11:16:51] now when I search for "male", the right result is third >_< [11:17:21] it was bad enough that Malé kept being the top result, but now even "male creature" is somehow deemed more likely >_< [11:52:21] Aleksey_WMDE: https://doc.wikimedia.org/cover/ [17:48:02] multichill, hi, did you see the lines graph? [22:06:13] Is there a way to find out of any given item if it's a town or a person or whatever? Currently looking for 'town' [22:15:47] Papierkorb: you would need to look for P31 (instance of) statements with the value set to Q3957 (town) [22:16:20] nikki: I want to find any place that is a village/town/big-town/whatever [22:16:41] city too [22:18:02] you could use the query service to find all subclasses of human settlement, like https://query.wikidata.org/#select%20%2a%20where%20%7B%0A%09%3Fitem%20wdt%3AP279%2a%20wd%3AQ486972%0A%7D and then check for P31 set to any of those values [22:22:43] (and https://www.mediawiki.org/wiki/Wikidata_query_service/User_Manual#SPARQL_endpoint might help too if you want to write something which fetches results from the query service)