Join Jason VanHorn for an in-depth discussion in this video Google Fusion Tables with Google spreadsheets, part of GIS on the Web.
To show you how to build a simple mashup using fusion tables, let's first start with spreadsheets to construct some geographic data. The way that we do that is we choose Create, and Spreadsheets. Here is our spreadsheet environment. In this case, we could give a meaningful title and we could populate this with geographic data, such as an ID field, a location field, and a description field. In this case I've already done that in an Excel spreadsheet. You can find this in the exercise files folder.
So, what we're going to do is we're going to import that Excel spreadsheet, right now. Now you don't need to have Excel to build the data set, in fact what I did is I built it here in drive and then exported it as an Excel spreadsheet. The way I did that was File, and then download as Microsoft Excel. Well we're going to import, so if you'll choose Import, and we'll import straight from that exercise files folder. There we are, we want Lake Tana geography and we'll choose to Open it. And now we're going to replace this spreadsheet, and import.
Great. Now you can see I collected four features around Lake Tana region. Of Lake Tana, the blue Nile headwaters, Bahir Dar. Airport and a Lake Tana Monastery. There are several of these Monasterys on the islands near the center of the lake. Now, let's give a meaningful name to this spreadsheet. We'll call it Lake Tana Geography. Great. Now, if we close this, we should see this in our files in Google Drive. And there it is. Now it should update. And there it goes. Lake Tanah geography.
Now we can take this spreadsheet, and actually convert it into a Google fusion table and map it. The way we do that is to click create and fusion table. Now we'll step through a wizard, and convert our spreadsheet. Into a Fusion Table. I'll choose Google Spreadsheets, and there is my Lake Tana Geography that we've imported. I'll select it, and now we get a small preview of that table. In this case, the whole table is presented, because we only have four features.
I'll choose next, and then I'll keep everything default here, and finish. Now we've successfully created of the Lake Tana geography, fusion table. Now because we have location information in there, we see a map of the location. If you don't see this tab you can always add a map by choosing this button here, this plus, and choosing add map. Now, that we have the latitude and longitude of each of these locations, and there's no problems. If you have a problem you'll see this as a yellow row.
So, now let's take a look at our map. When we click on the map, here. We have our four features on the map, and we can click on any of them. And there they are. Now let's manipulate this map mashup even more.
- 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