Skip to content

Output Files

Enrique Sanchez edited this page Feb 17, 2022 · 28 revisions

The table below contains brief descriptions of the output files from the SANDAG travel model. Click on file names for more details on all variables in each input file. Navigate to Output Files Data Dictionary to browse through all input files and their respective attribute details.

Output Files Contents

File Name Description File Type
Skims
traffic_skims_[tod].omx Highway Impedance matrices for 5 time periods (tod = EA, AM, MD, PM,EV) OMX
transit_skims.omx Transit Impedance matrix OMX
Imp[truck_class][toll_class]_MD_DU.txt Mid-day commercial vehicle skims for 3 truck classes (truck_class = LHD, MHD, HHD) and 2 toll classes (toll_class = Toll, Non-Toll) TXT
Impldt_MD_Dist.txt TXT
Impldt_MD_Time.txt TXT
Demand Outputs
aoResults_pre.csv Pre-Auto-ownership output file CSV
aoResults.csv Post-Auto-ownership output file CSV
wsLocResults_[iteration].csv Work and school location output file for each iteration (iteration = 1, 2, 3) CSV
householdData_[iteration].csv Household output file for each iteration (iteration = 1, 2, 3) CSV
personData_[iteration].csv Person output file for each iteration (iteration = 1, 2, 3) CSV
indivTourData_[iteration].csv Individual tour output file for each iteration (iteration = 1, 2, 3) CSV
jointTourData_[iteration].csv Joint tour output file for each iteration (iteration = 1, 2, 3) CSV
indivTripData_[iteration].csv Individual trip output file for each iteration (iteration = 1, 2, 3) CSV
jointTripData_[iteration].csv Joint trip output file for each iteration (iteration = 1, 2, 3) CSV
airport_out.CBX.csv CBX airport model data list output file CSV
airport_out.SAN.csv SAN airport model data list output file CSV
crossBorderTours.csv Cross border tour list output file CSV
CrossBorderTrips.csv Cross border trip list output file CSV
visitorTours.csv Visitor tour list output file CSV
visitorTrips.csv Visitor trip list output file CSV
internalExternalTrips.csv Internal External trip list output file CSV
TNCTrips.csv TNC trips with routing information CSV
householdAVTrips Household autonomous vehicle trips CSV
Gen and trip sum.csv Commercial vehicle trips CSV
bikeMgraLogsum.csv CSV
bikeTazLogsum.csv CSV
CBDByMGRA_Vehicles.csv Number of vehicles of each MGRA in CBD, by 5 time periods CSV
PNRByTAP_Vehicles.csv Park and Ride by each TAP, and by 5 time period CSV
mgraParkingCost.csv Weighted average parking cost of each MGRA CSV
Demand Matrices
autoTrips_[tod]_[vot].omx Residential Auto Trip Matrix for 5 time periods (tod = EA, AM, MD, PM, EV) and three value of time bins (vot = low, med, high) OMX
tranTrips_[tod].omx Residential Transit Trip Matrix for 5 time periods (tod = EA, AM, MD, PM, EV) OMX
nmotTrips_[tod].omx Residential Non-motorized Trip Matrix for 5 time periods (tod = EA, AM, MD, PM, EV) OMX
othrTrips_[tod].omx Residential Other Trip Matrix for 5 time periods (tod = EA, AM, MD, PM, EV) OMX
autoAirportTrips.CBX_[tod]_[vot].omx Output CBX airport auto trip tables 5 time periods (tod = EA, AM, MD, PM, EV) and three value-of-time bins (vot = low, med, high) OMX
TranAirportTrips.CBX_[tod].omx Output CBX airport transit trip tables for 5 time periods (tod = EA, AM, MD, PM, EV) OMX
NmotAirportTrips.CBX_[tod].omx Output CBX airport non-motorized trip tables for 5 time periods (tod = EA, AM, MD, PM, EV) OMX
OthrAirportTrips.CBX_[tod].omx Output CBX airport other trip tables for 5 time periods (tod = EA, AM, MD, PM, EV) OMX
autoAirportTrips.SAN_[tod]_[vot].omx Output SAN airport auto trip tables 5 time periods (tod = EA, AM, MD, PM, EV) and three value-of-time bins (vot = low, med, high) OMX
TranAirportTrips.SAN_[tod].omx Output SAN airport transit trip tables for 5 time periods (tod = EA, AM, MD, PM, EV) OMX
NmotAirportTrips.SAN_[tod].omx Output SAN airport non-motorized trip tables for 5 time periods (tod = EA, AM, MD, PM, EV) OMX
OthrAirportTrips.SAN_[tod].omx Output SAN airport other trip tables for 5 time periods (tod = EA, AM, MD, PM, EV) OMX
autoCrossBorderTrips_[tod]_[vot].omx Output Cross Border auto trip tables by 5 time periods (tod = EA, AM, MD, PM, EV) and three value-of-time bins (vot = low, med, high) OMX
TranCrossBorderTrips_[tod].omx Output Cross Border transit trip tables for 5 time periods (tod = EA, AM, MD, PM, EV) OMX
NmotCrossBorderTrips_[tod].omx Output Cross Border non-motorized trip tables for 5 time periods (tod = EA, AM, MD, PM, EV) OMX
OthrCrossBorderTrips_[tod].omx Output Cross Border other trip tables for 5 time periods (tod = EA, AM, MD, PM, EV) OMX
autoVisitorTrips_[tod]_[vot].omx Output Visitor auto trip tables by 5 time periods (tod = EA, AM, MD, PM, EV) and three value-of-time bins (vot = low, med, high). OMX
TranVisitorTrips_[tod].omx Output Visitor transit trip tables for 5 time periods (tod = EA, AM, MD, PM, EV) OMX
NmotVisitorTrips_[tod].omx Output Visitor non-motorized trip tables for 5 time periods (tod = EA, AM, MD, PM, EV) OMX
OthrVisitorTrips_[tod].omx Output Visitor other trip tables for 5 time periods (tod = EA, AM, MD, PM, EV) OMX
AutoInternalExternalTrips_[tod]_[vot].omx Output Internal External auto trip tables for 5 time periods: XX= EA, AM, MD, PM, EV. OMX
TranInternalExternalTrips_[tod]_[vot].omx Output Internal External transit trip tables for 5 time periods: XX= EA, AM, MD, PM, EV. OMX
NmotInternalExternalTrips_[tod]_[vot].omx Output Internal External non-motorized trip tables for 5 time periods: XX= EA, AM, MD, PM, EV. OMX
OthrInternalExternalTrips_[tod]_[vot].omx Output Internal External other trip tables for 5 time periods: XX= EA, AM, MD, PM, EV. OMX
TNCVehicleTrips_[tod].omx Output TNC demand from the TNC fleet model by 5 time periods (tod = EA, AM, MD, PM, EV) OMX
emptyAVTrips.omx Empty autonomous vehicle demand OMX
trip_[tod].omx Total Trip tables to assign to the highway network by 5 time periods (tod = EA, AM, MD, PM, EV) OMX
Other
transponderModelAccessibilities.csv Accessibility output file from transponder ownership model CSV
Hwyload_sid1.shp SHP
tapLines.csv CSV
Temp_tazdata_cvm.csv CSV
EMFAC2017-SANDAG-[YEAR]-[SERVER]-[SEASON]-[YEAR]-sb375.xls The output emission result form EMFAC2017 XLS
EMFAC2017-SANDAG-[YEAR]-[SERVER]-[SEASON]-[YEAR]-sb375_sb375_[DATESTAMP].xls The output emission result form EMFAC2017 XLS
ShadowPricingOutput_school_10.csv CSV
ShadowPricingOutput_work_10.csv CSV
Trip_[sector type]_[tod].csv Commercial vehicle trip generation tables by 7 sector types (sector type = FA, GO, IN, RE, SV, TH, WH) and 5 time periods (tod = EA, AM, MD, PM, EV) CSV
TripMatrices.csv CSV
walkMgraEquivMinutes.csv CSV
walkMgraTapEquivMinutes.csv CSV
microMgraEquivMinutes.csv Output file from the micro-mobility/transit generalized cost calculator CSV
microMgraTapEquivMinutes.csv Output file from the micro-mobility/transit generalized cost calculator

