{"id":1885,"date":"2015-05-25T14:16:39","date_gmt":"2015-05-25T21:16:39","guid":{"rendered":"http:\/\/miriamposner.com\/blog\/?p=1885"},"modified":"2015-05-25T14:34:10","modified_gmt":"2015-05-25T21:34:10","slug":"google-fusion-table-basics-with-ius-cushman-collection","status":"publish","type":"post","link":"https:\/\/miriamposner.com\/blog\/google-fusion-table-basics-with-ius-cushman-collection\/","title":{"rendered":"Google Fusion Table Basics with IU&#8217;s Cushman Collection"},"content":{"rendered":"<p><!-- Start ScreenSteps Content --><\/p>\n<div class=\"LessonContent\">\n<div class=\"LessonSummary\">\n<p>I&#8217;ve used Indiana University&#8217;s <a href=\"http:\/\/webapp1.dlib.indiana.edu\/cushman\/\">Cushman Collection<\/a> of photographs before, in my <a href=\"https:\/\/miriamposner.com\/blog\/getting-started-with-palladio\/\">Palladio tutorial<\/a>. Google Fusion tables, though, is a\u00a0slightly simpler way for people to get started with data visualization. So here&#8217;s a quick tutorial that uses\u00a0the same data to create a map and some simple charts.<\/p>\n<p>You can also download this tutorial as a <a href=\"https:\/\/miriamposner.com\/blog\/wp-content\/uploads\/2015\/05\/Google-Fusion-Table-Basics-with-IUs-Cushman-Collection.pdf\">PDF<\/a> or a <a href=\"https:\/\/miriamposner.com\/blog\/wp-content\/uploads\/2015\/05\/Google-Fusion-Table-Basics-with-IUs-Cushman-Collection.docx\">Word document<\/a> (in case you&#8217;d like to modify it).<\/p>\n<p>Here&#8217;s a preview of the map we&#8217;ll make:<\/p>\n<p><iframe loading=\"lazy\" src=\"https:\/\/www.google.com\/fusiontables\/embedviz?q=select+col10+from+1ftslX_I7oiZ5mCzU5s86923ct7r_2_pipijydVRY&amp;viz=MAP&amp;h=false&amp;lat=39.876477521814266&amp;lng=-98.50733984375006&amp;t=1&amp;z=5&amp;l=col10&amp;y=2&amp;tmplt=2&amp;hml=ONE_COL_LAT_LNG\" width=\"500\" height=\"300\" frameborder=\"no\" scrolling=\"no\"><\/iframe><\/p>\n<p><!--more--><\/p>\n<p>Google Fusion Tables is a fairly simple way to go from spreadsheet to data visualization. In this tutorial, you&#8217;ll upload a spreadsheet containing information about the Indiana University&#8217;s Cushman Collection of photographs (which you can find ) and use it to create a map and some charts.<\/p>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\">Open Google Fusion Tables<\/h3>\n<div class=\"StepImage\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/miriamposner.com\/blog\/wp-content\/uploads\/2015\/05\/media_1432585078208.png\" alt=\"media_1432585078208.png\" width=\"540\" height=\"359\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>Go to tables.googlelabs.com<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\">Click on &#8220;Create a Fusion Table&#8221; and sign in with your Google account<\/h3>\n<div class=\"StepImage\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/miriamposner.com\/blog\/wp-content\/uploads\/2015\/05\/media_1432585424636.png\" alt=\"media_1432585424636.png\" width=\"540\" height=\"382\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>Once you&#8217;re in, click on <strong>Choose File<\/strong> and then select the Cushman-Collection file. For <strong>Separator Character<\/strong>, keep the options as they are (with <strong>Comma<\/strong> selected) and then click <strong>Next<\/strong>. On the next screen, click <strong>Next<\/strong> again, and finally, click <strong>Finish<\/strong>.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\">Hey, that&#8217;s kind of cool.<\/h3>\n<div class=\"StepImage\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/miriamposner.com\/blog\/wp-content\/uploads\/2015\/05\/media_1432585651677.png\" alt=\"media_1432585651677.png\" width=\"540\" height=\"360\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>The next screen shows you your spreadsheet just as it was when you were looking at it in Excel \u2014 except Google has automatically pulled in thumbnail images for all the direct links to photographs.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\">Check out a map of locations<\/h3>\n<div class=\"StepImage\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/miriamposner.com\/blog\/wp-content\/uploads\/2015\/05\/media_1432585825030.png\" alt=\"media_1432585825030.png\" width=\"540\" height=\"322\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>Click on the <strong>Map of City and State<\/strong> tab, but \u2014 IMPORTANT \u2014 click on &#8220;Pause Geocoding&#8221; on the window that pops up. In order to place your locations on the map, you need latitudes and longitudes. Google is trying to be helpful by retrieving these for you. But that will take a long time, and actually your spreadsheet already contains this information. So we need to inform Google of this.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\">On the &#8220;Location&#8221; dropdown, click &#8220;Geocoordinates&#8221;<\/h3>\n<div class=\"StepImage\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/miriamposner.com\/blog\/wp-content\/uploads\/2015\/05\/media_1432586008573.png\" alt=\"media_1432586008573.png\" width=\"540\" height=\"454\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>That way Google will use the latitude and longitude data you&#8217;ve already provided.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\">Hey, you have a map!<\/h3>\n<div class=\"StepImage\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/miriamposner.com\/blog\/wp-content\/uploads\/2015\/05\/media_1432586102733.png\" alt=\"media_1432586102733.png\" width=\"540\" height=\"355\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>Pretty cool. You can click on each of the points to see which photo was taken there. Play with the various options to see what you get.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\">Share, if you want.<\/h3>\n<div class=\"StepImage\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/miriamposner.com\/blog\/wp-content\/uploads\/2015\/05\/media_1432586339651.png\" alt=\"media_1432586339651.png\" width=\"540\" height=\"306\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>You can share this map if you want! Just click on the <strong>Share <\/strong>button and share the map the same way you&#8217;d share a Google doc. You can also embed the map on a website by clicking on <strong>Tools <\/strong>and then <strong>Publish<\/strong>.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\">Make some graphs and charts.<\/h3>\n<div class=\"StepImage\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/miriamposner.com\/blog\/wp-content\/uploads\/2015\/05\/media_1432586457241.png\" alt=\"media_1432586457241.png\" width=\"540\" height=\"368\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>Let&#8217;s look at some other views of the same data. Click on the red &#8220;plus&#8221; sign on the tabs menu and select <strong>Add Chart<\/strong>.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\">Make a bar chart.<\/h3>\n<div class=\"StepImage\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/miriamposner.com\/blog\/wp-content\/uploads\/2015\/05\/media_1432586549732.png\" alt=\"media_1432586549732.png\" width=\"540\" height=\"377\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>Click on the <strong>bar chart<\/strong> icon and for <strong>Category<\/strong>, select <strong>Genre 1<\/strong>. Be sure to uncheck &#8220;Value: IU Archives Number&#8221; and <i>do<\/i> check the <strong>Summarize data <\/strong>checkbox. (An easier way to create a summary bar chart is just to choose the <strong>Summarize<\/strong> option when you&#8217;re opening a new tab \u2014 but this way we can switch among different chart types.)<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\">Filter your data.<\/h3>\n<div class=\"StepImage\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/miriamposner.com\/blog\/wp-content\/uploads\/2015\/05\/media_1432588182216.png\" alt=\"media_1432588182216.png\" width=\"540\" height=\"353\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>Fusion Tables allows you to drill down into your data by filtering it. Try adding a <strong>City, State<\/strong> filter.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\">Play with other chart types.<\/h3>\n<div class=\"StepImage\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/miriamposner.com\/blog\/wp-content\/uploads\/2015\/05\/media_1432588253621.png\" alt=\"media_1432588253621.png\" width=\"540\" height=\"489\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>Use these charts to explore your dataset as you try to get a sense of its contours. Pay attention to what the data can and can&#8217;t tell you about the collection of photographs.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<p><!--more--><\/p>\n<p><!--more--><\/p>\n<p><!-- End ScreenSteps Content --><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;ve used Indiana University&#8217;s Cushman Collection of photographs before, in my Palladio tutorial. Google Fusion tables, though, is a\u00a0slightly simpler way for people to get started with data visualization. So here&#8217;s a quick tutorial that uses\u00a0the same data to create a map and some simple charts. You can also download this tutorial as a PDF [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1885","post","type-post","status-publish","format-standard","hentry","category-digital-humanities"],"_links":{"self":[{"href":"https:\/\/miriamposner.com\/blog\/wp-json\/wp\/v2\/posts\/1885","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/miriamposner.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/miriamposner.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/miriamposner.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/miriamposner.com\/blog\/wp-json\/wp\/v2\/comments?post=1885"}],"version-history":[{"count":7,"href":"https:\/\/miriamposner.com\/blog\/wp-json\/wp\/v2\/posts\/1885\/revisions"}],"predecessor-version":[{"id":1894,"href":"https:\/\/miriamposner.com\/blog\/wp-json\/wp\/v2\/posts\/1885\/revisions\/1894"}],"wp:attachment":[{"href":"https:\/\/miriamposner.com\/blog\/wp-json\/wp\/v2\/media?parent=1885"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/miriamposner.com\/blog\/wp-json\/wp\/v2\/categories?post=1885"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/miriamposner.com\/blog\/wp-json\/wp\/v2\/tags?post=1885"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}