LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: PROJECT_ID

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

VARCHAR2(40)


A familiar, non-numeric designation for the route.
NO_OF_LANES

NUMBER(1)


The total number of through lanes in the direction of travel.
DATE_OPEN_TRAFFIC

DATE


Date (month/year) test section opened to traffic.
COST_PER_LANE_MILE

NUMBER(5)
1000s $

Total average construction (in thousands) cost per lane mile for test section.
MILEPOINT

NUMBER(7,2)


The milepoint of the start of the project.
ELEVATION

NUMBER(5)
ft

Elevation of section.
LOCATION_INFO

VARCHAR2(240)
ft

Text describing any additional location information, i.e. Significant landmarks.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
SHRP_ID

VARCHAR2(4)


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

DATE


The date (month/year) construction inventory data were collected.
HA_DISTRICT_NO

VARCHAR2(15)


Number identifying the Highway Agency district where pavement test section is located.
COUNTY
COUNTYVARCHAR2(3)


Code for county or parish where pavement section is located.
FUNCTIONAL_CLASS
CLASSVARCHAR2(2)


Code identifying the functional classification of the roadway.
ROUTE_NO

VARCHAR2(15)


Number assigned to highway where project is located.
ROUTE_SIGNING
HPMS_ROUTE_SIGNINGVARCHAR2(2)


Code for the type of highway where the project is located.
ROUTE_QUALIFIER
ROUTE_QUALIFIERVARCHAR2(2)


The route signing descriptive qualifier.