Join Jason VanHorn for an in-depth discussion in this video Merging your data, part of GIS on the Web.
…Now that we've mapped the gas stations, we can click on any of the symbols and…get attribute information about that gas station.…So how can we expand the attribute information connected with each station?…The most common information most people who use a vehicle want to…know is where to find the cheapest gas.…While I've collected the current gas prices at each of these stations at…the data set.…So how are we going to map that?…Well first we need to create a spreadsheet and then convert it to a fusion table.…
And then I want to show you how to merge it into this map.…First, we're going to go over to Drive.…In here I have organized all my files into these two folders.…We'll go into the gas station folder and we'll create a new spreadsheet.…Here I'll go ahead and name my spreadsheet Gas Prices.…Now in the exercise file folder, now I've gone ahead and…added a gas prices Excel spreadsheet.…So lets go ahead and import that now.…And we'll go ahead and replace the entire spreadsheet.…Okay, notice here I have two columns, station and cost.…
- Understanding map mashups
- Finding coordinates
- Mapping with Google Drive
- Geocoding with addresses and coordinates
- Merging data
- Analyzing your map
- Adding GIS layers from services or a file
- Working with the Google Maps, Bing Maps, and Esri APIs
- Sharing and publishing your work
Skill Level Intermediate
1. Mapping on the Internet
2. Google Maps Mashups Made Easy
3. Esri Maps Mashups Made Easy
4. Advanced Concepts: Application Programming Interfaces
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.