-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathfind all botanists
32 lines (23 loc) · 1.02 KB
/
find all botanists
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
SELECT ?human ?humanLabel ?yob ?yod ?ISNI ?Harvard ?ORCID ?VIAF ?IPNI
WHERE
{
#will return duplicated rows for every instance of an id.
{?human wdt:P106 wd:Q2374149.} UNION #with proffession botanist
{?human wdt:P586 ?id .} UNION #with IPNI person identifier
#{?human wdt:P106 wd:Q350979 .} UNION # can be expanded by other properties, eg. profession is zoologist
{?human wdt:P106 wd:Q18805 .} #profession is naturalist
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
#display year of birth and year of death
OPTIONAL { ?human wdt:P569 ?dob . BIND(YEAR(?dob) as ?yob) }
OPTIONAL { ?human wdt:P570 ?dod . BIND(YEAR(?dod) as ?yod) }
#display some personal identifiers
OPTIONAL { ?human wdt:P213 ?ISNI .}
OPTIONAL { ?human wdt:P6264 ?Harvard .}
OPTIONAL { ?human wdt:P496 ?ORCID .}
OPTIONAL { ?human wdt:P214 ?VIAF .}
OPTIONAL { ?human wdt:P586 ?IPNI .}
}
#Offset the query to continue where you left off
#OFFSET 20000
#Limit the output
#LIMIT 2000