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. In addition to the main user interface the data stored within the system is now also accessible in the the form of open linkable data combined with a SPARQL end-point at https://rdf.ng-london.org.uk/rrr/sparql.

This example will introduce the information which is currently available within this resource and some of the web-base tools that have been developed to disseminate it.

This process will be based on but not necessarily limited too:
  • How to perform basic SPARQL queries.
  • Using PHP to collect and format the results of basic SPARQL queries.
  • Using existing IIPImage javascript libraries to present high resolution images.
  • Using PHP and HTML to combine the formatted results and images into simple web-pages.
This example is intended as a basic introduction to these particular resources and some of the techniques currently being used to exploit them. The resources will remain publicly available for those who wish to continue to work with them. However, this system should be considered as experimental and may be subject to periods of down time. An archive of the code used to create this example presentation can be found here.

More recently (2019) this example was refreshed as part of the work carried out in relation to the AHRC funded Linked Conservation Data project.
Complex query example: Find details for a given digital text
SPARQL Query Query Results

Soft limit 
Array
(
    [0] => Array
        (
            [text] => Array
                (
                    [type] => uri
                    [value] => https://rdf.ng-london.org.uk/raphael/resource/Hofmann_Provenance_2008_NG1171_Part_II
                )

            [id] => Array
                (
                    [xml:lang] => en
                    [type] => literal
                    [value] => Hofmann_Provenance_2008_NG1171_Part_II
                )

            [title] => Array
                (
                    [xml:lang] => en
                    [type] => literal
                    [value] => M. Hofmann, ‘The Provenance of the Altarpiece of San Fiorenzo in Perugia. Part II: The Separated Main Panel (NG1171)’, The Mellon Digital Documentation Project, 2008.
                )

            [label] => Array
                (
                    [xml:lang] => en
                    [type] => literal
                    [value] => Hofmann_Provenance_2008_NG1171_Part_II
                )

            [child] => Array
                (
                    [type] => uri
                    [value] => https://rdf.ng-london.org.uk/raphael/resource/Hofmann_Provenance_2008_NG1171_Part_II_0001
                )

        )

    [1] => Array
        (
            [text] => Array
                (
                    [type] => uri
                    [value] => https://rdf.ng-london.org.uk/raphael/resource/Hofmann_Provenance_2008_NG1171_Part_II
                )

            [id] => Array
                (
                    [xml:lang] => en
                    [type] => literal
                    [value] => Hofmann_Provenance_2008_NG1171_Part_II
                )

            [title] => Array
                (
                    [xml:lang] => en
                    [type] => literal
                    [value] => M. Hofmann, ‘The Provenance of the Altarpiece of San Fiorenzo in Perugia. Part II: The Separated Main Panel (NG1171)’, The Mellon Digital Documentation Project, 2008.
                )

            [label] => Array
                (
                    [xml:lang] => en
                    [type] => literal
                    [value] => Hofmann_Provenance_2008_NG1171_Part_II
                )

            [child] => Array
                (
                    [type] => uri
                    [value] => https://rdf.ng-london.org.uk/raphael/resource/Hofmann_Provenance_2008_NG1171_Part_II_0002
                )

        )

    [2] => Array
        (
            [text] => Array
                (
                    [type] => uri
                    [value] => https://rdf.ng-london.org.uk/raphael/resource/Hofmann_Provenance_2008_NG1171_Part_II
                )

            [id] => Array
                (
                    [xml:lang] => en
                    [type] => literal
                    [value] => Hofmann_Provenance_2008_NG1171_Part_II
                )

            [title] => Array
                (
                    [xml:lang] => en
                    [type] => literal
                    [value] => M. Hofmann, ‘The Provenance of the Altarpiece of San Fiorenzo in Perugia. Part II: The Separated Main Panel (NG1171)’, The Mellon Digital Documentation Project, 2008.
                )

            [label] => Array
                (
                    [xml:lang] => en
                    [type] => literal
                    [value] => Hofmann_Provenance_2008_NG1171_Part_II
                )

            [child] => Array
                (
                    [type] => uri
                    [value] => https://rdf.ng-london.org.uk/raphael/resource/Hofmann_Provenance_2008_NG1171_Part_II_0004
                )

        )

    [3] => Array
        (
            [text] => Array
                (
                    [type] => uri
                    [value] => https://rdf.ng-london.org.uk/raphael/resource/Hofmann_Provenance_2008_NG1171_Part_II
                )

            [id] => Array
                (
                    [xml:lang] => en
                    [type] => literal
                    [value] => Hofmann_Provenance_2008_NG1171_Part_II
                )

            [title] => Array
                (
                    [xml:lang] => en
                    [type] => literal
                    [value] => M. Hofmann, ‘The Provenance of the Altarpiece of San Fiorenzo in Perugia. Part II: The Separated Main Panel (NG1171)’, The Mellon Digital Documentation Project, 2008.
                )

            [label] => Array
                (
                    [xml:lang] => en
                    [type] => literal
                    [value] => Hofmann_Provenance_2008_NG1171_Part_II
                )

            [child] => Array
                (
                    [type] => uri
                    [value] => https://rdf.ng-london.org.uk/raphael/resource/Hofmann_Provenance_2008_NG1171_Part_II_0007
                )

        )

    [4] => Array
        (
            [text] => Array
                (
                    [type] => uri
                    [value] => https://rdf.ng-london.org.uk/raphael/resource/Hofmann_Provenance_2008_NG1171_Part_II
                )

            [id] => Array
                (
                    [xml:lang] => en
                    [type] => literal
                    [value] => Hofmann_Provenance_2008_NG1171_Part_II
                )

            [title] => Array
                (
                    [xml:lang] => en
                    [type] => literal
                    [value] => M. Hofmann, ‘The Provenance of the Altarpiece of San Fiorenzo in Perugia. Part II: The Separated Main Panel (NG1171)’, The Mellon Digital Documentation Project, 2008.
                )

            [label] => Array
                (
                    [xml:lang] => en
                    [type] => literal
                    [value] => Hofmann_Provenance_2008_NG1171_Part_II
                )

            [child] => Array
                (
                    [type] => uri
                    [value] => https://rdf.ng-london.org.uk/raphael/resource/Hofmann_Provenance_2008_NG1171_Part_II_0015
                )

        )

)

Simplified PHP Code
<?php

require_once ("header.php");
setGlobals();

$q = "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/rdfs/cidoc_crm_v5.0.2_english_label.rdfs#>
PREFIX rro:<https://rdf.ng-london.org.uk/raphael/ontology/>
PREFIX rri:<https://rdf.ng-london.org.uk/raphael/resource/>

SELECT 
  ?text ?id ?title ?label 
  ?im ?thumb ?caption ?child

WHERE { 
  ?text rro:RP17.has_identifier ?id ;
    rro:RP34.has_title ?title ;
    rdfs:label ?label ;
    rdf:type rro:RC220.Digital_Text .
  Optional { 
    ?text rro:RP40.is_related_to ?im .
    ?im rdf:type rro:RC25.Image ;
      rro:RP259.has_thumbnail ?thumb ;
      rro:RP233.has_caption ?caption . }.
  Optional { 
    ?child rro:RP99.is_part_of ?text ;
      rdf:type rro:RC220.Digital_Text . }.  
  FILTER ( ?text = rri:Hofmann_Provenance_2008_NG1171_Part_II ) . }";

$r = selectQuery($q, true);

echo "<pre>";
print_r ($r);
echo "</pre>";

?>

This site was developed by: Joseph Padfield, The National Gallery Scientific Department.