Wikidata:WikiProject Collection highlights National Library of the Netherlands/Flora Batava/Queries
This page is part of the Wikiproject Collection highlights National Library of the Netherlands, subproject Flora Batava. This project is of the Wikidata efforts of the Koninklijke Bibliotheek Nederland
General and structural overviews | Botanical overviews | SPARQL example queries | Machine & programmatical reuse | Data models, quality & completeness | All pages |
SPARQL example queries
editSee also
edit- The overview of examples of prorammatical interactions with the data and images of the Flora Batava. This page also includes a number of SPARQL example queries.
Volumes and plates
editAll volumes of Flora Batava
edit#All volumes of Flora Batava
SELECT DISTINCT ?volume ?titlepage ?volumeLabel ?volumeDescription
WHERE
{
wd:Q117860156 wdt:P527 ?volume.
OPTIONAL{?volume wdt:P18 ?titlepage}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ?volumeLabel
Timeline of Flora Batava volumes
edit# Timeline of Flora Batava volumes
#defaultView:Timeline
SELECT DISTINCT ?volume ?titlepage ?volumeLabel ?publicationyear
WHERE
{
wd:Q117860156 wdt:P527 ?volume.
?volume wdt:P577 ?publicationyear.
OPTIONAL{?volume wdt:P18 ?titlepage}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ?volumeLabel
Plates in Volume 1
edit# Plates in Volume 1
SELECT DISTINCT ?plate ?plateLabel ?plateDescription ?plateImage
WHERE
{
wd:Q118248037 wdt:P527 ?plate.
?plate wdt:P18 ?plateImage
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ?plateLabel
Gallery of all plates in all volumes
edit# Gallery of all plates in all volumes of FB
#defaultView:ImageGrid
SELECT DISTINCT ?plate ?plateLabel ?plateDescription ?plateImage ?volumeLabel
WHERE
{
wd:Q117860156 wdt:P527 ?volume.
?volume wdt:P527 ?plate.
?plate wdt:P18 ?plateImage
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ?plateLabel
Gallery of title pages
edit# Gallery of title pages of Flora Batava
#defaultView:ImageGrid
SELECT DISTINCT ?volume ?volumeLabel ?titlepage
WHERE
{
wd:Q117860156 wdt:P527 ?volume.
?volume wdt:P18 ?titlepage
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ?volumeLabel
Graph visualisation of semantic relations between entities linked to Plate 0098
editInspired by the Wikidata Knowledge Grapher tool
# Graph visualisation of semantic relations between entities linked to Plate 0098 (Q118611263)
# Inspired by the Wikidata Knowledge Grapher tool - https://knowledgegrapher.toolforge.org/
#defaultView:Graph
SELECT ?item1 ?image ?item1Label ?item2 ?image2 ?item2Label ?edgeLabel WHERE {
VALUES ?item1 {wd:Q118611263 wd:Q3161629 wd:Q1526131 wd:Q11060274 wd:Q19652 wd:Q1526131 wd:Q118258724 wd:Q161720 wd:Q324567}
VALUES ?item2 {wd:Q118611263 wd:Q3161629 wd:Q1526131 wd:Q11060274 wd:Q19652 wd:Q1526131 wd:Q118258724 wd:Q161720 wd:Q324567}
?item1 ?prop ?item2.
MINUS { ?item1 wdt:P530 ?item2 }
?edge ?dummy ?prop ; rdf:type wikibase:Property
OPTIONAL {?item1 wdt:P18 ?image}
OPTIONAL {?item2 wdt:P18 ?image2}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Wikimedia Commons: files, categories, galleries related to Flora Batava
editSee for help: https://www.mediawiki.org/wiki/Wikidata_Query_Service/User_Manual/MWAPI
List of subcategories and gallery pages (Commons query service)
edit# List of subcategories and gallery pages in Category:Flora Batava - KB copy (Commons query service)
# Lazy query, we should do a UNION (?) to get a nice table with the Category and Gallery on the same row
SELECT ?page ?pageURL ?ns
WITH
{
SELECT ?page ?ns
WHERE
{
SERVICE wikibase:mwapi
{
bd:serviceParam wikibase:api "Generator" .
bd:serviceParam wikibase:endpoint "commons.wikimedia.org" .
bd:serviceParam mwapi:gcmtitle "Category:Flora Batava - KB copy" .
bd:serviceParam mwapi:generator "categorymembers" .
bd:serviceParam mwapi:gcmlimit "max" .
?page wikibase:apiOutput mwapi:title .
?ns wikibase:apiOutput "@ns".
}
FILTER regex (?ns, "(14|0)$") #(sub)categories & gallery pages only
}
} AS %get_files
WHERE
{
INCLUDE %get_files
BIND(REPLACE(?page, " ", "_", "i") AS ?p)
BIND(URI(CONCAT('https://commons.wikimedia.org/wiki/', ?p)) AS ?pageURL).
}
ORDER BY ?page
List of Commons category and gallery pages per volume (Wikidata query service)
edit# List of Commons category and gallery pages per volume (Wikidata query service)
SELECT DISTINCT ?volume ?volumeLabel ?CommonsCategory ?CommonsCategoryURL ?CommonsGallery ?CommonsGalleryURL
WHERE
{
wd:Q117860156 wdt:P527 ?volume.
?volume wdt:P373 ?CommonsCategory.
BIND(REPLACE(?CommonsCategory, " ", "_", "i") AS ?CommonsCat)
BIND(URI(CONCAT('https://commons.wikimedia.org/wiki/Category:', ?CommonsCat)) AS ?CommonsCategoryURL).
?volume wdt:P935 ?CommonsGallery.
BIND(REPLACE(?CommonsGallery, " ", "_", "i") AS ?CommonsGal)
BIND(URI(CONCAT('https://commons.wikimedia.org/wiki/', ?CommonsGal)) AS ?CommonsGalleryURL).
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ?volumeLabel
List of all files
edit# List of all files in Category:Flora Batava - KB copy, and its subcategories
SELECT ?category ?categoryName ?file ?title
WHERE
{
SERVICE wikibase:mwapi
{
bd:serviceParam wikibase:api "Generator" .
bd:serviceParam wikibase:endpoint "commons.wikimedia.org" .
bd:serviceParam mwapi:gcmtitle "Category:Flora Batava - KB copy" .
bd:serviceParam mwapi:generator "categorymembers" .
bd:serviceParam mwapi:gcmlimit "max" .
?categoryName wikibase:apiOutput mwapi:title .
?pageid wikibase:apiOutput "@pageid" .
?ns wikibase:apiOutput "@ns".
}
FILTER (?ns = "14") # (sub)categories only
BIND (URI(CONCAT('https://commons.wikimedia.org/entity/M', ?pageid)) AS ?category)
SERVICE wikibase:mwapi
{
bd:serviceParam wikibase:api "Generator" .
bd:serviceParam wikibase:endpoint "commons.wikimedia.org" .
bd:serviceParam mwapi:gcmtitle ?categoryName.
bd:serviceParam mwapi:generator "categorymembers" .
bd:serviceParam mwapi:gcmtype "file" .
bd:serviceParam mwapi:gcmlimit "max" .
?title wikibase:apiOutput mwapi:title .
?pageid2 wikibase:apiOutput "@pageid" .
}
BIND (URI(CONCAT('https://commons.wikimedia.org/entity/M', ?pageid2)) AS ?file)
} ORDER BY ?category ?title
Get all files and their URLs in Volume 2
editFor File:Agrostis Spica venti (modern=Apera spica-venti) - Pl0151 - FloraBatava-KB-v02.jpg
- MediaID = M132800954 (see this page)
- Title (as string) = File:Agrostis Spica venti (modern=Apera spica-venti) - Pl0151 - FloraBatava-KB-v02.jpg
- FullimageUrl1 = https://upload.wikimedia.org/wikipedia/commons/e/e8/Agrostis_Spica_venti_%28modern%3DApera_spica-venti%29_-_Pl0151_-_FloraBatava-KB-v02.jpg
- FullimageUrl2, via Special:Redirect = https://commons.wikimedia.org/w/index.php?title=Special:Redirect/file&wpvalue=File:Agrostis_Spica_venti_(modern%3DApera_spica-venti)_-_Pl0151_-_FloraBatava-KB-v02.jpg
- PageUrl = https://commons.wikimedia.org/wiki/File:Agrostis_Spica_venti_(modern%3DApera_spica-venti)_-_Pl0151_-_FloraBatava-KB-v02.jpg
- PageShortUrl = https://commons.wikimedia.org/w/index.php?curid=132800954
- PageShortUrl2, via the concept URI = https://commons.wikimedia.org/entity/M132800954
See for help https://www.mediawiki.org/wiki/Wikidata_Query_Service/User_Manual/MWAPI
# For File:Agrostis Spica venti (modern=Apera spica-venti) - Pl0151 - FloraBatava-KB-v02.jpg
# - MediaID = M132800954 (see [https://commons.wikimedia.org/w/index.php?title=File:Agrostis_Spica_venti_(modern%3DApera_spica-venti)_-_Pl0151_-_FloraBatava-KB-v02.jpg&action=info this page])
# - Title (as string)= File:Agrostis Spica venti (modern=Apera spica-venti) - Pl0151 - FloraBatava-KB-v02.jpg
# - FullimageUrl1 = https://upload.wikimedia.org/wikipedia/commons/e/e8/Agrostis_Spica_venti_%28modern%3DApera_spica-venti%29_-_Pl0151_-_FloraBatava-KB-v02.jpg
# - FullimageUrl2, via Special:Redirect = https://commons.wikimedia.org/w/index.php?title=Special:Redirect/file&wpvalue=File:Agrostis_Spica_venti_(modern%3DApera_spica-venti)_-_Pl0151_-_FloraBatava-KB-v02.jpg
# - PageUrl = https://commons.wikimedia.org/wiki/File:Agrostis_Spica_venti_(modern%3DApera_spica-venti)_-_Pl0151_-_FloraBatava-KB-v02.jpg
# - PageShortUrl = https://commons.wikimedia.org/w/index.php?curid=132800954
# - PageShortUrl2, via the concept URI = https://commons.wikimedia.org/entity/M132800954
#
# See for help https://www.mediawiki.org/wiki/Wikidata_Query_Service/User_Manual/MWAPI
SELECT ?MediaID ?Title ?FullimageUrl1 ?FullimageUrl2 ?PageUrl ?PageShortUrl1 ?PageShortUrl2
WITH
{
SELECT ?Title ?pageid ?FullimageUrl1
WHERE
{
SERVICE wikibase:mwapi
{
bd:serviceParam wikibase:api "Generator" .
bd:serviceParam wikibase:endpoint "commons.wikimedia.org" .
bd:serviceParam mwapi:gcmtitle "Category:Flora_Batava_-_KB_copy,_Volume_2,_1807" .
bd:serviceParam mwapi:generator "categorymembers" .
bd:serviceParam mwapi:gcmlimit "500" .
bd:serviceParam mwapi:prop "imageinfo".
bd:serviceParam mwapi:iiprop "url".
?Title wikibase:apiOutput mwapi:title .
?pageid wikibase:apiOutput "@pageid" .
?ns wikibase:apiOutput "@ns".
?FullimageUrl1 wikibase:apiOutputURI "imageinfo/ii/@url".
}
FILTER (?ns = "6") #Files only
}
} AS %get_files
WHERE
{
INCLUDE %get_files
BIND(CONCAT('M', ?pageid) AS ?MediaID)
BIND(REPLACE(?Title, " ", "_", "i") AS ?p)
BIND(URI(CONCAT("https://commons.wikimedia.org/w/index.php?title=Special:Redirect/file&wpvalue=", ?p)) AS ?FullimageUrl2)
BIND(URI(CONCAT('https://commons.wikimedia.org/wiki/', ?p)) AS ?PageUrl).
BIND(URI(CONCAT('https://commons.wikimedia.org/w/index.php?curid=', ?pageid)) AS ?PageShortUrl1)
BIND(URI(CONCAT('https://commons.wikimedia.org/entity/', ?MediaID)) AS ?PageShortUrl2)
}
ORDER BY ?MediaID #approx the same order as the plate numbers
List of all botanical plates
edit# List of all botanical plates in Category:Flora Batava - KB copy, and its subcategories
SELECT ?category ?categoryName ?plate ?file ?title
WHERE
{
SERVICE wikibase:mwapi
{
bd:serviceParam wikibase:api "Generator" .
bd:serviceParam wikibase:endpoint "commons.wikimedia.org" .
bd:serviceParam mwapi:gcmtitle "Category:Flora Batava - KB copy" .
bd:serviceParam mwapi:generator "categorymembers" .
bd:serviceParam mwapi:gcmlimit "max" .
?categoryName wikibase:apiOutput mwapi:title .
?pageid wikibase:apiOutput "@pageid" .
?ns wikibase:apiOutput "@ns".
}
FILTER (?ns = "14") # (sub)categories only
BIND (URI(CONCAT('https://commons.wikimedia.org/entity/M', ?pageid)) AS ?category)
SERVICE wikibase:mwapi
{
bd:serviceParam wikibase:api "Generator" .
bd:serviceParam wikibase:endpoint "commons.wikimedia.org" .
bd:serviceParam mwapi:gcmtitle ?categoryName.
bd:serviceParam mwapi:generator "categorymembers" .
bd:serviceParam mwapi:gcmtype "file" .
bd:serviceParam mwapi:gcmlimit "max" .
?title wikibase:apiOutput mwapi:title .
?pageid2 wikibase:apiOutput "@pageid" .
}
BIND(STRBEFORE(STRAFTER(?title," - Pl")," - FloraBatava-KB-v") AS ?plate)
BIND (URI(CONCAT('https://commons.wikimedia.org/entity/M', ?pageid2)) AS ?file)
FILTER(REGEX(?title,"(Pl[0-9]{4} - FloraBatava-KB-v[0-9]{2}.jpg)$")) #File name ending with "Pl<4 digits> - FloraBatava-KB-v<2 digits>.jpg"
} ORDER BY ?category ?plate
List of all text pages in Dutch
edit# List of all text pages in Dutch in Category:Flora Batava - KB copy, and its subcategories
SELECT ?category ?categoryName ?plate ?file ?title
WHERE
{
SERVICE wikibase:mwapi
{
bd:serviceParam wikibase:api "Generator" .
bd:serviceParam wikibase:endpoint "commons.wikimedia.org" .
bd:serviceParam mwapi:gcmtitle "Category:Flora Batava - KB copy" .
bd:serviceParam mwapi:generator "categorymembers" .
bd:serviceParam mwapi:gcmlimit "max" .
?categoryName wikibase:apiOutput mwapi:title .
?pageid wikibase:apiOutput "@pageid" .
?ns wikibase:apiOutput "@ns".
}
FILTER (?ns = "14") # (sub)categories only
BIND (URI(CONCAT('https://commons.wikimedia.org/entity/M', ?pageid)) AS ?category)
SERVICE wikibase:mwapi
{
bd:serviceParam wikibase:api "Generator" .
bd:serviceParam wikibase:endpoint "commons.wikimedia.org" .
bd:serviceParam mwapi:gcmtitle ?categoryName.
bd:serviceParam mwapi:generator "categorymembers" .
bd:serviceParam mwapi:gcmtype "file" .
bd:serviceParam mwapi:gcmlimit "max" .
?title wikibase:apiOutput mwapi:title .
?pageid2 wikibase:apiOutput "@pageid" .
}
BIND(STRBEFORE(STRAFTER(?title," - Pl")," - DescriptionNL") AS ?plate)
BIND (URI(CONCAT('https://commons.wikimedia.org/entity/M', ?pageid2)) AS ?file)
FILTER(REGEX(?title,"(DescriptionNL[0-9]+ - FloraBatava-KB-v[0-9]{2}.jpg)$"))
} ORDER BY ?category ?plate
List of text pages in French in Volume 1
edit#List of text pages in French in Category:Flora Batava - KB copy, Volume 1, 1800
SELECT ?file ?plate ?title
WHERE
{
SERVICE wikibase:mwapi
{
bd:serviceParam wikibase:api "Generator" .
bd:serviceParam wikibase:endpoint "commons.wikimedia.org" .
bd:serviceParam mwapi:gcmtitle "Category:Flora Batava - KB copy, Volume 1, 1800" .
bd:serviceParam mwapi:generator "categorymembers" .
bd:serviceParam mwapi:gcmtype "file" .
bd:serviceParam mwapi:gcmlimit "max" .
?title wikibase:apiOutput mwapi:title .
?pageid wikibase:apiOutput "@pageid" .
}
BIND(STRBEFORE(STRAFTER(?title," - Pl")," - DescriptionFR") AS ?plate)
BIND (URI(CONCAT('https://commons.wikimedia.org/entity/M', ?pageid)) AS ?file)
FILTER(REGEX(?title,"(DescriptionFR[0-9]+ - FloraBatava-KB-v01.jpg)$"))
} ORDER BY ?plate
List of all non-plate, non-text pages
edit# List of all non-plate, non-text pages in Category:Flora Batava - KB copy, and its subcategories
SELECT ?category ?categoryName ?file ?title
WHERE
{
SERVICE wikibase:mwapi
{
bd:serviceParam wikibase:api "Generator" .
bd:serviceParam wikibase:endpoint "commons.wikimedia.org" .
bd:serviceParam mwapi:gcmtitle "Category:Flora Batava - KB copy" .
bd:serviceParam mwapi:generator "categorymembers" .
bd:serviceParam mwapi:gcmlimit "max" .
?categoryName wikibase:apiOutput mwapi:title .
?pageid wikibase:apiOutput "@pageid" .
?ns wikibase:apiOutput "@ns".
}
FILTER (?ns = "14") # (sub)categories only
BIND (URI(CONCAT('https://commons.wikimedia.org/entity/M', ?pageid)) AS ?category)
SERVICE wikibase:mwapi
{
bd:serviceParam wikibase:api "Generator" .
bd:serviceParam wikibase:endpoint "commons.wikimedia.org" .
bd:serviceParam mwapi:gcmtitle ?categoryName.
bd:serviceParam mwapi:generator "categorymembers" .
bd:serviceParam mwapi:gcmtype "file" .
bd:serviceParam mwapi:gcmlimit "max" .
?title wikibase:apiOutput mwapi:title .
?pageid2 wikibase:apiOutput "@pageid" .
}
BIND (URI(CONCAT('https://commons.wikimedia.org/entity/M', ?pageid2)) AS ?file)
FILTER(!REGEX(?title,"(Pl[0-9]{4} - FloraBatava-KB-v[0-9]{2}.jpg)$"))
FILTER(!REGEX(?title,"(DescriptionFR[0-9]+ - FloraBatava-KB-v[0-9]{2}.jpg)$"))
FILTER(!REGEX(?title,"(DescriptionNL[0-9]+ - FloraBatava-KB-v[0-9]{2}.jpg)$"))
} ORDER BY ?category ?title
Relations between Commons, Wikidata and KB
edit# Relations between images on Wikimedia Commons, Wikidata and KB website - for files in Category:Flora Batava - KB copy, Volume 1, 1800
SELECT DISTINCT ?title ?url
?depicts ?depictsLabel ?depictsIsALabel
?digrepofLabel
?mainsubject ?mainsubjectLabel ?mainsubjectIsALabel
?kbsourceurl
WITH
{
SELECT ?file ?title
WHERE
{
SERVICE wikibase:mwapi
{
bd:serviceParam wikibase:api "Generator" .
bd:serviceParam wikibase:endpoint "commons.wikimedia.org" .
bd:serviceParam mwapi:gcmtitle "Category:Flora Batava - KB copy, Volume 1, 1800" .
bd:serviceParam mwapi:generator "categorymembers" .
bd:serviceParam mwapi:gcmtype "file" .
bd:serviceParam mwapi:gcmlimit "max" .
?title wikibase:apiOutput mwapi:title .
?pageid wikibase:apiOutput "@pageid" .
}
BIND (URI(CONCAT('https://commons.wikimedia.org/entity/M', ?pageid)) AS ?file)
}
} AS %get_files
WHERE
{
INCLUDE %get_files
?file schema:url ?url.
OPTIONAL {?file wdt:P180 ?depicts.
SERVICE <https://query.wikidata.org/sparql> {
?depicts rdfs:label ?depictsLabel FILTER (lang(?depictsLabel) = "en").
?depicts wdt:P31 ?depictsIsA.
FILTER (?depictsIsA = wd:Q11060274) # ?depicts must be instance of print/Q11060274
?depictsIsA rdfs:label ?depictsIsALabel FILTER (lang(?depictsIsALabel) = "en").}
}
OPTIONAL {?file wdt:P6243 ?digrepof. #digital representation of
SERVICE <https://query.wikidata.org/sparql> {
?digrepof rdfs:label ?digrepofLabel FILTER (lang(?digrepofLabel) = "en").}
}
OPTIONAL {?file wdt:P921 ?mainsubject.
SERVICE <https://query.wikidata.org/sparql> {
?mainsubject rdfs:label ?mainsubjectLabel FILTER (lang(?mainsubjectLabel) = "la").
?mainsubject wdt:P31 ?mainsubjectIsA.
FILTER (?mainsubjectIsA = wd:Q16521) # ?mainsubject must be instance of taxon/Q16521
?mainsubjectIsA rdfs:label ?mainsubjectIsALabel FILTER (lang(?mainsubjectIsALabel) = "en").}
}
OPTIONAL {?file p:P7482 [ps:P7482 ?source; pq:P973 ?kbsourceurl].}
}
ORDER BY DESC (?depictsLabel)
Persons, authors, editors, publishers, illustrators etc.
editVolumes by Jan Kops (Q2372924)
edit# Volumes by Jan Kops
SELECT DISTINCT ?volume ?volumeLabel ?author ?authorLabel
WHERE
{
BIND (wd:Q2372924 AS ?writer) # target author = Jan Kops
BIND (wd:Q117860156 AS ?fb) #Flora Batava KB
?fb wdt:P527 ?volume.
?volume wdt:P50 ?author.
FILTER (?author = ?writer) # filter for target author
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ?volumeLabel
Authors/editors per volume
edit# Authors/editors per volume
SELECT DISTINCT ?volume ?volumeLabel
(GROUP_CONCAT(DISTINCT ?author; SEPARATOR = " -- ") AS ?authors)
(GROUP_CONCAT(DISTINCT ?authorLabel; SEPARATOR = " -- ") AS ?authorLabels)
WHERE
{
BIND (wd:Q117860156 AS ?fb) #Flora Batava KB
?fb wdt:P527 ?volume.
?volume wdt:P50 ?author.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
?author rdfs:label ?authorLabel.
?volume rdfs:label ?volumeLabel.}
}
GROUP BY ?volume ?volumeLabel
ORDER BY ?volumeLabel
Volumes containing plates made by Georgius Jacobus Johannes van Os (Q324567)
editPlates made by Georgius Jacobus Johannes van Os (Q324567)
editVolumes per publisher and place of publication
edit# Volumes per publisher and place of publication
SELECT DISTINCT
?publisher ?publisherLabel ?volume ?volumeLabel ?placeofpublication ?placeofpublicationLabel
WHERE
{
BIND (wd:Q117860156 AS ?fb) #Flora Batava KB
?fb wdt:P527 ?volume.
?volume wdt:P123 ?publisher;
wdt:P291 ?placeofpublication.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ?volumeLabel
Botanical queries
editList of all plates, all volumes, with their depecited plant species, their historical and modern botanical (scientific) and Dutch (trivial) names, and Dutch Wikipedia articles about the plants
edit# List of all plates, all volumes, with their depecited plants, their historical and modern botanical (scientific) and Dutch (trivial) names, and Dutch Wikipedia articles about the plants.
SELECT DISTINCT
?volume ?volumeLabel
?plate ?plateLabel ?plateImage
?plantDecpicted
?scientificNameInFB ?dutchTrivialNameInFB ?scientificNameModern ?dutchTrivialNameModern
?plantDecpictedWikipediaNL
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')
OPTIONAL{?plantDecpictedWikipediaNL schema:about ?plantDecpicted;
schema:isPartOf <https://nl.wikipedia.org/>.}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],nl". }
}
ORDER BY ?volumeLabel ?plateLabel
Plant name indexes
editList of Latin scientific/botanical names, as mentioned in the book
edit#List of scientific/botanical Latin names as mentioned in the Flora Batava
SELECT DISTINCT
?scientificNameInFB ?dutchTrivialNameInFB ?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')
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],nl". }
}
ORDER BY ?scientificNameInFB
List of trivial Dutch names, as mentioned in the book, starting with 'A' (or 'a')
edit#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
List of modern scientific/botanical Latin names
edit#List of modern scientific/botanical Latin names
SELECT DISTINCT
?scientificNameModern ?dutchTrivialNameModern ?scientificNameInFB ?dutchTrivialNameInFB
?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')
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],nl". }
}
ORDER BY ?scientificNameModern
List of modern trivial Dutch names, starting with 'S' (or 's')
edit# List of modern trivial Dutch plant names, starting with 'S' or 's'
SELECT DISTINCT
?dutchTrivialNameModern ?scientificNameModern ?scientificNameInFB ?dutchTrivialNameInFB
?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(?dutchTrivialNameModern)), 'S'))
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],nl". }
}
ORDER BY ?dutchTrivialNameModern
Overview of category and gallery pages of plant species on Wikimedia Commons
editAction: for botanical illustration categories, request number of category members via API (via SPARQL). If this is 0, the cat is empty / does not exist
# Overview of Category and Gallery pages of plant species on Wikimedia Commons
SELECT DISTINCT
?plate ?plateLabel
?plantDecpicted
?scientificNameInFB ?scientificNameModern ?dutchTrivialNameModern
?plantDecpictedWikipediaNL
?plantDecpictedCommonsCat ?plantDecpictedCommonsCatBotIll ?plantDecpictedCommonsGal
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:P180 ?plantDecpicted.
?plantDecpicted rdfs:label ?scientificNameModern . FILTER(lang(?scientificNameModern)='la')
?plantDecpicted rdfs:label?dutchTrivialNameModern . FILTER(lang(?dutchTrivialNameModern)='nl')
OPTIONAL{?plantDecpictedWikipediaNL schema:about ?plantDecpicted;
schema:isPartOf <https://nl.wikipedia.org/>.}
OPTIONAL{?plantDecpicted wdt:P373 ?plantDCCat.
BIND(REPLACE(?plantDCCat, " ", "_", "i") AS ?plantDCCat2)
BIND(URI(CONCAT('https://commons.wikimedia.org/wiki/Category:', ?plantDCCat2)) AS ?plantDecpictedCommonsCat).
BIND(URI(CONCAT(STR(?plantDecpictedCommonsCat),'_-_botanical_illustrations')) AS ?plantDecpictedCommonsCatBotIll).
}
OPTIONAL{?plantDecpicted wdt:P935 ?plantDCGal.
BIND(REPLACE(?plantDCGal, " ", "_", "i") AS ?plantDCGal2)
BIND(URI(CONCAT('https://commons.wikimedia.org/wiki/', ?plantDCGal2)) AS ?plantDecpictedCommonsGal).
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],nl". }
}
ORDER BY ?plateLabel
Historical vs. modern images and distribution maps of plants
edit1) 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 (Verspreidingsatlas.nl ID (P6142) = 1351):
- Historical illustration vs. modern photo of plant
- Map of historical distribution vs. current distribution of this plant.
# 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