LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: TRF_ESAL_INPUTS_SUMMARY

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

NUMBER(6,2)
mm

Average annual precipitation.
AVG_FREEZE_INDEX

NUMBER(5,1)
deg F degree days

Average freeze index.
CLIMATIC_REGION
CLIMATIC_REGIONVARCHAR2(1)


Code indicating the climatic region.
CLIMATIC_REGION_SOURCE
ESAL_SOURCEVARCHAR2(1)


Code indicating the climatic region data source.
FUNC_CLASS
FUNC_CLASSVARCHAR2(2)


Code indicating the functional classification of the route.
TSI

NUMBER(2,1)


The terminal serviceability index assigned to the section.
TSI_SOURCE
ESAL_SOURCEVARCHAR2(1)


Code indicating the source of the TSI.
PAVE_TYPE_ESAL
PAVE_TYPE_ESALVARCHAR2(1)


Code indicating the type of pavement used in ESAL calculations.
PAVE_TYPE_SOURCE
ESAL_SOURCEVARCHAR2(1)


Code indicating the source of the pavement type data.
SN_VALUE

NUMBER(3,1)


Structural number used for AC pavements.
SHRP_ID

VARCHAR2(4)


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

NUMBER(3,1)
in

Effective slab thickness used for PCC pavements.
SN_D_INPUT_SOURCE
ESAL_SOURCEVARCHAR2(1)


Code indicating the source of the SN or D value.
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.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
START_DATE

DATE


Beginning date for which these properties apply to the section.
END_DATE

DATE


End date for which these properties apply to this section.
DATE_COMPUTED

DATE


Date when properties were computed.
GPS_SPS
GPS_SPSVARCHAR2(1)


Code indicating if the section is a GPS or SPS section.
EXPERIMENT_NO

VARCHAR2(2)


Code indicating to which LTPP experiment the pavement section is assigned.