Input Files

The following table contains brief descriptions of the input files required to execute the SDRSPM. Click on the file names for details on all variables within each input file. Navigate to Input Files Data Dictionary to browse through all input files and their respective attribute details. Detailed information can be found here*.

Input Files Contents

• Azone
• Bzone
• Marea
• Region

File Name	Purpose	File Type	Prepared By
Azone
azone_carsvc_characteristics.csv	This file specifies the different characteristics for high and low car service level and is used in the CreateVehicleTable and AssignVehicleAge modules.	CSV	SANDAG Modelers
azone_charging_availability.csv	This file has data on proportion of different household types who has EV charging available and is used in the AssignHHVehiclePowertrain module.	CSV	VE Default
azone_fuel_power_cost.csv	This file supplies data for retail cost of fuel and electricity and is used in the CalculateVehicleOperatingCost module.	CSV	SANDAG Modelers
azone_gq_pop_by_age.csv	This file contains group quarters population estimates/forecasts by age and is used in the CreateHouseholds module.	CSV	SANDAG Modelers
azone_hhsize_targets.csv	This file contains the household specific targets and is used in CreateHouseholds module.	CSV	SANDAG Modelers
azone_hh_ave_veh_per_driver.csv	This file contains the average number of household vehicles per licensed driver by Azone and is used in AssignVehilceOwnership module.	CSV	SANDAG Modelers
azone_hh_lttrk_prop.csv	This file specifies the light truck proportion of the vehicle fleet and is used in AssignVehicleType module.	CSV	SANDAG Modelers
azone_hh_pop_by_age.csv	This file contains population estimates/forecasts by age and is used in the CreateHouseholds module.	CSV	SANDAG Modelers
azone_hh_veh_mean_age.csv	This file provides inputs for mean auto age and mean light truck age and is used in the AssignVehicleAge module.	CSV	SANDAG Modelers
azone_hh_veh_own_taxes.csv	This file provides inputs for flat fees/taxes (i.e. annual cost per vehicle) and ad valorem taxes (i.e. percentage of vehicle value paid in taxes). The file is used in CalculateVehicleOwnCost module.	CSV	VE Default
azone_payd_insurance_prop.csv	This file provides inputs on the proportion of households having PAYD (pay-as-you-drive) insurance and is used in the CalculateVehicleOwnCost module.	CSV	VE Default
azone_per_cap_inc.csv	This file contains information on regional average per capita household and group quarters income in year 2010 dollars and is used in the PredictIncome module.	CSV	SANDAG Modelers
azone_prop_sov_dvmt_diverted.csv	This file provides inputs for a goal for diverting a portion of SOV travel within a 20-mile tour distance and is used in the DivertSovTravel module.	CSV	SANDAG Modelers
azone_relative_employment.csv	These optional input values specify by age group, Azone, and year the proportions of persons in the age group and Azone who are workers relative to the proportions in the model estimation year.	CSV	SANDAG Modelers
azone_vehicle_access_times.csv	This file supplies data for vehicle access and egress time and is used in the CalculateVehicleOperatingCost module.	CSV	SANDAG Modelers
azone_veh_use_taxes.csv	This file supplies data for vehicle related taxes and is used in the CalculateVehicleOperatingCost module.	CSV	SANDAG Modelers
Bzone
bzone_carsvc_availability.csv	This file contains the information about level of car service availability and is used in the AssignCarSvcAvailability module.	CSV	SANDAG Modelers
bzone_dwelling_units.csv	This file contains the number single-family, multi-family and group-quarter dwelling units and is used in the PredictHousing module.	CSV	SANDAG Modelers
bzone_employment.csv	This file contains the total, retail and service employment by zone and is used in the LocateEmployment module.	CSV	SANDAG Modelers
bzone_hh_inc_qrtl_prop.csv	This file contains the proportion of households in 1st, 2nd, 3rd, and 4th quartile of household income and is used in the PredictHousing module.	CSV	SANDAG Modelers
bzone_lat_lon.csv	This file contains the latitude and longitude of the centroid of the zone and is used in the LocateEmployment module.	CSV	SANDAG Modelers
bzone_network_design.csv	This file contains the intersection density in terms of pedestrian-oriented intersections having four or more legs per square mile and is used in the Calculate4DMeasures module.	CSV	SANDAG Modelers
bzone_parking.csv	This file contains the parking information and is used in the AssignParkingRestrictions module.	CSV	SANDAG Modelers
bzone_transit_service.csv	This file supplies the data on relative public transit accessibility and is used in the AssignTransitService module.	CSV	SANDAG Modelers
bzone_travel_demand_mgt.csv	This file contains the information about workers and households participating in demand management programs and is used in the AssignDemandManagement module.	CSV	VE Default
bzone_unprotected_area.csv	This file contains the information about unprotected (i.e., developable) area within the zone and is used in the Calculate4DMeasures module.	CSV	SANDAG Modelers
bzone_urban-mixed-use_prop.csv	This file contains the target proportion of households located in mixed-used neighborhoods in zone and is used in the CalculateUrbanMixMeasure module.	CSV	SANDAG Modelers
bzone_urban-town_du_proportions.csv	This file contains proportion of Single-Family, Multi-Family and Group Quarter dwelling units within the urban portion of the zone and is used in the AssignLocTypes module.	CSV	SANDAG Modelers
Marea
marea_base_year_dvmt.csv	This file is used to specify to adjust the dvmt growth factors and is optional (only needed if user wants to modify the values). The file is used in the Initialize (VETravelPerformance), CalculateBaseRoadDvmt and CalculateFutureRoadDvmt modules.	CSV	SANDAG Modelers
marea_congestion_charges.csv	This file is used to specify the charges of vehicle travel for different congestion levels and is optional. The file is used in the Initialize (VETravelPerformance) and CalculateRoadPerformance modules.	CSV	SANDAG Modelers
marea_dvmt_split_by_road_class.csv	This file is used to specify the dvmt split for different road classes and is optional. The file is used in the Initialize (VETravelPerformance) and CalculateBaseRoadDvmt modules.	CSV	SANDAG Modelers
marea_lane_miles.csv	This file contains inputs on the numbers of freeway lane-miles and arterial lane-miles and is used in the AssignRoadMiles module.	CSV	SANDAG Modelers
marea_operations_deployment.csv	This file is used to specify the proportion of dvmt affected by operations for different road classes and is optional. The file is used in the Initialize (VETravelPerformance) and CalculateRoadPerformance modules.	CSV	SANDAG Modelers
marea_speed_smooth_ecodrive.csv	This input file supplies information of deployment of speed smoothing and ecodriving by road class and vehicle type and is used in the CalculateMpgMpkwhAdjustments module.	CSV	SANDAG Modelers
marea_transit_ave_fuel_carbon_intensity.csv	This file is used to specify the average carbon intensity of fuel used by transit and is optional. The file is used in the Initialize (VETravelPerformance) module.	CSV	SANDAG Modelers
marea_transit_biofuel_mix.csv	This file is used to specify the biofuel used by transit and is optional. The file is used in the Initialize (VETravelPerformance) and CalculateCarbonIntensity modules.	CSV	SANDAG Modelers
marea_transit_fuel.csv	This file is used to specify the transit fuel proportions and is optional. The file is used in the Initialize (VETravelPerformance) and CalculateCarbonIntensity modules.	CSV	VE Default
marea_transit_powertrain_prop.csv	This file is used to specify the mixes of transit vehicle powertrains and is optional. The file is used in the Initialize (VETravelPerformance) and CalculatePtranEnergyAndEmissions modules.	CSV	VE Default
marea_transit_service.csv	This file contains annual revenue-miles for different transit modes for metropolitan area and is used in the AssignTransitService module.	CSV	SANDAG Modelers
Region
other_ops_effectiveness.csv	This file is used to specify the delay effects of operations in different road classes and is optional (only needed if user wants to modify the values). The file is used in the Initialize (VETravelPerformance) and CalculateRoadPerformance modules.	CSV	SANDAG Modelers
region_ave_fuel_carbon_intensity.csv	This file is used to specify the average carbon density for different vehicle types and is optional (only needed if user wants to modify the values). The file is used in the Initialize (VETravelPerformance) and CalculateCarbonIntensity modules.	CSV	SANDAG Modelers
region_base_year_dvmt .csv	Base year highway truck dvmt for region. This input file is OPTIONAL. It is only needed if the user wants to adjust heavy truck dvmt for base year	CSV	SANDAG Modelers
region_carsvc_powertrain_prop.csv	This file is used to specify the powertrain proportion of car services and is optional. The file is used in the Initialize (VETravelPerformance), AssignHhVehiclePowertrain and AdjustHhVehicleMpgMpkwh modules.	CSV	SANDAG Modelers
region_co2e_costs.csv	Environmental and social cost of CO2e emissions per metric ton	CSV	VE Default
region_comsvc_ave_veh_age.csv	The average vehicle age of commercial vehicles	CSV	VE Default
region_comsvc_lttrk_prop.csv	This file supplies data for the light truck proportion of commercial vehicles and is used in the CalculateComEnergyAndEmissions module.	CSV	SANDAG Modelers
region_comsvc_powertrain_prop.csv	This file is used to specify the powertrain proportion of commercial vehicles and is optional. The file is used in the Initialize (VEPowertrainsAndFuels) and CalculateComEnergyAndEmissions modules.	CSV	VE Default
region_hh_ave_driver_per_capita.csv	This file contains the target ratio of drivers each age group.	CSV	SANDAG Modelers
region_hvytrk_powertrain_prop.csv	The file is used to specify the powertrain proportion of heavy duty trucks and is optional. The file is used in the Initialize (VEPowertrainsAndFuels) and CalculateComEnergyAndEmissions modules.	CSV	SANDAG Modelers
region_prop_externalities_paid.csv	file supplies data for climate change and other social costs and is used in the CalculateVehicleOperatingCost module.	CSV	VE Default

Go To Top

Next Section: Output Files