query-692b0e0bce07057696807ae161d9007f

rq turtle/ttl

All software items that have at least one TaDiRAH ID (indirectly via Property:P366)

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT
  ?method ?methodLabel ?tadirahID
  (?methodColor AS ?rgb)
  ?tool ?toolLabel ?toolDesc
  ?image # order is relevant for the graph display.
WHERE {
   {
  SELECT DISTINCT
    ?tool ?method ?methodColor
  WHERE {
    # select all items that have a TaDiRAH ID
    ?method wdt:P9309 ?tadirahID.
    BIND("7eb8ff" AS ?methodColor) # set rgb colour for method nodes
    # select all items which are linked to the methods through `has use`
    ?tool wdt:P366 ?method;
      # limit tools to software in the broadest sense
      wdt:P31/wdt:P279* wd:Q7397.
    }
  LIMIT 3000
}  # retrieve the logos and images for those tools that have them
  OPTIONAL { ?tool (wdt:P154| wdt:P18) ?image .}
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
    ?tool rdfs:label ?toolLabel;
      schema:description ?toolDesc.
    ?method rdfs:label ?methodLabel.
  }
}
ORDER BY ?toolLabel
LIMIT 5000

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v6("?image"):::projected v2("?method"):::projected v4("?methodColor"):::projected v8("?methodLabel"):::projected v9("?rgb") v3("?tadirahID"):::projected v5("?tool"):::projected v7("?toolDesc"):::projected v1("?toolLabel"):::projected a1((" ")) c5(["wd:Q7397"]):::iri c9(["bd:serviceParam"]):::iri c11(["#91;AUTO_LANGUAGE#93;,en"]):::literal v2 --"wdt:P9309"--> v3 bind0[/"'7eb8ff'"/] bind0 --as--o v4 v5 --"wdt:P366"--> v2 v5 --"wdt:P31"--> a1 a1 --"wdt:P279"--> c5 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; v5 -."wdt:P18".-> v6 end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; v5 --"wdt:P154"--> v6 end union0r <== or ==> union0l end end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c9 --"wikibase:language"--> c11 v5 --"rdfs:label"--> v1 v5 --"schema:description"--> v7 v2 --"rdfs:label"--> v8 end bind1[/"?methodColor"/] v4 --o bind1 bind1 --as--o v9