2021 Regional Plan

The 2021 Regional Plan project contains SQL objects, a Python project, and a formatted Excel template. The main output product is a formatted and populated Excel workbook containing up to seven scenarios for performance measure and SB375 comparison.

To run the project

• Pull the ABM-Reporting repository from GitHub into your local environment
• Update the settings.py file located in the python\rp_2021 folder to point at the correct SQL Server instance and database containing the rp_2021 SQL objects created by the rp_2021.sql file in the sql\rp_2021 folder (ex. server = "MySQLInstance", database = "MyDataBase")
• Update the settings.py file located in the python\rp_2021 folder with the desired full path of the formatted and populated Excel workbook (ex. templateWritePath = "C:/Users/MyUserName/Desktop/PerformanceMeasures.xlsx")
• Update the settings.py file located in the python\rp_2021 folder with the list of up to seven comparison scenarios IDs and their labels within the Regional Plan. See the settings.py file for examples and possible labels.
• Use the environment.yml file located in the python\rp_2021 folder to create the rp_2021 Python virtual environment and set as the project interpreter
• Run python\rp_2021\main.py from the top-level ABM-Reporting working directory

Python

File	Description
environment.yml	conda environment used to run rp_2021 python files
main.py	orchestrator file used to populate the rp_2021 Excel Workbook
performanceMeasuresM1M5.py	class for all information and utilities relating to calculations of Main Performance Measures M1-(a-c) and M5-(a-c)
settings.py	settings file used to run rp_2021 python files

Resources

File	Description
Performance Measures_template.xlsx	formatted Excel template to hold output from rp_2021 scenario comparisons

SQL Tables and Views

Name	Description
[rp_2021].[freight_distribution_hubs]	Table of series 13 TAZs identified as freight distribution hubs
[rp_2021].[mobility_hubs]	Table of series 13 MGRAs identified as mobility hubs
[rp_2021].[particulate_matter_grid]	Table holding a representation of the San Diego region broken into a square polygon grid
[rp_2021].[results]	Table holding results from 2021 regional plan measures

SQL Table Valued Functions

Name	Description
[rp_2021].[fn_particulate_matter_ctemfac_2014]	calculate link level particulate matter 2.5 and 10 emissions using emfac 2014
[rp_2021].[fn_particulate_matter_ctemfac_2017]	calculate link level particulate matter 2.5 and 10 emissions using emfac 2017
[rp_2021].[fn_person_coc]	ABM synthetic population with Community of Concern (CoC) designations
[rp_2021].[fn_transit_node_tiers]	transit stop ([near_node]/[trcov_id]) for Tier 1, Tier 2, and Tier 3 transit stops

SQL Stored Procedures

Name	Description
[rp_2021].[sp_m1_m5_destinations]	destinations at the MGRA level used in calculations for the 2021 Regional Plan Main Performance Measures M1 and M5
[rp_2021].[sp_m1_m5_populations]	population at the MGRA level used in calculations for the 2021 Regional Plan Main Performance Measures M1 and M5
[rp_2021].[sp_particulate_matter_ctemfac_2014]	calculate person-level particulate matter 2.5 and 10 exposure using EMFAC 2014
[rp_2021].[sp_particulate_matter_ctemfac_2017]	calculate person-level particulate matter 2.5 and 10 exposure using EMFAC 2017