Re: [Wikidata-l] World's largest cities with a female mayor :-)

2015-04-21 Thread Jeremy Baron
Hi, On Tue, Apr 21, 2015 at 5:05 PM, Thad Guidry thadgui...@gmail.com wrote: We had US Census, World Bank, and UN Data as our primary data sources for any /statistics/ of a City/Town/Village. Here's Houston - https://www.freebase.com/m/03l2n#/location/statistical_region I don't understand

Re: [Wikidata-l] World's largest cities with a female mayor :-)

2015-04-21 Thread Thomas Douillard
Thanks, it made me realize the datas of my city are not up to date :) I thought : I wondered if I would see https://www.wikidata.org/entity/Q16037012 (although the city is not that big, but Rennes, a comparable on, showed up in the results, so ...) and it did not. There is redundancy in this

Re: [Wikidata-l] World's largest cities with a female mayor :-)

2015-04-21 Thread Markus Krötzsch
On 21.04.2015 02:05, James Douglas wrote: This is super cool, thanks for sharing! Would you mind if I write it up for the Wikidata Query Service docs? No, of course not. We could certainly use some more documentation. Be aware, however, that the RDF export format is still subject to change,

Re: [Wikidata-l] World's largest cities with a female mayor :-)

2015-04-21 Thread Markus Krötzsch
On 21.04.2015 11:27, Daniel Kinzler wrote: Am 21.04.2015 um 00:50 schrieb Markus Krötzsch: On 20.04.2015 23:47, Daniel Kinzler wrote: Something seems to be wrong with the order, though. Munich (pop 1m in all statements) is listed way after Chemnitz (pop 300k in all statements). Any idea why?

Re: [Wikidata-l] World's largest cities with a female mayor :-)

2015-04-21 Thread Pharos
There appear to be a number of other major cities missing, though I'm not sure what the cut-off for population is: Cities where we have articles for the mayor: Baltimore, Maryland (USA) Columbus, Georgia (USA) Diyarbakır (Turkey) Gary, Indiana (USA) Knoxville, Tennessee (USA) Łódź (Poland) Malmö

Re: [Wikidata-l] World's largest cities with a female mayor :-)

2015-04-21 Thread Jeremy Baron
On Apr 21, 2015 10:41, Pharos pharosofalexand...@gmail.com wrote: There appear to be a number of other major cities missing, though I'm not sure what the cut-off for population is: Cities where we have articles for the mayor: Baltimore, Maryland (USA) [...] You're welcome to fix some of

Re: [Wikidata-l] World's largest cities with a female mayor :-)

2015-04-21 Thread Nicola Vitucci
Sure, that's possible, but probably not this week. In fact, maybe we should fix the remaining issues first and update the data again. But it's surely a good idea to give a little SPARQL introduction using such an example. Lydia, would this be something for the WMDE Blog? Markus I'm

Re: [Wikidata-l] World's largest cities with a female mayor :-)

2015-04-21 Thread Pharos
Oh, and the city at the bottom of the query list has a population of only 279! I have a feeling Wikidata is just playing better with Spanish cities for some reason :) This is an awesome effort, but needs some work. Thanks, Richard (User:Pharos) On Tue, Apr 21, 2015 at 10:40 AM, Pharos

Re: [Wikidata-l] World's largest cities with a female mayor :-)

2015-04-21 Thread Jeremy Baron
On Tue, Apr 21, 2015 at 10:05 PM, James Douglas jdoug...@wikimedia.org wrote: Here's the (nearly) equivalent query for the statements dump[1] loaded into Blazegraph: better to work based on Markus's revised version. (on this thread, Date: Tue, 21 Apr 2015 00:50:26 +0200) -Jeremy

Re: [Wikidata-l] World's largest cities with a female mayor :-)

2015-04-21 Thread Thad Guidry
BTW, the Freebase ingestion later this summer should help fill a few of those holes in population and other statistics. We had US Census, World Bank, and UN Data as our primary data sources for any /statistics/ of a City/Town/Village. Here's Houston -