I’m currently working on mapping PAS data to the CIDOC-CRM and I’m trying to align our thesauri with the SENESCHAL uris. To get the all the URIs from their system, run this SPARQL query on their endpoint with the URI, preferred label and scope note being obtained. I can then dump these into my database or create a CSV file easily from the results to reference later.
FISH object thesaurus
To obtain the URIs and extra information from the FISH archaeological objects thesaurus which number 2020:
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
SELECT *
WHERE {
?subject a skos:Concept ;
skos:inScheme <http://purl.org/heritagedata/schemes/mda_obj> ;
skos:prefLabel ?label ;
skos:scopeNote ?note
}
ORDER BY ASC(?label)
EH periods
To obtain the English Heritage period URIs which number 30 in total:
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
SELECT *
WHERE {
?subject a skos:Concept ;
skos:inScheme <http://purl.org/heritagedata/schemes/eh_period>;
skos:prefLabel ?label;
}
ORDER BY ASC(?label)
EH Building materials
To obtain the English Heritage building materials URIs which number 231 in total:
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
SELECT *
WHERE {
?subject a skos:Concept ;
skos:inScheme <http://purl.org/heritagedata/schemes/eh_tbm>;
skos:prefLabel ?label;
}
ORDER BY ASC(?label)
EH Event types
To obtain the English Heritage event type URIs of which there are 97:
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
SELECT *
WHERE {
?subject a skos:Concept ;
skos:inScheme <http://purl.org/heritagedata/schemes/agl_et> ;
skos:prefLabel ?label ;
}
ORDER BY ASC(?label)
EH monument types
To obtain the EH monument type URIs of which there are 4855:
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
SELECT *
WHERE {
?subject a skos:Concept ;
skos:inScheme <http://purl.org/heritagedata/schemes/eh\_tmt2> ;
skos:prefLabel ?label ;
}
ORDER BY ASC(?label)
Counting results
To get a count for any of these:
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
SELECT (COUNT(*) AS ?count)
WHERE {
?subject a skos:Concept ;
skos:inScheme <SCHEME URI> ; }
Offsetting
The end point returns a maximum of 250 records, and so to get more results, use OFFSET n as shown below:
PREFIX skos:
SELECT *
WHERE {
?subject a skos:Concept;
skos:inScheme <YOUR SCHEME URI>;
skos:prefLabel ?label;
skos:scopeNote ?note
}
ORDER BY ASC(?label)
OFFSET 250