LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: MNT_ASPHALT_CRACK_SEAL

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.
CRACK_SEAL_MATL_OTHER

VARCHAR2(40)


Type of material used to seal cracks of other than those specified.
CRACK_SEAL_MATL_SOURCE
MNT_SOURCENUMBER(1)


Code indicating data source for type of material used to seal cracks.
MANUFACTURER_NAME

VARCHAR2(40)


Manufacturer of the sealant.
MANUFACTURER_MATERIAL

VARCHAR2(40)


Name of sealant used.
AIR_TEMP_LOW

NUMBER(3)
deg F

Lowest air temperature observed during maintenance/repair.
AIR_TEMP_HIGH

NUMBER(3)
deg F

Highest air temperature observed during maintenance/repair.
SURFACE_MOISTURE
SURFACE_MOISTURENUMBER(1)


Code indicating pavement surface moisture condition at time seal was applied.
CONDITION_SOURCE
MNT_SOURCENUMBER(1)


Data source of ambient conditions at time of crack sealing.
TOTAL_LENGTH_SEALED

NUMBER(4)
lf

Approximate total length of cracks sealed.
CLEAN_METHOD
CLEAN_METHOD_SEALNUMBER(1)


Code for method used to clean crack prior to sealing.
STATE_CODE
STATE_PROVINCENUMBER(2)


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

VARCHAR2(40)


Method used to clean crack prior to sealing if other than those specified.
CLEAN_METHOD_SOURCE
MNT_SOURCENUMBER(1)


Code indicating data source for clean method.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
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.
SHRP_CASE_NO

NUMBER(4)


Key generated by the computer to insure uniqueness of records.
DATE_BEGAN

DATE


Date operations began.
CRACK_SEVERITY
CRACK_SEVERITYNUMBER(1)


Code indicating the crack severity level (as determined in the distress identification manual).
CRACK_TYPE
DISTRESS_TYPENUMBER(2)


Code indicating the primary type of cracks observed within test section.
CRACK_SEAL_MATL
MNT_5_4NUMBER(1)


Code for type of material used to seal cracks.