Update BIBFRAME SPARQL to FOLIO Records

[jermnelson]

Based on @kallimathios (see attached) new SPARQL queries, update/add to the SPARQL query templates at:

• BIBFRAME Instance
• BIBFRAME Work

SPARQL queries for Sinopia to FOLIO_26-02-2024.txt

[kallimathios]

Hi Jeremy - just adding a note here as I was going through these queries, I found a typo where I duplicated a line under #Administrative data - cataloger id and cataloged_date. Sorry about that. They should read:

#Administrative data - cataloger id
PREFIX bf: http://id.loc.gov/ontologies/bibframe/
PREFIX bflc: http://id.loc.gov/ontologies/bflc/
PREFIX sinopia: http://sinopia.io/vocabulary/
PREFIX rdf: http://www.w3.org/1999/02/22-rdf-syntax-ns#
PREFIX rdfs: http://www.w3.org/2000/01/rdf-schema#

SELECT ?subject ?administrative_note
WHERE {
?subject a bf:Instance ;
bf:adminMetadata ?admin_wild .
?admin_wild bflc:catalogerId ?administrative_note .
}

#Administrative data - cataloged date
PREFIX bf: http://id.loc.gov/ontologies/bibframe/
PREFIX sinopia: http://sinopia.io/vocabulary/
PREFIX rdf: http://www.w3.org/1999/02/22-rdf-syntax-ns#
PREFIX rdfs: http://www.w3.org/2000/01/rdf-schema#

SELECT ?subject ?cataloged_date
WHERE {
?subject a bf:Instance ;
bf:adminMetadata ?admin_wild .
?admin_wild bf:creationDate ?cataloged_date .
}

Thanks!

[kallimathios]

Another update for the addition of bf:OclcNumber class:

#Resource identifier - OCLC
PREFIX bf: http://id.loc.gov/ontologies/bibframe/
PREFIX sinopia: http://sinopia.io/vocabulary/
PREFIX rdf: http://www.w3.org/1999/02/22-rdf-syntax-ns#
PREFIX rdfs: http://www.w3.org/2000/01/rdf-schema#

SELECT ?subject ?oclc
WHERE {
?subject a bf:Instance ;
bf:identifiedBy ?id .
?id a bf:OclcNumber ;
rdf:value ?oclc .
}