RichTracks
Field | Short Description |
Id | unique id of rich track |
TrackToken | Track Token |
DeviceToken | Device Token |
IncomingTrackId | Incoming track id |
StartDate | Start Date |
EndDate | End Date |
Distance | Distance in km |
Duration | Duration in minutes |
AccelerationCount | Acceleration Count per Track |
DecelerationCount | DecelerationCount per Track |
Rating | 5-star Scoring |
PhoneUsage | Phone Usage in minutes |
TrackOrigin | Track source from application or Machine Learning |
OriginChanged | Flag of changing track source |
AddressStart | Address Start from Here |
AddressFinish | AddressFinish from Here |
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 RatingOverSpeed |
RatingAcceleration | 5-star RatingAcceleration |
RatingPhoneUsage | 5-star RatingPhoneUsage |
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 | Id of company |
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 RatingDeceleration |
MaxSpeed | Average Speed (km/h) |
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 | Euclidean norm of the difference between enriched and incoming points in meters |
deviationmeters | Euclidean norm of the difference between enriched and incoming points in meters |
vehicletoken | Vehicle Token |
datecreated | date of creation in DB |
Last updated