Processed telematics data format

Introduction

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

Table name	Short description
Track Enrichment Finished 📄 Dataset	ℹ️ This JSON file you will get from API when you subscribed on TrackEnrichmentFinished event. 👉 More about data export
Rich tracks 👉 Description 📄 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
RichTrackPoints 👉 Description 📄 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)
RichTrackEvents 👉 Description 📄 Dataset	Processed and filtered events What's there? Events JSON parsing Mapping phone usage to events Calculating the index - fitstresholds (ML)
RichTrackDetails 👉 Description 📄 Dataset	Trip safe driving score and fine points calculation that is used as a basis for the safe driving score calculation What's there? Aggregated points for 2-weeks period Scores for track in 100-scale
UserStatisticDrivingDetails 👉 Description 📄 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

Rich tracks

Field	Short description	Additional information
Id	Unique id of rich track
TrackToken	Unique Track Token
DeviceToken	Unique user id	User-service
IncomingTrackId	Unique Incoming track id (Raw track id)
StartDate	Start date of the trip
EndDate	End date of the trip
Distance	Trip distance in km
Duration	Trip duration in minutes
AccelerationCount	A number of acceleration events during the trip
DecelerationCount	A number of braking events during the trip
Rating	5-star Safe Score rating
PhoneUsage	Phone Usage in minutes
TrackOrigin	Track source from application or Machine Learning
OriginChanged	Flag of changing track source
AddressStart	Address Start
AddressFinish	Address Finish
DistanceGPS	DistanceGPS - distance based on enriched data km
Urban	City Flag; 1-City; 0-rest
Region	Region from start point
Country	Country from start point
RatingOverSpeed	5-star Speeding rating
RatingAcceleration	5-star Acceleration rating
RatingPhoneUsage	5-star Phone usage ration
OverSpeedMileage	Mileage with 10-20 OverSpeed in km (over km/h)
MidOverSpeedMileage	Mileage with 20-30 OverSpeed in km (over km/h)
HighOverSpeedMileage	Mileage with 30+ OverSpeed in km (over km/h)
OriginalTrackOrigin	If track origin is changed; original track origin moves to this field
CompanyId	Unique company id
RushHours	Driving time in rush hours in minute (8-10, 17-19)
NightHours	Driving time in night hours in minute (23-6)
DailyHours	Driving time in other hours in minute
RatingDeceleration	5-star Braking Rating
MaxSpeed	Maximum detected speed (km/h) within the trip
AverageSpeed	Average Speed (km/h)
PhoneUsageKm	Phone Usage in km shared 1 if ride is shared with other user
citystart	Start City
cityfinish	Finish City
updatedt	date of update in DB
corneringcount	Number of cornering within the trip
ratingcornering	5-star RatingCornering
beaconid	Unique device ID
deviationmeters	Euclidean norm of the difference between enriched and incoming points in meters
vehicletoken	Unique vehicle ID	Car-service
datecreated	date when the trip was received and created in the DB

Rich track points (waypoints)

Field	Short description	Additional information
id	Unique if of point
RichTrackId	RichTrackId
Number	Number of point in track
TotalMeters	Distance since start of track enriched (meters)
Speed	Speed in point (km/h)
MidSpeed	Average speed since previous point (km/h)
PointDate	Point time
Latitude	Latitude (processed)
Longitude	Longitude (processed)
Height	Height from GPS
Course	Course from GPS
Yaw	Yaw from GPS
Lateral	Lateral acceleration
AlertType	AlertType acceleration - for acceleration; deacc for Braking
AlertValue	Value of acceleration/ braking in m/s2
SpeedType	Speed type for colouring map	Level 1; Level 2; Level 3
SpeedLimit	Speedlimit in km/h	Source: External location platform
PhoneUsage	Phone usage: 1- true.
Acceleration	Acceleration front value of acceleration in m/s2
Deceleration	Braking front value of deceleration in m/s2
TickTimestamp	Timestamp
Urban	Flag of city
FromSource	Original or added by processing of the point
LinkIdMatched	external partner match id
TypicalSpeed	Typical and average traffic speed for this point	Source: External location platform
RoadType	Road Type	Source: External location platform
Midroute	Distance since previous point
Interval	Duration since previous point
Turn	Turn flag (left - right - no turn)
LaneCount	Lane Count Number of lanes on the road	Source: External location platform
SpeedLimitSource	External partner id	Source: External location platform
TotalMetersGPS	Distance since the start of the trip
MidrouteGPS	Distance since previous point original
DeviceToken	Unique user id
CompanyId	Unique company id
Cornering	1 - true
Rotation	Rotation in point
Deviation meters	Deviation from associated incoming points
s2index	Index of google s2 cell; 16-level
eventid	Unique event id
straightroad	1 if curvature of the road is >= 1700

Rich Track Events

Field	Short description	Additional information
id	Unique event ID within the trip
richtrackid	Unique trip id after processing
type	type of event: Acceleration Braking Cornering
timestart	time of event start
durationms	Duration of the event with all gaps between acceleration points in ms
puredurationms	Duration of points with acceleration >= threshold in ms
speedstart	GPS speed at the beginning of event
speedstop	GPS speed at the end of event
speedmedian	Median GPS speed during event
Accelerations	Type: Direct - in direction of movement Lateral - perpendicular to the movement direction Vertical - vertical acceleration Calc type: Without postfix - at the beginning of event min - minimum during event max - maximum during event end - at the end of event 05 - 5%-quantile during event 95 - 95%-quantile during event median - 50%-quantile during event
Accuracy	GPS accuracy during event Calc type: Without postfix - at the beginning of event min - minimum during event max - maximum during event end - at the end of event 05 - 5%-quantile during event 95 - 95%-quantile during event median - 50%-quantile during event
Speed	GPS speed during event Calc type: Without postfix - at the beginning of event min - minimum during event max - maximum during event end - at the end of event 05 - 5%-quantile during event 95 - 95%-quantile during event median - 50%-quantile during event
LatitudeStart	Latitude of event start
LongitudeStart	Longitude of event start
LatitudeFinish	Latitude of event finish
LongitudeFinish	Longitude of event finish
PhoneUsagePoints	Indicator of phone usage in this event; based on ML algorithm; if 1 then event is ignored; 1-false
fitstresholds	Indicator of event adequacy; based on ML algorithm; 1-we use event

Rich Track Details

Field	Short description	Additional information
Richtrackid	Id of rich track
id	id of detail
devicetoken	user’s device token
avglat	Average Latitude of track
avglon	Average Longitude of track
startlat	Start Latitude of track
startlon	Start Longitude of the track
finishlat	Finish Latitude of track
finishlon	Finish Longitude of track
starts2index	Google s2 start index of track (16 level)
finishs2index	Google s2 end index of track (16 level)
accpoints	Acceleration penalty points
deaccpoints	Deceleration penalty points
speedpoints	Speeding penalty points
phonepoints	Phone Usage penalty points
corneringpoints	Cornering penalty points
totalpoints	Total penalty points

User Statistic Driving Details

📘
This table contains safe driving score information and the basis for its calculation.
👉 more

Field	Short description
Devicetoken	Unique user id
calcdate	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
Score	2-week total safe score	calculation of 5 scores above
accpoints	Acceleration penalty points for 2-week period	Part of total points
deaccpoint	Braking penalty points for 2-week period	Part of total points
speedpoints	Speed penalty points for 2-week period	Part of total points
phonepoints	Phone usage penalty points for 2-week period	Part of total points
corneringpoints	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

Updated 5 days ago