[09:29:37] Is there any way to search for a Wikidata object that links to a Wikipedia article that shows in a specific external links search yet lacks a specific property? [09:30:04] (wondering about pages on etwiki that link to the Estonian Heritage registry but whose items don't have a heritage ID) [11:08:47] Hi, im trying to query an item on wikidata by a property and an exact title match. What am i doing wrong here: https://pastebin.ca/3938559 [11:10:46] I don't see a language specified. [11:17:11] deanc: yeah, you need a language code: http://tinyurl.com/yd8tgaah [11:17:30] you *can* also do a language- and case-insensitive search, but that’s much less efficient: http://tinyurl.com/y8232sl7 [11:17:44] Do we have examples with this btw, I couldn't find one. [11:17:50] And it seems like a good use case. [11:20:23] I searched through about 117 mentions of ?itemLabel on the examples and didn't find one [11:20:47] Lucas_WMDE: why does that give me an empty itemLabel on that actaul result? [11:20:51] the goal would be to pull more fields also [11:21:31] deanc: because I changed it to match the label directly, instead of putting it in a variable and then filtering it [11:21:59] you can also do this http://tinyurl.com/ya5e8avp, but it’s less efficient [11:24:09] And if i want to query another field I have to add this to the bottom of the where: OPTIONAL { ?item wdt:PXXXX ?_Varaible_name. } [11:24:24] and then i can add SELECT ?_Variable_name [11:24:25] ? [11:25:37] yes [11:26:35] What is the process for resolving what it finds? It's giving me Q30 :P [11:27:28] not sure what you mean by resolving… [11:27:54] http://tinyurl.com/ycse9ukm [11:28:01] sorry, hold on [11:28:47] not sure how you made that tinyurl, it's forcing a download for me on chrome :p [11:29:12] https://pastebin.ca/3938572 [11:30:03] sorry, gotta go for now [11:36:51] oki! [11:50:37] Lucas_WMDE: I was told you might have some idea about my previous question, so: "Is there any way to search for a Wikidata object that links to a Wikipedia article that shows in a specific external links search yet lacks a specific property? [11:50:37] (wondering about pages on etwiki that link to the Estonian Heritage registry but whose items don't have a heritage ID)" [11:51:04] I was told "it might be possible by using the mw api functions in a sparql query" but I have no idea how that works [11:51:14] (I mean I can do basic sparql queries, but) [11:56:51] don't know if this is kind of spam or not - user Jesper.nygaard32 seemly only adds data for Hilton Hotels and Waldorf Astoria... [11:57:25] reosarevok: what does such a link look like? is it just a hyperlink in wikitext? [11:58:14] Lucas_WMDE: pretty much [11:58:21] hm, then I doubt it’s possible [11:59:22] hm, or perhaps it might be [11:59:24] (basically, I want to take https://et.wikipedia.org/w/index.php?title=Eri:V%C3%A4lislinkide_otsimine&limit=500&offset=0&target=http%3A%2F%2Fregister.muinas.ee%2Fpublic.php%3FmenuID%3Dmonument and compare the results with their WD items automatically somehow) [12:01:08] okay, so you can get the external links via the API: https://et.wikipedia.org/wiki/Eri:ApiSandbox?setlang=en#action=query&format=json&prop=extlinks&titles=August%20Weizenberg [12:01:44] but that’s looking for the links of a specific article – you need all articles with a specific link [12:02:12] link fragment, but yes (link without the specific ID) [12:02:37] https://www.mediawiki.org/wiki/API:Exturlusage [12:03:10] a ha! thanks :) [12:06:00] https://et.wikipedia.org/wiki/Eri:ApiSandbox#action=query&format=json&list=exturlusage&euquery=register.muinas.ee%2Fpublic.php%3FmenuID%3Dmonument&eunamespace=0&eulimit=max [12:08:07] I guess there's no one-click "generate SPARQL-style version of this" button? :) [12:08:37] I don't think SPARQL can interact with that specific API module. [12:08:41] (atm) [12:10:53] Aww [12:11:13] Well for this specific case there aren't that many so I can do it by hand easily anyway I guess :) [12:11:27] hang on, hang on, I almost have it working! :D [12:11:32] haha [12:11:36] * reosarevok hangs on [12:11:43] you want items without which property? [12:12:08] P2948? [12:12:21] Yeah [12:12:31] (it's probably most of them, currently) [12:15:37] reosarevok: http://tinyurl.com/y8cblnj9 [12:15:48] haven’t figured out yet how to extract the URL itself, unfortunately [12:16:44] otherwise the query could spit out the ID directly, which would be even more useful [12:17:16] also, here’s a version with the article title, slightly more useful http://tinyurl.com/ydze6bgp [12:17:46] Hmm, a lot of results seem not to be there for some reason [12:18:30] (like https://et.wikipedia.org/wiki/Raekoja_plats_(Tallinn)) [12:18:50] The basic idea seems to work though, which is great already, I had no clue how to get this far :) [12:19:36] yeah, it looks like the APi is limited to fairly few results [12:20:12] I guess we need https://phabricator.wikimedia.org/T178712 [12:22:40] I see. Well I'll save this query for now, I'm pretty sure I'll want to use it for more stuff than this just tweaking it a bit [12:28:27] hm, but it doesn’t really make sense that the number of results is *that* low [12:28:31] five results: http://tinyurl.com/yad6cac8 [12:28:44] equivalent API query: way more results https://et.wikipedia.org/wiki/Eri:ApiSandbox#action=query&format=json&generator=exturlusage&geuprop=title%7Curl&geuquery=register.muinas.ee%2Fpublic.php%3FmenuID%3Dmonument&geunamespace=0&geulimit=max [12:29:19] the only reason I could think of would be if most of the results didn’t have wikidata items, but that doesn’t seem to be the case [12:29:30] Multiple links per page? [12:29:43] One of the results could be a list with a lot of urls. [12:30:02] it looks like lots of different results [13:00:13] There's definitely multiple links per page, but there's a total of 191 [13:00:24] links. So it should still go under the 500 total? [13:55:27] Do people think it would be ok to merge https://www.wikidata.org/wiki/Q12373247 (Estonian article for sacred tree) into https://www.wikidata.org/wiki/Q21029882 (which by enlabel + desc sounds generic, but it has only a Belarusian wiki article and two Belarusian trees linked)? [14:06:05] Also, https://www.wikidata.org/wiki/Q20529903 is the main building of https://www.wikidata.org/wiki/Q9284834 - which of the two should be an instance of "train station", and what should the other one be? :/ [14:10:30] Station building is something that is separate from the railway facility [14:10:41] The building can still exist, while the rest have been removed. [14:12:46] Oh, I see Q1339195 is a thing for the building itself :) [14:12:58] Doubt solved! [14:24:40] They might think my shift button is broken. https://www.wikidata.org/wiki/Q43394989 [15:00:27] Technical Advice IRC meeting starting in 60 minutes in channel #wikimedia-tech, hosts: @addshore & @Christoph_Jauera_(WMDE) - all questions welcome, more infos: https://www.mediawiki.org/wiki/Technical_Advice_IRC_Meeting [15:02:14] MichaelSchoenitz: as far as I know Thiemo_WMDE and me are supposed to host this one [15:02:55] Lucas_WMDE: yes, sorry today it's @Lucas_WMDE & @Thiemo_WMDE! [15:08:49] Hm, only increased one item from 13,5k to 249,7k... https://www.wikidata.org/w/index.php?title=Q2039348&offset=&limit=250&action=history [16:00:56] any OpenRefine experts online? is it possible to set the language in which Wikidata labels and descriptions are shown while reconciling? [17:03:14] another OpenRefine noob question… once I’m done reconciling the data, how is the actual import into Wikidata done? [17:04:02] it looks like I can export it to QuickStatements syntax using a custom tabular exporter (making sure to emit the reconciled ID for that column, and specify QS’s custom date format for those columns), but that seems unexpectedly complicated [17:47:06] Is using both "commemorates" and "depicts" for a statue (like on https://www.wikidata.org/wiki/Q12366397) correct? I'd expect so but just in case :) [17:49:20] Some objects can pay tribute to people without actually displaying them. [17:51:21] Sure, but if they do :) [17:51:36] (I've also seen a couple of non-depicting ones, obelisks and whatnot) [17:52:42] I was thinking more in that latter direction too [17:53:02] depicts: Lord Exampleton; commemorates: Battle of Thingy [17:54:14] https://frinkiac.com/img/S11E03/593960.jpg [18:00:17] :D [18:00:32] https://www.wikidata.org/wiki/User%3AReosarevok%2FEstonian_heritage so many graveyards [18:19:13] I keep selecting the wrong unit, as the unit selector selects the first results automatically, while this isn't happening on normal values. [18:29:55] hm, that sounds less than ideal, considering we haven’t optimized that selector for units yet… [18:30:03] I'm creating some task now. [18:31:54] It's also some accessibility issue. https://phabricator.wikimedia.org/T181185 [18:37:49] oh, I just noticed the unit input field is some OOui input now [18:37:55] looks slightly prettier at least [18:38:53] Huh? [18:39:12] I did notice that sometimes the padding is off on all fields. [18:39:39] it also gets a blue border when it’s active [18:40:19] Not on my side. [18:40:27] Ehm, just system default I meant. [18:41:26] damn, I can’t take a screenshot of it because as soon as I press the screenshot button the element is no longer active :D [18:41:36] Classic. [18:42:30] sjoerddebruin: https://i.imgur.com/cPVYWk6.png [18:42:39] That's not here. [18:42:44] strange [18:42:54] * Lucas_WMDE fires up GNOME Web [18:43:28] Any opinions on the data type here: https://www.wikidata.org/wiki/Wikidata:Property_proposal/Flathub_URL [18:43:32] might be another WebKit thing [18:44:19] It's the same size in Firefox and Safari here. [18:44:35] The question is maybe if flathub is notable enough to have an identifier yet. [18:45:02] That is not the discussion anymore I think. [18:45:03] this is what I see in gnome web: https://i.imgur.com/q4ihcoE.png [18:45:10] Beautiful, Lucas. [18:45:18] (the black background is my gnome theme) [18:45:24] I would go for external ID, Tobias. [18:45:59] Will we ever use ooUI in the Wikidata ui? They need to add a small mode then. :P [18:46:29] sjoerddebruin: can you comment on wiki too? [18:47:12] done [18:47:45] sjoerddebruin: okay, as far as I can tell this is all browser styles, in Chromium it looks completely different again [18:48:00] so I guess Firefox just changed the default style of text inputs with Quantum? [18:48:38] yeah, an unstyled on about:blank looks identical [18:49:11] Oh, I didn't updated my main Firefox yet. [18:49:24] Still, no size difference here. [18:50:57] tobias47n9e: for datatype external identifier, having URL in the label would be a bit weird IMHO [18:51:05] flathub ID, perhaps? [18:52:15] The question is then if we should have a separate property for other flatpak URLs? [18:53:24] gotta go home now, sorry :)