Open Data in Heritage Science

SPARQL: Custom query example

PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#>
PREFIX owl:<http://www.w3.org/2002/07/owl#>
PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX crm:<http://www.cidoc-crm.org/cidoc-crm/>
PREFIX aat:<http://vocab.getty.edu/page/aat/>
PREFIX wd:<http://www.wikidata.org/entity/>
PREFIX ng:<https://data.ng-london.org.uk/>
PREFIX dig:<http://www.cidoc-crm.org/crmdig/>
PREFIX sci:<http://www.cidoc-crm.org/crmsci/>

#use combined

SELECT DISTINCT * WHERE {

?thing ?outgoingProperty ?relatedObject .
  OPTIONAL {
    ?relatedObject rdfs:label ?relatedObjectLabel . }
  OPTIONAL {
    ?relatedObject crm:P2_has_type ?relatedObjectType .
    OPTIONAL { ?relatedObjectType rdfs:label ?relatedObjectTypeLabel . } }

OPTIONAL { 
  ?relatedSubject ?incomingProperty ?thing . 
  OPTIONAL {
    ?relatedSubject rdfs:label ?relatedSubjectLabel . }
  OPTIONAL {
    ?relatedSubject crm:P2_has_type ?relatedSubjectType .
    OPTIONAL { ?relatedSubjectType rdfs:label ?relatedSubjectTypeLabel . }}
  }

FILTER ( ?thing = ng:SC-B8NM-SCKN-4HJK-XEQH ) .
} LIMIT 250

Query Results

