LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: SPS_GENERAL

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

VARCHAR2(20)


Type of shoulder surface for inside shoulder if other than those specified
I_SH_WIDTH

NUMBER(2)
ft

Total width of inside shoulder (paved and unpaved).
I_SH_PAVED_WIDTH

NUMBER(2)
ft

Paved width of inside shoulder.
I_SH_BASE_TYPE
BASE_MATNUMBER(2)


Code identifying base materials used in inside shoulder.
I_SH_SURFACE_THICKNESS

NUMBER(3,1)
in

Surface thickness of inside shoulder.
I_SH_BASE_THICKNESS

NUMBER(3,1)
in

Inside shoulder base thickness.
O_SH_SURFACE_TYPE
SHOULDER_SURFACE_TYPENUMBER(1)


Code for surface type of material used for outside shoulder.
O_SH_SURFACE_TYPE_OTHER

VARCHAR2(20)


Type of material used for outside shoulder if other than those specified.
O_SH_WIDTH

NUMBER(2)
ft

Total width of outside shoulder (paved and unpaved).
O_SH_PAVED_WIDTH

NUMBER(2)
ft

Paved width of outside shoulder.
STATE_CODE
STATE_PROVINCENUMBER(2)


Numerical code for state or province. U.S. codes are consistent with Federal Information Processing Standards.
O_SH_BASE_TYPE
BASE_MATNUMBER(2)


Code identifying base materials used in outside shoulder.
O_SH_SURFACE_THICKNESS

NUMBER(3,1)
in

Average thickness of outside shoulder surface.
O_SH_BASE_THICKNESS

NUMBER(3,1)
in

Average base thickness along outside shoulder.
DRAINPIPE_DIAMETER

NUMBER(3,1)


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.
PAVEMENT_TYPE
PAVEMENTNUMBER(2)


Code identifying general type of pavement.
LANE_WIDTH

NUMBER(2)
ft

Width of lane being monitored.
LANE_NUMBER_MONITORED

NUMBER(1)


Number identifying lane being monitored; 1 indicates outside lane.
DRAINAGE_LOCATION
DRAINAGE_LOCATIONNUMBER(1)


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


Code indicating type of subsurface drainage.
OTHER_DRAINAGE_TYPE

VARCHAR2(40)


Drainage type if other than those specified.
I_SH_SURFACE_TYPE
SHOULDER_SURFACE_TYPENUMBER(1)


Code indicating type of shoulder surface for inside shoulder.