Re: [Wikidata-l] World's largest cities with a female mayor :-)
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 showing labels for a given languages? Thanks, GerardM Hi Gerard, what do you mean? Are you looking for something like this? http://wikisparql.org/sparql?query=PREFIX+wd%3A+%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2F%3E%0D%0ASELECT+DISTINCT+%3Fcity+%3Fcitylabel+%3Fmayorlabel+WHERE+%7B%0D%0A++%3Fcity+wd%3AP31s%2Fwd%3AP31v+wd%3AQ515+.%0D%0A++%3Fcity+wd%3AP6s+%3Fstatement+.+++%0D%0A++%3Fstatement+wd%3AP6v+%3Fmayor+.%0D%0A++%3Fmayor+wd%3AP21s%2Fwd%3AP21v+wd%3AQ6581072+.+%0D%0A++FILTER+NOT+EXISTS+%7B+%3Fstatement+wd%3AP582q+%3Fx+%7D%0D%0A++%3Fcity+wd%3AP1082s%2Fwd%3AP1082v%2F%3Chttp%3A%2F%2Fwww.wikidata.org%2Fontology%23numericValue%3E+%3Fpopulation+.%0D%0A++OPTIONAL+%7B%0D%0A%3Fcity+rdfs%3Alabel+%3Fcitylabel+.%0D%0AFILTER+%28+LANG%28%3Fcitylabel%29+%3D+%22es%22+%29%0D%0A++%7D%0D%0A++OPTIONAL+%7B%0D%0A%3Fmayor+rdfs%3Alabel+%3Fmayorlabel+.%0D%0AFILTER+%28+LANG%28%3Fmayorlabel%29+%3D+%22es%22+%29%0D%0A++%7D%0D%0A%7D+ORDER+BY+DESC%28%3Fpopulation%29+LIMIT+100 (The chosen language is Spanish) Nicola Do you not have a URL parameter that resolves to the query source? Example: http://milenio.dcc.uchile.cl/sparql?default-graph-uri=qtxt=PREFIX+wd:+%3Chttp://www.wikidata.org/entity/%3E%0D%0ASELECT+DISTINCT+%3Fcity+%3Fcitylabel+%3Fmayorlabel+WHERE+%7B%0D%0A++%3Fcity++wd:P31s/wd:P31v+wd:Q515+.++%23+find+instances+of+subclasses+of+city%0D%0A++%3Fcity++wd:P6s++%3Fstatement++.++%23+with+a+P6+(head+of+goverment)+statement%0D%0A++%3Fstatement+wd:P6v++%3Fmayor++.++%23+...+that+has+the+value+%3Fmayor%0D%0A++%3Fmayor+wd:P21s/wd:P21v+wd:Q6581072+.++%23+...+where+the+%3Fmayor+has+P21+(sex+or+gender)+female%0D%0A++FILTER+NOT+EXISTS+%7B+%3Fstatement+wd:P582q+%3Fx+%7D++%23+...+but+the+statement+has+no+P582+(end+date)+qualifier%0D%0A+%0D%0A++%23+Now+select+the+population+value+of+the+%3Fcity%0D%0A++%23+(the+number+is+reached+through+a+chain+of+three+properties)%0D%0A++%3Fcity+wd:P1082s/wd:P1082v/%3Chttp://www.wikidata.org/ontology%23numericValue%3E+%3Fpopulation+.%0D%0A%0D%0A++%23+Optionally,+find+English+labels+for+city +and+mayor:%0D%0A++OPTIONAL+%7B%0D%0A%3Fcity+wd:P373s/wd:P373v+%3Fcitylabel+.%0D%0A%23+FILTER+(+LANG(%3Fcitylabel)+%3D+%22en%22+)%0D%0A++%7D%0D%0A++OPTIONAL+%7B%0D%0A%3Fmayor+wd:P373s/wd:P373v+%3Fmayorlabel+.%0D%0A%23+FILTER+(+LANG(%3Fmayorlabel)+%3D+%22en%22+)%0D%0A++%7D%0D%0A%0D%0A%7D+ORDER+BY+DESC(%3Fpopulation)+LIMIT+100format=text/htmlCXML_redir_for_subjs=121CXML_redir_for_hrefs=timeout=3debug=on If not, please paste the query source in a reply. Here's what I mean: Your Query, but via the SPARQL endpoint at: http://milenio.dcc.uchile.cl/sparql, which produces this SPARQL Query Results URL : http://milenio.dcc.uchile.cl/sparql?default-graph-uri=query=%0D%0APREFIX+wd%3A+%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2F%3E%0D%0ASELECT+DISTINCT+%3Fcity+%3Fcitylabel+%3Fmayorlabel+WHERE+%7B%0D%0A++%3Fcity+wd%3AP31s%2Fwd%3AP31v+wd%3AQ515+.%0D%0A++%3Fcity+wd%3AP6s+%3Fstatement+.+++%0D%0A++%3Fstatement+wd%3AP6v+%3Fmayor+.%0D%0A++%3Fmayor+wd%3AP21s%2Fwd%3AP21v+wd%3AQ6581072+.+%0D%0A++FILTER+NOT+EXISTS+%7B+%3Fstatement+wd%3AP582q+%3Fx+%7D%0D%0A++%3Fcity+wd%3AP1082s%2Fwd%3AP1082v%2F%3Chttp%3A%2F%2Fwww.wikidata.org%2Fontology%23numericValue%3E+%3Fpopulation+.%0D%0A++OPTIONAL+%7B%0D%0A%3Fcity+rdfs%3Alabel+%3Fcitylabel+.%0D%0AFILTER+%28+LANG%28%3Fcitylabel%29+%3D+%22es%22+%29%0D%0A++%7D%0D%0A++OPTIONAL+%7B%0D%0A%3Fmayor+rdfs%3Alabel+%3Fmayorlabel+.%0D%0AFILTER+%28+LANG%28%3Fmayorlabel%29+%3D+%22es%22+%29%0D%0A++%7D%0D%0A%7D+ORDER+BY+DESC%28%3Fpopulation%29+LIMIT+100format=text%2Fhtmltimeout=3debug=on Query Definition URL: http://milenio.dcc.uchile.cl/sparql?default-graph-uri=qtxt=%0D%0APREFIX+wd%3A+%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2F%3E%0D%0ASELECT+DISTINCT+%3Fcity+%3Fcitylabel+%3Fmayorlabel+WHERE+%7B%0D%0A++%3Fcity+wd%3AP31s%2Fwd%3AP31v+wd%3AQ515+.%0D%0A++%3Fcity+wd%3AP6s+%3Fstatement+.+++%0D%0A++%3Fstatement+wd%3AP6v+%3Fmayor+.%0D%0A++%3Fmayor+wd%3AP21s%2Fwd%3AP21v+wd%3AQ6581072+.+%0D%0A++FILTER+NOT+EXISTS+%7B+%3Fstatement+wd%3AP582q+%3Fx+%7D%0D%0A++%3Fcity+wd%3AP1082s%2Fwd%3AP1082v%2F%3Chttp%3A%2F%2Fwww.wikidata.org%2Fontology%23numericValue%3E+%3Fpopulation+.%0D%0A++OPTIONAL+%7B%0D%0A%3Fcity+rdfs%3Alabel+%3Fcitylabel+.%0D%0AFILTER+%28+LANG%28%3Fcitylabel%29+%3D+%22es%22+%29%0D%0A++%7D%0D%0A++OPTIONAL+%7B%0D%0A%3Fmayor+rdfs%3Alabel+%3Fmayorlabel+.%0D%0AFILTER+%28+LANG%28%3Fmayorlabel%29+%3D+%22es%22+%29%0D%0A++%7D%0D%0A%7D+ORDER+BY+DESC%28%3Fpopulation%29+LIMIT+100format=text%2Fhtmltimeout=3debug=on For the results using English labels (@en tag) you have query
Re: [Wikidata-l] World's largest cities with a female mayor :-)
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,
GerardM
Hi Gerard,
what do you mean? Are you looking for something like this?
http://wikisparql.org/sparql?query=PREFIX+wd%3A+%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2F%3E%0D%0ASELECT+DISTINCT+%3Fcity+%3Fcitylabel+%3Fmayorlabel+WHERE+%7B%0D%0A++%3Fcity+wd%3AP31s%2Fwd%3AP31v+wd%3AQ515+.%0D%0A++%3Fcity+wd%3AP6s+%3Fstatement+.+++%0D%0A++%3Fstatement+wd%3AP6v+%3Fmayor+.%0D%0A++%3Fmayor+wd%3AP21s%2Fwd%3AP21v+wd%3AQ6581072+.+%0D%0A++FILTER+NOT+EXISTS+%7B+%3Fstatement+wd%3AP582q+%3Fx+%7D%0D%0A++%3Fcity+wd%3AP1082s%2Fwd%3AP1082v%2F%3Chttp%3A%2F%2Fwww.wikidata.org%2Fontology%23numericValue%3E+%3Fpopulation+.%0D%0A++OPTIONAL+%7B%0D%0A%3Fcity+rdfs%3Alabel+%3Fcitylabel+.%0D%0AFILTER+%28+LANG%28%3Fcitylabel%29+%3D+%22es%22+%29%0D%0A++%7D%0D%0A++OPTIONAL+%7B%0D%0A%3Fmayor+rdfs%3Alabel+%3Fmayorlabel+.%0D%0AFILTER+%28+LANG%28%3Fmayorlabel%29+%3D+%22es%22+%29%0D%0A++%7D%0D%0A%7D+ORDER+BY+DESC%28%3Fpopulation%29+LIMIT+100
(The chosen language is Spanish)
Nicola
Do you not have a URL parameter that resolves to the query source?
Example:
http://milenio.dcc.uchile.cl/sparql?default-graph-uri=qtxt=PREFIX+wd:+%3Chttp://www.wikidata.org/entity/%3E%0D%0ASELECT+DISTINCT+%3Fcity+%3Fcitylabel+%3Fmayorlabel+WHERE+%7B%0D%0A++%3Fcity++wd:P31s/wd:P31v+wd:Q515+.++%23+find+instances+of+subclasses+of+city%0D%0A++%3Fcity++wd:P6s++%3Fstatement++.++%23+with+a+P6+(head+of+goverment)+statement%0D%0A++%3Fstatement+wd:P6v++%3Fmayor++.++%23+...+that+has+the+value+%3Fmayor%0D%0A++%3Fmayor+wd:P21s/wd:P21v+wd:Q6581072+.++%23+...+where+the+%3Fmayor+has+P21+(sex+or+gender)+female%0D%0A++FILTER+NOT+EXISTS+%7B+%3Fstatement+wd:P582q+%3Fx+%7D++%23+...+but+the+statement+has+no+P582+(end+date)+qualifier%0D%0A+%0D%0A++%23+Now+select+the+population+value+of+the+%3Fcity%0D%0A++%23+(the+number+is+reached+through+a+chain+of+three+properties)%0D%0A++%3Fcity+wd:P1082s/wd:P1082v/%3Chttp://www.wikidata.org/ontology%23numericValue%3E+%3Fpopulation+.%0D%0A%0D%0A++%23+Optionally,+find+English+labels+for+city+
and+mayor:%0D%0A++OPTIONAL+%7B%0D%0A%3Fcity+wd:P373s/wd:P373v+%3Fcitylabel+.%0D%0A%23+FILTER+(+LANG(%3Fcitylabel)+%3D+%22en%22+)%0D%0A++%7D%0D%0A++OPTIONAL+%7B%0D%0A%3Fmayor+wd:P373s/wd:P373v+%3Fmayorlabel+.%0D%0A%23+FILTER+(+LANG(%3Fmayorlabel)+%3D+%22en%22+)%0D%0A++%7D%0D%0A%0D%0A%7D+ORDER+BY+DESC(%3Fpopulation)+LIMIT+100format=text/htmlCXML_redir_for_subjs=121CXML_redir_for_hrefs=timeout=3debug=on
If not, please paste the query source in a reply.
Hi Kingsley,
currently there is no such parameter, but it's a good idea - I'll add it.
The query source with the Spanish labels is below (replace es with
ru for the Russian labels):
---
PREFIX wd:http://www.wikidata.org/entity/
SELECT DISTINCT ?city ?citylabel ?mayorlabel WHERE {
?city wd:P31s/wd:P31v wd:Q515 .
?city wd:P6s ?statement .
?statement wd:P6v ?mayor .
?mayor wd:P21s/wd:P21v wd:Q6581072 .
FILTER NOT EXISTS { ?statement wd:P582q ?x }
?city
wd:P1082s/wd:P1082v/http://www.wikidata.org/ontology#numericValue
?population .
OPTIONAL {
?city rdfs:label ?citylabel .
FILTER ( LANG(?citylabel) = es )
}
OPTIONAL {
?mayor rdfs:label ?mayorlabel .
FILTER ( LANG(?mayorlabel) = es )
}
} ORDER BY DESC(?population) LIMIT 100
---
Nicola
Yes, I know that. Our responses our a little out of sync. The link I
shared to the query definition exposed what I wanted to share with
others re. use of LANG() and the nature of SELECT list output etc..
Anyway, it would be great if you add the @qtx parameter as alternative
to @query when the goal is identifying a document that's comprised of
the SPARQL Query Definition rather than SPARQL Query Result (or solution).
This is good news!
--
Regards,
Kingsley Idehen
Founder CEO
OpenLink Software
Company Web: http://www.openlinksw.com
Personal Weblog 1: http://kidehen.blogspot.com
Personal Weblog 2: http://www.openlinksw.com/blog/~kidehen
Twitter Profile: https://twitter.com/kidehen
Google+ Profile: https://plus.google.com/+KingsleyIdehen/about
LinkedIn Profile: http://www.linkedin.com/in/kidehen
Personal WebID: http://kingsley.idehen.net/dataspace/person/kidehen#this
smime.p7s
Description: S/MIME Cryptographic Signature
___
Wikidata-l mailing list
Wikidata-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Re: [Wikidata-l] World's largest cities with a female mayor :-)
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 expected to provide essentially the same results for the same query? -Jeremy ___ Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Re: [Wikidata-l] World's largest cities with a female mayor :-)
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? http://wikisparql.org/sparql?query=PREFIX+wd%3A+%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2F%3E%0D%0ASELECT+DISTINCT+%3Fcity+%3Fcitylabel+%3Fmayorlabel+WHERE+%7B%0D%0A++%3Fcity+wd%3AP31s%2Fwd%3AP31v+wd%3AQ515+.%0D%0A++%3Fcity+wd%3AP6s+%3Fstatement+.+++%0D%0A++%3Fstatement+wd%3AP6v+%3Fmayor+.%0D%0A++%3Fmayor+wd%3AP21s%2Fwd%3AP21v+wd%3AQ6581072+.+%0D%0A++FILTER+NOT+EXISTS+%7B+%3Fstatement+wd%3AP582q+%3Fx+%7D%0D%0A++%3Fcity+wd%3AP1082s%2Fwd%3AP1082v%2F%3Chttp%3A%2F%2Fwww.wikidata.org%2Fontology%23numericValue%3E+%3Fpopulation+.%0D%0A++OPTIONAL+%7B%0D%0A%3Fcity+rdfs%3Alabel+%3Fcitylabel+.%0D%0AFILTER+%28+LANG%28%3Fcitylabel%29+%3D+%22es%22+%29%0D%0A++%7D%0D%0A++OPTIONAL+%7B%0D%0A%3Fmayor+rdfs%3Alabel+%3Fmayorlabel+.%0D%0AFILTER+%28+LANG%28%3Fmayorlabel%29+%3D+%22es%22+%29%0D%0A++%7D%0D%0A%7D+ORDER+BY+DESC%28%3Fpopulation%29+LIMIT+100 (The chosen language is Spanish) Nicola Do you not have a URL parameter that resolves to the query source? Example: http://milenio.dcc.uchile.cl/sparql?default-graph-uri=qtxt=PREFIX+wd:+%3Chttp://www.wikidata.org/entity/%3E%0D%0ASELECT+DISTINCT+%3Fcity+%3Fcitylabel+%3Fmayorlabel+WHERE+%7B%0D%0A++%3Fcity++wd:P31s/wd:P31v+wd:Q515+.++%23+find+instances+of+subclasses+of+city%0D%0A++%3Fcity++wd:P6s++%3Fstatement++.++%23+with+a+P6+(head+of+goverment)+statement%0D%0A++%3Fstatement+wd:P6v++%3Fmayor++.++%23+...+that+has+the+value+%3Fmayor%0D%0A++%3Fmayor+wd:P21s/wd:P21v+wd:Q6581072+.++%23+...+where+the+%3Fmayor+has+P21+(sex+or+gender)+female%0D%0A++FILTER+NOT+EXISTS+%7B+%3Fstatement+wd:P582q+%3Fx+%7D++%23+...+but+the+statement+has+no+P582+(end+date)+qualifier%0D%0A+%0D%0A++%23+Now+select+the+population+value+of+the+%3Fcity%0D%0A++%23+(the+number+is+reached+through+a+chain+of+three+properties)%0D%0A++%3Fcity+wd:P1082s/wd:P1082v/%3Chttp://www.wikidata.org/ontology%23numericValue%3E+%3Fpopulation+.%0D%0A%0D%0A++%23+Optionally,+find+English+labels+for+city+and+mayor:%0D%0A++OPTIONAL+%7B%0D%0A%3Fcity+wd:P373s/wd:P373v+%3Fcitylabel+.%0D%0A%23+FILTER+(+LANG(%3Fcitylabel)+%3D+%22en%22+)%0D%0A++%7D%0D%0A++OPTIONAL+%7B%0D%0A%3Fmayor+wd:P373s/wd:P373v+%3Fmayorlabel+.%0D%0A%23+FILTER+(+LANG(%3Fmayorlabel)+%3D+%22en%22+)%0D%0A++%7D%0D%0A%0D%0A%7D+ORDER+BY+DESC(%3Fpopulation)+LIMIT+100format=text/htmlCXML_redir_for_subjs=121CXML_redir_for_hrefs=timeout=3debug=on If not, please paste the query source in a reply. -- Regards, Kingsley Idehen Founder CEO OpenLink Software Company Web: http://www.openlinksw.com Personal Weblog 1: http://kidehen.blogspot.com Personal Weblog 2: http://www.openlinksw.com/blog/~kidehen Twitter Profile: https://twitter.com/kidehen Google+ Profile: https://plus.google.com/+KingsleyIdehen/about LinkedIn Profile: http://www.linkedin.com/in/kidehen Personal WebID: http://kingsley.idehen.net/dataspace/person/kidehen#this smime.p7s Description: S/MIME Cryptographic Signature ___ Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Re: [Wikidata-l] World's largest cities with a female mayor :-)
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 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 in
Wikipedia, but it would be painfully hard to get the result by reading
articles.
I recently had the occasion of actually phrasing this in SPARQL, so that
an answer can now, finally, be given. The query to run at
http://milenio.dcc.uchile.cl/sparql
is as follows (with some explaining comments inline):
PREFIX : http://www.wikidata.org/entity/ SELECT DISTINCT ?city
?citylabel ?mayorlabel WHERE {
?city :P31c/:P279c* :Q515 . # find instances of subclasses of city
?city :P6s ?statement . # with a P6 (head of goverment) statement
?statement :P6v ?mayor . # ... that has the value ?mayor
?mayor :P21c :Q6581072 . # ... where the ?mayor has P21 (sex or
gender) female
FILTER NOT EXISTS { ?statement :P582q ?x } # ... but the statement has
no P582 (end date) qualifier
# Now select the population value of the ?city
# (the number is reached through a chain of three properties)
?city :P1082s/:P1082v/http://www.wikidata.org/ontology#numericValue
?population .
# Optionally, find English labels for city and mayor:
OPTIONAL {
?city rdfs:label ?citylabel .
FILTER ( LANG(?citylabel) = en )
}
OPTIONAL {
?mayor rdfs:label ?mayorlabel .
FILTER ( LANG(?mayorlabel) = en )
}
} ORDER BY DESC(?population) LIMIT 100
To see the results, just paste this into the box at
http://milenio.dcc.uchile.cl/sparql and press Run query.
The query does not filter the most recent population but relies on
Virtuoso to pick the biggest value for DESC sorting, and on the world to
have (mostly) cities with increasing population numbers over time. This is
also the reason why the population is not printed (it would give you more
than one match per city then, even with DISTINCT). Picking the current
population will become easier once ranks are used more widely to mark it.
There might also be some inaccuracies in cases where a past mayor does not
have an end date set in Wikidata (Madrid has a suspiciously large number
of current mayors ...), but a query can only ever be as good as its input
data.
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.
Cheers,
Markus
___
Wikidata-l mailing list
Wikidata-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-l
___
Wikidata-l mailing list
Wikidata-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Re: [Wikidata-l] World's largest cities with a female mayor :-)
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? http://wikisparql.org/sparql?query=PREFIX+wd%3A+%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2F%3E%0D%0ASELECT+DISTINCT+%3Fcity+%3Fcitylabel+%3Fmayorlabel+WHERE+%7B%0D%0A++%3Fcity+wd%3AP31s%2Fwd%3AP31v+wd%3AQ515+.%0D%0A++%3Fcity+wd%3AP6s+%3Fstatement+.+++%0D%0A++%3Fstatement+wd%3AP6v+%3Fmayor+.%0D%0A++%3Fmayor+wd%3AP21s%2Fwd%3AP21v+wd%3AQ6581072+.+%0D%0A++FILTER+NOT+EXISTS+%7B+%3Fstatement+wd%3AP582q+%3Fx+%7D%0D%0A++%3Fcity+wd%3AP1082s%2Fwd%3AP1082v%2F%3Chttp%3A%2F%2Fwww.wikidata.org%2Fontology%23numericValue%3E+%3Fpopulation+.%0D%0A++OPTIONAL+%7B%0D%0A%3Fcity+rdfs%3Alabel+%3Fcitylabel+.%0D%0AFILTER+%28+LANG%28%3Fcitylabel%29+%3D+%22es%22+%29%0D%0A++%7D%0D%0A++OPTIONAL+%7B%0D%0A%3Fmayor+rdfs%3Alabel+%3Fmayorlabel+.%0D%0AFILTER+%28+LANG%28%3Fmayorlabel%29+%3D+%22es%22+%29%0D%0A++%7D%0D%0A%7D+ORDER+BY+DESC%28%3Fpopulation%29+LIMIT+100 (The chosen language is Spanish) Nicola ___ Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Re: [Wikidata-l] World's largest cities with a female mayor :-)
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 Hi Gerard, what do you mean? Are you looking for something like this? http://wikisparql.org/sparql?query=PREFIX+wd%3A+%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2F%3E%0D%0ASELECT+DISTINCT+%3Fcity+%3Fcitylabel+%3Fmayorlabel+WHERE+%7B%0D%0A++%3Fcity+wd%3AP31s%2Fwd%3AP31v+wd%3AQ515+.%0D%0A++%3Fcity+wd%3AP6s+%3Fstatement+.+++%0D%0A++%3Fstatement+wd%3AP6v+%3Fmayor+.%0D%0A++%3Fmayor+wd%3AP21s%2Fwd%3AP21v+wd%3AQ6581072+.+%0D%0A++FILTER+NOT+EXISTS+%7B+%3Fstatement+wd%3AP582q+%3Fx+%7D%0D%0A++%3Fcity+wd%3AP1082s%2Fwd%3AP1082v%2F%3Chttp%3A%2F%2Fwww.wikidata.org%2Fontology%23numericValue%3E+%3Fpopulation+.%0D%0A++OPTIONAL+%7B%0D%0A%3Fcity+rdfs%3Alabel+%3Fcitylabel+.%0D%0AFILTER+%28+LANG%28%3Fcitylabel%29+%3D+%22es%22+%29%0D%0A++%7D%0D%0A++OPTIONAL+%7B%0D%0A%3Fmayor+rdfs%3Alabel+%3Fmayorlabel+.%0D%0AFILTER+%28+LANG%28%3Fmayorlabel%29+%3D+%22es%22+%29%0D%0A++%7D%0D%0A%7D+ORDER+BY+DESC%28%3Fpopulation%29+LIMIT+100 (The chosen language is Spanish) Nicola ___ Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l ___ Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Re: [Wikidata-l] World's largest cities with a female mayor :-)
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 mean? Are you looking for something like this?
http://wikisparql.org/sparql?query=PREFIX+wd%3A+%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2F%3E%0D%0ASELECT+DISTINCT+%3Fcity+%3Fcitylabel+%3Fmayorlabel+WHERE+%7B%0D%0A++%3Fcity+wd%3AP31s%2Fwd%3AP31v+wd%3AQ515+.%0D%0A++%3Fcity+wd%3AP6s+%3Fstatement+.+++%0D%0A++%3Fstatement+wd%3AP6v+%3Fmayor+.%0D%0A++%3Fmayor+wd%3AP21s%2Fwd%3AP21v+wd%3AQ6581072+.+%0D%0A++FILTER+NOT+EXISTS+%7B+%3Fstatement+wd%3AP582q+%3Fx+%7D%0D%0A++%3Fcity+wd%3AP1082s%2Fwd%3AP1082v%2F%3Chttp%3A%2F%2Fwww.wikidata.org%2Fontology%23numericValue%3E+%3Fpopulation+.%0D%0A++OPTIONAL+%7B%0D%0A%3Fcity+rdfs%3Alabel+%3Fcitylabel+.%0D%0AFILTER+%28+LANG%28%3Fcitylabel%29+%3D+%22es%22+%29%0D%0A++%7D%0D%0A++OPTIONAL+%7B%0D%0A%3Fmayor+rdfs%3Alabel+%3Fmayorlabel+.%0D%0AFILTER+%28+LANG%28%3Fmayorlabel%29+%3D+%22es%22+%29%0D%0A++%7D%0D%0A%7D+ORDER+BY+DESC%28%3Fpopulation%29+LIMIT+100
(The chosen language is Spanish)
Nicola
Do you not have a URL parameter that resolves to the query source?
Example:
http://milenio.dcc.uchile.cl/sparql?default-graph-uri=qtxt=PREFIX+wd:+%3Chttp://www.wikidata.org/entity/%3E%0D%0ASELECT+DISTINCT+%3Fcity+%3Fcitylabel+%3Fmayorlabel+WHERE+%7B%0D%0A++%3Fcity++wd:P31s/wd:P31v+wd:Q515+.++%23+find+instances+of+subclasses+of+city%0D%0A++%3Fcity++wd:P6s++%3Fstatement++.++%23+with+a+P6+(head+of+goverment)+statement%0D%0A++%3Fstatement+wd:P6v++%3Fmayor++.++%23+...+that+has+the+value+%3Fmayor%0D%0A++%3Fmayor+wd:P21s/wd:P21v+wd:Q6581072+.++%23+...+where+the+%3Fmayor+has+P21+(sex+or+gender)+female%0D%0A++FILTER+NOT+EXISTS+%7B+%3Fstatement+wd:P582q+%3Fx+%7D++%23+...+but+the+statement+has+no+P582+(end+date)+qualifier%0D%0A+%0D%0A++%23+Now+select+the+population+value+of+the+%3Fcity%0D%0A++%23+(the+number+is+reached+through+a+chain+of+three+properties)%0D%0A++%3Fcity+wd:P1082s/wd:P1082v/%3Chttp://www.wikidata.org/ontology%23numericValue%3E+%3Fpopulation+.%0D%0A%0D%0A++%23+Optionally,+find+English+labels+for+city+
and+mayor:%0D%0A++OPTIONAL+%7B%0D%0A%3Fcity+wd:P373s/wd:P373v+%3Fcitylabel+.%0D%0A%23+FILTER+(+LANG(%3Fcitylabel)+%3D+%22en%22+)%0D%0A++%7D%0D%0A++OPTIONAL+%7B%0D%0A%3Fmayor+wd:P373s/wd:P373v+%3Fmayorlabel+.%0D%0A%23+FILTER+(+LANG(%3Fmayorlabel)+%3D+%22en%22+)%0D%0A++%7D%0D%0A%0D%0A%7D+ORDER+BY+DESC(%3Fpopulation)+LIMIT+100format=text/htmlCXML_redir_for_subjs=121CXML_redir_for_hrefs=timeout=3debug=on
If not, please paste the query source in a reply.
Hi Kingsley,
currently there is no such parameter, but it's a good idea - I'll add it.
The query source with the Spanish labels is below (replace es with
ru for the Russian labels):
---
PREFIX wd: http://www.wikidata.org/entity/
SELECT DISTINCT ?city ?citylabel ?mayorlabel WHERE {
?city wd:P31s/wd:P31v wd:Q515 .
?city wd:P6s ?statement .
?statement wd:P6v ?mayor .
?mayor wd:P21s/wd:P21v wd:Q6581072 .
FILTER NOT EXISTS { ?statement wd:P582q ?x }
?city
wd:P1082s/wd:P1082v/http://www.wikidata.org/ontology#numericValue
?population .
OPTIONAL {
?city rdfs:label ?citylabel .
FILTER ( LANG(?citylabel) = es )
}
OPTIONAL {
?mayor rdfs:label ?mayorlabel .
FILTER ( LANG(?mayorlabel) = es )
}
} ORDER BY DESC(?population) LIMIT 100
---
Nicola
___
Wikidata-l mailing list
Wikidata-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Re: [Wikidata-l] World's largest cities with a female mayor :-)
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, GerardM Hi Gerard, what do you mean? Are you looking for something like this? http://wikisparql.org/sparql?query=PREFIX+wd%3A+%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2F%3E%0D%0ASELECT+DISTINCT+%3Fcity+%3Fcitylabel+%3Fmayorlabel+WHERE+%7B%0D%0A++%3Fcity+wd%3AP31s%2Fwd%3AP31v+wd%3AQ515+.%0D%0A++%3Fcity+wd%3AP6s+%3Fstatement+.+++%0D%0A++%3Fstatement+wd%3AP6v+%3Fmayor+.%0D%0A++%3Fmayor+wd%3AP21s%2Fwd%3AP21v+wd%3AQ6581072+.+%0D%0A++FILTER+NOT+EXISTS+%7B+%3Fstatement+wd%3AP582q+%3Fx+%7D%0D%0A++%3Fcity+wd%3AP1082s%2Fwd%3AP1082v%2F%3Chttp%3A%2F%2Fwww.wikidata.org%2Fontology%23numericValue%3E+%3Fpopulation+.%0D%0A++OPTIONAL+%7B%0D%0A%3Fcity+rdfs%3Alabel+%3Fcitylabel+.%0D%0AFILTER+%28+LANG%28%3Fcitylabel%29+%3D+%22es%22+%29%0D%0A++%7D%0D%0A++OPTIONAL+%7B%0D%0A%3Fmayor+rdfs%3Alabel+%3Fmayorlabel+.%0D%0AFILTER+%28+LANG%28%3Fmayorlabel%29+%3D+%22es%22+%29%0D%0A++%7D%0D%0A%7D+ORDER+BY+DESC%28%3Fpopulation%29+LIMIT+100 (The chosen language is Spanish) Nicola Do you not have a URL parameter that resolves to the query source? Example: http://milenio.dcc.uchile.cl/sparql?default-graph-uri=qtxt=PREFIX+wd:+%3Chttp://www.wikidata.org/entity/%3E%0D%0ASELECT+DISTINCT+%3Fcity+%3Fcitylabel+%3Fmayorlabel+WHERE+%7B%0D%0A++%3Fcity++wd:P31s/wd:P31v+wd:Q515+.++%23+find+instances+of+subclasses+of+city%0D%0A++%3Fcity++wd:P6s++%3Fstatement++.++%23+with+a+P6+(head+of+goverment)+statement%0D%0A++%3Fstatement+wd:P6v++%3Fmayor++.++%23+...+that+has+the+value+%3Fmayor%0D%0A++%3Fmayor+wd:P21s/wd:P21v+wd:Q6581072+.++%23+...+where+the+%3Fmayor+has+P21+(sex+or+gender)+female%0D%0A++FILTER+NOT+EXISTS+%7B+%3Fstatement+wd:P582q+%3Fx+%7D++%23+...+but+the+statement+has+no+P582+(end+date)+qualifier%0D%0A+%0D%0A++%23+Now+select+the+population+value+of+the+%3Fcity%0D%0A++%23+(the+number+is+reached+through+a+chain+of+three+properties)%0D%0A++%3Fcity+wd:P1082s/wd:P1082v/%3Chttp://www.wikidata.org/ontology%23numericValue%3E+%3Fpopulation+.%0D%0A%0D%0A++%23+Optionally,+find+English+labels+for+city +and+mayor:%0D%0A++OPTIONAL+%7B%0D%0A%3Fcity+wd:P373s/wd:P373v+%3Fcitylabel+.%0D%0A%23+FILTER+(+LANG(%3Fcitylabel)+%3D+%22en%22+)%0D%0A++%7D%0D%0A++OPTIONAL+%7B%0D%0A%3Fmayor+wd:P373s/wd:P373v+%3Fmayorlabel+.%0D%0A%23+FILTER+(+LANG(%3Fmayorlabel)+%3D+%22en%22+)%0D%0A++%7D%0D%0A%0D%0A%7D+ORDER+BY+DESC(%3Fpopulation)+LIMIT+100format=text/htmlCXML_redir_for_subjs=121CXML_redir_for_hrefs=timeout=3debug=on If not, please paste the query source in a reply. Here's what I mean: Your Query, but via the SPARQL endpoint at: http://milenio.dcc.uchile.cl/sparql, which produces this SPARQL Query Results URL : http://milenio.dcc.uchile.cl/sparql?default-graph-uri=query=%0D%0APREFIX+wd%3A+%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2F%3E%0D%0ASELECT+DISTINCT+%3Fcity+%3Fcitylabel+%3Fmayorlabel+WHERE+%7B%0D%0A++%3Fcity+wd%3AP31s%2Fwd%3AP31v+wd%3AQ515+.%0D%0A++%3Fcity+wd%3AP6s+%3Fstatement+.+++%0D%0A++%3Fstatement+wd%3AP6v+%3Fmayor+.%0D%0A++%3Fmayor+wd%3AP21s%2Fwd%3AP21v+wd%3AQ6581072+.+%0D%0A++FILTER+NOT+EXISTS+%7B+%3Fstatement+wd%3AP582q+%3Fx+%7D%0D%0A++%3Fcity+wd%3AP1082s%2Fwd%3AP1082v%2F%3Chttp%3A%2F%2Fwww.wikidata.org%2Fontology%23numericValue%3E+%3Fpopulation+.%0D%0A++OPTIONAL+%7B%0D%0A%3Fcity+rdfs%3Alabel+%3Fcitylabel+.%0D%0AFILTER+%28+LANG%28%3Fcitylabel%29+%3D+%22es%22+%29%0D%0A++%7D%0D%0A++OPTIONAL+%7B%0D%0A%3Fmayor+rdfs%3Alabel+%3Fmayorlabel+.%0D%0AFILTER+%28+LANG%28%3Fmayorlabel%29+%3D+%22es%22+%29%0D%0A++%7D%0D%0A%7D+ORDER+BY+DESC%28%3Fpopulation%29+LIMIT+100format=text%2Fhtmltimeout=3debug=on Query Definition URL: http://milenio.dcc.uchile.cl/sparql?default-graph-uri=qtxt=%0D%0APREFIX+wd%3A+%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2F%3E%0D%0ASELECT+DISTINCT+%3Fcity+%3Fcitylabel+%3Fmayorlabel+WHERE+%7B%0D%0A++%3Fcity+wd%3AP31s%2Fwd%3AP31v+wd%3AQ515+.%0D%0A++%3Fcity+wd%3AP6s+%3Fstatement+.+++%0D%0A++%3Fstatement+wd%3AP6v+%3Fmayor+.%0D%0A++%3Fmayor+wd%3AP21s%2Fwd%3AP21v+wd%3AQ6581072+.+%0D%0A++FILTER+NOT+EXISTS+%7B+%3Fstatement+wd%3AP582q+%3Fx+%7D%0D%0A++%3Fcity+wd%3AP1082s%2Fwd%3AP1082v%2F%3Chttp%3A%2F%2Fwww.wikidata.org%2Fontology%23numericValue%3E+%3Fpopulation+.%0D%0A++OPTIONAL+%7B%0D%0A%3Fcity+rdfs%3Alabel+%3Fcitylabel+.%0D%0AFILTER+%28+LANG%28%3Fcitylabel%29+%3D+%22es%22+%29%0D%0A++%7D%0D%0A++OPTIONAL+%7B%0D%0A%3Fmayor+rdfs%3Alabel+%3Fmayorlabel+.%0D%0AFILTER+%28+LANG%28%3Fmayorlabel%29+%3D+%22es%22+%29%0D%0A++%7D%0D%0A%7D+ORDER+BY+DESC%28%3Fpopulation%29+LIMIT+100format=text%2Fhtmltimeout=3debug=on For the results using English labels (@en tag) you have query result:
Re: [Wikidata-l] World's largest cities with a female mayor :-)
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 looking for something like this? http://wikisparql.org/sparql?query=PREFIX+wd%3A+%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2F%3E%0D%0ASELECT+DISTINCT+%3Fcity+%3Fcitylabel+%3Fmayorlabel+WHERE+%7B%0D%0A++%3Fcity+wd%3AP31s%2Fwd%3AP31v+wd%3AQ515+.%0D%0A++%3Fcity+wd%3AP6s+%3Fstatement+.+++%0D%0A++%3Fstatement+wd%3AP6v+%3Fmayor+.%0D%0A++%3Fmayor+wd%3AP21s%2Fwd%3AP21v+wd%3AQ6581072+.+%0D%0A++FILTER+NOT+EXISTS+%7B+%3Fstatement+wd%3AP582q+%3Fx+%7D%0D%0A++%3Fcity+wd%3AP1082s%2Fwd%3AP1082v%2F%3Chttp%3A%2F%2Fwww.wikidata.org%2Fontology%23numericValue%3E+%3Fpopulation+.%0D%0A++OPTIONAL+%7B%0D%0A%3Fcity+rdfs%3Alabel+%3Fcitylabel+.%0D%0AFILTER+%28+LANG%28%3Fcitylabel%29+%3D+%22es%22+%29%0D%0A++%7D%0D%0A++OPTIONAL+%7B%0D%0A%3Fmayor+rdfs%3Alabel+%3Fmayorlabel+.%0D%0AFILTER+%28+LANG%28%3Fmayorlabel%29+%3D+%22es%22+%29%0D%0A++%7D%0D%0A%7D+ORDER+BY+DESC%28%3Fpopulation%29+LIMIT+100 (The chosen language is Spanish) Nicola Do you not have a URL parameter that resolves to the query source? Example: http://milenio.dcc.uchile.cl/sparql?default-graph-uri=qtxt=PREFIX+wd:+%3Chttp://www.wikidata.org/entity/%3E%0D%0ASELECT+DISTINCT+%3Fcity+%3Fcitylabel+%3Fmayorlabel+WHERE+%7B%0D%0A++%3Fcity++wd:P31s/wd:P31v+wd:Q515+.++%23+find+instances+of+subclasses+of+city%0D%0A++%3Fcity++wd:P6s++%3Fstatement++.++%23+with+a+P6+(head+of+goverment)+statement%0D%0A++%3Fstatement+wd:P6v++%3Fmayor++.++%23+...+that+has+the+value+%3Fmayor%0D%0A++%3Fmayor+wd:P21s/wd:P21v+wd:Q6581072+.++%23+...+where+the+%3Fmayor+has+P21+(sex+or+gender)+female%0D%0A++FILTER+NOT+EXISTS+%7B+%3Fstatement+wd:P582q+%3Fx+%7D++%23+...+but+the+statement+has+no+P582+(end+date)+qualifier%0D%0A+%0D%0A++%23+Now+select+the+population+value+of+the+%3Fcity%0D%0A++%23+(the+number+is+reached+through+a+chain+of+three+properties)%0D%0A++%3Fcity+wd:P1082s/wd:P1082v/%3Chttp://www.wikidata.org/ontology%23numericValue%3E+%3Fpopulation+.%0D%0A%0D%0A++%23+Optionally,+find+English+labels+for+city+and+mayor:%0D%0A++OPTIONAL+%7B%0D%0A%3Fcity+wd:P373s/wd:P373v+%3Fcitylabel+.%0D%0A%23+FILTER+(+LANG(%3Fcitylabel)+%3D+%22en%22+)%0D%0A++%7D%0D%0A++OPTIONAL+%7B%0D%0A%3Fmayor+wd:P373s/wd:P373v+%3Fmayorlabel+.%0D%0A%23+FILTER+(+LANG(%3Fmayorlabel)+%3D+%22en%22+)%0D%0A++%7D%0D%0A%0D%0A%7D+ORDER+BY+DESC(%3Fpopulation)+LIMIT+100format=text/htmlCXML_redir_for_subjs=121CXML_redir_for_hrefs=timeout=3debug=on If not, please paste the query source in a reply. Here's what I mean: Your Query, but via the SPARQL endpoint at: http://milenio.dcc.uchile.cl/sparql, which produces this SPARQL Query Results URL : http://milenio.dcc.uchile.cl/sparql?default-graph-uri=query=%0D%0APREFIX+wd%3A+%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2F%3E%0D%0ASELECT+DISTINCT+%3Fcity+%3Fcitylabel+%3Fmayorlabel+WHERE+%7B%0D%0A++%3Fcity+wd%3AP31s%2Fwd%3AP31v+wd%3AQ515+.%0D%0A++%3Fcity+wd%3AP6s+%3Fstatement+.+++%0D%0A++%3Fstatement+wd%3AP6v+%3Fmayor+.%0D%0A++%3Fmayor+wd%3AP21s%2Fwd%3AP21v+wd%3AQ6581072+.+%0D%0A++FILTER+NOT+EXISTS+%7B+%3Fstatement+wd%3AP582q+%3Fx+%7D%0D%0A++%3Fcity+wd%3AP1082s%2Fwd%3AP1082v%2F%3Chttp%3A%2F%2Fwww.wikidata.org%2Fontology%23numericValue%3E+%3Fpopulation+.%0D%0A++OPTIONAL+%7B%0D%0A%3Fcity+rdfs%3Alabel+%3Fcitylabel+.%0D%0AFILTER+%28+LANG%28%3Fcitylabel%29+%3D+%22es%22+%29%0D%0A++%7D%0D%0A++OPTIONAL+%7B%0D%0A%3Fmayor+rdfs%3Alabel+%3Fmayorlabel+.%0D%0AFILTER+%28+LANG%28%3Fmayorlabel%29+%3D+%22es%22+%29%0D%0A++%7D%0D%0A%7D+ORDER+BY+DESC%28%3Fpopulation%29+LIMIT+100format=text%2Fhtmltimeout=3debug=on Query Definition URL: http://milenio.dcc.uchile.cl/sparql?default-graph-uri=qtxt=%0D%0APREFIX+wd%3A+%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2F%3E%0D%0ASELECT+DISTINCT+%3Fcity+%3Fcitylabel+%3Fmayorlabel+WHERE+%7B%0D%0A++%3Fcity+wd%3AP31s%2Fwd%3AP31v+wd%3AQ515+.%0D%0A++%3Fcity+wd%3AP6s+%3Fstatement+.+++%0D%0A++%3Fstatement+wd%3AP6v+%3Fmayor+.%0D%0A++%3Fmayor+wd%3AP21s%2Fwd%3AP21v+wd%3AQ6581072+.+%0D%0A++FILTER+NOT+EXISTS+%7B+%3Fstatement+wd%3AP582q+%3Fx+%7D%0D%0A++%3Fcity+wd%3AP1082s%2Fwd%3AP1082v%2F%3Chttp%3A%2F%2Fwww.wikidata.org%2Fontology%23numericValue%3E+%3Fpopulation+.%0D%0A++OPTIONAL+%7B%0D%0A%3Fcity+rdfs%3Alabel+%3Fcitylabel+.%0D%0AFILTER+%28+LANG%28%3Fcitylabel%29+%3D+%22es%22+%29%0D%0A++%7D%0D%0A++OPTIONAL+%7B%0D%0A%3Fmayor+rdfs%3Alabel+%3Fmayorlabel+.%0D%0AFILTER+%28+LANG%28%3Fmayorlabel%29+%3D+%22es%22+%29%0D%0A++%7D%0D%0A%7D+ORDER+BY+DESC%28%3Fpopulation%29+LIMIT+100format=text%2Fhtmltimeout=3debug=on For the results using English labels (@en tag) you have query result:
Re: [Wikidata-l] World's largest cities with a female mayor :-)
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 an example. Lydia, would this be something for the WMDE Blog? Markus, this is way cool! Good to see we have achieved a milestone ;-) If you want to write something up for the WMDE blog that's be great. Cheers Lydia -- Lydia Pintscher - http://about.me/lydia.pintscher Product Manager for Wikidata Wikimedia Deutschland e.V. Tempelhofer Ufer 23-24 10963 Berlin www.wikimedia.de Wikimedia Deutschland - Gesellschaft zur Förderung Freien Wissens e. V. Eingetragen im Vereinsregister des Amtsgerichts Berlin-Charlottenburg unter der Nummer 23855 Nz. Als gemeinnützig anerkannt durch das Finanzamt für Körperschaften I Berlin, Steuernummer 27/681/51985. ___ Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Re: [Wikidata-l] World's largest cities with a female mayor :-)
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
subclasses of city
?city wd:P6s ?statement . # with a P6 (head of
goverment) statement
?statement wd:P6v ?mayor . # ... that has the
value ?mayor
?mayor wd:P21s/wd:P21v wd:Q6581072 . # ... where the ?mayor
has P21 (sex or gender) female
FILTER NOT EXISTS { ?statement wd:P582q ?x } # ... but the
statement has no P582 (end date) qualifier
# Now select the population value of the ?city
# (the number is reached through a chain of three properties)
?city
wd:P1082s/wd:P1082v/http://www.wikidata.org/ontology#numericValue
?population .
# Optionally, find English labels for city and mayor:
OPTIONAL {
?city wd:P373s/wd:P373v ?citylabel .
# FILTER ( LANG(?citylabel) = en )
}
OPTIONAL {
?mayor wd:P373s/wd:P373v ?mayorlabel .
# FILTER ( LANG(?mayorlabel) = en )
}
} ORDER BY DESC(?population) LIMIT 100
Free beer to anyone who can figure out how to use those language
filters. Would we need to also load property definitions[2]?
1.
http://tools.wmflabs.org/wikidata-exports/rdf/exports/20150223/wikidata-statements.nt.gz
2.
http://tools.wmflabs.org/wikidata-exports/rdf/exports/20150223/wikidata-properties.nt.gz
Please try to share SPARQL related examples using SPARQL Query Results
URLs that identity documents where the content is dynamically generated
via SPARQL query processing. It makes them easier to tweak and diagnose,
amongst other things.
Examples:
1. http://bit.ly/wikidata-query-example-cities-with-female-mayor --
shortened query results url
BTW -- for language tags to work, the content would have to have also
been language tagged using xyz@en prior to upload to DBMS. Then,
modulo use of LANG filter, you would be seeing stuff like Madrid@en in
the output produced by the SELECT LIST.
Kingsley
On Tue, Apr 21, 2015 at 11:13 AM, Jeremy Baron jer...@tuxmachine.com
mailto:jer...@tuxmachine.com wrote:
Hi,
On Tue, Apr 21, 2015 at 5:05 PM, Thad Guidry thadgui...@gmail.com
mailto: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 where a lot of those numbers are from.
Also, maybe Houston is a bad example because the Census Bureau revised
numbers after the data was released.[0] Even some official Census
Bureau sites still report the old, pre-appeal number.[1]
There are multiple years that have duplicate conflicting values after
clicking 65 values total » at your link. At first I was thinking it
may be something like estimates base vs. estimate vs. decennial.
However, for 2010 and 2011 there's one value that matches estimate
from [1] (source = [2]) and a larger value (source = [3]) that does
not match any other data I've seen. [2] and [3] both use the same
Attribution URI [4].
In any case, why take this from freebase instead of importing directly
from Census Bureau data? It's available in bulk. Format isn't great
but isn't horrible either. (at least the 5-year ACS is inconsistent
about upper/lower case for state two letter abbreviations. and, I
think, most humans would prefer something like a geoid as a key rather
than a dataset specific key used to look up the geoid in a different
file. and other quirks)
-Jeremy
[0]
http://www.chron.com/news/houston-texas/houston/article/City-wins-census-appeal-count-adjusted-4087372.php
[1]
http://factfinder.census.gov/bkmk/table/1.0/en/PEP/2013/PEPANNRES/162US4835000
[2] https://www.freebase.com/g/11x1k306j
[3] https://www.freebase.com/m/0jst35z
[4] http://www.census.gov/popest/about/terms.html
___
Wikidata-l mailing list
Wikidata-l@lists.wikimedia.org mailto:Wikidata-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-l
___
Wikidata-l mailing list
Wikidata-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-l
--
Regards,
Kingsley Idehen
Founder CEO
OpenLink Software
Company Web: http://www.openlinksw.com
Personal Weblog 1: http://kidehen.blogspot.com
Personal Weblog 2: http://www.openlinksw.com/blog/~kidehen
Twitter Profile: https://twitter.com/kidehen
Google+ Profile: https://plus.google.com/+KingsleyIdehen/about
LinkedIn Profile: http://www.linkedin.com/in/kidehen
Personal WebID: http://kingsley.idehen.net/dataspace/person/kidehen#this
smime.p7s
Description: S/MIME
Re: [Wikidata-l] World's largest cities with a female mayor :-)
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 instances of
subclasses of city
?city wd:P6s ?statement . # with a P6 (head of
goverment) statement
?statement wd:P6v ?mayor . # ... that has the value
?mayor
?mayor wd:P21s/wd:P21v wd:Q6581072 . # ... where the ?mayor
has P21 (sex or gender) female
FILTER NOT EXISTS { ?statement wd:P582q ?x } # ... but the statement
has no P582 (end date) qualifier
# Now select the population value of the ?city
# (the number is reached through a chain of three properties)
?city
wd:P1082s/wd:P1082v/http://www.wikidata.org/ontology#numericValue
?population .
# Optionally, find English labels for city and mayor:
OPTIONAL {
?city wd:P373s/wd:P373v ?citylabel .
# FILTER ( LANG(?citylabel) = en )
}
OPTIONAL {
?mayor wd:P373s/wd:P373v ?mayorlabel .
# FILTER ( LANG(?mayorlabel) = en )
}
} ORDER BY DESC(?population) LIMIT 100
Free beer to anyone who can figure out how to use those language
filters. Would we need to also load property definitions[2]?
James,
I believe language filters are defined only on rdfs:label, not on the
P373 property(-ies). Replace wd:P373s/wd:P373v with rdfs:label and it
will work.
Nicola
P.S. Where is my beer? :-)
___
Wikidata-l mailing list
Wikidata-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Re: [Wikidata-l] World's largest cities with a female mayor :-)
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 where a lot of those numbers are from. Also, maybe Houston is a bad example because the Census Bureau revised numbers after the data was released.[0] Even some official Census Bureau sites still report the old, pre-appeal number.[1] There are multiple years that have duplicate conflicting values after clicking 65 values total » at your link. At first I was thinking it may be something like estimates base vs. estimate vs. decennial. However, for 2010 and 2011 there's one value that matches estimate from [1] (source = [2]) and a larger value (source = [3]) that does not match any other data I've seen. [2] and [3] both use the same Attribution URI [4]. In any case, why take this from freebase instead of importing directly from Census Bureau data? It's available in bulk. Format isn't great but isn't horrible either. (at least the 5-year ACS is inconsistent about upper/lower case for state two letter abbreviations. and, I think, most humans would prefer something like a geoid as a key rather than a dataset specific key used to look up the geoid in a different file. and other quirks) -Jeremy [0] http://www.chron.com/news/houston-texas/houston/article/City-wins-census-appeal-count-adjusted-4087372.php [1] http://factfinder.census.gov/bkmk/table/1.0/en/PEP/2013/PEPANNRES/162US4835000 [2] https://www.freebase.com/g/11x1k306j [3] https://www.freebase.com/m/0jst35z [4] http://www.census.gov/popest/about/terms.html ___ Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Re: [Wikidata-l] World's largest cities with a female mayor :-)
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 area: the ''head of goverment'' of cities is also present as a ''office heald'' : ''mayor of foo'', if there is an item ''mayor of foo'' (and this seems better than just ''office heald:mayor''). Tom 2015-04-21 11:27 GMT+02:00 Daniel Kinzler daniel.kinz...@wikimedia.de: 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? Good catch. My query was too simple (using one random population instead of the biggest one). Here is a better query, this time even with populations given: I still wonder how the old result came about, since the *all* population values for Munich are much bigger than *all* the population numbers for Chemnitz. Even with picking a random value, how could the order have been reversed? -- Daniel Kinzler Senior Software Developer Wikimedia Deutschland Gesellschaft zur Förderung Freien Wissens e.V. ___ Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l ___ Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Re: [Wikidata-l] World's largest cities with a female mayor :-)
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,
so the query will have to change accordingly in the future.
Markus
On Mon, Apr 20, 2015 at 3:50 PM, Markus Krötzsch
mar...@semantic-mediawiki.org mailto:mar...@semantic-mediawiki.org
wrote:
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 one). Here is a better query, this time even
with populations given:
PREFIX : http://www.wikidata.org/entity/
SELECT ?city (MAX(?population) AS ?max_population) ?citylabel
?mayorlabel WHERE {
?city :P31c/:P279c* :Q515 . # find instances of subclasses of city
?city :P6s ?statement . # with a P6 (head of goverment) statement
?statement :P6v ?mayor . # ... that has the value ?mayor
?mayor :P21c :Q6581072 . # ... where the ?mayor has P21 (sex
or gender) female
FILTER NOT EXISTS { ?statement :P582q ?x } # ... but the
statement has no P582 (end date) qualifier
# Now select the population value of the ?city
# (the number is reached through a chain of three properties)
?city
:P1082s/:P1082v/http://www.wikidata.org/ontology#numericValue
?population .
# Optionally, find English labels for city and mayor:
OPTIONAL {
?city rdfs:label ?citylabel .
FILTER ( LANG(?citylabel) = en )
}
OPTIONAL {
?mayor rdfs:label ?mayorlabel .
FILTER ( LANG(?mayorlabel) = en )
}
} GROUP BY ?city ?citylabel ?mayorlabel
ORDER BY DESC(?max_population) LIMIT 100
Oh... maybe quantity values are sorted in alphanumeric order,
because they are
decimal strings? They should be xsd:decimal...
They are.
Markus
Am 20.04.2015 um 22:18 schrieb 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 in
Wikipedia, but it would be
painfully hard to get the result by reading articles.
I recently had the occasion of actually phrasing this in
SPARQL, so that an
answer can now, finally, be given. The query to run at
http://milenio.dcc.uchile.cl/sparql
is as follows (with some explaining comments inline):
PREFIX : http://www.wikidata.org/entity/ SELECT DISTINCT
?city ?citylabel
?mayorlabel WHERE {
?city :P31c/:P279c* :Q515 . # find instances of
subclasses of city
?city :P6s ?statement . # with a P6 (head of
goverment) statement
?statement :P6v ?mayor . # ... that has the value ?mayor
?mayor :P21c :Q6581072 . # ... where the ?mayor has
P21 (sex or gender) female
FILTER NOT EXISTS { ?statement :P582q ?x } # ... but the
statement has no P582
(end date) qualifier
# Now select the population value of the ?city
# (the number is reached through a chain of three properties)
?city
:P1082s/:P1082v/http://www.wikidata.org/ontology#numericValue
?population .
# Optionally, find English labels for city and mayor:
OPTIONAL {
?city rdfs:label ?citylabel .
FILTER ( LANG(?citylabel) = en )
}
OPTIONAL {
?mayor rdfs:label ?mayorlabel .
FILTER ( LANG(?mayorlabel) = en )
}
} ORDER BY DESC(?population) LIMIT 100
To see the results, just paste this into the box at
http://milenio.dcc.uchile.cl/sparql and press Run query.
The query does not filter the most recent population but
relies on Virtuoso to
pick the biggest value for DESC sorting, and on the world to
have (mostly)
cities with increasing population numbers over time. This is
also the reason why
the population is not printed (it would give you more than
one match per city
then, even with DISTINCT). Picking the current
Re: [Wikidata-l] World's largest cities with a female mayor :-)
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? Good catch. My query was too simple (using one random population instead of the biggest one). Here is a better query, this time even with populations given: I still wonder how the old result came about, since the *all* population values for Munich are much bigger than *all* the population numbers for Chemnitz. Even with picking a random value, how could the order have been reversed? Good question. I don't know. Maybe there is some issue in Virtuoso here after all. However, the rest of the order looked sensible to me even in the old query. It could also be that our (non-live) data had a temporary glitch that has been fixed on Wikidata in the meantime; one should check the population values we get with SPARQL to be sure. Cheers, Markus ___ Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Re: [Wikidata-l] World's largest cities with a female mayor :-)
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ö (Sweden) Montevideo (Uruguay) Windhoek (Namibia) Cities whose current mayors we don't have articles on yet: Baghdad (Iraq) Prague (Czech Republic) Nantes (France) (The above based on educated guesses from https://en.wikipedia.org/wiki/List_of_first_female_mayors#2010s ) Thanks, Richard (User:Pharos) On Tue, Apr 21, 2015 at 10:17 AM, Nicola Vitucci nicola.vitu...@gmail.com 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 an example. Lydia, would this be something for the WMDE Blog? Markus I'm going to write up a sort of tutorial with example queries too (including this one), so if needed I might help. Nicola ___ Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l ___ Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Re: [Wikidata-l] World's largest cities with a female mayor :-)
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 them. :) https://www.wikidata.org/wiki/special:diff/208946888/212095823 -Jeremy ___ Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Re: [Wikidata-l] World's largest cities with a female mayor :-)
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 going to write up a sort of tutorial with example queries too (including this one), so if needed I might help. Nicola ___ Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Re: [Wikidata-l] World's largest cities with a female mayor :-)
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 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) Columbus, Georgia (USA) Diyarbakır (Turkey) Gary, Indiana (USA) Knoxville, Tennessee (USA) Łódź (Poland) Malmö (Sweden) Montevideo (Uruguay) Windhoek (Namibia) Cities whose current mayors we don't have articles on yet: Baghdad (Iraq) Prague (Czech Republic) Nantes (France) (The above based on educated guesses from https://en.wikipedia.org/wiki/List_of_first_female_mayors#2010s ) Thanks, Richard (User:Pharos) On Tue, Apr 21, 2015 at 10:17 AM, Nicola Vitucci nicola.vitu...@gmail.com 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 an example. Lydia, would this be something for the WMDE Blog? Markus I'm going to write up a sort of tutorial with example queries too (including this one), so if needed I might help. Nicola ___ Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l ___ Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Re: [Wikidata-l] World's largest cities with a female mayor :-)
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 ___ Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Re: [Wikidata-l] World's largest cities with a female mayor :-)
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 - https://www.freebase.com/m/03l2n#/location/statistical_region and Paris - https://www.freebase.com/m/05qtj#/location/statistical_region The cut-off in the USA is based on Census data collection years. Thad +ThadGuidry https://www.google.com/+ThadGuidry On Tue, Apr 21, 2015 at 9:56 AM, Jeremy Baron jer...@tuxmachine.com wrote: 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 them. :) https://www.wikidata.org/wiki/special:diff/208946888/212095823 -Jeremy ___ Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l ___ Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Re: [Wikidata-l] World's largest cities with a female mayor :-)
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 20.04.2015 um 22:18 schrieb 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 in Wikipedia, but it would
be
painfully hard to get the result by reading articles.
I recently had the occasion of actually phrasing this in SPARQL, so that an
answer can now, finally, be given. The query to run at
http://milenio.dcc.uchile.cl/sparql
is as follows (with some explaining comments inline):
PREFIX : http://www.wikidata.org/entity/ SELECT DISTINCT ?city ?citylabel
?mayorlabel WHERE {
?city :P31c/:P279c* :Q515 . # find instances of subclasses of city
?city :P6s ?statement . # with a P6 (head of goverment) statement
?statement :P6v ?mayor . # ... that has the value ?mayor
?mayor :P21c :Q6581072 . # ... where the ?mayor has P21 (sex or gender)
female
FILTER NOT EXISTS { ?statement :P582q ?x } # ... but the statement has no
P582
(end date) qualifier
# Now select the population value of the ?city
# (the number is reached through a chain of three properties)
?city :P1082s/:P1082v/http://www.wikidata.org/ontology#numericValue
?population .
# Optionally, find English labels for city and mayor:
OPTIONAL {
?city rdfs:label ?citylabel .
FILTER ( LANG(?citylabel) = en )
}
OPTIONAL {
?mayor rdfs:label ?mayorlabel .
FILTER ( LANG(?mayorlabel) = en )
}
} ORDER BY DESC(?population) LIMIT 100
To see the results, just paste this into the box at
http://milenio.dcc.uchile.cl/sparql and press Run query.
The query does not filter the most recent population but relies on Virtuoso to
pick the biggest value for DESC sorting, and on the world to have (mostly)
cities with increasing population numbers over time. This is also the reason
why
the population is not printed (it would give you more than one match per city
then, even with DISTINCT). Picking the current population will become easier
once ranks are used more widely to mark it.
There might also be some inaccuracies in cases where a past mayor does not
have
an end date set in Wikidata (Madrid has a suspiciously large number of
current
mayors ...), but a query can only ever be as good as its input data.
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.
Cheers,
Markus
___
Wikidata-l mailing list
Wikidata-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-l
--
Daniel Kinzler
Senior Software Developer
Wikimedia Deutschland
Gesellschaft zur Förderung Freien Wissens e.V.
___
Wikidata-l mailing list
Wikidata-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Re: [Wikidata-l] World's largest cities with a female mayor :-)
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 Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Re: [Wikidata-l] World's largest cities with a female mayor :-)
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. 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 one). Here is a better query, this time even with
populations given:
PREFIX : http://www.wikidata.org/entity/
SELECT ?city (MAX(?population) AS ?max_population) ?citylabel ?mayorlabel
WHERE {
?city :P31c/:P279c* :Q515 . # find instances of subclasses of city
?city :P6s ?statement . # with a P6 (head of goverment) statement
?statement :P6v ?mayor . # ... that has the value ?mayor
?mayor :P21c :Q6581072 . # ... where the ?mayor has P21 (sex or
gender) female
FILTER NOT EXISTS { ?statement :P582q ?x } # ... but the statement has
no P582 (end date) qualifier
# Now select the population value of the ?city
# (the number is reached through a chain of three properties)
?city :P1082s/:P1082v/http://www.wikidata.org/ontology#numericValue
?population .
# Optionally, find English labels for city and mayor:
OPTIONAL {
?city rdfs:label ?citylabel .
FILTER ( LANG(?citylabel) = en )
}
OPTIONAL {
?mayor rdfs:label ?mayorlabel .
FILTER ( LANG(?mayorlabel) = en )
}
} GROUP BY ?city ?citylabel ?mayorlabel
ORDER BY DESC(?max_population) LIMIT 100
Oh... maybe quantity values are sorted in alphanumeric order, because
they are
decimal strings? They should be xsd:decimal...
They are.
Markus
Am 20.04.2015 um 22:18 schrieb 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 in Wikipedia, but it
would be
painfully hard to get the result by reading articles.
I recently had the occasion of actually phrasing this in SPARQL, so that
an
answer can now, finally, be given. The query to run at
http://milenio.dcc.uchile.cl/sparql
is as follows (with some explaining comments inline):
PREFIX : http://www.wikidata.org/entity/ SELECT DISTINCT ?city
?citylabel
?mayorlabel WHERE {
?city :P31c/:P279c* :Q515 . # find instances of subclasses of city
?city :P6s ?statement . # with a P6 (head of goverment) statement
?statement :P6v ?mayor . # ... that has the value ?mayor
?mayor :P21c :Q6581072 . # ... where the ?mayor has P21 (sex or
gender) female
FILTER NOT EXISTS { ?statement :P582q ?x } # ... but the statement
has no P582
(end date) qualifier
# Now select the population value of the ?city
# (the number is reached through a chain of three properties)
?city :P1082s/:P1082v/http://www.wikidata.org/ontology#numericValue
?population .
# Optionally, find English labels for city and mayor:
OPTIONAL {
?city rdfs:label ?citylabel .
FILTER ( LANG(?citylabel) = en )
}
OPTIONAL {
?mayor rdfs:label ?mayorlabel .
FILTER ( LANG(?mayorlabel) = en )
}
} ORDER BY DESC(?population) LIMIT 100
To see the results, just paste this into the box at
http://milenio.dcc.uchile.cl/sparql and press Run query.
The query does not filter the most recent population but relies on
Virtuoso to
pick the biggest value for DESC sorting, and on the world to have
(mostly)
cities with increasing population numbers over time. This is also the
reason why
the population is not printed (it would give you more than one match per
city
then, even with DISTINCT). Picking the current population will become
easier
once ranks are used more widely to mark it.
There might also be some inaccuracies in cases where a past mayor does
not have
an end date set in Wikidata (Madrid has a suspiciously large number of
current
mayors ...), but a query can only ever be as good as its input data.
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.
Cheers,
Markus
___
Wikidata-l mailing list
Wikidata-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-l
___
Wikidata-l mailing list
Wikidata-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-l
___
Wikidata-l mailing list
Wikidata-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Re: [Wikidata-l] World's largest cities with a female mayor :-)
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 once ranks are used more widely to mark it. I think this is solved with preferred ranks and truthy statements concept pretty nice. So people should start using ranks to separate current data from historical data. -- Stas Malyshev smalys...@wikimedia.org ___ Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Re: [Wikidata-l] World's largest cities with a female mayor :-)
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 one). Here is a better query, this time even with
populations given:
PREFIX : http://www.wikidata.org/entity/
SELECT ?city (MAX(?population) AS ?max_population) ?citylabel
?mayorlabel WHERE {
?city :P31c/:P279c* :Q515 . # find instances of subclasses of city
?city :P6s ?statement . # with a P6 (head of goverment) statement
?statement :P6v ?mayor . # ... that has the value ?mayor
?mayor :P21c :Q6581072 . # ... where the ?mayor has P21 (sex or
gender) female
FILTER NOT EXISTS { ?statement :P582q ?x } # ... but the statement
has no P582 (end date) qualifier
# Now select the population value of the ?city
# (the number is reached through a chain of three properties)
?city :P1082s/:P1082v/http://www.wikidata.org/ontology#numericValue
?population .
# Optionally, find English labels for city and mayor:
OPTIONAL {
?city rdfs:label ?citylabel .
FILTER ( LANG(?citylabel) = en )
}
OPTIONAL {
?mayor rdfs:label ?mayorlabel .
FILTER ( LANG(?mayorlabel) = en )
}
} GROUP BY ?city ?citylabel ?mayorlabel
ORDER BY DESC(?max_population) LIMIT 100
Oh... maybe quantity values are sorted in alphanumeric order, because they are
decimal strings? They should be xsd:decimal...
They are.
Markus
Am 20.04.2015 um 22:18 schrieb 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 in Wikipedia, but it would be
painfully hard to get the result by reading articles.
I recently had the occasion of actually phrasing this in SPARQL, so that an
answer can now, finally, be given. The query to run at
http://milenio.dcc.uchile.cl/sparql
is as follows (with some explaining comments inline):
PREFIX : http://www.wikidata.org/entity/ SELECT DISTINCT ?city ?citylabel
?mayorlabel WHERE {
?city :P31c/:P279c* :Q515 . # find instances of subclasses of city
?city :P6s ?statement . # with a P6 (head of goverment) statement
?statement :P6v ?mayor . # ... that has the value ?mayor
?mayor :P21c :Q6581072 . # ... where the ?mayor has P21 (sex or gender)
female
FILTER NOT EXISTS { ?statement :P582q ?x } # ... but the statement has no
P582
(end date) qualifier
# Now select the population value of the ?city
# (the number is reached through a chain of three properties)
?city :P1082s/:P1082v/http://www.wikidata.org/ontology#numericValue
?population .
# Optionally, find English labels for city and mayor:
OPTIONAL {
?city rdfs:label ?citylabel .
FILTER ( LANG(?citylabel) = en )
}
OPTIONAL {
?mayor rdfs:label ?mayorlabel .
FILTER ( LANG(?mayorlabel) = en )
}
} ORDER BY DESC(?population) LIMIT 100
To see the results, just paste this into the box at
http://milenio.dcc.uchile.cl/sparql and press Run query.
The query does not filter the most recent population but relies on Virtuoso to
pick the biggest value for DESC sorting, and on the world to have (mostly)
cities with increasing population numbers over time. This is also the reason why
the population is not printed (it would give you more than one match per city
then, even with DISTINCT). Picking the current population will become easier
once ranks are used more widely to mark it.
There might also be some inaccuracies in cases where a past mayor does not have
an end date set in Wikidata (Madrid has a suspiciously large number of current
mayors ...), but a query can only ever be as good as its input data.
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.
Cheers,
Markus
___
Wikidata-l mailing list
Wikidata-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-l
___
Wikidata-l mailing list
Wikidata-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Re: [Wikidata-l] World's largest cities with a female mayor :-)
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. Markus ___ Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Re: [Wikidata-l] World's largest cities with a female mayor :-)
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). Picking the current population will become easier once ranks are used more widely to mark it. I think this is solved with preferred ranks and truthy statements concept pretty nice. So people should start using ranks to separate current data from historical data. Exactly. It is almost impossible right now to get the most current population without using ranks (it's just too complex a concept for most query languages). Markus ___ Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Re: [Wikidata-l] World's largest cities with a female mayor :-)
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 asked the simple question: What are the world's largest
cities with a female mayor? The information to answer this is clearly
in Wikipedia, but it would be painfully hard to get the result by
reading articles.
I recently had the occasion of actually phrasing this in SPARQL, so that
an answer can now, finally, be given. The query to run at
http://milenio.dcc.uchile.cl/sparql
is as follows (with some explaining comments inline):
PREFIX : http://www.wikidata.org/entity/ SELECT DISTINCT ?city
?citylabel ?mayorlabel WHERE {
?city :P31c/:P279c* :Q515 . # find instances of subclasses of city
?city :P6s ?statement . # with a P6 (head of goverment) statement
?statement :P6v ?mayor . # ... that has the value ?mayor
?mayor :P21c :Q6581072 . # ... where the ?mayor has P21 (sex or
gender) female
FILTER NOT EXISTS { ?statement :P582q ?x } # ... but the statement
has no P582 (end date) qualifier
# Now select the population value of the ?city
# (the number is reached through a chain of three properties)
?city :P1082s/:P1082v/http://www.wikidata.org/ontology#numericValue
?population .
# Optionally, find English labels for city and mayor:
OPTIONAL {
?city rdfs:label ?citylabel .
FILTER ( LANG(?citylabel) = en )
}
OPTIONAL {
?mayor rdfs:label ?mayorlabel .
FILTER ( LANG(?mayorlabel) = en )
}
} ORDER BY DESC(?population) LIMIT 100
To see the results, just paste this into the box at
http://milenio.dcc.uchile.cl/sparql and press Run query.
The query does not filter the most recent population but relies on
Virtuoso to pick the biggest value for DESC sorting, and on the world to
have (mostly) cities with increasing population numbers over time. This
is also the reason why the population is not printed (it would give you
more than one match per city then, even with DISTINCT). Picking the
current population will become easier once ranks are used more widely to
mark it.
There might also be some inaccuracies in cases where a past mayor does
not have an end date set in Wikidata (Madrid has a suspiciously large
number of current mayors ...), but a query can only ever be as good as
its input data.
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.
Cheers,
Markus
___
Wikidata-l mailing list
Wikidata-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-l
___
Wikidata-l mailing list
Wikidata-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Re: [Wikidata-l] World's largest cities with a female mayor :-)
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 : http://www.wikidata.org/entity/ SELECT ?country ?label
(count(*) as ?count) WHERE {
?city :P31c/:P279c* :Q515 . # find instances of subclasses of city
?city :P6s ?statement . # with a P6 (head of goverment) statement
?statement :P6v ?mayor . # ... that has the value ?mayor
?mayor :P21c :Q6581072 . # ... where the ?mayor has P21 (sex or
gender) female
FILTER NOT EXISTS { ?statement :P582q ?x } # ... but the statement
has no P582 (end date) qualifier
?city :P17s/:P17v ?country # Also find the country of the city
# If available, get the en label of the country:
OPTIONAL {
?country rdfs:label ?label .
FILTER ( LANG(?label) = en )
}
} GROUP BY ?country ?label ORDER BY DESC(?count)
There seems to be a great imbalance here, which could indicate some
bias/incompleteness of our data -- or, possibly, of the world.
Cheers,
Markus
On Mon, Apr 20, 2015 at 1:18 PM Markus Krötzsch
mar...@semantic-mediawiki.org mailto: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 asked the simple question: What are the world's largest
cities with a female mayor? The information to answer this is clearly
in Wikipedia, but it would be painfully hard to get the result by
reading articles.
I recently had the occasion of actually phrasing this in SPARQL, so that
an answer can now, finally, be given. The query to run at
http://milenio.dcc.uchile.cl/sparql
is as follows (with some explaining comments inline):
PREFIX : http://www.wikidata.org/entity/ SELECT DISTINCT ?city
?citylabel ?mayorlabel WHERE {
?city :P31c/:P279c* :Q515 . # find instances of subclasses of city
?city :P6s ?statement . # with a P6 (head of goverment)
statement
?statement :P6v ?mayor . # ... that has the value ?mayor
?mayor :P21c :Q6581072 . # ... where the ?mayor has P21 (sex or
gender) female
FILTER NOT EXISTS { ?statement :P582q ?x } # ... but the statement
has no P582 (end date) qualifier
# Now select the population value of the ?city
# (the number is reached through a chain of three properties)
?city :P1082s/:P1082v/http://www.wikidata.org/ontology#numericValue
?population .
# Optionally, find English labels for city and mayor:
OPTIONAL {
?city rdfs:label ?citylabel .
FILTER ( LANG(?citylabel) = en )
}
OPTIONAL {
?mayor rdfs:label ?mayorlabel .
FILTER ( LANG(?mayorlabel) = en )
}
} ORDER BY DESC(?population) LIMIT 100
To see the results, just paste this into the box at
http://milenio.dcc.uchile.cl/sparql and press Run query.
The query does not filter the most recent population but relies on
Virtuoso to pick the biggest value for DESC sorting, and on the world to
have (mostly) cities with increasing population numbers over time. This
is also the reason why the population is not printed (it would give you
more than one match per city then, even with DISTINCT). Picking the
current population will become easier once ranks are used more widely to
mark it.
There might also be some inaccuracies in cases where a past mayor does
not have an end date set in Wikidata (Madrid has a suspiciously large
number of current mayors ...), but a query can only ever be as good as
its input data.
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.
Cheers,
Markus
___
Wikidata-l mailing list
Wikidata-l@lists.wikimedia.org mailto:Wikidata-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-l
___
Wikidata-l mailing list
Wikidata-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-l
___
Wikidata-l mailing list
Wikidata-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Re: [Wikidata-l] World's largest cities with a female mayor :-)
... 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 mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
