query-2c1dacc7b0893f42b80de4fcc3dda03a
RDM-Service Points distinguished by type of University (no good results yet) does not adequatly capture the way relevant Universities are represented in Wikidata. Comprehensive University and University of Applied ScienceSo far, the query gives only about half of the RDM-Service Points, because the distinction between
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#>
#defaultView:Map{"hide":"organization_type", "layer":"?organization_typeLabel"}
SELECT DISTINCT ?organizational_unit ?organization_typeLabel ?geo ?located_in_the_administrative_territorial_entityLabel ?organizational_unitLabel ?email_address ?official_website ?part_ofLabel WHERE {
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
?organizational_unit wdt:P31 wd:Q679206;
wdt:P101 wd:Q30089794.
?organizational_unit wdt:P361/wdt:P31 ?organization_type.
VALUES ?organization_type {wd:Q1365560 wd:Q1767829} .
OPTIONAL { ?organizational_unit wdt:P131 ?located_in_the_administrative_territorial_entity. }
OPTIONAL { ?organizational_unit wdt:P968 ?email_address. }
OPTIONAL { ?organizational_unit wdt:P856 ?official_website. }
OPTIONAL { ?organizational_unit wdt:P361 ?part_of. }
OPTIONAL { ?part_of wdt:P625 ?geo. }
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v4("?email_address"):::projected
v7("?geo"):::projected
v3("?located_in_the_administrative_territorial_entity")
v5("?official_website"):::projected
v3("?organization_type")
v1("?organizational_unit"):::projected
v6("?part_of")
a1((" "))
c6(["wd:Q679206"]):::iri
c2(["bd:serviceParam"]):::iri
c8(["wd:Q30089794"]):::iri
c4(["#91;AUTO_LANGUAGE#93;,en"]):::literal
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c2 --"wikibase:language"--> c4
end
v1 --"wdt:P31"--> c6
v1 --"wdt:P101"--> c8
v1 --"wdt:P361"--> a1
a1 --"wdt:P31"--> v3
bind0[/VALUES ?organization_type/]
bind0-->v3
bind00(["wd:Q1365560"])
bind00 --> bind0
bind01(["wd:Q1767829"])
bind01 --> bind0
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v1 -."wdt:P131".-> v3
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v1 -."wdt:P968".-> v4
end
subgraph optional2["(optional)"]
style optional2 fill:#bbf,stroke-dasharray: 5 5;
v1 -."wdt:P856".-> v5
end
subgraph optional3["(optional)"]
style optional3 fill:#bbf,stroke-dasharray: 5 5;
v1 -."wdt:P361".-> v6
end
subgraph optional4["(optional)"]
style optional4 fill:#bbf,stroke-dasharray: 5 5;
v6 -."wdt:P625".-> v7
end