LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: SMP_ATEMP_RAIN_DAY

Field NameCodesData TypeUnitsTest ProtocolDescription
SHRP_ID

VARCHAR2(4)


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

NUMBER(5,1)
mm

Total rainfall for the day.
NO_TEMP_HOUR

NUMBER(2)


Number of hours for which temperatures were collected.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
STATE_CODE
STATE_PROVINCENUMBER(2)


Numerical code for state or province. U.S. codes are consistent with Federal Information Processing Standards.
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.
SMP_DATE

DATE


Measurement date.
AVG_DAY_AIR_TEMPERATURE

NUMBER(3,1)
deg C

Average daily ambient air temperature.
MAX_AIR_TEMPERATURE

NUMBER(3,1)
deg C

Maximum daily ambient air temperature.
MAX_ATEMP_TIME

VARCHAR2(4)
hhmm

Time for maximum daily ambient air temperature.
MIN_AIR_TEMPERATURE

NUMBER(3,1)
deg C

Minimum daily ambient air temperature.
MIN_ATEMP_TIME

VARCHAR2(4)
hhmm

Time for minimum daily ambient air temperature.