Please tell us if the details on these pages are no longer correct: firstname.lastname@example.org.
Show: Kenya National Health Facilities KML in Google Earth
"This map of thousands of health facilities in Kenya came from a spreadsheet. After importing it into Google Fusion Tables, it takes only two clicks to make this KML. I'm going to show you how I did it."
"To get a little fancier, I'm also going to show to make a version that will update to always reflect the latest data in the underlying data table, using a Network Link in Google Earth. "
Show: Browser Tab 1: MAP | Noor et al. 2009
"As a part of the Malaria Atlas Project, a data set was brought together with about 5,000 health facility locations in Kenya. It's been published and made available to the public here on this website."
"I'm going to download it and bring it into Google Fusion Tables."
"Google Fusion Tables requires that all of the descriptive location information be combined together in one column, separated by spaces. For example, if you have an address - street, city, state, zip - these need to be combined into one column, with each part separated by a space.
"But if you have point data like Latitude and Longitude, like in this data file, you're fine."
"Google Fusion Tables accepts spreadsheet files up to 1 MB in size, and .csv files up to 100 MB. I'm going to save this as .csv to take advantage of the larger file allowance."
Show: Data file in Excel
Show: Browser Tab 2: Google Fusion Tables
"Here's the data, in Fusion Tables. I'm going to specify which columns have the lat-long."
Show: Google Earth
"Now we have all over 5 thousand locations in Google Earth. We can zoom around and see where they appear."
"The bubbles show the all the values from that record by default."
"The key advantage of using a Network Link is that it always reflects the latest values in the underlying data table. Let me show you..."
Show: Browser Tab 2: your imported Kenya Health Facilities test table
"This is a pretty dramatic change to our data set, but it's OK because we brought it in to test & play with."
Show: Google Earth
"OK, so let's refresh our Network Link. We should see that pin disappear."
Teach Fusion Tables >