-
Notifications
You must be signed in to change notification settings - Fork 21
Output Files
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.
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 |
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) |
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 |
where *HD = LHD, MHD, HHD, and TOLL_CLASS = T (Toll) and N (Non-TOLL)
Table Name | Description |
---|
Table Name | Description |
---|
Table Name | Description |
---|
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 |
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 |
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 |
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 |
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) |
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) |
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 |
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 |
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>> |
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>> |
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>> |
where TIME PERIOD = EA, AM, MD, PM, EV
Table Name | Description |
---|---|
SCHLBUS_<<time period>> | School Bus for <<time period>> |
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) |
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>> |
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>> |
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>> |
where TIME PERIOD = EA, AM, MD, PM, EV
AIRPORT = SAN, CBX
Table Name | Description |
---|---|
SCHLBUS_<<time period>> | School Bus for <<time period>> |
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) |
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) |
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>> |
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>> |
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>> |
where TIME PERIOD = EA, AM, MD, PM, EV
Table Name | Description |
---|---|
SCHLBUS_<<time period>> | School Bus for <<time period>> |
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) |
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 |
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>> |
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>> |
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>> |
where TIME PERIOD = EA, AM, MD, PM, EV
Table Name | Description |
---|---|
SCHLBUS_<<time period>> | School Bus for <<time period>> |
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) |
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 |
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 |
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 |
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 |
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>> |
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>> |
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>> |
where TIME PERIOD = EA, AM, MD, PM, EV
Table Name | Description |
---|---|
SCHLBUS_<<time period>> | School Bus for <<time period>> |
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 |
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 |
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 |
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 |
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 |
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 |
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) |
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 |
|
||||||||||||||||||||
TAZ | TAZ ID | ||||||||||||||||||||
Tours | |||||||||||||||||||||
Trips | |||||||||||||||||||||
Dist | |||||||||||||||||||||
Intra |
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) |
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) |
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 |
Column Name | Description |
---|---|
TAP | Origin TAZ |
LINES | Transit lines serving TAP |
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 |
Column Name | Description |
---|---|
I | Origin MGRA |
J | Destination MGRA |
Perceived | Perceived walk time |
Actual | Actual walk time |
Gain |
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 |
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 |
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 |