Processed telematics data - Offline Reporting

📘

Note

Processed telematics data contains information about tracks, points, and events after road mapping, events detection and filtering, scoring and other ML enrichments

Example of extracted zip for a given date:

📘

Note

Processed telematics data also can be exported to Amazon S3 or Google Cloud in zip for a specific date; zip file contains csv files that are described below
Instruction on how to set up data export

CSV Tables Description

Table name

Short description

TripSummary
:point-right: Description
:page-facing-up: Dataset

A list of processed trips with statistics and safe scoring.
What's there?

  • Final track entity based on RichTrackPoints
  • Safe score
  • Trip metrics
  • Trip events metrics
  • Start address
  • End address

TrackPoints
:point-right: Description
:page-facing-up: Dataset

Processed track points (waypoints)
What's there?

  • Track matching to road graph
  • Speed limits
  • Events matched to points
  • Phone usage (ML)
  • Rotation calculated (ML)

TrackEvents
:point-right: Description
:page-facing-up: Dataset

Processed and filtered events
What's there?

  • Events JSON parsing
  • Mapping phone usage to events
  • Calculating the index - fitstresholds (ML)

ScoringSummary
:point-right: Description
:page-facing-up: Dataset

User safe driving score and fine points calculation that is used as a basis for the safe driving score calculation
What's there?

  • Aggregated scores for 2-weeks period

UserState
:point-right: Description
:page-facing-up: Dataset

UserState report contains information about active users:

  • Personal info
  • Sensor's status
  • OS versions

Fraud
:point-right: Description
:page-facing-up: Dataset

Fraud contains information about suspicious events like:

  • Low power mode
  • GPS switch off
  • Mobile data switch off

VehicleSummary
:point-right: Description
:page-facing-up: Dataset

Vehicle summary report contains information about vehicles connected to DeviceToken and mileage information for given period

CoinsSummary
:point-right: Description
:page-facing-up: Dataset

The CoinsSummary report contains data on the total amount of coins and bonuses to users for the reporting period.

Trips

Trips data to create BI reports


Trip Summary

Field

Short description

Additional information

DeviceToken

Unique user id

ClientId

Unique user id set up by client

Email

Email of the user

TripId

Unique id for enriched trip;
equals to tracktoken

TripStartUtc

Start date of the trip in UTC

TripEndUtc

End date of the trip in UTC

TripStartLocal

Start date of the trip

TripEndLocal

End date of the trip

LocalTimeOffset

Timezone of the user location

StartLatitude

Start point Latitude

StartLongitude

Start point Longitude

FinishLatitude

Finish point Latitude

FinishLongitude

Finish point Longitude

DistanceKm

Trip distance in km

DurationMinutes

Trip duration in minutes

AverageSpeedKmh

Average speed in km/h

TripMode

Type of trip

ClassificationConfidence

Probability of UserLabel model estimation

UserLabel

Role of user in trip

OverallPoints

Overall penalty points for trip

AccelerationPoints

Acceleration penalty points for trip

BrakingPoints

Braking penalty points for trip

CorneringPoints

Cornering penalty points for trip

SpeedingPoints

Speeding penalty points for trip

DistractionPoints

Distraction penalty points for trip

StartRatingOverall

5-star rating of the trip

StartRatingAcceleration

Acceleration 5-star rating of the trip

StartRatingBraking

Braking 5-star rating of the trip

StartRatingCornering

Cornering 5-star rating of the trip

StartRatingSpeeding

Speeding 5-star rating of the trip

StartRatingDistraction

Distraction 5-star rating of the trip

NightTimeDrivingMinutes

Night time driving during the trip

AddressStart

Address of start

AddressFinish

Address of finish

UserTags

User tags

InstanceId

5-star Safe Score rating

TrackPoints

(Drive -> 1 file = 1 track's points)

Field

Short description

Additional information

PointDate

Point time

Latitude

Latitude (processed)

Longitude

Longitude (processed)

MidrouteGPS

Distance between previous and current point

Speed

Speed at point, in km/h

SpeedLimit

Speed limit at point, km/h

Distraction

1 - Phone usage
0 - No Phone usage

TrackToken

Unique identifier of trip

you can join with Trip Summary on this field

TrackEvents

(Events -> 1 file = 1 track's events)

Field

Short description

Additional information

PointDate

Datetime of event

Latitude

Latitude of event

Longitude

Longitude of event

AlertType

Type of event

  • Acc
  • Deacc

AlertValue

Force of event

m/s2

TrackToken

Unique identifier of trip

Scoring Summary

Field

Short description

Additional information

Devicetoken

Unique user id

ClientId

Unique user id set up by client

Email

Email of the user

Date

Date of calculation

scoreacceleration

2-week acceleration score

Part of safe score

scoredeceleration

2-week braking score

Part of safe score

scorespeeding

2-week speeding score

Part of safe score

scoredistraction

2-week phone usage score

Part of safe score

scoreturn

2-week cornering score

Part of safe score

ScoreOverall

2-week total safe score

calculation of 5 scores above

DistanceKm

Distance for 2-weeks period

km

TripAmount

Number of trips for 2-weeks period

DurationMinutes

Duration of trips for 2-weeks period

min

AccelerationPoints

Acceleration penalty points for 2-week period

Part of total points

BrakingPoints

Braking penalty points for 2-week period

Part of total points

SpeedPoints

Speed penalty points for 2-week period

Part of total points

DistractionPoints

Phone usage penalty points for 2-week period

Part of total points

TurnPoints

Cornering penalty points for 2-week period

Part of total points

TotalPoints

total penalty points for 2-weeks period

Total number of fine points from the 5 rows above

InstanceId

Unique id for instance

UserState

Field

Short description

Additional information

DeviceToken

User's ID

Email

Email of the user if registered

ClientId

Client's user id

FirstName

First Name

LastName

Last Name

NickName

Nickname

Wifi

Is wi-fi switched on?

On/off

GPS

Is gps switched on?

On/off

DataTransfer

Is datatransfer switched on?

On/off

DeviceOS

OS version of user's mobile phone

InstanceId

Instance Id

Fraud

Field

Short description

Additional information

DeviceToken

User's ID

ClientId

Client's user id

Email

Email of the user if registered

EventDate

Date of event

EventType

Type of event

Example:
'low battery'

InstanceId

Instance Id

VehicleSummary

Field

Short description

Additional information

DeviceToken

User's ID

ClientId

Client's user id

Email

Email of the user if registered

VehicleToken

Vehicle token if registered

VehicleId

Vehicle id if registered

Mileage

Mileage for a given period

km

MileageTotal

Total mileage to MileageDate

MileageDate

Date of last mileage total update

MileageInitial

Initial mileage for a given period

InstanceId

Instance Id

CoinsSummary

Field

Short description

Additional information

Date

Accrual date

DeviceToken

Unique id of user

Balance

Total Coins at the beginning of reporting period

Coins

Coins earned at reporting period

TotalCoins

Total Coins at the end of reporting period

LimitReached

Is limit reached?

Yes/no

InstanceId

Instance Id


Did this page help you?