Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
Occupation des personnes nommant les rues de Rennes
#defaultView:TreeMap
# Voies de Rennes
SELECT ?occupationNomLabel ?genreNomLabel (COUNT(?voie ) AS ?voies)
WHERE {
?voie wdt:P31 ?nature ;
wdt:P31/wdt:P279* wd:Q83620 ; # Voie de communication
wdt:P131 wd:Q647 ; # à Rennes
wdt:P138/wdt:P21 ?genreNom ; # genre
wdt:P138/wdt:P106 ?occupationNom . # occupation
SERVICE wikibase:label {
bd:serviceParam wikibase:language "fr"
}
}
GROUP BY ?occupationNomLabel ?genreNomLabel
ORDER BY DESC(?voies)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment