Skip to content

Mode Choice Report

Gregor Schroeder edited this page Sep 3, 2021 · 1 revision

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