LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: TRF_HIST_CLASS_MASTER

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

VARCHAR2(4)
hhmm

Time when classification count began.
CLASS_COUNT_END_TIME

VARCHAR2(4)
hhmm

Time when classification count ended.
CLASS_COUNT_DURATION_HOUR

NUMBER(3)
hr

Duration of classification count in hours.
CLASS_COUNT_TYPE
CLASS_COUNT_TYPEVARCHAR2(1)


Code indicating manual or auto classification count.
CLASS_COUNT_NO_LANES

NUMBER(2)


Number of lanes for which classification count was done.
CLASS_EQUIPMENT_TYPE
CLASS_EQUIPMENT_TYPEVARCHAR2(1)


Type of equipment used for classification count.
CLASS_EQUIPMENT_NAME

VARCHAR2(30)


Name/Model# of equipment used for classification count.
CLASS_NO_VEHICLES

NUMBER(7)


Number of vehicles classified.
CLASS_NO_TRUCKS

NUMBER(5)


Number of trucks classified.
CLASS_PCT_TRUCKS

NUMBER(4,1)
%

Percent of vehicles classified which are trucks.
SHRP_ID

VARCHAR2(4)


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

NUMBER(5)


Number of trucks traveling in the LTPP lane.
CLASS_PCT_TRUCKS_LTPP_LN

NUMBER(4,1)
%

Percent of vehicles which are trucks in the LTPP lane.
METH_VEHICLE_CLASS
METH_VEHICLE_CLASSVARCHAR2(1)


Code indicating the classification scheme used.
NO_CLASS_BINS

NUMBER(2)


Number of classification bins.
TOT_NO_VEH_2WAY

NUMBER(6)


Total number of vehicles for all the vehicle classes both directions.
TOT_NO_VEH_LTPP_DIR

NUMBER(7)


Total number of vehicles in the LTPP direction.
TOT_NO_VEH_LTPP_LN

NUMBER(6)


Total number of vehicles in the LTPP lane.
DATE_DATA_REVIEWED

DATE


Date of sheet data verification.
CLASS_COUNT_BEGIN_DATE

DATE


Date when classification count began.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
ROUTE_NO

VARCHAR2(10)


Number assigned to highway where SHA count is located.
MILEPOST

NUMBER(5,2)


Milepost of the count location.
LOCATION_INFO

VARCHAR2(30)


Additional information (i.e. landmarks) regarding location of the count.
FUNC_CLASS
FUNC_CLASSVARCHAR2(2)


Code identifying the functional classification of the highway sampled.
CLASS_COUNT_END_DATE

DATE


Date when classification count ended.