Main Page: Difference between revisions

From clb-lod
Line 2: Line 2:


== SPARQL Queries ==
== SPARQL Queries ==
=== MARC records 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 ?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 ===
=== Creators in CLB-LOD ===
<sparql tryit="1">
<sparql tryit="1">

Revision as of 14:02, 2 October 2022

Welcome to CLB-LOD Wikibase, a Wikibase instance hosted on wikibase.cloud. This is a sandbox for working towards MARC bibliographical records LOD-ification, with the final goal of their integration in Wikidata, with CLB Czech Literary Bibliography MARC-XML data as showcase. This is a project carried out in the framework of DARIAH WG Bibliodata.

SPARQL Queries

Creators in CLB-LOD

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)

Try it!


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.

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)

Try it!


See also some more SPARQL examples.