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.
Geotab Ignition login screen
  • 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.
Geotab Ignition login screen

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.

Geotab Ignition register screen

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.

Geotab Ignition Console Editor

Figure 1.1: Geotab Ignition view upon initial login. 


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

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

Geotab Ignition Console Editor

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

Geotab Ignition Console Editor

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.

Sample Queries button

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.

Run Query button


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.

Visualize button

Previous & Next

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

Previous and Next buttons

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


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.

Play button

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.  

Full Screen button

Zoom to Data Bounds

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

Zoom to Data button

Map Options

Multiple map visualization options are available with this button.

Map Options button and menu

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.

Choose Geography Column dropdown

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.

Style Panel

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.

Choose color scaling menu
Reverse Colours

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

Choose color scaling menu with Reverse Colours selected
Categorical Mode

This option will display distinct valued gradient color bar.

Choose color scaling menu with Categorical Mode selected
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.

Opacity Slider
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.

Colour Value Min/Max input and selection
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.

Radius scaling column

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