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