Wikidata:WikiProject Alba amicorum National Library of the Netherlands/Extract-KB-LOD-AA

This project is part of the Wikidata efforts of the Koninklijke Bibliotheek Nederland

Home

Pilot projects

Overviews

Source data

All project pages

Overview

Europeana

data.bibliotheken.nl

KB catalog

KB website

Other sources

How to extract the alba amicorum + album contributions available in http://data.bibliotheken.nl/doc/dataset/rise-alba using SPARQL

SPARQL endpoint and dataset

• SPARQL endpoint: http://data.bibliotheken.nl/sparql
• Dataset: http://data.bibliotheken.nl/id/dataset/rise-alba

Querying alba amicorum (+contributions) through data.bibliotheken.nl SPARQL endpoint

Alba only

SELECT DISTINCT ?album ?inventoryNumber ?albumtitle ?image WHERE {
?inscription foaf:isPrimaryTopicOf/void:inDataset <http://data.bibliotheken.nl/id/dataset/rise-alba> .
?inscription schema:isPartOf ?album .
?album schema:name ?albumtitle .
?album schema:identifier ?inventoryNumber. 
?album schema:dateCreated ?dateCreated .
?album schema:image ?a .
?a schema:contentUrl ?image .
} ORDER BY ?album

Direct URL: http://data.bibliotheken.nl/sparql?default-graph-uri=&query=SELECT+DISTINCT+%3Falbum+%3FinventoryNumber+%3Falbumtitle+%3Fimage+WHERE+%7B%0D%0A+++%3Finscription+foaf%3AisPrimaryTopicOf%2Fvoid%3AinDataset+%3Chttp%3A%2F%2Fdata.bibliotheken.nl%2Fid%2Fdataset%2Frise-alba%3E+.%0D%0A+++%3Finscription+schema%3AisPartOf+%3Falbum+.%0D%0A+++%3Falbum+schema%3Aname+%3Falbumtitle+.%0D%0A+++%3Falbum+schema%3Aidentifier+%3FinventoryNumber.+%0D%0A+++%3Falbum+schema%3AdateCreated+%3FdateCreated+.%0D%0A+++%3Falbum+schema%3Aimage+%3Fa+.%0D%0A+++%3Fa+schema%3AcontentUrl+%3Fimage+.%0D%0A+++%7D+ORDER+BY+%3Falbum+%0D%0A&format=text%2Fhtml&timeout=0&debug=on&run=+Run+Query+

Alba with GROUP_CONCAT

Retrieves 57 alba

SELECT DISTINCT 
?album
?albumtitle
(GROUP_CONCAT(DISTINCT(?owner); separator="****") as ?albumowner)
(GROUP_CONCAT(DISTINCT(?albumdescr); separator="****") as ?albumdescription)
(GROUP_CONCAT(DISTINCT(?albumlocation); separator="****") as ?albumlocationcreated)
(GROUP_CONCAT(DISTINCT(?inventory); separator="****") as ?inventoryNumber)
(GROUP_CONCAT(DISTINCT(?material); separator="****") as ?albummaterial)
(GROUP_CONCAT(DISTINCT(?date); separator="****") as ?dateCreated)
?albumpages 
?albumwidth
?albumheight
#(GROUP_CONCAT(DISTINCT(?image); separator="****") as ?albumimages)
WHERE {
?contrib foaf:isPrimaryTopicOf/void:inDataset <http://data.bibliotheken.nl/id/dataset/rise-alba> .
?contrib schema:isPartOf ?album .
?album schema:name ?albumtitle .
OPTIONAL{?album schema:numberOfPages ?albumpages.}
#?album schema:image ?a .
#?a schema:contentUrl ?image .
#CONCAT fields
OPTIONAL{?album schema:material ?material.} 
OPTIONAL{?album schema:description ?albumdescr.}
OPTIONAL{?album schema:locationCreated ?albumlocation.}
OPTIONAL{?album schema:identifier ?inventory.} 
OPTIONAL{?album schema:width ?albumwidth.}
OPTIONAL{?album schema:height ?albumheight.}
OPTIONAL{?album schema:dateCreated ?date.}
OPTIONAL{?album schema:author ?owner.} 
} #GROUP BY ?album  ?albumwidth ?albumheight #?albumpages
ORDER BY ?album

Alba and their contributions

Retrieves 2096 results

SELECT DISTINCT ?album ?albumtitle ?contrib ?contribtitle WHERE { #
?contrib foaf:isPrimaryTopicOf/void:inDataset <http://data.bibliotheken.nl/id/dataset/rise-alba> .
?contrib schema:name ?contribtitle .
?contrib schema:isPartOf ?album .
?album schema:name ?albumtitle .
} ORDER BY ?album

