[00:00:56] weird, with WDQS I only find 23448 P172 statements without reference [00:01:25] note the "non Wikipedia" bit [00:01:34] aaah [00:04:18] okay, now the count almost matches, slight variation probably due to definition of “non wikipedia” [00:05:20] http://tinyurl.com/jvdr56z [00:05:44] Yeah, we cleaned up sexuality some months ago. [00:05:56] oh god, another minefield [00:07:33] Alright, applied a range block for now. Will look for more things tomorrow. [08:28:00] Bonjour :) [08:28:19] salut Auregann_WMDE ! [08:29:06] Looking for nice Wikidata catch phrases this morning, but everything seems to exist already ^^ [08:29:37] (we will make Wikidata tote bags \o/) [08:30:28] Auregann_WMDE: I like the french topic [08:30:38] "The night is dark and full of statements" [08:30:39] :p [08:31:06] Yeah, I keep this one in my mind ;) [08:31:21] Auregann_WMDE: or the one on my userpage (credit to Meneldur) : "longtemps je me suis couché-e de bonne heure, et puis j'ai découvert Wikidata" [08:31:29] French litterature for the win! [08:32:01] Harmonia_Boulot: this one is neat but too long for a tote bag x) [08:32:23] *sad face* [08:33:14] what do you have in mind for now? [08:34:25] I plan to put the logo + Wikidata, so I was looking for a short slogan to add before or after [08:34:42] I thought about "in data we trust" but there is already a book named after that [08:35:02] ooh, catchy [08:35:15] let's love data? [08:35:57] the "data love" theme already belongs to our friends from Open Knowledge Foundation, we don't want to be too similar to them :) [08:36:07] hmm [08:36:27] the world is data? [08:36:32] or just "we make [logo] Wikidata" [08:36:47] less catchy [08:36:54] data is everywhere [08:37:04] expect us :p [08:38:14] I [edit] Wikipedia --> I ?query Wikidata [08:38:32] I structure knowledge [08:38:36] expect ontologies [08:38:37] pour les sparql junkies [08:38:51] I love this one [08:39:03] :D [08:39:04] i want a t-shirt with this one [08:39:13] * Auregann_WMDE takes note [08:39:29] I want to go to wikimania with a different wikidata t-shirt everyday :p [08:39:49] (but i'll probably have to add other wikimedia projects for now) [08:39:53] Challenge accepted :p [08:40:01] YAY [08:40:59] * Harmonia_Boulot happily rock on her chair [08:41:00] My favorite for now (for the bag) is "I structure knowledge" [08:41:18] yes, not too bad [08:41:31] and bigger than just "data" [08:41:42] it's the core of our work after all [08:45:04] Auregann_WMDE: I invade Wikipedia :p [08:45:09] (sorry, I'm trolling) [08:45:16] (it's the morning) [08:45:27] ...and Wiktionary :D [08:45:32] hem O:) [08:45:52] and Commons 3:) [08:45:57] Wikidata: the silent invasion [08:46:07] the data invasion [08:46:18] date of birth: Jesuit [08:46:33] structured data army [08:46:41] (but probably doesn't make sense if you didn't follow the absurd debate on the French WP) [08:46:46] oh yes ! [08:46:54] all for structured data army! [08:47:45] and we even thought with Ash_Crow that the new pin's are a little military-like [08:47:55] with just the logo without text [08:49:09] I don't know if we want too much of military metaphors x) but yeah [08:49:43] yeah, probably should go something more along the line of "Dumbledore's army" than any real army [08:50:27] structured data crew [08:50:32] better [08:52:19] watch your infoboxes, Wikidata is coming [08:52:49] XD [08:53:00] but it's more than just infoboxes [08:53:08] we are doing tables, lists... [08:53:23] graphs [08:53:26] maps [08:53:44] just 'Wikidata is coming"? [08:53:45] Harmonia_Boulot: if you find a slogan with a private joke about Firefly I print this one for you too :D [08:53:55] ooooh <3 [08:58:05] I'm kinda stuck on "wikidata: we are doing the impossible, and that make us mighty" [08:58:11] but too long [08:58:49] nice but a bit long yeah [09:00:09] or just "You can't stop the data" [09:00:28] but not sure many people will think of Serenity with that one [09:01:34] but then that's a double reference with "you can't stop the beat" from Hairspray x) [09:01:49] ^^ [09:02:29] I let you think about it ^^ [09:05:42] Auregann_WMDE, Wiki Loves Data is probably too obious? [09:06:36] edo_wtf: no, that's a good one. We usually use this pattern for events [09:09:10] Auregann_WMDE: You can't take data from me [09:09:24] Auregann_WMDE: with music symbols around [09:09:36] for the Firefly one :p [09:10:56] Harmonia_Boulot: neat :) [09:11:04] :) [09:11:31] Auregann_WMDE: I accept to go to Wikimania with only Wikidata and Firefly t-shirt :p [09:12:03] Harmonia_Boulot: Genre :p [09:12:34] ^^ [11:07:02] You can't take data away from me ... (sounds like ... you can't take that away from me) [11:07:34] or WIKI + DATA = WikiData [11:07:59] edo_wtf: https://www.youtube.com/watch?v=7DiWxcilWtU [11:33:11] need one help [11:36:47] hello naveenpf can you explain what it is about? [11:37:28] I am trying to map 15 National highways which are mapped and wikidata linked [11:37:30] https://en.wikipedia.org/wiki/User:Naveenpf/sandbox [11:37:38] it is showing json error [11:38:37] About 15 primary NHs (nh no below 100) are mapped and linked from OSM. [11:39:02] CMs in India i could map [11:39:03] https://en.wikipedia.org/wiki/User:Naveenpf/sandbox#/maplink/3 [16:06:03] hey folks. Is there a table that stores the relationship between Qids and Pids (statements)? [16:06:15] Essentially, I'm looking to be able to track what properties are used on what items? [16:07:55] There's over a hundred million of those, you know [16:08:04] :P [16:08:14] As is true of most interesting things in wikimedia wikis [16:09:31] I don't know if the database stores that directly. I don't know what schema changes Wikibase does. Wikidata entities are JSON blobs in the database and most sophisticated querying is made possible by the content being output as RDF as well, where it is tapped by Blazegraph. [16:10:26] You can in theory construct a query that says "give me all statements" but the query service might time out. [16:11:59] not what I want to do [16:12:09] But yeah, I agree that all items are JSON blobs [16:12:52] (I am glad we agree on facts?) [16:14:08] You could consider querying each property piecemeal. [16:16:13] https://query.wikidata.org/#select%20%3Fi%20where%20%7B%20%3Fi%20p%3AP20%20%3Fq%20%7D << here, all items that have P20 [16:16:37] https://query.wikidata.org/#select%20distinct%20%3Fi%20where%20%7B%20%3Fi%20p%3AP20%20%3Fq%20%7D << and this is the same query but with "select distinct" if you don't want duplicates [16:16:50] I tried this with p31 ('instance of') and it expectedly times out [16:18:01] I guess you could use linked data fragments… [16:51:40] WikidataFacts, what are "linked data fragments"? [16:52:23] halfak: you pass the server a single triple, e. g. ?subject wdt:P31 ?object, and it sends you a stream of results (paginated) [16:52:37] instead of collecting all results at once – so it’s much cheaper for the server [16:52:38] https://lists.wikimedia.org/pipermail/wikidata/2016-December/010054.html [16:52:56] Oh I see. [18:04:57] Petscan stopped working ... does everyone have the same thing happening ? [18:06:11] weird it does work in Firefox and stopped working in Chrome [19:02:06] I cannot use my old saved petscan [19:02:13] in either of the two [19:10:14] WHat is the longest time it takes for a category to synchronize with Wikidata? [19:20:05] Rodejong what do you mean ? [19:20:22] there is nothing happening automagically here [19:20:33] it could do but it does not [19:22:15] Kategoriseringen udføres af Skabelon:Wikidata-emne. This template gets data from Wikidata, fills it in the infobox. If the label is in another language than Danish, it should give a note below in the article. I change the labels to danish, but they still show in the category [19:22:15] https://da.wikipedia.org/wiki/Kategori:Oplysninger_fra_Wikidata_p%C3%A5_et_andet_sprog_end_dansk [19:22:59] It's now 7 hours ago that I changed the first one, but it still shows up, as if the Infobox has labels that are not in dansh [19:23:03] Danish* [19:23:37] ''1 Night in Paris'' [19:24:20] But as you can see here: https://da.wikipedia.org/wiki/1_Night_in_Paris [19:24:40] The Category doesn't show. [19:27:06] hi [19:27:48] https://www.wikidata.org/w/index.php?title=Q28740157 could you please restore this, it obviously acceptable