[08:57:44] PROBLEM - High lag on wdqs1009 is CRITICAL: 3630 ge 3600 https://grafana.wikimedia.org/dashboard/db/wikidata-query-service?orgId=1&panelId=8&fullscreen [08:58:44] PROBLEM - High lag on wdqs1010 is CRITICAL: 3605 ge 3600 https://grafana.wikimedia.org/dashboard/db/wikidata-query-service?orgId=1&panelId=8&fullscreen [09:21:28] hush lag [09:25:14] RECOVERY - High lag on wdqs1009 is OK: (C)3600 ge (W)1200 ge 898 https://grafana.wikimedia.org/dashboard/db/wikidata-query-service?orgId=1&panelId=8&fullscreen [09:33:55] RECOVERY - High lag on wdqs1010 is OK: (C)3600 ge (W)1200 ge 51 https://grafana.wikimedia.org/dashboard/db/wikidata-query-service?orgId=1&panelId=8&fullscreen [13:35:07] Suppose I have a list of ISNI and an (to-be-imported) external-id list to import to WD, is there any (already existing) tool to help me importing them in a batch? [13:38:08] revi: https://www.wikidata.org/wiki/Help:QuickStatements [13:38:41] thanks, I'll look into it [13:38:49] (tho I need to get that actual list first lol) [13:39:02] revi: at the bottom there's a link to a tool that can ingest CVS directly [13:39:10] CSV I guess [13:40:05] o/ [13:40:41] Looks like I need to know the Qids, hmmmmmm [13:41:03] \o [13:41:37] revi: yes, establishing the mapping is the hard part, always! [13:42:04] hmm yeah 140000 hand-mapping time [13:42:33] s/140000/max 500000 [13:42:55] I don't think all 500000 has sitemap tho but anyway [13:43:01] sitemap/sitelink [13:43:02] damnit typo [13:44:12] revi: https://query.wikidata.org/#SELECT%20%2a%20WHERE%20%7B%0A%20%20%20%20%3Fobj%20wdt%3AP213%20%3Fid.%20%0A%7D%0ALIMIT%20100 [13:44:20] uh awesome [13:44:30] I still can't follow all the new features [13:44:37] you can look up items by ISNI. I don't know a good way to look up *many* items by ISNI, though [13:46:49] I'm approached by National Library of Korea for importing http://www.nl.go.kr/authorities?language=en (for Wikipedia use, but { {Authority Control} } loads from Wikidata, so...) to Wikidata, they at least have ISNI so I was thinking I could import it by mapping ISNI and Qids [13:47:13] revi https://query.wikidata.org/#SELECT%20%2a%20WHERE%20%7B%0A%20%20%20%20%3Fobj%20wdt%3AP213%20%3Fid.%0A%20%20FILTER%20%28%20%3Fid%20IN%20%28%20%220000%200000%205933%203783%22%2C%20%220000%200000%205550%206835%22%20%29%20%29%0A%7D%0ALIMIT%20100 [13:48:54] DanielK_WMDE, revi: more efficient https://query.wikidata.org/#SELECT%20%2a%20WHERE%20%7B%0A%20%20VALUES%20%3Fid%20%7B%0A%20%20%20%20%220000%200000%205933%203783%22%0A%20%20%20%20%220000%200000%205550%206835%22%0A%20%20%7D%0A%20%20%3Fobj%20wdt%3AP213%20%3Fid.%0A%7D%0ALIMIT%20100 [13:51:13] Lucas_WMDE: what would be a giood way for revi to get a full list of the ISNI-to-Q-id mapping? [13:51:29] oh, right, the values syntax is much better [13:51:31] I wonder if *this* is a place where openrefine would work [13:51:43] I'm still trying to work out when it would be useful [13:51:48] nikki: good idea, it should! [13:51:56] probably, yes [13:52:11] [[WD:OpenRefine]], right? [13:52:11] 10[1] 1010https://www.wikidata.org/wiki/Wikidata:Tools/OpenRefine - Redirección desde 10https://www.wikidata.org/wiki/WD:OpenRefine?redirect=no [13:52:13] Lucas_WMDE: i keep forgetting the name of the cached-pages-of-triples http interface. [13:52:24] DanielK_WMDE: linked data fragments? [13:52:32] yea, that one! [13:52:48] do we still have that? [13:52:55] seems so, I think? [13:53:00] it'S not mentioend on https://www.wikidata.org/wiki/Wikidata:Data_access#SPARQL_endpoints nor on https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service [13:53:10] that would be an easy way to get a full ISNI mapping [13:53:34] actually, I’m not sure if OpenRefine can reconcile on just the ISNI column… hm [13:53:46] I don’t think it uses the query service at all [13:54:05] oh, that'S sad :/ [13:54:08] revi: https://query.wikidata.org/bigdata/ldf [13:54:34] revi: https://query.wikidata.org/bigdata/ldf?subject=&predicate=wdt%3AP213&object= [13:54:50] that looks better [13:54:54] * revi needs to take some note [13:55:15] that should support content negotiation and give you easy to process data [13:55:21] not sure what formaqts it supports, though [13:55:23] I think I would prefer the SPARQL version [13:55:35] Linked Data Fragments would require one HTTP request per ISNI, no? [13:55:54] no relevant info in the html head either. sad. [13:55:55] with SPARQL you can ask for lots of ISNIs at once (as long as you POST the query – GET requests have some limitations) [13:56:22] Lucas_WMDE: ldf allow paged download of the full mapping, e.g. into an sql database [13:56:27] then the mapping can happen locally [13:56:41] oh, I see [13:56:46] for a few hundred ISNIs, queries are better [13:56:55] for a few hundred thousand, i'd go for ldf [13:56:58] yeah, that makes sense if you have lots of ISNIs, good point [13:57:33] how do i make the ldf endpoint give me cvs or n3? [13:59:08] (meanwhile) you both are really awesome, thanks! [14:01:35] DanielK_WMDE: sending `Accept: text/turtle` works for ttl [14:01:58] but text/csv or text/tab-separated-values doesn’t [14:02:26] not sure which content types are supported [14:45:53] Hello [14:46:20] hi [14:46:38] I'm creating a property proposal. What datatype should I write for the age of a surface ? [14:46:59] the age of a surface? [14:47:13] Yup, for geology and astro-geology [14:47:22] It's different from the time of formation [14:47:26] JN_Squire: age is a quantity. it measures time, which could use units like seconds or years [14:48:17] The list of the property proposal says « élément (item), identifiant externe (external-id), chaîne de caractères (string), média (media), coordonnées (coordinates), texte unilingue (monolingual text), texte multilingue (multilingual text), heure (time), lien web (URL), nombre (number), forme géographique (geo-shape), données tabulaires (tabular), lexème (lexeme), formulaire (form), sens (sense), expression [14:48:17] mathématique (mathematical expression), ou un nouveau type possible) » [14:49:05] The term used in French for "time" is "hour" [14:49:39] Does it mean it's more than just time units within a day? [14:51:02] @DanielK_WMDE see above [15:04:11] Argh [15:04:41] There is an uncertainity whether or not name of geological periods should be allowed [15:13:12] JN_Squire: "quantity" is a property type, and it's the right one to use, but it wouldn't support gerological periods. that would be an item reference [15:13:26] "time" is probably a proeprty for time of day, i don't know [15:13:53] DanielK_WMDE: so I should use "item" for my proposal? [15:14:56] For example, "10 millions years" [15:15:35] no, "quantity" [15:17:46] JN_Squire: oh, i see, the tremplate is a bit odd. I guess "number" is what is used there for quantities [15:18:32] oh, ok. number it is. [15:19:02] JN_Squire: this is the canonical list of available types, never mind the template: https://www.wikidata.org/wiki/Special:ListDatatypes [15:19:33] "time" is dd too. it'S really "date", shich currently doesn't even support time of day [17:05:56] My laptop freezed, I had to reboot and I lost my progress on the property proposal :'( [17:07:56] PROBLEM - Check systemd state on wdqs1009 is CRITICAL: CRITICAL - degraded: The system is operational but one or more units failed. [17:22:15] JN_Squire: :( [17:41:02] PROBLEM - High lag on wdqs1003 is CRITICAL: 3607 ge 3600 https://grafana.wikimedia.org/dashboard/db/wikidata-query-service?orgId=1&panelId=8&fullscreen [17:45:43] PROBLEM - High lag on wdqs1004 is CRITICAL: 3632 ge 3600 https://grafana.wikimedia.org/dashboard/db/wikidata-query-service?orgId=1&panelId=8&fullscreen [17:49:42] PROBLEM - High lag on wdqs1005 is CRITICAL: 3657 ge 3600 https://grafana.wikimedia.org/dashboard/db/wikidata-query-service?orgId=1&panelId=8&fullscreen [17:50:23] jikes! [17:56:23] ACKNOWLEDGEMENT - High lag on wdqs1003 is CRITICAL: 4233 ge 3600 Gehel New occurence of https://phabricator.wikimedia.org/T202764 https://grafana.wikimedia.org/dashboard/db/wikidata-query-service?orgId=1&panelId=8&fullscreen [17:56:24] ACKNOWLEDGEMENT - High lag on wdqs1004 is CRITICAL: 4029 ge 3600 Gehel New occurence of https://phabricator.wikimedia.org/T202764 https://grafana.wikimedia.org/dashboard/db/wikidata-query-service?orgId=1&panelId=8&fullscreen [17:56:24] ACKNOWLEDGEMENT - High lag on wdqs1005 is CRITICAL: 3933 ge 3600 Gehel New occurence of https://phabricator.wikimedia.org/T202764 https://grafana.wikimedia.org/dashboard/db/wikidata-query-service?orgId=1&panelId=8&fullscreen [18:12:28] RECOVERY - Check systemd state on wdqs1009 is OK: OK - running: The system is fully operational [19:28:27] RECOVERY - High lag on wdqs1005 is OK: (C)3600 ge (W)1200 ge 1137 https://grafana.wikimedia.org/dashboard/db/wikidata-query-service?orgId=1&panelId=8&fullscreen [19:38:27] RECOVERY - High lag on wdqs1004 is OK: (C)3600 ge (W)1200 ge 1050 https://grafana.wikimedia.org/dashboard/db/wikidata-query-service?orgId=1&panelId=8&fullscreen [20:52:37] RECOVERY - High lag on wdqs1003 is OK: (C)3600 ge (W)1200 ge 1135 https://grafana.wikimedia.org/dashboard/db/wikidata-query-service?orgId=1&panelId=8&fullscreen