Go To Top

Output Files Data Dictionary

Auto Skim by Time Period

TRAFFIC_SKIMS_<TIME_PERIOD>.OMX

where TIME_PERIOD = EA (Early AM), AM (AM Peak), MD (Midday), PM (PM Peak), EV (Evening)

Table Name Description
<time_period>_<traffic_class><_vot>_TIME Travel time for evaluation of volume-delay functions
<time_period>_<traffic_class><_vot>_DIST Travel distance
<time_period>_<traffic_class><_vot>_REL
<time_period>_<traffic_class><_vot>_TOLLCOST Total toll cost (only for TOLL traffic classes)
<time_period>_<traffic_class><_vot>_TOLLDIST Total distance on toll facilities (only for TOLL traffic classes)
<time_period>_<traffic_class><_vot>_MLCOST Total cost for managed lane facilities (only for TOLL traffic classes)
<time_period>_<traffic_class><_vot>_HOVDIST Distance on HOV facilities (only for HOV traffic classes)
*traffic class = SOV_TR, SOV_NT, HOV2, HOV3, TRK
vot = L (low), M (medium), and H (high)

Go To Top

Transit Skim

TRANSIT_SKIMS.OMX

Table Name Description
<time_period>_<transit_class>_GENCOST Total generalized cost which includes perception factors from assignment
<time_period>_<transit_class>_FIRSTWAIT actual wait time at initial boarding point
<time_period>_<transit_class>_XFERWAIT actual wait time at all transfer boarding points
<time_period>_<transit_class>_TOTALWAIT total actual wait time
<time_period>_<transit_class>_FARE fare paid
<time_period>_<transit_class>_XFERS number of transfers
<time_period>_<transit_class>_ACCWALK access actual walk time prior to initial boarding
<time_period>_<transit_class>_EGRWALK egress actial walk time after final alighting
<time_period>_<transit_class>_TOTALWALK total actual walk time
<time_period>_<transit_class>_TOTALIVTT Total actual in-vehicle travel time
<time_period>_<transit_class>_DWELLTIME Total dwell time at stops
<time_period>_BUS_DIST Distance travel in-vehicle
<time_period>_<transit_class>_BUSIVTT actual in-vehicle travel time on local bus mode
<time_period>_<transit_class>_LRTIVTT actual in-vehicle travel time on LRT mode
<time_period>_<transit_class> _CMRIVTT actual in-vehicle travel time on commuter rail mode
<time_period>_<transit_class> _EXPIVTT actual in-vehicle travel time on express bus mode
<time_period>_<transit_class>_LTDEXPIVTT actual in-vehicle travel time on premium bus mode
<time_period>_<transit_class>_BRTREDIVTT actual in-vehicle travel time on red BRT mode
<time_period>_<transit_class>_BRTYELIVTT actual in-vehicle travel time on yellow BRT mode
<time_period>_<transit_class>_BUSDIST distance travel in-vehicle on local bus mode
<time_period>_<transit_class>_LRTDIST distance travel in-vehicle on LRT mode
<time_period>_<transit_class>_CMRDIST distance travel in-vehicle on commuter rail mode
<time_period>_<transit_class>_EXPDIST distance travel in-vehicle on express/premium bus modes
<time_period>_<transit_class>_BRTDIST distance travel in-vehicle BRT mode
*time period = EA, AM, MD, PM, EV
transit_class = BUS, ALLPEN, PREM

Go To Top

Commercial Vehicle Skims by Classes for Toll

IMP*HD<TOLL_CLASS>_MD_DU.TXT

where *HD = LHD, MHD, HHD, and TOLL_CLASS = T (Toll) and N (Non-TOLL)

Table Name Description

Go To Top

Commercial Vehicle Distance Skim

IMPLDT_MD_DIST.TXT

Table Name Description

Go To Top

Commercial Vehicle Time Skim

IMPLDT_MD_TIME.TXT

Table Name Description

Go To Top

Auto Ownership Output

AORESULTS_PRE.CSV and AORESULTS.CSV

Column Name Description
HHID Unique Household ID
AO Auto ownership category:
0 = 0 autos
1 = 1 auto
2 = 2 autos
3 = 3 autos
4 = 4+ autos

Go To Top

Work and School Location Output

WSLOCRESULTS_<<ITERATION>>.CSV

Column Name Description
HHID Unique Household ID
homeMGRA Home MGRA zone
income Household income
personID Unique person ID
personNum Person number in household
personType Person type:
1 = Full-time worker
2 = Part-time worker
3 = University student
4 = Non-working adult
5 = Non-working senior
6 = Driving age student
7 = Pre-driving student
8 = Pre-school
personAge Age of person
Employment Category Employment category:
1 = Working Full Time worker
2 = Working Part Time workers, university student workers, and driving age student workers
3 = Non-working university students, non-workers, and driving age student workers
4 = Non-working pre-driving and preschool students
StudentCategory Student category:
1 = Preschool and K-12
2 = University/College
3 = Non-Student (Workers/Non-Workers)
WorkSegment Work segment = Work Occupation Category:
-1 = non-worker
0 = Management Business Science and Arts Labor
1 = Services Labor
2 = Sales and Office Labor
3 = Natural Resources Construction and Maintenance Labor
4 = Production Transportation and Material Moving Labor
5 = Military Labor
99999 = Work-at-Home
SchoolSegment School Segment = School District:
-1 = Non-Student
0 – 56 = School District
88888 = home schooling
WorkLocation Work location MGRA
0 = Non-Worker
99999 = Work-at-Home
WorkLocationDistance Distance from home to work location
WorkLocationLogsum Work location logsum
SchoolLocation School Location MGRA:
0 = non-student
88888 = home schooling
SchoolLocationDistance Distance from home to school location
SchoolLocationLogsum School location logsum

Go To Top

Household Data Output

HOUSEHOLDDATA_<<ITERATION>>.CSV

