LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: SPS_PROJECT_STATIONS

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

VARCHAR2(4)


The 4 character identifier for the SPS project used to identify elements of information which are common to all sections in that project.
ORDER_NO

NUMBER(2)


Number representing sequential order of locations on project or test section.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
TEST_SECTION

VARCHAR2(6)


Six digit test section ID number comprised of STATE_CODE and SHRP_ID for the section found at this location on the project.
SECTION_START

NUMBER(7)
m

Location of the starting point of the test section relative to the starting point of the first test section on the project.
SECTION_END

NUMBER(7)
m

Location of the ending point of the test section relative to the starting point of the first test section on the project.
SECTION_CUT_FILL
CUT_FILL_TYPEVARCHAR2(1)


Code indicating if subgrade structure is cut, fill, at-grade or some combination.
DIRECTION_OF_TRAVEL
DIRECTION_OF_TRAVELNUMBER(1)


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