Marc, 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.
He is more active on the German site, see https://de.wikipedia.org/wiki/Benutzer:Kolossos. His email link is there or you can search thru this email list for it. Bryan On Mon, Mar 2, 2015 at 3:42 PM, Marc Miquel <[email protected]> wrote: > Hi Max and Oliver, > > 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. > > Marc > ᐧ > > 2015-03-02 23:38 GMT+01:00 Oliver Keyes <[email protected]>: > >> Max's idea is an improvement but still a lot of requests. We really need >> to start generating these dumps :(. >> >> Until the dumps are available, the fastest way to do it is probably >> Quarry (http://quarry.wmflabs.org/) 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: >> >> SELECT * FROM enwiki_p.geo_tags; >> >> 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! >> >> On 2 March 2015 at 17:35, Max Semenik <[email protected]> wrote: >> >>> Use generators: >>> api.php?action=query&generator=allpages&gapnamespace=0&prop=coordinates&gaplimit=max&colimit=max >>> >>> On Mon, Mar 2, 2015 at 2:33 PM, Marc Miquel <[email protected]> >>> wrote: >>> >>>> Hi guys, >>>> >>>> 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. >>>> >>>> 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. >>>> >>>> My objective is to obtain different lists of articles related to >>>> countries and regions. >>>> >>>> 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. >>>> Anyone could help me? >>>> >>>> Thanks a lot. >>>> >>>> Marc Miquel >>>> ᐧ >>>> >>>> _______________________________________________ >>>> Analytics mailing list >>>> [email protected] >>>> https://lists.wikimedia.org/mailman/listinfo/analytics >>>> >>>> >>> >>> >>> -- >>> Best regards, >>> Max Semenik ([[User:MaxSem]]) >>> >>> _______________________________________________ >>> Analytics mailing list >>> [email protected] >>> https://lists.wikimedia.org/mailman/listinfo/analytics >>> >>> >> >> >> -- >> Oliver Keyes >> Research Analyst >> Wikimedia Foundation >> >> _______________________________________________ >> Analytics mailing list >> [email protected] >> https://lists.wikimedia.org/mailman/listinfo/analytics >> >> > > _______________________________________________ > Labs-l mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/labs-l > >
_______________________________________________ Labs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/labs-l
