LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: SPS4_CRACK_SEAL_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.
DAY3_TIME_WORK_BEGAN

NUMBER(4)
hhmm

Time work began on day 3.
DAY3_TIME_WORK_ENDED

NUMBER(4)
hhmm

Time work ended on day 3.
DAY4_TIME_WORK_BEGAN

NUMBER(4)
hhmm

Time work began on day 4.
DAY4_TIME_WORK_ENDED

NUMBER(4)
hhmm

Time work ended on day 4.
DAY5_TIME_WORK_BEGAN

NUMBER(4)
hhmm

Time work began on day 5.
DAY5_TIME_WORK_ENDED

NUMBER(4)
hhmm

Time work ended on day 5.
TEST_SECTION_LENGTH

NUMBER(4)
ft

Length of the test section that was sealed.
LANE_WIDTH

NUMBER(3,1)
ft

Width of the test section that was sealed.
DAY1_BEGIN_SEAL_TEMP

NUMBER(3)
deg F

Air temperature at beginning of sealing on day 1.
DAY1_END_SEAL_TEMP

NUMBER(3)
deg F

Air temperature at end of sealing on day 1.
STATE_CODE
STATE_PROVINCENUMBER(2)


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

NUMBER(3)
deg F

Air temperature at beginning of sealing on day 2.
DAY2_END_SEAL_TEMP

NUMBER(3)
deg F

Air temperature at end of sealing on day 2.
DAY3_BEGIN_SEAL_TEMP

NUMBER(3)
deg F

Air temperature at beginning of sealing on day 3.
DAY3_END_SEAL_TEMP

NUMBER(3)
deg F

Air temperature at end of sealing on day 3.
DAY4_BEGIN_SEAL_TEMP

NUMBER(3)
deg F

Air temperature at beginning of sealing on day 4.
DAY4_END_SEAL_TEMP

NUMBER(3)
deg F

Air temperature at end of sealing on day 4.
DAY5_BEGIN_SEAL_TEMP

NUMBER(3)
deg F

Air temperature at beginning of sealing on day 5.
DAY5_END_SEAL_TEMP

NUMBER(3)
deg F

Air temperature at end of sealing on day 5.
DAY1_BEGIN_SEAL_HUMIDITY

NUMBER(3)
%

Relative humidity at beginning of sealing on day 1.
DAY1_END_SEAL_HUMIDITY

NUMBER(3)
%

Relative humidity at end of sealing on day 1.
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.
DAY2_BEGIN_SEAL_HUMIDITY

NUMBER(3)
%

Relative humidity at beginning of sealing on day 2.
DAY2_END_SEAL_HUMIDITY

NUMBER(3)
%

Relative humidity at end of sealing on day 2.
DAY3_BEGIN_SEAL_HUMIDITY

NUMBER(3)
%

Relative humidity at beginning of sealing on day 3.
DAY3_END_SEAL_HUMIDITY

NUMBER(3)
%

Relative humidity at end of sealing on day 3.
DAY4_BEGIN_SEAL_HUMIDITY

NUMBER(3)
%

Relative humidity at beginning of sealing on day 4.
DAY4_END_SEAL_HUMIDITY

NUMBER(3)
%

Relative humidity at end of sealing on day 4.
DAY5_BEGIN_SEAL_HUMIDITY

NUMBER(3)
%

Relative humidity at beginning of sealing on day 5.
DAY5_END_SEAL_HUMIDITY

NUMBER(3)
%

Relative humidity at end of sealing on day 5.
CONCRETE_SHOULDER_JOINT
NUMBER_SEALEDNUMBER(1)


Code indicating types of cracks that were sealed at the concrete pavement/asphalt shoulder joint.
TRANSVERSE_JOINT
NUMBER_SEALEDNUMBER(1)


Code indicating number of concrete transverse pavement joints/shoulder joints sealed.
DATE_COMPLETE

DATE


Date activity was completed.
LONGITUDINAL_JOINT
NUMBER_SEALEDNUMBER(1)


Code indicating number of longitudinal pavement joints/shoulder joints sealed.
DIAGONAL_CRACK
NUMBER_SEALEDNUMBER(1)


Code indicating quantity of diagonal random cracks sealed.
TRANSVERSE_CRACK
NUMBER_SEALEDNUMBER(1)


Code indicating number of transverse random cracks sealed.
LONGITUDINAL_CRACK
NUMBER_SEALEDNUMBER(1)


Code indicating number of longitudinal random cracks sealed.
SHOULDER_PATCHING_COMPLETED
YES_NONUMBER(1)


Code indicating if shoulder patching was completed.
CONCRETE_PATCHING_COMPLETED
YES_NONUMBER(1)


Code indicating if concrete patching was completed.
MATL_BURNED_BY_AIR_LANCE
FREQUENCYNUMBER(1)


Code indicating if asphalt shoulder material was burned by the hot compressed air lance.
FIELD_NOTES_AVAILABLE
YES_NONUMBER(1)


Code indicating if field notes are available.
FIELD_NOTE_LOCATION

VARCHAR2(40)


Location of field notes.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
DATE_BEGAN

DATE


Date operations began.
DAY1_TIME_WORK_BEGAN

NUMBER(4)
hhmm

Time work began on day 1.
DAY1_TIME_WORK_ENDED

NUMBER(4)
hhmm

Time work ended on day 1.
DAY2_TIME_WORK_BEGAN

NUMBER(4)
hhmm

Time work began on day 2.
DAY2_TIME_WORK_ENDED

NUMBER(4)
hhmm

Time work ended on day 2.