Northern California Megaregion Goods Movement Analysis & Mapping

The Goods Movement program at MTC provides a regional, coordinating framework from which funding and planning priorities are developed. The current planning framework is the San Francisco Goods Movement Plan, adopted in 2016, which prioritizes sustainable, global competitiveness in freight. The primary strategies for realizing this goal are through increasing capacity at the Port of Oakland, increasing access to industrial land region-wide, improving efficiency and emissions of urban deliveries, and reducing adverse impacts of freight movement along the highway and rail corridors.

Contents

Problem Statement

Data Sources

Analysis Parameters

Methodology

• Summary
• Detailed

Expected Outcomes

Results

Problem Statement

The purpose of this project is to analyze business, transportation, and demographic data for the 22 County Northern California Megaregion, which will inform the works of planners and decision makers supporting the MTC Goods Movement program.

Asana Project

Data Sources

• California Business Data: Esri;Infogroup 2016
  • Datasets are licensed and therefore not to be distributed publicly
• FMMP Urban 2014
• 2015 American Community Survey 5 Year Estimates
• Freight Analysis Framework (FAF) 4 Network Database and Flow Assignment: 2012 and 2045

Potential Data Sources

U.S. Department of Transportation - Federal Railroad Administration

• Highway-Rail Crossing Collisions 2007-2017

Analysis Parameters

As part of this analysis process, we mapped NAICS 2 digit, 3 digit, and 4 digit codes to what we’ve defined as Supply Chain Roles. Similarly, we mapped NAICS 2 digit, 3 digit, and 4 digit codes to what we’ve defined as Goods Movement - Related Industries and Occuplations. Following are tables which group NAICS codes into classes.

Goods Movement - Related Industries and Occupations

Supply Chain Roles and NAICs Classifications

Workers without a College Degree

American Community Survey 5 Year Estimates: API Variables Reference

Table: B23006

Low Income Workers

Low income workers are workers 16 years and over with earnings below the median for California (for that group) which is $31,296 per year.

Table: S2001

ACS 2015 5 Year Estimates - Earnings in the Past 12 Months (California)

Table: B08119

Unemployed

Table: B23025

Methodology

Summary

1. Create Northern California Megaregion Businesses FC

   • Create Northern California Megaregion Business FC Script

2. Create Nothern California Megaregion Employment Density Feature Classes

3. Employment Summary by Goods Movement Class / Supply Chain Class

   Create Megaregion Employment Summaries

4. Unemployment Rate

   In 2015, 10% of California residents in the labor force were unemployed. Areas where more than 10% of residents in the labor force are unemployed is considered a moderate to high share.

   2015 ACS Unemployment Data - California

5. Workers without a College Degree

   In 2015, 64% of workers in California did not have a Bachelor’s Degree or higher. Areas where more than 60% of workers do not have a college Degree is considered a moderate to high share.

   2015 ACS Educational Attainment and Employment Status Data - California

6. Low Income Workers

   In 2015, 50% of workers in California made $35,000 or less. Areas where more than 50% of workers make less than $35,000 is considered a moderate to high share. The median income for a worker in California is $31,296 per year. Given the income is grouped into income brackets, the median income fell into the $25,000 to $34,999 range so anything below the top range was considered ‘low income’.

   2015 Earnings and Employment Status Data - California

Detailed

Create Northern California Megaregion Business FC

Script:

• Create Northern California Megaregion Business FC Script

Input:

• California Business Data
• Northern California Megaregion Counties

Output:

• GMS 2016 North CA Megaregion Businesses

Output Data Dictionary: Four fields were added to the original GMS_2016_CA_Businesses feature class; the full domain of each field is summarized in the table below:

Create Northern Claifornia Mega Region Employment Density Feature Classes

Two custom tools were created using ArcGIS Pro Model Builder to generate the final output feature class, as well as intermediary feature classes & rasters. The feature class generated highlights employment density within FMMP Urban and Built Up areas. The toolbox containing the tools is linked below. Assumptions are maintained as defaults within the tools.

Select By Attribute Create Point Density Raster

Tool: Select_By_Attr_Create_Point_Density_Raster

Input:

• GMS 2016 North CA Megaregion Businesses

Tool Input Values:

• Population field: EMPNUM
• Expressions:
  • All Industries: 'Goods_Mvmt_Class IN (1,2,3)'
  • Core Industries: 'Goods_Mvmt_Class = 1'
  • Dependent Industries: 'Goods_Mvmt_Class = 2'
  • Supported Industries: 'Goods_Mvmt_Class = 3'
  • Production: 'Supply_Chain_Class = 1'
  • Transportation: 'Supply_Chain_Class = 2'
  • Distribution: 'Supply_Chain_Class = 3'
  • Retail: 'Supply_Chain_Class = 4'
  • Waste: 'Supply_Chain_Class = 5'
• Output Cell Size: 20
• Mask: NC_Mega_Region_FMMP_Urban_2014_SF (Polygon)
  • Built - up areas

Tool Assumptions:

Output:

This process created 9 output rasters, each following a patterned naming convention followed by the goods movement or supply chain class to to disambiguate each feature. Examples of that convention are provided below. These are intermediate features, which will were reclassified and converted from raster to polygon in the following process. To see the name of each output, follow the respective links below.

• NC_Megaregion_Emp_Density_GoodsMvmtClass (Raster)
• NC_Megaregion_Emp_Density_SupplyChainClass (Raster)

Reclassify Convert Raster to Polygon

Tool: Reclassify_Convert_Raster_to_Polygon

Input:

This process was not integrated into the last process as each of the input rasters to the process needed to be classified seperately. Reclassification tables were created for each reclass feature and are referenced below. the 9 output rasters created from the previous process were input into this tool, each following a patterend naming convention followed by the goods movement or supply chain class.

• NC_Megaregion_Emp_Density_GoodsMvmtClass (Raster)
• NC_Megaregion_Emp_Density_SupplyChainClass (Raster)

Tool Input Values:

Each raster was reclassified, creating classes by standard deviation values. Those values were stored in tables for reference each following a pattered naming convention followed by the goods movement or supply chain class to disambiguate each feature. Examples of that convention are provided below.

• Reclass_Table_GoodsMvmtClass
• Reclass_Table_SupplyChainClass

Output:

This process created 9 output vector feature classes, each following a patterned naming convention followed by the goods movement or supply chain class and ‘rc’ or reclassifed to to disambiguate each feature. Examples of that convention are provided below.

• NC_Mega_Region_Emp_Density_GoodsMvmtClass_RC (Raster)
• NC_Mega_Region_Emp_Density_SupplyChainClass_RC (Raster)

Employment Summary by Goods Movement Class / Supply Chain Class

Script:

Create_megaregion_Employment_Summaries

Input:

• GMS 2016 North CA Megaregion Businesses

Output:

• 2016_Megaregion_Emp_Tot_By_GM_Class.csv
• 2016_Megaregion_Emp_Tot_By_SC_Class.csv

Results

Tools

• NC_Megaregion_Goods_Movement_Study FGDB

Maps, Charts, and Graphics

• Illustrator Files
• Image Files (PDFs/PNGs)

Feature Classes & CSVs

• NC_Megaregion_Goods_Movement_Study FGDB
• 2016_Megaregion_Emp_Tot_By_GM_Class.csv
• 2016_Megaregion_Emp_Tot_By_SC_Class.csv