Skip to content

Data Dictionary

Michael McCarthy edited this page Jan 29, 2026 · 3 revisions

Data Dictionary

Visum Database

Zones

Field Description Data Type Usage
CensusBlockGroup Census Block Group ID Integer Reference
CensusTrac Census Tract ID Integer Reference
District ID District Number Integer Reference
District Name District Name Text Reference
HousingUnits Number of Households (Occupied Housing Units) Float User-supplied Input to Household Submodels
HousingDensity Housing Units per square mile Float Calculated (Reference)
ACS_AvgHHSize Average HH Size for the Tract in ACS Float (rounded to 1 decimal place) Reference (Unused)
ACS_AvgHHSize_BG Average HH Size for the Block Group in ACS Float (rounded to 1 decimal place) User-supplied Input to Household Size model
HHINC Average Income for the Tract in ACS Float User-supplied Input to Household Income model
TotPopulation Total Population Float Reference (Unused)
TotEmployment Total Employment Float User-supplied Input
EMP_RETAIL Retail and Food Services Employment Float User-supplied Input
EMP_FIRES Finance, insurance, real estate, services Employment Float User-supplied Input
EMP_GOVERNMENT Government Employment Float User-supplied Input
EMP_EDUCATION Education Employment Float User-supplied Input
EMP_WTCU Wholesale trade, transportation, utilities Employment Float User-supplied Input
EMP_MFG Manufacturing Employment Float User-supplied Input
EMP_RESOURCE Agriculture, forestry, fishing, mining Employment Float User-supplied Input
EMP_HEALTH Health care, social assistance Employment Float User-supplied Input
EMP_SELF Self Employment Float User-supplied Input
EXT_AUTO_GROWTH External Auto growth rate Float User-supplied Input to External trip model
HHWRK0 Households with 0 Workers Float Household Submodel Ouput
HHWRK1 Households with 1 Workers Float Household Submodel Ouput
HHWRK2 Households with 2 Workers Float Household Submodel Ouput
HHWRK3 Households with 3+ Workers Float Household Submodel Ouput
HH1VEH0 Cross-classified Households with 1 person and 0 Vehicles Available Float Household Submodel Ouput
HH1VEH1 Cross-classified Households with 1 person and 1 Vehicle Available Float Household Submodel Ouput
HH2VEH0 Cross-classified Households with 2 persons and 0 Vehicles Available Float Household Submodel Ouput
HH2VEH1 Cross-classified Households with 2 persons and 1 Vehicle Available Float Household Submodel Ouput
HH2VEH2 Cross-classified Households with 2 persons and 2 Vehicles Available Float Household Submodel Ouput
HH3VEH0 Cross-classified Households with 3 persons and 0 Vehicles Available Float Household Submodel Ouput
HH3VEH1 Cross-classified Households with 3 persons and 1 Vehicle Available Float Household Submodel Ouput
HH3VEH2 Cross-classified Households with 3 persons and 2 Vehicles Available Float Household Submodel Ouput
HH3VEH3 Cross-classified Households with 3 persons and 3+ Vehicles Available Float Household Submodel Ouput
HH4VEH0 Cross-classified Households with 4+ persons and 0 Vehicles Available Float Household Submodel Ouput
HH4VEH1 Cross-classified Households with 4+ persons and 1 Vehicle Available Float Household Submodel Ouput
HH4VEH2 Cross-classified Households with 4+ persons and 2 Vehicles Available Float Household Submodel Ouput
HH4VEH3 Cross-classified Households with 4+ persons and 3+ Vehicles Available Float Household Submodel Ouput
INC_INDEX Index of Zonal Average Income to Regional Average Float (rounded to 1 decimal place) Household Submodel Ouput

Links

Field Description Data Type Usage
TypeNo Link Type Number Integer Lookup
NumLanes Number of Lanes by direction Integer User-supplied (VISUM attribute)
ADD_CAP Additional Hourly Capacity Integer User-supplied
V0PrT Free-flow Speed (mph) Integer User-supplied (VISUM attribute)
CapPrT Directional Capacity Integer Lookup from Link Type, used in previous assignment (tpyically OP)* (VISUM attribute)
VolVehPrT(AP) Assigned Volume (in Vehicles, Private Transport modes) Float Calculated, used in previous assignment (tpyically OP) (VISUM attribute)
AM_CAP AM Directional Capacity Integer Calculated
PM_CAP PM Directional Capacity Integer Calculated
OP_CAP OP Directional Capacity Integer Calculated
PMPK_CAP PM Peak Hour Directional Capacity Integer Calculated
AM_SPEED AM Congested Speed Integer Calculated
PM_SPEED PM Congested Speed Integer Calculated
OP_SPEED OP Congested Speed Integer Calculated
PMPK_SPEED PM Peak Hour Congested Speed Integer Calculated
AM_VOL AM Assigned Demand Float Calculated
PM_VOL PM Assigned Demand Float Calculated
OP_VOL OP Assigned Demand Float Calculated
VOL_CORR Volume LOS Corridor ID Integer Flag for Reporting
VOL_CORR_2 Volume LOS Corridor ID (secondary) Integer Flag for Reporting
TT_CORR Travel Time LOS Corridor ID Integer Flag for Reporting

