{"id":8419,"date":"2023-05-01T19:00:44","date_gmt":"2023-05-01T19:00:44","guid":{"rendered":"https:\/\/studentwork.prattsi.org\/infoshow\/?p=8419"},"modified":"2023-05-10T18:25:37","modified_gmt":"2023-05-10T18:25:37","slug":"linked-open-data-fellowship-at-the-moma","status":"publish","type":"post","link":"https:\/\/studentwork.prattsi.org\/infoshow\/2023\/linked-open-data-fellowship-at-the-moma","title":{"rendered":"Linked Open Data:                           Uploading MoMA Artist and Exhibition Metadata to Wikidata"},"content":{"rendered":"\n<p class=\"has-text-align-center\">With Fellow Allysha A. Leonard<\/p>\n\n\n\n<p>You can view the presentation here.\u00a0<br><a href=\"https:\/\/docs.google.com\/presentation\/d\/1P4vVwc7MkNOYyXmy8GR2CzQDc0fsK6XH6wpiN4Om1Mg\/edit?usp=sharing\u00a0\">https:\/\/docs.google.com\/presentation\/d\/1P4vVwc7MkNOYyXmy8GR2CzQDc0fsK6XH6wpiN4Om1Mg\/edit?usp=sharing\u00a0<\/a><br>MS Graduation Portfolio<br><a href=\"https:\/\/allyshaaleonard.wixsite.com\/pratt-portfolio\">https:\/\/allyshaaleonard.wixsite.com\/pratt-portfolio<\/a><\/p>\n\n\n<p>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 The presentation will discuss the project I have been working on with Jonathan Lill for the Linked Open Data Fellowship at the Museum of Modern Art. It will discuss the use of digital tools such as OpenRefine and uploading shared data to the open source site Wikidata. <br \/>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <span style=\"font-weight: 400\">Linked open data is a concept of publishing and interlinking data on the internet in a way that is freely accessible, shareable, and machine-readable. It involves using standardized formats, such as Resource Description Framework (RDF), to create links between different data sets, enabling them to be easily combined and analyzed by computers. By using open standards and making data available in a standardized format, linked open data allows for greater interoperability and sharing of information across different systems and platforms. This results in a more connected and collaborative web of data, making it easier to discover, analyze, and reuse information for various purposes.<\/span><br \/>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0My specific job included adding all MoMA exhibited artists since its opening in 1929, and linking them to the already uploaded assets of the past exhibitions. This work is helpful for connecting different databases and sources such as the MoMA website URLS for both exhibition and artist, the Virtual International Authority File, Social Networks and Archival Context, Union List of Artist Names withe the Getty Institute, all to one accessible page that can be populated by Wiki editors to add background information. Part of this work includes setting a base schema for each asset, and using machine processing to upload the data in bulk.<\/p>\n<p>PROCESS<\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Step 1: OpenRefine &#8211; Artist Reconciliation<\/span><span style=\"font-weight: 400\"><br \/><\/span><b>&#8211; Download <\/b><span style=\"font-weight: 400\">XLSX of all artists and data from MoMA Microsoft Access and <\/span><b>Upload <\/b><span style=\"font-weight: 400\">into OpenRefine<br \/><\/span><span style=\"font-weight: 400\">&#8211; Separated projects by Individuals and Institutions since they have different schemas\u00a0<\/span><span style=\"font-weight: 400\"><br \/>&#8211; Reconcile artists Display Name and Identifiers with existing Wikidata pages<br \/><br \/><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Step 2: Artist and Institution Schema<br \/><\/span><span style=\"font-weight: 400\">&#8211;\u00a0 Create Schema for Artist Page using &#8220;instance of&#8221; (P31) &#8220;human&#8221; (Q5) for individuals<\/span><i><span style=\"font-weight: 400\"><br \/><\/span><\/i><em><span style=\"font-weight: 400\">Individual Inclusions:<\/span><\/em><span style=\"font-weight: 400\"> Date of Birth (P569), Date of Death (P570), Part of (P361), Museum of Modern Art artist ID (P2174), Union List of Artist Names ID (P245), VIAF ID (P214), SNAC ARK ID (P3430), <\/span><span style=\"font-weight: 400\">ADD REFERENCE URL (P854) for every provable statement<br \/>&#8211; Create Schema for Artist Page using &#8220;instance of&#8221; (P31) and &#8220;organization&#8221; (Q42339) for institutions<br \/><em>Institutions Inclusions<\/em>: Start Time (P580), End Time (P582), Location (P276), Museum of Modern Art artist ID (P2174), Union List of Artist Names ID (P245), VIAF ID (P214), SNAC ARK ID (P3430), ADD REFERENCE URL (P854) for every provable statement<br \/><br \/><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Step 3: Upload to Wikidata &#8211; QIDs<br \/>&#8211; Upload items to Wikibase &#8211; https:\/\/www.wikidata.org\/wiki\/Wikidata:Tools\/OpenRefine\/Editing\/Uploading <br \/>&#8211; Track Uploads via Edit Groups Tool Forge and User Contributions on Wikidata &#8211; Important for avoiding duplicate upload, too many QID\u2019s for one constituent<br \/>&#8211; Create a Spreadsheet with new and existing QIDs for artists by creating new QID column and export XLSX<br \/>&#8211; Combine exhibition data in Excel spreadsheet QIDs with artist QIDs using Exhibition_Constituents_Match table on Microsoft access &#8211; 50,890 Lines of Data<br \/>(QIDs will later be uploaded to MoMA TMS System)\u00a0<br \/><br \/><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Step 4: OpenRefine Schema: Linking Artist <\/span>and Exhibition<br \/>&#8211; Use a new project in Open-Refine to reconcile by QID for now existing artists and exhibition. Reconciliation should now take \u00bc the original time as all QID\u2019s are created and more easily matched<br \/>&#8211; Upload in multiple projects\/batches to assure correct tracking and quicker reconciliation <br \/>(18 projects with 2,000-3,000 lines of data were used in this case)<br \/>&#8211; Create a Schema for the Art Exhibition page using &#8220;Exhibited Creator&#8221; (P10661) for attaching reconciled artist names.<\/li>\n<\/ul>\n<p>\u00a0<\/p>","protected":false},"excerpt":{"rendered":"<p>With Fellow Allysha A. Leonard You can view the presentation here.\u00a0https:\/\/docs.google.com\/presentation\/d\/1P4vVwc7MkNOYyXmy8GR2CzQDc0fsK6XH6wpiN4Om1Mg\/edit?usp=sharing\u00a0MS Graduation Portfoliohttps:\/\/allyshaaleonard.wixsite.com\/pratt-portfolio \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 The presentation will discuss the&#8230;<\/p>\n","protected":false},"author":4057,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1036],"tags":[],"coauthors":[1042],"class_list":["post-8419","post","type-post","status-publish","format-standard","hentry","category-1036"],"_links":{"self":[{"href":"https:\/\/studentwork.prattsi.org\/infoshow\/wp-json\/wp\/v2\/posts\/8419","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/studentwork.prattsi.org\/infoshow\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/studentwork.prattsi.org\/infoshow\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infoshow\/wp-json\/wp\/v2\/users\/4057"}],"replies":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infoshow\/wp-json\/wp\/v2\/comments?post=8419"}],"version-history":[{"count":2,"href":"https:\/\/studentwork.prattsi.org\/infoshow\/wp-json\/wp\/v2\/posts\/8419\/revisions"}],"predecessor-version":[{"id":9074,"href":"https:\/\/studentwork.prattsi.org\/infoshow\/wp-json\/wp\/v2\/posts\/8419\/revisions\/9074"}],"wp:attachment":[{"href":"https:\/\/studentwork.prattsi.org\/infoshow\/wp-json\/wp\/v2\/media?parent=8419"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infoshow\/wp-json\/wp\/v2\/categories?post=8419"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infoshow\/wp-json\/wp\/v2\/tags?post=8419"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infoshow\/wp-json\/wp\/v2\/coauthors?post=8419"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}