The official blog for Google Maps
Finding the perfect home with Google Fusion Tables
November 21, 2011
Editor’s Note:
This is a true story, but some of the details have been changed for privacy purposes.
My husband and I were recently in the market for a new home. We worked with a realtor for a few months, looking at several houses every weekend. As we checked out each house, we tracked our thoughts about it in a Google spreadsheet, which included columns for the address, our pros and cons, individual ratings and the combined rating of the house.
One day, while my husband and I were rating a recently viewed home, he came up with a brilliant idea to put all of our home data on a map. We realized that adding geographic information to our personal opinions would help us find trends, such as which neighborhoods we preferred. A light bulb went on over my head:
Google Fusion Tables
!
Fusion Tables is a data management web application that makes it easy to view tabular data on a
Google Map
. Columns with location data, such as addresses, points, lines, or polygons, are automatically interpreted and mapped. The map features can be styled according to the data in your table. It’s also simple to share the map visualization with others.
In just a
few steps,
we were able to convert our spreadsheet into a
fusion table
:
This was a great start, but what we really wanted was to quickly get a glimpse of this data on a map. All we had to do was select
‘Visualize > Map’
from the table menu and the data in the ‘Address’ column was geocoded (i.e. converted into latitude and longitude coordinates) and the markers were displayed on the map. Clicking on the markers showed additional information about the house pulled from our spreadsheet, including the pros, cons and ratings we inputted for each location.
Our house ratings viewed in Google Maps (after being converted into a Fusion Table).
Fusion Tables also allow you to style the features on the map according to data in a numerical column in the table. We had the perfect column to use for this purpose: the ‘Total Rating’ column!
In order to color code the map markers by their ‘Total Rating’ score, we
customized the icons
based on a range of scores, with red representing the lowest scores, yellow show mid-range scores and green showing the houses with the highest combined rating. After saving these new settings, the map markers were immediately styled:
Our new map made it much easier to see what locations we were most interested in (the house just south of Redwood City) and the neighborhoods of low interest (those that were closer to the bay or hills).
We shared the map with our realtor and she loved it. It helped her refine the selection of homes she showed us and in just a matter of weeks, I’m happy to say that my husband and I found the perfect house!
Posted by Kathryn Hurley, Developer Programs Engineer, Geo DevRel
Labels
#streetview
#treasuremap
+1
3D
8bitmaps
Adwords Express
Africa
Amazon
Andorra
Android
api
Art Project
Audi
biking
Boost
Boulder
Brazil
Bulgaria
Business Photos
Business View
businesses
Canada
check-in
community
competition
contest
crisis response
Culture
custom maps
developer
Developers
directions
disaster response
discovery
earth outreach
education
Emmy Awards
Enterprise
Estonia
Europe
Explore
Fusion Tables
gadgets
Gibraltar
GMM
google
Google Earth
Google Earth Engine
Google Map Maker
Google Maps
Google Maps API
Google Maps Engine
Google Maps for Mobile
Google Maps Gallery
Google Maps Navigation
Google Maps Transit
Google Places
Google Plus
Google Search
Google Street View
google.org
Google+
googlenew
Grand Canyon
ground truth
Halloween
historical
history
holiday
Hotpot
Hungary
imager
imagery
Indoor Maps
iOS
iPhone
Iraq
Japan
Latitude
Latvia
layers
LBC
Lithuania
London
Making of Maps
Malaysia
Mall of America
Map Maker
Maps Blog
Maps Gallery
mapsgl
Matt Harding
Mexico
Mobile
Monticello
My Maps
my places
my tracks
National Geographic
navigation
new Google Maps
oblique imagery
ocean
offline maps
Olympics
Outreach
Pakistan
Panoramio
Parks Canada
Pegman
Photo Spheres
photo tours
photos
picasa
Polar Bears
Quiz
real estate
restaurants
road trips
Russia
Santa
Santa Tracker
search stories
SketchUp
Slovakia
Slovenia
South Sudan
space
Spain
sports
Street View
summer
SXSW
Tags
Thomas Jefferson
Thomas Jefferson Foundation
Tip of the week
tips
tour guide
traffic
Train
Transit
travel
trees
Trekker
Trike
Trolley
U.S. National Park Service
Ukraine
University of Virginia
Valentine's Day
Veterans Day
Views
voice search
walking
Waze
weather
webgl
Your Timeline
zagat
Archive
2016
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2015
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2014
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2013
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2012
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2011
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2010
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2009
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2008
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2007
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Feed
Google
on
Follow @googlemaps
Follow
Give us feedback in our
Product Forums
.
Follow
