LD4P / ils-middleware

PoC for using Apache Airflow to manage interactions with multiple ILS
Apache License 2.0
0 stars 1 forks source link

Update BIBFRAME SPARQL to FOLIO Records #195

Open jermnelson opened 6 months ago

jermnelson commented 6 months ago

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

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

kallimathios commented 1 month ago

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 commented 2 weeks ago

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 . }