LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: SPS4_CRACK_SEAL_PVMT_MEAS

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

NUMBER(2)
1/16 in

Width of the reservoir for transverse joints.
T_RESERVOIR_WIDTH7

NUMBER(2)
1/16 in

Width of the reservoir for transverse joints.
T_RESERVOIR_WIDTH8

NUMBER(2)
1/16 in

Width of the reservoir for transverse joints.
T_RESERVOIR_WIDTH9

NUMBER(2)
1/16 in

Width of the reservoir for transverse joints.
T_RESERVOIR_WIDTH10

NUMBER(2)
1/16 in

Width of the reservoir for transverse joints.
T_MIN_RESERVOIR_WIDTH

NUMBER(2)
1/16 in

Minimum reservoir width for transverse joints.
T_MAX_RESERVOIR_WIDTH

NUMBER(2)
1/16 in

Maximum reservoir width for transverse joints.
T_AVG_RESERVOIR_WIDTH

NUMBER(2)
1/16 in

Average reservoir width for transverse joints.
T_RESERVOIR_DEPTH1

NUMBER(2)
1/16 in

Depth of the reservoir for transverse joints.
T_RESERVOIR_DEPTH2

NUMBER(2)
1/16 in

Depth of the reservoir for transverse joints.
STATE_CODE
STATE_PROVINCENUMBER(2)


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

NUMBER(2)
1/16 in

Depth of the reservoir for transverse joints.
T_RESERVOIR_DEPTH4

NUMBER(2)
1/16 in

Depth of the reservoir for transverse joints.
T_RESERVOIR_DEPTH5

NUMBER(2)
1/16 in

Depth of the reservoir for transverse joints.
T_RESERVOIR_DEPTH6

NUMBER(2)
1/16 in

Depth of the reservoir for transverse joints.
T_RESERVOIR_DEPTH7

NUMBER(2)
1/16 in

Depth of the reservoir for transverse joints.
T_RESERVOIR_DEPTH8

NUMBER(2)
1/16 in

Depth of the reservoir for transverse joints.
T_RESERVOIR_DEPTH9

NUMBER(2)
1/16 in

Depth of the reservoir for transverse joints.
T_RESERVOIR_DEPTH10

NUMBER(2)
1/16 in

Depth of the reservoir for transverse joints.
T_MIN_RESERVOIR_DEPTH

NUMBER(2)
1/16 in

Minimum reservoir depth for transverse joints.
T_MAX_RESERVOIR_DEPTH

NUMBER(2)
1/16 in

Maximum reservoir depth for transverse joints.
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.
T_AVG_RESERVOIR_DEPTH

NUMBER(2)
1/16 in

Average reservoir depth for transverse joints.
T_TOT_LENGTH_PREP

NUMBER(4)
ft

Total length of transverse joints prepared.
L_RESERVOIR_WIDTH1

NUMBER(2)
1/16 in

Width of the reservoir for longitudinal joints.
L_RESERVOIR_WIDTH2

NUMBER(2)
1/16 in

Width of the reservoir for longitudinal joints.
L_RESERVOIR_WIDTH3

NUMBER(2)
1/16 in

Width of the reservoir for longitudinal joints.
L_RESERVOIR_WIDTH4

NUMBER(2)
1/16 in

Width of the reservoir for longitudinal joints.
L_RESERVOIR_WIDTH5

NUMBER(2)
1/16 in

Width of the reservoir for longitudinal joints.
L_RESERVOIR_WIDTH6

NUMBER(2)
1/16 in

Width of the reservoir for longitudinal joints.
L_RESERVOIR_WIDTH7

NUMBER(2)
1/16 in

Width of the reservoir for longitudinal joints.
L_RESERVOIR_WIDTH8

NUMBER(2)
1/16 in

Width of the reservoir for longitudinal joints.
DATE_COMPLETE

DATE


Date activity was completed.
L_RESERVOIR_WIDTH9

NUMBER(2)
1/16 in

Width of the reservoir for longitudinal joints.
L_RESERVOIR_WIDTH10

NUMBER(2)
1/16 in

Width of the reservoir for longitudinal joints.
L_MIN_RESERVOIR_WIDTH

NUMBER(2)
1/16 in

Minimum reservoir width for longitudinal joints.
L_MAX_RESERVOIR_WIDTH

