LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: SECTION_DRAINAGE

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

VARCHAR2(4)


Test section identification number assigned by LTPP program. Must be combined with STATE_CODE to be unique.
DRAINAGE_LOCATION
DRAINAGE_LOCATIONVARCHAR2(1)


Code indicating if subsurface drainage is continuous along section or at intermittent locations or not provided.
DRAINAGE_TYPE
DRAINAGE_TYPEVARCHAR2(1)


Code indicating type of subsurface drainage.
OTHER_DRAINAGE_TYPE

VARCHAR2(40)


Drainage type if other than those specified.
DRAINPIPE_DIAMETER

NUMBER(4,1)
in

Inside diameter of longitudinal drainpipes used for subsurface drainage.
LATERALS_SPACING

NUMBER(3)
ft

Average spacing for subdrainage laterals.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.