* Some of the VISUM attributes are changed for each assignment and retain their values from the prior assignment, typically OP as these trips are assigned last in a model run. Take care when referencing these attributes directly.

Nodes

Intersection control and delay are a function of Node Type Number and Control Type lookup.

Field Description Data Type Usage
TypeNo Node Type Number 5 - Node Capacity for Two-way Stop
6, 20, 43 - Node Delay
Lookup
ControlType Intersection Control Type 0 - Unknown
1 - Uncontrolled
2 - Two-way Stop
3 - Signalized
4 - All-way Stop
5 - Roundabout
6 - Two-way Yield
User-supplied Input

Network

Network attributes are used to hold the scenario and base model years for the external growth calculation and a scenario name for naming output folders.

Field Description Data Type Usage
SCEN_YEAR Current Scenario Year Integer User-supplied Input
BASE_YEAR Base Year Integer User-supplied Input
SCENARIO Current Scenario Name Text User-supplied Input

These variables can be changed while creating/editing modifications to the base year network. The BASE_YEAR should remain at 2022 until the next model update. The SCEN_YEAR should be changed to 2045 or 2050 in future year modifications. Model Reporting ouputs are written to the folder SCOG_Model_2022\Outputs\ModelRun_SCENARIO_YYYYMMDD.

CSV Inputs

External Station Summary

Path: SCOG_Model_2022\SharedData\External\Ext_Sta_Summary.csv

Field Description Data Type Usage
NO External Zone Number Integer Lookup
Name External Corridor Name Text Reference
Notes Additional Notes Text Reference
AADT Total Average Annual Daily Traffic count Float Reference
Auto_AADT Average Annual Daily Auto Traffic count Float Reference
Trk_AADT Average Annual Daily Truck Traffic count Float Not Used (No Truck fields are used)
Auto_XX_O Auto XX Origin Trips Float User-supplied Input
Auto_XX_D Auto XX Destination Trips Float User-supplied Input
Auto_XIIX_OD Auto XI/IX Trips Float User-supplied Input
XI_W% XI Work Share of XI/IX Trips Float User-supplied Input
IX_W% IX Work Share of XI/IX Trips Float User-supplied Input
X_NW% XI/IX Non-Work Share of XI/IX Trips Float User-supplied Input
Auto_IX% Unused
Auto_XX% Unused
AutoXXO% Unused
AutoXXD% Unused
Auto_XX_O_Out Grown Auto XX Origin Trips Float Output
Auto_XX_D_Out Grown Auto XX Destination Trips Float Output
Auto_XIIX_OD_Out Grown Auto XI/IX Trips Float Output

Household Size Stratification Curves

Path: SCOG_Model_2022\SharedData\HH_Submodel\Parameters\HHSizeModel.csv

Field Description Data Type Usage
HHSIZE Zonal Average Household Size Float (rounded to 1 decimal place) Lookup
HH1 Household Size 1 proportion Float User-supplied Input
HH2 Household Size 2 proportion Float User-supplied Input
HH3 Household Size 3 proportion Float User-supplied Input
HH4 Household Size 4 proportion Float User-supplied Input

Household Income Stratification Curves

Path: SCOG_Model_2022\SharedData\HH_Submodel\Parameters\IncomeModel.csv

Field Description Data Type Usage
INC_INDEX Index of Zonal Average Income to Regional Average Float (rounded to 1 decimal place) Lookup
HHINC1 Household Income 1 proportion Float User-supplied Input
HHINC2 Household Income 2 proportion Float User-supplied Input
HHINC3 Household Income 3 proportion Float User-supplied Input
HHINC4 Household Income 4 proportion Float User-supplied Input

Household Number of Workers MNL Model

Path: SCOG_Model_2022\SharedData\HH_Submodel\Parameters\NumberOfWorkersModel_MNL.csv

Field Description Data Type Usage
Variable Variable name or ASC Text Lookup
Work0 Work0 Coefficient Float Input Parameter
Work1 Work1 Coefficient Float Input Parameter
Work2 Work2 Coefficient Float Input Parameter
Work3p Work3p Coefficient Float Input Parameter

Household Number of Vehicles MNL Model

Path: SCOG_Model_2022\SharedData\HH_Submodel\Parameters\NumberOfVehiclesModel_MNL.csv

Field Description Data Type Usage
Variable Variable name or ASC Text Lookup
Veh0 Veh0 Coefficient Float Input Parameter
Veh1 Veh1 Coefficient Float Input Parameter
Veh2 Veh2 Coefficient Float Input Parameter
Veh3 Veh3 Coefficient Float Input Parameter

Clone this wiki locally