query-76c75a37d21e4b0aaaaaa472ae1207b6

rq turtle/ttl

Cours d'eau alimentant la Saint-Maurice river (Q203862).

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?item ?itemLabel ?riveLabel ?confluentLabel ?locationLabel ?locationCoord ?sourceLabel ?sourceLocationLabel ?sourceCoord ?longueur 
  WHERE { {?item (wdt:P403)* wd:Q203862 }                  # rivière Saint-Maurice
    OPTIONAL {?item p:P403 [ pq:P31 ?rive ] }              # qualificatif rive de la confluence
    OPTIONAL {?item wdt:P403 ?confluent }
    OPTIONAL {?item p:P403 [ pq:P131 ?location ] }         # qualificatif unité administrative   
    OPTIONAL {?item p:P403 [ pq:P625 ?locationCoord ] }    # qualificatif coordonnés de la confluence 
    OPTIONAL {?item wdt:P885 ?source }
    OPTIONAL {?item p:P885 [ pq:P131 ?sourceLocation ] }              
    OPTIONAL {?item p:P885 [ pq:P625 ?sourceCoord ] }                
    OPTIONAL {?item wdt:P885 ?tempCo .                     # Chercher les coordonnées de la source
              ?tempCo wdt:P625 ?sourceCoord }              
    OPTIONAL {?item wdt:P885 ?tempLoc .                    # Chercher la localisation de la source
              ?tempLoc wdt:P131 ?sourceLocation }
    OPTIONAL {?item wdt:P131 ?location }
    OPTIONAL {?item wdt:P131 ?sourceLocation } 
    OPTIONAL {?item wdt:P3871 ?rive } 
    OPTIONAL {?item wdt:P625 ?locationCoord }
    OPTIONAL {?item wdt:P2043 ?longueur } .
    SERVICE wikibase:label { bd:serviceParam wikibase:language "fr,en" . }  # français sinon anglais
}
ORDER BY (?itemLabel) 
LIMIT 500

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?confluent") v2("?item"):::projected v1("?itemLabel"):::projected v5("?location") v6("?locationCoord"):::projected v12("?longueur"):::projected v3("?rive") v7("?source") v9("?sourceCoord"):::projected v8("?sourceLocation") v10("?tempCo") v11("?tempLoc") a1((" ")) a2((" ")) a3((" ")) a4((" ")) a5((" ")) c2(["wd:Q203862"]):::iri c14(["bd:serviceParam"]):::iri c16(["fr,en"]):::literal v2 --"p:direct/P403"--> c2 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; a1 -."p:qualifier/P31".-> v3 v2 --"p:P403"--> a1 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v2 -."p:direct/P403".-> v4 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; a2 -."p:qualifier/P131".-> v5 v2 --"p:P403"--> a2 end subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; a3 -."p:qualifier/P625".-> v6 v2 --"p:P403"--> a3 end subgraph optional4["(optional)"] style optional4 fill:#bbf,stroke-dasharray: 5 5; v2 -."p:direct/P885".-> v7 end subgraph optional5["(optional)"] style optional5 fill:#bbf,stroke-dasharray: 5 5; a4 -."p:qualifier/P131".-> v8 v2 --"p:P885"--> a4 end subgraph optional6["(optional)"] style optional6 fill:#bbf,stroke-dasharray: 5 5; a5 -."p:qualifier/P625".-> v9 v2 --"p:P885"--> a5 end subgraph optional7["(optional)"] style optional7 fill:#bbf,stroke-dasharray: 5 5; v2 -."p:direct/P885".-> v10 v10 --"p:direct/P625"--> v9 end subgraph optional8["(optional)"] style optional8 fill:#bbf,stroke-dasharray: 5 5; v2 -."p:direct/P885".-> v11 v11 --"p:direct/P131"--> v8 end subgraph optional9["(optional)"] style optional9 fill:#bbf,stroke-dasharray: 5 5; v2 -."p:direct/P131".-> v5 end subgraph optional10["(optional)"] style optional10 fill:#bbf,stroke-dasharray: 5 5; v2 -."p:direct/P131".-> v8 end subgraph optional11["(optional)"] style optional11 fill:#bbf,stroke-dasharray: 5 5; v2 -."p:direct/P3871".-> v3 end subgraph optional12["(optional)"] style optional12 fill:#bbf,stroke-dasharray: 5 5; v2 -."p:direct/P625".-> v6 end subgraph optional13["(optional)"] style optional13 fill:#bbf,stroke-dasharray: 5 5; v2 -."p:direct/P2043".-> v12 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c14 --"wikibase:language"--> c16 end