On Sat, Oct 5, 2013 at 3:49 PM, Maarten Dammers <maar...@mdammers.nl> 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 > Wikidata-l@lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/wikidata-l > > -- Katie Filbert filbe...@gmail.com @filbertkm / @wikimediadc / @wikidata
_______________________________________________ Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l