LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: SPSWIM_VALIDATION_INIT

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

NUMBER(4)


Last year with 210+ days of data collected under LTPPs Traffic Pooled Fund Study TPF-5(004).
COMMENTS

VARCHAR2(2000)


Indicates why data collection was stopped.
SHRP_ID

VARCHAR2(4)


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

VARCHAR2(1)


A code indicating the general quality of the data.
INSTALLATION_DATE

DATE


Date on which the equipment installation was complete for use in TPF-5(004).
FIRST_VALIDATION

DATE


Date the initial validation was performed under the SPS WIM Pooled Fund study.
BEGAN_DATA_COLLECTION

DATE


First day of data collected as part of the TPF-5(004).
ENDED_DATA_COLLECTION

DATE


Last day of data associated with the quality expected for TPF-5(004).
OUT_OF_STUDY_TPF

DATE


Date on which data collection under LTPPs Traffic Pooled Fund Study TPF-5(004) ended.
FIRST_FULL_YEAR

NUMBER(4)


First calendar year after the initial validation that could have at least 210 days of data.