|
|
(3 intermediate revisions by the same user not shown) |
Line 1: |
Line 1: |
| Welcome to CLB-LOD Wikibase, a Wikibase instance hosted on [https://wikibase.cloud wikibase.cloud]. This is a sandbox for working towards MARC bibliographical records LOD-ification, with the final goal of their integration in Wikidata, with [https://clb.ucl.cas.cz/en/ CLB Czech Literary Bibliography] MARC-XML data as showcase. This is a project carried out in the framework of [https://www.dariah.eu/activities/working-groups/bibliographical-data-bibliodata/ DARIAH WG Bibliodata]. | | Welcome to CLB-LOD Wikibase, a Wikibase instance hosted on [https://wikibase.cloud wikibase.cloud]. This is a sandbox for working towards MARC bibliographical records LOD-ification, with the final goal of their integration in Wikidata, with [https://clb.ucl.cas.cz/en/ CLB Czech Literary Bibliography] MARC-XML data as showcase. This is a project carried out in the framework of [https://www.dariah.eu/activities/working-groups/bibliographical-data-bibliodata/ DARIAH WG Bibliodata]. |
| | |
| | The code used in this experiment for re-modeling and sending MARC records to Wikibase is found here: https://github.com/dlindem/wikibase/tree/main/clb |
|
| |
|
| == SPARQL Queries == | | == SPARQL Queries == |
| === MARC records in CLB-LOD ===
| | See [[SPARQL examples]]. |
| <sparql tryit="1">
| |
| PREFIX clbwb: <https://clb-lod.wikibase.cloud/entity/>
| |
| PREFIX clbdp: <https://clb-lod.wikibase.cloud/prop/direct/>
| |
| PREFIX clbp: <https://clb-lod.wikibase.cloud/prop/>
| |
| PREFIX clbps: <https://clb-lod.wikibase.cloud/prop/statement/>
| |
| PREFIX clbpq: <https://clb-lod.wikibase.cloud/prop/qualifier/>
| |
| PREFIX clbpr: <https://clb-lod.wikibase.cloud/prop/reference/>
| |
| PREFIX clbno: <https://clb-lod.wikibase.cloud/prop/novalue/>
| |
| | |
| select ?wikibase_item ?pubtype ?1stauthor (group_concat(?title;SEPARATOR=" == ") as ?titles)
| |
|
| |
| where {
| |
| ?wikibase_item clbdp:P5 clbwb:Q3; clbdp:P58 ?type; clbdp:P6 ?title.
| |
| ?type rdfs:label ?pubtype . filter(lang(?pubtype)="en")
| |
| optional {?wikibase_item clbp:P12 [clbps:P12 ?1stau; clbpq:P14 "1"] .
| |
| ?1stau clbdp:P48 ?1stauthor.}
| |
| } group by ?wikibase_item ?pubtype ?1stauthor ?titles
| |
| </sparql>
| |
| | |
| === Creators in CLB-LOD ===
| |
| <sparql tryit="1">
| |
| PREFIX clbwb: <https://clb-lod.wikibase.cloud/entity/>
| |
| PREFIX clbdp: <https://clb-lod.wikibase.cloud/prop/direct/>
| |
| PREFIX clbp: <https://clb-lod.wikibase.cloud/prop/>
| |
| PREFIX clbps: <https://clb-lod.wikibase.cloud/prop/statement/>
| |
| PREFIX clbpq: <https://clb-lod.wikibase.cloud/prop/qualifier/>
| |
| PREFIX clbpr: <https://clb-lod.wikibase.cloud/prop/reference/>
| |
| PREFIX clbno: <https://clb-lod.wikibase.cloud/prop/novalue/>
| |
| | |
| select ?wikibase_item ?label
| |
| (iri(concat("http://www.wikidata.org/entity/",?wikidata)) as ?wikidata_link)
| |
| (iri(concat("https://aleph.nkp.cz/F/?func=find-c&local_base=aut&ccl_term=ica=",?nkcr)) as ?nkcr_link)
| |
| (count(?bibitem) as ?author_roles)
| |
|
| |
| where {
| |
| ?wikibase_item clbdp:P5 clbwb:Q5; rdfs:label ?label. filter (lang(?label)="en")
| |
| ?wikibase_item clbdp:P8 ?nkcr .
| |
| optional {?wikibase_item clbdp:P1 ?wikidata .}
| |
| optional {?bibitem clbdp:P12 ?wikibase_item .}
| |
|
| |
| } group by ?wikibase_item ?label ?nkcr ?wikidata ?author_roles order by desc(?author_roles)
| |
| </sparql>
| |
| | |
| === UDC Classificators in CLB-LOD ===
| |
| UDC Classificators, at the moment, are represented as literals as in MARC. A conceptual mapping, i.e. linking classificators to concepts, is planned.
| |
| <sparql tryit="1">
| |
| PREFIX clbwb: <https://clb-lod.wikibase.cloud/entity/>
| |
| PREFIX clbdp: <https://clb-lod.wikibase.cloud/prop/direct/>
| |
| PREFIX clbp: <https://clb-lod.wikibase.cloud/prop/>
| |
| PREFIX clbps: <https://clb-lod.wikibase.cloud/prop/statement/>
| |
| PREFIX clbpq: <https://clb-lod.wikibase.cloud/prop/qualifier/>
| |
| PREFIX clbpr: <https://clb-lod.wikibase.cloud/prop/reference/>
| |
| PREFIX clbno: <https://clb-lod.wikibase.cloud/prop/novalue/>
| |
| | |
| select ?udc_literal (count(?wikibase_item) as ?bibitems)
| |
|
| |
| where {
| |
| ?wikibase_item clbp:P86 [clbpq:P87 ?udc_literal] .
| |
|
| |
| } group by ?udc_literal ?bibitems order by desc(?bibitems)
| |
| </sparql>
| |
| | |
| See also some more [[SPARQL examples]]. | |