query-22e850d4d3f4963a38ba3aaab419db02

rq turtle/ttl

List of trivial Dutch names, as mentioned in the Flora Batava, starting with 'A' (or 'a') SELECT DISTINCT ?dutchTrivialNameInFB ?scientificNameInFB ?scientificNameModern ?dutchTrivialNameModern ?plate ?plateLabel ?plateImage WHERE { wd:Q117860156 wdt:P527 ?volume. ?volume wdt:P527 ?plate. OPTIONAL{?plate wdt:P18 ?plateImage.}

?plate wdt:P1476 ?scientificNameInFB. FILTER(lang(?scientificNameInFB)='la') ?plate wdt:P1476 ?dutchTrivialNameInFB. FILTER(lang(?dutchTrivialNameInFB)='nl') ?plate wdt:P180 ?plantDecpicted. ?plantDecpicted rdfs:label ?scientificNameModern . FILTER(lang(?scientificNameModern)='la') ?plantDecpicted rdfs:label?dutchTrivialNameModern . FILTER(lang(?dutchTrivialNameModern)='nl') FILTER (STRSTARTS(UCASE(STR(?dutchTrivialNameInFB)), 'A'))
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],nl". } } ORDER BY ?dutchTrivialNameInFB

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
#List of trivial Dutch names, as mentioned in the Flora Batava, starting with 'A' (or 'a')
SELECT DISTINCT 
?dutchTrivialNameInFB ?scientificNameInFB ?scientificNameModern ?dutchTrivialNameModern
?plate ?plateLabel ?plateImage
WHERE 
{
  wd:Q117860156 wdt:P527 ?volume.
  ?volume wdt:P527 ?plate.
  OPTIONAL{?plate wdt:P18 ?plateImage.}

  ?plate wdt:P1476 ?scientificNameInFB. FILTER(lang(?scientificNameInFB)='la')
  ?plate wdt:P1476 ?dutchTrivialNameInFB. FILTER(lang(?dutchTrivialNameInFB)='nl')
  ?plate wdt:P180 ?plantDecpicted.
  ?plantDecpicted rdfs:label ?scientificNameModern . FILTER(lang(?scientificNameModern)='la')
  ?plantDecpicted rdfs:label?dutchTrivialNameModern . FILTER(lang(?dutchTrivialNameModern)='nl')
  FILTER (STRSTARTS(UCASE(STR(?dutchTrivialNameInFB)), 'A'))          
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],nl". } 
}
ORDER BY ?dutchTrivialNameInFB

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?dutchTrivialNameInFB"):::projected v2("?dutchTrivialNameModern"):::projected v8("?plantDecpicted") v6("?plate"):::projected v7("?plateImage"):::projected v4("?scientificNameInFB"):::projected v3("?scientificNameModern"):::projected v5("?volume") c4(["wd:Q117860156"]):::iri c13(["#91;AUTO_LANGUAGE#93;,nl"]):::literal c11(["bd:serviceParam"]):::iri f0[["starts-with(upper-case(str(?dutchTrivialNameInFB)),'A')"]] f0 --> v1 f1[["?dutchTrivialNameModern = 'nl'"]] f1 --> v2 f2[["?scientificNameModern = 'la'"]] f2 --> v3 f3[["?dutchTrivialNameInFB = 'nl'"]] f3 --> v1 f4[["?scientificNameInFB = 'la'"]] f4 --> v4 c4 --"wdt:P527"--> v5 v5 --"wdt:P527"--> v6 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v6 -."wdt:P18".-> v7 end v6 --"wdt:P1476"--> v4 v6 --"wdt:P1476"--> v1 v6 --"wdt:P180"--> v8 v8 --"rdfs:label"--> v3 v8 --"rdfs:label"--> v2 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c11 --"wikibase:language"--> c13 end