Fusion Table Searchable Map Template

No longer working Google shut down Fusion Tables on Dec 3rd, 2019. This template no longer functions.

However, I have since created two new mapping templates that do work based on this one:

• Searchable Map Template - Carto - For large datasets. Requires a CARTO account (which you'll likely have to pay for).
• Searchable Map Template - Turf - For smaller datasets. Does everything in the browser and is free.

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, iframe and content templates
• display up to 100,000 map points
• address search (with variable radius and geocomplete)
• geolocation (find me!)
• results count
• RESTful URLs for sharing searches
• ability to easily add additional search filters (checkboxes, sliders, etc)
• mobile and tablet friendly using responsive design
• built with HTML, CSS and Javascript - no server side code required

Releases

• v 1.5 - HTTPS support, Fusion Tables API v2
• v 1.4 - iframe template, MapsLib class
• 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

Dependencies

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

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 »

Setup

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 that 'Allow Downloads' is checked for your Fusion Table (File => About this table => Edit table information)
4. Create your own Google API key to replace the default in the Map Options section of the index.html file above. By inserting your own key, you will be able to use your map on domains other than *.github.io.
   1. Follow these instructions to get a Google API key.
   2. You will need to make sure that the Places API, Maps JavaScript API, Geocoding API and Fusion Tables API are all enabled for your project.
   3. Note You’ll need to enable billing with a credit card and have a valid API key for all Google API projects, including this one.
5. Download or clone this project and fire up your text editor of choice. Open up index.html and set your map options at the bottom of the file (see the full list of options)
   1. fusionTableId - the ID of your Fusion Table (found in Fusion Tables under File => About this table)
   2. googleApiKey - your Google Cloud Platform API key
   3. locationColumn - the name of your location column in your Fusion Table
   4. map_center - the lat/long you want your map to center on (find yours here)
   5. locationScope - the area you want to limit searches to (set to 'chicago' by default)
6. Replace the API key on this line of index.html with yours: <script type="text/javascript" src="https://maps.google.com/maps/api/js?v=3.37&libraries=places&key=[YOUR KEY HERE]"></script>
7. 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.
8. Upload this map and all the supporting files (css, fonts, images and js folders) to your site

MapsLib options

You can configure your map by passing in a dictionary of options when you create a new MapsLib instance in index.html or index_iframe.html. Here's an example:

var myMap = new MapsLib({
  fusionTableId:      "1m4Ez9xyTGfY2CU6O-UgEcPzlS0rnzLU93e4Faa0",
  googleApiKey:       "AIzaSyA3FQFrNr5W2OEVmuENqhb2MBB2JabdaOY",
  locationColumn:     "geometry",
  map_center:         [41.8781136, -87.66677856445312],
  locationScope:      "chicago"
});

Option	Default value	Notes
fusionTableId		Required. Table ID of your Fusion Table (found under File => About).
googleApiKey		Required. Found at https://developers.google.com/maps/documentation/directions/get-api-key The key provided in this template is for demonstration purposes only. You will need to register your own for your map to work on domains other than *.github.io.
map_centroid		Required. Center [latitude, longitude] that your map defaults to.
recordName	record	Used for showing the count of results.
recordNamePlural	records
searchRadius	805	Default search radius. Defined in meters. Default is 1/2 mile.
locationColumn	geometry	Name of the location column in your Fusion Table. If your location column name has spaces in it, surround it with single quotes like this "'my location'".
locationScope		Appended to all address searches to keep results within a geographic area.
defaultZoom	11	Default zoom level when map is loaded (bigger is more zoomed in).
addrMarkerImage	images/blue-pushpin.png	Image used to identify your address search on the map. Setting it to blank ("") will hide the marker.

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 modify 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; }

FusionTable-Map-2-layers

If you want to create a map with two layers - one with points and another with polygons, take a look at Jack Dougherty's FusionTable-Map-2-layers, based on this template. It's a great place to start.

Resources

Fusion Tables

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

Community

• Fusion Table Map Template Google Group
• 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 do 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:

1. Fork the project.
2. Make your feature addition or bug fix.
3. 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, maps_lib.js javascript class

Copyright and attribution

Copyright (c) 2015 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.