Fusion Table Searchable Map Template

You want to put your data on a searchable, filterable map. This is a free, open source template to help you do it.

See the working demo »

Features

• full screen and iframe templates (new!)
• mobile and tablet friendly using responsive design
• address search (with variable radius and geocomplete)
• geolocation (find me!)
• results count (using Google's Fusion Tables v1 API)
• RESTful URLs for sharing searches
• ability to easily add additional search filters (checkboxes, sliders, etc)
• all done with HTML, CSS and Javascript - no server side code required

Dependencies

• Google Fusion Tables
• Google Maps API V3
• jQuery
• jQuery Address
• Bootstrap 3

Community

There's a public Google Group for anyone who wants to or has used the Searchable Map Template. Join the growing community of map makers to learn, share and benefit from each other!

Join the Fusion Table Map Template Google Group »

Releases

We've upgraded to Bootstrap 3! The HTML markup is slightly different in this version, so if you still want to use Bootstrap 2, you can grab that version too.

If you're upgrading, check out the Bootstrap migration guide.

• v 1.3 - Bootstrap 3.2, more robust query function, dynamic zoom
• v 1.2 - Bootstrap 3, jQuery 1.10.2, jQuery Address 1.6
• v 1.1 - Bootstrap 2.0.3, jQuery 1.7.1, jQuery Address 1.4

Setup

This template now supports the Fusion Tables v1 API. For more info on this, see the migration guide.

Follow the steps below and you'll be in business with your own map.

1. Create a Fusion Table (here's a great tutorial)
2. Make sure at least one column is set to a type of Location and that Fusion Tables has geocoded it
3. Set the Fusion Table to be publicly visible (via the Share button in the upper right) and make sure 'Allow Download' is enabled.
4. Turn on the Fusion Tables API
   1. Go to the Google APIs Console
   2. Click 'Enable an API' and set Fusion Tables API to 'On'
   3. On the Credentials page, create a new Public API access key
   4. Select Browser key
   5. Leave the ACCEPT REQUESTS FROM THESE HTTP REFERERS blank and click Create
   6. Copy the API KEY, which should look something like AIzaSyA3FQFrNr5W2OEVmuENqhb2MBB2JabdaOY
5. In js/maps_lib.js, set your
   1. fusionTableId to the encrypted ID of your Fusion Table. Note: Google is phasing out numeric IDs soon
   2. googleApiKey to the API key from your Google API Console
   3. locationColumn to the name of your location column in your Fusion Table
   4. map_centroid to the lat/long you want your map to center on
   5. locationScope to the area you want to limit searches to (set to 'Chicago' by default)
   6. recordName and recordNamePlural to the name of the items in your Fusion Table
6. Add/modify additional filters to maps_lib.js. This will depend on the data you are trying to map. Take a look at the wiki for filter examples and list views to get started. You can also take a look at these examples:
   • Connect Chicago Locator
   • Chicago Buildings
   • Chicago Bike Crash Reports
   • Chicago TIF Projects
7. Upload this map and all the supporting files (css, fonts, images and js folders) to your site

Custom Filters and Views

Take a look at the wiki to see how to add your own custom filters and views like:

• Checkboxes
• Radio buttons
• Drop down lists
• Text searches
• Results lists
• Text searches
• Sliders
• Date sliders

iframe Template

If you want to embed the template in a page on your website, the easiest way to do it is with an iframe. We provide an iframe-optimized template for this purpose:

See the working demo »

This template works exactly the same way as the standard full screen template. All the javascript code is still contained in js/maps_lib.js.

To embed, you can use the following code on your page:

<iframe 
  style="border-style: none;" 
  src="/path/to/map-template/index_iframe.html" 
  width="600" 
  height="950" >
</iframe>

You must explicitly set the size of the iframe, so midify the height and width attributes as necessary. You can also control the height of the map in css/custom.css:

.iframe #map_canvas { height: 500px; }

Resources

Fusion Tables

• Fusion Tables Home
• v1 API Documentation
• v1 API Migration Guide

Community

• Fusion Tables Issue Tracker
• Fusion Tables Google Group

Reference Guides

• Google Maps API
• Fusion Tables API Developer Guide
• Fusion Tables API Reference Guide

Common issues/troubleshooting

If your map isn't displaying any data, try the following:

1. Use the Chrome developer console or install Firebug for FireFox. This will allow you to debug your javascript.
2. Load your map in the browser and open the javascript console
   • Chrome developer console on a Mac: option+command+j
   • Chrome developer console on a PC: Control+Shift+J
   • Firebug in Firefox: Tools => Web Developer => Firebug => Open Firebug)
3. If you aren't seeing any javascript errors:
   • Make sure that you have at least one column with address or lat/long points set to type 'Location'. You can check this in Fusion Tables under Edit => Modify Columns.
   • Make sure that Fusion Tables has geocoded your column. You check this by going to View => Map. If you see your points on the map, you're good!
   • Check that your Fusion Table is public (in Fusion Tables, upper right corner => Share button)
4. If you do see javascript errors:
   • The error will tell you what line it is failing on. Best to start by going there!
   • Columns in Fusion Tables are case sensitive, so make sure they are correct.
   • For columns that have multiple words in the title, make sure to surround the column name in your code with single quotes (example: "'first name'")

My custom map styles won't display!

This is due to a recent change to the FusionTablesLayer and only effects tables created after mid-November 2012. A styleId and templateId must be defined.

When you create custom styles for the first time, the styleId will be 2. For custom info window layouts, the first templateId will also be 2. The latest version of this template has these defaults set, but in case you want to add it to an existing project, use the following code:

   MapsLib.searchrecords = new google.maps.FusionTablesLayer({
     query: {
       from:   MapsLib.fusionTableId,
       select: MapsLib.locationColumn,
       where:  whereClause
     },
     styleId: 2,
     templateId: 2
   });

For reference, styleId 1 is the default look - usually small red dots or red polygons. templateId 1 is the default info window that just shows the first few columns in your table.

For more information, see Working with styles and Working with templates in the Fusion Tables documentation.

I want to display custom icons on my map

By default, Fusion Tables only provides 10 (5 large and 5 small) marker icons.

         

From my understanding, this is for performance reasons (the map and icon tiles are cached). However, there are two ways to work around it:

1. Use some of the 200 additional icons provided by Google. This page gives a good tutorial.
2. Use the Fusion Tables API to fetch your data and then draw your own markers using the Google Maps v3 API. Take a look at this example (warning: more advanced programming ahead!)

My map works, but the results count returns 0

The results counter uses the Fusion Tables API, which requires an API key and some specific sharing permissions. Try the following in this order:

1. Make sure you set fusionTableId to a valid API key. It should look something like 1m4Ez9xyTGfY2CU6O-UgEcPzlS0rnzLU93e4Faa0. To get a new one, go to the Google API Console
2. Make sure that 'Allow Downloads' is checked for your Fusion Table (File => About this table => Edit table information)

Still can't figure it out or more detail needed?

Ask for help on our Fusion Table Map Template Google Group!

Bug fixes and pull requests

Notice a bug or want to add a feature? Open an issue or submit a pull request like so:

• Fork the project.
• Make your feature addition or bug fix.
• Commit and send me a pull request.

Contributors

• Derek Eder - primary contributor
• Chris Keller - recenter map on resize
• nb-ofs - Windows 8 touch screen ability, Google Maps Visual Refresh, Noscript message
• Felipe Figueroa - Geocomplete update, Updates to query function

Copyright and attribution

Copyright (c) 2014 Derek Eder. Released under the MIT License.

If you use this template, please provide the following attribution in the footer:

<a href='http://derekeder.com/searchable_map_template/'>Searchable Map Template</a> 
by <a href='http://derekeder.com'>Derek Eder</a>.

See LICENSE for more details.