LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: TRF_EQUIPMENT_MASTER

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.
SENSORS_LTPP_QUARTZ_PIEZO
Y_NVARCHAR2(1)


Code indicating if quartz piezo sensors are installed in LTPP lane.
SENSORS_LTPP_CAPACITANCE_PADS
Y_NVARCHAR2(1)


Code indicating if capacitance pads are installed in LTPP lane.
SENSORS_LTPP_INDUCTANCE_LOOPS
Y_NVARCHAR2(1)


Code indicating if inductance loops are installed in LTPP lane.
SENSORS_LTPP_LOAD_CELLS
Y_NVARCHAR2(1)


Code indicating if load cells are installed in LTPP lane.
SENSORS_LTPP_OTHER
Y_NVARCHAR2(1)


Code indicating other sensor type installed in LTPP lane.
SENSORS_LTPP_OTHER_DESCRIPTION

VARCHAR2(40)


Description of other sensor type used for LTPP lane.
WIM_EQUIPMENT_MANUFACTURER

VARCHAR2(40)


Manufacture of WIM equipment used at site.
AVC_EQUIPMENT_MANUFACTURER

VARCHAR2(40)


Manufacture of AVC equipment used at site.
TRF_CALIBRATION_PROTOCOL
TRF_CAL_PROTOCOLVARCHAR2(5)


Code for the documented calibration protocol used for the calibration/validation on this date.
SHRP_ID

VARCHAR2(4)


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

DATE


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

VARCHAR2(1)


A code indicating the general quality of the data.
TYPE_EQUIP_CALIB
TYPE_EQUIPMENT_CALIBVARCHAR2(1)


Code indicating the type of equipment calibrated.
REASON_CALIB
REASON_CALIBVARCHAR2(2)


Reason why the calibration check was performed.
REASON_CALIB_OTHER

VARCHAR2(40)


Reason why the calibration check was performed if other than those specified.
SENSORS_LTPP_BENDING_PLATES
Y_NVARCHAR2(1)


Code indicating if bending plates are installed in LTPP lane.
SENSORS_LTPP_PIEZO_CABLE
SENSORS_LTPP_PIEZO_CABLEVARCHAR2(1)


Code indicating which type, if any, of piezo cable sensors are installed in LTPP lane.