[{"thing":{"type":"uri","value":"https://data.ng-london.org.uk/SC-B8NM-SCKN-4HJK-XEQH"},"outgoingProperty":{"type":"uri","value":"http://www.cidoc-crm.org/cidoc-crm/P2_has_type"},"relatedObject":{"type":"uri","value":"http://www.wikidata.org/entity/Q3411251"},"relatedObjectLabel":{"xml:lang":"en","type":"literal","value":"pyramid"},"relatedSubject":{"type":"uri","value":"https://data.ng-london.org.uk/SC-GC4A-IRU0-RS9L-YSOJ"},"incomingProperty":{"type":"uri","value":"http://www.cidoc-crm.org/crmdig/L22_created_derivative"},"relatedSubjectType":{"type":"uri","value":"http://www.cidoc-crm.org/crmdig/D3_Formal_Derivation"}},{"thing":{"type":"uri","value":"https://data.ng-london.org.uk/SC-B8NM-SCKN-4HJK-XEQH"},"outgoingProperty":{"type":"uri","value":"http://www.cidoc-crm.org/cidoc-crm/P2_has_type"},"relatedObject":{"type":"uri","value":"http://www.wikidata.org/entity/Q3411251"},"relatedObjectLabel":{"xml:lang":"en","type":"literal","value":"pyramid"},"relatedSubject":{"type":"uri","value":"https://data.ng-london.org.uk/SC-PYZE-WEUQ-JSC4-MDZ5"},"incomingProperty":{"type":"uri","value":"http://www.cidoc-crm.org/crmdig/L21_used_as_derivation_source"},"relatedSubjectType":{"type":"uri","value":"http://www.cidoc-crm.org/crmdig/D3_Formal_Derivation"}},{"thing":{"type":"uri","value":"https://data.ng-london.org.uk/SC-B8NM-SCKN-4HJK-XEQH"},"outgoingProperty":{"type":"uri","value":"http://www.cidoc-crm.org/cidoc-crm/P62_depicts"},"relatedObject":{"type":"uri","value":"https://data.ng-london.org.uk/SC-RPR4-FG9N-VDEV-W9CT"},"relatedSubject":{"type":"uri","value":"https://data.ng-london.org.uk/SC-GC4A-IRU0-RS9L-YSOJ"},"incomingProperty":{"type":"uri","value":"http://www.cidoc-crm.org/crmdig/L22_created_derivative"},"relatedSubjectType":{"type":"uri","value":"http://www.cidoc-crm.org/crmdig/D3_Formal_Derivation"}},{"thing":{"type":"uri","value":"https://data.ng-london.org.uk/SC-B8NM-SCKN-4HJK-XEQH"},"outgoingProperty":{"type":"uri","value":"http://www.cidoc-crm.org/cidoc-crm/P62_depicts"},"relatedObject":{"type":"uri","value":"https://data.ng-london.org.uk/SC-RPR4-FG9N-VDEV-W9CT"},"relatedSubject":{"type":"uri","value":"https://data.ng-london.org.uk/SC-PYZE-WEUQ-JSC4-MDZ5"},"incomingProperty":{"type":"uri","value":"http://www.cidoc-crm.org/crmdig/L21_used_as_derivation_source"},"relatedSubjectType":{"type":"uri","value":"http://www.cidoc-crm.org/crmdig/D3_Formal_Derivation"}},{"thing":{"type":"uri","value":"https://data.ng-london.org.uk/SC-B8NM-SCKN-4HJK-XEQH"},"outgoingProperty":{"type":"uri","value":"http://www.cidoc-crm.org/cidoc-crm/P65_shows_visual_item"},"relatedObject":{"type":"uri","value":"https://data.ng-london.org.uk/SC-LXQQ-CNQN-FKTQ-R8S5"},"relatedObjectType":{"type":"uri","value":"http://www.cidoc-crm.org/cidoc-crm/E36_Visual_Item"},"relatedSubject":{"type":"uri","value":"https://data.ng-london.org.uk/SC-GC4A-IRU0-RS9L-YSOJ"},"incomingProperty":{"type":"uri","value":"http://www.cidoc-crm.org/crmdig/L22_created_derivative"},"relatedSubjectType":{"type":"uri","value":"http://www.cidoc-crm.org/crmdig/D3_Formal_Derivation"}},{"thing":{"type":"uri","value":"https://data.ng-london.org.uk/SC-B8NM-SCKN-4HJK-XEQH"},"outgoingProperty":{"type":"uri","value":"http://www.cidoc-crm.org/cidoc-crm/P65_shows_visual_item"},"relatedObject":{"type":"uri","value":"https://data.ng-london.org.uk/SC-LXQQ-CNQN-FKTQ-R8S5"},"relatedObjectType":{"type":"uri","value":"http://www.cidoc-crm.org/cidoc-crm/E36_Visual_Item"},"relatedSubject":{"type":"uri","value":"https://data.ng-london.org.uk/SC-PYZE-WEUQ-JSC4-MDZ5"},"incomingProperty":{"type":"uri","value":"http://www.cidoc-crm.org/crmdig/L21_used_as_derivation_source"},"relatedSubjectType":{"type":"uri","value":"http://www.cidoc-crm.org/crmdig/D3_Formal_Derivation"}},{"thing":{"type":"uri","value":"https://data.ng-london.org.uk/SC-B8NM-SCKN-4HJK-XEQH"},"outgoingProperty":{"type":"uri","value":"http://www.cidoc-crm.org/cidoc-crm/P70i_is_documented_in"},"relatedObject":{"type":"uri","value":"https://research.ng-london.org.uk/iiif/pics/tmp/raphael_pyr/2010/05/12/16_30a_head_of_St_Peter_IRR_det-PYR.tif/info.json"},"relatedObjectLabel":{"xml:lang":"en","type":"literal","value":"https://research.ng-london.org.uk/iiif/pics/tmp/raphael_pyr/2010/05/12/16_30a_head_of_St_Peter_IRR_det-PYR.tif/info.json"},"relatedObjectType":{"type":"uri","value":"http://www.cidoc-crm.org/cidoc-crm/E31_Document"},"relatedSubject":{"type":"uri","value":"https://data.ng-london.org.uk/SC-GC4A-IRU0-RS9L-YSOJ"},"incomingProperty":{"type":"uri","value":"http://www.cidoc-crm.org/crmdig/L22_created_derivative"},"relatedSubjectType":{"type":"uri","value":"http://www.cidoc-crm.org/crmdig/D3_Formal_Derivation"}},{"thing":{"type":"uri","value":"https://data.ng-london.org.uk/SC-B8NM-SCKN-4HJK-XEQH"},"outgoingProperty":{"type":"uri","value":"http://www.cidoc-crm.org/cidoc-crm/P70i_is_documented_in"},"relatedObject":{"type":"uri","value":"https://research.ng-london.org.uk/iiif/pics/tmp/raphael_pyr/2010/05/12/16_30a_head_of_St_Peter_IRR_det-PYR.tif/info.json"},"relatedObjectLabel":{"xml:lang":"en","type":"literal","value":"https://research.ng-london.org.uk/iiif/pics/tmp/raphael_pyr/2010/05/12/16_30a_head_of_St_Peter_IRR_det-PYR.tif/info.json"},"relatedObjectType":{"type":"uri","value":"http://www.cidoc-crm.org/cidoc-crm/E31_Document"},"relatedSubject":{"type":"uri","value":"https://data.ng-london.org.uk/SC-PYZE-WEUQ-JSC4-MDZ5"},"incomingProperty":{"type":"uri","value":"http://www.cidoc-crm.org/crmdig/L21_used_as_derivation_source"},"relatedSubjectType":{"type":"uri","value":"http://www.cidoc-crm.org/crmdig/D3_Formal_Derivation"}},{"thing":{"type":"uri","value":"https://data.ng-london.org.uk/SC-B8NM-SCKN-4HJK-XEQH"},"outgoingProperty":{"type":"uri","value":"http://www.cidoc-crm.org/cidoc-crm/P70i_is_documented_in"},"relatedObject":{"type":"uri","value":"https://research.ng-london.org.uk/iiif/pics/tmp/raphael_pyr/2010/05/12/16_30a_head_of_St_Peter_IRR_det-PYR.tif/info.json"},"relatedObjectLabel":{"xml:lang":"en","type":"literal","value":"https://research.ng-london.org.uk/iiif/pics/tmp/raphael_pyr/2010/05/12/16_30a_head_of_St_Peter_IRR_det-PYR.tif/info.json"},"relatedObjectType":{"type":"uri","value":"http://www.wikidata.org/entity/Q62087795"},"relatedSubject":{"type":"uri","value":"https://data.ng-london.org.uk/SC-GC4A-IRU0-RS9L-YSOJ"},"incomingProperty":{"type":"uri","value":"http://www.cidoc-crm.org/crmdig/L22_created_derivative"},"relatedSubjectType":{"type":"uri","value":"http://www.cidoc-crm.org/crmdig/D3_Formal_Derivation"}},{"thing":{"type":"uri","value":"https://data.ng-london.org.uk/SC-B8NM-SCKN-4HJK-XEQH"},"outgoingProperty":{"type":"uri","value":"http://www.cidoc-crm.org/cidoc-crm/P70i_is_documented_in"},"relatedObject":{"type":"uri","value":"https://research.ng-london.org.uk/iiif/pics/tmp/raphael_pyr/2010/05/12/16_30a_head_of_St_Peter_IRR_det-PYR.tif/info.json"},"relatedObjectLabel":{"xml:lang":"en","type":"literal","value":"https://research.ng-london.org.uk/iiif/pics/tmp/raphael_pyr/2010/05/12/16_30a_head_of_St_Peter_IRR_det-PYR.tif/info.json"},"relatedObjectType":{"type":"uri","value":"http://www.wikidata.org/entity/Q62087795"},"relatedSubject":{"type":"uri","value":"https://data.ng-london.org.uk/SC-PYZE-WEUQ-JSC4-MDZ5"},"incomingProperty":{"type":"uri","value":"http://www.cidoc-crm.org/crmdig/L21_used_as_derivation_source"},"relatedSubjectType":{"type":"uri","value":"http://www.cidoc-crm.org/crmdig/D3_Formal_Derivation"}},{"thing":{"type":"uri","value":"https://data.ng-london.org.uk/SC-B8NM-SCKN-4HJK-XEQH"},"outgoingProperty":{"type":"uri","value":"http://www.cidoc-crm.org/cidoc-crm/P43_has_dimension"},"relatedObject":{"type":"bnode","value":"t63218"},"relatedObjectLabel":{"type":"literal","value":"Number of pyramidal levels"},"relatedObjectType":{"type":"uri","value":"http://www.cidoc-crm.org/cidoc-crm/E54_Dimension"},"relatedSubject":{"type":"uri","value":"https://data.ng-london.org.uk/SC-GC4A-IRU0-RS9L-YSOJ"},"incomingProperty":{"type":"uri","value":"http://www.cidoc-crm.org/crmdig/L22_created_derivative"},"relatedSubjectType":{"type":"uri","value":"http://www.cidoc-crm.org/crmdig/D3_Formal_Derivation"}},{"thing":{"type":"uri","value":"https://data.ng-london.org.uk/SC-B8NM-SCKN-4HJK-XEQH"},"outgoingProperty":{"type":"uri","value":"http://www.cidoc-crm.org/cidoc-crm/P43_has_dimension"},"relatedObject":{"type":"bnode","value":"t63218"},"relatedObjectLabel":{"type":"literal","value":"Number of pyramidal levels"},"relatedObjectType":{"type":"uri","value":"http://www.cidoc-crm.org/cidoc-crm/E54_Dimension"},"relatedSubject":{"type":"uri","value":"https://data.ng-london.org.uk/SC-PYZE-WEUQ-JSC4-MDZ5"},"incomingProperty":{"type":"uri","value":"http://www.cidoc-crm.org/crmdig/L21_used_as_derivation_source"},"relatedSubjectType":{"type":"uri","value":"http://www.cidoc-crm.org/crmdig/D3_Formal_Derivation"}},{"thing":{"type":"uri","value":"https://data.ng-london.org.uk/SC-B8NM-SCKN-4HJK-XEQH"},"outgoingProperty":{"type":"uri","value":"http://www.cidoc-crm.org/cidoc-crm/P149_is_identified_by"},"relatedObject":{"type":"bnode","value":"t63850"},"relatedObjectLabel":{"xml:lang":"en","type":"literal","value":"pics/tmp/raphael_pyr/2010/05/12/16_30a_head_of_St_Peter_IRR_det-PYR.tif"},"relatedObjectType":{"type":"uri","value":"http://www.cidoc-crm.org/cidoc-crm/E42_Identifier"},"relatedSubject":{"type":"uri","value":"https://data.ng-london.org.uk/SC-GC4A-IRU0-RS9L-YSOJ"},"incomingProperty":{"type":"uri","value":"http://www.cidoc-crm.org/crmdig/L22_created_derivative"},"relatedSubjectType":{"type":"uri","value":"http://www.cidoc-crm.org/crmdig/D3_Formal_Derivation"}},{"thing":{"type":"uri","value":"https://data.ng-london.org.uk/SC-B8NM-SCKN-4HJK-XEQH"},"outgoingProperty":{"type":"uri","value":"http://www.cidoc-crm.org/cidoc-crm/P149_is_identified_by"},"relatedObject":{"type":"bnode","value":"t63850"},"relatedObjectLabel":{"xml:lang":"en","type":"literal","value":"pics/tmp/raphael_pyr/2010/05/12/16_30a_head_of_St_Peter_IRR_det-PYR.tif"},"relatedObjectType":{"type":"uri","value":"http://www.cidoc-crm.org/cidoc-crm/E42_Identifier"},"relatedSubject":{"type":"uri","value":"https://data.ng-london.org.uk/SC-PYZE-WEUQ-JSC4-MDZ5"},"incomingProperty":{"type":"uri","value":"http://www.cidoc-crm.org/crmdig/L21_used_as_derivation_source"},"relatedSubjectType":{"type":"uri","value":"http://www.cidoc-crm.org/crmdig/D3_Formal_Derivation"}},{"thing":{"type":"uri","value":"https://data.ng-london.org.uk/SC-B8NM-SCKN-4HJK-XEQH"},"outgoingProperty":{"type":"uri","value":"http://www.cidoc-crm.org/cidoc-crm/P149_is_identified_by"},"relatedObject":{"type":"bnode","value":"t63850"},"relatedObjectLabel":{"xml:lang":"en","type":"literal","value":"pics/tmp/raphael_pyr/2010/05/12/16_30a_head_of_St_Peter_IRR_det-PYR.tif"},"relatedObjectType":{"type":"uri","value":"http://www.wikidata.org/entity/Q1144928"},"relatedObjectTypeLabel":{"xml:lang":"en","type":"literal","value":"filename"},"relatedSubject":{"type":"uri","value":"https://data.ng-london.org.uk/SC-GC4A-IRU0-RS9L-YSOJ"},"incomingProperty":{"type":"uri","value":"http://www.cidoc-crm.org/crmdig/L22_created_derivative"},"relatedSubjectType":{"type":"uri","value":"http://www.cidoc-crm.org/crmdig/D3_Formal_Derivation"}},{"thing":{"type":"uri","value":"https://data.ng-london.org.uk/SC-B8NM-SCKN-4HJK-XEQH"},"outgoingProperty":{"type":"uri","value":"http://www.cidoc-crm.org/cidoc-crm/P149_is_identified_by"},"relatedObject":{"type":"bnode","value":"t63850"},"relatedObjectLabel":{"xml:lang":"en","type":"literal","value":"pics/tmp/raphael_pyr/2010/05/12/16_30a_head_of_St_Peter_IRR_det-PYR.tif"},"relatedObjectType":{"type":"uri","value":"http://www.wikidata.org/entity/Q1144928"},"relatedObjectTypeLabel":{"xml:lang":"en","type":"literal","value":"filename"},"relatedSubject":{"type":"uri","value":"https://data.ng-london.org.uk/SC-PYZE-WEUQ-JSC4-MDZ5"},"incomingProperty":{"type":"uri","value":"http://www.cidoc-crm.org/crmdig/L21_used_as_derivation_source"},"relatedSubjectType":{"type":"uri","value":"http://www.cidoc-crm.org/crmdig/D3_Formal_Derivation"}}]

