LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: SPS1_PMA_DENSITY_PROFILE

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.
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.
STATE_CODE
STATE_PROVINCENUMBER(2)


Numerical code for state or province. U.S. codes are consistent with Federal Information Processing Standards.
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.
ATB_MEASURE
MEASUREVARCHAR2(1)


Measurement method of asphalt treated base.
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.
ATB_NO_MEASUREMENTS

NUMBER(2)


Number of measurements for asphalt treated base.
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.
AVERAGE_ATB

NUMBER(4,1)
pcf

Average density measurement for asphalt treated base.
MAXIMUM_ATB

NUMBER(4,1)
pcf

Maximum density measurement for asphalt treated base.
MINIMUM_ATB

NUMBER(4,1)
pcf

Minimum density measurement of the asphalt treated base layer.
STD_DEV_ATB

NUMBER(4,1)


Standard deviation of density measurement for asphalt treated base.
LAYER_NO_ATB

NUMBER(2)


Layer number of asphalt treated base.