Katie has a bot that does it. I think there is a script somewhere already too, but I can't find it.
Sven On Oct 5, 2013 3:58 PM, "Jan Dudík" <[email protected]> wrote: > Give me python script, and I'll move all coordinates from cs and sk wiki > ;-) > > there are only sripts for importing types "item" and "string" yet. > > JAnD > > --- > Ing. Jan Dudík > projekce dopravních staveb > tel. 777082195 > > > 2013/10/5 Katie Filbert <[email protected]> > >> On Sat, Oct 5, 2013 at 3:49 PM, Maarten Dammers <[email protected]>wrote: >> >>> Hi Katie, >>> >>> Op 4-10-2013 23:29, Katie Filbert schreef: >>> >>> As many folks enjoy country rankings, I have generated a list of >>> countries (Property:P17) ranked by number of coordinates (P625) in >>> Wikidata. Note this data is from the September 22 database dump. >>> >>> Did you consider doing this as a query on the live database on Tool*? >>> >> >> Unfortunately tool labs does not have PostgreSQL and PostGIS yet :( >> which is what I need to do certain stuff. >> >> It's easy enough to work with dumps, and can do stuff on tool labs when >> it makes sense. >> >> >>> You have a page for an item with coordinates. >>> * Join this page against pagelinks for P625 (coordinate location) >>> * Join this page against pagelinks for P17 (country) >>> * Join this page against pagelinks for countrypage >>> * Join countrypage aginst pagelinks for Q6256 (country) or Q1763527 >>> (constituent country) >>> >>> Group it by country and do some ordering. >>> >>> We do seem to have quite a few items where country is missing, see >>> http://208.80.153.172/wdq/?q=claim[625]_AND_noclaim[17]_AND_noclaim[31] >>> . We should probably work on that too. >>> >> >> Yep! >> >> >>> >>> I was wondering how many articles do have coordinates at the Dutch >>> Wikipedia, but not at Wikidata. For that I created a tracker category, see >>> https://nl.wikipedia.org/wiki/Categorie:Wikipedia:Co%C3%B6rdinaten_niet_op_Wikidata. >>> We could probably do some LUA magic to compare coordinates in Wikidata >>> with local coordinates and see how far these are apart. Did anyone already >>> build something in LUA that might be reused for this? >>> >> >> I am not aware of that. Definitely a good idea. >> >> Cheers, >> Katie >> >> >> >>> >>> >>> Maarten >>> >>> _______________________________________________ >>> Wikidata-l mailing list >>> [email protected] >>> https://lists.wikimedia.org/mailman/listinfo/wikidata-l >>> >>> >> >> >> -- >> Katie Filbert >> [email protected] >> @filbertkm / @wikimediadc / @wikidata >> >> _______________________________________________ >> Wikidata-l mailing list >> [email protected] >> https://lists.wikimedia.org/mailman/listinfo/wikidata-l >> >> > > _______________________________________________ > Wikidata-l mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/wikidata-l > >
_______________________________________________ Wikidata-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-l