Issues in providing Open Data in Heritage Science

This site presents access to two example Heritage Science data sets that have been mapped to the CIDOC-CRM ontology and a few of the the related CIDOC models. They have both been formatted as RDF XML and uploaded to an open instance of the Blazegraph Triple Store, hosted on one of the National Galleries public research servers. SPARQL queries can be submitted using the GUI provided or direct queries can be submitted to the end-points using URLs with the following format:

https://END-POINT-URL?format=json&query=FULLESCAPEDSPARQLQUERY

A series of example SPARQL queries are presented, for data set one, to document how the datasets are organised and the various relationships that have been mapped to the CIDOC CRM. A simple default query is also presented, for both of the data sets, to allow new bespoke queries to be created. The queries pages are organised into two main sections; the SPARQL query on the left and the results, formatted as JSON, presented on the right. Three additional interaction options are also provided through the small icons in the upper right:

- Re-format the results and present the defined relationships as a graphic model (see below).
- A shareable link for the current query presentation webpage - including bespoke queries.
- A direct shareable link to a simple json version of the results of the current query - including bespoke queries.

Website Code:

GitHub

Data set 1: The Raphael Research Resource

In 2007 the Raphael Research Resource project began to examine how complex conservation, scientific and art historical research could be combined in a flexible digital form. Exploring the presentation of interrelated high resolution images and text, along with how the data could be stored in relation to an event driven ontology in the form of RDF triples. The original main user interface is still live and the data stored within the system is presented here in the form of open linkable data combined with a SPARQL end-point.

