How to get started with Geotab Ignition | Geotab Quick Start Guide

Preface

The purpose of this Guide is to familiarize users with Geotab Ignition. Geotab Ignition uses Standard SQL, which is similar to most SQL languages. More information on SQL syntax can be found here.

Please refer to our Intelligence Data White Papers for detailed use cases pertaining to the datasets found in Geotab Ignition.

Login and Registration

Please click here to log in and register for Geotab Ignition. If you have successfully entered the site, continue to the Console Editor section below.

Existing MyAdmin and MyGeotab Customer Login

Select the Login option to enter

  • For MyAdmin users, enter your email and password and click the Login button to access Geotab Ignition.
  • For MyGeotab users, check the Existing MyGeotab Customer checkbox, enter your email, password and the database, and click the Login button to access Geotab Ignition.

New Customer Registration

Select the Register option, enter the requested details, and click the Register button. 

A verification email will be sent to the registered email account. Please verify your account by clicking the link found in the email. Once verified, the account will be activated and a confirmation email will be sent as notification.

Once the terms and conditions have been agreed upon, access to Geotab Ignition is granted.

Console Editor

Once logged in, you are directed to the Console Editor.

Here, you can write SQL queries to access the available data and visualize it as needed. Please note that a geography column must be specified in the query to visualize the data.

Queries are auto validated concurrently when written. Once the query is validated the Run Query and Visualize buttons get activated.

Figure 1.1: Geotab Ignition view upon initial login. 

Datasets

Available datasets are located on the left navigation menu. Dataset descriptions are available by hovering over each on the navigation menu.

If needed, additional information is available by clicking the More Information button, as shown in Figure 1.2 below. This button opens the corresponding dataset page in a new tab on data.geotab.com.

Dataset descriptions, preloaded queries and a table preview are also available by clicking each dataset, as shown in Figure 1.3.

Figure 1.2: Hover example of Fuel Station Metrics dataset description and More Information button.

Figure 1.3: Dataset selection example showcasing the Fuel Station Metrics dataset description, preloaded queries and table preview.

Console Editor Button Functions

Sample Queries


This button populates a list of preloaded queries for each of the datasets, making it easily accessible to all levels so that even a beginner level user can start querying with Geotab Ignition. Click on one of the queries to populate on the Console Editor.


Run Query


This button will remain inactive (grey) until the query is validated. Once activated, the button turns blue, click the button to run the query and populate the data successfully.


Visualize


This button will only activate if a Geography type column is present in a valid query. Once activated, the button turns blue, click the button to display the data on the Visual Tool successfully.


Previous & Next


Previous & Next button can be used for pagination to see the queried data successfully on the Console Editor.


Visual Tool

The Visual Tool populates queried data points once the Visualize button on the Console Editor has been selected. Queries can be edited and customized via the query editor found on the left navigation panel.

Visual Tool Button Functions

Play


This button should  be used to reload the map when changes have been made in the queries. It will blink and prompt on every successful query change.


Full screen


This button is used to show the map on the entire screen. The left navigation panel is hidden in this mode until the Exit button is pressed.  


Zoom to Data Bounds


This button zooms into the location on the map where data points appear.


Map Options

Multiple map visualization options are available with this button.

Figure 1.4: Map visualization option drop down menu.

Geography Panel

Geography columns must be selected for the data points to successfully appear on the map. It can be used to switch between more than one Geography option if applicable.

Style Panel

The Style Panel is located on the left navigation panel. It can be used to customize the displayed data and contains multiple options to create an appealing and engaging data points map.

Figure 1.5: Visual Tool with Geography and Style Panel displayed.

Style Panel functions

Colour Scaling


This must be selected for the colour bar to successfully appear on the map.

Reverse Colours


This option can be selected to reverse the display of the color bar

Categorical Mode


This option will display distinct valued gradient color bar.

Opacity Slider


This option can be used to customize the opaqueness of the data points on the map. The opacity value can also be directly entered into the value box beside the slider. The value must never be 0 as that would make all the data points disappear.

Colour Value Min/Max


This option can be selected to set the max and min values on the colour bar. The value will default  between 1 and 10.

Radius Scaling Column


This option allows for the customization of the size of the datapoint of the column that you want to display. The radius can also be directly entered into the value box beside the slider.

Data Insight Reading

Looking for guides and resources to help understand the value of big data? You've come to the right place.

Performance Benchmarking with Big Data

The value of big data lies in how well an organization is able to draw insight from data and turn it into measurable revenue generation or cost savings. Discover how with benchmarking data.

Read now

Big Data and the Smart Fleet Revolution

Discover how the smart fleet movement is happening now. The Internet of Things (IoT) is expanding rapidly, and this includes increasing connectivity in the automotive realm.

Read now

Are You Getting the Most out of Your Data?

Data is increasingly important to business in every industry – especially fleet management. Learn how telematics comes into play and how you can get the most from your data.

Read now