Gis mapping webinar part 2 may 14 2014

60 %
40 %
Information about Gis mapping webinar part 2 may 14 2014

Published on May 14, 2014

Author: LSNTAP

Source: slideshare.net

Mapping with Google Fusion Tables May 14, 2014

Welcome! • Part 2 of a 3-part series – Part 1: Intro to GIS Mapping (April 23) – Part 2: Mapping in Google Fusion Tables (Today, May 14) – Part 3: Mapping in Google Fusion Tables (May 21) • Presenters – Christina Sanabria, LSC – Brian Rowe, LSNTAP • Recording will be available on LSNTAP’s YouTube channel • Phone lines are muted – please send questions via chat

Mapping: Not Just Software To make a map, you need to • Know how to use mapping software • Know where to access data to map • Manage data

Today’s Objectives • Set up Google Fusion Tables • Structure information so you can map it • Create a basic point map of addresses • Share and publish your maps • Combine data from two different sources • Customize your map with colors and filters • Review data resources

Get Started with Google Fusion Tables • Fusion Tables work within Google Drive • Share and collaborate with others – Specify privileges (edit or view) for each person – Publish online (embed like a YouTube video)

Get Started with Google Fusion Tables • You need a Google account to use Google Drive Three ways to create a Google account: 1. Use your Gmail account 2. Create a Google account using your Yahoo, Hotmail or other email 3. Create a free Google Apps account for your nonprofit • Once you’re set up in Google Drive, you need to enable the Fusion Tables app

Get Started: Enable the Fusion Tables App 1. Go to www.drive.google.com and log in to your Google Account

Get Started: Enable the Fusion Tables App 2. Click “Create” 3. Click “Connect more apps”

Get Started: Enable the Fusion Tables App 4. Type Google Fusion Tables in the search field and press “Enter” to search

Get Started: Enable the Fusion Tables App 5. Click Connect

Get Started: Enable the Fusion Tables App 6. Click OK

Get Started: Enable the Fusion Tables App 7. Success! Google Fusion Tables is now enabled.

Get Started: Enable the Fusion Tables App 8. Click “Create” 9. Fusion Tables is now in the menu as one of the apps you can open.

Questions so far?

Project 1: Mapping Office Locations

Project 1: Mapping Office Locations Project goal: Create a map of office locations

Project 1: Mapping Office Locations We’ll need to • Structure information so we can map it • Load to Fusion Tables and create the map • Set up a custom “info window” • Share and publish the map

Project 1: Prepare Data in Excel Why start in Excel? • We’re familiar with it • Easier to manipulate data (add/ edit information) • Excel files can be uploaded to Fusion Tables Remember: GIS maps are just visual data, so good data management is essential.

Project 1: Structuring the Information Additional spreadsheet preparation: • No merged cells, no fancy formatting • Is there any other data you’ll want for this project? Add it now. Column headers labeled Full address in a single column One row for each location Each attribute has it’s own column

Questions so far?

Project 1: Data Types in Fusion Tables Text – For descriptive information Number – For quantitative numbers (numbers you’d do math with, not things like phone numbers, zip codes, or ID codes) Location – 1 column (full addresses) or 2 column (lat/long coordinates) Date/Time – in standard formats (e.g., mm/dd/yy)

Project 1: Geocoding Geocode – The process of using geographic information (e.g., street address) about a location to find the geographic coordinates (i.e., latitude and longitude) so the feature can be mapped Geocoding is built into Fusion Tables. File  Geocode This could take a minute…

Questions so far?

Project 1: Customize the Info Window Change info window… “Change info window layout” box displays column headers from your data set. Check or uncheck boxes to display or not display data in the info window. Click “Save”

Project 1: Customize the Info Window You could include:  links  images  videos  charts/ graphs If you include these in your spreadsheet as pieces of data, they will appear in your info window.

Project 1: Customize the Info Window Or select the “Custom” tab to manually edit the html for your info window.  Font sizes/ colors  Edit, format, or remove labels

Project 1: Sharing and Publishing Sharing • Giving permission to access • Share with specific individuals or with a group • Give individuals specific levels of access (read only or edit) Publishing • Making the document available to the people with whom you’ve shared • Publish by embedding your map online or sharing the link to your Fusion Table

Project 1: Sharing & Publishing are Interdependent • You can share it, but if you don’t publish it, no one will know it’s out there. • You can publish it but if you haven’t shared it, your audience won’t have permissions to open it.

Project 1: Share so you can Publish Change your sharing settings to “Anyone with the link” so that you can publish your map on a website (and not get an error message)

