3 of 18

First, make sure you’re in the right place

You’re already a Fusion Tables user.
You’ve made maps with Fusion Tables in the past.
You need/want to migrate your maps off Fusion Tables.
You have your Fusion Tables maps ready to work with in this session.
Most of this session will be Q&A and free work time (some presentation).
You know Fusion Tables is shutting down on December 3.

#GeoForGood19

4 of 18

Quick recap

9+ years ago: Fusion Tables launches as a research project in Google Labs.
Long time ago: Internally, we tried to figure out how to deprecate Fusion Tables.
December 11, 2018: We finally announced the deprecation of Fusion Tables.
September 10, 2019: Announced the FT Archive Tool (more on that shortly).
December 3, 2019: Fusion Tables will shutdown.

#GeoForGood19

5 of 18

Meet the Fusion Tables Archive Tool

g.co/fusiontables

We've partnered with our friends at Ubilabs to create a new open source tool built to preserve maps generated with Fusion Tables.

#GeoForGood19

6 of 18

Demo

g.co/fusiontables

#GeoForGood19

7 of 18

How it works

1.	The data for each table is saved to its own "archive". The data will be saved in a Google Sheet; for datasets beyond the size limits of Sheets, you'll get a CSV. This archive is stored in a top level folder called "ft-archive" in your Drive.

g.co/fusiontables

#GeoForGood19

8 of 18

How it works

2.	A Google Maps visualization is automatically created with the archived data. This map preserves many of the original Fusion Tables styling configurations. Any changes you make to the Sheet or CSV will appear in the map visualization.

g.co/fusiontables

#GeoForGood19

9 of 18

How it works

3.	A listing of all archived tables is stored in a Sheet. This handy Sheet is called "ft-archive-index" and lives within the "ft-archive" folder. The index Sheet summarizes each run of the archive tool and preserves the visualization URLs with encoded styles. Each time you run the archive tool, you’ll get additional archives based on the current data in your tables along with corresponding new rows in the archive directory.

g.co/fusiontables

#GeoForGood19

10 of 18

Preview and embed a map

1	You can preview a map visualization in the archive tool, and when you're ready to share, generate a code snippet to embed your map.
2	If you want to embed the map on your site, you must get an API key. If you're a journalist or nonprofit, you may be eligible for free or reduced cost usage.
3	Certain features of Fusion Tables, notably geocoding, will not be supported by this tool. See this FAQ for more limitations: goo.gle/archivetoolfaq

g.co/fusiontables

#GeoForGood19

11 of 18

Demo: Create and embed a map

g.co/fusiontables

#GeoForGood19

12 of 18

Demo: Create and embed a map

<head> <title>Example Fusion Tables Embed</title></head>

<body>

Here is my map.

<style>

#fusiontable-map {width: 100%; height: 100%}

body.cursor-pointer .gm-style > div {cursor: pointer !important;}

</style>

var containerSelector = '#fusiontable-map';

var apiKey = 'AIzaSyBfeQcuG_czvsd579_qGGhskkkYSW3gM80';

var url = new URL(window.location);

var docid = url.searchParams.get('docid');

var wa_counties_sheet = '1R59SFIgSNHZpmTzjnW-AywEgoRj14zfDMRa2Ib-U4VI';

var fileId = docid || wa_counties_sheet;

var style = {marker:{icon:'small_red'},polyline:{strokeColor:{color:'#ff000080'},strokeWeight:{weight:2}},polygon:{fill:{color:'#ff000080'},strokeColor:{color:'#666666ff'},strokeWeight:{weight:1}}};

fusiontablesArchiveEmbed(containerSelector, apiKey, fileId, style);

</script>

</body>

#GeoForGood19

13 of 18

Visualizations with deck.gl

The archive tool takes advantage of deck.gl, an open source data visualization library specifically designed for mapping. At this year’s Google I/O, we announced deck.gl support for the Maps JavaScript API, offering custom, high-performance data visualization. To learn more, see the documentation for deck.gl's Google Maps module.

g.co/fusiontables

#GeoForGood19

14 of 18

Limitations

1	Geocoding is not supported
2	Watch out for very large tables
3	Some custom styles may not be preserved
4	Custom info window styles via templates are not supported

goo.gle/archivetool-faq

#GeoForGood19

15 of 18

Open source

1	We've open sourced the export and visualization code:�goo.gle/archivetool-export goo.gle/archivetool-viz
2	The export code will stop working on December 3, when Fusion Tables shuts down.
3	The visualizer will continue to be available for at least a year after this date.

goo.gle/archivetool

#GeoForGood19