NUMBER(2)
1/16 in

Maximum reservoir width for longitudinal joints.
L_AVG_RESERVOIR_WIDTH

NUMBER(2)
1/16 in

Average reservoir width for longitudinal joints.
L_RESERVOIR_DEPTH1

NUMBER(2)
1/16 in

Depth of the reservoir for longitudinal joints.
L_RESERVOIR_DEPTH2

NUMBER(2)
1/16 in

Depth of the reservoir for longitudinal joints.
L_RESERVOIR_DEPTH3

NUMBER(2)
1/16 in

Depth of the reservoir for longitudinal joints.
L_RESERVOIR_DEPTH4

NUMBER(2)
1/16 in

Depth of the reservoir for longitudinal joints.
L_RESERVOIR_DEPTH5

NUMBER(2)
1/16 in

Depth of the reservoir for longitudinal joints.
T_RESERVOIR_WIDTH1

NUMBER(2)
1/16 in

Width of the reservoir for transverse joints.
L_RESERVOIR_DEPTH6

NUMBER(2)
1/16 in

Depth of the reservoir for longitudinal joints.
L_RESERVOIR_DEPTH7

NUMBER(2)
1/16 in

Depth of the reservoir for longitudinal joints.
L_RESERVOIR_DEPTH8

NUMBER(2)
1/16 in

Depth of the reservoir for longitudinal joints.
L_RESERVOIR_DEPTH9

NUMBER(2)
1/16 in

Depth of the reservoir for longitudinal joints.
L_RESERVOIR_DEPTH10

NUMBER(2)
1/16 in

Depth of the reservoir for longitudinal joints.
L_MIN_RESERVOIR_DEPTH

NUMBER(2)
1/16 in

Minimum reservoir depth for longitudinal joints.
L_MAX_RESERVOIR_DEPTH

NUMBER(2)
1/16 in

Maximum reservoir depth for longitudinal joints.
L_AVG_RESERVOIR_DEPTH

NUMBER(2)
1/16 in

Average reservoir depth for longitudinal joints.
L_TOT_LENGTH_PREP

NUMBER(4)
ft

Total length of longitudinal joints prepared.
T_BACKER_DEPTH1

NUMBER(2)
1/16 in

Depth of backer material measurements after joint preparation and before sealing for the transverse joints, measured at 10 random locations.
T_RESERVOIR_WIDTH2

NUMBER(2)
1/16 in

Width of the reservoir for transverse joints.
T_BACKER_DEPTH2

NUMBER(2)
1/16 in

Depth of backer material measurements after joint preparation and before sealing for the transverse joints, measured at 10 random locations.
T_BACKER_DEPTH3

NUMBER(2)
1/16 in

Depth of backer material measurements after joint preparation and before sealing for the transverse joints, measured at 10 random locations.
T_BACKER_DEPTH4

NUMBER(2)
1/16 in

Depth of backer material measurements after joint preparation and before sealing for the transverse joints, measured at 10 random locations.
T_BACKER_DEPTH5

NUMBER(2)
1/16 in

Depth of backer material measurements after joint preparation and before sealing for the transverse joints, measured at 10 random locations.
T_BACKER_DEPTH6

NUMBER(2)
1/16 in

Depth of backer material measurements after joint preparation and before sealing for the transverse joints, measured at 10 random locations.
T_BACKER_DEPTH7

NUMBER(2)
1/16 in

Depth of backer material measurements after joint preparation and before sealing for the transverse joints, measured at 10 random locations.
T_BACKER_DEPTH8

NUMBER(2)
1/16 in

Depth of backer material measurements after joint preparation and before sealing for the transverse joints, measured at 10 random locations.
T_BACKER_DEPTH9

NUMBER(2)
1/16 in

Depth of backer material measurements after joint preparation and before sealing for the transverse joints, measured at 10 random locations.
T_BACKER_DEPTH10

NUMBER(2)
1/16 in

Depth of backer material measurements after joint preparation and before sealing for the transverse joints, measured at 10 random locations.
T_MIN_BACKER_DEPTH

NUMBER(2)
1/16 in

The minimum depth of the backer material after joint preparation and before sealing for the transverse joints.
T_RESERVOIR_WIDTH3

NUMBER(2)
1/16 in

