LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: SPS4_DYNAFLECT_MEASURE

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

NUMBER(4,2)
mils

Deflection readings for sensor 2.
DEFLECT3

NUMBER(4,2)
mils

Deflection readings for sensor 3.
DEFLECT4

NUMBER(4,2)
mils

Deflection readings for sensor 4.
DEFLECT5

NUMBER(4,2)
mils

Deflection readings for sensor 5.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
STATE_CODE
STATE_PROVINCENUMBER(2)


Numerical code for state or province. U.S. codes are consistent with Federal Information Processing Standards.
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.
STATION

NUMBER(5,1)
ft

Section station number.
SIDE_OF_JOINT_CRACK
SIDE_LOCATIONNUMBER(1)


Code indicating side of joint/crack where measurements were taken.
LOCATION_AT
LOCATION_DYNAFLECTNUMBER(1)


Code indicating location of test.
JOINT_NO

NUMBER(3)


Sequential number assigned to pavement joint.
DEFLECT1

NUMBER(4,2)
mils

Deflection readings for sensor 1.