ABM3 Model Inputs ¶
This page documents the input files required to run ABM3, organized by model component. It provides concise file descriptions and links to detailed field definitions for Land Use, Synthetic Population, Airport, Commercial Vehicle, Crossborder, External, and Heavy Truck models.
Network-specific inputs are documented separately under Networks.
Model Inputs ¶
The table below contains brief descriptions of the input files required to execute the SANDAG ABM3.
Note: Click on file name for additional details.
| File Name | Description |
| Land Use | |
| mgra15_based_input{year}.csv | MGRA land use, demographics, and employment |
| Synthetic Population | |
| households.csv | Synthetic households |
| persons.csv | Synthetic persons |
| Crossborder Model | |
| closest_maz_to_external_tazs.csv | Crossborder Model list of closest MGRA to each external TAZ |
| crossBorder_inboundStopDuration.csv | Crossborder Model time-of-day offsets for inbound stops |
| crossBorder_outboundStopDuration.csv | Crossborder Model time-of-day offsets for outbound stops |
| crossBorder_pointOfEntryWaitTime.csv | Crossborder Model wait times at border crossing locations |
| crossBorder_stopFrequency.csv | Crossborder Model stop frequency data |
| crossBorder_stopPurpose.csv | Crossborder Model stop purpose distribution |
| crossBorder_supercolonia.csv | Crossborder Model distance from Colonias to border crossing locations |
| crossBorder_tourEntryAndReturn.csv | Crossborder Model tour entry and return time-of-day distribution |
| crossBorder_tourPurpose_control.csv | Crossborder Model tour purpose reassignment probability lookup table |
| crossBorder_tourPurpose_nonSENTRI.csv | Crossborder Model tour purpose distribution for Non-SENTRI tours |
| crossBorder_tourPurpose_SENTRI.csv | Crossborder Model tour purpose distribution for SENTRI tours |
| pmsa_geoms.shp | Pseudo Major Statistical Area shapefile |
| Airport Models | |
| Hotels_EventSpace_0314.csv | Hotel/convention event-space square footage by MGRA |
| External Models | |
| externalExternalTripsByYear.csv | External origin-destination station trip matrix |
| internalExternal_tourTOD.csv | External Internal station control totals |
| internalExternal_tourTOD.csv | Internal-External Model tour time-of-day frequency distribution |
| resident_ie_size_terms.csv | Internal-External Model external zone size terms |
| Commercial Vehicle Model (CVM) | |
| percent_of_establishments_by_luz_size_emp_cat.xlsx | Percent of establishments in LUZ that belong in each size category by industry sector |
| CVM\SynthEstablishments.csv Generated during ABM3 run |
Output from CVM establishment synthesis, similar description as previous part |
| CVM\MGRAEmpByEstSize.csv Generated during ABM3 run |
MGRA Based synthetically generated establishments. Used for disgnostic purposes, not for simulation |
| CVM\SummaryEstablishments.csv Generated during ABM3 run |
Contains information about synthetically generated establishments to be used as inputs to the commercial vehicle model |
| CVM Industries Dictionary Not an ABM3 input |
Dictionary of industry codes utilized by the CVM. Not an input, only for reference. |
| Heavy Truck Model (HTM) | |
| HTM/inputs_sandag_HTM_{scenario_year}.xlsx | Contains all the required inputs (in different sheets) for the Heavy Truck Model |
| HTM/FAF5_BaseandFutureYears_Oct27_2023.csv | FAF5 Data (filtered) origin-destination flows for required years |
| FAF5 Modes Dictionary Not an ABM3 input |
Dictionary of FAF5 Modes under HTM/FAF5_BaseandFutureYears_Oct27_2023.csv. Not an input, only for reference. |
| FAF5 Commodity Groups Dictionary Not an ABM3 input |
Dictionary of FAF5 Commodity Groups under HTM/FAF5_BaseandFutureYears_Oct27_2023.csv. Not an input, only for reference. |
| Other Inputs | |
| bikeTazLogsum.csv | Bike TAZ logsum |
| bikeMgraLogsum.csv | Bike MGRA logsum |
| parametersByYears.csv | Parameters by scenario years |
| trip_XX.omx | Warm start trip table matrix. XX is the TOD (EA, AM, MD, PM, and EV) |
| zone_term.csv | TAZ terminal times |
| mobilityHubMGRAs.csv | List of MGRAs with microtransit availability |
Land Use ¶
Master Geographic Reference Areas Data ¶
mgra15_based_input{year}.csv
| Column name | Description |
|---|---|
| mgra | MGRA ID number |
| taz | TAZ ID number |
| luz_id | Land Use Zone ID number |
| pop | Total population |
| hhp | Total household population (exclude gq pop) |
| hs | Housing structures |
| hs_sf | Single family housing structures |
| hs_mf | Multi-family housing structures |
| hs_mh | Mobile home housing structures |
| hh | Total number of households |
| hh_sf | Number of single family households |
| hh_mf | Number of multi-family households |
| hh_mh | Number of mobile home households |
| hhs | Average household size |
| gq_civ | Civilian Group Quarterss |
| gq_mil | Military Group Quarters |
| i1 | Number of households with income less than $15,000 ($2022) |
| i2 | Number of households with income $15,000-$29,999 ($2022) |
| i3 | Number of households with income $30,000-$44,999 ($2022) |
| i4 | Number of households with income $45,000-$59,999 ($2022) |
| i5 | Number of households with income $60,000-$74,999 ($2022) |
| i6 | Number of households with income $75,000-$99,999 ($2022) |
| i7 | Number of households with income $100,000-$124,999 ($2022) |
| i8 | Number of households with income $125,000-$149,999 ($2022) |
| i9 | Number of households with income $150,000-$199,999 ($2022) |
| i10 | Number of households with income $200,000 or more ($2022) |
| emp_gov | Government employment |
| emp_mil | Military employment |
| emp_ag_min | Agriculture and mining employment (NAICS:11,21) |
| emp_bus_svcs | Professional and Business Services employment (NAICS:51,54,56) |
| emp_fin_res_mgm | Financial and resource management employment (NAICS:52,53,55) |
| emp_educ | Education services employment (NAICS:61) |
| emp_hlth | Health services employment (NAICS:62) |
| emp_ret | Retail services employment (NAICS:44,45) |
| emp_trn_wrh | Transportation and Warehousing employment (NAICS:48,49) |
| emp_con | Construction employment (NAICS:23) |
| emp_utl | Utilities office support employment (NAICS:22) |
| emp_mnf | Manufacturing employment (NAICS:31,32,33) |
| emp_whl | Wholesale employment (NAICS:42) |
| emp_ent | Entertainment services employment (NAICS:71) |
| emp_accm | Hotel and accomodation services (NAICS:721) |
| emp_food | Food services employment (NAICS:722) |
| emp_oth | Other employment (NAICS:81) |
| emp_non_ws_wfh | Non-wage and salary work from home employments |
| emp_non_ws_oth | Non-wage and salary other employments |
| emp_total | Total employment |
| pseudomsa |
Pseudo MSA 1: Downtown 2: Central 3: North City 4: South Suburban 5: East Suburban 6: North County West 7: North County East 8: East County |
| zip09 | 2009 Zip Code |
| enrollgradekto8 | Grade School K-8 enrollment |
| enrollgrade9to12 | Grade School 9-12 enrollment |
| collegeenroll | Major College enrollment |
| othercollegeenroll | Other College enrollment |
| hotelroomtotal | Total number of hotel rooms |
| parkactive | Acres of Active Park |
| openspaceparkpreserve | Acres of Open Park or Preserve |
| beachactive | Acres of Active Beach |
| district27 | 27 district system |
| milestocoast | Distance (miles) to the nearest coast |
| acres | Total acres in the MGRA |
| land_acres | Acres of land in the MGRA |
| effective_acres | Effective acres in the MGRA |
| truckregiontype | Truck region type |
| exp_hourly | Hourly parking expense |
| exp_daily | Daily parking expense |
| exp_monthly | Monthly parking expense |
| parking_type |
1 = parking constrained area: has cluster_id and district_id 2 = buffer around parking constrained area which is used to include free spaces to average into parking cost calculation: has district_id but no cluster_id 3 = no parking cost: Has neither cluster_id nor district_id |
| parking_spaces | Estimated parking spaces in MGRA |
| ech_dist | Elementary school district |
| hch_dist | High school district |
| remoteAVParking |
Remote AV parking available at MGRA: 0 = Not available 1 = Available |
| refueling_stations | Number of refueling stations at MGRA |
| MicroAccessTime | Shared Micro-mobility (e-scooter/e-bike) access time (mins) |
| microtransit | The microtransit service area ID [0 means no service] |
| nev | Neighborhood Electric Vehicle (NEV) service area ID [0 means no service] |
| totint | Total intersections within 0.65 miles of the MGRA |
| duden | Dwelling units per acre within 0.65 miles of the MGRA |
| empden | Jobs per acre within 0.65 miles of the MGRA |
| popden | Population per acre within 0.65 miles of the MGRA |
| retempden | Retail jobs per acre within 0.65 miles of the MGRA |
| totintbin | Total intersection bin |
| empdenbin | Employment density bin |
| dudenbin | Dwelling unit density bin |
| PopEmpDenPerMi | Population and employment density per mile within 0.65 miles of the MGRA |
Synthetic Population ¶
Population Synthesizer Household Data ¶
households.csv
| Column Name | Description |
|---|---|
| hhid | Unique Household ID |
| household_serial_no | Household serial number |
| taz | TAZ of household |
| mgra | MGRA of household |
| hinccat1 |
Household income category: 1 = <$30k 2 = $30-60k 3 = $60-100k 4 = $100-150k 5 = $150k+ |
| hinc | Household income |
| num_workers | Number of workers in household |
| veh | Number of vehicles in household |
| persons | Number of persons in household |
| hht |
Household/family type: 0 = Not in universe (vacant or GQ) 1 = Family household: married-couple 2 = Family household: male householder, no wife present 3 = Family household: female householder, no husband present 4 = Nonfamily household: male householder, living alone 5 = Nonfamily household: male householder, not living alone 6 = Nonfamily household: female householder, living alone 7 = Nonfamily household: female householder, not living alone |
| bldgsz |
Units in Structure: 0 = N/A (Group Quarter) 1 = Mobile home or trailer 2 = One-family house detached 3 = One-family house attached 4 = 2 Apartments 5 = 3-4 Apartments 6 = 5-9 Apartments 7 = 10-19 Apartments 8 = 20-49 Apartments 9 = 50 or more apartments 10 = Boat, RV, van, etc. |
| unittype |
Household unit type: 0 = Non-GQ Household 1 = GQ Household |
| version | Synthetic population run version. Presently set to 0. |
| poverty | Poverty indicator utilized for social equity reports. Percentage value where value <= 2 (200% of the Federal Poverty Level) indicates household is classified under poverty. |
Population Synthesizer Person Data ¶
persons.csv
| Column Name | Description |
|---|---|
| hhid | Household ID |
| perid | Person ID |
| household_serial_no | Household serial number |
| pnum | Person Number |
| age | Age of person |
| sex |
Gender of person 1 = Male 2 = Female |
| miltary |
Military status of person: 0 = N/A Less than 17 Years Old 1 = Yes, Now on Active Duty |
| pemploy |
Employment status of person: 1 = Employed Full-Time 2 = Employed Part-Time 3 = Unemployed or Not in Labor Force 4 = Less than 16 Years Old |
| pstudent |
Student status of person: 1 = Pre K-12 2 = College Undergrad+Grad and Prof. School 3 = Not Attending School |
| ptype |
Person type: 1 = Full-time Worker 2 = Part-time Worker 3 = College Student 4 = Non-working Adult 5 = Non-working Senior 6 = Driving Age Student 7 = Non-driving Student 8 = Pre-school |
| educ |
Educational attainment: 1 = No schooling completed 9 = High school graduate 13 = Bachelor's degree |
| grade |
School grade of person: 0 = N/A (not attending school) 2 = K to grade 8 5 = Grade 9 to grade 12 6 = College undergraduate |
| occen5 |
Occupation: 0 = Not in universe (Under 16 years or LAST-WRK = 2) 1..997 = Legal census occupation code |
| occsoc5 | Detailed occupation codes defined by the Bureau of Labor Statistics |
| indcen |
Industry code. 0 = default 9970 = NAICS2 is MIL |
| weeks |
Weeks worked during past 12 months 0 .N/A (less than 16 years old/did not work during the past 12 .months) 1 .50 to 52 weeks worked during past 12 months 2 .48 to 49 weeks worked during past 12 months 3 .40 to 47 weeks worked during past 12 months 4 .27 to 39 weeks worked during past 12 month 5 .14 to 26 weeks worked during past 12 months 6 .13 weeks or less worked during past 12 months |
| hours |
Hours worked per week past 12 months 0 .N/A (less than 16 years old/did not work during the past .12 months) 1..98 .1 to 98 usual hours 99 .99 or more usual hours |
| rac1p |
Race: 1 = White alone 2 = Black or African American alone 3 = American Indian alone 4 = Alaska Native alone 5 = American Indian and Alaska Native tribes specified; or .American Indian or Alaska Native, not specified and no other .races 6 = Asian alone 7 = Native Hawaiian and Other Pacific Islander alone 8 = Some Other Race alone 9 =Two or More Races |
| hisp |
Hispanic origin: 1 = Not Hispanic 2 = Hispanic |
| version | Synthetic population run version. Presently set to 0. |
| naics2_original_code |
2 digit North American Industry Classification System (NAICS) 11 = Agriculture, Forestry, Fishing and Hunting 21 = Mining, Quarrying, and Oil and Gas Extraction 22 = Utilities 23 = Construction 31 = Manufacturing 32 = Wood Product Manufacturing 33 = Primary Metal Manufacturing 42 = Wholesale Trade 44 = Retail Trade 45 = General Merchandise Retailers 48 = Transportation and Warehousing 49 = Postal Service 51 = Information 52 = Finance and Insurance 53 = Real Estate and Rental and Leasing 54 = Professional, Scientific, and Technical Services 55 = Management of Companies and Enterprises 56 = Administrative and Support and Waste Management and Remediation Services 61 = Educational Services 62 = Health Care and Social Assistance 71 = Arts, Entertainment, and Recreation 721 = Accommodation 722 = Food Services and Drinking Places 81 = Other Services (except Public Administration) 92 = Public Administration |
| soc2 | 2 digit Standard Occupational Classification |
Airport Models ¶
Hotels and Event Space for Airport Models ¶
Hotels_EventSpace_0314.csv
| Column Name | Description |
|---|---|
| USER_Accou | Hotel or venue name |
| Status | Geocoding match status |
| Score | Geocoding match score |
| Match_addr | Matched address |
| LongLabel | Long address label |
| ShortLabel | Short address label |
| Subregion | Subregion name |
| Region | Region name (State) |
| Postal | ZIP code |
| PostalExt | ZIP code extension |
| CntryName | Country name |
| X | Longitude coordinate |
| Y | Latitude coordinate |
| ExInfo | Extended information |
| StrucType | Structure type (e.g., Commercial) |
| StrucDet | Structure detail (e.g., Lodging) |
| IN_Neighbo | Neighborhood or community area |
| USER_Sleep | Number of sleeping rooms |
| USER_Total | Total event space (square feet) |
| USER_Large | Largest room size (square feet) |
| USER_Class | Number of classrooms |
| USER_Theat | Theater seating capacity |
| USER_Banqu | Banquet seating capacity |
| USER_Numbe | Number of meeting rooms |
| USER_Mobil | Mobil rating |
| USER_AAA_R | AAA diamond rating |
| USER_TMD_A | TMD (The Meeting Destination) approved (Yes/No) |
| MGRA | Micro-geography analysis zone |
| TAZ | Traffic analysis zone |
Commercial Vehicle Model ¶
Establishment Size Distribution by LUZ ¶
percent_of_establishments_by_luz_size_emp_cat.xlsx
| Sheet Name | Description |
|---|---|
| Info | Basic information of the data, and the size class definitions included |
| Data | Detailed industry sector breakdown by size class and LUZ |
Synthesized Establishments ¶
CVM/SynthEstablishments.csv
| Column Name | Description |
|---|---|
| Establishment_ID | Unique establishment id ( index ) for each establishment |
| Industry_No | The category of industry that the establishment belongs to (range: 1 - 12 ) |
| Industry_Name | The name of industry that the establishment belongs to ( EPO, AGM, CON etc.)/td> |
| LUZ | Land Use Zone ( Or the TAZ) to which the establishment belongs to |
| MGRA | The MGRA number to which establishment belongs to |
| Employees | The number of employees in the establishment |
| Size_Class | The categorized size of the establishment based on the number of employees |
Employment by MGRA by TAZ by LUZ ¶
CVM/MGRAEmpByEstSize.csv
| Field | Description |
|---|---|
| mgra | MGRA id |
| taz | TAZ id |
| luz | Land use zone |
| emp_Sector_Size_Class | Employment numbers, where Sector is gov, mil, ag_min, bus_svcs, fin_res_mgm, educ, hlth, ret, trn_wrh, con, utl, mnf, whl, ent, accm, food, oth; where Size_Class ranges 1-7. |
Summary of Synthesized Establishments ¶
SummarySynthEstabs.csv
| Field | Description |
|---|---|
| Industry_No | Industry No |
| Industry_Name | Industry name |
| Size_Class | Size class |
| Count | Total number |
CVM Industries Dictionary ¶
| Industry No | Industry Name | Description |
|---|---|---|
| 1 | AGM | Agriculture, Forestry, Fishing, and Hunting, and Mining |
| 2 | MFG | Manufacturing |
| 3 | IUT | Industrial Utilities |
| 4 | RET | Retail Trade |
| 5 | WHL | Wholesale Trade |
| 6 | CON | Construction |
| 7 | TRN | Transportation and Warehousing |
| 8 | IFR | Information, Financial, Insurance, Real Estate, and Professional Services |
| 9 | EPO | Education, Public, and Other Services |
| 10 | MHS | Medical and Health Services |
| 11 | LAF | Leisure, Accomodations, and Food |
| 12 | MIL | Military |
Crossborder ¶
Crossborder Model Tour Entry and Return Distribution ¶
crossBorder_tourEntryAndReturn.csv
| Column Name | Description |
|---|---|
| Purpose |
Tour Purpose: 0 = Work 1 = School 2 = Cargo 3 = Shop 4 = Visit 5 = Other |
| EntryPeriod |
Entry Period: 1 = Before 5:00AM 2 = 5:00AM-5:30AM 3 through 39 is every half hour time slots 40 = After 12:00AM |
| Return Period |
Return Period: 1 = Before 5:00AM 2 = 5:00AM-5:30AM 3 through 39 is every half hour time slots 40 = After 12:00AM |
| Percent | Distribution of tours in entry and return period time slots |
Crossborder Model Supercolonia ¶
crossBorder_supercolonia.csv
| Column Name | Description |
|---|---|
| Supercolonia_ID | Super colonia ID |
| Population | Population of the super colonia |
| Distance_poe0 | Distance from colonia to point of entry 0 (San Ysidro) |
| Distance_poe1 | Distance from colonia to point of entry 1 (Otay Mesa) |
| Distance_poe2 | Distance from colonia to point of entry 2 (Tecate) |
| Distance_poe3 | Distance from colonia to point of entry 3 (Otay Mesa East) |
| Distance_poe4 | Distance from colonia to point of entry 4 (Jacumba) |
Crossborder Model Point of Entry Wait Time ¶
crossBorder_pointOfEntryWaitTime.csv
| Column Name | Description |
|---|---|
| poe |
Point of Entry number: 0 = San Ysidro 1 = Otay Mesa 2 = Tecate 3 = Otay Mesa East 4 = Jacumba |
| StartHour | Start Hour (1 through 12) |
| EndHour | End Hour (1 through 12) |
| StartPeriod |
Start Period: 1 = Before 5:00AM 2 = 5:00AM-5:30AM 3 through 39 is every half hour time slots 40 = After 12:00AM |
| EndPeriod |
End Period: 1 = Before 5:00AM 2 = 5:00AM-5:30AM 3 through 39 is every half hour time slots 40 = After 12:00AM |
| PedestrianWait | Pedestrian wait time in minutes |
| ReadyWait | Ready Lane wait time in minutes |
| SENTRIWait | SENTRI Lane wait time in minutes |
| StandardWait | Standard Lane wait time in minutes |
Crossborder Model Stop Frequency ¶
crossBorder_StopFrequency.csv
| Column Name | Description |
|---|---|
| Purpose |
Tour Purpose: 0 = Work 1 = School 2 = Cargo 3 = Shop 4 = Visit 5 = Other |
| DurationLo | Lower bound of tour duration (0, 4, or 8) |
| DurationHi | Upper bound of tour duration (4, 8, or 24) |
| Outbound | Number of stops on the outbound (0, 1, 2, 3+) |
| Inbound | Number of stops on the inbound (0, 1, 2, 3+) |
| Percent | Distribution of tours by purpose, duration, number of outbound/inbound stops |
Crossborder Model Stop Purpose Distribution ¶
crossBorder_stopPurpose.csv
| Column Name | Description |
|---|---|
| TourPurp |
Tour Purpose: 0 = Work 1 = School 2 = Cargo 3 = Shop 4 = Visit 5 = Other |
| Inbound | Boolean for whether stop is inbound (0=No, 1=Yes) |
| StopNum | Stop number on tour (1, 2, or 3) |
| Multiple | Boolean for whether there are multiple stops on tour (0=No, 1=Yes) |
| StopPurp0 | Distribution of Work stops |
| StopPurp1 | Distribution of School stops |
| StopPurp2 | Distribution of Cargo stops |
| StopPurp3 | Distribution of Shopping stops |
| StopPurp4 | Distribution of Visiting stops |
| StopPurp5 | Distribution of Other stops |
Crossborder Model Outbound Stop Duration Distribution ¶
crossBorder_outboundStopDuration.csv
| Column Name | Description |
|---|---|
| RemainingLow |
Lower bound of remaining half hour periods after last scheduled trip: 1 = Before 5:00AM 2 = 5:00AM-5:30AM 3 through 39 is every half hour time slots 40 = After 12:00AM |
| RemainingHigh |
Upper bound of remaining half hour periods after last scheduled trip: 1 = Before 5:00AM 2 = 5:00AM-5:30AM 3 through 39 is every half hour time slots 40 = After 12:00AM |
| Stop | Stop number on tour (1, 2, or 3) |
| 0 | Probability that stop departure is in same period as last outbound trip |
| 1 | Probability that stop departure is in last outbound trip period + 1 |
| 2 | Probability that stop departure is in last outbound trip period + 2 |
| 3 | Probability that stop departure is in last outbound trip period + 3 |
| 4 | Probability that stop departure is in last outbound trip period + 4 |
| 5 | Probability that stop departure is in last outbound trip period + 5 |
| 6 | Probability that stop departure is in last outbound trip period + 6 |
| 7 | Probability that stop departure is in last outbound trip period + 7 |
| 8 | Probability that stop departure is in last outbound trip period + 8 |
| 9 | Probability that stop departure is in last outbound trip period + 9 |
| 10 | Probability that stop departure is in last outbound trip period + 10 |
| 11 | Probability that stop departure is in last outbound trip period + 11 |
Crossborder Model Inbound Stop Duration Distribution ¶
crossBorder_inboundStopDuration.csv
| Column Name | Description |
|---|---|
| RemainingLow |
Lower bound of remaining half hour periods after last scheduled trip: 1 = Before 5:00AM 2 = 5:00AM-5:30AM 3 through 39 is every half hour time slots 40 = After 12:00AM |
| RemainingHigh |
Upper bound of remaining half hour periods after last scheduled trip: 1 = Before 5:00AM 2 = 5:00AM-5:30AM 3 through 39 is every half hour time slots 40 = After 12:00AM |
| Stop | Stop number on tour (1, 2, or 3) |
| 0 | Probability that stop departure period is same as tour arrival period |
| -1 | Probability that stop departure period is tour arrival period - 1 |
| -2 | Probability that stop departure period is tour arrival period – 2 |
| -3 | Probability that stop departure period is tour arrival period – 3 |
| -4 | Probability that stop departure period is tour arrival period – 4 |
| -5 | Probability that stop departure period is tour arrival period – 5 |
| -6 | Probability that stop departure period is tour arrival period – 6 |
| -7 | Probability that stop departure period is tour arrival period - 7 |
External Models ¶
External External Control Totals ¶
externalExternalTripsByYear.csv
| Column Name | Description |
|---|---|
| originTAZ | External origin TAZ |
| destinationTAZ | External destination TAZ |
| Trips | Number of trips between external TAZs |
External Internal Control Totals ¶
externalInternalControlTotalsByYear
| Column Name | Description |
|---|---|
| Taz | External TAZ station |
| Work | Number of work vehicle trips |
| Nonwork | Number of non-work vehicle trips |
Internal External Tours Time of Day Distribution ¶
internalExternal_tourTOD.csv
| Column Name | Description |
|---|---|
| Purpose |
Tour Purpose: 0 = All Purposes |
| EntryPeriod |
Entry Period: 1 = Before 5:00AM 2 = 5:00AM-5:30AM 3 through 39 is every half hour time slots 40 = After 12:00AM |
| ReturnPeriod |
Return Period: 1 = Before 5:00AM 2 = 5:00AM-5:30AM 3 through 39 is every half hour time slots 40 = After 12:00AM |
| Percent | Distribution of tours by entry and return periods |
External-Internal Model External Zone Size Terms ¶
resident_ie_size_terms.csv
| Column Name | Description |
|---|---|
| taz | External Zone ID |
| work | Work-tour size term |
| nonwork | Nonwork-tour size term |
| start_year | First year that row is active |
| OME_override | If 1, start_year is set from scenario parameter |
Heavy Truck Model (HTM) ¶
Year-Specific SANDAG HTM Inputs ¶
HTM/inputs_sandag_HTM_{scenario_year}.xlsx
| Sheet Name | Description |
|---|---|
| FAZ_County | County-FAZ Mapping |
| TAZ_FAZ | Identifies in which FAZ, each TAZ is located |
| OtherMode_Truck | Determines what percentage of each mode belongs to trucks |
| SD_Flows | Identifies all OD pairs that have at least one end in SANDAG region or passes through the SANDAG region. |
| FAZ_Gateway | A look up table that corresponds FAF FAZ that are outside the SANDAG region to one/many SANDAG Gateways. This table also includes area code of each FAZ that is outside SANDAG region. |
| Commodity_Group | Determines the commodity group (15 categories) to which each of the 43 commodities from the FAF data belongs. |
| EMP_Calc | Calculate the share of each of the 3 digits NAICS employee categories withing the 19 categories SANDAG ABM employee for each of the 5 FAZs in San Diego County |
| EMP_Converter | Provides a table that correlates SANDAG model employee categories with corresponding NAICS employee categories. |
| CG_Emp_P | Establishes the relationship between each commodity group and the NAICS employee category for the production end. |
| CG_Emp_A | Establishes the relationship between each commodity group and the NAICS employee category for the attraction end. |
| Annual_Factor | Number of business days in a year. |
| Truck_Dist | Provides the percent distribution of truck type based on OD distance. |
| Payload | Average pounds of load that each truck type can carry based on commodity groups. |
| Time_of_Day | Provides distribution of trucks throughout the day. |
| External_Count | The Inbound and outbound truck counts by type at each of the 12 SANDAG gateways. For base year, this is the daily truck counts at the gateways. |
| SRA_Dist | The overall distribution of trucks when they cross each of the gateway from/to each of the 63 SRAs. For base year this information is calculated from truck GPS data |
| SRA_TAZ | SRA-TAZ Mapping |
Freight Analysis Framework Version 5 (FAF5) Origin-Destination (O-D) Flows ¶
HTM/FAF5_BaseandFutureYears_Oct27_2023.csv
| Column Name | Description |
|---|---|
| dms_orig | FAF region or state where a freight movement begins the domestic portion of shipment. For imports, this is the US entry region where an import enters United States. |
| dms_dest | FAF region or state where a freight movement ends the domestic portion of shipment. For exports, this is the US exit region where an export leaves United States. |
| Mode | Mode used between domestic origins and destinations |
| Commodity | 2-digit level of the Standard Classification of Transported Goods ( SCTG) |
| Direction | Trade Direction : II or XI |
| Trade | Trade Type : Domestic or Foreign |
| fr_orig | Foreign region of shipment origin |
| fr_dest | Foreign region of shipment destination |
| fr_inmode | Mode used between a foreign region and the US entry region for the imported goods |
| fr_outmode | Mode used between the US exit region and foreign region for the exported goods |
| distons_year | Total weight of commodities shipped (unit: Thousand Tons) in year |
| disvalue_year | Total value (in 2017 constant dollar) of commodities shipped (unit: Million Dollars) in year |
FAF5 Modes Dictionary ¶
| Numeric Label | Description |
|---|---|
| 1 | Truck |
| 2 | Rail |
| 3 | Water |
| 4 | Air (include truck-air) |
| 5 | Multiple modes & mail |
| 6 | Pipeline |
| 7 | Other and unknown |
| 8 | No domestic mode |
FAF5 Commodity Groups Dictionary ¶
| Numeric Label | Description |
|---|---|
| 01 | Live animals/fish |
| 02 | Cereal grains |
| 03 | Other ag prods. |
| 04 | Animal feed |
| 05 | Meat/seafood |
| 06 | Milled grain prods. |
| 07 | Other foodstuffs |
| 08 | Alcoholic Beverages |
| 09 | Tobacco prods |
| 10 | Building stone |
| 11 | Natural sands |
| 12 | Gravel |
| 13 | Nonmetallic minerals |
| 14 | Metallic ores |
| 15 | Coal |
| 16 | Crude Petroleum |
| 17 | Gasoline |
| 18 | Fuel oils |
| 19 | Natural gas and other fossil products |
| 20 | Basic chemicals |
| 21 | Pharmaceuticals |
| 22 | Fertilizers |
| 23 | Chemical prods. |
| 24 | Plastics/rubber |
| 25 | Logs |
| 26 | Wood prods |
| 27 | Newsprint/paper |
| 28 | Paper articles |
| 29 | Printed prods. |
| 30 | Textiles/leather |
| 31 | Nonmetal min. prods. |
| 32 | Base metals |
| 33 | Articles-base metal |
| 34 | Machinery |
| 35 | Electronics |
| 36 | Motorized Vehicles |
| 37 | Transport equip. |
| 38 | Precision instruments |
| 39 | Furniture |
| 40 | Misc. mfg. prods. |
| 41 | Waste/scrap |
| 43 | Mixed freight |
Other Inputs ¶
Bike TAZ Logsum ¶
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) |
Bike MGRA Logsum ¶
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) |
Parameters by Scenario Years ¶
parametersByYears.csv
| Column Name | Description |
|---|---|
| year | Scenario year |
| aoc.fuel | Auto operating fuel cost |
| aoc.maintenance | Auto operating maitenance cost |
| aoc.truck.fuel.light | Auto operating fuel cost for light trucks |
| aoc.truck.fuel.medium | Auto operating fuel cost for medium trucks |
| aoc.truck.fuel.high | Auto operating fuel cost for heavy trucks |
| aoc.truck.maintenance.light | Auto operating maintenance cost for light trucks |
| aoc.truck.maintenance.medium | Auto operating maintenance cost for medium trucks |
| aoc.truck.maintenance.high | Auto operating maintenance cost for heavy trucks |
| aoc.truck.fuel.SUT | Auto operating fuel cost for single-unit trucks |
| aoc.truck.fuel.MUT | Auto operating fuel cost for multi-unit trucks |
| aoc.truck.maintenance.SUT | Auto operating maintenance cost for single-unit trucks |
| aoc.truck.maintenance.MUT | Auto operating maintenance cost for multi-unit trucks |
| airport.SAN.enplanements | San Diego International Airport enplanements |
| airport.SAN.connecting | San Diego International Airport connecting passengers |
| airport.SAN.airportMgra | MGRA San Diego International Airport is located in |
| airport.CBX.enplanements | Cross Border Express Terminal (Tijuana International Airport) enplanements |
| airport.CBX.connecting | Cross Border Express Terminal (Tijuana International Airport) connecting passengers |
| airport.CBX.airportMgra | MGRA Cross Border Express Terminal is located in |
| crossBorder.tours | Number of cross border tours |
| crossBorders.sentriShare | Share of cross border tours that use SENTRI Lane |
| crossBorders.readyShare | Share of cross border tours that use Ready Lane |
| taxi.baseFare | Initial taxi fare |
| taxi.costPerMile | Taxi cost per mile |
| taxi.cosPerMinute | Taxi cost per minute |
| TNC.single.baseFare | Initial TNC fare for single ride |
| TNC.single.costPerMile | TNC cost per mile for single ride |
| TNC.single.costPerMinute | TNC cost per minute for single ride |
| TNC.single.costMinimum | TNC minimum cost for single ride |
| TNC.shared.baseFare | Initial TNC fare for shared ride |
| TNC.shared.costPerMile | TNC cost per mile for shared ride |
| TNC.shared.costPerMinute | TNC cost per minute for shared ride |
| TNC.shared.costMinimum | TNC minimum cost for shared ride |
| Mobility.AV.RemoteParkingCostPerHour | Remote parking cost per hour for autonomous vehicles |
| active.micromobility.variableCost | Variable cost for micromobility |
| active.micromobility.fixedCost | Fixed cost for micromobility |
| active.microtransit.fixedCost | Fixed cost for microtransit |
| Mobility.AV.Share | The share of vehicles assumed to be autonomous vehicles in the vehicle fleet |
| smartSignal.factor.LC | Smart signal factor for Collector intersection approaches |
| smartSignal.factor.MA | Smart signal factor for Major Arterial or Major / Prime Arterial intersection approaches |
| smartSignal.factor.PA | Smart signal factor for Primary Arterial intersection approaches |
| atdm.factor | Active Transportation and Demand Management factor |
| active.ebike.ownership | E-bike ownership rate |
| rapid.factor.ivt | Rapid bus in-vehicle time perception factor |
| rapid.factor.wait | Rapid bus wait time perception factor |
| rapid.dwell | Rapid bus dwell times in minutes |
| poe.OME.start.year | Open-to-traffic year for the Otay Mesa East port of entry |
| tr.veh.year | Vehicle year when vehicles are assumed to have transponders |
| ev.rebate.lowinc.bev | Rebate value ($) for battery electric vehicles for low-income housesholds |
| ev.rebate.lowinc.pev | Rebate value ($) for plug-in electric vehicles for low-income households |
| ev.rebate.medinc.bev | Rebate value ($) for battery electric vehicles for medium-income households |
| ev.rebate.medinc.pev | Rebate value ($) for plug-in electric vehicles for medium-income households |
| ev.chargers | Number of electric vehicle chargers |
| wfh.coef.regional.calibration | Regional work-from-home calibration coefficient |
Zone Terminal Time ¶
zone_term.csv
| Column Name | Description | |
|---|---|---|
| Zone | TAZ number | |
| Terminal time | Terminal time (3, 4, 5, 7, 10 minutes) |
Mobility Hub MGRAs ¶
mobilityHubMGRAs.csv
| Column Name | Description |
|---|---|
| MGRA | MGRA ID |
| MoHubName | Name of Mobility Hub |
| MoHubType | Type of Mobility Hub |