{"id":8917,"date":"2018-04-05T11:13:03","date_gmt":"2018-04-05T15:13:03","guid":{"rendered":"http:\/\/studentwork.prattsi.org\/infovis\/?p=8917"},"modified":"2018-04-19T11:26:17","modified_gmt":"2018-04-19T15:26:17","slug":"remapping-hopper-theatre","status":"publish","type":"post","link":"https:\/\/studentwork.prattsi.org\/infovis\/labs\/remapping-hopper-theatre\/","title":{"rendered":"Remapping Hopper at the Theatre"},"content":{"rendered":"<h1><b>Introduction<\/b><\/h1>\n<p><span style=\"font-weight: 400\">This report explores categorical and geospatial data collected through the Linked Open Data (LOD) for Museums Fellowship offered by the Pratt Institute School of Information and the Whitney Museum of American Art and visualized using CARTO, a proprietary Software as a Service (SaaS) cloud based platform for GIS and web mapping. The goal of the resulting geovisualization is to explore some of the CARTO Builder basic features by <\/span><span style=\"font-weight: 400\">investigating the cultural and theatrical landscape of Edward Hopper\u2019s New York.<\/span><\/p>\n<h3><span style=\"text-decoration: underline\"><span style=\"font-weight: 400\">Background<\/span><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Leveraging the unparalleled collection of Hopper\u2019s art and archival materials held by the Whitney Museum of American Art, <\/span><i><span style=\"font-weight: 400\">Hopper at the Theatre<\/span><\/i><span style=\"font-weight: 400\"> contextualizes the artist\u2019s personal and professional geographies towards the end of the interwar period circa 1925 to 1937. The project targets primary source data for semantic enrichment from event ticket stubs in the newly established Sanborn Hopper Archive.<\/span><\/p>\n<h3><span style=\"text-decoration: underline\"><span style=\"font-weight: 400\">Inspiration<\/span><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Primary inspiration came from the original <\/span><i><span style=\"font-weight: 400\">Hopper at the Theatre <\/span><\/i><span style=\"font-weight: 400\">interactive geovisualization (Figure 1) built by the author using HTML, CSS, JavaScript, and Python. <\/span><a href=\"https:\/\/reganartinfo.github.io\/hopper\/\"><span style=\"font-weight: 400\">Launch the project<\/span><\/a><span style=\"font-weight: 400\"> or <\/span><a href=\"https:\/\/github.com\/reganartinfo\/hopper\"><span style=\"font-weight: 400\">view the code on GitHub<\/span><\/a><span style=\"font-weight: 400\">.<\/span><\/p>\n<div id=\"attachment_8925\" style=\"width: 840px\" class=\"wp-caption aligncenter\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-8925\" class=\"wp-image-8925 size-large\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/nyc-hopper.png?resize=840%2C663\" alt=\"\" width=\"840\" height=\"663\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/nyc-hopper.png?resize=1024%2C808&amp;ssl=1 1024w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/nyc-hopper.png?resize=300%2C237&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/nyc-hopper.png?resize=768%2C606&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/nyc-hopper.png?w=1440&amp;ssl=1 1440w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><p id=\"caption-attachment-8925\" class=\"wp-caption-text\"><b>Figure 1<\/b>. Screenshot of original <em>Hopper at the Theatre<\/em> map.<\/p><\/div>\n<p><span style=\"font-weight: 400\">NYC Public Art Map and Guide (Figure 2) informed the decision to use different colors to visualize the permanence or destruction of a building, while Andrea Geyer\u2019s artist map <\/span><i><span style=\"font-weight: 400\">Audrey Munson: This Site of Memory<\/span><\/i><span style=\"font-weight: 400\"> (2006) was a source of creativity for commemorating New York City cultural landmarks, albeit in analog form (Figure 3).<\/span><\/p>\n<div id=\"attachment_8926\" style=\"width: 775px\" class=\"wp-caption aligncenter\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-8926\" class=\"wp-image-8926 size-large\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/nyc-parks.png?resize=775%2C1024\" alt=\"\" width=\"775\" height=\"1024\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/nyc-parks.png?resize=775%2C1024&amp;ssl=1 775w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/nyc-parks.png?resize=227%2C300&amp;ssl=1 227w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/nyc-parks.png?resize=768%2C1015&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/nyc-parks.png?w=795&amp;ssl=1 795w\" sizes=\"auto, (max-width: 775px) 100vw, 775px\" \/><p id=\"caption-attachment-8926\" class=\"wp-caption-text\"><b>Figure 2<\/b>. Screenshot of NYC Public Art Map and Guide.<\/p><\/div>\n<div id=\"attachment_8929\" style=\"width: 796px\" class=\"wp-caption aligncenter\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-8929\" class=\"wp-image-8929 size-large\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/nyc-geyer.jpg?resize=796%2C1024\" alt=\"\" width=\"796\" height=\"1024\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/nyc-geyer.jpg?resize=796%2C1024&amp;ssl=1 796w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/nyc-geyer.jpg?resize=233%2C300&amp;ssl=1 233w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/nyc-geyer.jpg?resize=768%2C987&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/nyc-geyer.jpg?w=1512&amp;ssl=1 1512w\" sizes=\"auto, (max-width: 796px) 100vw, 796px\" \/><p id=\"caption-attachment-8929\" class=\"wp-caption-text\"><b>Figure 3<\/b>. <em>Audrey Munson: This Site of Memory<\/em> by Andrea Geyer.<\/p><\/div>\n<h1><b>Methodology<\/b><\/h1>\n<h3><span style=\"text-decoration: underline\"><span style=\"font-weight: 400\">Data Collection and Transformation<\/span><\/span><\/h3>\n<p><span style=\"font-weight: 400\">A detailed overview of the original data extraction and transformation process can be found <\/span><a href=\"https:\/\/eportfolio.pratt.edu\/user\/regan\/hopper-at-the-theatre\"><span style=\"font-weight: 400\">here<\/span><\/a><span style=\"font-weight: 400\">. To summarize, primary source metadata from ticket stubs of events attended by Edward Hopper was generously provided by the Whitney Museum of American Art Archives. After exporting the ticket dataset from <\/span><a href=\"http:\/\/archivesspace.org\/\"><span style=\"font-weight: 400\">ArchivesSpace<\/span><\/a><span style=\"font-weight: 400\"> and minimally normalizing it using <\/span><a href=\"http:\/\/openrefine.org\/\"><span style=\"font-weight: 400\">OpenRefine<\/span><\/a><span style=\"font-weight: 400\">, manual and automated data enrichment and integration was performed using the following sources:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><a href=\"https:\/\/github.com\/CarnegieHall\/linked-data\"><span style=\"font-weight: 400\">Carnegie Hall Archives Linked Data<\/span><\/a><\/li>\n<li style=\"font-weight: 400\"><a href=\"http:\/\/cinematreasures.org\/\"><span style=\"font-weight: 400\">Cinema Treasures<\/span><\/a><\/li>\n<li style=\"font-weight: 400\"><a href=\"https:\/\/developers.google.com\/maps\/documentation\/geocoding\/start\"><span style=\"font-weight: 400\">Google Maps Geocoding API<\/span><\/a><\/li>\n<li style=\"font-weight: 400\"><a href=\"https:\/\/www.ibdb.com\/\"><span style=\"font-weight: 400\">Internet Broadway Database<\/span><\/a><\/li>\n<li style=\"font-weight: 400\"><a href=\"https:\/\/www.imdb.com\/\"><span style=\"font-weight: 400\">Internet Movie Database<\/span><\/a><\/li>\n<li style=\"font-weight: 400\"><a href=\"https:\/\/en.wikipedia.org\/w\/api.php\"><span style=\"font-weight: 400\">MediaWiki API<\/span><\/a><\/li>\n<li style=\"font-weight: 400\"><a href=\"https:\/\/query.wikidata.org\/\"><span style=\"font-weight: 400\">Wikidat<\/span><span style=\"font-weight: 400\">a Query API<\/span><\/a><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">The final dataset was structured to support future Resource Description Framework (RDF) modeling serialized as JSON-LD and visualization with open-source JavaScript libraries like <\/span><a href=\"http:\/\/leafletjs.com\/\"><span style=\"font-weight: 400\">Leaflet<\/span><\/a><span style=\"font-weight: 400\"> and <\/span><a href=\"http:\/\/maps.stamen.com\/\"><span style=\"font-weight: 400\">Stamen Maps<\/span><\/a><span style=\"font-weight: 400\">. While the nested structure of the final dataset was appropriate for building the original geovisualization from scratch, there were technical difficulties navigating down through multiple JSON subproperties like individual ticket data or complex geocoding when using CARTO Builder. To optimize the dataset schema for CARTO, I wrote simple Python script (see: <\/span><a href=\"https:\/\/github.com\/reganartinfo\/hopper\/blob\/master\/carto.py\"><span style=\"font-weight: 400\">https:\/\/github.com\/reganartinfo\/hopper\/blob\/master\/carto.py<\/span><\/a><span style=\"font-weight: 400\">) to flatten the Google geocoding data, keeping only the latitude and longitude of the theaters and appending them to the top level of the JSON array.<\/span><\/p>\n<h3><span style=\"text-decoration: underline\"><span style=\"font-weight: 400\">Visualization Creation<\/span><\/span><\/h3>\n<p><span style=\"font-weight: 400\">After flattening the ticket dataset, I imported it to CARTO Builder to use as the primary map layer. CARTO Builder is an extremely intuitive web-based interface that allows users to create beautiful maps in minutes. It automatically transformed the dataset into a point map, which I further customized by enabling the pop-up feature to display columns such as venue name and address from the ticket dataset. Given that the Wikipedia abstracts for the venues had already been parsed to HTML during the original extraction and transformation process, embedded hyperlinks remained functional when included in the pop-ups.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u201cFilter by column\u201d analysis was applied to identify with venues\u2019 current lifecycle (e.g. closed, demolished, open) and added as a widget for users to interact with. The color palette for the filters was selected using <\/span><a href=\"https:\/\/chrome.google.com\/webstore\/detail\/eye-dropper\/hmdcmlfkchdmnmnmheododdhjedfccka?hl=en\"><span style=\"font-weight: 400\">Eye Dropper<\/span><\/a><span style=\"font-weight: 400\">, an open-source extension for Chrome, to pick colors from a digital image of <\/span><i><span style=\"font-weight: 400\">New York Movie <\/span><\/i><span style=\"font-weight: 400\">(1939) by Edward Hopper.<\/span><\/p>\n<h1><b>Results<\/b><\/h1>\n<p>[iframe src=&#8221;https:\/\/eganr.carto.com\/builder\/cefa661f-f3cb-4bf6-9788-13a3f08e9e54\/embed&#8221; width=&#8221;100%&#8221; height=&#8221;520&#8243;]<\/p>\n<h1><b>Future Directions<\/b><\/h1>\n<p><span style=\"font-weight: 400\">With more time and resources, the author envisions flattening more portions of the original ticket dataset to be optimized for CARTO Builder. In doing so, temporal data from the performances could be displayed as an animated time-series widget that retraces the artist\u2019s journey through New York City. Flattening the nested event category (e.g. play, drama, musical) and into rectangular data would also allow for an additional \u201cFilter by column\u201d analysis to further illustrate Hopper\u2019s theatrical preferences based on frequency.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Many of the features incorporated into this CARTO geovisualization have also inspired future versions of the original <\/span><i><span style=\"font-weight: 400\">Hopper at the Theatre<\/span><\/i><span style=\"font-weight: 400\"> interactive map. For instance, the \u201cFilter by column\u201d analysis and use of different colors to visualize the permanence or destruction of a building could be implemented using JavaScript and Leaflet to create markers with custom icons. CARTO\u2019s automated affordance for vertical scrolling in pop-ups is an elegant UX solution to the overloaded text of the Wikipedia abstracts in the Leaflet version.<\/span><\/p>\n<h1><b>References<\/b><\/h1>\n<p><span style=\"font-weight: 400\">Geyer, A. (2006). <\/span><i><span style=\"font-weight: 400\">Audrey Munson: This site of memory<\/span><\/i><span style=\"font-weight: 400\"> [Artist\u2019s map]. Retrieved from <\/span><a href=\"http:\/\/www.andreageyer.info\/projects\/audrey_munson\/munson_notebooks\/audrey\/mapNEU5.pdf\"><span style=\"font-weight: 400\">http:\/\/www.andreageyer.info\/projects\/audrey_munson\/munson_notebooks\/audrey\/mapNEU5.pdf<\/span><\/a><\/p>\n<p><span style=\"font-weight: 400\">Hopper, E. (n.d.). <\/span><i><span style=\"font-weight: 400\">New York movie<\/span><\/i><span style=\"font-weight: 400\"> [Digital image]. Retrieved from <\/span><a href=\"https:\/\/www.moma.org\/collection\/works\/79616\"><span style=\"font-weight: 400\">https:\/\/www.moma.org\/collection\/works\/79616<\/span><\/a><\/p>\n<p><span style=\"font-weight: 400\">NYC Parks. (n.d.). <\/span><i><span style=\"font-weight: 400\">NYC public art map and guide<\/span><\/i><span style=\"font-weight: 400\">. Retrieved from <\/span><a href=\"https:\/\/www.nycgovparks.org\/art-map\"><span style=\"font-weight: 400\">https:\/\/www.nycgovparks.org\/art-map<\/span><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction This report explores categorical and geospatial data collected through the Linked Open Data (LOD) for Museums Fellowship offered by the Pratt Institute School of Information and the Whitney Museum of American Art and visualized using CARTO, a proprietary Software as a Service (SaaS) cloud based platform for GIS and web mapping. The goal of&hellip;<\/p>\n","protected":false},"author":471,"featured_media":8925,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[149],"tags":[111,31,19],"coauthors":[],"class_list":["post-8917","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-labs","tag-carto","tag-maps","tag-nyc"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/nyc-hopper.png?fit=1440%2C1136&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paBdcV-2jP","_links":{"self":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/8917","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/users\/471"}],"replies":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/comments?post=8917"}],"version-history":[{"count":10,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/8917\/revisions"}],"predecessor-version":[{"id":9206,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/8917\/revisions\/9206"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/media\/8925"}],"wp:attachment":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/media?parent=8917"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/categories?post=8917"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/tags?post=8917"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/coauthors?post=8917"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}