query-ece376e8ef2c63bcb509ea3a29d00c78
title:query per timeline tableau SELECT DISTINCT ?tipograf ?tipografLabel ?sessoLabel (MIN(?start) as ?startt) (MAX (?end) as ?endd) ?luogolavLabel ?lat ?long WHERE { ?tipograf wdt:P31 wd:Q5; wdt:P21 ?sesso; wdt:P937 ?luogolav; wdt:P2031 ?st; wdt:P2032 ?en; wdt:P106 ?activity . values ?activity { wd:Q175151 wd:Q1229025 wd:Q998550 wd:Q2516866 wd:Q40881196 }
?luogolav wdt:P625 ?coord; wdt:P17 wd:Q38. ?luogolav p:P625 [ psv:P625 ?coo2]. ?coo2 wikibase:geoLatitude ?lat. ?coo2 wikibase:geoLongitude ?long. Bind (YEAR(?st) as ?start) Bind (YEAR(?en) as ?end)
SERVICE wikibase:label { bd:serviceParam wikibase:language "it, en". } } GROUP BY ?tipograf ?tipografLabel ?sessoLabel ?luogolavLabel ?lat ?long
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title:query per timeline tableau
SELECT DISTINCT ?tipograf ?tipografLabel ?sessoLabel (MIN(?start) as ?startt) (MAX (?end) as ?endd) ?luogolavLabel ?lat ?long WHERE {
?tipograf wdt:P31 wd:Q5; wdt:P21 ?sesso; wdt:P937 ?luogolav; wdt:P2031 ?st; wdt:P2032 ?en; wdt:P106 ?activity .
values ?activity {
wd:Q175151 wd:Q1229025 wd:Q998550 wd:Q2516866 wd:Q40881196
}
?luogolav wdt:P625 ?coord; wdt:P17 wd:Q38.
?luogolav p:P625 [ psv:P625 ?coo2].
?coo2 wikibase:geoLatitude ?lat.
?coo2 wikibase:geoLongitude ?long.
Bind (YEAR(?st) as ?start)
Bind (YEAR(?en) as ?end)
SERVICE wikibase:label { bd:serviceParam wikibase:language "it, en". }
}
GROUP BY ?tipograf ?tipografLabel ?sessoLabel ?luogolavLabel ?lat ?long
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v7("?activity")
v8("?coo2")
v7("?coord")
v5("?en")
v12("?end"):::projected
v14("?endd")
v9("?lat"):::projected
v10("?long"):::projected
v3("?luogolav")
v2("?sesso")
v4("?st")
v11("?start"):::projected
v13("?startt")
v1("?tipograf"):::projected
a1((" "))
c18(["it, en"]):::literal
c10(["wd:Q38"]):::iri
c16(["bd:serviceParam"]):::iri
c2(["wd:Q5"]):::iri
v1 --"p:direct/P31"--> c2
v1 --"p:direct/P21"--> v2
v1 --"p:direct/P937"--> v3
v1 --"p:direct/P2031"--> v4
v1 --"p:direct/P2032"--> v5
v1 --"p:direct/P106"--> v7
bind0[/VALUES ?activity/]
bind0-->v7
bind00(["wd:Q175151"])
bind00 --> bind0
bind01(["wd:Q1229025"])
bind01 --> bind0
bind02(["wd:Q998550"])
bind02 --> bind0
bind03(["wd:Q2516866"])
bind03 --> bind0
bind04(["wd:Q40881196"])
bind04 --> bind0
v3 --"p:direct/P625"--> v7
v3 --"p:direct/P17"--> c10
a1 --"p:statement/value/P625"--> v8
v3 --"p:P625"--> a1
v8 --"wikibase:geoLatitude"--> v9
v8 --"wikibase:geoLongitude"--> v10
bind1[/"year-from-dateTime(?st)"/]
v4 --o bind1
bind1 --as--o v11
bind2[/"year-from-dateTime(?en)"/]
v5 --o bind2
bind2 --as--o v12
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c16 --"wikibase:language"--> c18
end
bind5[/"min(?start)"/]
v11 --o bind5
bind5 --as--o v13
bind6[/"max(?end)"/]
v12 --o bind6
bind6 --as--o v14