LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: SPS7_PCCO_JOINT_DATA

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

NUMBER(3,1)
ft

Average intermediate sawed joint spacing.
TRANS_METHOD
TRANS_METHODNUMBER(1)


Code indicating method used to form transverse joints.
TRANS_METHOD_OTHER

VARCHAR2(40)


Method used to form the transverse joints if other than those specified.
LONG_TYPE
LONG_JOINT_FORMEDNUMBER(1)


Code for method used to form the longitudinal joint between the lanes.
LONG_TYPE_OTHER

VARCHAR2(40)


Method used to form the longitudinal joint between the lanes if other than those specified.
SH_TRAFFIC_LANE_TYPE
SH_JOINT_FORMEDNUMBER(1)


Code for method used to form joint between the shoulder and the traffic lane.
SH_TRAFFIC_LANE_TYPE_OTHER

VARCHAR2(40)


Method used to form joint between shoulder and traffic lane if other than those specified.
TRANS_SEAL_TYPE
TRANS_SEAL_TYPENUMBER(1)


Code indicating type of joint sealant used in transverse joints.
TRANS_SEAL_TYPE_OTHER

VARCHAR2(40)


Type of joint sealant used in transverse joints if other than those specified.
TRANS_SEAL_RESVR_WIDTH

NUMBER(3,2)
in

Transverse joint sealant reservoir width.
STATE_CODE
STATE_PROVINCENUMBER(2)


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

NUMBER(3,2)
in

Transverse joint sealant reservoir depth.
LONG_SEAL_RESVR_WIDTH

NUMBER(3,2)
in

Average width of the longitudinal joint sealant reservoir.
LONG_SEAL_RESVR_DEPTH

NUMBER(3,2)
in

Average depth of the longitudinal joint sealant reservoir.
JOINT_SEAL_BACKER
JOINT_SEAL_BACKERNUMBER(1)


Code indicating the type of joint sealant backer material.
JOINT_SEAL_BACKER_OTHER

VARCHAR2(40)


Type of joint sealant backer if other than those specified.
JOINT_SEAL_BACKER_DIAM

NUMBER(3,2)
in

Joint sealant backer dimension.
SH_TRAFFIC_SEAL_RESVR_WIDTH

NUMBER(3,2)
in

Average width of joint sealant reservoir between the shoulder and the traffic lane.
SH_TRAFFIC_SEAL_RESVR_DEPTH

NUMBER(3,2)
in

Average depth of joint sealant reservoir between the shoulder and the traffic lane.
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.
DATE_BEGAN

DATE


Date operations began.
AVG_CONTRACTION_SPACING

NUMBER(4,1)
ft

Average spacing between consecutive contraction joints.
RANDOM_SPACING

VARCHAR2(40)


Description of any random spacing.
BUILT_IN_EXPANSION_SPACING

NUMBER(4)
ft

Average spacing between consecutive expansion joints.
JOINT_SKEWNESS

NUMBER(2,1)
ft/lane

Average deviation of the contraction joint across the slab from a right angle with the edge.