User:Pierre Tribhou/queries

Pascal

Wikipedia articles about works

The following query uses these:

Items: Blaise Pascal (Q1290)

Properties: author (P50)   , publication date (P577)  
```
SELECT ?work ?title ?year ?english ?french ?german ?spanish ?italian ?russian WHERE {
  ?work wdt:P50 wd:Q1290
OPTIONAL{?work wdt:P577 ?pubdate}
BIND(YEAR(?pubdate) as ?year)
OPTIONAL{ ?english schema:about ?work ; schema:isPartOf <https://en.wikipedia.org/> }
OPTIONAL{ ?french schema:about ?work ; schema:isPartOf <https://fr.wikipedia.org/> }
OPTIONAL{ ?german schema:about ?work ; schema:isPartOf <https://de.wikipedia.org/> }
OPTIONAL{ ?spanish schema:about ?work ; schema:isPartOf <https://es.wikipedia.org/> }
OPTIONAL{ ?italian schema:about ?work ; schema:isPartOf <https://it.wikipedia.org/> }
OPTIONAL{ ?russian schema:about ?work ; schema:isPartOf <https://ru.wikipedia.org/> }
OPTIONAL{ ?work rdfs:label ?title filter(lang(?title) = "fr") }
}
```

Try it!

Map of artworks depicting Blaise Pascal

SPARQL Query: https://w.wiki/6Gpf

People interested in Blaise Pascal

SPARQL Query: https://w.wiki/9Sud

Clermont-Ferrand

Lieux de Clermont-ferrand avec un article sur la Wikipédia en français https://w.wiki/7BNU

Overnia

The following query uses these:

Properties: Overnia ID (P9845)  
```
SELECT ?item ?itemLabel ?groupLabel ?imageLabel ?collection ?collectionLabel WHERE {
  ?item wdt:P9845 ?group .
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
```

Try it!

Biblissima

The following query uses these:

Items: Rare book library of Clermont Auvergne Métropole (Q85821952)

Properties: collection (P195)   , image (P18)   , inventory number (P217)   , Biblissima authority ID (P11493)  
```
SELECT ?item ?cote ?biblissima ?itemLabel ?pic WHERE {
  ?item wdt:P195 wd:Q85821952.
  ?item p:P217 ?statement1.
  ?statement1 (ps:P217) _:anyValueP217.
  ?item p:P11493 ?statement2.
  ?statement2 (ps:P11493) _:anyValueP11493
  OPTIONAL {
    ?item wdt:P18 ?pic.
   ?item wdt:P217 ?cote.
  ?item wdt:P11493 ?biblissima.}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],fr". }
}
```

Try it!

https://www.patrimoine-et-numerique.fr/data-visualisations/82-do-you-sparql-compilation-de-requetes-patrimoniales-et-culturelles-sur-wikidata

dont cinéma :

The following query uses these:

Items: Puy-de-Dôme (Q12694)

Properties: filming location (P915)   , located in the administrative territorial entity (P131)   , coordinate location (P625)   , publication date (P577)

Features: map (Q24515275)  

#title: Lieux de tournages de films tournés dans le Puy-de-Dôme
#defaultView:Map
SELECT ?film ?filmLabel ?lieu ?lieuLabel ?coord ?layer WHERE {
?film wdt:P915 ?lieu .
?lieu wdt:P131* wd:Q12694 .
?lieu wdt:P625 ?coord .
?film wdt:P577 ?date .
BIND ( year(?date) AS ?layer )
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Lieux de tournages de films tournés dans le Puy-de-Dôme