30,537
edits
DS Catalog:SPARQL Query Service/example queries: Difference between revisions
DS Catalog:SPARQL Query Service/example queries (view source)
Revision as of 15:21, 5 November 2024
, 18 days ago→Wikidata Uploading Query
| Line 2,119: | Line 2,119: | ||
==Wikidata Uploading Query== | ==Wikidata Uploading Query== | ||
As part of a pilot project, DS is uploading data about manuscripts to represent manuscript objects as Wikidata items. The following query pulls down and formats a dataset which can be loaded in OpenRefine and uploaded to Wikidata using a Wikibase schema. | As part of a pilot project, DS is uploading data about manuscripts to represent manuscript objects as Wikidata items. The following query pulls down and formats a dataset which can be loaded in OpenRefine and uploaded to Wikidata using a Wikibase schema. This query is set up to pull records from the University of Missouri, but can be altered for other datasets (see information in commented sections). | ||
<syntaxhighlight lang="SPARQL"> | <syntaxhighlight lang="SPARQL"> | ||
| Line 2,269: | Line 2,269: | ||
} | } | ||
BIND(CONCAT("Columbia, Missouri, ",?holderDSLabel,", ",?shelfmark) as ?signature) | BIND(CONCAT("Columbia, Missouri, ",?holderDSLabel,", ",?shelfmark) as ?signature) # hard code location for institution | ||
} | } | ||
GROUP BY ?signature ?instanceOf ?scriptNote ?holderDS ?holderWikidata ?DSID ?institutionalID ?shelfmark ?record ?link | GROUP BY ?signature ?instanceOf ?scriptNote ?holderDS ?holderWikidata ?DSID ?institutionalID ?shelfmark ?record ?link | ||
</syntaxhighlight> | </syntaxhighlight> | ||