This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Nombre de voies et lieux-dits à Rennes, dont nombre ayant un code Fantoir renseigné | |
SELECT ?natureLabel (COUNT(?lieu) AS ?Nombre) (COUNT(?fantoir) AS ?Fantoir) | |
WHERE { | |
?lieu wdt:P31 ?nature ; | |
wdt:P131 wd:Q647 . # à Rennes | |
{ ?lieu wdt:P31/wdt:P279* wd:Q181307 } # Lieu-dit | |
UNION | |
{ ?lieu wdt:P31/wdt:P279* wd:Q83620 } # Voie de communication | |
OPTIONAL { | |
?lieu wdt:P3182 ?fantoir ; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#defaultView:TreeMap | |
# Voies de Rennes | |
SELECT ?natureNomLabel ?natureLabel (COUNT(?voie) AS ?c) | |
WHERE { | |
?voie wdt:P31 ?nature ; | |
wdt:P31/wdt:P279* wd:Q83620 ; # Voie de communication | |
wdt:P131 wd:Q647 . # à Rennes | |
OPTIONAL { | |
?voie wdt:P138 ?nom ; # nommée en référence à une entité | |
wdt:P138/wdt:P31 ?natureNom . # nature de l’entité référencée |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#defaultView:TreeMap | |
SELECT ?genreNomLabel ?natureLabel (COUNT(?voie) AS ?c) | |
WHERE { | |
?voie wdt:P31 ?nature ; | |
wdt:P31/wdt:P279* wd:Q83620 ; # Voie de communication | |
wdt:P131 wd:Q647 ; # à Rennes | |
wdt:P138 ?nom ; | |
wdt:P138/wdt:P31 wd:Q5 ; | |
wdt:P138/wdt:P21 ?genreNom . | |
SERVICE wikibase:label { |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#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 { |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Candidates pour odonymes rennais | |
SELECT ?person ?personLabel (GROUP_CONCAT(DISTINCT ?femOccupation; SEPARATOR = ', ') AS ?occupation) | |
WHERE { | |
{ | |
{ ?person wdt:P19 wd:Q647 } # nées à Rennes | |
UNION # ou | |
{ ?person wdt:P20 wd:Q647 } # ayant vécu à Rennes | |
UNION # ou | |
{ ?person wdt:P551 wd:Q647 } # mortes à Rennes | |
} # et |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#defaultView:Map | |
SELECT ?item ?itemLabel ?coords | |
WHERE { | |
?item wdt:P361 wd:Q1032581 ; # sous-parties du canal | |
wdt:P31/wdt:P279* wd:Q105731 ; # qui sont des écluses | |
wdt:P625 ?coords . # et leurs coordonnées | |
SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" } | |
} |