2026 — Present
Featured Case Study
Local Driving Intelligence
A regional data platform built for Bay Area and Northern California drivers. It combines weather, route cameras, traffic activity, events, and preparation workflows while keeping the underlying public feeds inspectable.
- Stack
- React · Node.js · Express · SQLite
- Focus
- Regional data integration · Route-aware interfaces · Reliability
- Current Work
- Imagery playback · Provider reliability · Cache behavior · Regional coverage
Before the drive
See weather, route activity, cameras, and event details before leaving.
Full-stack system
I built the React interface, Express API, and SQLite data layer.
Recent data stays available
Cached results keep the dashboard useful when a public feed fails.
More routes and history
Current work adds weather playback and broader Northern California coverage.
Interface Evidence
Regional features in context
Each view connects a public data source or preparation task to the route, location, or event being planned.
System Flow
Architecture summary
- 01Public data providersWeather, cameras, incidents, closures, message signs, events, stations, and imagery
- 02Validation and normalizationProvider-specific responses converted into consistent application records
- 03Persistence and refreshSQLite storage, bounded caches, deduplication, scheduled collection, and stale-data handling
- 04Regional interfaceRoutes, corridors, locations, cameras, alerts, events, and weather shown in context