DB Traffic Summary

Traffic Summary Table

Contains information about the vehicle passes, including start and end times for each load event, gear configuration, applied loads (actual), and wander position.

 

Traffic_ID

Unique number assigned to a traffic event. An event is defined as a movement of the vehicle with loads.

Track_ID

Track number defining the lateral position of the vehicle during event EventNo. There are 9 track numbers ranging from [-4, 4] as defined in the Track table.

EventStartTime

Date and time of the start of a traffic event. Dates are given in the format MM/DD/YYYY. Time is local time (New Jersey, USA).

EventEndTime

Date and time of the end of a traffic event. Dates are given in the format MM/DD/YYYY. Time is local time (New Jersey, USA).

AvModuleLoadsLB

Average module loads corresponding to traffic event EventNo (lbs.). Values are given as a string of 10 comma-delineated values as follows: Carriage 1 Module 1, Carriage 1 Module2, …, Carriage 1 Module 5, Carriage 2 Module 1, Carriage 2 Module 2, …, Carriage 2 Module 5. For certain events, different sets of loads were applied to two different test items. In such cases, two comma delineated strings may be given, separated by a semicolon. The first string applies to test item MRS-2 and the second string to test item MRS-3. Note that a load module consists of two wheels. To obtain the wheel load, divide the module load by 2.

AvTirepressureCarriage1PSIM2TireAM2TireBM3TireAM3TireB

Average tire pressures recorded for modules 2 and 3 on Carriage 1, for traffic event EventNo (psi). Values are given as a string of 4 comma-delineated values, corresponding to the 4 tires making up the 4-wheel gear. For certain events, different sets of loads were applied to two different test items. In such cases, two comma delineated strings may be given, separated by a semicolon. The first set of tire pressures applies to test item MRS-2 and the second set to test item MRS-3. Note that these values may vary from the target values indicated in table Gear.

AvTirepressureCarriage2PSIM4TireAM4TireBM5TireAM5TireB

Average tire pressures recorded for modules 4 and 5 on Carriage 2, for traffic event EventNo (psi). Values are given as a string of 4 comma-delineated values, corresponding to the 4 tires making up the 4-wheel gear. For certain events, different sets of loads were applied to two different test items. In such cases, two comma delineated strings may be given, separated by a semicolon. The first set of tire pressures applies to test item MRS-2 and the second set to test item MRS-3. Note that these values may vary from the target values indicated in table Gear.

TestItem

Test item(s) loaded during event EventNo.

Gear_ID

Gear configuration for event EventNo. Refer to table Gear.

Wander_ID

Position within the wander sequence corresponding to event EventNo. The wander pattern consists of wander sequences 1 through 66. (Note: The wander sequence number must agree with the track number as given in table Wander.)

 

 


Query Traffic Summary data

Date (YYY/MM/DD) :

Run Traffic Summary Query