DS Catalog:SPARQL Query Service/example queries: Difference between revisions

 
Line 2,169: Line 2,169:


==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. 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).
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 Saint Louis University, but can be altered for other datasets (see information in commented sections).


<syntaxhighlight lang="SPARQL">
<syntaxhighlight lang="SPARQL">
Line 2,319: Line 2,319:
     }
     }
    
    
BIND(CONCAT("Columbia, Missouri, ",?holderDSLabel,", ",?shelfmark) as ?signature) # hard code location for institution
BIND(CONCAT("Saint Louis, 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>
Bots, Bureaucrats, emailconfirmed, Administrators
30,537

edits