Courses/CGBV SS24/Graph: Difference between revisions

Revision as of 07:21, 3 May 2024

Contains queries about the graph of the "CGBV SS24" course to help debug and structure it.

All Sessions

Returns a graph containing all sessions included in the course, as well as all included topics.

All existing CGBV SS24 sessions with included topics

All Categories

Returns a graph with all categories included in the course. See the query here

Items

Orphans

Returns all items included in the course, that don't depend on other items and aren't depended on by other items.

Resources

All Resources

Returns a table with all resources that are linked to from inside the course.

Items used: CGBV 24SS (Q932)

Properties used: includes (P14), resource (P21), url (P20), instance of (P3)

#defaultView:Table
PREFIX wdt: <https://graphit.ur.de/prop/direct/>
PREFIX wd: <https://graphit.ur.de/entity/>
SELECT DISTINCT ?item ?itemLabel ?resource ?resourceLabel ?alias ?url ?type ?typeLabel # ?resLabelLength 
WHERE {
  wd:Q932 wdt:P14/wdt:P14 ?item.
  ?item wdt:P21 ?resource.
  OPTIONAL {?resource wdt:P20 ?link.
            BIND("true" as ?url) }
  
  OPTIONAL {?resource wdt:P3 ?type.}
  OPTIONAL {?resource skos:altLabel ?alias.}

  service wikibase:label { bd:serviceParam wikibase:language "en" }
} ORDER BY ASC(?resourceLabel)

Try it!

Items without Resources

Returns a table with all items in the CGBV 24SS course, that don't link to a resource.

@@ Line 32: / Line 32: @@
 == Items ==
+=== Orphans ===
+Returns all items included in the course, that don't depend on other items and aren't depended on by other items.
+{{#widget:SPARQLquery|code=
+# All items that don't link to another item (no dependency)
+#defaultView:Table
+PREFIX wdt: <https://graphit.ur.de/prop/direct/>
+PREFIX wd: <https://graphit.ur.de/entity/>
+SELECT ?source ?sourceLabel ?dependency
+WHERE {
+  wd:Q932 wdt:P14/wdt:P14 ?source.
+  MINUS {?dependency wdt:P1 ?source}. # Remove all items that have the ?source as a dependency
+  MINUS {?source wdt:P1 ?dependency}. # Remove all ?source's that have a dependency
+  service wikibase:label { bd:serviceParam wikibase:language "en" }
+}
+}}
 === Resources ===
 ==== All Resources ====