{"id":1867,"date":"2017-02-24T18:00:52","date_gmt":"2017-02-24T18:00:52","guid":{"rendered":"http:\/\/www.mollieecheverria.com\/?p=1867"},"modified":"2017-05-08T00:23:38","modified_gmt":"2017-05-08T00:23:38","slug":"february-24-2017","status":"publish","type":"post","link":"https:\/\/www.mollieecheverria.com\/?p=1867","title":{"rendered":"February 24, 2017"},"content":{"rendered":"
\n
\n \t<\/i> Read Time:<\/span>3 Minute, 35 Second <\/div>\n\n <\/div>

Getty\u2019s Knoedler Dataset<\/h3>\n

I\u2019m thinking it might be interesting to compare the Getty\u2019s Knoedler dataset with the Whitney\u2019s. While none of the Whitney Founding Collection objects came from Knoedler, they were an influential 19th-early 20th century gallery, and sold to Gertrude Vanderbilt Whitney\u2019s father\/grandfather(?) Cornelius (http:\/\/www.artnews.com\/2016\/04\/25\/the-big-fake-behind-the-scenes-of-knoedler-gallerys-downfall\/<\/a>), among other influential robber barons of the time. I imagine there might be some overlap between artists or collectors in the two datasets, if nothing else.<\/p>\n

Strangely, a cursory search of TMS reveals that Knoedler Gallery has only one related object in the database (a Jasper Johns artist book, ID 84.52)<\/p>\n

The Getty\u2019s provenance resources also skew heavily towards pre-20th century sources (presumably due to copyright issues) and records from European auction houses.<\/p>\n

The Knoedler sales books do encompass the years the Whitney Founding Collection was amassed, as well as the decades before and after, so hopefully the Getty\u2019s Knoedler dataset has some kind of linkage with the Whitney\u2019s.<\/p>\n

As the readme in the Getty\u2019s Github repository notes, the Carnegie Museum also has their collection data available in both CSV and JSON format:<\/p>\n

https:\/\/github.com\/cmoa\/collection<\/a><\/p>\n

To go about connecting the Whitney\u2019s dataset to the Getty\u2019s and\/or Carnegie\u2019s, I would have to use a similar to what Hannah and Molly did for their Program for Cultural Heritage project:<\/p>\n

https:\/\/github.com\/MollieEcheverria\/CH-LJ\/blob\/master\/README.txt<\/a><\/p>\n

I might need to query for URIs for the Getty\/Carnegie names first.<\/p>\n

OpenRefine<\/h3>\n

Before I get into external datasets, I am going to start working with the Whitney\u2019s data using OpenRefine.<\/p>\n

I\u2019m using this book as a reference:<\/p>\n

Verborgh, R., De Wilde, M., & Sawant, A. (2013). Using OpenRefine : The Essential OpenRefine Guide That Takes You From Data Analysis and Error Fixing to Linking Your Dataset to the Web<\/em>.Birmingham, England: Packt Publishing. Retrieved fromhttp:\/\/search.ebscohost.com.ezproxy.pratt.edu:2048\/login.aspx?direct=true&db=nlebk&AN=639455&site=ehost-live&ebv=EK&ppid=Page-__-20<\/a><\/p>\n

A preliminary look at the RDF Refine extension for OpenRefine (http:\/\/refine.deri.ie\/<\/a>) is promising. I tried plugging in the BloodyBite CIDOC mapping namespace I think I mentioned previously (http:\/\/bloody-byte.net\/rdf\/cidoc-crm\/core_5.0.1#<\/a>) to get CIDOC classes\/properties:<\/p>\n

Sidenote: this namespace lookup resource looks helpful as well:<\/p>\n

http:\/\/prefix.cc\/<\/a><\/p>\n

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

The Erlangen OWL mapping used by the British Museum works well too:<\/p>\n

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

Since I have all the columns in my Google Sheets aligned with CIDOC properties, the RDF schema alignment process should hopefully be pretty easy.<\/p>\n

This plugin lets you identify entity nodes as well, so I could probably just simplify things and recombine all my separate sheets into one CSV file rather than having one sheet per entity:<\/p>\n

https:\/\/en.wikipedia.org\/wiki\/Node_(computer_science)<\/a><\/p>\n

https:\/\/en.wikipedia.org\/wiki\/Linked_data_structure<\/a><\/p>\n

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

OpenRefine also does Wikidata reconciliation!<\/p>\n

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

You can reconcile against SPARQL endpoints too! (https:\/\/github.com\/OpenRefine\/OpenRefine\/wiki\/Reconcilable-Data-Sources<\/a>)<\/p>\n

Adding name reconciliation sources: http:\/\/iphylo.blogspot.com\/2012\/02\/using-google-refine-and-taxonomic.html<\/a><\/p>\n

You can even generate RDF\/XML or Turtle files from OpenRefine (no JSON-LD, sadly)<\/p>\n

Publishing these RDF files on GitHub might be a simple preliminary way to share the Whitney\u2019s data<\/p>\n

Or, I could use something like this (https:\/\/github.com\/semsol\/arc2\/wiki<\/a>), though that might be again getting hung up on publication\/databases.<\/p>\n

It\u2019s a bit tricky in practice:<\/p>\n

http:\/\/networkedplanet.com\/blog\/2015\/07\/13\/turning-flat-data-into-semantic-data-with-open-refine-and-the-rdf-extension.html<\/a><\/p>\n

In working with OpenRefine, I realize all my spreadsheets are a little out of control in terms of granularity.<\/p>\n

Revised Project Plan<\/h3>\n

Recombine spreadsheets into three main sheets (Constituent, Object, Event)<\/p>\n

Do name reconciliation\/RDF schema layout stuff in OpenRefine<\/p>\n

Feed sheet into Gephi and make visualization.<\/p>\n

Also spit out some RDF\/XML files and make into an N-Triple\/JSON-LD<\/p>\n

http:\/\/rdf-translator.appspot.com\/<\/a><\/p>\n

Clean and reconcile Getty\/Carnegie data with OpenRefine too and try to make some connections.<\/p>\n

Make a Gephi visualization mapping the connections<\/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":"

Getty\u2019s Knoedler Dataset I\u2019m thinking it might be interesting to compare the Getty\u2019s Knoedler dataset with the Whitney\u2019s. While none of the Whitney Founding Collection objects came from Knoedler, they were an influential 19th-early 20th century gallery, and sold to Gertrude Vanderbilt Whitney\u2019s father\/grandfather(?) Cornelius (http:\/\/www.artnews.com\/2016\/04\/25\/the-big-fake-behind-the-scenes-of-knoedler-gallerys-downfall\/), among other influential robber barons of the time. I […]<\/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-1867","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=1867\" \/>\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=1867#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1867\"},\"author\":{\"name\":\"amanda\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/#\\\/schema\\\/person\\\/12cc1a68de4ed401b88418f813f45084\"},\"headline\":\"February 24, 2017\",\"datePublished\":\"2017-02-24T18:00:52+00:00\",\"dateModified\":\"2017-05-08T00:23:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1867\"},\"wordCount\":668,\"image\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1867#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mollieecheverria.com\\\/wp-content\\\/uploads\\\/2017\\\/04\\\/image19-785x464.png\",\"articleSection\":[\"Whitney Linked Open Data Fellowship Journal\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1867\",\"url\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1867\",\"name\":\"Mollie Echeverr\u00eda\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1867#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1867#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mollieecheverria.com\\\/wp-content\\\/uploads\\\/2017\\\/04\\\/image19-785x464.png\",\"datePublished\":\"2017-02-24T18:00:52+00:00\",\"dateModified\":\"2017-05-08T00:23:38+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/#\\\/schema\\\/person\\\/12cc1a68de4ed401b88418f813f45084\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1867\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1867#primaryimage\",\"url\":\"https:\\\/\\\/www.mollieecheverria.com\\\/wp-content\\\/uploads\\\/2017\\\/04\\\/image19.png\",\"contentUrl\":\"https:\\\/\\\/www.mollieecheverria.com\\\/wp-content\\\/uploads\\\/2017\\\/04\\\/image19.png\",\"width\":1999,\"height\":1182},{\"@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=1867","twitter_misc":{"Written by":"amanda","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.mollieecheverria.com\/?p=1867#article","isPartOf":{"@id":"https:\/\/www.mollieecheverria.com\/?p=1867"},"author":{"name":"amanda","@id":"https:\/\/www.mollieecheverria.com\/#\/schema\/person\/12cc1a68de4ed401b88418f813f45084"},"headline":"February 24, 2017","datePublished":"2017-02-24T18:00:52+00:00","dateModified":"2017-05-08T00:23:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.mollieecheverria.com\/?p=1867"},"wordCount":668,"image":{"@id":"https:\/\/www.mollieecheverria.com\/?p=1867#primaryimage"},"thumbnailUrl":"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image19-785x464.png","articleSection":["Whitney Linked Open Data Fellowship Journal"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.mollieecheverria.com\/?p=1867","url":"https:\/\/www.mollieecheverria.com\/?p=1867","name":"Mollie Echeverr\u00eda","isPartOf":{"@id":"https:\/\/www.mollieecheverria.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.mollieecheverria.com\/?p=1867#primaryimage"},"image":{"@id":"https:\/\/www.mollieecheverria.com\/?p=1867#primaryimage"},"thumbnailUrl":"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image19-785x464.png","datePublished":"2017-02-24T18:00:52+00:00","dateModified":"2017-05-08T00:23:38+00:00","author":{"@id":"https:\/\/www.mollieecheverria.com\/#\/schema\/person\/12cc1a68de4ed401b88418f813f45084"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mollieecheverria.com\/?p=1867"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mollieecheverria.com\/?p=1867#primaryimage","url":"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image19.png","contentUrl":"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image19.png","width":1999,"height":1182},{"@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\/1867","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=1867"}],"version-history":[{"count":4,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/posts\/1867\/revisions"}],"predecessor-version":[{"id":2196,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/posts\/1867\/revisions\/2196"}],"wp:attachment":[{"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1867"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1867"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1867"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}