LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: SPS9_SP_PMA_AGGREGATE_PROP

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

NUMBER(3)
%

Coarse aggregate amount - percent by weight of coarse aggregate total.
AGGR_COMP_TYPE_C3
COARSE_AGG_COMPVARCHAR2(1)


Code indicating composition of coarse aggregate.
AGGR_COMP_TYPE_C3_OTHER

VARCHAR2(40)


Composition of coarse aggregate if other than those specified.
AGGR_COMP_PERCENT_C3

NUMBER(3)
%

Coarse aggregate amount - percent by weight of coarse aggregate total.
AGGR_COMP_TYPE_F1
FINE_AGG_COMPVARCHAR2(1)


Code indicating composition of fine aggregate.
AGGR_COMP_TYPE_F1_OTHER

VARCHAR2(40)


Composition of fine aggregate if other than those specified.
AGGR_COMP_PERCENT_F1

NUMBER(3)
%

Fine aggregate amount - percent by weight of fine aggregate total.
AGGR_COMP_TYPE_F2
FINE_AGG_COMPVARCHAR2(1)


Code indicating composition of fine aggregate.
AGGR_COMP_TYPE_F2_OTHER

VARCHAR2(40)


Composition of fine aggregate if other than those specified.
AGGR_COMP_PERCENT_F2

NUMBER(3)
%

Fine aggregate amount - percent by weight of fine aggregate total.
SHRP_ID

VARCHAR2(4)


Test section identification number assigned by LTPP program. Must be combined with STATE_CODE to be unique.
AGGR_COMP_TYPE_F3
FINE_AGG_COMPVARCHAR2(1)


Code indicating composition of fine aggregate.
AGGR_COMP_TYPE_F3_OTHER

VARCHAR2(40)


Composition of fine aggregate if other than those specified.
AGGR_COMP_PERCENT_F3

NUMBER(3)
%

Fine aggregate amount - percent by weight of fine aggregate total.
MINERAL_FILLER
SPS9_MINERAL_FILLERVARCHAR2(1)


Code indicating the type of mineral filler.
MINERAL_FILLER_OTHER

VARCHAR2(40)


Type of mineral filler if other than those specified.
COARSE_AGGR_BULK_SPEC

NUMBER(4,3)


Bulk specific gravity of coarse aggregate.
FINE_AGGR_BULK_SPEC

NUMBER(4,3)


Bulk specific gravity of the fine aggregate.
MINERAL_FILLER_BULK_SPEC

NUMBER(4,3)


Mean bulk specific gravity for mineral filler.
AGGR_COMB_BULK_SPEC

NUMBER(4,3)


Mean bulk specific gravity of aggregate combination.
EFFECTIVE_SPEC_GRAVITY

NUMBER(4,3)


Mean calculated effective specific gravity.
LAYER_NO

NUMBER(2)


Unique sequential number assigned to pavement layers, starting with layer 1 as the deepest layer (subgrade).
ANGULARITY_COARSE_ONE_FACE

NUMBER(4,1)
%

Coarse aggregate angularity for aggregates with one or more faces.
ANGULARITY_COARSE_TWO_FACES

NUMBER(4,1)
%

Coarse aggregate angularity for aggregates with two or more faces.
ANGULARITY_FINE

NUMBER(3,1)
%

Fine aggregate angularity.
SOUNDNESS_COARSE

NUMBER(3,1)
%

Coarse aggregate soundness.
SOUNDNESS_FINE

NUMBER(3,1)
%

Fine aggregate soundness.
COARSE_AGGREGATE_TOUGHNESS

NUMBER(3,1)
%

Toughness of coarse aggregate.
DELETERIOUS_MATERIALS

NUMBER(3,1)
%

Estimate of percentage of deleterious materials.
CLAY_CONTENT

NUMBER(3,1)
%

Clay content determined by the use of the Sand Equivalent.
THIN_ELONGATED_PARTICLES

NUMBER(2,1)
%

Percentage by weight of aggregate that have a maximum to minimum dimension ratio greater than 5.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
AGGR_COMP_TYPE_C1
COARSE_AGG_COMPVARCHAR2(1)


Code indicating composition of coarse aggregate.
AGGR_COMP_TYPE_C1_OTHER

VARCHAR2(40)


Composition of coarse aggregate if other than those specified.
AGGR_COMP_PERCENT_C1

NUMBER(3)
%

Coarse aggregate amount - percent by weight of coarse aggregate total.
AGGR_COMP_TYPE_C2
COARSE_AGG_COMPVARCHAR2(1)


Code indicating composition of coarse aggregate.
AGGR_COMP_TYPE_C2_OTHER

VARCHAR2(40)
%

Composition of coarse aggregate if other than those specified.