QAQC Interpretation Tools - BayAreaMetro/modeling-website GitHub Wiki

Input Summary & QAQC

Network coding (individual projects)

• Tableau workbook template, project diff can be automatically created during network build: https://github.com/BayAreaMetro/NetworkWrangler/tree/master/ProjectMapping
• PBA50+ network coding Tableau online: Modeling/Plan Bay Area 2050+/Project QA
• (Special project) Seamless strategy: Tableau workbook
• (Special project) Sea level rise flooding and rerouting: working files for roadway link flooding tagging: M:\Application\PBA50Plus_Data_Processing\SLR\FBP_tag_TM1_roadway_links; QAQ Tableau workbook

System-wide network

• Roadway (roadway supply, tolls / FT / USE): Tableau workbook template; PBA50+ FBP version saved at M:\Application\Model One\RTP2025\INPUT_DEVELOPMENT\Networks\network_comparison_FinalBlueprint\network_comparison_Roadway_FinalBlueprint.twb
• Transit supply: Tableau workbook template; PBA50+ FBP version saved at M:\Application\Model One\RTP2025\INPUT_DEVELOPMENT\Networks\network_comparison_FinalBlueprint\network_comparison_Transit_FinalBlueprint.twb
• Transit fare: M:\Application\Model One\RTP2025\INPUT_DEVELOPMENT\Networks\network_comparison_FinalBlueprint\ferries_FinalBlueprint.twb
• Transit accessary (connectors, etc.): TBD

TAZ - Growth Geographies crosswalks

• Used for the parking strategy and some performance metrics. Relevant scripts in folder utilities/geographies/create_geography_overlays; QAQC Tableau for PBA50 at M:\Application\PBA50Plus_Data_Processing\crosswalks\TAZ_GGTRA_crosswalk_QAQC.twb

Output Summary & QAQC

• Top-sheet summary (key outputs including VMT, mode share, ridership, trips): Tableau workbook template; PBA50+ FBP version saved at M:\Application\Model One\RTP2025\Blueprint\across_runs_FinalBlueprint\across_RTP2025_FBP_runs.twb
• Performance metrics for Plan Bay Area 2050+ Outcomes: metrics_Affordable.twb (including travel cost details), metrics_Connected.twb (including highway corridor travel time debug view), metrics_Healthy.twb (emissions, mode share, safety, etc.), metrics_Vibrant.twb. PBA50+ version saved at \Box\Plan Bay Area 2050+\Performance and Equity\Plan Performance\Equity_Performance_Metrics\Final_Blueprint
• Roadway (lane miles summary; congested speed; cordon; speed limit check): Tableau workbook template; PBA50+ FBP version saved at M:\Application\Model One\RTP2025\Blueprint\across_runs_FinalBlueprint\across_RTP2025_FBP_roadways.twb
• Transit supply & demand, crowding: Tableau workbook template; PBA50+ FBP version saved at M:\Application\Model One\RTP2025\Blueprint\across_runs_FinalBlueprint\across_RTP2025_FBP_transit.twb
• Journey to Work (WFH related): Tableau workbook template; PBA50+ FBP version saved at M:\Application\Model One\RTP2025\Blueprint\across_runs_FinalBlueprint\across_RTP2025_FBP_JourneyToWorkModes.twb
• Activity Duration (for downtown activities summary): Tableau workbook template; PBA50+ FBP version saved at M:\Application\Model One\RTP2025\Blueprint\across_runs_FinalBlueprint\across_RTP2025_FBP_ActivityDuration.twb
• CO2 Emissions: Tableau workbook template; PBA50+ FBP version saved at M:\Application\Model One\RTP2025\Blueprint\across_runs_FinalBlueprint\across_RTP2025_FBP_emissions.twb
• perCapita VMT and perWorker VMT: Tableau workbook template; PBA50+ FBP version saved at M:\Application\Model One\RTP2025\Blueprint\VMT per capita or worker
• Over-burdened Communities Emission Inventory: Relevant scripts and Tableau (including QAQC maps) in folder utilities/RTP/Emissions/over_burdened_communities_emission_inventory; PBA50+ FBP version saved at M:\Application\PBA50Plus_Data_Processing\OverburdenedCommunities_analysis\PBA50plus\links_OverBurdened\Analysis-Overburdened-PBA50plus_EMFAC2025.twb
• For PBA50+ Modeling Supplemental Report: M:\Application\Model One\RTP2025\Blueprint\across_runs_FinalBlueprint\across_RTP2025_Forecasting_Modeling_Report.twb