Skip to contentUnited States Department of Transportation - Federal Highway AdministrationSearch FHWAFeedback
Policy Information

VTRIS Documentation: TVT Database Structures

MASTRSTN

Master Station DB contains the latest Station records received from each state.

Field Field Name Type Width Description
1 STATECODE Character 2 FIPS State code
2 FCLASS Character 2 Functional Classification
3 STATIONID Character 6 Station Identification number
4 DIRECTION Character 1 Direction of Travel
5 LANE Character 1 Lane of Travel
6 POSTRTCAT Character 1 Posted Route Category code
7 POSTRTNUM Character 6 Posted Route Number
8 CONCRTCAT Character 1 Concurrent Route Category code
9 CONCRTNUM Character 6 Concurrent Route Number
10 COUNTYCODE Character 3 County code
11 HPMSSAMPLE Character 12 HPMS Sample Number
12 HPMSSUBNR Character 1 HPMS Subdivision Number
13 YEARESTABL Character 4 Year Station Established
14 YEARDISC Character 4 Year Station Discontinued
15 SITETYPE Character 1 Type of Site code
16 METHRETRV Character 1 Data Retrieval Method
17 MFGRCODE Character 2 ATR Equipment Manufacturer
18 STNLOCATION Character 50 Location of Station
19 NRLANES Character 2 Number of Lanes
20 LASTUPDATE Date 8 Date of last Update
21 NEWFLAG Character 1 New Flag

STNPARM

Designed to hold special default values. By adding the flags to be set for the control of processing.

Field Field Name Type Width Description
1 STATECODE Character 2 FIPS State code
2 FCLASS Character 2 Functional Classification
3 STATIONID Character 6 ATR Station Identification Number
4 DIRECTION Character 1 Direction of Travel
5 LANE Character 1 Lane of Travel
6 DATAYEAR Character 2 Year of the data
7 DATAMONTH Character 2 Month of the Data
8 PROCDATE Character 4 Date of the processing
9 MINHOURS Numeric 2 MIN # of hours per day required for valid Calculation
10 MINDAYS Numeric 2 MIN # of days per day required for valid Calculation
11 PRECTOL Numeric 3 Tolerance value of hourly count preceding a count = 0
12 SUCCTOL Numeric 3 Tolerance value of hourly count following a count = 0
13 CONSZERO Numeric 2 # of Consecutive ZERO hourly counts which are acceptable in a 24 hour period
14 HDATAYEAR Character 1 Flag Y/N if hourly record field is Edited
15 HDATAMON Character 1 Flag Y/N if hourly record field is Edited
16 HDATADOM Character 1 Flag Y/N if hourly record field is Edited
17 HDATADOW Character 1 Flag Y/N if hourly record field is Edited
18 HHOURDATA Character 1 Flag Y/N if hourly record field is Edited
19 HFOOTNOTE Character 1 Flag Y/N if hourly record field is Edited
20 SPRTCAT Character 1 Flag Y/N if hourly record field is Edited
21 SPRTNUM Character 1 Flag Y/N if hourly record field is Edited
22 SCRTCAT Character 1 Flag Y/N if hourly record field is Edited
23 SCRTNUM Character 1 Flag Y/N if hourly record field is Edited
24 SCOUNTYCD Character 1 Flag Y/N if hourly record field is Edited
25 SHMMSSAMP Character 1 Flag Y/N if hourly record field is Edited
26 SHPMSSUB Character 1 Flag Y/N if hourly record field is Edited
27 SYEARREST Character 1 Flag Y/N if hourly record field is Edited
28 SYEARDIS Character 1 Flag Y/N if hourly record field is Edited
29 SSITETYPE Character 1 Flag Y/N if hourly record field is Edited
30 SMETHRET Character 1 Flag Y/N if hourly record field is Edited
31 SMFGCODE Character 1 Flag Y/N if hourly record field is Edited
32 SSTNLOC Character 1 Flag Y/N if hourly record field is Edited

VMT

Vehicle Miles Travel DB contains values calculated from the Monthly files containing evaluated data

Field Field Name Type Width Description
1 VMTYEAR Character 2 Year of data for VMT Calculations
2 VMTMONTH Character 2 Month of data for VMT Calculations
3 STATECODE Character 2 FIPS State code
4 FCLASS Character 2 Functional Classification
5 FCMULT Numeric 5.3 Functional Classification Multiplier (% change in VMT)
6 VMT Numeric 8 Vehicle Miles Traveled (in thousands of miles)
7 ESTFLAG Character 1 Flag of Estimation

STATE

State contains the FIPS State code, Postal abbreviation and full state name for each state.

Field Field Name Type Width Description
1 STATECODE Character 2 FIPS State code
2 ABBREV Character 2 Postal Abbreviation for state
3 CENSUS Character 2 Census code for state
4 NAME Character 30 State name

Census field was added for user convenience.

STSSYYMM

Station DB to receive the Monthly State Station input data SS - State code, YY - Year, MM - Month

Field Field Name Type Width Description
1 RECID Character 1 Identifies type of file upon Input
2 STATECODE Character 2 FIPS State code
3 FCLASS Character 2 Functional Classification
4 STATIONID Character 6 Station Identification number
5 DIRECTION Character 1 Direction of Travel
6 LANE Character 1 Lane of Travel
7 POSTRTCAT Character 1 Posted Route Category code
8 POSTRTNUM Character 6 Posted Route Number
9 CONCRTCAT Character 1 Concurrent Route Category code
10 CONCRTNUM Character 6 Concurrent Route Number
11 COUNTYCODE Character 3 County code
12 HPMSSAMPLE Character 12 HPMS Sample Number
13 HPMSSUBNR Character 1 HPMS Subdivision Number
14 YEARESTABL Character 4 Year Station Established
15 YEARDISC Character 4 Year Station Discontinued
16 SITETYPE Character 1 Type of Site code
17 METHRETRV Character 1 Data Retrieval Method
18 MFGRCODE Character 2 ATR Equipment Manufacturer
19 STNLOCATION Character 50 Location of Station
20 NRLANES Character 2 Number of Lanes

MOSSYYMM

SS - State code, YY Year, MM - Month. The data and calculated values are processed from the SSYYMM DB into Monthly MOSSYYMM DB

Field Field Name Type Width Description
1 STATECODE Character 2 FIPS State code
2 FCLASS Character 2 Functional Classification
3 STATIONID Character 6 ATR Station Identification Number
4 DIRECTION Character 1 Direction of Travel
5 LANE Character 1 Lane of Travel
6 DATAYEAR Character 2 Year of the data
7 DATAMONTH Character 2 Month of the Data
8 TVCALCS Character 217 Traffic Volume Calculated
9 AVGDAY Numeric 7 Average day of the month
10 AVGSUN Numeric 7 Average Sunday
11 AVGMON Numeric 7 Average Monday
12 AVGTUE Numeric 7 Average Tuesday
13 AVGWED Numeric 7 Average Wednesday
14 AVGTHU Numeric 7 Average Thursday
15 AVGFRI Numeric 7 Average Friday
16 AVGSAT Numeric 7 Average Saturday
17 JAVDAY Numeric 7 Adjusted average day
18 JAVWDAY Numeric 7 Adjusted average weekday
19 WAVGDAY Numeric 7 Weighted average day
20 ESTFLAG Character 1 Estimated data flag

More Information

Contact

David Jones
Office of Highway Policy Information
202-366-5053
E-mail David

 
 
Updated: 04/04/2011
 

FHWA
United States Department of Transportation - Federal Highway Administration