LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: 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.
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.
DIRECTION_OF_TRAVEL
DIRECTION_OF_TRAVELVARCHAR2(1)


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

VARCHAR2(4)


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

NUMBER(2)


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

NUMBER(8,1)
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(8,1)
m

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

NUMBER(8,1)
m

Length of the test section.
SECTION_CUT_FILL
CUT_FILL_TYPEVARCHAR2(1)


Code indicating if subgrade structure is cut, fill, at-grade or some combination.