LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: SPS3_CHIP

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.
RATE_ADJUSTED
YES_NONUMBER(1)


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

NUMBER(3,3)
lb/sq yd

Target application rate of bituminous material.
DIST_READ_RATE

NUMBER(3,3)
gal/sq yd

Application rate of the material as determined by the distributor's flow meter.
DIST_TANK_RATE

NUMBER(3,3)
gal/sq yd

Application rate of the material as determined by the difference in tank readings before and after application.
MIN_TARGET_TEMP

NUMBER(3)
deg F

Minimum target temperature of bituminous material.
MAX_TARGET_TEMP

NUMBER(3)
deg F

Maximum target temperature of bituminous material.
STATE_CODE
STATE_PROVINCENUMBER(2)


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

NUMBER(3)
deg F

The actual temperature of bituminous material.
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 the aggregate source.
AGG_TARGET_RATE

NUMBER(3,1)
lb/sq yd

Target application rate for the cover aggregate.
AGG_RATE_IN_WHEEL

NUMBER(3,1)
lb/sq yd

Application rate for the cover aggregate in the wheel path.
AGG_RATE_BET_WHEEL

NUMBER(3,1)
lb/sq yd

Application rate for the cover aggregate between the wheel path.
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.
DATE_COMPLETE

DATE


Date activity was completed.
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 chip 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 chip 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.
DATE_BEGAN

DATE


Date operations began.
AGG_COND_MOIST
AGG_COND_MOISTNUMBER(1)


Code indicating the moisture condition prior to use.
AGG_MOISTURE

NUMBER(3,1)
%

Aggregate moisture content, percent by weight.
TIME_BEFORE_SPREAD

NUMBER(3)
sec

Estimated time between the application of material and the aggregate cover.
TIME_BEFORE_ROLL

NUMBER(3)
sec

Estimated time between the application of the cover aggregate and initial rolling.
COVERAGES

NUMBER(1)


Number of times the roller covered the surface area.
TIME_BEFORE_BROOM

NUMBER(3,1)
hr

Time between the application of the final rolling and the sweeping of the pavement.
TIME_BEFORE_OPEN

NUMBER(3,1)
hr

Estimated time between final rolling and opening section to reduced speed traffic.
MAX_SPEED_ALLOWED

NUMBER(2)
mph

Maximum speed allowed on the test section prior to final brooming operation.
TIME_BEFORE_FULL_SPEED

NUMBER(3,1)
hr

Estimated time between final rolling and opening section to full speed traffic.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
TIME_BEGAN

VARCHAR2(4)
hhmm

Time chip seal operation began.
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 chip 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.