<div dir="ltr">Marc, <div><br></div><div>If anybody would know, it would be Kolossos. He is one of the people responsible for geohack, integration with OpenStreetmap and other geographical referencing doohickeys. <div><br></div><div>He is more active on the German site, see <a href="https://de.wikipedia.org/wiki/Benutzer:Kolossos" target="_blank">https://de.wikipedia.org/wiki/Benutzer:Kolossos</a>. His email link is there or you can search thru this email list for it. </div><div><br></div><div>Bryan</div></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Mar 2, 2015 at 3:42 PM, Marc Miquel <span dir="ltr"><<a href="mailto:marcmiquel@gmail.com" target="_blank">marcmiquel@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi Max and Oliver,<div><br></div><div>Thanks for your answers. geo_tags table seems quite uncomplete. I just checked some random articles in for instance Nepali Wikipedia, for its Capital Katmandú there is coords in the real article but it doesn't appear in geo_tags. Then it doesn't seem an option.</div><div><br></div><div>Marc</div><div hspace="streak-pt-mark" style="max-height:1px"><img style="width:0px;max-height:0px"><font color="#ffffff" size="1">ᐧ</font></div></div><div class="gmail_extra"><br><div class="gmail_quote">2015-03-02 23:38 GMT+01:00 Oliver Keyes <span dir="ltr"><<a href="mailto:okeyes@wikimedia.org" target="_blank">okeyes@wikimedia.org</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div><div>Max's idea is an improvement but still a lot of requests. We really need to start generating these dumps :(. <br><br></div>Until
the dumps are available, the fastest way to do it is probably Quarry
(<a href="http://quarry.wmflabs.org/" target="_blank">http://quarry.wmflabs.org/</a>) an open MySQL client to our public
database tables. So, you want the geo_tags table; getting all the coordinate sets on the English-language Wikipedia would be something like:<br><br></div>SELECT * FROM enwiki_p.geo_tags;<br><br></div>This should be available for all of our production wikis (SHOW DATABASES is your friend): you want [project]_p rather than [project]. Hope that helps!<br> </div><div class="gmail_extra"><div><div><br><div class="gmail_quote">On 2 March 2015 at 17:35, Max Semenik <span dir="ltr"><<a href="mailto:maxsem.wiki@gmail.com" target="_blank">maxsem.wiki@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Use generators: api.php?action=query&generator=allpages&gapnamespace=0&prop=coordinates&gaplimit=max&colimit=max</div><div class="gmail_extra"><br><div class="gmail_quote"><div><div>On Mon, Mar 2, 2015 at 2:33 PM, Marc Miquel <span dir="ltr"><<a href="mailto:marcmiquel@gmail.com" target="_blank">marcmiquel@gmail.com</a>></span> wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div><div dir="ltr"><span style="font-size:12.8000001907349px">Hi guys,</span><div style="font-size:12.8000001907349px"><br></div><div style="font-size:12.8000001907349px">I am doing some research and I struggling a bit to obtain geolocalized articles in several languages. They told me that the best tool to obtain the geolocalization for each article would be GeoData API. But I see there I need to introduce each article name and I don't know if it is the best way.</div><div style="font-size:12.8000001907349px"><br></div><div style="font-size:12.8000001907349px">I am thinking for instance that for big wikipedies like French or German I might need to make a million queries to get only those with coords... Also, I would like to obtain the region according to ISO 3166-2 which seems to be there.</div><div style="font-size:12.8000001907349px"><br></div><div style="font-size:12.8000001907349px">My objective is to obtain different lists of articles related to countries and regions.</div><div style="font-size:12.8000001907349px"><br></div><div style="font-size:12.8000001907349px">I don't know if using WikiData with python would be a better option. But I see that there there isn't the region. Maybe I could combine WikiData and some other tool to give me the region. </div><div style="font-size:12.8000001907349px">Anyone could help me?</div><div style="font-size:12.8000001907349px"><br></div><div style="font-size:12.8000001907349px">Thanks a lot.</div><span><font color="#888888"><div style="font-size:12.8000001907349px"><br></div><div style="font-size:12.8000001907349px">Marc Miquel</div><div hspace="streak-pt-mark" style="max-height:1px"><img style="width:0px;max-height:0px"><font color="#ffffff" size="1">ᐧ</font></div></font></span></div>
<br></div></div>_______________________________________________<br>
Analytics mailing list<br>
<a href="mailto:Analytics@lists.wikimedia.org" target="_blank">Analytics@lists.wikimedia.org</a><br>
<a href="https://lists.wikimedia.org/mailman/listinfo/analytics" target="_blank">https://lists.wikimedia.org/mailman/listinfo/analytics</a><br>
<br></blockquote></div><span><font color="#888888"><br><br clear="all"><span class="HOEnZb"><font color="#888888"><div><br></div>-- <br><div>Best regards,<br> Max Semenik ([[User:MaxSem]])<br></div>
</font></span></font></span></div><span class="HOEnZb"><font color="#888888">
<br>_______________________________________________<br>
Analytics mailing list<br>
<a href="mailto:Analytics@lists.wikimedia.org" target="_blank">Analytics@lists.wikimedia.org</a><br>
<a href="https://lists.wikimedia.org/mailman/listinfo/analytics" target="_blank">https://lists.wikimedia.org/mailman/listinfo/analytics</a><br>
<br></font></span></blockquote></div><span class="HOEnZb"><font color="#888888"><br><br clear="all"><br>-- <br></font></span></div></div><span class="HOEnZb"><font color="#888888"><span><font color="#888888"><div><div dir="ltr">Oliver Keyes<br>Research Analyst<br>Wikimedia Foundation<br></div></div>
</font></span></font></span></div><span class="HOEnZb"><font color="#888888">
<br>_______________________________________________<br>
Analytics mailing list<br>
<a href="mailto:Analytics@lists.wikimedia.org" target="_blank">Analytics@lists.wikimedia.org</a><br>
<a href="https://lists.wikimedia.org/mailman/listinfo/analytics" target="_blank">https://lists.wikimedia.org/mailman/listinfo/analytics</a><br>
<br></font></span></blockquote></div><br></div>
<br>_______________________________________________<br>
Labs-l mailing list<br>
<a href="mailto:Labs-l@lists.wikimedia.org">Labs-l@lists.wikimedia.org</a><br>
<a href="https://lists.wikimedia.org/mailman/listinfo/labs-l" target="_blank">https://lists.wikimedia.org/mailman/listinfo/labs-l</a><br>
<br></blockquote></div><br></div>