How to Apply the Fusion Tables Layer for Data Map Widget
The Data Map dashboard widget allows users to apply a Fusion Table Layer to display devices on the map based on information stored in a table created with the Google Fusion Table app. This lesson will go through the steps to apply that layer.
This lesson requires to user to have:
- A Dashboard created in Asset Vision.
- A Data Map widget created on that Dashboard. A base layer must already be applied to the Data Map widget.
- A table created in Google Fusion Tables where each record contains information on a device and at least one column contains the address of the device. The user must have access to the Google account that is storing the table OR the table id. The table must be viewable to the public.
Dashboard and Widget creation is covered in the Dashboard Management lessons.
Navigate to Dashboard Management
Navigate to Admin > Dashboard Management and search for the dashboard that the Data Map widget is on. This is the map widget that will have the Fusion Table Layer applied.
Select the Fusion Table Layer
After creating a Data Map widget the user is able to choose between different layers to apply to the map to show device locations. Multiple layers can be applied at once, and layers can be added, deleted, and edited in the settings menu of the Data Map widget. The user must have a base Data View layer if they decide to add a Fusion Table layer. The user should not delete that base data view layer while they have the Fusion Table layer.
For Data View layers Asset Vision uses Ip to Location mapping to determine where the icons will be displayed on the map. Information on Location Management and how to create an Ip to Location mapping can be found in the Location Management lesson.
If the Data Map widget already has a base layer applied, the user can select Fusion Table Layer from the dropdown menu. This will apply a layer on the map that will show device locations based on information in the table created with the Google Fusion Table app.
Google Credentials Prompt
After selecting Fusion Table Layer from the dropdown list and clicking OK, a popup will prompt the user to enter their credentials for the Google account where their table is stored.
If the popup is blocked, the user must enable the popup in their browser to log into their account and allow Scalable access to read the information in their tables.
If the user does not want to allow this access to Scalable, they can provide the Table Id instead. If the user signs in and accepts then they will be able to view existing Tables and Location columns in the Fusion Table Layer properties form.
Fusion Table Layer Properties
These are the fields for a Fusion Table Layer:
- Name: Unique identifier for the layer. This name will not appear on the map.
- Icon: Picture that will be displayed on the map to represent a device location.
- Table Id: The Id of the table created with the Google Fusion Table app. The user can provide this information if they do not want to give Scalable access to read their Fusion Tables.
- Location Column: Column that will be used to determine the device's location.
As noted in the picture above, the table must be viewable to an outside party, meaning it cannot be private.
Viewing the List of Supported Icon Images
Clicking the link under the info section in the Fusion Table Layer form will bring up a new window in the user's web browser that will show the supported icon images for Google Maps.
Obtaining the Table Id
To obtain the table Id, navigate to the table in the Google Fusion Table application.
Select File > About this table
- Go to File
- Select About this table
Copy Table Id
- Copy the Id listed.
Data Map Widget with Fusion Table Layer Applied
Once the user saves the filter and exits out of the Data Map settings they will see the Data Map widget with the Fusion Table layer applied. The user can zoom in to view device locations that are close to each other.