[10:00:26] <wm-bb>	 <Galder> hello! Is there a way to get all the geotagged articles in a given Wiki? I'm trying with WDQS, but the query is too expensive
[10:08:57] <wm-bb>	 <Jan_ainali> What is your definition of a "geotagged articles in a given Wiki"? (re @Galder: hello! Is there a way to get all the geotagged articles in a given Wiki? I'm trying with WDQS, but the query is too expensive)
[10:10:06] <wm-bb>	 <Galder> articles with coordinates
[10:10:28] <wm-bb>	 <Ladsgroup> You could query geo_tags table of that wiki
[10:10:39] <wm-bb>	 <Ladsgroup> That should contain anything you want
[10:10:58] <wm-bb>	 <Galder> how exactly? with Quarry I assume
[10:11:02] <wm-bb>	 <Ladsgroup> Mysql (re @Ladsgroup: You could query geo_tags table of that wiki)
[10:11:05] <wm-bb>	 <Ladsgroup> Yup (re @Galder: how exactly? with Quarry I assume)
[10:13:01] <wm-bb>	 <lucaswerkmeister> yeah, something like
[10:13:02] <wm-bb>	 <lucaswerkmeister> ```
[10:13:04] <wm-bb>	 <lucaswerkmeister> SELECT DISTINCT page_namespace, page_title FROM page JOIN geo_tags ON page_id = gt_page_id```
[10:13:05] <wm-bb>	 <lucaswerkmeister> 
[10:13:07] <wm-bb>	 <lucaswerkmeister> should do the trick I think
[10:13:17] <wm-bb>	 <Galder> thanks!
[10:21:13] <wm-bb>	 <Jan_ainali> Just to learn myself of how to get think about getting that info, would you mind sharing the query you had? (re @Galder: hello! Is there a way to get all the geotagged articles in a given Wiki? I'm trying with WDQS, but the query is too expensive)
[10:22:39] <wm-bb>	 <Galder> #defaultView:Map
[10:22:40] <wm-bb>	 <Galder> SELECT ?itemLabel ?koordenatuak WHERE {
[10:22:41] <wm-bb>	 <Galder>   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
[10:22:43] <wm-bb>	 <Galder>   ?item wdt:P625 ?koordenatuak.
[10:22:44] <wm-bb>	 <Galder>   ?article schema:about ?item .
[10:22:46] <wm-bb>	 <Galder>   ?article schema:isPartOf <https://eo.wikipedia.org/> .
[10:22:47] <wm-bb>	 <Galder> }
[10:22:49] <wm-bb>	 <Galder> LIMIT 100
[10:22:51] <wm-bb>	 <Galder> (move the limit, but more than 10.000 seems tricky)
[10:24:51] <wm-bb>	 <Jan_ainali> Thanks!
[10:24:52] <wm-bb>	 <Jan_ainali>  Just a note, thatthis query won't get geotagged articles, but geotagged wikidata items with articles. The slight difference is that you might miss articles that do have a coordinate on the local wiki and might get a few that doesn't. (re @Galder: #defaultView:Map
[10:24:53] <wm-bb>	 <Jan_ainali> SELECT ?itemLabel ?koordenatuak WHERE {
[10:24:55] <wm-bb>	 <Jan_ainali>   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LAN...)
[10:25:24] <wm-bb>	 <Galder> right
[10:27:51] <wm-bb>	 <Galder> anyway, thanks for the clue @lucaswerkmeister! I made this map for Esperanto using Kepler.gl
[10:28:07] <wm-bb>	 <Galder> https://tools-static.wmflabs.org/bridgebot/e2e76f14/file_51976.jpg
[10:29:04] <wm-bb>	 <Galder> guess who is editing Esperanto Wikipedia! : https://tools-static.wmflabs.org/bridgebot/41dc5576/file_51977.jpg
[20:54:32] <wm-bb>	 <Effeietsanders> (which made me wonder - why is https://en.wikipedia.org/wiki/Geographical_bias_on_Wikipedia still showing a figure from 2013? )
[20:55:55] <wm-bb>	 <Effeietsanders> Galder it might be useful to have a series of images on commons with such maps, per project?
[21:01:11] <wm-bb>	 <Galder> That would be a great project, but making 320 maps without certain automation would be a bit boring
[21:02:00] <wm-bb>	 <jhsoby> you could limit it to the 10–15 largest languages?
[21:02:07] <wm-bb>	 <Galder> Also, other information can be added to Kepler, like sizing dots with a parameter (i.e length lf the article)
[21:03:00] <wm-bb>	 <Galder> And Basque, bokmal and nynorks to compare 😜 (re @jhsoby: you could limit it to the 10–15 largest languages?)
[21:03:15] <wm-bb>	 <jhsoby> naturally! 😁 (re @Galder: And Basque, bokmal and nynorks to compare 😜)
[21:21:08] <Platonides>	 xD
[21:27:24] <wm-bb>	 <robertsky> toolforge index shows that the project that generated the image is present, but looks like there is no public endpoints to generate the image. : https://tools-static.wmflabs.org/bridgebot/cb05b54a/file_51988.jpg
[21:30:30] <wm-bb>	 <robertsky> from the project page, it seems that the data stopped at 2015. we will need to rework the data.
[21:33:13] <wm-bb>	 <Effeietsanders> i think automation would be great, so that you can update the images annually? (re @Galder: That would be a great project, but making 320 maps without certain automation would be a bit boring)
[21:34:16] <wm-bb>	 <Effeietsanders> I'm not sure how hard it would be to automate your process though - Otherwise Robert's suggestion is a good one.
[21:37:34] <wm-bb>	 <Galder> The process is: query at quarry, download csv, upload to kepler, customize map, save the image. It would be also uploading it to Commons. So it takes like... 10 minutes each? 300 would be 50 hours of doing only that, if everything goes smooth and the 2 million points of Cebuano don't break my compjter
[22:18:38] <wm-bb>	 <Nikki> thanks for the link. it doesn't seem to cover what I want though :( I want to get notifications (on the website, what phabricator calls a notification) when someone mentions me (like on-wiki pings), but "Someone comments on a task." is the only option related to comments on tickets that I can find (re @andreklapper: https://m.mediawiki.org/wiki/Phabricator/Help/Managing_mail)