Dynamic Data

Contains dynamic sensor responses, including peak values and full dynamic records. Fields are defined in the following list. The following figure illustrates properties of the sensor record as given in the Dynamic_data table.

Definition of Fields in Table Dynamic_data

 

SensorID

Number assigned to an individual sensor in the "SPU" table.

EventNo

Number assigned to an event in the “Traffic” table. An event is defined as a vehicle movement with loads.

StartTime

Time after the start of an event corresponding to the first data sample added to the SensorRecord (seconds).

StartVehiclePosition

The vehicle position corresponding to time StartTime (feet).

EndTime

Time after the start of an event corresponding to the last data sample added to the SensorRecord (seconds).

EndVehiclePosition

The vehicle position corresponding to time EndTime (feet).

OffsetLeft

Average value of the sensor reading prior to the initial load response (sensor units).

OffsetRight

Average value of the sensor reading following the load response (sensor units).

FilterFreq

Frequency of the applied data filter (Hz).

Peak1Time

Time after the start of an event corresponding to Peak 1 (seconds). See below for information on how Peak1 and Peak2 are determined.

Peak1

Value of Peak 1 relative to OffsetRight (sensor units). See below for information on how Peak1 and Peak2 are determined.

Peak2Time

Time after the start of an event corresponding to Peak 2 (seconds). See below for information on how Peak1 and Peak2 are determined.

Peak2

Value of Peak 2 relative to OffsetRight (sensor units). See below for information on how Peak1 and Peak2 are determined.

Peak3Time

Peak3

SensorRecord

Full dynamic sensor data corresponding to an event, consisting of a string of SampleCount values delineated by commas (sensor units).

SpuRefTime

Date/Time when the sensor record was recorded by the signal processing unit (SPU). Date is recorded as MM/DD/YYYY. Time is local time (New Jersey, USA).

Comments

RowID

Column_Temporary

 

 

Select Sensor :

Run