LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: SPS9_LOAD_TRANSFER

Field NameCodesData TypeUnitsTest ProtocolDescription
STATE_CODE
STATE_PROVINCENUMBER(2)


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

NUMBER(3)
ft

Distance from the outer lane edge to the center of the load transfer device.
DOWEL_2

NUMBER(3)
ft

Distance from the outer lane edge to the center of the load transfer device.
DOWEL_3

NUMBER(3)
ft

Distance from the outer lane edge to the center of the load transfer device.
DOWEL_4

NUMBER(3)
ft

Distance from the outer lane edge to the center of the load transfer device.
DOWEL_5

NUMBER(3)
ft

Distance from the outer lane edge to the center of the load transfer device.
DOWEL_6

NUMBER(3)
ft

Distance from the outer lane edge to the center of the load transfer device.
DOWEL_7

NUMBER(3)
ft

Distance from the outer lane edge to the center of the load transfer device.
DOWEL_8

NUMBER(3)
ft

Distance from the outer lane edge to the center of the load transfer device.
DOWEL_9

NUMBER(3)
ft

Distance from the outer lane edge to the center of the load transfer device.
DOWEL_10

NUMBER(3)
ft

Distance from the outer lane edge to the center of the load transfer device.
SHRP_ID

VARCHAR2(4)


Test section identification number assigned by LTPP program. Must be combined with STATE_CODE to be unique.
DOWEL_11

NUMBER(3)
in

Distance from the outer lane edge to the center of the load transfer device.
DOWEL_12

NUMBER(3)
in

Distance from the outer lane edge to the center of the load transfer device.
DOWEL_13

NUMBER(3)
in

Distance from the outer lane edge to the center of the load transfer device.
DOWEL_14

NUMBER(3)
in

Distance from the outer lane edge to the center of the load transfer device.
DOWEL_DIAMETER

NUMBER(3,2)
in

Diameter of retrofit dowel bars.
BACKFILL_MATERIAL
BACKFILL_MATERIALVARCHAR2(1)


Code identifying the type of material used to backfill around the load transfer restoration device.
BACKFILL_OTHER

VARCHAR2(40)


Type of material used to backfill around the load transfer restoration device if other than those specified.
BOND_AGENT_BACKFILL
BOND_AGENT_BACKFILLVARCHAR2(1)


Code identifying the material used to bond the backfill material to the existing PCC pavement.
BOND_AGENT_OTHER

VARCHAR2(40)


Material used to bond the backfill material to the existing PCC pavement of other than those specified.
DATE_BEFORE_RESTORE

DATE


Date tests were conducted before load restoration.
DATE_COMPLETE

DATE


Date activity was completed.
DATE_AFTER_RESTORE

DATE


Date tests were conducted after load restoration.
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_BEGAN

DATE


Date operations began.
NO_JOINTS_IN_SECTION

NUMBER(3)


Number of joints in the test section.
NO_JOINT_RESTORE_LOCATIONS

NUMBER(3)


Number of joints where load transfer restoration was performed.
DEVICES_PER_JOINT

NUMBER(3)


Number of load restoration devices installed per joint.