[00:02:05] ok, I have a set of csvs that list the current state & location of our data [00:02:22] working on a google doc of that now.... [00:06:11] b5++ [00:07:50] b5 to the rescue [00:08:37] everywhere I go, there is abergman [00:11:08] https://docs.google.com/a/qri.io/spreadsheets/d/1Xi2v6-0H-EZdVss8b-u5a_Dt3F5a32RFASntchishCg/edit?usp=sharing [00:13:04] b5 can you make it public? [00:13:24] this is just like that Sting song, b5 [00:13:33] b5++? more like b6 [00:14:36] ok will make public [00:16:08] nice, thanks [00:19:33] we have a little more metadata than this, but not too much. each sheet should correspond to the phase of completion for urls [00:20:14] this is a nice reminder that I need to fix that auto-exporter script... [00:26:19] I left a query here: https://www.wikidata.org/wiki/Wikidata:Project_chat#Data_type_query:_Tracking_links_to_archived_datasets [00:54:29] me [01:21:36] heading out. will check in w okfn folk also [05:15:51] PROBLEM - High lag on wdqs1002 is CRITICAL: CRITICAL: 52.94% of data above the critical threshold [1800.0] [05:16:21] PROBLEM - High lag on wdqs1003 is CRITICAL: CRITICAL: 66.67% of data above the critical threshold [1800.0] [05:18:51] PROBLEM - High lag on wdqs1002 is CRITICAL: CRITICAL: 42.86% of data above the critical threshold [1800.0] [05:19:21] PROBLEM - High lag on wdqs1003 is CRITICAL: CRITICAL: 55.56% of data above the critical threshold [1800.0] [05:29:21] PROBLEM - High lag on wdqs1003 is CRITICAL: CRITICAL: 45.45% of data above the critical threshold [1800.0] [05:29:51] RECOVERY - High lag on wdqs1002 is OK: OK: Less than 30.00% above the threshold [600.0] [05:33:21] RECOVERY - High lag on wdqs1003 is OK: OK: Less than 30.00% above the threshold [600.0] [09:31:09] What's the difference between the Wikibase extension and the Wikidata extension? [09:31:16] Wikibase is the underlying software. But what does "Wikidata" do? [09:38:28] harej: "wikidata" packages additional things we use (property suggester, constraints, etc) [09:39:23] Surely those things would be useful in Wikibase in general? [09:42:42] those are extensions to wikibase [09:43:53] not a core part and not sure we would merge them together [10:29:03] Been playing around with adding OpenStreetMap tags to Wikidata items https://www.openstreetmap.org/user/PlaneMad/diary/40537 [10:31:18] planemad: awesome [10:31:35] planemad: I added it to https://www.wikidata.org/wiki/Wikidata:Status_updates/Next [10:32:16] thank you :) [11:09:32] planemad: Nice! So far 964 tags or keys added: http://tinyurl.com/zz68fsq [11:11:08] hi [11:13:02] ooh, adding that to my post Ainali ! [11:15:57] I'm currently editing some buildings on OpenStreetMap. I usually try to add the wikidata id to objects in OSM [11:16:01] I found wikimedia commons categories with pictures of these buildings, but no wikidata entries [11:16:06] https://commons.wikimedia.org/wiki/Category:Klappergasse_3 [11:16:10] https://commons.wikimedia.org/wiki/Category:Mittlerer_Hasenpfad_5 [11:16:46] When I create new entries for these on wikidata, how can I connect the ID with commons? [11:17:05] or: are there wikidata ids which I just don't find? [11:17:14] just add the interwiki [11:17:38] like you would do for a wikipedia article [11:21:06] ah, I see. I don't have to add the id to the pictures itself as they are in the categories, right? [11:21:54] Athalis: exactly [11:22:12] you can use the pictures as values for P:picture on the item [11:22:45] but we tend to chose only one or two pictures [11:28:27] What is the property "Commons category" (P373) used for when I can add the category below in "other sites"? [11:30:24] Athalis: because there is an ongoing debate to where commons interwiki should be linked [11:30:35] ah okay [11:30:41] some says commons categories should be linked to categories items [11:30:47] thank you very much so far :) [11:31:07] and some say that commons categories are actually the main space of Commons and as such should be directly linked to the items [11:31:51] both methods are in use right now, so we have turnarounds ^^ [11:32:54] so you should use P:commons category regardless of whether or not the commons category is linked in the interwikis [11:33:14] because it's actually the most used method by templates importing data from Wikidata [11:38:14] ok I did that. I wasn't sure because it was displayed as text, only after a reload it was displayed as clickable link [11:38:51] yes, i think that's javascript? to make it clickable? [11:39:13] not sure but it's a common issue when you just add it or when the page doesn't load properly [11:39:33] you lose clickable links and sometimes "edit" buttons too [11:40:06] * Harmonia_Boulot hate low connections when she have to F5 ten times a page before it's correctly loaded [11:40:59] I didn't need 10 reloads, was there right after the first one :D [11:41:25] do you want to take a look at it? Q28824196 I also created the street: Q28824188 [11:44:24] seems good to me [11:50:38] I am trying to filter for things from today. Is there an easier way to write this?: FILTER (datatype(?d) = xsd:dateTime) FILTER (year(?d) = year(now())) FILTER (month(?d) = month(now())) FILTER (day(?d) = day(now())) [11:50:58] or shorter rather [11:53:45] I did that for people dead in the last seven days http://tinyurl.com/h6vt2ca [11:58:19] Harmonia_Boulot: thanks again, cya [16:16:31] nikki: SMalyshev: Do you know if it's possible to force the sparql service to do a query on a certain member? See https://www.wikidata.org/wiki/Wikidata_talk:WikiProject_sum_of_all_paintings#Painting_in_two_collections_merged my assumption is that members don't have the same data [16:16:46] And I'm wondering how to test that (do the same query on both servers) [16:22:51] PROBLEM - High lag on wdqs1002 is CRITICAL: CRITICAL: 100.00% of data above the critical threshold [1800.0] [16:29:51] PROBLEM - High lag on wdqs1002 is CRITICAL: CRITICAL: 100.00% of data above the critical threshold [1800.0] [17:22:05] multichill: you mean server? not externally, but I can do it manually [17:23:01] multichill: you can also look at the headers to see which server produced the response [17:28:45] ACKNOWLEDGEMENT - High lag on wdqs1002 is CRITICAL: CRITICAL: 100.00% of data above the critical threshold [1800.0] Gehel replication was stuck, but is now recovering. Investigation on T158874 [17:54:16] RECOVERY - High lag on wdqs1002 is OK: OK: Less than 30.00% above the threshold [600.0] [18:42:34] SMalyshev: https://query.wikidata.org/#SELECT%20%3Fitem%20WHERE%20%7B%20%3Fitem%20wdt%3AP170%20wd%3AQ37693%20.%20MINUS%20%7B%20%3Fitem%20wdt%3AP31%20wd%3AQ15727816%20%7D%20%7D%20LIMIT%20300 [18:42:43] Is producing different results [18:50:14] multichill: I don't think it does anymore [19:10:02] SMalyshev: You're right, looks like the edit solved it, see https://www.wikidata.org/wiki/Wikidata_talk:WikiProject_sum_of_all_paintings#Painting_in_two_collections_merged [21:04:29] Peter_b zit weer op zijn beterweter-stoel [21:39:55] PROBLEM - Disk space on wdqs1001 is CRITICAL: DISK CRITICAL - free space: / 1055 MB (3% inode=96%) [21:44:50] Hello, does anybody have an idea of why there isn't more information in the infobox on https://en.wikipedia.org/wiki/Arjen_Lenstra ? [21:45:04] there is much more on Wikidata [21:45:55] RECOVERY - Disk space on wdqs1001 is OK: DISK OK [21:46:40] rama: maybe enwiki only fetches statements with references? [21:49:05] Jup. [21:49:42] I was under the impression that the template was asked to fetch everything, and that some information was sourced anyway [21:51:11] wow, Commons has the wierdest name in Russian [21:55:44] not much online resources