←Back to projects

Project 07

SBCTA: Long-Range Multimodal Transportation Plan

Hero image

Export at 1920 × 1080

The lead visual for this project — a screenshot of the live site, map, or survey.

Survey analysis and ArcGIS geospatial modeling shaping a countywide transportation vision through 2050.

I led the analysis behind the public engagement for San Bernardino County's Long-Range Multimodal Transportation Plan — cleaning, validating, and visualizing the initial public survey, then using ArcGIS to run geospatial analysis showing how transportation preferences and needs varied across the county.

Year
Aug 2023 – Present
My role
Technology Coordinator
Location
San Bernardino County, CA
Disciplines
GISData AnalysisData DashboardsSurvey Design

The challenge

San Bernardino County is the largest county in the contiguous United States, and a transportation plan reaching to 2050 has to serve bus and rail riders, drivers, truckers, cyclists, and pedestrians across terrain that ranges from dense urban grid to open desert. A countywide survey average would have been close to meaningless — it would describe a typical resident who does not exist anywhere. The analytical problem was to keep geography attached to the responses so the plan could tell where each need actually lived.

My approach

I owned the survey data end to end. I cleaned and validated the raw responses first, since analysis built on unexamined data would have quietly misdirected a twenty-five-year plan. I then visualized the results for presentations and reports aimed at non-technical audiences, and used ArcGIS to run geospatial analysis joining responses to location — surfacing where access, safety, connectivity, and sustainability priorities diverged across the county rather than reporting a single blended figure.

  • Cleaned, validated, and visualized the plan's initial public survey data
  • Conducted in-depth geospatial analysis in ArcGIS to map preferences and needs across the county
  • Produced visualizations and reports translating geospatial findings for non-technical stakeholders

What did I learn from this work?

What did I learn?

Resisting countywide averages that would have masked the sharp regional differences the plan needed to address.

What did I learn?

Cleaning and validating raw survey data rigorously enough to trust it as the basis for long-horizon planning decisions.

What did I learn?

Presenting geospatial findings so that stakeholders without a GIS background could read and act on them.

What difference did we make?

Gave the planning team a geographic view of public priorities rather than a single countywide average.

Ensured the long-range planning process was informed by validated community data across all modes of travel.