PresentationPics: Difference between revisions
(created page + added gallery and query) |
(added queries for Learning path and Student interest) |
||
Line 9: | Line 9: | ||
</gallery> | </gallery> | ||
= Queries = | |||
== Full Graph with Learning Path == | == Full Graph with Learning Path == | ||
Query returns the full CGBV-Graph and the learning path to an item. | Query returns the full CGBV-Graph and the learning path to an item. | ||
''Union of both queries.'' | |||
{{SPARQL2|query= | {{SPARQL2|query= | ||
#defaultView:Graph | #defaultView:Graph | ||
Line 68: | Line 70: | ||
} | } | ||
} | } | ||
}} | |||
== Learning path == | |||
The complete path to an item (here: [[Item:Q149|Virtual Cameras]]) and what's next. | |||
{{#widget:SPARQLquery|code= | |||
#defaultView:Graph | |||
# prerequisite -> topic -> postrequisite | |||
PREFIX wd: <https://graphit.ur.de/entity/> | |||
PREFIX wdt: <https://graphit.ur.de/prop/direct/> | |||
SELECT distinct ?v ?vLabel ?rgb ?link ?linkLabel | |||
WHERE { | |||
{ | |||
{ SELECT * WHERE { | |||
{ SELECT ?goal ?goalLabel ?topic ?topicLabel WHERE { | |||
{ | |||
BIND (wd:Q149 as ?goal). | |||
?goal wdt:P1+ ?topic. | |||
} UNION { | |||
VALUES ?topic { wd:Q149 } # we also want to include the root node itself | |||
} | |||
} | |||
} | |||
?topic wdt:P1 ?pre. | |||
BIND (?topic as ?v). # + add all ?pre that are not yet in ?topic | |||
BIND (?pre as ?link). | |||
bind (if(?v = wd:Q149, "FBBC74", "FFEDD8") as ?rgb). | |||
} | |||
} | |||
Union | |||
{ SELECT * WHERE { | |||
{ SELECT ?topic ?topicLabel ?goal ?goalLabel WHERE { | |||
{ | |||
BIND (wd:Q149 as ?topic). | |||
?goal wdt:P1+ ?topic. | |||
} UNION { | |||
VALUES ?topic { wd:Q149 } # we also want to include the root node itself | |||
} | |||
} | |||
} | |||
?post wdt:P1 ?topic. | |||
BIND (?post as ?v). | |||
BIND (?topic as ?link). | |||
bind ("F68C13" as ?rgb). | |||
} | |||
} | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | |||
} | |||
} |caption=The learning path to an item, showing its pre- and postrequisites | |||
}} | |||
== Student Interest == | |||
{{#widget:SPARQLquery|code= | |||
#defaultView:Graph | |||
PREFIX wdt: <https://graphit.ur.de/prop/direct/> | |||
PREFIX wd: <https://graphit.ur.de/entity/> | |||
SELECT DISTINCT #?item1 ?item1Label ?edgeLabel ?item2 ?item2Label ?dependency ?dependencyLabel | |||
?item2 ?item2Label ?dependency ?dependencyLabel ?item1 ?item1Label ?edgeLabel | |||
WHERE { | |||
VALUES ?item1 {wd:Q157} | |||
VALUES ?prop {wdt:P23} | |||
?item1 ?prop ?item2. | |||
# Select all dependencies for every item2 | |||
OPTIONAL {?item2 wdt:P1 ?dependency.} | |||
?edge ?dummy ?prop ; rdf:type wikibase:Property. # edge labels | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | |||
} ORDER BY ?prop | |||
}} | }} |
Revision as of 16:24, 6 November 2023
A collection of images for presentations or similar.
Existing Images
Queries
Full Graph with Learning Path
Query returns the full CGBV-Graph and the learning path to an item. Union of both queries. Items used: Virtual Cameras (Q149)
Properties used: depends on (P1), subclass of (P2)
#defaultView:Graph
# prerequisite -> topic -> postrequisite
PREFIX wd: <https://graphit.ur.de/entity/>
PREFIX wdt: <https://graphit.ur.de/prop/direct/>
SELECT distinct ?v ?vLabel ?rgb ?link ?linkLabel
WHERE {
{
{ SELECT * WHERE {
{ SELECT ?goal ?goalLabel ?topic ?topicLabel WHERE {
{
BIND (wd:Q149 as ?goal).
?goal wdt:P1+ ?topic.
} UNION {
VALUES ?topic { wd:Q149 } # we also want to include the root node itself
}
}
}
?topic wdt:P1 ?pre.
BIND (?topic as ?v). # + add all ?pre that are not yet in ?topic
BIND (?pre as ?link).
bind (if(?v = wd:Q149, "FBBC74", "FFEDD8") as ?rgb).
}
}
Union
{ SELECT * WHERE {
{ SELECT ?topic ?topicLabel ?goal ?goalLabel WHERE {
{
BIND (wd:Q149 as ?topic).
?goal wdt:P1+ ?topic.
} UNION {
VALUES ?topic { wd:Q149 } # we also want to include the root node itself
}
}
}
?post wdt:P1 ?topic.
BIND (?post as ?v).
BIND (?topic as ?link).
bind ("F68C13" as ?rgb).
}
}
Union
{ Select ?v ?vLabel ?link ?linkLabel WHERE {
?v wdt:P1 ?link.
?v wdt:P2 ?class.
}
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
}
Learning path
The complete path to an item (here: Virtual Cameras) and what's next.
Student Interest