Your Mobile Support

  • Subscribe to our RSS feed.
  • Twitter
  • StumbleUpon
  • Reddit
  • Facebook
  • Digg

Monday, 21 November 2011

Finding the perfect home with Google Fusion Tables

Posted on 06:00 by Unknown

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
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Posted in Fusion Tables, Google Maps, real estate | No comments
Newer Post Older Post Home

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Popular Posts

  • Take off for the holidays with Google Street View
    Whether it’s touring the canals of Venice , swimming with the seals in the Galapagos or climbing the Burj Khalifa in Dubai, Street View ha...
  • New Maps domains in 11 countries in Middle East & North Africa
    [Cross-posted from the Google Arabia Blog - in Arabic] With the growing numbers of Internet users in the region, we noticed that a huge num...
  • Help improve the “blue dot” for people visiting your venue
    When we announced the availability of indoor maps for Android last November , we also introduced Google Maps Floor Plans as a tool for busi...
  • Get a better view of natural geography with Google Maps
    When you look at Google Maps, we want you to see the most comprehensive, accurate and easy-to-understand representation of the entire world....
  • New Crisis Response maps feature preparedness information for Hurricane Sandy
    Update Nov. 1, 2012 :  We're constantly looking for ways to improve our ability to help in a crisis. Please tell use how you're usi...
  • See the seafloor like never before on World Oceans Day
    Only a tiny fraction of our oceans have ever been explored. As a matter of fact, we know more about the surfaces of Mars and the Moon than w...
  • A bird’s eye view of The Queen’s Diamond Jubilee procession
    Following the royal wedding in 2011, the eyes of the world will again be on London as we celebrate the Diamond Jubilee of Queen Elizabeth I...
  • Catch the London Underground with Google Maps
    (Cross-posted from the Official Google Blog ) Starting today, you can get public transport directions for London within Google Maps. One of...
  • Refocused Design Evolution, Continued
    In June we launched the start of a comprehensive visual redesign for Google Maps founded on three key principles: focus, elasticity, and ef...
  • Explore “land art” with Google Earth
    Whether you’re an art lover or a Google Earth explorer (or both!), you’ll appreciate a new tour that highlights pieces from what’s known to...

