LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: SMP_FROST_PENETRATION

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

NUMBER(4,3)
m

Top depth of a frozen layer.
FREEZE_TO

NUMBER(4,3)
m

Bottom depth of a frozen layer.
SHRP_ID

VARCHAR2(4)


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

DATE


Standard Data Dictionary description
FROZEN_LAYER_NO

NUMBER(1)


Serial Number for interpreted frozen layers.
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.
FREEZE_STATE
T_FVARCHAR2(1)


Code indicating whether or not the ground was frozen.
DEPTH_NO_FROM

NUMBER(2)


Serial Number for the top of a frozen layer.
DEPTH_NO_TO

NUMBER(2)


Serial Number for the bottom of a frozen layer.