LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: SPS6_QC_MEASUREMENTS

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

NUMBER(4,1)
pcf

Minimum density measurement of rut level-up layer.
STD_DEV_RUT

NUMBER(4,1)
pcf

Standard deviation of density measurements of rut level-up layer.
LAYER_NO_RUT

NUMBER(2)


Layer number of rut level-up layer.
MILL_MEASURE
MEASUREVARCHAR2(1)


Code indicating the measurement method for the mill replacement layer.
MILL_NO_MEASUREMENTS

NUMBER(2)


Number of measurements taken for the mill replacement layer.
AVERAGE_MILL

NUMBER(4,1)
pcf

Average density measurement for the mill replacement layer.
MAXIMUM_MILL

NUMBER(4,1)
pcf

Maximum density measurement for the mill replacement layer.
MINIMUM_MILL

NUMBER(4,1)
pcf

Minimum density measurement of the mill replacement layer.
STD_DEV_MILL

NUMBER(4,1)


Standard deviation of density measurements for the mill replacement layer.
LAYER_NO_MILL

NUMBER(2)


Layer number of mill replacement layer.
STATE_CODE
STATE_PROVINCENUMBER(2)


Numerical code for state or province. U.S. codes are consistent with Federal Information Processing Standards.
BINDER_MEASURE
MEASUREVARCHAR2(1)


Code indicating the measurement method of the binder course layer.
BINDER_NO_MEASUREMENTS

NUMBER(2)


Number of measurements taken for the binder course layer.
AVERAGE_BINDER

NUMBER(4,1)
pcf

Average density measurement for the binder course layer.
MAXIMUM_BINDER

NUMBER(4,1)
pcf

Maximum density measurement for the binder course layer.
MINIMUM_BINDER

NUMBER(4,1)
pcf

Minimum density measurement of the binder course layer.
STD_DEV_BINDER

NUMBER(4,1)


Standard deviation of density measurements for binder course layer.
LAYER_NO_BINDER

NUMBER(2)


Layer number of binder course.
SURFACE_MEASURE
MEASUREVARCHAR2(1)


Code indicating measurement method used on the surface course layer.
SURFACE_NO_MEASUREMENTS

NUMBER(2)


Number of measurements taken on the surface course layer.
AVERAGE_SURFACE

NUMBER(4,1)
pcf

Average density measurement for the surface course layer.
CONSTRUCTION_NO

NUMBER(2)


Event number used to relate changes in pavement structure with other time dependent data elements. This field is set to 1 when a test section is initially accepted into LTPP and is incremented with each change to the layer structure.
MAXIMUM_SURFACE

NUMBER(4,1)
pcf

Maximum density measurement for the surface course layer.
MINIMUM_SURFACE

NUMBER(4,1)
pcf

Minimum density measurement for the surface course layer.
STD_DEV_SURFACE

NUMBER(4,1)


Standard deviation of density measurements for the surface course layer.
LAYER_NO_SURFACE

NUMBER(2)


Layer number of surface course.
FRICTION_MEASURE
MEASUREVARCHAR2(1)


Code indicating measurement method of the surface friction course layer.
FRICTION_NO_MEASUREMENTS

NUMBER(2)


Number of nuclear density measurements taken for the surface friction layer.
AVERAGE_FRICTION

NUMBER(4,1)
pcf

Average density measurement for the surface friction course layer.
MAXIMUM_FRICTION

NUMBER(4,1)
pcf

Maximum density measurement for the surface friction course layer.
MINIMUM_FRICTION

NUMBER(4,1)
pcf

Minimum density measurement of the surface friction course layer.
STD_DEV_FRICTION

NUMBER(4,1)


Standard deviation of density measurements of surface friction layer.
DATE_COMPLETE

DATE


Date activity was completed.
LAYER_NO_FRICTION

NUMBER(2)


Layer number of surface friction course.
NUCLEAR_GAUGE_MAKER

VARCHAR2(40)


Name of nuclear density gauge manufacturer.
GAUGE_MODEL_NUMBER

VARCHAR2(20)


Model number of the gauge.
GAUGE_ID_NUMBER

VARCHAR2(20)


Identification number of the nuclear density gauge.
GAUGE_COUNT_RATE

NUMBER(5)


Gauge count rate used for standardization.
PROFILOGRAPH_TYPE
PROFILOGRAPH_TYPENUMBER(1)


Code indicating type of profilograph used.
PROFILE_INDEX

NUMBER(3,1)
in/mi

Profile index of any profilograph measurements.
INTERP_METHOD
INTERPRETATION_METHODNUMBER(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.
DATE_BEGAN

DATE


Date operations began.
INCENTIVE_PAYMENT
Y_NVARCHAR2(1)


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

VARCHAR2(1)


A code indicating the general quality of the data.
RUT_MEASURE
MEASUREVARCHAR2(1)


Code indicating measurement method for the rut level-up layer.
RUT_NO_MEASUREMENTS

NUMBER(2)


Number of measurements taken for the rut level-up layer.
AVERAGE_RUT

NUMBER(4,1)
pcf

Average of the density measurements taken for the rut level-up layer.
MAXIMUM_RUT

NUMBER(4,1)
pcf

Maximum density measurement of rut level-up layer.