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
