View on GitHub

Portable Antiquities County Blogs - revived

An archive of the old PAS blogs that went missing.

Download this project as a .zip file Download this project as a tar.gz file

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
central unit (23) danish research (8) denmark (1) essex (8) finds advisers (1) frome hoard (20) hampshire (1) isle of wight (1) labs (3) lancashire (1) lincolnshire (13) news (3) north east (9) north west (20) north yorkshire (1) northants (9) oxfordshire (2) piercebridge (3) roman coins (1) roman numismatics phd (7) somerset (14) sussex (3) technology (1) the marches (11) treasure (21) west midlands (6) wiltshire (1)