LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: DLR_OH_STRAIN_TRACE_SUM_PCC

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.
POINT_TYPE_1
DLR_POINT_TYPEVARCHAR2(1)


Code for the type of the 1st data point determined.
TIME_SMOOTH_1

NUMBER(6)
milliseconds

Time along the trace at which the 1st smoothed point was determined.
STRAIN_VALUE_SMOOTH_1

NUMBER(6,1)
microstrain

Value of the 1st point in microstrain for the smoothed trace.
POINT_TYPE_2
DLR_POINT_TYPEVARCHAR2(1)


Code for the type of the 2nd data point determined.
TIME_SMOOTH_2

NUMBER(6)
milliseconds

Time along the trace at which the 2nd smoothed point was determined.
STRAIN_VALUE_SMOOTH_2

NUMBER(6,1)
microstrain

Value of the 2nd point in microstrain for the smoothed trace.
POINT_TYPE_3
DLR_POINT_TYPEVARCHAR2(1)


Code for the type of the 3rd data point determined.
TIME_SMOOTH_3

NUMBER(6)
milliseconds

Time along the trace at which the 3rd smoothed point was determined.
STRAIN_VALUE_SMOOTH_3

NUMBER(6,1)
microstrain

Value of the 3rd point in microstrain for the smoothed trace.
POINT_TYPE_4
DLR_POINT_TYPEVARCHAR2(1)


Code for the type of the 4th data point determined.
SHRP_ID

VARCHAR2(4)


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

NUMBER(6)
milliseconds

Time along the trace at which the 4th smoothed point was determined.
STRAIN_VALUE_SMOOTH_4

NUMBER(6,1)
microstrain

Value of the 4th point in microstrain for the smoothed trace.
POINT_TYPE_5
DLR_POINT_TYPEVARCHAR2(1)


Code for the type of the 5th data point determined.
TIME_SMOOTH_5

NUMBER(6)
milliseconds

Time along the trace at which the 5th smoothed point was determined.
STRAIN_VALUE_SMOOTH_5

NUMBER(6,1)
microstrain

Value of the 5th point in microstrain for the smoothed trace.
POINT_TYPE_6
DLR_POINT_TYPEVARCHAR2(1)


Code for the type of the 6th data point determined.
TIME_SMOOTH_6

NUMBER(6)
milliseconds

Time along the trace at which the 6th smoothed point was determined.
STRAIN_VALUE_SMOOTH_6

NUMBER(6,1)
microstrain

Value of the 6th point in microstrain for the smoothed trace.
DATA_COLLECTION_FREQUENCY

NUMBER(7,3)
Hz

The data recording frequency for the sensor time-history trace.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
TEST_NAME

VARCHAR2(7)


Character string that uniquely identifies each series of test traces.
GAIN_ADJUST_FACTOR

NUMBER(7,2)
microstrain

Average value of the first 500 data points used as the zero point for trace interpretation.
RUN_NUMBER

NUMBER(3)


Consecutive number of the test runs within a defined testing matrix. This number is also used as the file extension for the raw data files.
TAG_ID

VARCHAR2(8)


Descriptive tag given to the channel within the data collection software.
TEST_DATE

DATE


Date the field test was performed.
CHANNEL

VARCHAR2(10)


The channel number on which the sensor is wired.
COMMENTS

VARCHAR2(1)


An unformatted field for the comments pertaining to the information stored in the table.
STRAIN_POINTS_REPORTED

VARCHAR2(10)


Number of peak points interpreted from the data trace.