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_SH_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.
RESERVOIR_WIDTH6

NUMBER(2)
1/16 in

Sealant reservoir width; measured at 10 random locations.
RESERVOIR_WIDTH7

NUMBER(2)
1/16 in

Sealant reservoir width; measured at 10 random locations.
RESERVOIR_WIDTH8

NUMBER(2)
1/16 in

Sealant reservoir width; measured at 10 random locations.
RESERVOIR_WIDTH9

NUMBER(2)
1/16 in

Sealant reservoir width; measured at 10 random locations.
RESERVOIR_WIDTH10

NUMBER(2)
1/16 in

Sealant reservoir width; measured at 10 random locations.
MIN_RESERVOIR_WIDTH

NUMBER(2)
1/16 in

Minimum width of reservoir after preparation and before sealing; measured at 10 random locations.
MAX_RESERVOIR_WIDTH

NUMBER(2)
1/16 in

Maximum width of reservoir after preparation and before sealing; measured at 10 random locations.
AVG_RESERVOIR_WIDTH

NUMBER(2)
1/16 in

Average width of reservoir after preparation and before sealing; measured at 10 random locations.
RESERVOIR_DEPTH1

NUMBER(2)
1/16 in

Sealant reservoir depth; measured at 10 random locations.
RESERVOIR_DEPTH2

NUMBER(2)
1/16 in

Sealant reservoir depth; measured at 10 random locations.
STATE_CODE
STATE_PROVINCENUMBER(2)


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

NUMBER(2)
1/16 in

Sealant reservoir depth; measured at 10 random locations.
RESERVOIR_DEPTH4

NUMBER(2)
1/16 in

Sealant reservoir depth; measured at 10 random locations.
RESERVOIR_DEPTH5

NUMBER(2)
1/16 in

Sealant reservoir depth; measured at 10 random locations.
RESERVOIR_DEPTH6

NUMBER(2)
1/16 in

Sealant reservoir depth; measured at 10 random locations.
RESERVOIR_DEPTH7

NUMBER(2)
1/16 in

Sealant reservoir depth; measured at 10 random locations.
RESERVOIR_DEPTH8

NUMBER(2)
1/16 in

Sealant reservoir depth; measured at 10 random locations.
RESERVOIR_DEPTH9

NUMBER(2)
1/16 in

Sealant reservoir depth; measured at 10 random locations.
RESERVOIR_DEPTH10

NUMBER(2)
1/16 in

Sealant reservoir depth; measured at 10 random locations.
MIN_RESERVOIR_DEPTH

NUMBER(2)
1/16 in

Minimum depth of reservoir after preparation and before sealing; measured at 10 random locations.
MAX_RESERVOIR_DEPTH

NUMBER(2)
1/16 in

Maximum depth of reservoir after preparation and before sealing; measured at 10 random locations.
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.
AVG_RESERVOIR_DEPTH

NUMBER(2)
1/16 in

Average depth of reservoir after preparation and before sealing; measured at 10 random locations.
TOT_LENGTH_PREP

NUMBER(4)
ft

Total length of joints/cracks prepared.
BACKER_DEPTH1

NUMBER(2)
1/16 in

Depth of backer material or tape from pavement surface; measured at 10 random locations.
BACKER_DEPTH2

NUMBER(2)
1/16 in

Depth of backer material or tape from pavement surface; measured at 10 random locations.
BACKER_DEPTH3

NUMBER(2)
1/16 in

Depth of backer material or tape from pavement surface; measured at 10 random locations.
BACKER_DEPTH4

NUMBER(2)
1/16 in

Depth of backer material or tape from pavement surface; measured at 10 random locations.
BACKER_DEPTH5

NUMBER(2)
1/16 in

Depth of backer material or tape from pavement surface; measured at 10 random locations.
BACKER_DEPTH6

NUMBER(2)
1/16 in

Depth of backer material or tape from pavement surface; measured at 10 random locations.
BACKER_DEPTH7

NUMBER(2)
1/16 in

Depth of backer material or tape from pavement surface; measured at 10 random locations.
BACKER_DEPTH8

NUMBER(2)
1/16 in

Depth of backer material or tape from pavement surface; measured at 10 random locations.
DATE_COMPLETE

DATE


Date activity was completed.
BACKER_DEPTH9

NUMBER(2)
1/16 in

Depth of backer material or tape from pavement surface; measured at 10 random locations.
BACKER_DEPTH10

NUMBER(2)
1/16 in

Depth of backer material or tape from pavement surface; measured at 10 random locations.
MIN_BACKER_DEPTH

NUMBER(2)
1/16 in

Minimum depth of backer material or tape from pavement surface; measured at 10 random locations.
MAX_BACKER_DEPTH

NUMBER(2)
1/16 in

Maximum depth of backer material or tape from pavement surface measured at 10 random locations.
AVG_BACKER_DEPTH

NUMBER(2)
1/16 in

Average depth of backer material or tape from pavement surface; measured at 10 random locations.
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.
RESERVOIR_WIDTH1

NUMBER(2)
1/16 in

Sealant reservoir width; measured at 10 random locations.
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.
RESERVOIR_WIDTH2

NUMBER(2)
1/16 in

Sealant reservoir width; measured at 10 random locations.
RESERVOIR_WIDTH3

NUMBER(2)
1/16 in

Sealant reservoir width; measured at 10 random locations.
RESERVOIR_WIDTH4

NUMBER(2)
1/16 in

Sealant reservoir width; measured at 10 random locations.
RESERVOIR_WIDTH5

NUMBER(2)
1/16 in

Sealant reservoir width; measured at 10 random locations.