<div dir="ltr"><div><div><div><div>Hoi,<br></div>What is the point.. Harvest jobs have been run on many Wiikipedias and the result ended up in Wikidata.. Is this enough or does the data need to be in the text for a language text as well ?<br><br></div>When you run a job querying Wikipedias have the result end up in Wikidata as well.. It allows people stand on the shoulders of giants..<br></div>Thanks,<br></div> GerardM<br></div><div class="gmail_extra"><br><div class="gmail_quote">On 2 March 2015 at 23:42, 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" 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><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 class="h5"><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></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5"><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></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>