LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: SPS3_SLURRY

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.
ASPHALT_GRADE
ASPHALTNUMBER(2)


Code indicating grade of asphalt cement.
ASPHALT_GRADE_OTHER

VARCHAR2(40)


Grade of asphalt cement if other than those specified.
MANUFACTURER_NAME

VARCHAR2(40)


Manufacturer name of bituminous seal coat materials.
MATERIAL_NAME

VARCHAR2(40)


Manufacturer's material name.
AGG_TYPE
GEOL_CLASSNUMBER(2)


Code indicating type of aggregate used in seal coat
AGG_TYPE_OTHER

VARCHAR2(40)


Type of aggregate used in seal coat if other than those specified.
AGG_SOURCE

VARCHAR2(40)


Brief description of aggregate source.
MINERAL_FILL_TYPE
MODIFIERNUMBER(2)


Code indicating type of mineral filler used in slurry seal.
MINERAL_FILL_TYPE_OTHER

VARCHAR2(40)


Type of mineral filler used in slurry seal if other than those specified.
MINERAL_FILL_SOURCE

VARCHAR2(40)


Source of mineral filler.
STATE_CODE
STATE_PROVINCENUMBER(2)


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

NUMBER(4)


Drum counter value on the slurry seal machine prior to the slurry seal application.
REV_AFTER_APP

NUMBER(4)


Drum counter value on the slurry seal machine after to the slurry seal application.
BIT_TARGET_RATE

NUMBER(3,3)
gal/sq yd

Target application rate of the bituminous material.
BIT_ACTUAL_RATE

NUMBER(3,3)
gal/sq yd

Actual application rate of the bituminous material as determined by the distributor readings.
RATE_ADJUSTED
YES_NONUMBER(1)


Code indicating whether the application rate was adjusted at the jobsite to correct for surface condition.
AGG_TARGET_RATE

NUMBER(3,1)
lb/sq yd

Target application rate for the cover aggregate.
AGG_ACTUAL_RATE

NUMBER(3,1)
lb/sq yd

The actual application rate for the cover aggregate as determined by distributor readings.
GATE_OPENING

NUMBER(3,1)
in

Width of the gate opening.
MINERAL_TARGET_RATE

NUMBER(3,2)
lb/sq yd

Target application rate for the mineral filler.
MINERAL_ACTUAL_RATE

NUMBER(3,2)
lb/sq yd

Actual application rate for the mineral filler as determined by distributor readings.
DATE_COMPLETE

DATE


Date activity was completed.
MINERAL_SETTING

NUMBER(4,2)


Setting for the mineral filler displayed on the slurry distributor.
SLURRY_TARGET_RATE

NUMBER(3,1)
lb/sq yd

Target application rate for the slurry mixture.
SLURRY_ACTUAL_RATE

NUMBER(3,1)
lb/sq yd

Actual application rate for the slurry mixture as determined by distributor readings.
WATER_ADDED

NUMBER(3,2)
gal water/gal emuls

Amount of water added to dilute the mixture to a workable consistency.
TEMP_PRIOR

NUMBER(3)
deg F

Temperature of material at point of discharge from the tanker prior to application.
SLURRY_TEMP

NUMBER(3)
deg F

Actual temperature of bituminous material at point of discharge from distributor.
SURFACE_PREP
SURFACE_PREPNUMBER(1)


Code indicating method of surface preparation.
SURFACE_PREP_OTHER

VARCHAR2(40)


Method of surface preparation if other than those specified.
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.
DATE_BEGAN

DATE


Date operations began.
SURFACE_MOISTURE
SURFACE_MOISTURE_SPS34NUMBER(1)


Code indicating pavement surface moisture condition at time of slurry seal application.
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 slurry seal coat 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.
PERCENT_SEALED

NUMBER(3)
%

Estimated percent of cracks sealed.
AGG_COND
CONDITIONNUMBER(1)


Code indicating the aggregate condition prior to use.
AGG_COND_MOIST
AGG_COND_MOISTNUMBER(1)


Code indicating the moisture condition prior to use.
TIME_BEGAN

VARCHAR2(4)
hhmm

Time slurry seal operation began.
AGG_MOISTURE

NUMBER(3,1)
%
H27F
Aggregate moisture content, percent by weight.
TIME_BEFORE_OPEN

NUMBER(3,1)
hr

Estimated time between application of slurry seal and opening section to reduced speed traffic.
MAX_SPEED_ALLOWED

NUMBER(2)
mph

Maximum speed allowed on the test section during the initial curing period.
TIME_BEFORE_FULL_SPEED

NUMBER(3,1)
hr

Estimated time between application of slurry seal and opening section to full speed traffic.
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.
TIME_COMPLETE

VARCHAR2(4)
hhmm

Time slurry seal operation completed.
LENGTH_SEALED

NUMBER(4)
ft

Length of the test section that was sealed.
WIDTH_SEALED

NUMBER(3,1)
ft

Width of test section that was sealed.
SEAL_TYPE
MNT_3_4NUMBER(1)


Code indicating the type of seal coat used.