LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: SPS_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.
DATE_COMPLETE

DATE


Date activity was completed.
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.
DIRECTION_OF_TRAVEL
DIRECTION_OF_TRAVELNUMBER(1)


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

NUMBER(5,2)


Milepost at which the section is located.
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(1)


Code used to identify a further subdivision of an original HPMS section. Generally included as a 13th digit of the HPMS sample number.
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.
COLLECT_DATE

DATE


The date (month/year) "as built" construction inventory data were collected.
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)


Number identifying the functional classification of highway for sample pavement section.
ROUTE_SIGNING
ROUTE_SIGNINGNUMBER(1)


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

VARCHAR2(15)


Number assigned to highway where project is located.
NO_OF_LANES

NUMBER(1)


Number indicating the total number of through lanes in the direction of travel.