LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: PROJECT_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.
UNSIGNALED
Y_NVARCHAR2(1)


Code indicating if an intersection within the project has traffic signals.
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.
PROJECT_STATION_NO

NUMBER(8,1)


Project station number for the intersection.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
ROUTE

VARCHAR2(40)


Name of the route that intersects with the test section.
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.
SIGNALS
Y_NVARCHAR2(1)


Code indicating if there are signals at the intersection.