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

2015-04-25 Thread Kingsley Idehen
On 4/23/15 5:39 PM, Nicola Vitucci wrote: Il 23/04/2015 23:22, Kingsley Idehen ha scritto: On 4/23/15 2:01 PM, Kingsley Idehen wrote: On 4/23/15 1:02 PM, Nicola Vitucci wrote: Il 23/04/2015 18:36, Gerard Meijssen ha scritto: Hoi, Do I understand correctly that you cannot have results

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

2015-04-25 Thread Kingsley Idehen
On 4/23/15 5:25 PM, Nicola Vitucci wrote: Il 23/04/2015 20:01, Kingsley Idehen ha scritto: On 4/23/15 1:02 PM, Nicola Vitucci wrote: Il 23/04/2015 18:36, Gerard Meijssen ha scritto: Hoi, Do I understand correctly that you cannot have results showing labels for a given languages? Thanks,

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

2015-04-23 Thread Jeremy Baron
Hi, On Mon, Apr 20, 2015 at 8:29 PM, Nicola Vitucci nicola.vitu...@gmail.com wrote: Markus, this is really cool! Can I reuse it as an example on WikiSPARQL? :-) What's the difference between http://milenio.dcc.uchile.cl/sparql and WikiSPARQL? Just a different codebase/engine? should they be

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

2015-04-23 Thread Kingsley Idehen
On 4/23/15 1:02 PM, Nicola Vitucci wrote: Il 23/04/2015 18:36, Gerard Meijssen ha scritto: Hoi, Do I understand correctly that you cannot have results showing labels for a given languages? Thanks, GerardM Hi Gerard, what do you mean? Are you looking for something like this?

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

2015-04-23 Thread Gerard Meijssen
Hoi, Do I understand correctly that you cannot have results showing labels for a given languages? Thanks, GerardM On 20 April 2015 at 22:18, Markus Krötzsch mar...@semantic-mediawiki.org wrote: Hi all, For many years, Denny and I have been giving talks about why we need to improve the

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

2015-04-23 Thread Nicola Vitucci
Il 23/04/2015 18:36, Gerard Meijssen ha scritto: Hoi, Do I understand correctly that you cannot have results showing labels for a given languages? Thanks, GerardM Hi Gerard, what do you mean? Are you looking for something like this?

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

2015-04-23 Thread Gerard Meijssen
Hoi, Yes the link below is for Russian :) On 23 April 2015 at 19:02, Nicola Vitucci nicola.vitu...@gmail.com wrote: Il 23/04/2015 18:36, Gerard Meijssen ha scritto: Hoi, Do I understand correctly that you cannot have results showing labels for a given languages? Thanks, GerardM

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

2015-04-23 Thread Nicola Vitucci
Il 23/04/2015 20:01, Kingsley Idehen ha scritto: On 4/23/15 1:02 PM, Nicola Vitucci wrote: Il 23/04/2015 18:36, Gerard Meijssen ha scritto: Hoi, Do I understand correctly that you cannot have results showing labels for a given languages? Thanks, GerardM Hi Gerard, what do you

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

2015-04-23 Thread Nicola Vitucci
Il 23/04/2015 23:22, Kingsley Idehen ha scritto: On 4/23/15 2:01 PM, Kingsley Idehen wrote: On 4/23/15 1:02 PM, Nicola Vitucci wrote: Il 23/04/2015 18:36, Gerard Meijssen ha scritto: Hoi, Do I understand correctly that you cannot have results showing labels for a given languages? Thanks,

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

2015-04-23 Thread Kingsley Idehen
On 4/23/15 2:01 PM, Kingsley Idehen wrote: On 4/23/15 1:02 PM, Nicola Vitucci wrote: Il 23/04/2015 18:36, Gerard Meijssen ha scritto: Hoi, Do I understand correctly that you cannot have results showing labels for a given languages? Thanks, GerardM Hi Gerard, what do you mean? Are you

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

2015-04-22 Thread Lydia Pintscher
On Tue, Apr 21, 2015 at 4:09 PM, Markus Krötzsch mar...@semantic-mediawiki.org wrote: 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

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

2015-04-22 Thread Kingsley Idehen
On 4/21/15 6:05 PM, James Douglas wrote: Here's the (nearly) equivalent query for the statements dump[1] loaded into Blazegraph: PREFIX wd: http://www.wikidata.org/entity/ SELECT DISTINCT ?city ?citylabel ?mayorlabel WHERE { ?city wd:P31s/wd:P31v wd:Q515 . # find instances of

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

2015-04-22 Thread Nicola Vitucci
Il 22/04/2015 00:05, James Douglas ha scritto: Here's the (nearly) equivalent query for the statements dump[1] loaded into Blazegraph: PREFIX wd: http://www.wikidata.org/entity/ SELECT DISTINCT ?city ?citylabel ?mayorlabel WHERE { ?city wd:P31s/wd:P31v wd:Q515 . # find

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 -

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

2015-04-20 Thread Daniel Kinzler
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? Oh... maybe quantity values are sorted in alphanumeric order, because they are decimal strings? They should be xsd:decimal... Am

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

2015-04-20 Thread Andy Mabbett
On 20 April 2015 at 21:18, Markus Krötzsch mar...@semantic-mediawiki.org wrote: (Madrid has a suspiciously large number of current mayors ...) Not any more ;-) -- Andy Mabbett @pigsonthewing http://pigsonthewing.org.uk ___ Wikidata-l mailing list

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

2015-04-20 Thread James Douglas
This is super cool, thanks for sharing! Would you mind if I write it up for the Wikidata Query Service docs? On Mon, Apr 20, 2015 at 3:50 PM, Markus Krötzsch mar...@semantic-mediawiki.org wrote: On 20.04.2015 23:47, Daniel Kinzler wrote: Something seems to be wrong with the order, though.

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

2015-04-20 Thread Stas Malyshev
Hi! is as follows (with some explaining comments inline): This is very nice, thanks! Will use this as a test case for the query engine (btw yes it works on my test machine just fine :). more than one match per city then, even with DISTINCT). Picking the current population will become easier

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

2015-04-20 Thread 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? Good catch. My query was too simple (using one random population instead of the biggest

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

2015-04-20 Thread Markus Krötzsch
On 20.04.2015 22:29, Nicola Vitucci wrote: ... I hope this is inspiring to some of you. One could also look for the world's youngest or oldest current mayors with similar queries, for example. Markus, this is really cool! Can I reuse it as an example on WikiSPARQL? :-) Yes, of course.

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

2015-04-20 Thread Markus Krötzsch
On 20.04.2015 22:51, Stas Malyshev wrote: Hi! is as follows (with some explaining comments inline): This is very nice, thanks! Will use this as a test case for the query engine (btw yes it works on my test machine just fine :). more than one match per city then, even with DISTINCT).

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

2015-04-20 Thread Denny Vrandečić
This is seriously awesome! Thank you! On Mon, Apr 20, 2015 at 1:18 PM Markus Krötzsch mar...@semantic-mediawiki.org wrote: Hi all, For many years, Denny and I have been giving talks about why we need to improve the data management in Wikipedia. To explain and motivate this, we have often

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

2015-04-20 Thread Markus Krötzsch
On 20.04.2015 22:21, Denny Vrandečić wrote: This is seriously awesome! Thank you! My pleasure. :-) And here, as a bonus, the list of countries ordered by the number of their cities with female mayor (includes only countries with at least one such city): PREFIX :

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

2015-04-20 Thread Nicola Vitucci
... I hope this is inspiring to some of you. One could also look for the world's youngest or oldest current mayors with similar queries, for example. Markus, this is really cool! Can I reuse it as an example on WikiSPARQL? :-) Cheers, Nicola