Width of the reservoir for transverse joints.
T_MAX_BACKER_DEPTH

NUMBER(2)
1/16 in

Maximum depth of backer material after joint preparation and before sealing for transverse joints.
T_AVG_BACKER_DEPTH

NUMBER(2)
1/16 in

Average depth of backer material for transverse joints.
L_BACKER_DEPTH1

NUMBER(2)
1/16 in

Depth of backer material after joint preparation and before sealing for longitudinal joints, measured at 10 random locations.
L_BACKER_DEPTH2

NUMBER(2)
1/16 in

Depth of backer material after joint preparation and before sealing for longitudinal joints, measured at 10 random locations.
L_BACKER_DEPTH3

NUMBER(2)
1/16 in

Depth of backer material after joint preparation and before sealing for longitudinal joints, measured at 10 random locations.
L_BACKER_DEPTH4

NUMBER(2)
1/16 in

Depth of backer material after joint preparation and before sealing for longitudinal joints, measured at 10 random locations.
L_BACKER_DEPTH5

NUMBER(2)
1/16 in

Depth of backer material after joint preparation and before sealing for longitudinal joints, measured at 10 random locations.
L_BACKER_DEPTH6

NUMBER(2)
1/16 in

Depth of backer material after joint preparation and before sealing for longitudinal joints, measured at 10 random locations.
L_BACKER_DEPTH7

NUMBER(2)
1/16 in

Depth of backer material after joint preparation and before sealing for longitudinal joints, measured at 10 random locations.
L_BACKER_DEPTH8

NUMBER(2)
1/16 in

Depth of backer material after joint preparation and before sealing for longitudinal joints, measured at 10 random locations.
T_RESERVOIR_WIDTH4

NUMBER(2)
1/16 in

Width of the reservoir for transverse joints.
L_BACKER_DEPTH9

NUMBER(2)
1/16 in

Depth of backer material after joint preparation and before sealing for longitudinal joints, measured at 10 random locations.
L_BACKER_DEPTH10

NUMBER(2)
1/16 in

Depth of backer material after joint preparation and before sealing for longitudinal joints, measured at 10 random locations.
L_MIN_BACKER_DEPTH

NUMBER(2)
1/16 in

Minimum backer material depth for longitudinal joints.
L_MAX_BACKER_DEPTH

NUMBER(2)
1/16 in

Maximum backer material depth for longitudinal joints.
L_AVG_BACKER_DEPTH

NUMBER(2)
1/16 in

Average depth of the backer material after joint preparation and before sealing for the longitudinal joints.
DEPTH_TOP_SEAL1

NUMBER(3)
1/16 in

Distance from surface of pavement to top of sealant.
DEPTH_TOP_SEAL2

NUMBER(3)
1/16 in

Distance from surface of pavement to top of sealant.
DEPTH_TOP_SEAL3

NUMBER(3)
1/16 in

Distance from surface of pavement to top of sealant.
DEPTH_TOP_SEAL4

NUMBER(3)
1/16 in

Distance from surface of pavement to top of sealant.
DEPTH_TOP_SEAL5

NUMBER(3)
1/16 in

Distance from surface of pavement to top of sealant.
T_RESERVOIR_WIDTH5

NUMBER(2)
1/16 in

Width of the reservoir for transverse joints.
DEPTH_TOP_SEAL6

NUMBER(3)
1/16 in

Distance from surface of pavement to top of sealant.
DEPTH_TOP_SEAL7

NUMBER(3)
1/16 in

Distance from surface of pavement to top of sealant.
DEPTH_TOP_SEAL8

NUMBER(3)
1/16 in

Distance from surface of pavement to top of sealant.
DEPTH_TOP_SEAL9

NUMBER(3)
1/16 in

Distance from surface of pavement to top of sealant.
DEPTH_TOP_SEAL10

NUMBER(3)
1/16 in

Distance from surface of pavement to top of sealant.
MIN_DEPTH_TOP_SEAL

NUMBER(3)
1/16 in

Minimum depth from surface of pavement to top of sealant.
MAX_DEPTH_TOP_SEAL

NUMBER(3)
1/16 in

Maximum depth from surface of pavement to top of sealant.
AVG_DEPTH_TOP_SEAL

NUMBER(3)
1/16 in

Average depth from surface of pavement to top of sealant.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.