LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: TRF_HIST_WEIGHT_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.
DIRECTION_OF_TRAVEL
DIRECTION_OF_TRAVELVARCHAR2(1)


Code for direction of traffic flow along entire route which includes the site data.
FHWA_STATION_NO

VARCHAR2(5)


FHWA station identification number.
WEIGHT_EQUIPMENT_TYPE
WEIGHT_EQUIPMENT_TYPEVARCHAR2(1)


Type of equipment used for weighing .
WEIGHT_COUNT_DURATION_HOUR

NUMBER(3)
hr

Duration of weight count session in hours.
WEIGHT_COUNT_LANE
WEIGHT_COUNT_LANEVARCHAR2(2)


Code representing the lanes) in which the truck weight measurements were made.
WEIGHT_END_DATE

DATE


Date weight session ended.
WEIGHT_END_TIME

VARCHAR2(4)
hhmm

Time when weight session ended.
WEIGHT_EQUIPMENT_NAME

VARCHAR2(25)


Name/model number of equipment used for weighing.
WEIGHT_COUNT_PURPOSE
WEIGHT_COUNT_PURPOSEVARCHAR2(1)


Code indicating the purpose of conducting weight count session.
METH_VEHICLE_CLASS
METH_VEHICLE_CLASSVARCHAR2(1)


Code indicating the classification scheme used.
SHRP_ID

VARCHAR2(4)


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

NUMBER(2)


Number of classification bins.
PAVE_TYPE_TRF
PAVE_TYPE_TRFVARCHAR2(1)


Code indicating the type of pavement structure
CALIBRATION_INFORMATION

VARCHAR2(640)


Methodology for calibration of weighing device and frequency of calibration.
DATE_DATA_REVIEWED

DATE


Date of sheet data verification.
WEIGHT_BEGIN_DATE

DATE


Date when weight session began.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
WEIGHT_BEGIN_TIME

VARCHAR2(4)
hhmm

Time when weight session began.
ROUTE_NO

VARCHAR2(5)


Number assigned to highway where data was located.
MILEPOST

NUMBER(5,2)


Milepost at which the data was collected.
LOCATION_INFO

VARCHAR2(30)


Additional information (i.e. landmarks) regarding data location.
FUNC_CLASS
FUNC_CLASSVARCHAR2(2)


Code identifying the functional classification of the highway sampled.