End-point:	https://rdf.ng-london.org.uk/bg/bigdata/sparql/namespace/sshoc-raphael
Classes:	36	Properties:	69
Entities:	40915	Triples:	414401
Ontologies:	CIDOC CRM, CRM Dig, CRM Sci	Full XML:	DOI
Mapping Code:	GitHub	Original GUI:	Link

Data set 2: The Grounds Database

In 2018 the IPERION-CH Grounds Database was presented to examine how the data produced through the scientific examination of historic painting preparation or grounds samples, from multiple institutions could be combined in a flexible digital form. Exploring the presentation of interrelated high resolution images, text, complex metadata and procedural documentation. The original main user interface is live, though password protected at this time, and the data stored within the system is presented here in the form of open linkable data combined with a SPARQL end-point.

End-point:	https://rdf.ng-london.org.uk/bg/bigdata/sparql/namespace/sshoc-grounds
Classes:	60	Properties:	78
Entities:	41197	Triples:	474470
Ontologies:	CIDOC CRM, CRM Dig, CRM Sci	Full XML:	DOI
Mapping Code:	GitHub	Original GUI:	Link

Data set 3: The SMK Grounds Database (Not searchable here)

The work carried out within T5.6 of SSHOC also provided technical support for the production of a new open version of the Grounds Database, with all of its content made re-usable under a defined creative-commons licences. A generous grant from The Samuel H. Kress Foundation for the project "The digitization of cross-sections from Italian and Dutch paintings" at The National Gallery of Denmark (SMK) enabled the digitization and analyses of cross-sections from a total of 158 Italian 14th to 17th C. and 17th C. Dutch paintings from the SMK collection to be made available in this open access art and technology research database on ground layers. With samples from the collections of Nationalmuseum Stockholm and Museum of National History, Frederiksborg Castle in Hillerød the database includes an additional 11 paintings. Effort within the SSHOC project re-formatted the provided data and enabled it to be presented within the IPERION-CH Grounds Database GUI. Further work was also carried out to open up this data to non specialists, allowing access to the same images via a simple keyword search option, though a Simple IIIF Discovery site, the development of which was supported by the AHRC funded Practical IIIF project, the SSHOC project and the H2020 IPERION HS project.

IIIF Discovery End-point:	https://research.ng-london.org.uk/smk/
Full Website:	Link	Simple IIIF Discovery Website:	Link
Simple IIIF Discovery Code:	GitHub

The Dynamic Modeller

Initially in response to restrictions imposed by COVID-19 a live, online, dynamic, modelling system was developed to facilitate the collaborative development of semantic models and flow diagrams within SSHOC, but also within other related research projects such as the Linked.Art project and the H2020 IPERION HS research project. This is an interactive modelling system which can automatically convert simple tab separated triples or JSON-LD into graphical models using the mermaid library. To improve the accessibility and understanding of these presented data sets the output of each of the SPARQL queries, including bespoke queries, can be automatically formatted and modelled using the dynamic modeller. This can be achieved by clicking on the small "eye" icon in the upper right corer of any of the SPARQL query pages.

Full Website:

Link

Website Code:

GitHub