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.
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.
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 FunctionsSample 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.
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.
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.
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 FunctionsPlay
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.
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.
Multiple map visualization options are available with this button.
Figure 1.4: Map visualization option drop down menu.
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.
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 functionsColour Scaling
This must be selected for the colour bar to successfully appear on the map.
This option can be selected to reverse the display of the color bar
This option will display distinct valued gradient color bar.
Colour Value Min/Max
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.
Radius Scaling Column
This option can be selected to set the max and min values on the colour bar. The value will default between 1 and 10.
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.