Project 1: Share so you can Publish Change your sharing settings to “Anyone with the link” so that you can publish your map on a website (and not get an error message)  

Questions so far?

Project 2: Mapping School Suspension Data

Project 2: School Suspension Data Project goal: Advocates working on education issues have seen a spate of cases involving school suspensions, especially with middle school students. They want to know: • Are there any regional patterns? • Should we focus our outreach/ community education efforts in a certain area?

Project 2: School Suspension Data

Project 2: School Suspension Data We’ll need to • Structure information so we can map it • Combine information from two different data sources* • Customize map with colors and filters • Set up a custom info window • Share and publish the map * It can be difficult to find one data set that tells you everything you want to know.

Project 2: Gathering Data National Center for Education Statistics for basic info about schools http://nces.ed.gov/ccd/elsi/

Project 2: Gathering Data Civil Rights Data Collection on ED.gov http://ocrdata.ed.gov/

Project 2: Merging Data School A Location information School A Discipline data Merge tables to combine data from different sources School A Location information and Discipline Data Merged

Project 2: Merging Data C. Hunter Ritchie Elemen. Ritchie Elementary??? NCES school ID: 510313001289 NCES school ID: 510313001289 • Fusion Tables will not recognize that this is the same school. • Fusion Tables will recognize that this is the same school. • Info about this school from the two different sources will be related to each other. Fusion Tables needs a matching column to correctly merge data.

Project 2: Defining Marker Styles from Data Add or remove buckets “1 to 4.9999” Schools at which 1 to 4 students received more than one out of school suspension will be marked with a yellow dot Select the column of data that should determine the color of dot

Final questions?

Now that you can map… Where to get data?

Data Resources American Community Survey http://factfinder2.census.gov National Center for Education Statistics for basic info about schools http://nces.ed.gov/ccd/elsi/ Civil Rights Data Collection on ED.gov – discipline, student retention, AP courses, Early Childhood Education, and more http://ocrdata.ed.gov/ “Data, Demographics, Statistics” resource list, Legal Services Northern California http://equity.lsnc.net/data-demographics-statistics/

Challenge – Make a Map this Week! • Set up your Google Account and enable the Fusion Tables app • Map your own office locations • Map other data that’s of interest to you • Got stuck? Contact us! • Did you make a map? Show it to us! • sanabriac@lsc.gov, pellittierim@lsc.gov

Learn More • Join us next week, May 21 for Part 3 of the series! • More resources available on LRI, plus more content to be added soon • Contact us: sanabriac@lsc.gov, pellittierim@lsc.gov “Polygon” map made using Fusion Tables http://lri.lsc.gov/engaging- clients/language-access

Add a comment

Related pages

GIS Mapping Part 2 Slides | LSNTAP

Home › Blog › GIS Mapping Part 2 Slides. ... Gis mapping webinar part 2 may 14 2014 from Legal Services National Technology Assistance Project (LSNTAP)
Read more

Mapping with Google Fusion Tables

May 21, 2014 . Welcome! • Part 3 ... – Part 1: Intro to GIS Mapping (April 23) – Part 2: Mapping in Google Fusion Tables (May 14) ... Male 12 to 14 years
Read more

Gis Mapping | LinkedIn

Gis mapping webinar part 2 may 14 2014. 863 Views. kirwaninstitute. ... Gis Mapping. GIS stands for Geographic Information System, ...
Read more

GIS | GISblog.com - Part 2

... GIS, GIScience 2014, TUWien, ... MicroStation DGN: How to Integrate CAD & GIS Free webinar by: ... Learning Open Web Mapping from Start to Finish ...
Read more

Listening to the Webinar - ADA Conferences

... 2014 2 3 3 Listening to the Webinar, continued ... Emergency Preparedness Webinar Series January 8, 2014 14 ... (GIS) Mapping.
Read more

GIS Webinar - YouTube

Recorded Webinar: 2014 BE-10 Benchmark Survey Overview for New Filers (May 14, 2015) - Duration: ... Modeling & GIS - Webinar - Part 1 of 5 ...
Read more

[Webinar Recap] GIS – What, Why and How?

There’s a lot of buzz these days about ‘GIS’ applications ... July, 2014 (14) June, 2014 (12) May, 2014 (13) April, 2014 (13) ... [Part 2] Failure to ...
Read more

Gis (mapping) | LinkedIn

Gis (mapping) Articles, experts, jobs, and more: get all the professional insights you need on LinkedIn
Read more