LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: SPS3_CRACK

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

VARCHAR2(40)


Method of surface preparation if other than those specified.
AIR_TEMP

NUMBER(3)
deg F

Air temperature at time maintenance treatment was applied. [AIR_TEMP_TREAT]
RELATIVE_HUMIDITY

NUMBER(3)
%

Relative humidity at time of crack seal application.
PAVE_TEMP

NUMBER(3)
deg F

Temperature of pavement at time of sealing.
PAVE_COND
CONDITIONNUMBER(1)


Code indicating condition of pavement surface prior to sealing.
SURFACE_MOISTURE
SURFACE_MOISTURE_SPS34NUMBER(1)


Code indicating pavement surface moisture condition at time of slurry seal application.
SURFACE_COND
SURFACE_CONDNUMBER(1)


Code indicating the surface condition at time of seal application.
SURFACE_COND_OTHER

VARCHAR2(40)


Condition of surface at time of seal application if other than those specified.
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.
STATE_CODE
STATE_PROVINCENUMBER(2)


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

NUMBER(3)
%

Estimated percent of cracks sealed.
LENGTH_SEALED

NUMBER(4)
ft

Approximate total length of cracks filled within the test section.
MANUFACTURER_NAME

VARCHAR2(40)


Name of sealant manufacturer.
MATERIAL_NAME

VARCHAR2(40)


Manufacturer's material name used to seal cracks.
TRANS_CRACKS_ROUTED
YES_NEVERNUMBER(1)


Code indicating if the transverse cracks were routed.
DIAG_CRACKS_ROUTED
YES_NEVERNUMBER(1)


Code indicating if the diagonal cracks were routed.
LONG_CRACKS_ROUTED
YES_NEVERNUMBER(1)


Code indicating if the longitudinal cracks were routed.
ONE_PASS_ROUTING
YES_NEVERNUMBER(1)


Code indicating if routing was accomplished in one pass.
WIDTH_MIN

NUMBER(3,2)
in

Minimum width of the prepared cracks.
WIDTH_MEAN

NUMBER(3,2)
in

Average width of the prepared cracks.
DATE_COMPLETE

DATE


Date activity was completed.
WIDTH_MAX

NUMBER(3,2)
in

Maximum width of the prepared cracks.
DEPTH_MIN

NUMBER(3,2)
in

Minimum depth of the prepared cracks.
DEPTH_MEAN

NUMBER(3,2)
in

Average depth of the prepared cracks.
DEPTH_MAX

NUMBER(3,2)
in

Maximum depth of the prepared cracks.
LENGTH_PREPARED

NUMBER(4)
ft

Total length of prepared cracks.
CRACK_CLEAN
YES_NEVERNUMBER(1)


Code indicating if cracks were cleaned prior to sealing.
CRACK_DRY
YES_NEVERNUMBER(1)


Code indicating if cracks were dry prior to sealing.
LANCE_USED
YES_NEVERNUMBER(1)


Code indicating if a hot-air lance was used prior to sealing.
CHARRED
YES_NEVERNUMBER(1)


Code indicating if asphalt around crack was charred after heating.
HOT_PLACED
YES_NEVERNUMBER(1)


Code indicating if crack was still hot from the hot-air lance when sealant was placed.
DATE_BEGAN

DATE


Date operations began.
KETTLE_NAME

VARCHAR2(40)


Model name of the sealant heating kettle.
KETTLE_MODEL

VARCHAR2(20)


Model number of the sealant heating kettle.
MAX_SEAL_TEMP

NUMBER(3)
deg F

Sealant manufacturer's suggested maximum kettle temperature.
SEAL_TEMP_BEGIN

NUMBER(3)
deg F

Temperature of the sealant within the applicator at the start of sealing operations.
SEAL_TEMP_END

NUMBER(3)
deg F

Temperature of the sealant within the applicator at the end of sealing operations.
REHEATED
YES_NONUMBER(1)


Code indicating if any sealant was reheated.
TIMES_REHEATED

NUMBER(2)


Number of times sealant was reheated.
FLUSH_HOSE
YES_NEVERNUMBER(1)


Code indicating if back flushed hose.
FLUSH_FILLER
YES_NEVERNUMBER(1)


Code indicating if crack filler flushed.
CHAMBER_HEATED
YES_NEVERNUMBER(1)


Code indicating if sealant chamber was heated.
TIME_BEGAN

VARCHAR2(4)
hhmm

Time crack seal operation began.
HOSE_HEATED
YES_NEVERNUMBER(1)


Code indicating if hose between wand and sealant chamber was heated.
MATL_AGITATION
YES_NEVERNUMBER(1)


Code indicating if material in chamber was under constant agitation.
THERMOMETER_VISIBLE
YES_NEVERNUMBER(1)


Code indicating if thermometer was visible to operator.
BLOT_MATL_USED
YES_NEVERNUMBER(1)


Code indicating if blotting material was used on the cracks.
WAND_SQUEEGEE_DIST

NUMBER(2)
ft

Distance between applicator wand and squeegee.
AVG_WIDTH_CRACK

NUMBER(2,1)
in

Average width of completed sealed crack.
FINISH_SEAL
FINISH_SEALNUMBER(1)


Code indicating the thickness of the finished sealant.
SEAL_THICKNESS

NUMBER(2,2)
in

Average thickness of sealant above or below pavement surface.
TIME_BEFORE_PLACE

NUMBER(3,1)
min

Estimated time between completion of crack preparation and sealant placement.
TIME_SEAL_BEGAN

NUMBER(4,1)
hr

Length of time between completion of crack sealant and opening to traffic at end where sealing began.
TIME_COMPLETE

VARCHAR2(4)
hhmm

Time crack seal operation completed.
TIME_SEAL_END

NUMBER(4,1)
hr

Length of time between completion of crack sealant and opening to traffic at end where sealing ended.
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.
SECTION_LENGTH

NUMBER(4)
ft

Length of test section.
SECTION_WIDTH

NUMBER(3,1)
ft

Width of test section.
SURFACE_PREP
SURFACE_PREPNUMBER(1)


Code indicating method of surface preparation.