LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: SPS9_PMA_PROFILE

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


Code indicating if the surface profile was used as a basis of incentive payment.
SHRP_ID

VARCHAR2(4)


Test section identification number assigned by LTPP program. Must be combined with STATE_CODE to be unique.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
PROFILOGRAPH_TYPE
PROFILOGRAPH_TYPEVARCHAR2(1)


Code indicating type of profilograph used.
PROFILOGRAPH_TYPE_OTHER

VARCHAR2(40)


Type of profilograph used if other than those specified.
PROFILE_INDEX

NUMBER(3,1)
in/mi

Profile index of any profilograph measurements.
INTERPRETATION_METHOD
INTERPRETATION_METHODVARCHAR2(1)


Code indicating interpretation method used for profilograph measurements.
BLANK_BAND_HEIGHT

NUMBER(3,2)
in

Height of blanking band for profilograph measurements.
CUTOFF_HEIGHT

NUMBER(3,2)
in

Cutoff height for profilograph measurements.