1,449,764
edits
Project:SPARQL/examples: Difference between revisions
From geokb
no edit summary
(→People) |
No edit summary |
||
| Line 98: | Line 98: | ||
?item wdt:P2* wd:Q158710 ; | ?item wdt:P2* wd:Q158710 ; | ||
skos:altLabel ?itemAltLabel . | skos:altLabel ?itemAltLabel . | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . } | |||
} | |||
</sparql> | |||
= iSAID = | |||
The following queries focus on the entities and linkages in the GeoKB related to USGS staff and capacity assessment analyses. | |||
== USGS Current and Former Staff == | |||
<sparql tryit="1"> | |||
PREFIX wd: <https://geokb.wikibase.cloud/entity/> | |||
PREFIX wdt: <https://geokb.wikibase.cloud/prop/direct/> | |||
PREFIX p: <https://geokb.wikibase.cloud/prop/> | |||
PREFIX pq: <https://geokb.wikibase.cloud/prop/qualifier/> | |||
SELECT ?item ?itemLabel ?orcid ?email ?url ?end_time | |||
WHERE { | |||
?item wdt:P107 wd:Q44210 ; # Employed by the USGS | |||
p:P107 ?prop_statement . | |||
OPTIONAL { | |||
?prop_statement pq:P61 ?end_time . # Any value here indicates that employment status ended at some point | |||
} | |||
OPTIONAL { | |||
?item wdt:P106 ?orcid . | |||
} | |||
OPTIONAL { | |||
?item wdt:P109 ?email . | |||
} | |||
OPTIONAL { | |||
?item wdt:P145 ?url . | |||
} | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . } | SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . } | ||
} | } | ||
</sparql> | </sparql> | ||
