LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: SMP_TDR_MOISTURE_SUPPORT

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

NUMBER(4,1)
%

Most appropriate value of the percent soil passing the 1-1/2" sieve for analysis. Determined from interpretation of available materials testing data.
ANALYSIS_ONE_HALF_PASSING

NUMBER(4,1)
%

Most appropriate value of the percent soil passing the 1/2" sieve for analysis. Determined from interpretation of available materials testing data.
ANALYSIS_NO_4_PASSING

NUMBER(4,1)
%

Most appropriate value of the percent soil passing the #4 sieve for analysis. Determined from interpretation of available materials testing data.
ANALYSIS_NO_10_PASSING

NUMBER(4,1)
%

Most appropriate value of the percent soil passing the #10 sieve for analysis. Determined from interpretation of available materials testing data.
ANALYSIS_NO_200_PASSING

NUMBER(4,1)
%

Most appropriate value of the percent soil passing the #200 sieve for analysis. Determined from interpretation of available materials testing data.
ANALYSIS_PLASTIC_LIMIT

NUMBER(3)
%

Most appropriate value of the plastic limit for analysis. Determined from interpretation of available materials testing data.
ANALYSIS_LIQUID_LIMIT

NUMBER(3)
%

Most appropriate value of the liquid limit for analysis. Determined from interpretation of available materials testing data.
SHRP_ID

VARCHAR2(4)


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

NUMBER(2)


ID number of TDR probe.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
SOIL_TYPE

VARCHAR2(6)


Description of the soil around the TDR sensor. Either COARSE or FINE.
SOURCE_SOIL_TYPE
SOURCE_SOIL_TYPEVARCHAR2(1)


Code describing the source of the SOIL_TYPE field.
DRY_DENSITY_TDR

NUMBER(4)
kg/cu m

Estimated in-situ dry density of the soil around the TDR probe.
SOURCE_DRY_DENSITY_TDR
SOURCE_DRY_DENSITY_TDRVARCHAR2(2)


Code describing the source of the DRY_DENSITY_TDR value.
COMMENTS_DRY_DENSITY_TDR

VARCHAR2(80)


Comments on the DRY_DENSITY_TDR value.