Linked Conservation Data Example

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.

Simple display example: Find main details for a given painting

Artist: Raphael
Artist dates: 1483 - 1520
Full title:Portrait of Pope Julius II
Date made: 1511
Medium and support: Drying Oil on Poplar Panel
Dimensions: 108.70 x 81.00 cm
Inventory number: NG27
Location in Gallery: Room 8
URI: NG27
NG Website: NG27

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 
  ?Painting ?Label ?Location ?Medium ?Support 
  ?Height ?Width ?Collection ?Title ?sTitle 
  ?Artist ?Date ?Thumbnail ?Curator 

WHERE { 
  ?Painting rdf:type rro:RC12.Painting; 
    rro:RP10.has_current_location ?Location; 
    rro:RP72.was_produced ?Production; 
    rdfs:label ?Label; 
    rro:RP99.is_part_of ?Collection; 
    rro:RP231I.has_the_display_image ?dim .
  Optional { ?Painting rro:RP9.has_curator  ?Curator . }.
  Optional { ?Painting rro:RP20.has_medium ?Medium . }.
  Optional { ?Painting rro:RP32.has_support ?Support . }.
  Optional { ?Painting rro:RP36.has_width_in_cm ?Width . }.
  Optional { ?Painting rro:RP16.has_height_in_cm ?Height . }.
  Optional { ?Painting rro:RP34.has_title ?Title . }.
  Optional { ?Painting rro:RP31.has_short_title ?sTitle . }.
  ?dim rro:RP259.has_thumbnail ?Thumbnail .
  ?Production rro:RP43.was_carried_out_by ?Artist;  
  Optional { ?Production rro:RP209.has_time-span ?Date . }.
  FILTER ( ?Painting = rri:NG27 ) . }";
$r = selectQuery ($q, true);
$r = $r[0];
$tb = imgUrl ($r["Thumbnail"]);
$arr = selectQuery ($q, true); 
$r = $arr[0];
$p = $r["Painting"];
$tb = imgUrl ($r["Thumbnail"]["value"]);
$r["Label"] = $r["Label"]["value"];
echo htmlHeader (); 
echo <<<END

<table id="qtable" class="qresults"><tr>
  <td width="150px">
    <img src="$tb" width="150px" alt="Thumbnail for $r[Label]" title="Thumbnail for $r[Label]"/>
  </td>
  <td><ul>
END;

$ar = getArtist ($r["Artist"]["value"]);
echoLabel ("Artist", $r["Artist"]["value"]);
 
echo "<li><font class=\"red\">Artist dates:</font> ".
	$ar["birth"]["value"]." - ". $ar["death"]["value"]."</li>";
    
echo "<li><font class=\"red\">Full title:</font>".$r["Title"]["value"]."</li>";
echoLabel ("Date made", $r["Date"]["value"]);
					
$ms = "";
$tr = getInfo ($r["Medium"]["value"], "rdfs:label");
$ms .= $tr . " on ";
$tr = getInfo ($r["Support"]["value"], "rdfs:label");
$ms .= $tr;
echo "<li><font class=\"red\">Medium and support:</font> $ms</li>".
	"<li><font class=\"red\">Dimensions:</font> ".
	$r["Height"]["value"]." x ".$r["Width"]["value"]." cm</li>".
	"<li><font class=\"red\">Inventory number:</font> $r[Label]</li>";
echoLabel ("Location in Gallery", $r["Location"]["value"]);
echo "<li><font class=\"red\">URI:</font> <a href=\"".
	"$r[Painting]\">$r[Label]</a></li>".
	"<li><font class=\"red\">NG Website:</font> <a href=\"".
	"http://www.nationalgallery.org.uk/goto/painting.ashx?ID=".
	"$r[Label]\">$r[Label]</a></li>".
	"</ul></td></tr></table></td></tr></table>";

?>

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