{"id":1892,"date":"2017-03-24T18:00:40","date_gmt":"2017-03-24T18:00:40","guid":{"rendered":"http:\/\/www.mollieecheverria.com\/?p=1892"},"modified":"2017-04-01T20:23:25","modified_gmt":"2017-04-01T20:23:25","slug":"march-24-2017","status":"publish","type":"post","link":"https:\/\/www.mollieecheverria.com\/?p=1892","title":{"rendered":"March 24, 2017"},"content":{"rendered":"<div class='booster-block booster-read-block'>\n                <div class=\"twp-read-time\">\n                \t<i class=\"booster-icon twp-clock\"><\/i> <span>Read Time:<\/span>2 Minute, 31 Second                <\/div>\n\n            <\/div><h3>Status of the Project as of March 24th<\/h3>\n<p>I am currently in the process of exploring three tools:<\/p>\n<ul>\n<li>OpenRefine, specifically name reconciliation and the RDF plugin<\/li>\n<li>Karma<\/li>\n<li>Gephi<\/li>\n<\/ul>\n<p>My current challenges and end goals:<\/p>\n<ul>\n<li>OpenRefine\n<ul>\n<li>I have been used OpenRefine to clean up ingest data.<\/li>\n<li>I am also using it for name entity reconciliation, and have successfully reconciled names to Wikidata, VIAF, and LCSH.<\/li>\n<li>My end goal, besides the normalization, would be to figure out how to reconcile names in the Whitney\u2019s collection to other art museums with SPARQL endpoints, such as the Smithsonian American Art Museum.<\/li>\n<\/ul>\n<\/li>\n<li>Karma\n<ul>\n<li>I have been exploring Karma as a tool for mapping the Whitney\u2019s Data to the CIDOC CRM.<\/li>\n<li>OpenRefine can be used for mapping as well, and is somewhat easier to use than Karma, but it has limited options for RDF export (those being RDF\/XML and and Turtle).<\/li>\n<li>Karma supports the export of JSON-LD. My end goal would be to export the Whitney\u2019s data mapped to CIDOC in this format.<\/li>\n<li>Have tried to work with CSV data in Karma, I\u2019m currently creating a MySQL database with my Whitney spreadsheets to see if this is a more effective intake format.<\/li>\n<li>If successful, this could serve as a model for ingesting the Whitney\u2019s data directly from TMS into Karma in the future.<\/li>\n<\/ul>\n<\/li>\n<li>Gephi\n<ul>\n<li>Having discovered that sections of the Getty Provenance Index and the Carnegie Museum of Art\u2019s collection provenance are both available on GitHub as CSV files, I am currently starting to explore Gephi, in the hopes of using it to create a visualization of the overlap between these provenance sources and the Whitney Founding collection, using Molly Reese-Lerner &amp; Hannah Sistrunk\u2019s project (<a href=\"http:\/\/pfch.nyc\/linked_jazz_meets_carnegie_hall\/index.html\">http:\/\/pfch.nyc\/linked_jazz_meets_carnegie_hall\/index.html<\/a>) \u00a0in the Programming for Cultural Heritage class as a model.<\/li>\n<li>I have been experimenting with working with CSV data in Gephi, but have found that I would need to create RDF files first to connect the datasets<\/li>\n<\/ul>\n<\/li>\n<li>Tableau\n<ul>\n<li>As Gephi is rather technical, I started working with the Whitney, Getty, and Carnegie datasets in Tableau.<\/li>\n<li>Tableau maybe be a good visualization tool, but I\u2019ve realized I need to do more normalization work before using it.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3 class=\"c22\"><span class=\"c24 c13 c1\">OpenRefine<\/span><\/h3>\n<p><span class=\"c2\">I\u2019ve decided to try cleaning up the Carnegie and Getty data in OpenRefine and to try reconciling some of the names in it.<\/span><\/p>\n<p>I\u2019m starting with the Carnegie\u2019s Baring art sales data (<span class=\"c4\"><a class=\"c18\" href=\"https:\/\/github.com\/arttracks\/baring_art_sales\">https:\/\/github.com\/arttracks\/baring_art_sales<\/a><\/span><span class=\"c2\">) , which is kind of a mess. The seller and artwork of these pieces are both in one column, for instance, which is not very helpful for provenance. The names of the actual sellers are also often pretty vague (\u201cSir Addington\u201d, etc).<\/span><\/p>\n<p><span class=\"c2\">In reconciling the Getty provenance data, I learned that Wikidata links to a bunch of institutional URIs for artists, including the Smithsonian and British Museum!<\/span><\/p>\n<p><span class=\"c4\"><a class=\"c18\" href=\"https:\/\/www.wikidata.org\/wiki\/Q704868\">https:\/\/www.wikidata.org\/wiki\/Q704868<\/a><\/span><\/p>\n<h3 class=\"c22\"><span class=\"c24 c13 c1\">Karma<\/span><\/h3>\n<p><span class=\"c2\">After some difficulty, I\u2019m finally getting the hang of mapping with Karma.<\/span><\/p>\n        <div class=\"booster-block booster-reactions-block\">\n            <div class=\"twp-reactions-icons\">\n                \n                <div class=\"twp-reacts-wrap\">\n                    <a react-data=\"be-react-1\" post-id=\"1892\" class=\"be-face-icons un-reacted\" href=\"javascript:void(0)\">\n                        <img decoding=\"async\" src=\"https:\/\/www.mollieecheverria.com\/wp-content\/plugins\/booster-extension\/\/assets\/icon\/happy.svg\" alt=\"Happy\">\n                    <\/a>\n                    <div class=\"twp-reaction-title\">\n                        Happy                    <\/div>\n                    <div class=\"twp-count-percent\">\n                                                    <span style=\"display: none;\" class=\"twp-react-count\">0<\/span>\n                        \n                                                <span class=\"twp-react-percent\"><span>0<\/span> %<\/span>\n                                            <\/div>\n                <\/div>\n\n                <div class=\"twp-reacts-wrap\">\n                    <a react-data=\"be-react-2\" post-id=\"1892\" class=\"be-face-icons un-reacted\" href=\"javascript:void(0)\">\n                        <img decoding=\"async\" src=\"https:\/\/www.mollieecheverria.com\/wp-content\/plugins\/booster-extension\/\/assets\/icon\/sad.svg\" alt=\"Sad\">\n                    <\/a>\n                    <div class=\"twp-reaction-title\">\n                        Sad                    <\/div>\n                    <div class=\"twp-count-percent\">\n                                                    <span style=\"display: none;\" class=\"twp-react-count\">0<\/span>\n                                                                        <span class=\"twp-react-percent\"><span>0<\/span> %<\/span>\n                                            <\/div>\n                <\/div>\n\n                <div class=\"twp-reacts-wrap\">\n                    <a react-data=\"be-react-3\" post-id=\"1892\" class=\"be-face-icons un-reacted\" href=\"javascript:void(0)\">\n                        <img decoding=\"async\" src=\"https:\/\/www.mollieecheverria.com\/wp-content\/plugins\/booster-extension\/\/assets\/icon\/excited.svg\" alt=\"Excited\">\n                    <\/a>\n                    <div class=\"twp-reaction-title\">\n                        Excited                    <\/div>\n                    <div class=\"twp-count-percent\">\n                                                    <span style=\"display: none;\" class=\"twp-react-count\">0<\/span>\n                                                                        <span class=\"twp-react-percent\"><span>0<\/span> %<\/span>\n                                            <\/div>\n                <\/div>\n\n                <div class=\"twp-reacts-wrap\">\n                    <a react-data=\"be-react-6\" post-id=\"1892\" class=\"be-face-icons un-reacted\" href=\"javascript:void(0)\">\n                        <img decoding=\"async\" src=\"https:\/\/www.mollieecheverria.com\/wp-content\/plugins\/booster-extension\/\/assets\/icon\/sleepy.svg\" alt=\"Sleepy\">\n                    <\/a>\n                    <div class=\"twp-reaction-title\">\n                        Sleepy                    <\/div>\n                    <div class=\"twp-count-percent\">\n                                                    <span style=\"display: none;\" class=\"twp-react-count\">0<\/span>\n                        \n                                                <span class=\"twp-react-percent\"><span>0<\/span> %<\/span>\n                                            <\/div>\n                <\/div>\n\n                <div class=\"twp-reacts-wrap\">\n                    <a react-data=\"be-react-4\" post-id=\"1892\" class=\"be-face-icons un-reacted\" href=\"javascript:void(0)\">\n                        <img decoding=\"async\" src=\"https:\/\/www.mollieecheverria.com\/wp-content\/plugins\/booster-extension\/\/assets\/icon\/angry.svg\" alt=\"Angry\">\n                    <\/a>\n                    <div class=\"twp-reaction-title\">Angry<\/div>\n                    <div class=\"twp-count-percent\">\n                                                    <span style=\"display: none;\" class=\"twp-react-count\">0<\/span>\n                                                                        <span class=\"twp-react-percent\"><span>0<\/span> %<\/span>\n                        \n                    <\/div>\n                <\/div>\n\n                <div class=\"twp-reacts-wrap\">\n                    <a react-data=\"be-react-5\" post-id=\"1892\" class=\"be-face-icons un-reacted\" href=\"javascript:void(0)\">\n                        <img decoding=\"async\" src=\"https:\/\/www.mollieecheverria.com\/wp-content\/plugins\/booster-extension\/\/assets\/icon\/surprise.svg\" alt=\"Surprise\">\n                    <\/a>\n                    <div class=\"twp-reaction-title\">Surprise<\/div>\n                    <div class=\"twp-count-percent\">\n                                                    <span style=\"display: none;\" class=\"twp-react-count\">0<\/span>\n                                                                        <span class=\"twp-react-percent\"><span>0<\/span> %<\/span>\n                                            <\/div>\n                <\/div>\n\n            <\/div>\n        <\/div>\n\n    ","protected":false},"excerpt":{"rendered":"<p>Status of the Project as of March 24th I am currently in the process of exploring three tools: OpenRefine, specifically name reconciliation and the RDF plugin Karma Gephi My current challenges and end goals: OpenRefine I have been used OpenRefine to clean up ingest data. I am also using it for name entity reconciliation, and [&hellip;]<\/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-1892","post","type-post","status-publish","format-standard","hentry","category-whitney-journal"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Mollie 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=1892\" \/>\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=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1892#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1892\"},\"author\":{\"name\":\"amanda\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/#\\\/schema\\\/person\\\/12cc1a68de4ed401b88418f813f45084\"},\"headline\":\"March 24, 2017\",\"datePublished\":\"2017-03-24T18:00:40+00:00\",\"dateModified\":\"2017-04-01T20:23:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1892\"},\"wordCount\":503,\"articleSection\":[\"Whitney Linked Open Data Fellowship Journal\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1892\",\"url\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1892\",\"name\":\"Mollie Echeverr\u00eda\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/#website\"},\"datePublished\":\"2017-03-24T18:00:40+00:00\",\"dateModified\":\"2017-04-01T20:23:25+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/#\\\/schema\\\/person\\\/12cc1a68de4ed401b88418f813f45084\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1892\"]}]},{\"@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=1892","twitter_misc":{"Written by":"amanda","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.mollieecheverria.com\/?p=1892#article","isPartOf":{"@id":"https:\/\/www.mollieecheverria.com\/?p=1892"},"author":{"name":"amanda","@id":"https:\/\/www.mollieecheverria.com\/#\/schema\/person\/12cc1a68de4ed401b88418f813f45084"},"headline":"March 24, 2017","datePublished":"2017-03-24T18:00:40+00:00","dateModified":"2017-04-01T20:23:25+00:00","mainEntityOfPage":{"@id":"https:\/\/www.mollieecheverria.com\/?p=1892"},"wordCount":503,"articleSection":["Whitney Linked Open Data Fellowship Journal"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.mollieecheverria.com\/?p=1892","url":"https:\/\/www.mollieecheverria.com\/?p=1892","name":"Mollie Echeverr\u00eda","isPartOf":{"@id":"https:\/\/www.mollieecheverria.com\/#website"},"datePublished":"2017-03-24T18:00:40+00:00","dateModified":"2017-04-01T20:23:25+00:00","author":{"@id":"https:\/\/www.mollieecheverria.com\/#\/schema\/person\/12cc1a68de4ed401b88418f813f45084"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mollieecheverria.com\/?p=1892"]}]},{"@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\/1892","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=1892"}],"version-history":[{"count":4,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/posts\/1892\/revisions"}],"predecessor-version":[{"id":1990,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/posts\/1892\/revisions\/1990"}],"wp:attachment":[{"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1892"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1892"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1892"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}