LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: SPS5_AC_PATCHES

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_PATCHES_NO

NUMBER(2)


Number of surface pavement patches.
SURFACE_PATCHES_SF

NUMBER(4)
sq ft

Area of surface patching.
PARTIAL_BASE_NO

NUMBER(2)


Number of patches for surface and partial base replacement patches.
PARTIAL_BASE_SF

NUMBER(4)
sq ft

Total area of surface and partial base replacement patches.
FULL_DEPTH_NO

NUMBER(2)


Number of full depth patches placed in test section.
FULL_DEPTH_SF

NUMBER(4)
sq ft

Square feet of full depth patches.
LOC_SIZE_METHOD
LOC_SIZE_METHODNUMBER(1)


Code indicating primary method used to determine location of patches.
LOC_SIZE_METHOD_OTHER

VARCHAR2(40)


Primary method used to determine location of patches if other than those specified.
PATCH_BOUNDARY_METHOD
PATCH_BOUNDARY_METHODNUMBER(1)


Code indicating type of method used to form the patch boundary.
PATCH_BOUNDARY_METHOD_OTHER

VARCHAR2(40)


Type of method used to form the patch boundary if other than those specified.
STATE_CODE
STATE_PROVINCENUMBER(2)


Numerical code for state or province. U.S. codes are consistent with Federal Information Processing Standards.
COMPACTION
COMPACTIONNUMBER(1)


Code indicating type of compaction equipment used.
COMPACTION_OTHER

VARCHAR2(40)


Type of compaction equipment used if other than those specified.
PATCH_MATERIAL
PATCH_MATERIALNUMBER(1)


Code indicating general classification of material used in patch surface.
PATCH_MATERIAL_OTHER

VARCHAR2(40)


General classification of material used in patch surface if other than those specified.
MIN_TIME_TO_OPEN

NUMBER(2)
hr

Minimum time from completion of placement of patch to opening to traffic.
MAX_MATL_TEMP

NUMBER(3)
deg F

Maximum allowable material temperature specified for opening a section to traffic.
AIR_TEMP_HIGH

NUMBER(3)
deg F

Highest air temperature observed during maintenance/repair.
AIR_TEMP_LOW

NUMBER(3)
deg F

Lowest air temperature observed during maintenance/repair.
ROAD_MOISTURE
ROAD_MOISTURENUMBER(1)


Code indicating the predominate moisture condition of pavement surface during patching operations.
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.
COMPACTION_2
COMPACTIONNUMBER(1)


Code indicating type of compaction equipment used.
DATE_COMPLETE

DATE


Date activity was completed.
DATE_BEGAN

DATE


Date operations began.
PRIMARY_DISTRESS
DISTRESS_TYPENUMBER(2)


Code indicating the primary distress occurrence being patched.
PRIMARY_DISTRESS_OTHER

VARCHAR2(40)


Description of primary distress occurrence being patched if other than those specified.
SECONDARY_DISTRESS
DISTRESS_TYPENUMBER(2)


Code indicating secondary distress occurrence patched.
SECONDARY_DISTRESS_OTHER

VARCHAR2(40)


Description of secondary distress or occurrence being patched if other than those specified.