LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: SPS2_PCC_PROFILE_DATA

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


Code indicating if the surface profile was corrected by diamond grinding.
DATE_GRINDING_BEGAN

DATE


Date diamond grinding operations began.
DATE_GRINDING_COMPLETE

DATE


Date diamond grinding operations were completed.
GRINDING_REASON
GRINDING_REASONNUMBER(1)


Code indicating the reason for performing diamond grinding.
GRINDING_REASON_OTHER

VARCHAR2(40)


Reason for performing diamond grinding if other than those specified.
AVG_CUT_DEPTH

NUMBER(3,2)
in

Average depth of cut made during diamond grinding operations.
CUTTING_HEAD_WIDTH

NUMBER(5,2)
in

Width of the diamond grinder cutting head.
AVG_GROOVE_WIDTH

NUMBER(2,1)
in

Average groove width in the concrete surface.
AVG_BLADE_SPACING

NUMBER(2,1)
in

Average blade spacing of the diamond grinder.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
STATE_CODE
STATE_PROVINCENUMBER(2)


Numerical code for state or province. U.S. codes are consistent with Federal Information Processing Standards.
DATE_MEASURED

DATE


Date profile measurements were made.
PROFILOGRAPH_TYPE
PROFILOGRAPH_TYPENUMBER(1)


Code indicating type of profilograph used.
PROFILE_INDEX

NUMBER(3,1)
in/mi

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


Code indicating interpretation method used for profilograph measurements.
BLANKING_BAND_HEIGHT

NUMBER(3,2)
in

Height of blanking band for profilograph measurements.
CUTOFF_HEIGHT

NUMBER(3,2)
in

Cutoff height for profilograph measurements.
SURFACE_PROFILE_INCENTIVE
Y_NVARCHAR2(1)


Code indicating if the surface profile results were used as a basis of incentive payment.