query-367fc5c95a24d5dc91a04f660e558182

rq turtle/ttl

Historical vs. modern images and distribution maps of plants

1) Historical illustration vs. modern photo of plant (image URLs)

- Historical illustration: Illustration/plate in Flora Batava

2) Map of historical vs. current distributions of plant (map URLs)

- Historical plant distribution map (at time of publication of the FB volume the plant is listed in, ±20 years): https://www.verspreidingsatlas.nl/verspreidingskaart.aspx?size=large&soortcode=1351&jaar=1800&jaartot=1820

- Current plant distribution map (2023): https://www.verspreidingsatlas.nl/verspreidingskaart.aspx?size=large&soortcode=1351&jaar=2023

Example: ''Veronica chamaedrys'' (P6142 = 1351):

- Historical illustration (https://upload.wikimedia.org/wikipedia/commons/thumb/f/ff/Veronica_chamaedrys_-Pl0001-FloraBatava-KB-v01.jpg/782px-Veronica_chamaedrys-Pl0001-_FloraBatava-KB-v01.jpg) vs.

- modern photo of plant (https://upload.wikimedia.org/wikipedia/commons/thumb/6/61/%28MHNT%29_Veronica_chamaedrys_-Plant_Habit.jpg/751px-%28MHNT%29_Veronica_chamaedrys-_Plant_Habit.jpg)

and

- Map of historical distribution (https://www.verspreidingsatlas.nl/verspreidingskaart.aspx?size=large&soortcode=1351&jaar=1800&jaartot=1820) vs.

- map of current distribution of this plant (https://www.verspreidingsatlas.nl/verspreidingskaart.aspx?size=large&soortcode=1351&jaar=2023)

SELECT DISTINCT ?plate ?plateLabel ?plantDecpicted ?dutchTrivialNameInFB ?scientificNameInFB ?historicalPlantIllustration ?dutchTrivialNameModern ?scientificNameModern (SAMPLE(?plantDecpictedImage) AS ?modernPlantImage) ?VerspreidingsatlasID ?historicalDistMapURL ?currentDistMapURL WHERE { wd:Q117860156 wdt:P527 ?volume. ?volume wdt:P577 ?pubdate. ?volume wdt:P527 ?plate.

?plate wdt:P1476 ?scientificNameInFB. FILTER(lang(?scientificNameInFB)='la') ?plate wdt:P1476 ?dutchTrivialNameInFB. FILTER(lang(?dutchTrivialNameInFB)='nl') OPTIONAL{?plate wdt:P18 ?historicalPlantIllustration.} ?plate wdt:P180 ?plantDecpicted. ?plantDecpicted rdfs:label ?scientificNameModern. FILTER(lang(?scientificNameModern)='la') ?plantDecpicted rdfs:label?dutchTrivialNameModern. FILTER(lang(?dutchTrivialNameModern)='nl')

OPTIONAL{?plantDecpicted wdt:P18 ?plantDecpictedImage.}

OPTIONAL{ ?plantDecpicted wdt:P6142 ?VerspreidingsatlasID. }#Verspreidingsatlas.nl ID BIND(YEAR(?pubdate) AS ?pubdateyear). # year of publication of FB volume BIND(STR(?pubdateyear + 20) AS ?untildate). # publicationdateyear + 25 years BIND(URI(CONCAT("https://www.verspreidingsatlas.nl/verspreidingskaart.aspx?size=large&soortcode=",STR(?VerspreidingsatlasID),"&jaar=", STR(?pubdateyear),"&jaartot=",STR(?untildate))) AS ?historicalDistMapURL) # Historical distribution map URL

BIND(STR(YEAR(NOW())) AS ?currentyear) # year it is now
BIND(URI(CONCAT("https://www.verspreidingsatlas.nl/verspreidingskaart.aspx?size=large&soortcode=",STR(?VerspreidingsatlasID),"&jaar=", STR(?currentyear))) AS ?currentDistMapURL)

SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],nl". } } GROUP BY ?plate ?plateLabel ?plantDecpicted ?dutchTrivialNameInFB ?scientificNameInFB ?historicalPlantIllustration ?dutchTrivialNameModern ?scientificNameModern ?VerspreidingsatlasID ?historicalDistMapURL ?currentDistMapURL ORDER BY ?plateLabel

Use at

https://query.wikidata.org/sparql

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#>
# Historical vs. modern images and distribution maps of plants
#
# 1) Historical illustration vs. modern photo of plant (image URLs)
#  - Historical illustration: Illustration/plate in Flora Batava
#  - Modern image: P18 in the Qitem of the related plant
# 2) Map of historical vs. current distributions of plant (map URLs)
#  - Historical plant distribution map (at time of publication of the FB volume the plant is listed in, ±20 years): https://www.verspreidingsatlas.nl/verspreidingskaart.aspx?size=large&soortcode=1351&jaar=1800&jaartot=1820
#  - Current plant distribution map (2023): https://www.verspreidingsatlas.nl/verspreidingskaart.aspx?size=large&soortcode=1351&jaar=2023
#
# Example: ''Veronica chamaedrys'' (P6142 = 1351): 
# - Historical illustration (https://upload.wikimedia.org/wikipedia/commons/thumb/f/ff/Veronica_chamaedrys_-_Pl0001_-_FloraBatava-KB-v01.jpg/782px-Veronica_chamaedrys_-_Pl0001_-_FloraBatava-KB-v01.jpg) vs. 
# - modern photo of plant (https://upload.wikimedia.org/wikipedia/commons/thumb/6/61/%28MHNT%29_Veronica_chamaedrys_-_Plant_Habit.jpg/751px-%28MHNT%29_Veronica_chamaedrys_-_Plant_Habit.jpg)
# and
# - Map of historical distribution (https://www.verspreidingsatlas.nl/verspreidingskaart.aspx?size=large&soortcode=1351&jaar=1800&jaartot=1820) vs. 
# - map of current distribution of this plant (https://www.verspreidingsatlas.nl/verspreidingskaart.aspx?size=large&soortcode=1351&jaar=2023) 

SELECT DISTINCT 
?plate ?plateLabel 
?plantDecpicted 
?dutchTrivialNameInFB  ?scientificNameInFB ?historicalPlantIllustration 
?dutchTrivialNameModern ?scientificNameModern (SAMPLE(?plantDecpictedImage) AS ?modernPlantImage)
?VerspreidingsatlasID
?historicalDistMapURL ?currentDistMapURL
WHERE {
  wd:Q117860156 wdt:P527 ?volume.
  ?volume wdt:P577 ?pubdate.
  ?volume wdt:P527 ?plate.

  ?plate wdt:P1476 ?scientificNameInFB. FILTER(lang(?scientificNameInFB)='la')
  ?plate wdt:P1476 ?dutchTrivialNameInFB. FILTER(lang(?dutchTrivialNameInFB)='nl')
  OPTIONAL{?plate wdt:P18 ?historicalPlantIllustration.}
  ?plate wdt:P180 ?plantDecpicted.
  ?plantDecpicted rdfs:label ?scientificNameModern. FILTER(lang(?scientificNameModern)='la')
  ?plantDecpicted rdfs:label?dutchTrivialNameModern. FILTER(lang(?dutchTrivialNameModern)='nl')

  OPTIONAL{?plantDecpicted wdt:P18 ?plantDecpictedImage.}

  OPTIONAL{  ?plantDecpicted wdt:P6142 ?VerspreidingsatlasID. }#Verspreidingsatlas.nl ID
    BIND(YEAR(?pubdate) AS ?pubdateyear). # year of publication of FB volume
    BIND(STR(?pubdateyear + 20) AS ?untildate). # publicationdateyear + 25 years
    BIND(URI(CONCAT("https://www.verspreidingsatlas.nl/verspreidingskaart.aspx?size=large&soortcode=",STR(?VerspreidingsatlasID),"&jaar=", STR(?pubdateyear),"&jaartot=",STR(?untildate))) AS ?historicalDistMapURL) # Historical distribution map URL 

    BIND(STR(YEAR(NOW())) AS ?currentyear) # year it is now
    BIND(URI(CONCAT("https://www.verspreidingsatlas.nl/verspreidingskaart.aspx?size=large&soortcode=",STR(?VerspreidingsatlasID),"&jaar=", STR(?currentyear))) AS ?currentDistMapURL)

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],nl". } 
}
GROUP BY ?plate ?plateLabel ?plantDecpicted ?dutchTrivialNameInFB  ?scientificNameInFB ?historicalPlantIllustration ?dutchTrivialNameModern ?scientificNameModern ?VerspreidingsatlasID ?historicalDistMapURL ?currentDistMapURL
ORDER BY ?plateLabel

Query found at

https://www.wikidata.org/wiki/Wikidata:WikiProject_Collection_highlights_National_Library_of_the_Netherlands/Flora_Batava/Queries

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v12("?VerspreidingsatlasID"):::projected v17("?currentDistMapURL"):::projected v16("?currentyear") v4("?dutchTrivialNameInFB"):::projected v2("?dutchTrivialNameModern"):::projected v15("?historicalDistMapURL"):::projected v9("?historicalPlantIllustration"):::projected v18("?modernPlantImage") v10("?plantDecpicted"):::projected v11("?plantDecpictedImage"):::projected v8("?plate"):::projected v1("?plateLabel"):::projected v7("?pubdate") v13("?pubdateyear") v5("?scientificNameInFB"):::projected v3("?scientificNameModern"):::projected v14("?untildate") v6("?volume") c3(["wd:Q117860156"]):::iri c14(["#91;AUTO_LANGUAGE#93;,nl"]):::literal c12(["bd:serviceParam"]):::iri f0[["?dutchTrivialNameModern = 'nl'"]] f0 --> v2 f1[["?scientificNameModern = 'la'"]] f1 --> v3 f2[["?dutchTrivialNameInFB = 'nl'"]] f2 --> v4 f3[["?scientificNameInFB = 'la'"]] f3 --> v5 c3 --"wdt:P527"--> v6 v6 --"wdt:P577"--> v7 v6 --"wdt:P527"--> v8 v8 --"wdt:P1476"--> v5 v8 --"wdt:P1476"--> v4 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v8 -."wdt:P18".-> v9 end v8 --"wdt:P180"--> v10 v10 --"rdfs:label"--> v3 v10 --"rdfs:label"--> v2 subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v10 -."wdt:P18".-> v11 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v10 -."wdt:P6142".-> v12 end bind4[/"year-from-dateTime(?pubdate)"/] v7 --o bind4 bind4 --as--o v13 bind5[/"str(?pubdateyear + '20^^xsd:integer')"/] v13 --o bind5 bind5 --as--o v14 bind6[/"concat('https://www.verspreidingsatlas.nl/verspreidingskaart.aspx?size=large&soortcode=',str(?VerspreidingsatlasID),'&jaar=',str(?pubdateyear),'&jaartot=',str(?untildate))"/] v12 --o bind6 v13 --o bind6 v14 --o bind6 bind6 --as--o v15 bind7[/"str(year-from-dateTime(NOW()))"/] bind7 --as--o v16 bind8[/"concat('https://www.verspreidingsatlas.nl/verspreidingskaart.aspx?size=large&soortcode=',str(?VerspreidingsatlasID),'&jaar=',str(?currentyear))"/] v12 --o bind8 v16 --o bind8 bind8 --as--o v17 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c12 --"wikibase:language"--> c14 end bind10[/"sample(?plantDecpictedImage)"/] v11 --o bind10 bind10 --as--o v18