{"id":179,"date":"2016-04-28T17:20:36","date_gmt":"2016-04-28T17:20:36","guid":{"rendered":"http:\/\/teaching.lfhanley.net\/dhspring2016\/?p=179"},"modified":"2016-04-28T17:20:36","modified_gmt":"2016-04-28T17:20:36","slug":"working-with-sf-beats-data","status":"publish","type":"post","link":"https:\/\/teaching.lfhanley.net\/dhspring2016\/2016\/04\/28\/working-with-sf-beats-data\/","title":{"rendered":"Working with SF Beats data"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter  wp-image-180\" src=\"http:\/\/teaching.lfhanley.net\/dhspring2016\/files\/2016\/04\/BeatsTrips-300x205.jpg\" alt=\"BeatsTrips\" width=\"570\" height=\"390\" srcset=\"https:\/\/teaching.lfhanley.net\/dhspring2016\/files\/2016\/04\/BeatsTrips-300x205.jpg 300w, https:\/\/teaching.lfhanley.net\/dhspring2016\/files\/2016\/04\/BeatsTrips-768x524.jpg 768w, https:\/\/teaching.lfhanley.net\/dhspring2016\/files\/2016\/04\/BeatsTrips-1024x698.jpg 1024w, https:\/\/teaching.lfhanley.net\/dhspring2016\/files\/2016\/04\/BeatsTrips.jpg 1776w\" sizes=\"auto, (max-width: 570px) 100vw, 570px\" \/><\/p>\n<p>After wrangling, mangling and otherwise massaging the data in our SF Beats dataset, here&#8217;s the first offering via Palladio. \u00a0The map shows the connections between the birthplaces of Beat figures and San Francisco. \u00a0This is a pretty cool map. \u00a0But, what I discovered:\u00a0locations have to be geocoded to be plotted by Palladio. \u00a0This means: first, geocoding the locations (via a script I found for Google sheets), downloading the Google sheet into Excel, merging the longitude and latitude columns, adding in a column with the geocoded location for San Francisco (37.7749295, -122.4194155), cleaning up data to make sure that all entries are in the proper (lat, long) format, etc. \u00a0In other words, you may have the data and it may be very good, but you might have to translate the data into terms that will work for your visualization app.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter  wp-image-181\" src=\"http:\/\/teaching.lfhanley.net\/dhspring2016\/files\/2016\/04\/BeatsEDGoogleFusion-300x239.jpg\" alt=\"BeatsEDGoogleFusion\" width=\"449\" height=\"358\" srcset=\"https:\/\/teaching.lfhanley.net\/dhspring2016\/files\/2016\/04\/BeatsEDGoogleFusion-300x239.jpg 300w, https:\/\/teaching.lfhanley.net\/dhspring2016\/files\/2016\/04\/BeatsEDGoogleFusion-768x611.jpg 768w, https:\/\/teaching.lfhanley.net\/dhspring2016\/files\/2016\/04\/BeatsEDGoogleFusion-1024x814.jpg 1024w, https:\/\/teaching.lfhanley.net\/dhspring2016\/files\/2016\/04\/BeatsEDGoogleFusion.jpg 1777w\" sizes=\"auto, (max-width: 449px) 100vw, 449px\" \/><\/p>\n<p>Here&#8217;s a Google Fusion-ized map of our SF Beats data. \u00a0The map shows the places of education for 37 of our SF Beat figures. \u00a0Google Fusion will geocode locations (e.g. Cambridge, Mass, etc.) automatically. \u00a0Also, notice the little card that pops up for Catherine Cassady. \u00a0That&#8217;s nice. \u00a0However, Google Fusion doesn&#8217;t seem to allow as much sorting or customizing\u00a0in your visualization &#8211; &#8211; as in Palladio&#8217;s &#8220;Connected Points&#8221; tile. \u00a0Perhaps there are extensions that add these things to the Fusion maps.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter  wp-image-183\" src=\"http:\/\/teaching.lfhanley.net\/dhspring2016\/files\/2016\/04\/SFBeatSilk-300x239.jpg\" alt=\"SFBeatSilk\" width=\"554\" height=\"441\" srcset=\"https:\/\/teaching.lfhanley.net\/dhspring2016\/files\/2016\/04\/SFBeatSilk-300x239.jpg 300w, https:\/\/teaching.lfhanley.net\/dhspring2016\/files\/2016\/04\/SFBeatSilk-768x611.jpg 768w, https:\/\/teaching.lfhanley.net\/dhspring2016\/files\/2016\/04\/SFBeatSilk-1024x814.jpg 1024w, https:\/\/teaching.lfhanley.net\/dhspring2016\/files\/2016\/04\/SFBeatSilk.jpg 1777w\" sizes=\"auto, (max-width: 554px) 100vw, 554px\" \/><\/p>\n<p>Here, I&#8217;ve fed our SF Beats dataset into the Silk platform. \u00a0This produces a pretty nice pie chart showing the years in which our Beats arrived in SF. \u00a0Lesson learned: each platform (Palladio, Silk, Fusion, etc.) has different expectations about the organization and form of your data. \u00a0You&#8217;ll have to monkey around a bit &#8211; &#8211; adjusting the format of your data in Excel or Google sheets to match the expectations of the platform or app that you use.<\/p>\n<p>I&#8217;ve just started to really explore Tableau &#8211; &#8211; which looks like one of the most powerful of the visualization tools.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>After wrangling, mangling and otherwise massaging the data in our SF Beats dataset, here&#8217;s the first offering via Palladio. \u00a0The map shows the connections between the birthplaces of Beat figures and San Francisco. \u00a0This is a pretty cool map. \u00a0But, &hellip; <a href=\"https:\/\/teaching.lfhanley.net\/dhspring2016\/2016\/04\/28\/working-with-sf-beats-data\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-179","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/teaching.lfhanley.net\/dhspring2016\/wp-json\/wp\/v2\/posts\/179","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teaching.lfhanley.net\/dhspring2016\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teaching.lfhanley.net\/dhspring2016\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teaching.lfhanley.net\/dhspring2016\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/teaching.lfhanley.net\/dhspring2016\/wp-json\/wp\/v2\/comments?post=179"}],"version-history":[{"count":1,"href":"https:\/\/teaching.lfhanley.net\/dhspring2016\/wp-json\/wp\/v2\/posts\/179\/revisions"}],"predecessor-version":[{"id":184,"href":"https:\/\/teaching.lfhanley.net\/dhspring2016\/wp-json\/wp\/v2\/posts\/179\/revisions\/184"}],"wp:attachment":[{"href":"https:\/\/teaching.lfhanley.net\/dhspring2016\/wp-json\/wp\/v2\/media?parent=179"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teaching.lfhanley.net\/dhspring2016\/wp-json\/wp\/v2\/categories?post=179"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teaching.lfhanley.net\/dhspring2016\/wp-json\/wp\/v2\/tags?post=179"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}