LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: SPS_INTERSECTIONS

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.
SIGNALS
Y_NVARCHAR2(1)


Code indicating if there are signals at the intersection.
UNSIGNALED
Y_NVARCHAR2(1)


Code indicating if an intersection within the project has traffic signals.
SHRP_ID

VARCHAR2(4)


Test section identification number assigned by LTPP program. Must be combined with STATE_CODE to be unique.
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.
ROUTE

VARCHAR2(30)


Name of the route that intersects with the test section.
PROJECT_STATION_NO

NUMBER


Project station number for the intersection.
RAMP_EXITS
Y_NVARCHAR2(1)


Code indicating if there are ramp exits at the intersection.
RAMP_ENTRANCES
Y_NVARCHAR2(1)


Code indicating if there are ramp entrances at the intersection.
STOP_SIGNS
Y_NVARCHAR2(1)


Code indicating if there are stop signs at the intersection.