LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: SHRP_INFO

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

VARCHAR2(6)


Six digit station identifier used by agency to identify data collection on S- ,C-, and W- cards.
LTPP_DIR
DIR_TRFNUMBER(1)


Direction of LTPP lane using Traffic Monitoring Guide conventions.
LTPP_LANE

NUMBER(1)


Number of the LTPP lane where 1 is the outer through lane.
LANES_LTPP_DIR

NUMBER(1)


The total number of through lanes in the LTPP direction.
LANES_NON_LTPP_DIR

NUMBER(1)


The total number of through lanes in the non-LTPP direction.
SRO_CLASS
SROVARCHAR2(1)


Qualitative indicator of the spatial relationship between the classification data site and the LTPP section or project, S - site specific, R - Site related, O - other.
SRO_WEIGHT
SROVARCHAR2(1)


Qualitative indicator of the spatial relationship between the weight data site and the LTPP section or project, S - site specific, R - Site related, O - other.
DATA_AVAILABILITY
DATA_AVAILABILITYNUMBER(1)


A qualitative description of the data available and its reliability for the period indicated.
FUNC_CLASS
FUNC_CLASSNUMBER(2)


Functional class of the route where the LTPP section is located.
COMMENTS

VARCHAR2(2000)


Notes by user on data issues
SHRP_ID

VARCHAR2(4)


Test section identification number assigned by LTPP program. Must be combined with STATE_CODE to be unique.
CARD4INFO
CARD4INFOVARCHAR2(1)


Indicates how to process data after column 51 on the 4-Card input record. This value is typically S(top). A numeric value requires entries in Traffic_Class_Convert_Data.
CARDCINFO
CARDCINFOVARCHAR2(1)


Indicates how to process data after column 89 on the C-Card input record. This value is typically S(top) for sites not under direct LTPP control where the value is 5(-digits/vehicle) as data is submitted for 15 not 13 classes. A numeric value requires entries in Traffic_Class_Convert_Data.
ERR_1AM1PM

VARCHAR2(1)


For this site is the 1AM > 1PM daily class error enforced.
ERR_8ZERO

VARCHAR2(1)


Indicator if the 8 + zero volume class error enforced. This is typically Y.
ERR_4STATIC

VARCHAR2(1)


Indicator if the 4 + Static volume daily class error enforced. This is typically Y.
LTPP_LN_ONLY

VARCHAR2(1)


Indicator if the LTPP Lane is the only one loaded. This is typically N.
USEFILENAME

VARCHAR2(1)


Indicator if the files are identified and loaded by the filename. This is typically Y.
UPDATE_LNDIR

VARCHAR2(1)


For this site change the loading lane (LOAD_LN) to the LTPP lane and only load this one lane. This is typically N.
LOAD_LN

NUMBER(1)


For this site if UPDATE_LNDIR is Y, from the file load this lane and renumber it to the LTPP LN value. The normal value is equal to LTPP_LN.
LOAD_DIR
DIR_TRFNUMBER(1)


For this site if UPDATE_LNDIR is Y, from the file load this lane and renumber it to the LTPP DIR value. The typical value is equal to LTPP_DIR.
START_DATE

DATE


Beginning of the interval for which the data applies.
LOAD_HOURS

VARCHAR2(1)


For this site, load data to HH_CL_CT table routinely. The value is typically N for any site not in SPSWIM_VALIDATION_INIT and Y otherwise. To capture days associated with time changes this value is set to Y.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
END_DATE

DATE


End of interval for which the data applies.
VOLUME_SITE

VARCHAR2(4)


Site identifier for location at which volume was collected.
CLASS_SITE

VARCHAR2(4)


Site identifier for location at which class was collected.
WIM_SITE

VARCHAR2(4)


Site identifier for location at which WIM was collected.
ID3

VARCHAR2(3)


Three digit station identifier used by agency to identify data location for 2-, 3-, 4-, and 7- cards.