Querying alba amicorum (+ contributions) through the WDQS interface

All alba amicorum in data.bibliotheken.nl

Finds only 55 alba, not 57 as above. Why is there a differecne of 2? --> find out

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX schema: <http://schema.org/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

SELECT DISTINCT ?album ?albumtitle WHERE {
  
  SERVICE <http://data.bibliotheken.nl/sparql>{
   ?inscription schema:isPartOf ?album .
   ?album schema:name ?albumtitle .
   ?album schema:identifier ?inventoryNumber. 
   ?album schema:dateCreated ?dateCreated .
   ?album schema:image ?a .
   ?a schema:contentUrl ?image .
}
}
ORDER BY ?album
limit 1000

Try it!

Contributions to an album with the name 'Kerwal'

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX schema: <http://schema.org/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

SELECT ?album  ?album_name ?bijdrage ?bijdrage_name ?auteur (GROUP_CONCAT(?desc;SEPARATOR = " ") as ?bijdrage_beschrijving) ?maakdatum ?maaklocatie ?afbeelding ?bijdrage_nummer WHERE {
  
  SERVICE <http://data.bibliotheken.nl/sparql>{
      ?album schema:name ?album_name .
      ?bijdrage schema:isPartOf ?album .
      ?bijdrage schema:description ?desc .
      ?bijdrage schema:name ?bijdrage_name .
      ?bijdrage schema:author ?auteur.
      ?bijdrage schema:dateCreated ?maakdatum.
      ?bijdrage schema:locationCreated ?maaklocatie.
      ?bijdrage schema:image [ schema:contentUrl ?afbeelding] .
      ?bijdrage schema:position ?bijdrage_nummer .
      FILTER Contains(?album_name,"Kerwal")
}
}
GROUP BY ?album ?bijdrage ?afbeelding ?auteur ?maakdatum ?maaklocatie ?album_name ?bijdrage_name ?bijdrage_nummer
ORDER BY xsd:integer(?bijdrage_nummer)
limit 1000

Try it!

All contributions to alba amicorum in data.bibliotheken.nl (3721 rows)

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX schema: <http://schema.org/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>

SELECT DISTINCT ?album  ?album_name ?bijdrage ?bijdrage_name ?auteur (GROUP_CONCAT(DISTINCT ?desc;SEPARATOR = " ") as ?bijdrage_beschrijving) ?maakdatum ?maaklocatie ?afbeelding ?bijdrage_nummer WHERE {
  
  SERVICE <http://data.bibliotheken.nl/sparql>{
      ?album schema:name ?album_name .
      ?bijdrage schema:isPartOf ?album .
      ?bijdrage schema:description ?desc .
      ?bijdrage schema:name ?bijdrage_name .
      ?bijdrage schema:author ?auteur.
      ?bijdrage schema:dateCreated ?maakdatum.
      ?bijdrage schema:locationCreated ?maaklocatie.
      ?bijdrage schema:image [ schema:contentUrl ?afbeelding] .
      ?bijdrage schema:position ?bijdrage_nummer .
      #FILTER Contains(?album_name,"*")
  }
  } 
  GROUP BY ?album ?bijdrage ?afbeelding ?auteur ?maakdatum ?maaklocatie ?album_name ?bijdrage_name ?bijdrage_nummer
  ORDER BY ?album_name xsd:integer(?bijdrage_nummer)

Try it!

Number of alba and contributions

• No of alba: 55 or 57? (see above, why is there a difference of 2?)
• No of contributions: 2096 (or 3721) ? (SPARQL-query ?)

http://data.bibliotheken.nl/sparql?default-graph-uri=&query=SELECT+DISTINCT+%3Falbum+%28count%28%3Falbumtitle%29+as+%3Faantalbijdragen%29+WHERE+%7B%0D%0A%3Finscription+foaf%3AisPrimaryTopicOf%2Fvoid%3AinDataset+%3Chttp%3A%2F%2Fdata.bibliotheken.nl%2Fid%2Fdataset%2Frise-alba%3E+.%0D%0A%3Finscription+schema%3AisPartOf+%3Falbum+.%0D%0A%3Falbum+schema%3Aname+%3Falbumtitle+.%0D%0A%23%3Falbum+schema%3Aidentifier+%3FinventoryNumber.+%0D%0A%23%3Falbum+schema%3AdateCreated+%3FdateCreated+.%0D%0A%23%3Falbum+schema%3Aimage+%3Fa+.%0D%0A%23%3Fa+schema%3AcontentUrl+%3Fimage+.%0D%0A%7D+GROUP+BY+%3Falbum&format=text%2Fhtml&timeout=0&debug=on&run=+Run+Query+ --> 57 alba and 2096 contributions