LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: MON_T_PROF_INDEX_SECTION

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

NUMBER(7)
sq mm

Minimum section NEGATIVE_AREA.
NEGATIVE_AREA_MAX

NUMBER(7)
sq mm

Maximum section NEGATIVE_AREA.
POSITIVE_AREA_MEAN

NUMBER(6)
sq mm

Mean section POSITIVE_AREA.
POSITIVE_AREA_STD

NUMBER(6)
sq mm

Section POSITIVE_AREA sample standard deviation.
POSITIVE_AREA_MIN

NUMBER(6)
sq mm

Minimum section POSITIVE_AREA.
POSITIVE_AREA_MAX

NUMBER(6)
sq mm

Maximum section POSITIVE_AREA.
FILL_AREA_MEAN

NUMBER(6)
sq mm

Mean section FILL_AREA.
FILL_AREA_STD

NUMBER(6)
sq mm

Section FILL_AREA sample standard deviation.
FILL_AREA_MIN

NUMBER(6)
sq mm

Minimum section FILL_AREA.
FILL_AREA_MAX

NUMBER(6)
sq mm

Maximum section FILL_AREA.
SHRP_ID

VARCHAR2(4)


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

NUMBER(3)
mm

Mean section LLH_DEPTH_1_8.
LLH_DEPTH_1_8_STD

NUMBER(3)
mm

Section LLH_DEPTH_1_8 sample standard deviation.
LLH_DEPTH_1_8_MIN

NUMBER(3)
mm

Minimum section LLH_DEPTH_1_8.
LLH_DEPTH_1_8_MAX

NUMBER(3)
mm

Maximum section LLH_DEPTH_1_8.
RLH_DEPTH_1_8_MEAN

NUMBER(3)
mm

Mean section RLH_DEPTH_1_8.
RLH_DEPTH_1_8_STD

NUMBER(3)
mm

Section RLH_DEPTH_1_8 sample standard deviation.
RLH_DEPTH_1_8_MIN

NUMBER(3)
mm

Minimum section RLH_DEPTH_1_8.
RLH_DEPTH_1_8_MAX

NUMBER(3)
mm

Maximum section RLH_DEPTH_1_8.
MAX_MEAN_DEPTH_1_8

NUMBER(3)
mm

Maximum value of LLH_DEPTH_1_8_MEAN or RLH_DEPTH_1_8_MEAN.
LLH_WIDTH_1_8_MEAN

NUMBER(4)
mm

Mean section LLH_WIDTH_1_8.
SURVEY_DATE

DATE


Date survey was performed.
LLH_WIDTH_1_8_STD

NUMBER(4)
mm

Section LLH_WIDTH_1_8 sample standard deviation.
LLH_WIDTH_1_8_MIN

NUMBER(4)
mm

Minimum section LLH_WIDTH_1_8.
LLH_WIDTH_1_8_MAX

NUMBER(4)
mm

Maximum section LLH_WIDTH_1_8.
LLH_OFFSET_1_8_MEAN

NUMBER(4)
mm

Mean section LLH_OFFSET_1_8.
LLH_OFFSET_1_8_STD

NUMBER(4)
mm

Section LLH_OFFSET_1_8 sample standard deviation.
LLH_OFFSET_1_8_MIN

NUMBER(4)
mm

Minimum section LLH_OFFSET_1_8.
LLH_OFFSET_1_8_MAX

NUMBER(4)
mm

Maximum section LLH_OFFSET_1_8.
RLH_WIDTH_1_8_MEAN

NUMBER(4)
mm

Mean section RLH_WIDTH_1_8.
RLH_WIDTH_1_8_STD

NUMBER(4)
mm

Section RLH_WIDTH_1_8 sample standard deviation.
RLH_WIDTH_1_8_MIN

NUMBER(4)
mm

Minimum section RLH_WIDTH_1_8.
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.
RLH_WIDTH_1_8_MAX

NUMBER(4)
mm

Maximum section RLH_WIDTH_1_8.
RLH_OFFSET_1_8_MEAN

NUMBER(4)
mm

Mean section RLH_OFFSET_1_8.
RLH_OFFSET_1_8_STD

NUMBER(4)
mm

Section RLH_OFFSET_1_8 sample standard deviation.
RLH_OFFSET_1_8_MIN

NUMBER(4)
mm

Minimum section RLH_OFFSET_1_8.
RLH_OFFSET_1_8_MAX

NUMBER(4)
mm

