query-9aeebdfc397bb31fc0557991d3f7a5d0

rq turtle/ttl

Nomenclatural acts

Use at

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT ?item ?taxonName ?state ?publication ?title {
  ?item p:P225 ?statement .
  ?statement ps:P225 ?taxonName .
  ?statement pq:P574 ?date .
  ?statement prov:wasDerivedFrom ?refnode .
  ?refnode pr:P248 ?ref
  OPTIONAL {?refnode pr:P304 ?page }
  OPTIONAL {?refnode pr:P6184 ?state_}  ?ref wdt:P1433 wd:Q2003024 .
  ?ref wdt:P478 ?volume .
  ?ref wdt:P433 ?issue .
  ?ref wdt:P304 ?pages_ .
  OPTIONAL {?ref wdt:P1476 ?title} .
  BIND(if(!BOUND(?date), "", xsd:string(YEAR(?date))) as ?year)
  BIND(if(sameTerm(?state_, wd:Q1361864), "tax. nov.", if(sameTerm(?state_, wd:Q14594740), "comb. nov.", if(sameTerm(?state_, wd:Q749462), "nom. nov.", ""))) as ?state) 
  BIND(CONCAT("Taxon ", CONCAT(?volume, CONCAT( "(",CONCAT(?issue, CONCAT("): ", CONCAT(?page, CONCAT(". ", ?year))))))) AS ?publication)  
  FILTER(bound(?state))
}
ORDER BY ASC(?taxonName)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?date") v11("?issue") v3("?item"):::projected v8("?page") v12("?pages_") v15("?publication"):::projected v7("?ref") v6("?refnode") v15("?state"):::projected v9("?state_") v4("?statement") v1("?taxonName"):::projected v13("?title"):::projected v10("?volume") v14("?year") c9(["wd:Q2003024"]):::iri f0[["bound(?state)"]] f0 --> v15 v3 --"p:P225"--> v4 v4 --"p:statement/P225"--> v1 v4 --"p:qualifier/P574"--> v5 v4 --"prov:wasDerivedFrom"--> v6 v6 --"p:reference/P248"--> v7 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v6 -."p:reference/P304".-> v8 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v6 -."p:reference/P6184".-> v9 end v7 --"p:direct/P1433"--> c9 v7 --"p:direct/P478"--> v10 v7 --"p:direct/P433"--> v11 v7 --"p:direct/P304"--> v12 subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v7 -."p:direct/P1476".-> v13 end bind1[/"if(not bound(?date),'',http://www.w3.org/2001/XMLSchema#string(year-from-dateTime(?date)))"/] v5 --o bind1 bind1 --as--o v14 bind2[/"if(sameterm(?state_,'wd:Q1361864'),'tax. nov.',if(sameterm(?state_,'wd:Q14594740'),'comb. nov.',if(sameterm(?state_,'wd:Q749462'),'nom. nov.','')))"/] v9 --o bind2 bind2 --as--o v15 bind3[/"concat('Taxon ',concat(?volume,concat('(',concat(?issue,concat('): ',concat(?page,concat('. ',?year)))))))"/] v10 --o bind3 v11 --o bind3 v8 --o bind3 v14 --o bind3 bind3 --as--o v15