{"id":2668,"date":"2016-04-08T10:43:13","date_gmt":"2016-04-08T14:43:13","guid":{"rendered":"http:\/\/commons.trincoll.edu\/dataviz\/?p=2668"},"modified":"2016-04-29T09:52:43","modified_gmt":"2016-04-29T13:52:43","slug":"training-and-transfer-of-ownership-to-the-hartford-food-system","status":"publish","type":"post","link":"http:\/\/commons.trincoll.edu\/dataviz\/2016\/04\/08\/training-and-transfer-of-ownership-to-the-hartford-food-system\/","title":{"rendered":"Training and Transfer of Ownership to the Hartford Food System"},"content":{"rendered":"\n<!-- iframe plugin v.4.5 wordpress.org\/plugins\/iframe\/ -->\n<iframe src=\"https:\/\/docs.google.com\/presentation\/d\/1cWCP5dEZ2WSH4XQTuPyulaWJ1Q46BxquTWc5qwHx2KY\/embed?start=false&#038;loop=false&#038;delayms=3000\" frameborder=\"0\" width=\"960\" height=\"569\" allowfullscreen=\"true\" mozallowfullscreen=\"true\" webkitallowfullscreen=\"true\" scrolling=\"yes\" class=\"iframe-class\"><\/iframe>\n\n<p><strong>Transferring the Visualization\u2019s Ownership:<\/strong><\/p>\n<p>For this project, Kaitlyn and I have used Google Fusion Tables and GitHub to manipulate the data into a Visualization. Transferring the ownership of the visualization should be easy since Google Fusion Tables can be shared and edited by the Hartford Food System through email. Google Fusion Tables creates the map part of the online visualization, and editing these tables change the points and polygons. With the power to edit the Google Fusion Tables, the Hartford Food System will be able to add new data and upkeep old data while simultaneously updating the online map. In case the Hartford Food System change other parts of the visualization like the legend or the position of the maps, Kaitlyn and I will share the code via GitHub. This code can be \u2018forked\u2019 from our project\u2019s repository and then edited if necessary.<\/p>\n<p><strong>Adding and Updating the Visualization\u2019s Data:<\/strong><\/p>\n<p>Data about food establishments in Hartford can be found on the city\u2019s open data site. For example, the data that we used for our food establishment types <a href=\"https:\/\/data.hartford.gov\/Public-Health\/Food-Establishments-classified-as-Grocery-or-Conve\/gcmf-8b3e\">here<\/a>. The city of Hartford also updates this data on a regular basis. Current data can also be edited by double clicking on the table\u2019s cells or selecting the \u2018edit\u2019 button that appears next to the cell.<\/p>\n<p><a href=\"http:\/\/commons.trincoll.edu\/dataviz\/files\/2016\/04\/Screen-Shot-2016-04-07-at-8.18.33-PM.png\" rel=\"attachment wp-att-2671\"><img loading=\"lazy\" class=\"wp-image-2671 aligncenter\" src=\"http:\/\/commons.trincoll.edu\/dataviz\/files\/2016\/04\/Screen-Shot-2016-04-07-at-8.18.33-PM-300x176.png\" alt=\"Screen Shot 2016-04-07 at 8.18.33 PM\" width=\"373\" height=\"219\" srcset=\"http:\/\/commons.trincoll.edu\/dataviz\/files\/2016\/04\/Screen-Shot-2016-04-07-at-8.18.33-PM-300x176.png 300w, http:\/\/commons.trincoll.edu\/dataviz\/files\/2016\/04\/Screen-Shot-2016-04-07-at-8.18.33-PM.png 598w\" sizes=\"(max-width: 373px) 100vw, 373px\" \/><\/a><\/p>\n<p>New data can be singularly added by selecting \u2018edit\u2019 on the toolbar and then \u2018Add Row\u2019, while new data sets can be uploaded as excel and KML format by creating a new Google Fusion Table document.<\/p>\n<p><a href=\"http:\/\/commons.trincoll.edu\/dataviz\/files\/2016\/04\/Screen-Shot-2016-04-07-at-8.11.30-PM.png\" rel=\"attachment wp-att-2670\"><img loading=\"lazy\" class=\"alignnone wp-image-2670\" src=\"http:\/\/commons.trincoll.edu\/dataviz\/files\/2016\/04\/Screen-Shot-2016-04-07-at-8.11.30-PM-300x213.png\" alt=\"Screen Shot 2016-04-07 at 8.11.30 PM\" width=\"311\" height=\"221\" srcset=\"http:\/\/commons.trincoll.edu\/dataviz\/files\/2016\/04\/Screen-Shot-2016-04-07-at-8.11.30-PM-300x213.png 300w, http:\/\/commons.trincoll.edu\/dataviz\/files\/2016\/04\/Screen-Shot-2016-04-07-at-8.11.30-PM-768x544.png 768w, http:\/\/commons.trincoll.edu\/dataviz\/files\/2016\/04\/Screen-Shot-2016-04-07-at-8.11.30-PM-1024x726.png 1024w, http:\/\/commons.trincoll.edu\/dataviz\/files\/2016\/04\/Screen-Shot-2016-04-07-at-8.11.30-PM.png 1724w\" sizes=\"(max-width: 311px) 100vw, 311px\" \/><\/a><a href=\"http:\/\/commons.trincoll.edu\/dataviz\/files\/2016\/04\/Screen-Shot-2016-04-07-at-8.09.38-PM.png\" rel=\"attachment wp-att-2669\"><img loading=\"lazy\" class=\"wp-image-2669 alignleft\" src=\"http:\/\/commons.trincoll.edu\/dataviz\/files\/2016\/04\/Screen-Shot-2016-04-07-at-8.09.38-PM-300x207.png\" alt=\"Screen Shot 2016-04-07 at 8.09.38 PM\" width=\"305\" height=\"211\" srcset=\"http:\/\/commons.trincoll.edu\/dataviz\/files\/2016\/04\/Screen-Shot-2016-04-07-at-8.09.38-PM-300x207.png 300w, http:\/\/commons.trincoll.edu\/dataviz\/files\/2016\/04\/Screen-Shot-2016-04-07-at-8.09.38-PM-768x531.png 768w, http:\/\/commons.trincoll.edu\/dataviz\/files\/2016\/04\/Screen-Shot-2016-04-07-at-8.09.38-PM-1024x707.png 1024w, http:\/\/commons.trincoll.edu\/dataviz\/files\/2016\/04\/Screen-Shot-2016-04-07-at-8.09.38-PM.png 1598w\" sizes=\"(max-width: 305px) 100vw, 305px\" \/><\/a><\/p>\n<p>The polygon&#8217;s map information can also be altered and updated. Currently, we are using the 2014 ACS 1-year estimates for the data in the Polygon. This information can be updated annually. To do this, new American Community Survey data sets should be uploaded to a new Google Fusion Table and &#8216;merged&#8217; with the Hartford Census tract KML file. Both\u00a0spreadsheets must share the same information in at least one column, like the names of food establishments. More information and the step-by-step instruction on how to merge spreadsheets on Google Fusion Tables can be found <a href=\"http:\/\/www.datavizforall.org\/map\/polygon-gft\/index.html\">here<\/a>.<\/p>\n<p><strong>Changing the Visualization\u2019s Characteristics:<\/strong><\/p>\n<p>The ability to change the colors and information displayed by the polygons can be done in Google Fusion Tables. To do this, the Hartford Food System can select the \u2018Map 1\u2019 tab and then \u2018change feature styles\u2019 or &#8216;change info window&#8221; button on left side of the screen.<\/p>\n<p><a href=\"http:\/\/commons.trincoll.edu\/dataviz\/files\/2016\/04\/Screen-Shot-2016-04-08-at-10.18.46-AM.png\" rel=\"attachment wp-att-2672\"><img loading=\"lazy\" class=\" wp-image-2672 aligncenter\" src=\"http:\/\/commons.trincoll.edu\/dataviz\/files\/2016\/04\/Screen-Shot-2016-04-08-at-10.18.46-AM-300x130.png\" alt=\"Screen Shot 2016-04-08 at 10.18.46 AM\" width=\"667\" height=\"289\" srcset=\"http:\/\/commons.trincoll.edu\/dataviz\/files\/2016\/04\/Screen-Shot-2016-04-08-at-10.18.46-AM-300x130.png 300w, http:\/\/commons.trincoll.edu\/dataviz\/files\/2016\/04\/Screen-Shot-2016-04-08-at-10.18.46-AM-768x333.png 768w, http:\/\/commons.trincoll.edu\/dataviz\/files\/2016\/04\/Screen-Shot-2016-04-08-at-10.18.46-AM-1024x443.png 1024w\" sizes=\"(max-width: 667px) 100vw, 667px\" \/><\/a><\/p>\n<p>However, if the Hartford Food System decides to change the data point colors or the legend\u2019s characteristics they will have to modify code in GitHub. <a href=\"http:\/\/www.datavizforall.org\/edit\/github\/index.html\">In his data visualization book,<\/a> Jack Dougherty explains step by step the process how to extract, or \u2018fork\u2019, a visualization\u2019s code to another GitHub account. Kaitlyn and I will share the link to our GitHub repository so the Hartford Food System can extract the visualization\u2019s code.<\/p>\n<p><strong>Data Sources:<\/strong><\/p>\n<p><a href=\"https:\/\/data.hartford.gov\/Public-Health\/Food-Establishments-classified-as-Grocery-or-Conve\/gcmf-8b3e\">Food Establishment Types and Classes<\/a><\/p>\n<p><a href=\"http:\/\/factfinder.census.gov\/faces\/nav\/jsf\/pages\/download_center.xhtml\">American Fact Finder ACS download tool<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Transferring the Visualization\u2019s Ownership: For this project, Kaitlyn and I have used Google Fusion Tables and GitHub to manipulate the data into a Visualization. Transferring the ownership of the visualization should be easy since Google Fusion Tables can be shared and edited by the Hartford Food System through email. Google Fusion Tables creates the map &hellip; <a href=\"http:\/\/commons.trincoll.edu\/dataviz\/2016\/04\/08\/training-and-transfer-of-ownership-to-the-hartford-food-system\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Training and Transfer of Ownership to the Hartford Food System<\/span><\/a><\/p>\n","protected":false},"author":1580,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[64,63,72],"tags":[],"_links":{"self":[{"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/posts\/2668"}],"collection":[{"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/users\/1580"}],"replies":[{"embeddable":true,"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/comments?post=2668"}],"version-history":[{"count":6,"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/posts\/2668\/revisions"}],"predecessor-version":[{"id":2800,"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/posts\/2668\/revisions\/2800"}],"wp:attachment":[{"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/media?parent=2668"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/categories?post=2668"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/commons.trincoll.edu\/dataviz\/wp-json\/wp\/v2\/tags?post=2668"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}