LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: MON_DRAIN_CONDITION

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.
DITCH_CLEANING
Y_NVARCHAR2(1)


Y or N indicating the need for cleaning of the ditch.
DITCH_WATER
WATER_FLOWVARCHAR2(1)


Code indicating the presence of water in the lateral opening.
DRAIN_WATER
WATER_FLOWVARCHAR2(1)


Code indicating the presence of water in the drainage ditch.
OUTLET_EROSION
Y_NVARCHAR2(1)


Y or N indicating the presence or absence of erosion around the lateral opening.
SCREEN_CONDITION

VARCHAR2(40)


Description of the condition of the rodent screen.
VIDEO_TAKEN
Y_NVARCHAR2(1)


Y or N indicating whether video was taken during the inspection and is stored.
CLOUD_CONDITIONS

VARCHAR2(10)


A description of the cloud conditions.
SURVEY_AIR_TEMP

NUMBER(3,1)
deg C

Air temperature taken at the beginning of the inspection of the lateral.
PROCESS_DATE

DATE


Date the data was entered into the database.
PUMPING_EVIDENT
Y_NVARCHAR2(1)


Y or N indicating whether pumping was evident on pavement surface.
SITE_ID

VARCHAR2(4)


SPS Project ID or GPS SHRP_ID.
COMMENTS

VARCHAR2(80)


Additional information regarding condition of edge drain system.
LATERAL_ID

VARCHAR2(3)


A two-digit number assigned to each lateral opening.
SURVEY_DATE

DATE


The date the survey was performed.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
OPENING_CONDITION
LATERAL_CRUSHVARCHAR2(1)


Code indicating whether the lateral opening has experienced any crushing.
PRESENCE_OF_DEBRIS
SILT_DEBRISVARCHAR2(1)


Code indicating the presence of silt and debris in the lateral opening.
DITCH_VEGETATION
DITCH_VEGVARCHAR2(1)


Code indicating condition of the vegetation on the embankment.
DITCH_VEGETATION_OTHER

VARCHAR2(40)


Condition of the vegetation on the embankment, if other than those specified.