Categories

  • #treasuremap
  • +1
  • 3D
  • 8bitmaps
  • Adwords Express
  • Africa
  • Amazon
  • Andorra
  • Android
  • api
  • Art Project
  • Audi
  • biking
  • Boost
  • Boulder
  • Brazil
  • Bulgaria
  • Business Photos
  • Canada
  • check-in
  • community
  • competition
  • contest
  • crisis response
  • Culture
  • custom maps
  • developer
  • Developers
  • directions
  • disaster response
  • discovery
  • Download Free Nokia 6680 PC Suite
  • Download Micromax pc suite
  • Download Micromax pc suite for window
  • Download micromax Q5 Pc suite
  • Download PC suite
  • Download Samsung Mobile Pc Suite
  • earth outreach
  • education
  • Enterprise
  • Estonia
  • Europe
  • Fusion Tables
  • galaxy s2
  • 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 Navigation
  • Google Maps Transit
  • Google Places
  • Google Plus
  • Google Search
  • Google Street View
  • google.org
  • Google+
  • googlenew
  • Grand Canyon
  • ground truth
  • Halloween
  • historical
  • history
  • Hotpot
  • HTC PC Suite Download
  • HTC PC suite for WIN 7
  • HTC PC Suite Free Download
  • HTC sync Downlaod
  • HTC Sync Download for windows
  • HTC Sync Free Download
  • Hungary
  • imager
  • imagery
  • Indoor Maps
  • iPhone
  • Iraq
  • Japan
  • Latitude
  • Latvia
  • layers
  • LG Mobile PC Suite
  • LG Mobile Support Tool
  • LG PC suite Download
  • Lithuania
  • London
  • Malaysia
  • Mall of America
  • Map Maker
  • mapsgl
  • Matt Harding
  • Mexico
  • Micromax A110
  • Micromax Canvas 2
  • Micromax pc suite download
  • Micromax PC suite for windows
  • Micromax Q5 FB PC Suite Free Download
  • Micromax Q5 FB PC Suite Free Download For Windows
  • Mircromax Q3 PC Suite Download for windows
  • Mobile
  • Monticello
  • My Maps
  • my places
  • my tracks
  • navigation
  • new Google Maps
  • Nokia 5250 PC Suite Free Download
  • Nokia 5530 PC Suite Free Download
  • Nokia 5610 PC Suite Free Download
  • Nokia 5800 PC Suite Free Download
  • Nokia 6030 PC Suite Free Download
  • Nokia 6680 PC Suite Download for windows
  • Nokia 6680 PC suite free Download
  • Nokia Asha 305
  • Nokia Asha 306 PC Suite download
  • Nokia C3-01
  • Nokia Free Suite
  • Nokia Mobile PC suite Download
  • oblique imagery
  • ocean
  • offline maps
  • Outreach
  • Pakistan
  • Panoramio
  • Parks Canada
  • Pegman
  • photo tours
  • photos
  • picasa
  • Quiz
  • real estate
  • Russia
  • Samsung C3322 PC Suite Free Download
  • Samsung C6712 PC Suite Free Download
  • Samsung Corby 2 PC Suite Free Download
  • Samsung Galaxy
  • Samsung Galaxy 5830 PC Suite Download
  • Samsung Galaxy Ace Hugo Boss
  • Samsung Galaxy Ace PC Suite Download
  • Samsung galaxy I8190 S III PC Suite Download
  • samsung galaxy mega
  • Samsung Galaxy Mega 5.8
  • Samsung Galaxy Mega 6.3
  • samsung galaxy s2
  • Samsung Galaxy Stratosphere II I415
  • samsung GT-I9100 pc suite
  • Samsung GT-S6102 Galaxy Y Duos PC Suite Download
  • Samsung GT-S6102 PC Suite Download
  • Samsung I9000 Galaxy S PC Suite Download
  • Samsung mobile pc suite downlaod
  • samsung mobile pc suite download for Windows 7 ad XP
  • samsung mobile pc suite download for Windows 7 and XP
  • Samsung N7100
  • Samsung Note 2
  • Samsung Note II
  • Samsung PC Suite Download.
  • Samsung Wave Y Drivers Download
  • Samsung Wave Y PC Suite Free Download
  • Santa
  • Santa Tracker
  • search stories
  • SketchUp
  • Slovakia
  • Slovenia
  • Sony PC Companion Free Download
  • Sony PC Suite Free Download
  • South Sudan
  • space
  • Spain
  • sports
  • Street View
  • Sumsang C3322 Drivers Download
  • SXSW
  • Tags
  • Thomas Jefferson
  • Thomas Jefferson Foundation
  • Tip of the week
  • tour guide
  • traffic
  • Train
  • Transit
  • trees
  • Trekker
  • U.S. National Park Service
  • Ukraine
  • University of Virginia
  • voice search
  • walking
  • Waze
  • weather
  • webgl
  • Xperia PC Suite Download
  • zagat

Blog Archive

  • ►  2013 (87)
    • ►  November (7)
    • ►  October (3)
    • ►  September (4)
    • ►  August (9)
    • ►  July (13)
    • ►  June (12)
    • ►  May (10)
    • ►  April (9)
    • ►  March (11)
    • ►  February (2)
    • ►  January (7)
  • ►  2012 (192)
    • ►  December (9)
    • ►  November (5)
    • ►  October (24)
    • ►  September (13)
    • ►  August (15)
    • ►  July (18)
    • ►  June (21)
    • ►  May (17)
    • ►  April (19)
    • ►  March (26)
    • ►  February (12)
    • ►  January (13)
  • ▼  2011 (234)
    • ►  December (13)
    • ▼  November (17)
      • Imagery Update: Week of November 28th
      • A new frontier for Google Maps: mapping the indoors
      • Visualizing water and energy solutions in a warmin...
      • Street View comes to beautiful Belgium
      • Street View special collections: ski and snow edition
      • Finding the perfect home with Google Fusion Tables
      • Follow robotic wave gliders on a record setting Pa...
      • See your rated places and discover new ones direct...
      • Map your military service for Veterans Day
      • Announcing the 2012 Google Model Your Town Competi...
      • Getting to know you
      • Get news, learn tips and join Hangouts on the Goog...
      • Share biking and walking directions with Custom Maps
      • Recap: Google Geo User Summit in Barcelona
      • Connect with mapping enthusiasts in the Google Ear...
      • A new way to get information about real-world places
      • Take a walk in the park with Street View
    • ►  October (19)
    • ►  September (15)
    • ►  August (23)
    • ►  July (25)
    • ►  June (20)
    • ►  May (20)
    • ►  April (23)
    • ►  March (24)
    • ►  February (18)
    • ►  January (17)
  • ►  2010 (21)
    • ►  December (21)
Powered by Blogger.

About Me

Unknown
View my complete profile