LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: INV_ID

Field NameCodesData TypeUnitsTest ProtocolDescription
SHRP_ID

VARCHAR2(4)


Test section identification number assigned by LTPP program. Must be combined with STATE_CODE to be unique.
DIRECTION_OF_TRAVEL
DIRECTION_OF_TRAVELNUMBER(1)


Code for direction of traffic flow along entire route which includes test section.
MILEPOINT

NUMBER(5,2)
mi

Section starting point determined by adding the value on nearest milepost and distance to starting point. (e.g., .29 miles from milepost 114 should be 114.29).
ELEVATION

NUMBER(5)
ft

Elevation of section.
LOCATION_INFO

VARCHAR2(240)


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

VARCHAR2(12)


Section/grouped data identification assigned to any section of highway in the HPMS.
HPMS_SECTION_SD

VARCHAR2(2)


Code used to identify a further subdivision of an original HPMS section. Generally included as a 13th digit of the HPMS sample number.
SPEC_SECTION

NUMBER(2)


Identification of a linked SPS section.
COLLECT_DATE

DATE


Date of data collection/update.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
STATE_CODE
STATE_PROVINCENUMBER(2)


Numerical code for state or province. U.S. codes are consistent with Federal Information Processing Standards.
STATE_ASSIGNED_ID

NUMBER(4)


Code assigned by state that uniquely identifies the section.
SECTION_LENGTH

NUMBER(4)
ft

Length of test section.
SHA_DISTRICT_NO

NUMBER(2)


Number identifying the SHA district where pavement test section is located.
COUNTY
COUNTYNUMBER(3)


Code for county or parish where pavement section is located. County codes come from federal information processing standards publication 6. QC applies to GPS, see QC Manual for SPS.
FUNCTIONAL_CLASS
CLASSNUMBER(2)


Code for identifying the functional classification of the highway for which the pavement section is a sample. QC applies to GPS, see QC Manual for SPS.
ROUTE_SIGNING
ROUTE_SIGNINGNUMBER(1)


Code for the type of highway where the project is located.
ROUTE_NO

VARCHAR2(5)


Number assigned to highway where project is located.