<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;" src="https://mailfoogae.appspot.com/t?sender=abWFyY21pcXVlbEBnbWFpbC5jb20%3D&type=zerocontent&guid=57008f31-25be-4f4b-9c36-865e43f5b685"><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 class="h5"><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" src="https://mailfoogae.appspot.com/t?sender=abWFyY21pcXVlbEBnbWFpbC5jb20%3D&type=zerocontent&guid=8fae7c15-0ca2-4d1e-895a-2c0fa19983fc"><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"><div><br></div>-- <br><div>Best regards,<br> Max Semenik ([[User:MaxSem]])<br></div>
</font></span></div>
<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></blockquote></div><br><br clear="all"><br>-- <br></div></div><span class="HOEnZb"><font color="#888888"><div><div dir="ltr">Oliver Keyes<br>Research Analyst<br>Wikimedia Foundation<br></div></div>
</font></span></div>
<br>_______________________________________________<br>
Analytics mailing list<br>
<a href="mailto:Analytics@lists.wikimedia.org">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><br></div>