{"id":1844,"date":"2017-01-20T18:00:59","date_gmt":"2017-01-20T18:00:59","guid":{"rendered":"http:\/\/www.mollieecheverria.com\/?p=1844"},"modified":"2017-05-07T23:24:07","modified_gmt":"2017-05-07T23:24:07","slug":"january-20-2017","status":"publish","type":"post","link":"https:\/\/www.mollieecheverria.com\/?p=1844","title":{"rendered":"January 20, 2017"},"content":{"rendered":"
\n
\n \t<\/i> Read Time:<\/span>2 Minute, 2 Second <\/div>\n\n <\/div>

Meeting to Touch Base on the Project<\/h3>\n

At Cristina\u2019s suggestion, I used Doodle to try to schedule a meeting with everyone.<\/p>\n

She also suggested everyone could Skype rather than meeting in person. Given everyone\u2019s conflicting schedules, and that Prof. Pattuelli will be at the ARLIS Conference in New Orleans at the beginning of February, this may be a good solution.<\/p>\n

Data Cleaning and Normalization<\/h3>\n

My laptop, on which I\u2019ve been querying Python, and on which I have the OpenRefine desktop client installed, is unfortunately being repaired today, but I\u2019m planning to do some work on tabular data today.<\/p>\n

I\u2019m not sure if my user privileges on the Whitney\u2019s computers will enable me to install OpenRefine on my desktop computer here, but if nothing else I can work in Google Sheets.<\/p>\n

Unfortunately, it is looking like my work is going to be limited to Google Sheets today.<\/p>\n

Object\/Constituent Relations in Joshua\u2019s Database<\/h3>\n

Initially, I was a little confused how the two tables (Objects and Constituents) in Joshua\u2019s MySQL database were related to each other, as their SQL<\/a>\u00a0doesn\u2019t indicate any foreign keys. Constituent ID seems like it would be a natural foreign key in the Object table, for example.<\/p>\n

As it turns out, Joshua used a PHP script to create a join:<\/p>\n

<?php
\n$query = “SELECT objects.*, people.constituentID FROM `objects` JOIN people ON people.displayName = objects.Artist WHERE `objectID` =”.$objectID;
\n$result = $conn->query($query);
\nif (!$result) {
\ndie($conn->error);
\n} else {
\n$row = $result->fetch_assoc();
\n};
\n\/\/ print_r($row);
\n$name = $row[‘Title Sort’];
\n$creator = $row[‘Artist’];
\n$artform = $row[‘artform’];
\n$artMedium = $row[‘artMedium’];
\n$artworkSurface = $row[‘artworkSurface’];
\n$spatial = $row[‘Dimensions’];
\n$dateCreated = $row[‘Date’];
\n$accrualMethod = $row[‘Credit Line’];
\n$constituentID = $row[‘constituentID’];
\n?><\/p>\n

I\u2019m not really familiar with PHP, so I don\u2019t understand the rationale of doing this join with PHP versus making the tables relational with primary\/foreign keys in SQL.<\/p>\n

More on generating JSON from a MySQL database using PHP:<\/p>\n

http:\/\/www.kodingmadesimple.com\/2015\/01\/convert-mysql-to-json-using-php.html<\/a><\/p>\n

Indexing a Generated Column to Provide a JSON Column Index:<\/p>\n

https:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/create-table-secondary-indexes.html#json-column-indirect-index<\/a><\/p>\n

Summary Overview of using MySQL or PostgreSQL as a triple store:<\/p>\n

http:\/\/rdfextras.readthedocs.io\/en\/latest\/store\/mysqlpg.html<\/a><\/p>\n

One random note – I somehow didn\u2019t realize that PURL stands for Persistent uniform resource locator<\/a><\/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":"

Meeting to Touch Base on the Project At Cristina\u2019s suggestion, I used Doodle to try to schedule a meeting with everyone. She also suggested everyone could Skype rather than meeting in person. Given everyone\u2019s conflicting schedules, and that Prof. Pattuelli will be at the ARLIS Conference in New Orleans at the beginning of February, this […]<\/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-1844","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=1844\" \/>\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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1844#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1844\"},\"author\":{\"name\":\"amanda\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/#\\\/schema\\\/person\\\/12cc1a68de4ed401b88418f813f45084\"},\"headline\":\"January 20, 2017\",\"datePublished\":\"2017-01-20T18:00:59+00:00\",\"dateModified\":\"2017-05-07T23:24:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1844\"},\"wordCount\":395,\"articleSection\":[\"Whitney Linked Open Data Fellowship Journal\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1844\",\"url\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1844\",\"name\":\"Mollie Echeverr\u00eda\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/#website\"},\"datePublished\":\"2017-01-20T18:00:59+00:00\",\"dateModified\":\"2017-05-07T23:24:07+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/#\\\/schema\\\/person\\\/12cc1a68de4ed401b88418f813f45084\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1844\"]}]},{\"@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=1844","twitter_misc":{"Written by":"amanda","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.mollieecheverria.com\/?p=1844#article","isPartOf":{"@id":"https:\/\/www.mollieecheverria.com\/?p=1844"},"author":{"name":"amanda","@id":"https:\/\/www.mollieecheverria.com\/#\/schema\/person\/12cc1a68de4ed401b88418f813f45084"},"headline":"January 20, 2017","datePublished":"2017-01-20T18:00:59+00:00","dateModified":"2017-05-07T23:24:07+00:00","mainEntityOfPage":{"@id":"https:\/\/www.mollieecheverria.com\/?p=1844"},"wordCount":395,"articleSection":["Whitney Linked Open Data Fellowship Journal"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.mollieecheverria.com\/?p=1844","url":"https:\/\/www.mollieecheverria.com\/?p=1844","name":"Mollie Echeverr\u00eda","isPartOf":{"@id":"https:\/\/www.mollieecheverria.com\/#website"},"datePublished":"2017-01-20T18:00:59+00:00","dateModified":"2017-05-07T23:24:07+00:00","author":{"@id":"https:\/\/www.mollieecheverria.com\/#\/schema\/person\/12cc1a68de4ed401b88418f813f45084"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mollieecheverria.com\/?p=1844"]}]},{"@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\/1844","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=1844"}],"version-history":[{"count":2,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/posts\/1844\/revisions"}],"predecessor-version":[{"id":2183,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/posts\/1844\/revisions\/2183"}],"wp:attachment":[{"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1844"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1844"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1844"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}