Column Name Description
hh_id Unique Household ID
home_mgra Home MGRA zone
income Household income
autos Household vehicle ownership (includes human-driven and autonomous):
0 = 0 vehicles
1 = 1 vehicle
2 = 2 vehicles
3 = 3 vehicles
4 = 4+ vehicles
HVs Household human-driven vehicle (HV) ownership:
0 = 0 HV
1 = 1 HV
2 = 2 HVs
3 = 3 HVs
4 = 4+ HVs
AVs Household autonomous vehicle (AV) ownership:
0 = 0 AV
1 = 1 AV
2 = 2 AVs
3 = 3 AVs
4 = 4+ AVs
transponder Transponder ownership:
0 = No
1 = Yes
cdap_pattern Coordinated daily activity pattern. See model specification document for the different patterns
out_escort_choice Outbound escort choice:
0 = No outbound escort
1-157 = Escort choice with 3 kids, 2 chauffeurs, and 2 escort type
inb_escort_choice Inbound escort choice:
0 = No inbound escort
1-157 = Escort choice with 3 kids, 2 chauffeurs, and 2 escort type
jtf_choice Joint Tour frequency choice (150 choices with 5 purposes on first tour, 5 purposes on 2nd tour (with possible no 2nd tours for some people), 3 party types (adult only, children only, adult/children combined) on first tour, and 3 party types on second tour

Go To Top

Person Data Output

PERSONDATA_<<ITERATION>>.CSV

Column Name Description
hh_id Unique Household ID
person_id Unique Person ID
person_num Person number in household
age Age of person
gender Gender of person: f = female, m = male
type Person type:
Child too young for school
Full-time worker
Non-worker
Part-time worker
Retired
Student of driving age
Student of non-driving age
University student
value_of_time Value of time: set to 0 for now
activity_pattern Activity pattern:
H = Home
M = Mandatory
N = Non-mandatory
imf_choice Individual mandatory tour frequency choice:
0 = No mandatory tours
1 = 1 work tour
2 = 2+ work tours
3 = 1 school tour
4 = 2+ school tours
5 = 1 work, 1 school tour
inmf_choice Individual non-mandatory tour frequency choice:
0 = NO non-mandatory tours
1 through 197 = number of non-mandatory tours by different non-mandatory tour frequency combinations: see individualnonmandatorytourfrequencyalternatives.csv in the UEC folder
fp_choice Free Parking choice:
-1 = no parking
1 = Free parking
2 = Paid parking
3 = Reimbursed parking
reimb_pct Percentage of parking reimbursed
tele_choice Tele commute choice:
-1 = Not a worker
0 = No telecommute
1 = 1 day a week
2 = 2-3 days a week
3 = 4 days a week
9 = Permanent work from home
ie_choice Internal-external trip choice:
1 = No
2 = Yes
timeFactorWork
timeFactorNonWork

Go To Top

Individual Tour Data Output

INDIVTOURDATA_<<ITERATION>>.CSV

Column Name Description
hh_id Unique Household ID
person_id Unique Person ID
person_num Person number in household
person_type Person type:
1 = full time worker
2 = part time worker
3 = university student
4 = non-working adult
5 = retiree
6 = driving age school children
7 = pre-driving age school children
8 = pre-school children
tour_id Tour ID for household and person
tour_category Tour category:
AT_WORK
INDIVIDUAL_NON_MANDATORY
INDIVIDUAL_MANDATORY
tour_purpose Tour purpose:
Discretionary
Eating Out
Escort
Maintenance
School
Shop
University
Visiting
Work
Work-Based
orig_mgra Original MGRA of tour
dest_mgra Destination MGRA of tour
start_period Start Period:
1 = Before 5:00AM
2 = 5:00AM-5:30AM
3 through 39 is every half hour time slots
40 = After 12:00AM
end_period End Period:
1 = Before 5:00AM
2 = 5:00AM-5:30AM
3 through 39 is every half hour time slots
40 = After 12:00AM
tour_mode Tour Mode:
1 = Drive Alone
2 = Shared Ride 2
3 = Shared Ride 3
4 = Walk
5 = Bike
6 = Walk to Transit
7 = Park and Ride to Transit
8 = Kiss and Ride to Transit
9 = TNC to Transit
10 = Taxi
11 = TNC Single
12 = TNC Shared
13 = School Bus
av_avail Autonomous vehicle availability for the tour:
0 = No
1 = Yes
tour_distance Tour distance
atwork_freq At-work sub tour frequency:
0 = Not on a work tour
1 = On a work tour with no sub tours
2 = On a work tour with one eat out sub-tour
3 = On a work tour with one business sub tour
4 = On a work tour with one other sub tour
5 = On a work tour with two business sub tours
6 = On a work tour with two other sub tours
7 = On a work tour with a combination of business/eat-out/other sub tours
num_ob_stops Number of outbound stops (0, 1, 2, 3+)
num_ib_stops Number of inbound stops (0, 1, 2, 3+)
valueOfTime Value of time ($ per hour)
util_1 through util_13 Utility for each tour mode (see tour mode for codes)
prob_1 through prob_13 Probability for each tour mode (see tour mode for codes)

Go To Top

Joint Tour Data Output

JOINTTOURDATA_<<ITERATION>>.CSV

Column Name Description
hh_id Unique Household ID
tour_id Tour ID for household and person
tour_category Tour category:
AT_WORK
INDIVIDUAL_NON_MANDATORY
INDIVIDUAL_MANDATORY
tour_purpose Tour purpose:
Discretionary
Eating Out
Escort
Maintenance
School
Shop
University
Visiting
Work
Work-Based
tour_composition Tour composition:
1 = Adults only
2 = Children only
3 = Adults and children
tour_participants Listing of person numbers participating on the joint tour
orig_mgra Original MGRA of tour
dest_mgra Destination MGRA of tour
start_period Start Period:
1 = Before 5:00AM
2 = 5:00AM-5:30AM
3 through 39 is every half hour time slots
40 = After 12:00AM
end_period End Period:
1 = Before 5:00AM
2 = 5:00AM-5:30AM
3 through 39 is every half hour time slots
40 = After 12:00AM
tour_mode Tour Mode:
1 = Drive Alone
2 = Shared Ride 2
3 = Shared Ride 3
4 = Walk
5 = Bike
6 = Walk to Transit
7 = Park and Ride to Transit
8 = Kiss and Ride to Transit
9 = TNC to Transit
10 = Taxi
11 = TNC Single
12 = TNC Shared
13 = School Bus
av_avail Autonomous vehicle availability for the tour:
0 = No
1 = Yes
tour_distance Tour distance
num_ob_stops Number of outbound stops (0, 1, 2, 3+)
num_ib_stops Number of inbound stops (0, 1, 2, 3+)
valueOfTime Value of time ($ per hour)
util_1 through util_13 Utility for each tour mode (see tour mode for codes)
prob_1 through prob_13 Probability for each tour mode (see tour mode for codes)

Go To Top

Individual Trip Data Output

INDIVTRIPDATA_<<ITERATION>>.CSV

Column Name Description
hh_id Unique Household ID
person_id Unique Person ID
person_num Person number in household
tour_id Tour ID for household and person
stop_id Stop ID on tour
Inbound Boolean for whether stop is inbound:
0 = No
1 = Yes
tour_purpose Tour purpose:
Discretionary
Eating Out
Escort
Maintenance
School
Shop
University
Visiting
Work
Work-Based
orig_purpose Origin Trip Purpose:
Discretionary
Eating Out
Escort
Home
Maintenance
School
Shop
University
Visiting
Work
Work-Based
Work related
dest_purpose Destination Trip Purpose:
Discretionary
Eating Out
Escort
Home
Maintenance
School
Shop
University
Visiting
Work
Work-Based
Work related
orig_mgra Original MGRA of trip
dest_mgra Destination MGRA of trip
parking_mgra Parking MGRA of trip
stop_period Stop Period:
1 = Before 5:00AM
2 = 5:00AM-5:30AM
3 through 39 is every half hour time slots
40 = After 12:00AM
trip_mode Trip Mode:
1 = Drive Alone
2 = Shared Ride 2
3 = Shared Ride 3
4 = Walk
5 = Bike
6 = Walk to Transit
7 = Park and Ride to Transit
8 = Kiss and Ride to Transit
9 = TNC to Transit
10 = Taxi
11 = TNC Single
12 = TNC Shared
13 = School Bus
av_avail Autonomous vehicle availability for the trip:
0 = No
1 = Yes
trip_board_tap Trip boarding Transit Access Point
trip_alight_tap Trip alighting Transit Access Point
set -1 = not transit trip
0 = local bus
1 = premium transit
2 = local plus premium with a transfer
tour_mode Tour Mode:
1 = Drive Alone
2 = Shared Ride 2
3 = Shared Ride 3
4 = Walk
5 = Bike
6 = Walk to Transit
7 = Park and Ride to Transit
8 = Kiss and Ride to Transit
9 = TNC to Transit
10 = Taxi
11 = TNC Single
12 = TNC Shared
13 = School Bus
driver_pnum Driver person number
orig_escort_stoptype Origin escort stop type
orig_escortee_pnum Origin escortee person number
dest_escort_stoptype Destination escort stop type
dest_escortee_pnum Destination escortee person number
valueOfTime Value of time ($ per hour)
transponder_avail Transponder availability for the trip:
0 = No
1 = Yes
micro_walkMode Micro-mobility choice on walk mode:
0 = Not walk or micro-mobility mode
1 = Walk mode
2 = Micro-mobility mode
3 = Micro-transit mode
micro_trnAcc Micro-mobility choice on transit access mode:
0 = Not walk or micro-mobility mode
1 = Walk mode
2 = Micro-mobility mode
3 = Micro-transit mode
micro_trnEqr Micro-mobility choice on transit egress mode:
0 = Not walk or micro-mobility mode
1 = Walk mode
2 = Micro-mobility mode
3 = Micro-transit mode

Go To Top

Joint Trip Data Output

JOINTTRIPDATA_<<ITERATION>>.CSV

Column Name Description
hh_id Unique Household ID
tour_id Tour ID for household and person
stop_id Stop ID on tour
inbound Boolean for whether stop is inbound:
0 = No
1 = Yes
tour_purpose Tour purpose:
Discretionary
Eating Out
Escort
Maintenance
School
Shop
University
Visiting
Work
Work-Based
orig_purpose Origin Trip Purpose:
Discretionary
Eating Out
Escort
Home
Maintenance
School
Shop
University
Visiting
Work
Work-Based
Work related
dest_purpose Destination Trip Purpose:
Discretionary
Eating Out
Escort
Home
Maintenance
School
Shop
University
Visiting
Work
Work-Based
Work related
orig_mgra Original MGRA of trip
dest_mgra Destination MGRA of trip
parking_mgra Parking MGRA of trip
stop_period Stop Period:
1 = Before 5:00AM
2 = 5:00AM-5:30AM
3 through 39 is every half hour time slots
40 = After 12:00AM
trip_mode Trip Mode:
1 = Drive Alone
2 = Shared Ride 2
3 = Shared Ride 3
4 = Walk
5 = Bike
6 = Walk to Transit
7 = Park and Ride to Transit
8 = Kiss and Ride to Transit
9 = TNC to Transit
10 = Taxi
11 = TNC Single
12 = TNC Shared
13 = School Bus
av_avail Autonomous vehicle availability for the trip
0 = No
1 = Yes
num_participants Number of participants on joint trip
trip_board_tap Trip boarding Transit Access Point
trip_alight_tap Trip alighting Transit Access Point
set -1 = not transit trip
0 = local bus
1 = premium transit
2 = local plus premium with a transfer
tour_mode Tour Mode:
1 = Drive Alone
2 = Shared Ride 2
3 = Shared Ride 3
4 = Walk
5 = Bike
6 = Walk to Transit
7 = Park and Ride to Transit
8 = Kiss and Ride to Transit
9 = TNC to Transit
10 = Taxi
11 = TNC Single
12 = TNC Shared
13 = School Bus
valueOfTime Value of time ($ per hour)
transponder_avail Transponder availability for the trip:
0 = No
1 = Yes
micro_walkMode Micro-mobility choice on walk mode:
0 = Not walk or micro-mobility mode
1 = Walk mode
2 = Micro-mobility mode
3 = Micro-transit mode
micro_trnAcc Micro-mobility choice on transit access mode:
0 = Not walk or micro-mobility mode
1 = Walk mode
2 = Micro-mobility mode
3 = Micro-transit mode
micro_trnEgr Micro-mobility choice on transit egress mode:
0 = Not walk or micro-mobility mode
1 = Walk mode
2 = Micro-mobility mode
3 = Micro-transit mode

Go To Top

Residential Auto Trips Matrix

AUTOTRIPS_<<TIME PERIOD>>_<<VOT>>.OMX

where TIME PERIOD = EA, AM, MD, PM, EV
VOT = LOW, MED, HIGH

Table Name Description
SOVNOTRPDR_<<time period>> Drive Alone Non-Transponder for <<time period>>
SOVTRPDR_<<time period>> Drive Alone Transponder for <<time period>>
SR2NOTRPDR_<<time period>> Shared Ride 2 Non-Transponder for <<time period>>
SR2TRPDR_<<time period>> Shared Ride 2 Transponder for <<time period>>
SR3NOTRPDR_<<time period>> Shared Ride 3 Non-Transponder for <<time period>>
SR3TRPDR_<<time period>> Shared Ride 3 Transponder for <<time period>>

Go To Top

Residential Transit Trips Matrix

TRANTRIPS_<<TIME PERIOD>>.OMX

where TIME PERIOD = EA, AM, MD, PM, EV

Table Name Description
WLK_SET_set1_<<time period>>
PNR_SET_set1_<<time period>>
KNR_SET_set1_<<time period>>
WLK_SET_set2_<<time period>>
PNR_SET_set2_<<time period>>
KNR_SET_set2_<<time period>>
WLK_SET_set3_<<time period>>
PNR_SET_set3_<<time period>>
KNR_SET_set3_<<time period>>

Go To Top

Residential Non-Motorized Trips Matrix

NMOTTRIPS_<<TIME PERIOD>>.OMX

where TIME PERIOD = EA, AM, MD, PM, EV

Table Name Description
WALK_<<time period>> Walk for <<time period>>
BIKE_<<time period>> Bike for <<time period>>

Go To Top

Residential Other Trips Matrix

OTHRTRIPS_<<TIME PERIOD>>.OMX

where TIME PERIOD = EA, AM, MD, PM, EV

Table Name Description
SCHLBUS_<<time period>> School Bus for <<time period>>

Go To Top

Airport Data Output

AIRPORT_OUT.<<AIRPORT>>.CSV

where AIRPORT = SAN, CBX

Column Name Description
id Unique ID of airport trip
direction Direction of trip:
0 if origin is Airport MGRA
1 if destination is Airport MGRA
purpose Trip Purpose:
0 = Resident Business
1 = Resident Personal
2 = Visitor Business
3 = Visitor Personal
4= External
size Party size (1, 2, 3, 4, 5+)
income Household income:
0=Less than $25K
1=$25K – $50K
2=$50K – $75K
3=$75K – $100K
4=$100K – $125K
5=$125K – $150K
6=$150K – $200K
7=$200K plus
nights Number of Nights stayed (o through 14+)
departtime Departure Period:
1 = Before 5:00AM
2 = 5:00AM-5:30AM
3 through 39 is every half hour time slots
40 = After 12:00AM
originmgra Origin MGRA of trip
destinationmgra Destination MGRA of trip
tripmode Trip Mode:
0 = Unknown
1 = Drive Alone
2 = Shared Ride 2
3 = Shared Ride 3
4 = Walk
5 = Bike
6 = Walk to Transit
7 = Park and Ride to Transit
8 = Kiss and Ride to Transit
9 = TNC to Transit
10 = Taxi
11 = TNC Single
12 = TNC Shared
av_avail Autonomous vehicle availability for the trip:
0 = No
1 = Yes
arrivalmode Arrival mode:
1 = Parking lot terminal
2 = Parking lot off-site San Diego Airport area
3 = Parking lot off-site private
4 = Pickup/Drop-off escort
5 = Pickup/Drop=off curbside
6 = Rental car
7 = Taxi
8 = TNC Single
9 = TNC Shared
10 = Shuttle/Van/Courtesy Vehicle
11 = Transit
boardingtap Boarding Transit Access Point
alightingtap Alighting Transit Access Point
set -1 = not transit trip
0 = local bus
1 = premium transit
2 = local plus premium with a transfer
valueOfTime Value of time ($ per hour)

Go To Top

Airport Auto Trips Matrix

AUTOAIRPORTTRIPS.<<AIRPORT>>_<<TIME PERIOD>>_<<VOT>>.OMX

where TIME PERIOD = EA, AM, MD, PM, EV
AIRPORT = SAN, CBX
VOT = LOW, MED, HIGH

Table Name Description
SR2_<<time period>> Shared Ride 2 for <<time period>>
SR3_<<time period>> Shared Ride 3 for <<time period>>
SOV_<<time period>> Drive Alone for <<time period>>

Go To Top

Airport Transit Trips Matrix

TRANAIRPORTTRIPS.<<AIRPORT>>_<<TIME PERIOD>>.OMX

where TIME PERIOD = EA, AM, MD, PM, EV
AIRPORT = SAN, CBX

Table Name Description
WLK_SET_set1_<<time period>>
PNR_SET_set1_<<time period>>
KNR_SET_set1_<<time period>>
WLK_SET_set2_<<time period>>
PNR_SET_set2_<<time period>>
KNR_SET_set2_<<time period>>
WLK_SET_set3_<<time period>>
PNR_SET_set3_<<time period>>
KNR_SET_set3_<<time period>>

Go To Top

Airport Non-Motorized Trips Matrix

NMOTAIRPORTTRIPS.<<AIRPORT>>_<<TIME PERIOD>>.OMX

where TIME PERIOD = EA, AM, MD, PM, EV
AIRPORT = SAN, CBX

Table Name Description
WALK_<<time period>> Walk for <<time period>>
BIKE_<<time period>> Bike for <<time period>>

Go To Top

Airport Other Trips Matrix

OTHRAIRPORTTRIPS.<<AIRPORT>>_<<TIME PERIOD>>.OMX

where TIME PERIOD = EA, AM, MD, PM, EV
AIRPORT = SAN, CBX

Table Name Description
SCHLBUS_<<time period>> School Bus for <<time period>>

Go To Top

Cross Border Tour Data

CROSSBORDERTOURS.CSV

Column Name Description
id Unique ID of Cross border tour
purpose Tour Purpose:
0 = Work
1 = School
2 = Cargo
3 =Shop
4 = Visit
5 = Other
sentri Boolean for sentri user:
False
True
poe Point of Entry:
0 = San Ysidro
1 = Otay Mesa
2 = Tecate
departTime Departure Period:
1 = Before 5:00AM
2 = 5:00AM-5:30AM
3 through 39 is every half hour time slots
40 = After 12:00AM
arriveTime Arrival Period:
1 = Before 5:00AM
2 = 5:00AM-5:30AM
3 through 39 is every half hour time slots
40 = After 12:00AM
originMGRA Origin MGRA of tour
destinationMGRA Destination MGRA of tour
originTAZ Origin TAZ of tour
destinationTAZ Destination TAZ of tour
tourMode Tour Mode:
1 = Drive Alone
2 = Shared Ride 2
3 = Shared Ride 3+
4 = Walk
avAvailable Autonomous vehicle availability for the trip
workTimeFactor
nomnWorkTimeFactor
valueOfTime Value of time ($ per hour)

Go To Top

Cross Border Trip Data

CROSSBORDERTRIPS.CSV

Column Name Description
tourid Unique ID of Cross border tour
tripid Unique ID of Cross border trip
originPurp Origin Trip Purpose:
-1 = Unknown
0 = Work
1 = School
2 = Cargo
3 = Shop
4 = Visit
5 = Other
destPurp Destination Trip Purpose:
-1 = Unknown
0 = Work
1 = School
2 = Cargo
3 = Shop
4 = Visit
5 = Other
originMGRA Origin MGRA of trip
DestinationMGRA Destination MGRA of trip
originTAZ Origin TAZ of trip
destinationTAZ Destination TAZ of trip
inbound Boolean for whether trip is inbound:
False
True
originIsTourDestination Boolean for whether trip origin is tour destination:
False
True
destinationIsTourDestination Boolean for whether trip destination is tour destination:
False
True
period Period:
1 = Before 5:00AM
2 = 5:00AM-5:30AM
3 through 39 is every half hour time slots
40 = After 12:00AM
tripMode Trip Mode:
1 = Drive Alone
2 = Shared Ride 2
3 = Shared Ride 3
4 = Walk
5 = Bike
6 = Walk to Transit
7 = Park and Ride to Transit
8 = Kiss and Ride to Transit
9 = TNC to Transit
10 = Taxi
11 = TNC Single
12 = TNC Shared
13 = School Bus
avAvailable Autonomous vehicle availability for the trip:
0 = No
1 = Yes
boardingTap Boarding Transit Access Point
alightingTap Alighting Transit Access Point
set -1 = not transit trip
0 = local bus
1 = premium transit
2 = local plus premium with a transfer
workTimeFactor
nomnWorkTimeFactor
valueOfTime Value of time ($ per hour)

Go To Top

Cross Border Auto Trips Matrix

AUTOCROSSBORDERTRIPS_<<TIME PERIOD>>_<<VOT>>.OMX

where TIME PERIOD = EA, AM, MD, PM, EV
VOT = LOW, MED, HIGH

Table Name Description
SR2_<<time period>> Shared Ride 2 for <<time period>>
SR3_<<time period>> Shared Ride 3 for <<time period>>
SOV_<<time period>> Drive Alone for <<time period>>

Go To Top

Cross Border Transit Trips Matrix

TRANCROSSBORDERTRIPS_<<TIME PERIOD>>.OMX

where TIME PERIOD = EA, AM, MD, PM, EV

Table Name Description
WLK_SET_set1_<<time period>>
PNR_SET_set1_<<time period>>
KNR_SET_set1_<<time period>>
WLK_SET_set2_<<time period>>
PNR_SET_set2_<<time period>>
KNR_SET_set2_<<time period>>
WLK_SET_set3_<<time period>>
PNR_SET_set3_<<time period>>
KNR_SET_set3_<<time period>>

Go To Top

Cross Border Non-Motorized Trips Matrix

NMOTCROSSBORDERTRIPS_<<TIME PERIOD>>.OMX

where TIME PERIOD = EA, AM, MD, PM, EV

Table Name Description
WALK_<<time period>> Walk for <<time period>>
BIKE_<<time period>> Bike for <<time period>>

Go To Top

Cross Border Other Trips Matrix

OTHRCROSSBORDERTRIPS_<<TIME PERIOD>>.OMX

where TIME PERIOD = EA, AM, MD, PM, EV

Table Name Description
SCHLBUS_<<time period>> School Bus for <<time period>>

Go To Top

Visitor Tour Data

VISITORTOURS.CSV

Column Name Description
id Unique ID of Visitor tour
segment Visitor Segment:
0 = Business
1 = Personal
purpose Visitor Tour Purpose:
0 = Work
1 = Recreation
2 = Dining
autoAvailable Boolean for Auto available:
0 = No
1 = Yes
partySize Party size (1 through 10+)
income Visitor income:
0 = < $30K
1 = $30K-$60K
2 = $60K-100K
3 = $100K-$150K
4 = $150K+
departTime Depart time:
1 = Before 5:00AM
2 = 5:00AM-5:30AM
3 through 39 is every half hour time slots
40 = After 12:00AM
arriveTime Arrive time:
1 = Before 5:00AM
2 = 5:00AM-5:30AM
3 through 39 is every half hour time slots
40 = After 12:00AM
originMGRA Origin MGRA of tour
destinationMGRA Destination MGRA of tour
tourMode Tour Mode:
1 = Drive Alone
2 = Shared Ride 2
3 = Shared Ride 3
4 = Walk
5 = Bike
6 = Walk to Transit
7 = Park and Ride to Transit
8 = Kiss and Ride to Transit
9 = TNC to Transit
10 = Taxi
11 = TNC Single
12 = TNC Shared
avAvailable Autonomous vehicle availability for the tour
outboundstops Number of outbound stops
inboundstops Number of inbound stops
valueOfTime Value of time ($ per hour)

Go To Top

Visitor Trip Data

VISITORTRIPS.CSV

tourid Unique ID of Visitor tour
Tripid Unique ID of Visitor trip
originPurp Origin Trip Purpose:
-1 = Unknown
0 = Work
1 = Recreation
2 = Dining
destPurp Destination Trip Purpose:
-1 = Unknown
0 = Work
1 = Recreation
2 = Dining
originMGRA Origin MGRA of trip
destinationMGRA Destination MGRA of trip
originTAZ Origin TAZ of trip
destinationTAZ Destination TAZ of trip
inbound Boolean for whether trip is inbound:
FALSE
TRUE
originIsTourDestination Boolean for whether trip origin is tour destination:
FALSE
TRUE
destinationIsTourDestination Boolean for whether trip destination is tour destination:
FALSE
TRUE
period Period:
1 = Before 5:00AM
2 = 5:00AM-5:30AM
3 through 39 is every half hour time slots
40 = After 12:00AM
tripMode Trip Mode:
1 = Drive Alone
2 = Shared Ride 2
3 = Shared Ride 3
4 = Walk
5 = Bike
6 = Walk to Transit
7 = Park and Ride to Transit
8 = Kiss and Ride to Transit
9 = TNC to Transit
10 = Taxi
11 = TNC Single
12 = TNC Shared
13 = School Bus
avAvailable Autonomous vehicle availability for the trip
0 = No
1 = Yes
boardingTap Boarding Transit Access Point
alightingTap Alighting Transit Access Point
set -1 = not transit trip
0 = local bus
1 = premium transit
2 = local plus premium with a transfer
valueOfTime Value of time ($ per hour)
partySize Party size
micro_walkMode Micro-mobility choice on walk mode:
0 = Not walk or micro-mobility mode
1 = Walk mode
2 = Micro-mobility mode
3 = Micro-transit mode
micro_trnAcc Micro-mobility choice on transit access mode:
0 = Not walk or micro-mobility mode
1 = Walk mode
2 = Micro-mobility mode
3 = Micro-transit mode
micro_trnEgr Micro-mobility choice on transit egress mode:
0 = Not walk or micro-mobility mode
1 = Walk mode
2 = Micro-mobility mode
3 = Micro-transit mode

Go To Top

Visitor Auto Trips Matrix

AUTOVISITORTRIPS_<<TIME PERIOD>>_<<VOT>>.OMX

where TIME PERIOD = EA, AM, MD, PM, EV
VOT = LOW, MED, HIGH

Table Name Description
SR2_<<time period>> Shared Ride 2 for <<time period>>
SR3_<<time period>> Shared Ride 3 for <<time period>>
SOV_<<time period>> Drive Alone for <<time period>>

Go To Top

Visitor Transit Trips Matrix

TRANVISITORTRIPS_<<TIME PERIOD>>.OMX

where TIME PERIOD = EA, AM, MD, PM, EV

Table Name Description
WLK_SET_set1_<<time period>>
PNR_SET_set1_<<time period>>
KNR_SET_set1_<<time period>>
WLK_SET_set2_<<time period>>
PNR_SET_set2_<<time period>>
KNR_SET_set2_<<time period>>
WLK_SET_set3_<<time period>>
PNR_SET_set3_<<time period>>
KNR_SET_set3_<<time period>>

Go To Top

Visitor Non-Motorized Trips Matrix

NMOTVISITORTRIPS_<<TIME PERIOD>>.OMX

where TIME PERIOD = EA, AM, MD, PM, EV

Table Name Description
WALK_<<time period>> Walk for <<time period>>
BIKE_<<time period>> Bike for <<time period>>

Go To Top

Visitor Other Trips Matrix

OTHRVISITORTRIPS_<<TIME PERIOD>>.OMX

where TIME PERIOD = EA, AM, MD, PM, EV

Table Name Description
SCHLBUS_<<time period>> School Bus for <<time period>>

Go To Top

Internal External Trip Data

INTERNALEXTERNALTRIPS.CSV

Column Name Description
hhID Household ID
personID PersonID
tourID Internal external tour ID
originMGRA Origin MGRA of trip
destinationMGRA Destination MGRA of trip
originTAZ Origin TAZ of trip
destinationTAZ Destination TAZ of trip
inbound Boolean for whether trip is inbound:
FALSE
TRUE
originIsTourDestination Boolean for whether trip origin is tour destination:
FALSE
TRUE
destinationIsTourDestination Boolean for whether trip destination is tour destination:
FALSE
TRUE
period Period:
1 = Before 5:00AM
2 = 5:00AM-5:30AM
3 through 39 is every half hour time slots
40 = After 12:00AM
tripMode Trip Mode:
1 = Drive Alone
2 = Shared Ride 2
3 = Shared Ride 3
4 = Walk
5 = Bike
6 = Walk to Transit
7 = Park and Ride to Transit
8 = Kiss and Ride to Transit
9 = TNC to Transit
10 = Taxi
11 = TNC Single
12 = TNC Shared
13 = School Bus
av_avail Autonomous vehicle availability for the trip
0 = No
1 = Yes
boardingTap Boarding Transit Access Point
alightingTap Alighting Transit Access Point
set -1 = not transit trip
0 = local bus
1 = premium transit
2 = local plus premium with a transfer
valueOfTime Value of time ($ per hour)

Go To Top

TNC Vehicle Trip Data

TNCTRIPS.CSV

Column Name Description
trip_ID Trip ID
vehicle_ID Vehicle ID
originTaz Origin TAZ
destinationTaz Destination TAZ
originMgra Origin MGRA
destinationMgra Destination MGRA
totalPassengers Number of passengers in the vehicle
startPeriod Trip starting period
endPeriod Trip ending period
pickupIdsAtOrigin Trip id of the pick-up at origin.
CR-RAMP:
  Individual trips:
  "I_" + personId + "_" + purpAbb + "_" + tourid + "_" + inbound + "_" + stopid
   where purpAbb is the first 3 letters of the tour_purp field
  Joint trips:
  "J_" + hhid + "_" + purpAbb + "_" + tourid + "_" + inbound + "_" + stopid + ”_” + i
   where i is a number ranging from 1 to the total number of participants.
Visitor trips:
  partySize == 1: "V_" + tourid + "_" + stopid
  partySize > 1: "V_" + tourid + "_" + stopid + ”_” + i
   where i is a number ranging from 1 to the total number of participants.
Cross-border trips:
  partySize == 1: "M_" + tourid + "_" + stopid
  partySize > 1: "M_" + tourid + "_" + stopid + ”_” + i
   where i is a number ranging from 1 to the total number of participants.
CBX airport trips:
  partySize == 1: "CBX_" + tourid + "_" + stopid
  partySize>1: "CBX_" + tourid + "_" + stopid + ”_” + i
   where i is a number ranging from 1 to the total number of participants.
SAN airport trips:
  partySize == 1: "SAN_" + tourid + "_" + stopid
  partySize > 1: "SAN_" + tourid + "_" + stopid + ”_” + i
   where i is a number ranging from 1 to the total number of participants.
Internal-External trips:
  "IE_" + tourid + "_" + inbound
dropoffIdsAtOrigin Trip id of the drop-off at origin. See pickupIdsAtOrigin for trip id of the trip.
pickupIdsAtDestination Trip id of the pick-up at destination. See pickupIdsAtOrigin for trip id of the trip.
dropoffIdsAtDestination Trip id of the drop-off at destination. See pickupIdsAtOrigin for trip id of the trip.
originPurpose Trip origin purpose
destinationPurpose Trip destination purpose

Go To Top

Household Autonomous Vehicle Trip Data

HOUSEHOLDAVTRIPS.CSV

Column Name Description
hh_id Household id
veh_id Vehicle id
vehicleTrip_id Vehicle trip id
orig_mgra Trip origin MGRA
dest_gra Trip destination MGRA
period Period:
1 = Before 5:00AM
2 = 5:00AM-5:30AM
3 through 39 is every half hour time slots
40 = After 12:00AM
occupants Number of occupants in the vehicle
originIsHome Is origin home?
0 = No
1 = Yes
destinationIsHome Is destination home?
0 = No
1 = Yes
originIsRemoteParking Is origin remote parking?
0 = No
1 = Yes
destinationIsRemoteParking Is destination remote parking?
0 = No
1 = Yes
parkingChoiceAtDestination Parking choice at destination:
0 = Not constrained to remote parking
1 = Park at destination
2 = Remote parking
3 = Park at home
person_id Person id
person_num Person number
tour_id Tour id
stop_id Stop id
inbound Is trip inbound?
1 = Yes
0 = No
tour_purpose Tour purpose:
Discretionary
Eating Out
Escort
Home
Maintenance
School
Shop
University
Visiting
Work
Work-Based
orig_purpose Origin trip purpose:
Discretionary
Eating Out
Escort
Home
Maintenance
School
Shop
University
Visiting
Work
Work-Based
Work related
dest_purpose Destination trip purpose:
Discretionary
Eating Out
Escort
Home
Maintenance
School
Shop
University
Visiting
Work
Work-Based
Work related
trip_orig_mgra Trip origin MGRA
trip_dest_mgra Trip destination MGRA
stop_period Stop period:
1 = Before 5:00AM
2 = 5:00AM-5:30AM
3 through 39 is every half hour time slots
40 = After 12:00AM
periodsUntilNextTrip
trip_mode Trip mode:
0 = Empty vehicle trip
1 = Drive Alone
2 = Shared Ride 2
3 = Shared Ride 3

Go To Top

TNC Vehicle Trips Matrix

TNCVEHICLETRIPS_<<TIME PERIOD>>.OMX

where TIME PERIOD = EA, AM, MD, PM, EV

Table Name Description
TNC_<<time period>>_0 TNC trips for <<time period>> with 0 passenger
TNC_<<time period>>_1 TNC trips for <<time period>> with 1 passenger
TNC_<<time period>>_2 TNC trips for <<time period>> with 2 passengers
TNC_<<time period>>_3 TNC trips for <<time period>> with 3 or more passengers

Go To Top

Empty Autonomous Vehicle Trips Matrix

EMPTYAVTRIPS.OMX

Table Name Description
EmptyAV_EA Empty AV trips for EA period
EmptyAV_AM Empty AV trips for AM period
EmptyAV_MD Empty AV trips for MD period
EmptyAV_PM Empty AV trips for PM period
EmptyAV_EV Empty AV trips for EV period

Go To Top

Internal External Auto Trips Matrix

AUTOINTERNALEXTERNALTRIPS_<<TIME PERIOD>>_<<VOT>>.OMX

where TIME PERIOD = EA, AM, MD, PM, EV
VOT = LOW, MED, HIGH

Table Name Description
SR2_<<time period>> Shared Ride 2 for <<time period>>
SR3_<<time period>> Shared Ride 3 for <<time period>>
SOV_<<time period>> Drive Alone for <<time period>>

Go To Top

Internal External Transit Trips Matrix

TRANINTERNALEXTERNALTRIPS_<<TIME PERIOD>>.OMX

where TIME PERIOD = EA, AM, MD, PM, EV

Table Name Description
WLK_SET_set1_<<time period>>
PNR_SET_set1_<<time period>>
KNR_SET_set1_<<time period>>
WLK_SET_set2_<<time period>>
PNR_SET_set2_<<time period>>
KNR_SET_set2_<<time period>>
WLK_SET_set3_<<time period>>
PNR_SET_set3_<<time period>>
KNR_SET_set3_<<time period>>

Go To Top

Internal External Non-Motorized Trips Matrix

NMOTINTERNALEXTERNALTRIPS_<<TIME PERIOD>>.OMX

where TIME PERIOD = EA, AM, MD, PM, EV

Table Name Description
WALK_<<time period>> Walk for <<time period>>
BIKE_<<time period>> Bike for <<time period>>

Go To Top

Internal External Other Trips Matrix

OTHRINTERNALEXTERNALTRIPS_<<TIME PERIOD>>.OMX

where TIME PERIOD = EA, AM, MD, PM, EV

Table Name Description
SCHLBUS_<<time period>> School Bus for <<time period>>

Go To Top

Commercial Vehicle Trip Generation Table

TRIPMATRICES.CSV

where TIME PERIOD = EA, AM, MD, PM, EV

Column Name Description
I Origin TAZ
J Destination TAZ
CVM_<<time_period>>:LT Light trucks toll eligible
CVM_<<time_period>>:IT Intermediate trucks toll eligible
CVM_<<time_period>>:MT Medium trucks toll eligible
CVM_<<time_period>>:HT Heavy trucks toll eligible
CVM_<<time_period>>:LNT Light trucks not toll eligible
CVM_<<time_period>>:INT Intermediate trucks not toll eligible
CVM_<<time_period>>:MNT Medium trucks not toll eligible
CVM_<<time_period>>:HNT Heavy trucks not toll eligible

Go To Top

Commercial Vehicle Trip Generation Tables by Sector Type

TRIP_<<SECTOR_TYPE>>_<<TIME_PERIOD>>.CSV

where SECTOR_TYPE = FA, GO, IN, RE, SV, TH, WH
TIME_PERIOD = OE, AM, MD, PM, OL

Column Name Description
Model
SerialNo Tour id
Person
Trip Trip id
Tour Tour number
HomeZone Tour origin TAZ (13-4996)
SectorType Industrial sector:
FA = Fleet Allocator
GO = Government Office
IN = Industry
RE = Retail
SV = Service
TH = Transport
WH = Wholesale
OPurp Origin trip purpose:
Est = Return to Establishment
Gds = Goods
Srv = Service
Oth = Other
DPurp Destination trip purpose:
Est = Return to Establishment
Gds = Goods
Srv = Service
Oth = Other
I Trip origin TAZ (13-4996)
J Trip destination TAZ (13-4996)
Time Trip time by truck type and toll eligibility
CVM_<<time_period>>:<<Mode>><<TripMode>>
Mode Trip mode:
L = Light Vehicle
I = Intermediate Truck
M = Medium Truck
H = Heavy Truck
StartTime Continiuous start time of trip
EndTime Continuous end time of trip including stop_duration
StopDuration Continuous stop duration time
TourType Tour type/purpose:
G = Goods
S = Service
O = Other
OriginalTimePeriod Tour start period:
OE = Early AM
AM = AM Peak
MD = Mid-day
PM = PM Peak
OL = Evening/ Late Night
TripMode Toll or non-toll
NT = Non-Toll
TollAvailable Boolean of toll availability
TRUE

Go To Top

Total Vehicle Trips Assigned to the Highway Network by Time of Day

TRIP_<<TIME PERIOD>>.OMX

where TIME PERIOD = EA, AM, MD, PM, EV

Table Name Description
<<time_period>>_HOV3_<<vot>> Shared Ride 3 for <<time period>> and <<vot>>
<<time_period>>_TRK_<<class>> Truck for <<time_period>> and <<class>>
<<time_period>>_SOV_NT_<<vot>> Drive Alone Non-Transponder for <<time_period>> and <<vot>>
<<time_period>>_SOV_TR_<<vot>> Drive Alone Transponder for <<time_period>> and <<vot>>
<<time_period>>_HOV2_<<vot>> Shared Ride 2 for <<time_period>> and <<vot>>
vot/class = L (Low), M (Medium), or H (High)
time_period = EA, AM, MD, PM, EV

Go To Top

Number of Vehicles in CBD by MGRA

CBDBYMGRA_VEHICLES.CSV

Column Name Description
MGRA MGRA geography zone
EA Early Morning
AM Morning Peak
MD Mid-Day
PM Afternoon Peak
EV Evening
Total Total number of vehicles

Go To Top

Number of Park and Ride Vehicles by TAP

PNRBYTAP_VEHICLES.CSV

Column Name Description
TAP Transit Access Point
EA Early Morning
AM Morning Peak
MD Mid-Day
PM Afternoon Peak
EV Evening
Total Total number of Park and Ride vehicles

Go To Top

Parking Cost by MGRA

MGRAPARKINGCOST.CSV

Column Name Description
Mgra MGRA geography zone
mgraParkArea Category determining functionality of parking models:
1 = Trips with destinations in this MGRA may choose to park in a different MGRA, parking charges apply
2 = Trips with destinations in parkarea 1 may choose to park in this MGRA, parking charges might apply
3 = Only trips with destinations in this MGRA may park here, parking charges apply
4 = Only trips with destinations in this MGRA may park here, parking charges do not apply
lsWgtAvgCostM Logsum-Weighted monthly average cost
lsWgtAvgCostD Logsum-Weighted daily average cost
lsWgtAvgCostH Logsum-Weighted hourly average cost

Go To Top

GHG Emission Results from EMFA2014

EMFAC2014 – SG OUTPUT [YEAR]-.XLSX

Columns Description
Group
Area
Scenario
Sub-Area
Calendar Year
Season
Title
Veh. & Tech
EMFAC2007 Category
Vehicle Population
VMT
Trips
R-TOG Emissions
I-TOG Emissions
S-TOG Emissions
Total TOG EX Emissions
DIURN-TOG Emissions
HTSK-TOG Emissions
RUNL-TOG Emissions
RESTL-TOG Emissions
Total TOG Emissions
R-ROG Emissions
I-ROG Emissions
S-ROG Emissions
Total ROG EX Emissions
DIURN-ROG Emissions
HTSK-ROG Emissions
RUNL-ROG Emissions
RESTL-ROG Emissions
Total ROG Emissions
R-CO Emissions
I-CO Emissions
S-CO Emissions
Total CO Emissions
R-NOx Emissions
I-NOx Emissions
S-NOx Emissions
Total NOx Emissions
R-CO2 Emissions
I-CO2 Emissions
S-CO2 Emissions
Total CO2 Emissions
R-CO2 Emissions (Pavley I + LCFS)
I-CO2 Emissions (Pavley I + LCFS)
S-CO2 Emissions (Pavley I + LCFS)
Total CO2 Emissions (Pavley I + LCFS)
R-PM10 Emissions
I-PM10 Emissions
S-PM10 Emissions
Total PM10 EX Emissions
T-PM10 Emissions
B-PM10 Emissions
Total PM10 Emissions
R-PM2_5 Emissions
I-PM2_5 Emissions
S-PM2_5 Emissions
Total PM2_5 EX Emissions
T-PM2_5 Emissions
B-PM2_5 Emissions
Total PM2_5 Emissions
R-SOx Emissions
I-SOx Emissions
S-SOx Emissions
Total SOx Emissions
Fuel GAS (1000 gal)
Fuel DSL (1000 gal)

Go To Top

Commercial Vehicle Trips

GEN AND TRIPS SUM.CSV

Column Name Description
Industry Industrial sector:
FA = Fleet Allocator
GO = Government Office
IN = Industry
RE = Retail
SV = Service
TH = Transport
WH = Wholesale
Mode Trip mode:
L = Light Vehicle
I = Intermediate Truck
M = Medium Truck
H = Heavy Truck
Purpose Trip purpose:
G = Goods
S = Service
O = Other
Toll Toll or non-toll
NT = Non-Toll
TollAv Boolean of toll availability
Time
Time Period Description
CVM_<<time_period>>:LT Light trucks toll eligible
CVM_<<time_period>>:IT Intermediate trucks toll eligible
CVM_<<time_period>>:MT Medium trucks toll eligible
CVM_<<time_period>>:HT Heavy trucks toll eligible
CVM_<<time_period>>:LNT Light trucks not toll eligible
CVM_<<time_period>>:INT Intermediate trucks not toll eligible
CVM_<<time_period>>:MNT Medium trucks not toll eligible
CVM_<<time_period>>:HNT Heavy trucks not toll eligible
where time_period = EA, AM, MD, PM, EV
TAZ TAZ ID
Tours
Trips
Dist
Intra

Go To Top

Bicycle MGRA Logsum Calculations

BIKEMGRALOGSUM.CSV

Column Name Description
i Origin MGRA
j Destination MGRA
logsum Logsum - a measure of the closeness of the origin and the destination of the trip
time Time (in minutes)

Go To Top

Bicycle TAZ Logsum Calculations

BIKETAZLOGSUM.CSV

Column Name Description
i Origin TAZ
j Destination TAZ
logsum Logsum - a measure of the closeness of the origin and the destination of the trip
time Time (In minutes)

Go To Top

Accessibility Output from Transponder Ownership Model

TRANSPONDERMODELACCESSIBILITIES.CSV

Column Name Description
TAZ TAZ ID
DIST Distance (in miles) to the nearest managed lane facility (nearest link with a ML cost) calculated as a straight line
AVGTTS Average travel time savings for all households in each zone across all possible destinations
PCTDETOUR Percent detour is the percent difference between the AM transponder travel time and the AM non-transponder travel time to sample zones when the general purpose lanes parallel to all toll lanes using transponders are unavailable

Go To Top

Transit Lines per TAP

TAPLINES.CSV

Column Name Description
TAP Origin TAZ
LINES Transit lines serving TAP

Go To Top

Commercial Vehicle Model TAZ Data

TEMP_TAZDATA_CVM.CSV

Column Name Description
taz TAZ ID
pop Total population
hh Total number of households
i1 Number of households with income less than $15,000 ($2007)
i2 Number of households with income $15,000-$29,999 ($2007)
i3 Number of households with income $30,000-$44,999 ($2007)
i4 Number of households with income $45,000-$59,999 ($2007)
i5 Number of households with income $60,000-$74,999 ($2007)
i6 Number of households with income $75,000-$99,999 ($2007)
i7 Number of households with income $100,000-$124,999 ($2007)
i8 Number of households with income $125,000-$149,999 ($2007)
i9 Number of households with income $150,000-$199,999 ($2007)
i10 Number of households with income $200,000 or more ($2007)
emp_total Total Employment
emp_fed_mil Federal Military Activity
sqmile
land_sqmile
Emp_IN Industrial Employment
Emp_RE Retail Employment
Emp_SV Service Employment
Emp_TU
Emp_WH Wholesale Employment
Emp_OFF Office Employment
HHIncome Household Income
EmpDens Employment Density
PopDens Population Density
Per/Emp
Emp_ServRet_Pct
Ret_ServRet
Emp_Office
Low Density
Residential
Commercial
Industrial
Employment Node
Industrial_pct
TU_pct
Wholesale_pct
Retail_pct
Service_pct
Office_pct
E500_Industrial
E500_TU
E500_Wholesale
E500_Retail
E500_Service
E500_Office
RetailZone
ZoneType

Go To Top

MGRA Equivalent Walk Time Minutes

WALKMGRAEQUIVMINUTES.CSV

Column Name Description
I Origin MGRA
J Destination MGRA
Perceived Perceived walk time
Actual Actual walk time
Gain

Go To Top

MGRA and TAP Equivalent Walk Minutes

WALKMGRATAPEQUIVMINUTES.CSV

Column Name Description
MGRA MGRA ID
TAP TAP ID
boardingPerceived Perceived boarding time
boardingActual Actual boarding time
alightingPerceived Perceived alighting time
alightingActual Actual alighting time
boardingGain
alightingGain

Go To Top

Micro-Mobility/Transit Equivalent MGRA Travel Time Minutes

MICROMGRAEQUIVMINUTES.CSV

Column Name Description
i Origin MGRA
j Destination MGRA
walkTime Walk time between origin and destination MGRA
dist Distance between origin and destination MGRA
mmTime Micromobility time, in minutes, between origin and destination MGRA (does not include constant)
mmCost Micromobility cost ($) to travel between origin and destination MGRA
mtTime Microtransit time, in minutes, between origin and destination MGRA (does not include constant)
mtCost Microtransit cost ($) to travel between origin and destination MGRA
mmGenTime Micromobility generalized time to travel between origin and destination MGRA
mtGenTime Microtransit generalized time to travel between origin and destination MGRA
minTime Minimum time between walk, micromobility and microtransit travel times

Go To Top

Micro-Mobility/Transit Equivalent MGRA/TAP Travel Time Minutes

MICROMGRATAPEQUIVMINUTES.CSV

Column Name Description
mgra Origin or destination MGRA
tap Bording or alighting TAP
walkTime Walk time between MGRA and TAP
dist Distance between MGRA and TAP
mmTime Micromobility time, in minutes, between MGRA and TAP (does not include constant)
mmCost Micromobility cost ($) to travel between MGRA and TAP
mtTime Microtransit time, in minutes, between MGRA and TAP (does not include constant)
mtCost Microtransit cost ($) to travel between MGRA and TAP
mmGenTime Micromobility generalized time to travel between MGRA and TAP
mtGenTime Microtransit generalized time to travel between MGRA and TAP
minTime Minimum time between walk, micromobility and microtransit

Go To Top

Next Section: Report Files

Clone this wiki locally