query-05ce4b9448e74f771b501b7be1798ebb
Motivation, and GEPRIS institution ID. GEPRIS project IDThis is the second of three property proposals for GEPRIS person ID, . A list of projects funded by DFG can be queried via SPARQL (by now we have 34): Scholia lists all research projects, institutions, and researchers funded by the German Science Foundation since around the year 2000. Linking them to Wikidata would improve of reliability of research information in Wikidata and allow for interesting queries, e.g. in (Q48879895)GEPRIS
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 bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?project ?projectLabel ?title ?url WHERE {
{ # any project funded by DFG
{ ?project wdt:P859 wd:Q707283 .
?project wdt:P31/wdt:P279* wd:Q170584 }
UNION
{ ?project wdt:P31 wd:Q2300983 } # Sonderforschungsbereich
UNION
{ ?project wdt:P31 wd:Q48975698 } # Exzellenzcluster
UNION
{ ?project wdt:P31 wd:Q20825825 } # Graduiertenschule
}
OPTIONAL { ?project wdt:P1476 ?title }
OPTIONAL { ?project wdt:P856 ?url }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,de". }
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?project"):::projected
v2("?title"):::projected
v3("?url"):::projected
a1((" "))
c8(["wd:Q20825825"]):::iri
c6(["wd:Q2300983"]):::iri
c2(["wd:Q707283"]):::iri
c7(["wd:Q48975698"]):::iri
c12(["bd:serviceParam"]):::iri
c14(["#91;AUTO_LANGUAGE#93;,en,de"]):::literal
c5(["wd:Q170584"]):::iri
subgraph union0[" Union "]
subgraph union0l[" "]
style union0l fill:#abf,stroke-dasharray: 3 3;
subgraph union1[" Union "]
subgraph union1l[" "]
style union1l fill:#abf,stroke-dasharray: 3 3;
subgraph union2[" Union "]
subgraph union2l[" "]
style union2l fill:#abf,stroke-dasharray: 3 3;
v1 --"wdt:P31"--> c8
end
subgraph union2r[" "]
style union2r fill:#abf,stroke-dasharray: 3 3;
v1 --"wdt:P31"--> c7
end
union2r <== or ==> union2l
end
end
subgraph union1r[" "]
style union1r fill:#abf,stroke-dasharray: 3 3;
v1 --"wdt:P31"--> c6
end
union1r <== or ==> union1l
end
end
subgraph union0r[" "]
style union0r fill:#abf,stroke-dasharray: 3 3;
v1 --"wdt:P859"--> c2
v1 --"wdt:P31"--> a1
a1 --"wdt:P279"--> c5
end
union0r <== or ==> union0l
end
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v1 -."wdt:P1476".-> v2
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v1 -."wdt:P856".-> v3
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c12 --"wikibase:language"--> c14
end