Are you familiar with Fusion Tables?

A few weeks ago, my wife and I, along with three other couples, attended the Vineyards of Swan Creek Spring Herb Festival. While we were in the YadkinValley, we wanted to visit some other nearby wineries.

In order to see where other wineries in the area were located, I created a Google Fusion Table and displayed the data on an interactive map (clicking on the graphic below will open the interactive map):

Wineries Map

The green pushpins represent the five vineyards that participated in the Herb Festival, the yellow pushpin our hotel and the red pushpins other wineries in the area. Clicking on any pushpin will display information about that location.

Why is this relevant?

By now, you’re probably thinking this is nice, but what if I don’t care about visiting wineries?

Perhaps you don’t have a GIS system and you’re interested, as one Logics customer was, in knowing where you have radio read meters installed and where you still have manual read meters?

Would it be helpful to see, on a map, where water main leaks have been reported?

Or maybe you’ve wondered if your meter reading routes are as efficient as they could be. Wouldn’t being able to see them visually on a map be helpful?

Creating a Fusion Table

Creating a Fusion Table is as easy as exporting data from a spreadsheet as a comma-separated values (CSV) file and uploading it to Google. For my winery map example, I used the name of the vineyard, location, phone number and icon style (to display the green, yellow and red pushpins).

One quirk of Fusion Tables is the location must be all in one column – it won’t accept Address, City, State and Zip Code in separate columns as they are stored in most databases. To remedy this, use the concatenate function in Excel.

Let’s assume you have a spreadsheet with Address in column A, City in column B, State in column C and Zip Code in column D. The following formula will merge them into a single field in another column:

=CONCATENATE(A2, ” “, B2, “, “,C2, ” “, D2)

Fusion tables allow for 10 icon (pushpin) styles – two sizes (large and small) and five colors (yellow, green, blue, purple and red). The icon style must be defined in your data or they can be dynamically assigned by ranges of numeric values. Unfortunately, they can’t be dynamically assigned by non-numeric data.

Viewing the data

Once the data has been imported into a Fusion Table, it can be viewed in one of three formats – rows, cards or on a map. The row view is displayed in a grid, much like a spreadsheet. The cards view reminds me of a rolodex card and the map view is just what you would expect.

Give it a try!

Go ahead – create your own Fusion Table and experiment with it. You will have to have a Google Account (you already have one if you have a Gmail e-mail address).

Once you have a Google Account, just follow this tutorial to start creating your first map. It’s as easy as that!


If you’ve got questions about using Fusion Tables, feel free to give me a call at 919-232-2320 or e-mail me at

Click here to subscribe to my free, bi-weekly e-mail newsletter...

© 2014 Gary Sanders

Are you taking advantage of mapping?

Smartphones with GPS capability and online mapping applications have made finding addresses an easy task. Does your utility take advantage of any of the many electronic mapping applications that are available?

Geographic information systems

Many utilities have implemented Geographic Information Systems (GIS) to replace their reliance on paper maps. In addition to creating digital images of paper maps, GIS maps include attributes of each mapping layer.

These attributes can include such things as water line size, pipe material and year installed. Or for a valve, the attributes might include manufacturer, model, year purchased and direction the valve opens.

Online mapping applications

Even if your utility hasn’t implemented a Geographic Information System, several online options exist for locating an address.

Google Maps, Mapquest and Bing Maps all will display a map of an address, using nothing more than the address itself. They also will provide turn-by-turn driving directions to the address.

Integrated mapping

Some utility billing systems have integrated mapping within their billing software. Logics’ Utility Management system is one such application.

Below is a screen shot of the Mapping tab from the Account Console of Logics’ Utility Management system. Clicking on the image will open a larger image in a new window.

Account Console Mapping Tab

As you can see, the system displays a map with a push pin at the exact service address.

GIS Integration

Meters are often the last layer added to a GIS system, and they represent the point at which billing software and GIS systems intersect. For a utility with a GIS system mapped all the way to the meter level, the above map could be replaced by their GIS map.

Interested in integrating maps with your billing system?

If you are interested in learning more about integrating maps, either Google maps or your GIS system, with your billing system, please give me a call at 919-232-2320 or e-mail me at

Click here to subscribe to my free e-mail newsletter

© 2013 Gary Sanders