Maximum section RLH_OFFSET_1_8.
LLH_DEPTH_WIRE_REF_MEAN

NUMBER(3)
mm

Mean section LLH_DEPTH_WIRE_REF.
LLH_DEPTH_WIRE_REF_STD

NUMBER(3)
mm

Section LLH_DEPTH_WIRE_REF sample standard deviation.
LLH_DEPTH_WIRE_REF_MIN

NUMBER(3)
mm

Minimum section LLH_DEPTH_WIRE_REF.
LLH_DEPTH_WIRE_REF_MAX

NUMBER(3)
mm

Maximum section LLH_DEPTH_WIRE_REF.
RLH_DEPTH_WIRE_REF_MEAN

NUMBER(3)
mm

Mean section RLH_DEPTH_WIRE_REF.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
RLH_DEPTH_WIRE_REF_STD

NUMBER(3)
mm

Section RLH_DEPTH_WIRE_REF sample standard deviation.
RLH_DEPTH_WIRE_REF_MIN

NUMBER(3)
mm

Minimum section RLH_DEPTH_WIRE_REF.
RLH_DEPTH_WIRE_REF_MAX

NUMBER(3)
mm

Maximum section RLH_DEPTH_WIRE_REF.
MAX_MEAN_DEPTH_WIRE_REF

NUMBER(3)
mm

Maximum value of LLH_DEPTH_WIRE_REF_MEAN or RLH_DEPTH_WIRE_REF_MEAN.
LLH_WIDTH_WIRE_REF_MEAN

NUMBER(4)
mm

Mean section LLH_WIDTH_WIRE_REF.
LLH_WIDTH_WIRE_REF_STD

NUMBER(4)
mm

Section LLH_WIDTH_WIRE_REF sample standard deviation.
LLH_WIDTH_WIRE_REF_MIN

NUMBER(4)
mm

Minimum section LLH_WIDTH_WIRE_REF.
LLH_WIDTH_WIRE_REF_MAX

NUMBER(4)
mm

Maximum section LLH_WIDTH_WIRE_REF.
LLH_OFFSET_WIRE_REF_MEAN

NUMBER(4)
mm

Mean section LLH_OFFSET_WIRE_REF.
LLH_OFFSET_WIRE_REF_STD

NUMBER(4)
mm

Section LLH_OFFSET_WIRE_REF sample standard deviation.
T_PROF_DEVICE_CODE
DEVICE_CODE_RUTVARCHAR2(1)


Code indicating type of profile measurement device.
LLH_OFFSET_WIRE_REF_MIN

NUMBER(4)
mm

Minimum section LLH_OFFSET_WIRE_REF.
LLH_OFFSET_WIRE_REF_MAX

NUMBER(4)
mm

Maximum section LLH_OFFSET_WIRE_REF.
RLH_WIDTH_WIRE_REF_MEAN

NUMBER(4)
mm

Mean section RLH_WIDTH_WIRE_REF.
RLH_WIDTH_WIRE_REF_STD

NUMBER(4)
mm

Section RLH_WIDTH_WIRE_REF sample standard deviation.
RLH_WIDTH_WIRE_REF_MIN

NUMBER(4)
mm

Minimum section RLH_WIDTH_WIRE_REF.
RLH_WIDTH_WIRE_REF_MAX

NUMBER(4)
mm

Maximum section RLH_WIDTH_WIRE_REF.
RLH_OFFSET_WIRE_REF_MEAN

NUMBER(4)
mm

Mean section RLH_OFFSET_WIRE_REF.
RLH_OFFSET_WIRE_REF_STD

NUMBER(4)
mm

Section RLH_OFFSET_WIRE_REF sample standard deviation.
RLH_OFFSET_WIRE_REF_MIN

NUMBER(4)
mm

Minimum section RLH_OFFSET_WIRE_REF.
RLH_OFFSET_WIRE_REF_MAX

NUMBER(4)
mm

Maximum section RLH_OFFSET_WIRE_REF.
NO_PROFILES

NUMBER(2)


Number of transverse profile measurements used to compute section statistics.
DATA_PROCESS_EXTRACT_DATE

DATE


Date data was extracted from related IMS tables for computed parameter processing.
NEGATIVE_AREA_MEAN

NUMBER(7)
sq mm

Mean section NEGATIVE_AREA.
NEGATIVE_AREA_STD

NUMBER(7)
sq mm

Section NEGATIVE_AREA sample standard deviation.