{"id":1823,"date":"2016-12-12T18:00:40","date_gmt":"2016-12-12T18:00:40","guid":{"rendered":"http:\/\/www.mollieecheverria.com\/?p=1823"},"modified":"2017-05-07T22:05:39","modified_gmt":"2017-05-07T22:05:39","slug":"december-12-2016","status":"publish","type":"post","link":"https:\/\/www.mollieecheverria.com\/?p=1823","title":{"rendered":"December 12, 2016"},"content":{"rendered":"
\n
\n \t<\/i> Read Time:<\/span>6 Minute, 25 Second <\/div>\n\n <\/div>

Drawings of the Florentine Painters<\/em> Project and Whitney Model<\/h3>\n

After reading more on Drawings of the Florentine Painters<\/a><\/em>, I think the project offers a very concise model for how to proceed with the Whitney\u2019s linked data in the spring.<\/p>\n

While I was originally thinking to just use CIDOC entities and properties plus Art and Architecture Thesaurus controlled terms, I can see now that incorporating ULAN\/VIAF authority files into the Whitney model would be beneficial, particularly given that CIDOC only has a namespace page for its properties rather than URIs.<\/p>\n

After querying Wikidata for my project in Programming for Cultural Heritage, I don\u2019t think it would be a good name authority source for the Whitney. During my early exploration of<\/p>\n

Acquisition-related names related to the Whitney Founding, I found that even some of the most obscure early 20th century art dealers had VIAF or LCSH files, whereas I doubt Wikidata would have much information on these constituents.<\/p>\n

Geonames would also be a good source for place names.<\/p>\n

Rough Outline of Work for Spring<\/h3>\n

My work in Spring will be roughly structured around how Alex Provo et al. have described their process in their soon-to-be-published write-up on the Drawings of the Florentine Painters project.<\/p>\n

Data Preparation: Now – Jan 21st, 2017<\/h4>\n

I first need to combine all of my and Joshua\u2019s data into three main CSV files, constituents, objects, and events. This can be done with Google Sheets.<\/p>\n

I might also need to query TMS for some additional constituent data.<\/p>\n

Data Processing: Jan 21st – Feb 4th, 2017<\/h4>\n

I would then use OpenRefine and possibly Python to handle any discrepancies in the data (splitting, cleaning, merging, etc).<\/p>\n

I could either keep this data in CSV files or import it into a MySQL database. A relational database might be easier to manage and append, and might also be more useful for representing relationships, but could take time to build.<\/p>\n

Data Modeling Refinement\/Extension: Feb 4th – 11th, 2017<\/h4>\n

I might refine the Whitney model based on the data at this point. The Florentine Renaissance Painters project experimented with incorporating equivalent properties from other ontologies like Dublin Core along with CIDOC, although this idea was ultimately scrapped. I\u2019m taking Metadata: Description and Access\u00a0in the Spring, so I may have a better sense of whether to include other schemas and what other schemas to incorporate by February.<\/p>\n

Defining the Conceptual Model in 3M: Feb 11th – March 4th, 2017<\/h4>\n

The Florentine Renaissance Painters project used two applications to map its tabular data onto CIDOC: Mapping Memory Manager (3M)\u00a0and Karma<\/p>\n

3M\u00a0(http:\/\/139.91.183.3\/3M\/FirstPage<\/a>):<\/p>\n

3M (which unfortunately has kind of a buggy website), is a web-based tool for managing mapping definition files.<\/p>\n

This document (http:\/\/83.212.168.219\/DariahCrete\/sites\/default\/files\/mapping_manual_version_4g.pdf<\/a>) has more details on how to use 3M.<\/p>\n

The aforementioned PDF also contains mentions this hierarchical representation of CIDOC in Standford\u2019s Web Proteg\u00e9, which is a useful representation of CIDOC classes ranked from general to specific: http:\/\/webprotege.stanford.edu\/#Edit:projectId=6fe69ce8-94b9-4624-bfe6-43af7c6d0fe3<\/a><\/p>\n

\"\"<\/a><\/p>\n

3M is built specifically for CIDOC mappings. As my model for the Whitney is based on CIDOC, I can use the site to map the Whitney\u2019s linked data.<\/p>\n

\"\"<\/a><\/p>\n

3M has over 500 different mappings hosted at present, primarily CIDOC-based. These include mappings of LIDO and Dublin Core onto CIDOC, models based on internal relational database content, and even what looks like someone\u2019s attempt to map the TMS eMuseums module:<\/p>\n

\"\"<\/a><\/p>\n

Schemas are uploaded as XML. You can also export other people\u2019s data mappings, see detailed comparisons of different mappings of the same source schema, and view detailed analysis of your schema:<\/p>\n

\"\"<\/a>\"\"<\/a><\/p>\n

To plug in the Whitney\u2019s data, I would first need a source schema in XML form. This would be sourced from the TMS fields in whatever tabular data I have. I\u2019m still a little unclear on how to do this; Alexandra apparently used a Python script to convert the column names in her tabular data to XML. 3M has an XML schema called X3ML that it provides as template for source schemas, so I could also probably just manually plug fields into this template. The documentation for 3M also explains how to use joins to convert relational database source data to a usable XML source schema.<\/p>\n

3M also requires a URI policy generator XML file, which it uses to create URIs associated with whatever domain the source schema is hosted on (\/whitney\/collection\/object\/23928, etc).<\/p>\n

Once these two files are uploaded to 3M, I can use the site\u2019s interface to associate each TMS field with a CIDOC class or property. 3M can also validate your mapping and suggest other class and entity mappings.<\/p>\n

The final mapping (or Target Record) can then be exported from 3M as RDF\/XML, N-Triples, or Turtle.<\/p>\n

Mapping Whitney TMS Data to Classes and Properties: March 4th – 25th, 2017<\/h4>\n

Karma\u00a0(http:\/\/usc-isi-i2.github.io\/karma\/<\/a>)<\/p>\n

Karma is a data integration tool that can be used for database data, spreadsheets, XML, and JSON. Karma automates the process of adding URIs to this data and mapping it to an ontology.<\/p>\n

This document (http:\/\/www.isi.edu\/~szekely\/contents\/papers\/2013\/eswc-2013-saam.pdf<\/a>) details its use in greater detail.<\/p>\n

I would start by preparing the Whitney\u2019s tabular data for import into Karma, either directly from a CSV file, or from a SQL database if I choose to use one. Depending on what storage format I choose, I would either concatenate columns in MySQL or use OpenRefine.<\/p>\n

\"\"<\/a><\/p>\n

Karma is a desktop app that runs something like MySQL Workbench. You work with and manage data locally, but this can later be hosted on an external server.<\/p>\n

\"\"<\/a><\/p>\n

Karma can also run using data from a hosted SQL database. If I choose to store my initial data in a SQL database, I could opt to host this on the internal Whitney server Joshua used this past year and access Karma through there.<\/p>\n

I would then use Karma to map the various columns of data onto classes from the CIDOC mapping I refined in 3M.<\/p>\n

Data Enrichment: March 25th – April 15th, 2017<\/h4>\n

Karma also integrates the ability to link data to external resources.<\/p>\n

VIAF\/LCSH\/ULAN: For Acquisition-related constituents. Joshua already used ULAN for Object-related constituents, but it might be worth enriching his data with VIAF\/LCSH data as well.<\/p>\n

Geonames: For places related to events\/constituents<\/p>\n

DBpedia\/Wikidata: I don\u2019t know how many of the Whitney\u2019s non-artist constituents (in particular Acquisition-related constituents) would have records on these sites, but they might be worth investigating if time permits.<\/p>\n

Data from Other Museums (The Smithsonian, British Museum, etc): This actually might be the most important enrichment data to include. One of the main goals of implementing linked open data at the Whitney would be to enable the sharing of resources with other art-related cultural institutions, so this integration is key.<\/p>\n

Data Publishing: April 15th – 29th, 2017<\/h4>\n

Once all the data is prepared, it can then be hosted in some kind of graph database.<\/p>\n

Drawings of the Florentine Painters is using Metaphacts (http:\/\/www.metaphacts.com\/<\/a>), which seems like an attractive solution.<\/p>\n

This would either be hosted on the Whitney server, or possibly on the server of whatever company I use.<\/p>\n

Visualization(s) and Incorporating Images: April 29th – May 13th, 2017<\/h4>\n

Time permitting, I will create some kind of visualization project with the Whitney\u2019s data using Gephi\/Tableau.<\/p>\n

I \u00a0could also try to incorporate image content from TMS\/the main Whitney Collection page in some way.<\/p>\n

\n
\n \n
\n \n \"Happy\"\n <\/a>\n
\n Happy <\/div>\n
\n 0<\/span>\n \n 0<\/span> %<\/span>\n <\/div>\n <\/div>\n\n
\n \n \"Sad\"\n <\/a>\n
\n Sad <\/div>\n
\n 0<\/span>\n 0<\/span> %<\/span>\n <\/div>\n <\/div>\n\n
\n \n \"Excited\"\n <\/a>\n
\n Excited <\/div>\n
\n 0<\/span>\n 0<\/span> %<\/span>\n <\/div>\n <\/div>\n\n
\n \n \"Sleepy\"\n <\/a>\n
\n Sleepy <\/div>\n
\n 0<\/span>\n \n 0<\/span> %<\/span>\n <\/div>\n <\/div>\n\n
\n \n \"Angry\"\n <\/a>\n
Angry<\/div>\n
\n 0<\/span>\n 0<\/span> %<\/span>\n \n <\/div>\n <\/div>\n\n
\n \n \"Surprise\"\n <\/a>\n
Surprise<\/div>\n
\n 0<\/span>\n 0<\/span> %<\/span>\n <\/div>\n <\/div>\n\n <\/div>\n <\/div>\n\n ","protected":false},"excerpt":{"rendered":"

Drawings of the Florentine Painters Project and Whitney Model After reading more on Drawings of the Florentine Painters, I think the project offers a very concise model for how to proceed with the Whitney\u2019s linked data in the spring. While I was originally thinking to just use CIDOC entities and properties plus Art and Architecture […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1823","post","type-post","status-publish","format-standard","hentry","category-whitney-journal"],"yoast_head":"\nMollie Echeverr\u00eda<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.mollieecheverria.com\/?p=1823\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"amanda\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1823#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1823\"},\"author\":{\"name\":\"amanda\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/#\\\/schema\\\/person\\\/12cc1a68de4ed401b88418f813f45084\"},\"headline\":\"December 12, 2016\",\"datePublished\":\"2016-12-12T18:00:40+00:00\",\"dateModified\":\"2017-05-07T22:05:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1823\"},\"wordCount\":1266,\"image\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1823#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mollieecheverria.com\\\/wp-content\\\/uploads\\\/2017\\\/04\\\/image22-785x529.png\",\"articleSection\":[\"Whitney Linked Open Data Fellowship Journal\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1823\",\"url\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1823\",\"name\":\"Mollie Echeverr\u00eda\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1823#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1823#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mollieecheverria.com\\\/wp-content\\\/uploads\\\/2017\\\/04\\\/image22-785x529.png\",\"datePublished\":\"2016-12-12T18:00:40+00:00\",\"dateModified\":\"2017-05-07T22:05:39+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/#\\\/schema\\\/person\\\/12cc1a68de4ed401b88418f813f45084\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1823\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1823#primaryimage\",\"url\":\"https:\\\/\\\/www.mollieecheverria.com\\\/wp-content\\\/uploads\\\/2017\\\/04\\\/image22.png\",\"contentUrl\":\"https:\\\/\\\/www.mollieecheverria.com\\\/wp-content\\\/uploads\\\/2017\\\/04\\\/image22.png\",\"width\":1999,\"height\":1346},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/#website\",\"url\":\"https:\\\/\\\/www.mollieecheverria.com\\\/\",\"name\":\"Mollie Echeverr\u00eda\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/#\\\/schema\\\/person\\\/12cc1a68de4ed401b88418f813f45084\",\"name\":\"amanda\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/933d63347db0a4d6741d3684945d79bd61634cc6a5094794faf3a30fe7f432df?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/933d63347db0a4d6741d3684945d79bd61634cc6a5094794faf3a30fe7f432df?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/933d63347db0a4d6741d3684945d79bd61634cc6a5094794faf3a30fe7f432df?s=96&d=mm&r=g\",\"caption\":\"amanda\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/mollie.echeverria\",\"https:\\\/\\\/www.instagram.com\\\/mollie_echeverria\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/mollieecheverria\\\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Mollie Echeverr\u00eda","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.mollieecheverria.com\/?p=1823","twitter_misc":{"Written by":"amanda","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.mollieecheverria.com\/?p=1823#article","isPartOf":{"@id":"https:\/\/www.mollieecheverria.com\/?p=1823"},"author":{"name":"amanda","@id":"https:\/\/www.mollieecheverria.com\/#\/schema\/person\/12cc1a68de4ed401b88418f813f45084"},"headline":"December 12, 2016","datePublished":"2016-12-12T18:00:40+00:00","dateModified":"2017-05-07T22:05:39+00:00","mainEntityOfPage":{"@id":"https:\/\/www.mollieecheverria.com\/?p=1823"},"wordCount":1266,"image":{"@id":"https:\/\/www.mollieecheverria.com\/?p=1823#primaryimage"},"thumbnailUrl":"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image22-785x529.png","articleSection":["Whitney Linked Open Data Fellowship Journal"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.mollieecheverria.com\/?p=1823","url":"https:\/\/www.mollieecheverria.com\/?p=1823","name":"Mollie Echeverr\u00eda","isPartOf":{"@id":"https:\/\/www.mollieecheverria.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.mollieecheverria.com\/?p=1823#primaryimage"},"image":{"@id":"https:\/\/www.mollieecheverria.com\/?p=1823#primaryimage"},"thumbnailUrl":"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image22-785x529.png","datePublished":"2016-12-12T18:00:40+00:00","dateModified":"2017-05-07T22:05:39+00:00","author":{"@id":"https:\/\/www.mollieecheverria.com\/#\/schema\/person\/12cc1a68de4ed401b88418f813f45084"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mollieecheverria.com\/?p=1823"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mollieecheverria.com\/?p=1823#primaryimage","url":"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image22.png","contentUrl":"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image22.png","width":1999,"height":1346},{"@type":"WebSite","@id":"https:\/\/www.mollieecheverria.com\/#website","url":"https:\/\/www.mollieecheverria.com\/","name":"Mollie Echeverr\u00eda","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.mollieecheverria.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.mollieecheverria.com\/#\/schema\/person\/12cc1a68de4ed401b88418f813f45084","name":"amanda","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/933d63347db0a4d6741d3684945d79bd61634cc6a5094794faf3a30fe7f432df?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/933d63347db0a4d6741d3684945d79bd61634cc6a5094794faf3a30fe7f432df?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/933d63347db0a4d6741d3684945d79bd61634cc6a5094794faf3a30fe7f432df?s=96&d=mm&r=g","caption":"amanda"},"sameAs":["https:\/\/www.facebook.com\/mollie.echeverria","https:\/\/www.instagram.com\/mollie_echeverria\/","https:\/\/www.linkedin.com\/in\/mollieecheverria\/"]}]}},"_links":{"self":[{"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/posts\/1823","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1823"}],"version-history":[{"count":4,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/posts\/1823\/revisions"}],"predecessor-version":[{"id":2176,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/posts\/1823\/revisions\/2176"}],"wp:attachment":[{"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1823"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1823"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1823"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}