generic header image

Geotab recap of Google Cloud Next 2018

Last updated on April 24, 2023 in Smart City by Mike Branch |  2 minute read

Table of contents

  1. Diving Deep

Neil Cawse and members of the Geotab Data & Analytics team presented at Google Cloud Next 2018. Read a quick overview and watch video.

San Francisco was buzzing this past week as 25,000 people descended on the city for Google Cloud Next 2018. Geotab was thrilled to be part of this tech conference, and was highlighted on Wednesday’s keynote session for its machine learning chops leveraging new AI tools publicly released this week by Google, along with eight other high-profile companies, including Bloomberg and 20th Century Fox.


Geotab has been part of Google’s early access program for BigQuery ML (BQML). At the conference, CEO Neil Cawse spoke during a spotlight session about how Geotab leverages the power of BigQuery not only for its traditional telematics business, but for new smart city solutions driven from over 1 million connected vehicles in the Geotab ecosystem.


Click below to watch the video: Rethinking Big Data Analytics with Google Cloud (Cloud Next' 18)


Not only does Geotab provide free and open access to a wealth of smart city data in our new insights portal, but with the new machine learning (ML) tools built into BigQuery, this gave us the power to showcase a new software solution that predicts particularly hazardous driving areas in a city based on weather and traffic flow.


What is Here is everything you need to know about the website.

Diving Deep

We got really technical and into the weeds during the deep dive talk by Google’s Chad Jennings, Geotab Data Solutions Manager Bob Bradley and Data Scientist Daniel Lewis. The presenters walked through a technical demonstration of how the solution was put together and what this means for a smart city.


See the full presentation below: How Geotab Drives Smart City Innovation, Using BigQuery (Cloud Next '18)


Geotab focused on two use cases focused around road safety in cities:


Use Case #1: Virtual Pneumatic Tubes in NYC

By drawing a simple line on a map, Geotab leveraged its data insight from the thousands of vehicles driving around New York City to provide an immediate snapshot of speed and hazardous driving areas at a hyper-local level in a school zone.


This provides immediate access to insight that can serve as a proxy for aggregate driving behaviour without having to deploy crews to place physical pneumatic tubes to measure traffic activity over short periods of time and then subsequently analyze the data produced.


The new BigQuery GIS tools announced by Google this week made all of this possible, allowing us at Geotab to use many common 


GIS functions that exist in PostGIS, but leveraging the scale of BigQuery.


Use Case #2: Using AI to Predict Hazardous Driving Areas in Chicago

In the second use case, leveraging the NOAA public dataset in BigQuery, we used a series of filters to adjust temperature, visibility, precipitation and traffic flow to predict potential hazardous driving areas in Chicago (based on areas where vehicles tend to harsh brake or experience accident-level events).


We found an interesting location that emerged near a school in the north end of Chicago where a particularly hazardous area was located on a street in close proximity to where children park their bicycles. In this specific area, the crosswalk and school zone signage was very far from the bike racks, not to mention the lack of a stop sign from an oncoming alley that connects to the street.


The analysis was made possible leveraging Google’s new BigQuery ML and is a perfect application to highlight potential at-risk areas for a city and promote data-driven decision-making. From here, a city might decide to move the bike rack area, provide more signage, or even place a stop sign in the alleyway approaching the street.


Between BigQuery ML and the new GIS tools available in BigQuery, Geotab is very excited to be collaborating with Google and these incredible technologies to help create better solutions for our customers and the community.


To learn more about the power of this collaboration and what it means to Geotab and our customers, be sure to check out this case study: Geotab: Turning data from vehicles into actionable insights.


More from this author:

Columbus Smart City Hackathon Showcases Talent, Data and Passion

Connected Cars Detect Mexico Earthquake

Geotab Data Shows Impact of Hurricane Harvey on Driving and Commercial Fleet Activity

If you liked this post, let us know!

Mike Branch

Mike Branch

As Geotab’s Vice President of Data and Analytics Mike Branch leads the development for solutions that enable insight from over 1.4 million connected vehicles and 30 billion telematics records that Geotab processes daily.



Geotab's blog posts are intended to provide information and encourage discussion on topics of interest to the telematics community at large. Geotab is not providing technical, professional or legal advice through these blog posts. While every effort has been made to ensure the information in this blog post is timely and accurate, errors and omissions may occur, and the information presented here may become out-of-date with the passage of time.

Get industry tips and insights

Sign up for monthly news and tips from our award-winning fleet management blog. You can unsubscribe at any time.

Republish this article for free

Other posts you might like

Illustration of an EV being charged

How long do electric car batteries last? What 6,300 electric vehicles tell us about EV battery life

Compare the average battery degradation for different vehicle makes and model years.

May 16, 2024

Transport trucks

In the Driver’s Seat: Mike Branch’s Insights from Geotab’s State of Commercial Transportation Report

Data insights are improving safety outcomes for organizations and people. Fleets using Geotab’s safety features have shown a 40% reduction in collision rates.

May 9, 2024

Graphic of blue and white transport trucks with wireless signals coming from them.

How Geotab Cloud ELD works

Geotab Cloud ELD is a reliable and secure fleet platform for tracking, managing, and sharing records of duty status (RODS). Learn how it works.

December 22, 2023

Geotab Connect Banner

Meet the Geotab Connect 2024 Marketplace innovators

Find out what’s in store in the Marketplace Exhibit Hall at this year’s Geotab Connect.

December 5, 2023