LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: SPS4_CONTROL_GENERAL

Field NameCodesData TypeUnitsTest ProtocolDescription
SHRP_ID

VARCHAR2(4)


Test section identification number assigned by LTPP program. Must be combined with STATE_CODE to be unique.
SHOULDER_JOINT
NUMBER_SEALEDNUMBER(1)


Code indicating type of joints/cracks sealed at the concrete pavement/asphalt shoulder joint.
TRANS_JOINT
NUMBER_SEALEDNUMBER(1)


Code indicating type of joints/cracks sealed at the transverse pavement joints.
LONG_JOINT
NUMBER_SEALEDNUMBER(1)


Code indicating type of joints/cracks sealed at the longitudinal pavement joint.
TRANS_CRACK
NUMBER_SEALEDNUMBER(1)


Code indicating type of joints/cracks sealed at the transverse random cracks.
LONG_CRACK
NUMBER_SEALEDNUMBER(1)


Code indicating type of joints/cracks sealed at the longitudinal random cracks.
DIAGONAL_CRACK
NUMBER_SEALEDNUMBER(1)


Code indicating quantity of diagonal random cracks sealed.
JOINT_OPEN_PROCESS
JOINT_OPEN_PROCESSNUMBER(1)


Code indicating type of process used to open joints.
OTHER_PROCESS

VARCHAR2(40)


Process used to open joints if other than those specified.
PATCHING
PATCHINGNUMBER(1)


Code indicating the extent of patching in the control section.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
STATE_CODE
STATE_PROVINCENUMBER(2)


Numerical code for state or province. U.S. codes are consistent with Federal Information Processing Standards.
CONSTRUCTION_NO

NUMBER(2)


Event number used to relate changes in pavement structure with other time dependent data elements. This field is set to 1 when a test section is initially accepted into LTPP and is incremented with each change to the layer structure.
DATE_COMPLETE

DATE


Date activity was completed.
TIME

VARCHAR2(4)
hhmm

Time condition survey was performed on the control section.
SECTION_LENGTH

NUMBER(4)
ft

Length of control section to be monitored.
LANE_WIDTH

NUMBER(3,1)
ft

Width of control section.
AIR_TEMPERATURE

NUMBER(3)
deg F

Air temperature at time of survey.
HUMIDITY

NUMBER(3)
%

Humidity at time of survey.