LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: DLR_OH_LVDT_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(5,1)
milliseconds

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

NUMBER(6,1)
microns

Value of the 1st point 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(5,1)
milliseconds

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

NUMBER(6,1)
microns

Value of the 2nd point 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(5,1)
milliseconds

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

NUMBER(6,1)
microns

Value of the 3rd point for the smoothed trace.
DATA_COLLECTION_FREQUENCY

NUMBER(7,3)
Hz

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

VARCHAR2(4)


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

NUMBER(7,2)
microns

Average value of the first 500 data points used as the zero point for trace interpretation.
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.
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(80)


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

VARCHAR2(10)


Number of peak points interpreted from data trace.