LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: TRF_CALIBRATION_WIM

Field NameCodesData TypeUnitsTest ProtocolDescription
STATE_CODE
STATE_PROVINCENUMBER(2)


Numerical code for state or province. U.S. codes are consistent with Federal Information Processing Standards.
WIM_CALIB_TRUCK1_SUSPNSN
WIM_CALIB_TRUCK_SUSPNSNVARCHAR2(1)


Code indicating the suspension type for WIM test truck 1.
WIM_CALIB_TRUCK1_SUSPNSN_OTHER

VARCHAR2(40)


Suspension type on WIM test truck 1 if other than those specified.
WIM_CALIB_TRUCK2_TYPE
VEHICLE_CLASSVARCHAR2(5)


Code indicating the FHWA classification of second WIM test vehicle.
WIM_CALIB_TRUCK2_SUSPNSN
WIM_CALIB_TRUCK_SUSPNSNVARCHAR2(1)


Code indicating the suspension type for WIM test truck 2.
WIM_CALIB_TRUCK2_SUSPNSN_OTHER

VARCHAR2(40)


Suspension type on WIM test truck 2 if other than those specified.
WIM_CALIB_TRUCK3_TYPE
VEHICLE_CLASSVARCHAR2(5)


Code indicating the FHWA classification of third WIM test vehicle.
WIM_CALIB_TRUCK3_SUSPNSN
WIM_CALIB_TRUCK_SUSPNSNVARCHAR2(1)


Code indicating the suspension type for WIM test truck 3.
WIM_CALIB_TRUCK3_SUSPNSN_OTHER

VARCHAR2(40)


Suspension type on WIM test truck 3 if other than those specified.
DYNAMIC_STAT_GVW_DIFF

NUMBER(4,1)
%

Mean difference between dynamic and static GVW for all runs from WIM calibration check.
DYNAMIC_STAT_GVW_DIFF_SD

NUMBER(3,1)
%

Standard deviation of difference between dynamic and static GVW for all runs from WIM calibration.
SHRP_ID

VARCHAR2(4)


Test section identification number assigned by LTPP program. Must be combined with STATE_CODE to be unique.
DYNAMIC_STAT_SINGLE_AXLE_DIFF

NUMBER(4,1)
%

Mean difference between dynamic and static single axle weight for WIM calibration check.
DYNAMIC_STAT_SINGLE_DIFF_SD

NUMBER(3,1)
%

Standard deviation of difference between dynamic and static single axle weights for WIM calibration check.
DYNAMIC_STAT_TANDEM_AXLE_DIFF

NUMBER(4,1)
%

Mean difference between dynamic and static tandem axle weights for WIM calibration check.
DYNAMIC_STAT_TANDEM_DIFF_SD

NUMBER(3,1)
%

Standard deviation of difference between dynamic and static tandem axle weights for WIM calibration check.
WIM_CALIB_NO_SPEEDS

NUMBER(2)


Number of speeds at which WIM calibration was performed.
WIM_CALIB_SPEED_RANGE_1

VARCHAR2(9)
mph

First speed range used for WIM calibration, (low - high).
WIM_CALIB_SPEED_RANGE_2

VARCHAR2(9)
mph

Second speed range used for WIM calibration, (low - high).
WIM_CALIB_SPEED_RANGE_3

VARCHAR2(9)
mph

Third speed range used for WIM calibration, (low - high).
WIM_CALIB_SPEED_RANGE_4

VARCHAR2(9)
mph

Fourth speed range used for WIM calibration, (low - high).
WIM_CALIB_SPEED_RANGE_5

VARCHAR2(9)
mph

Fifth speed range used for WIM calibration, (low - high).
WIM_AVC_CALIB_DATE

DATE


Date calibration or calibration check of WIM or AVC equipment was completed.
WIM_CALIB_SPEED_RANGE_6

VARCHAR2(9)
mph

Sixth speed range used for WIM calibration, (low - high).
WIM_CALIB_SPEED_RANGE_7

VARCHAR2(9)
mph

Seventh speed range used for WIM calibration, (low - high).
WIM_CALIB_SPEED_RANGE_8

VARCHAR2(9)
mph

Eight speed range used for WIM calibration, (low - high).
WIM_CALIB_FACTOR

VARCHAR2(60)


Calibration factor entered into the WIM scale software at the end of calibration.
WIM_AUTO_CALIB
WIM_AUTO_CALIBVARCHAR2(1)


Code indicating if auto calibration used.
WIM_AUTO_CALIB_DESC

VARCHAR2(40)


Description of auto calibration factor.
WIM_AUTO_CALIB_VALUE

NUMBER(5)


Value of auto calibration factor used.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
WIM_CALIB_TECHNIQUE
WIM_CALIB_TECHNIQUEVARCHAR2(1)


Code indicating type of calibration technique used for WIM equipment.
WIM_CALIB_NO_TRUCKS_COMP

NUMBER(4)


Number of trucks used correctly matched between the static and WIM scales if trucks from the traffic stream are being weighed at a nearby static scale.
WIM_CALIB_NO_TEST_TRUCKS

NUMBER(1)


Number of test trucks if used for WIM equipment check.
WIM_CALIB_PASS_PER_TRUCK

NUMBER(3)


Number of passes per truck for WIM calibration.
WIM_CALIB_TRUCK1_TYPE
VEHICLE_CLASSVARCHAR2(5)


Code indicating the FHWA classification of first WIM test vehicle.