Skip to content

Instantly share code, notes, and snippets.

@ewg118
Created July 2, 2021 16:13
Show Gist options
  • Save ewg118/c474d751790c4c0d086fdce738bb74c6 to your computer and use it in GitHub Desktop.
Save ewg118/c474d751790c4c0d086fdce738bb74c6 to your computer and use it in GitHub Desktop.
OpenRefine template for Getty Museum vases
<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['name'].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 + '"/>', "")}}
{{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["Artist 1 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["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', "")), "")}}
{{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["begin"], 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"].value + '</crm:P82b_end_of_the_end>
</crm:E52_Time-Span>
</crm:P4_has_time-span>', "")}}
</crm:E12_Production>
</crm:P108i_was_produced_by>
{{forNonBlank(cells["height"], c, '<crm:P43_has_dimension>
<crm:E54_Dimension>
<crm:P90_has_value rdf:datatype="http://www.w3.org/2001/XMLSchema#decimal">' + c.value + '</crm:P90_has_value>
<crm:P2_has_type rdf:resource="http://vocab.getty.edu/aat/300055644"/>
<crm:P91_has_unit rdf:resource="http://vocab.getty.edu/aat/300379098"/>
</crm:E54_Dimension>
</crm:P43_has_dimension>', "")}}
{{forNonBlank(cells["width"], c, '<crm:P43_has_dimension>
<crm:E54_Dimension>
<crm:P90_has_value rdf:datatype="http://www.w3.org/2001/XMLSchema#decimal">' + c.value + '</crm:P90_has_value>
<crm:P2_has_type rdf:resource="http://vocab.getty.edu/aat/300055647"/>
<crm:P91_has_unit rdf:resource="http://vocab.getty.edu/aat/300379098"/>
</crm:E54_Dimension>
</crm:P43_has_dimension>', "")}}
{{forNonBlank(cells["diameter"], c, '<crm:P43_has_dimension>
<crm:E54_Dimension>
<crm:P90_has_value rdf:datatype="http://www.w3.org/2001/XMLSchema#decimal">' + c.value + '</crm:P90_has_value>
<crm:P2_has_type rdf:resource="http://vocab.getty.edu/aat/300055624"/>
<crm:P91_has_unit rdf:resource="http://vocab.getty.edu/aat/300379098"/>
</crm:E54_Dimension>
</crm:P43_has_dimension>', "")}}
{{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["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/2/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="http://kerameikos.org/id/getty_museum"/>
<void:inDataset rdf:resource="https://www.getty.edu/museum/"/>
</crm:E22_Man-Made_Object>
@ewg118
Copy link
Author

ewg118 commented Jul 2, 2021

Prefix:
<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="http://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