Documentation

Active Tranportation Planners in the Bicycle and Pedestrian Planning Department at MTC/ABAG are requesting mapping support from the Data Visualization Department to identify bicycle facilities built since 2009 in the 9-county Bay Area based on data provided by local Congestion Management Agencies (CMAs).

Define the Problem Statement

In 2009, how many miles are in the Regional Bike Network?
How much of the Regional Bike Network has been built since 2009?
How many miles are in the San Francisco Bay Trail Network?
How many miles of the SF Bay Trail are in the Regional Bike Network?

Mapping support will summarize the provided bike network datasets obtained from CMAs in late 2018.

In terms of this request, the 2009 Regional Bike Network is refering to the Regional Bike Plan feature class and the 2009 Regional Bike Facilities is the union of all bicycle facilities regardless of regional significance. And both contained on MTC GIS AGOL

Project Management

• Asana Project
• Box

Contents

• Data Sources
• Analysis Parameters
• Methodology
• Expected Outcomes
• Results

Data Sources

San Francisco Bay Trail
Regional Bike Facilities
Regional Bike Plan
Regional CMA-provided datasets

Analysis Parameters

Update the built and not built summaries for all 9 Bay Area Counties according to the data provided by the CMAs

Methodology

1. Upload all 9 Bike Network datasets and update to common projection: UTM NAD 83 Zone 10N
2. Upload Regional Bike Facilities -this is all bicycle facilities
3. Upload Regional Bike Plan
4. Upload SF Bay Trail
5. Identify the facilities in 2009 Regional Bike Network and the SF Bay Trail in 2018.
6. Identify the facilities in 2009 Regional Bike Network and current county bicycle facilities in 2018.
7. Spatially erase 2018 data from the 2009 data (SF Bay Trail and county-level datasets)
8. Then erase results from step 7 from 2009 data.
9. Create attribute ‘status2018’ then flag resulting dataset from step 7 by field calculating as ‘unbuilt’.
10. Create attribute ‘status2018’ then flag resulting dataset from step 8 by field calculating as ‘built’.
11. Merge outputdatasets from steps 9 and 10.
12. Spatial join the merge output fro step 11 to 2009 Regional Bike Plan dataset.
13. Create attribute ‘new2018status’ then flag final results accordingly:

Expected Outcomes

Inform the Regional CMAs, Plan Bay Area and Bicycle and Pedstrian Commitees of updates to teh Regional Bicycle Newtork. .

Results

Source: San Francisco Bay Trail

Source: 2009 Regional Bike Network (Regional Bike Plan)

Source: 2018 Updated Regional Bike Network