LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: MON_DRAIN_INSPECT

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

VARCHAR2(40)


Additional comments regarding the change in condition.
PROCESS_DATE

DATE


Date the data was entered into the database.
SITE_ID

VARCHAR2(4)


SPS Project ID or GPS SHRP_ID.
LATERAL_ID

VARCHAR2(3)


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

DATE


The date the survey was performed.
PROBE_DISTANCE

NUMBER(4,1)
m

Distance into the drainage system where the condition was encountered.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
DRAIN_CONDITION

VARCHAR2(40)


Type of change encountered in the drainage system.
PHOTO_TAKEN
Y_NVARCHAR2(1)


Y or N indicating whether a photo of the condition change was taken.
CONDITION_PASSABLE
Y_NVARCHAR2(1)


Y or N indicating whether the condition change was passable.