LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: TRF_HIST_VOLUME_COUNT

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.
COUNT_DURATION_UNIT
COUNT_DURATION_UNITVARCHAR2(1)


Code indicating whether the unit of count duration is hour, day, or month.
COUNT_DURATION

NUMBER(3)


Duration of traffic volume count in specified units.
COUNTER_TYPE

VARCHAR2(14)


Type of counter.
COUNTER_NAME

VARCHAR2(14)


Counter name/model#.
COUNT_TYPE
COUNT_TYPEVARCHAR2(1)


Code indicating type of traffic volume count.
TOTAL_NO_VEHICLES_COUNT

NUMBER(8)


Total number of vehicles.
FACTOR_24_HR_COUNT

NUMBER(5,4)


Adjustment factor for 24 hour count.
FACTOR_AXLE_CORRECT

NUMBER(5,4)


Axle correction adjustment factor.
FACTOR_DAY_OF_WEEK

NUMBER(5,4)


Day of week adjustment factor.
FACTOR_MONTH

NUMBER(5,4)


Month adjustment factor. May be a combination of month and day of week if that is agency practice.
SHRP_ID

VARCHAR2(4)


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

VARCHAR2(40)


Description of other adjustment factor.
FACTOR_OTHER

NUMBER(5,4)


Other adjustment factor.
COUNT_AADT

NUMBER(6)


Annual average daily traffic in all lanes, two-way from count data.
DIRECTIONAL_DISTRIB_FACTOR

NUMBER(5,4)


Directional distribution factor.
LTPP_LANE_DISTRIB_FACTOR

NUMBER(5,4)


LTPP lane distribution factor.
COUNT_AADT_LTPP_LN

NUMBER(6)


Annual average daily traffic for the LTPP lane from count data.
DATE_DATA_REVIEWED

DATE


Date of sheet data verification.
COUNT_BEGIN_DATE

DATE


Date when traffic volume count began.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
ROUTE_NO

VARCHAR2(10)


Number assigned to highway where count is located.
MILEPOST

NUMBER(5,2)


Milepost at which the count is located.
COUNT_LOCATION

VARCHAR2(30)


Description of count location.
COUNT_BEGIN_TIME

VARCHAR2(4)


Time when traffic volume count began.
COUNT_END_TIME

VARCHAR2(4)
hhmm

Time when traffic volume count ended.