LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: TRF_BASIC_INFO

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.
DIR_TRAV_LTPP
DIR_TRAV_LTPPVARCHAR2(2)


General direction of travel of vehicles crossing over the LTPP test section.
MILEPOST

NUMBER(5,2)


Milepost at which the section is located.
HPMS_SAMPLE

VARCHAR2(12)


Section/grouped data identification assigned to a highway segment in the HPMS which included the LTPP section when it was accepted into the LTPP program.
HPMS_SUBDIV

VARCHAR2(2)


Code used to identify a further subdivision of an original HPMS section which applied at the time of the acceptance of the LTPP section into the study.
ACCESS_CONTROL
Y_NVARCHAR2(1)


Indicates whether access is controlled.
MEDIAN
Y_NVARCHAR2(1)


Code indicating if a median exists.
FUNC_CLASS_MOD
FUNC_CLASSNUMBER(2)


Code identifying the new functional class if section designation has changed since entry into the LTPP program.
FUNC_CLASS_MOD_DATE

DATE


Date when the route received its new designation.
SHRP_ID

VARCHAR2(4)


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

VARCHAR2(1)


A code indicating the general quality of the data.
NO_LTPP_LANES

NUMBER(1)


Number of lanes in the direction of the LTPP section.
TOT_LANES

NUMBER(2)


Total number of lanes on the roadway, both directions.
PAVE_TYPE_TRF
PAVE_TYPE_TRFVARCHAR2(1)


Code indicating the type of pavement structure
STATE_ID

NUMBER(4)


State assigned section identifier.
COUNTY_NAME

VARCHAR2(20)


Name of the county.
FUNC_CLASS
FUNC_CLASSNUMBER(2)


Code identifying the functional classification of the highway section.