Transcript library.duke.edu

http://goo.gl/KHgusm
Fusion Tables
Introduction: Lab Workbook
John Little
Data Analysis & Management Analyst
Brandeleone Data & GIS Lab (226 Perkins)
Duke University Libraries
September, 2013
Brandaleone
Data & GIS Lab
Contact Us: [email protected]
Location: Perkins Library, 2nd Floor
Hours: Walk-in, M-F / 8-5
OR, Anytime the Library is open (with ID)
Walk-in, Attendant Hours:
http://library.duke.edu/data/about/schedule.html
Workshops:
http://library.duke.edu/data/news
Feedback on this workshop
http://library.duke.edu/data/feedback.html
Services:
●
Data analytics software and support
●
Statistical programming support
●
Robust computers with large dual monitors
●
GIS and mapping
●
Visualizations (mapping or statistical graphics)
●
Data management planning
●
Identifying data sources
●
Bloomberg financial data terminals
Google Fusion Tables
What is Fusion Tables? How are they used?
●
A cloud database service by Google that helps you manipulate large quantities of data
●
Easily merge your data with others
●
Easily collaborate with others
●
Intuitive, if rudimentary, GIS mapping combined with easy cloud-sharing (e.g. embedding in blogs)
●
Charting and plotting
●
Easily filtering or creating shareable sub-views of your data
Best Characteristics
●
Sharing, Mapping (geolocating address or latitude/longitude data), Merging
What’s it Like?
●
Looks like a spreadsheet, but it’s NOT
●
Sometimes, before import, you’ve got to clean your data. (e.g. OpenRefine or even Excel)
●
Import structured data (rows and columns)
●
Sort data
●
Faceting
●
Create custom views
Prerequisites
●
A Google Account
●
A google app: Go to “Google Drive” > Create > Connect to more apps > search: “Fusion” > Connect to “Fusion
Fusion Tables - Tour
Tour
●
Bicycle Theft Map - Raleigh 2012
○
data from OpenRaleigh Data Portal
○
Click “source” in the legend to see the Fusion Table
○
Notice Geocoding/Location, Filtering and Alternate maps
○
Yellow highlights means a geocodable/recognizable field
Fusion Tables - Tour
Adding Your Own Data
●
●
LA-Politicians in Baton Rouge -- Where do they live
○
Data can be imported from hard drive
e.g. CSV, spreadsheet (Google, Excel, etc.)
○
Or existing, shareable Fusion Tables
○
Show:
■
Card
■
Map
■
Card 2
■
Filtering
■
Sharing
■
Summary
■
Map Layout
■
Rows (Column header / Change)
■
File: merge, Geocode, import rows, share
■
+ > Add Chart
Mergable Data
○
Merge Table - Louisiana Counties ShapeFile
Fusion Tables - Hands-on
1.
Login to your Google Account (or create one)
2.
Create a Fusion Table
a.
Go to “Google Drive” > Create > Connect to more apps > search: “Fusion” > Connect to “Fusion Tables”
b.
Click “Create”
c.
In a separate tab, open this Google Spreadsheet dataset -- http://goo.gl/VJVp9c and copy the long URL
d.
Go back to “Google Drive”
e.
Click “Google Spreadsheets” in the Import dialogue box, then paste the long URL into the “Or paste a
web address here” field
f.
Click “Select”
g.
Wait
(directions continue on next screen of this workbook)
Fusion Tables - Hands-on
1.
Notice the features
in this screen
2.
Click Next
3.
Notice the fields in the next screen then
click Finish
4.
Notice the Yellow highlighted fields
whcih means those are recognized as potential
“locations” which can be “geocoded”. You
can change the columns into “location” fields.
And you can set a “2-column” latitude / longitude
location field
Fusion Tables - Hands-on
1.
Click the “Map of City” option
2.
Click the “down triangle”
3.
Choose “Select Location”
4.
Choose “FT address”
5.
WAIT as the Geocoding takes place
6.
Zoom in on Louisiana
7.
Click [browser] refresh and reselect “FT
Address” as part of the “Select Location”
Fusion Tables - Hands-on
Filter to Share a Custom View
1.
Click the “red + ” to add a tab
2.
Select “Add row layout”
3.
Click “down triangle”
select “Party Code”
4.
Select the “N” checkbox
Filter” and
Now you can share just this view of the data,
from the “down triangle” in this active tab,
you would choose “Publish”. You can
also rename the tab header from the
same “down triangle”
Fusion Tables - Hands-on
Customize Card View
1.
Click the “red + ” to add a tab
2.
Select “Add card layout”
3.
If it’s still open you can close (“x-out”)
the Party Code Filter on the lefthand
sidebar
4.
From the “down triangle” of the active
“Card 2” tab, choose “Change card
layout”
5.
Select “Office Title”, “Candidate
Name”, “City2”, and “State2” -- this will
require unselecting the other columns.
6.
Change the “Down” field to: 6
7.
Change the “Sort by” field to
“Candidate Name”
8.
Click “Save”
Note:
●
Compare with the “Cards 1” tab
●
You can still add filters
●
You can still “scroll” through the cards
Fusion Tables - Hands-on
Using multiple filters
1.
Click the “red + ” to add a tab
2.
Select “Add map”
3.
From the “down triangle”, set “Select
location” to “FT Address”
4.
Zoom [out] to get a get a good view of
the state
5.
Click the “blue Filter” button
6.
Select “Party Code”
7.
Click the “blue Filter” button again
8.
Select “Sex”
9.
Using both filters, show the distribution
of Male (M) Democrats (D)
10. Click on any dot in the map to engage
a balloon of the background data
Note:
●
You can use more than one selection
per filter. e.g. you can select Male
Democrats and Male Not-affiliated (N)
Fusion Tables - Hands-on
Explore Public Data Tables -- for potential
merge
1.
Select “File” > New table …
2.
In the “Or search public data tables”
box, type “Louisiana Counties” and
click the magnifying glass
3.
In the lefthand sidebar, select “Fusion
Tables”
4.
Click the first entry. This is a shapefile
of Census data for counties in Louisiana
5.
Click “Switch to new look” in the
upper-right
6.
Click the red + tab, and “Add map”
7.
Wait for the county shapefiles to appear
Note:
●
This data will not merge because there
is no common merge component: e.g.
“County Name”
●
Note you do not have to limit your
exploration to only Fusion Tables. The
Resources
Introductory Tutorials and Guides
●
Video Introduction (6:00 on YouTube)
●
Google’s Introduction
●
Google’s Basic Tutorials & Extending Knowledge “helps”
●
Intro from Penn State’s Department of Geography
●
Google’s Fusion Tables Workshop
●
Article on relating spatial and attribute data from the US Census Bureau (Cartographic Perspectives - the
journal of NACIS / Michael Peterson, Kelly S. Koepsell, Gabriel Pereda, and Spencer Trowbridge)
●
Blog Post on shape files, KML, mouseovers (Michael Henry Keller)
●
Mark’s LibGuide on the topic
More listsings, including links to resource data and examples can be found in this blog post. For more discussions of
Fusion Tables and examples of embedded maps see this set of tagged posts.
Thanks For Coming
Please give feedback on the live workshop
http://library.duke.edu/data/feedback.html
Questions to:
[email protected]
Data Analytics &
Management Analyst
Data & GIS Lab
Room 226 Perkins Library
Duke University Libraries