LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: AC_AGGR_GRADATION

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

NUMBER(4,1)
%

The percent by weight of aggregate passing the 5/8 inch sieve.
NO_40

NUMBER(4,1)
%

The percent by weight of aggregate passing the #40 sieve.
NO_50

NUMBER(4,1)
%

The percent by weight of aggregate passing the #50 sieve.
ONE_HALF

NUMBER(4,1)
%

The percent by weight of aggregate passing the 1/2 inch sieve.
NO_80

NUMBER(4,1)
%

The percent by weight of aggregate passing the #80 sieve.
THREE_EIGHTHS

NUMBER(4,1)
%

The percent by weight of aggregate passing the 3/8 inch sieve.
NO_100

NUMBER(4,1)
%

The percent by weight of aggregate passing the #100 sieve.
NO_4

NUMBER(4,1)
%

The percent by weight of aggregate passing the #4 sieve.
NO_200

NUMBER(4,1)
%

The percent by weight of aggregate passing the #200 sieve.
NO_8

NUMBER(4,1)
%

The percent by weight of aggregate passing the #8 sieve.
NO_10

NUMBER(4,1)
%

The percent by weight of aggregate passing the #10 sieve.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
NO_16

NUMBER(4,1)
%

The percent by weight of aggregate passing the #16 sieve.
SHRP_ID

VARCHAR2(4)


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

NUMBER(2)


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


Code indicating the type of aggregate.
TWO

NUMBER(4,1)
%

The percent by weight of aggregate passing the 2 inch sieve.
ONE_AND_HALF

NUMBER(4,1)
%

The percent by weight of aggregate passing the 1 and 1/2 inch sieve.
ONE

NUMBER(4,1)
%

The percent by weight of aggregate passing the 1 inch sieve.
SEVEN_EIGHTHS

NUMBER(4,1)
%

The percent by weight of aggregate passing the 7/8 inch sieve.
NO_30

NUMBER(4,1)
%

The percent by weight of aggregate passing the #30 sieve.
THREE_FOURTHS

NUMBER(4,1)
%

The percent by weight of aggregate passing the 3/4 inch sieve.