Mode Choice Report

The mode choice report project contains a set of stored procedures and a PowerBI template file to create the automated Service Bureau Mode Choice report. To run the Service Bureau Mode Choice report simply open the PowerBI template file and supply three parameters; the UNC network path to a one-column csv file containing the list of MGRAs in the project area with the column name "mgra", the ABM database scenario id of interest, and a description for the project.

Resources

File	Description
ModeChoiceReport.pbit	Service Bureau Mode Choice report PowerBI template

SQL Stored Procedures

Name	Description
[mode_choice_report].[demographics]	Synthetic population based demographics including non-institutionalized group quarters and telecommuters
[mode_choice_report].[internal_capture]	Study area intra-zonal vehicle trips
[mode_choice_report].[mgra_intrazonals]	MGRA-based inter/intra-zonal trips for Resident Models
[mode_choice_report].[mode_share]	Trip mode share for Resident Models
[mode_choice_report].[mode_share_peak]	Peak-period trip mode share for Resident Models
[mode_choice_report].[trip_lengths]	Trip length-based metrics