LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: TRAFFIC_SITE_REMARKS

Field NameCodesData TypeUnitsTest ProtocolDescription
REMARK_ID

NUMBER(6)


Sequential value assigned to uniquely identify remarks
REMARK_TYPE

VARCHAR2(20)


Scope of the comment
USER_NAME

VARCHAR2(31)


Individual entering the remark
SITE_REMARK

VARCHAR2(4000)


Additional comments on the site or data
LAST_MODIFIED

DATE


Date of the last change to the remark.
STATE_CODE
STATE_PROVINCENUMBER(2)


Numerical code for state or province. U.S. codes are consistent with Federal Information Processing Standards.
SHRP_ID

VARCHAR2(4)


Test section identification number assigned by LTPP program. Must be combined with STATE_CODE to be unique.
LANE_TRF

NUMBER(1)


Number of the lane for which the data was collected.
DIR_TRF
DIR_TRFNUMBER(1)


The direction to which the data applies.
TRF_DATA_TYPE
TRF_DATA_TYPENUMBER(1)


Code indicating if the remark applies to volume, classification, weight or all data.
START_DATE

DATE


First date for which this instance of the comment applies
END_DATE

DATE


Last date for which this instance of the comment applies
STD_REMARK
STD_REMARKNUMBER(5)


Code for the data or site characteristic