Project 07
SBCTA: Long-Range Multimodal Transportation Plan
Hero image
Export at 1920 × 1080
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.