LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: MON_DRAIN_MASTER

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


Y or N indicating the presence or absence of a rodent screen.
LATERAL_TYPE
PIPE_TYPEVARCHAR2(1)


Code indicating type of pipe used for the lateral.
LATERAL_TYPE_OTHER

VARCHAR2(40)


Type of pipe used for the lateral, if other than those specified.
LATERAL_DIAMETER

NUMBER(3)
mm

Nominal inside diameter of the lateral pipe.
LATERAL_LENGTH

NUMBER(3,1)
m

Distance from lateral opening to mainline intersection, based on video inspection.
INTERSECT_TYPE
INTERSECT_TYPEVARCHAR2(1)


Code indicating type of intersection between the lateral and the mainline.
INTERSECT_TYPE_OTHER

VARCHAR2(40)


Type of intersection between the lateral and the mainline, if other than those specified.
MAINLINE_TYPE
PIPE_TYPEVARCHAR2(1)


Code indicating type of pipe used for the mainline.
MAINLINE_TYPE_OTHER

VARCHAR2(40)


Type of pipe used for the mainline, if other than those specified.
MAINLINE_DIAMETER

NUMBER(3)
m

Nominal inside diameter of the mainline pipe.
SITE_ID

VARCHAR2(4)


SPS Project ID or GPS SHRP_ID.
NEAREST_SECTION

VARCHAR2(4)


SHRP ID of the test section located closest to the lateral opening.
COMMENTS

VARCHAR2(80)


Other useful information about site design or layout.
LATERAL_ID

VARCHAR2(3)


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

VARCHAR2(1)


A code indicating the general quality of the data.
PROJECT_STATION

NUMBER(6,1)
m

The location of the lateral opening relative to the starting point of the first test section on the project.
END_OFFSET

NUMBER(4,1)
m

The distance from the inside edge of the paint strip located on the shoulder side of the traffic lane to the lateral opening.
EXIT_DEPTH
EXIT_DEPTHVARCHAR2(1)


The estimated depth of the lateral opening from the surface of the pavement.
EROSION_CONTROL
EROSION_CONTROLVARCHAR2(1)


Code indicating type of erosion control used at lateral opening.
EROSION_CONTROL_OTHER

VARCHAR2(40)


Type of erosion control used at lateral opening, if other than those specified.