Skip to content

Instantly share code, notes, and snippets.

@ewg118
Last active September 4, 2025 15:26
Show Gist options
  • Select an option

  • Save ewg118/23fd4fd8d95d753467d2edd69a088fc1 to your computer and use it in GitHub Desktop.

Select an option

Save ewg118/23fd4fd8d95d753467d2edd69a088fc1 to your computer and use it in GitHub Desktop.
Ashmolean OpenRefine RDF template for Kerameikos
<crm:E22_Man-Made_Object rdf:about="{{cells['URI'].value}}">
<crm:P1_is_identified_by>
<crm:E33_E41_Linguistic_Appellation>
<crm:P190_has_symbolic_content>{{cells['Title'].value}}</crm:P190_has_symbolic_content>
<crm:P2_has_type rdf:resource="http://vocab.getty.edu/aat/300404670"/>
</crm:E33_E41_Linguistic_Appellation>
</crm:P1_is_identified_by>
<crm:P1_is_identified_by>
<crm:E42_Identifier>
<crm:P190_has_symbolic_content>{{cells['Accession number'].value}}</crm:P190_has_symbolic_content>
<crm:P2_has_type rdf:resource="http://vocab.getty.edu/aat/300312355"/>
</crm:E42_Identifier>
</crm:P1_is_identified_by>
{{forNonBlank(cells["Material URI"], c, '<crm:P45_consists_of rdf:resource="' + c.value + '"/>', "")}}
{{forNonBlank(cells["Shape URI"], c, '<kon:hasShape rdf:resource="' + c.value + '"/>', "")}}
<crm:P108i_was_produced_by>
<crm:E12_Production>
{{if(cells["Artist Uncertain"].value != true,
if (cells["Artist 2 URI"].value == null, forNonBlank(cells["Artist 1 URI"], c, '<crm:P14_carried_out_by rdf:resource="' + c.value + '"/>', ""),
forNonBlank(cells["Painter URI"], c, '<crm:P9_consists_of>
<crm:E12_Production>
<crm:P14_carried_out_by rdf:resource="' + c.value + '"/>
</crm:E12_Production>
</crm:P9_consists_of>\n', "") +
forNonBlank(cells["Artist 2 URI"], c, '<crm:P9_consists_of>
<crm:E12_Production>
<crm:P14_carried_out_by rdf:resource="' + c.value + '"/>
</crm:E12_Production>
</crm:P9_consists_of>\n', "")), "")}}
{{forNonBlank(cells["Production Place URI"], c, '<crm:P7_took_place_at rdf:resource="' + c.value + '"/>', "")}}
{{forNonBlank(cells["Technique 1 URI"], c, '<crm:P32_used_general_technique rdf:resource="' + c.value + '"/>', "")}}
{{forNonBlank(cells["Technique 2 URI"], c, '<crm:P32_used_general_technique rdf:resource="' + c.value + '"/>', "")}}
{{forNonBlank(cells["Start Date"], c, '<crm:P4_has_time-span>
<crm:E52_Time-Span>
<crm:P82a_begin_of_the_begin rdf:datatype="http://www.w3.org/2001/XMLSchema#gYear">' + c.value + '</crm:P82a_begin_of_the_begin>
<crm:P82b_end_of_the_end rdf:datatype="http://www.w3.org/2001/XMLSchema#gYear">' + cells["End Date"].value + '</crm:P82b_end_of_the_end>
</crm:E52_Time-Span>
</crm:P4_has_time-span>', "")}}
{{forNonBlank(cells["Period 1 URI"], c, '<crm:P10_falls_within rdf:resource="' + c.value + '"/>', "")}}
{{forNonBlank(cells["Period 2 URI"], c, '<crm:P10_falls_within rdf:resource="' + c.value + '"/>', "")}}
</crm:E12_Production>
</crm:P108i_was_produced_by>
{{forNonBlank(cells["Findspot URI"], c, '<crmsci:O19i_was_object_found_by>
<crmsci:S19_Encounter_Event>
<crm:P7_took_place_at>
<crm:E53_Place>
<rdfs:label xml:lang="en">' + cells["Findspot Label"].value + '</rdfs:label>
<crm:P89_falls_within rdf:resource="' + c.value + '"/>
</crm:E53_Place>
</crm:P7_took_place_at>
</crmsci:S19_Encounter_Event>
</crmsci:O19i_was_object_found_by>', "")}}
{{forNonBlank(cells["Image URL"], c, '<crm:P138i_has_representation>
<crm:E36_Visual_Item rdf:about="' + c.value + '">
<dcterms:format>image/jpeg</dcterms:format>
</crm:E36_Visual_Item>
</crm:P138i_has_representation>', "")}}
{{forNonBlank(cells["IIIF Manifest"], c, '<crm:P129i_is_subject_of>
<crm:E73_Information_Object rdf:about="' + c.value + '">
<dcterms:format>application/ld+json;profile=&quot;http://iiif.io/api/presentation/3/context.json&quot;</dcterms:format>
<dcterms:conformsTo rdf:resource="http://iiif.io/api/presentation"/>
</crm:E73_Information_Object>
</crm:P129i_is_subject_of>', "")}}
<crm:P50_has_current_keeper rdf:resource="https://kerameikos.org/id/ashmolean"/>
<void:inDataset rdf:resource="https://www.ashmolean.org/"/>
</crm:E22_Man-Made_Object>
@ewg118
Copy link
Author

ewg118 commented Aug 22, 2025

Prefix (https URIs):

<?xml version="1.0" encoding="UTF-8"?> <rdf:RDF xmlns:xsd="http://www.w3.org/2001/XMLSchema#" xmlns:crm="http://www.cidoc-crm.org/cidoc-crm/" xmlns:crmgeo="http://www.ics.forth.gr/isl/CRMgeo/" xmlns:crmsci="http://www.ics.forth.gr/isl/CRMsci/" xmlns:kon="https://kerameikos.org/ontology#" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:foaf="http://xmlns.com/foaf/0.1/" xmlns:geo="http://www.w3.org/2003/01/geo/wgs84_pos#" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:rdfs="http://www.w3.org/2000/01/rdf-schema#" xmlns:skos="http://www.w3.org/2004/02/skos/core#" xmlns:void="http://rdfs.org/ns/void#">

Suffix:

`</rdf:RDF>

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment