Skip to content

Instantly share code, notes, and snippets.

@ewg118
Last active September 5, 2025 20:21
Show Gist options
  • Select an option

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

Select an option

Save ewg118/ef0e48b165cbc9b3f5540043a27979c4 to your computer and use it in GitHub Desktop.
Met Museum OpenRefine template
<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'].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 + '"/>', "")}}
{{if(cells["Shape Uncertain"].value != true, forNonBlank(cells["Shape 1 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, if(cells["Artist 1 Attribution"].value == "influenced_by", '<crm:P15_was_influenced_by rdf:resource="' + c.value + '"/>', '<crm:P14_carried_out_by rdf:resource="' + c.value + '"/>'), ""),
forNonBlank(cells["Artist 1 URI"], c, '<crm:P9_consists_of>
<crm:E12_Production>
' + if(cells["Artist 1 Attribution"].value == "influenced_by", '<crm:P15_was_influenced_by rdf:resource="' + c.value + '"/>', '<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>
' + if(cells["Artist 2 Attribution"].value == "influenced_by", '<crm:P15_was_influenced_by rdf:resource="' + c.value + '"/>', '<crm:P14_carried_out_by rdf:resource="' + c.value + '"/>') + '
</crm:E12_Production>
</crm:P9_consists_of>\n', "") +
forNonBlank(cells["Artist 3 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', "")), "")}}
{{if(cells["Production Place Uncertain"].value != true, forNonBlank(cells["Production Place URI"], c, '<crm:P7_took_place_at rdf:resource="' + c.value + '"/>', ""), "")}}
{{forNonBlank(cells["Technique URI"], c, '<crm:P32_used_general_technique rdf:resource="' + c.value + '"/>', "")}}
{{forNonBlank(cells["Object Begin 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["Object 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["Images"], c, forEach(c.value.split("|"), url, '<crm:P138i_has_representation>
<crm:E36_Visual_Item rdf:about="' + url + '">
<dcterms:format>image/jpeg</dcterms:format>
</crm:E36_Visual_Item>
</crm:P138i_has_representation>'), "")}}
<crm:P50_has_current_keeper rdf:resource="https://kerameikos.org/id/metmuseum"/>
<void:inDataset rdf:resource="https://www.metmuseum.org/"/>
</crm:E22_Man-Made_Object>
@ewg118
Copy link
Author

ewg118 commented Sep 4, 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