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

[Wikidata-l] Nominations being accepted for 2015 Wikimedia Foundation elections

2015-04-20 Thread Gregory Varnum
Greetings, I am pleased to announce that nominations are now being accepted for the 2015 Wikimedia Foundation Elections. This year the Board and the FDC Staff are looking for a diverse set of candidates from regions and projects that are traditionally under-represented on the board and in the

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).

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

2015-04-20 Thread Markus Krötzsch
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 asked the simple question: What are the world's largest cities with a female mayor? The information to answer this is clearly

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

[Wikidata-l] querying wikidata for an unknown relationship between two items

2015-04-20 Thread English, S. Matthew
Hi, I've been trying to create a query in the online editor http://wdq.wmflabs.org/wdq/?q=claim[31:%28tree[12280][][279]%29]%20AND%20tree[183][150][17,131] such that I can retrieve a relationship, unknown to me in advance, for two alpha-numeric IDs (those Q numbers). So for instance, I have

Re: [Wikidata-l] querying wikidata for an unknown relationship between two items

2015-04-20 Thread Markus Krötzsch
Hi Matthew, You can use our experimental SPARQL endpoint http://milenio.dcc.uchile.cl/sparql. It has direct relations for all statements that have no qualifiers, and two-step relations for all statements (with or without qualifiers), which are a bit more complex but give you more power over