Fragmented Growth
Rapid municipal expansion across Los Angeles outpaced spreadsheet-based tracking and manual site coordination.
PlayLA Olympic Youth Sports Operations
From scattered spreadsheets to a citywide youth sports operating map.
A sport-agnostic relational database and geographic mapping architecture linking 1,520 schools, 419 parks, and 15 active program locations across Los Angeles.
Airtable
Google Cloud
Mermaid.js
Vite & TypeScript
Bilingual Field App
Strategic Context
Building civic infrastructure from zero.
PlayLA expanded across Los Angeles with community momentum, but the operating layer was fragmented: isolated spreadsheets, site-by-site phone coordination, and critical operational details like coach certifications and school logistics living in disconnected silos.
I built the underlying relational architecture: 1,520 schools, 419 recreation parks, and 15 active program locations unified into a structured model that surfaced coverage gaps, streamlined outreach, and gave citywide scale transparent visibility.
Schools Mapped
1,520 Verified
Educational institutions cataloged and linked across LA districts.
Recreation Parks
419 Linked
Municipal park facilities mapped for youth sports program delivery.
Active Program Sites
15 Centralized
Flag football clinic locations brought into a unified management view.
Field App Delivery
Bilingual EN / ES
Mobile-first operational resource for coaches, referees, and parents.
Operating Infrastructure
The operating system made citywide operations manageable.
Geographic intelligence & community distribution
The relational mapping dashboard made school, park, and recreation center relationships visible across Los Angeles districts, allowing coordinators to pinpoint coverage gaps.
Centralized Airtable operations engine
The dashboard consolidated active program locations, participant rosters, compliance records, and equipment tracking into a single operational interface.
Automated data routing logic
Data ingested from schools and fields flows through automated checks to validate compliance and assign logistical assets without manual overhead.
Verified Production Stack
Airtable
Relational database
Google Cloud
Cloud infrastructure
Mermaid.js
Workflow architecture
Vite & React
Bilingual Field App
Engineered for durability
Engineered using confirmed cloud and database tooling, keeping the operating architecture lightweight and maintainable for field staff.
Operational Workflow
How the system transformed field execution.
Relational Model
Structured 1,520 schools and 419 parks into normalized schemas with geocoded relationships and compliance tracking.
Coverage Logic
Automated feeder-school mapping to identify underserved recreation districts and reallocate coaching resources.
Public Field App
Deployed a bilingual, mobile-first web app for coaches, officials, and parents to access schedules and logistics.
Strategic Executive Takeaway
Scaling civic and youth sports operations requires relational data rigor.
Large-scale youth sports and community programs encounter friction when logistics rely on individual heroics and disconnected spreadsheets. Scaling across hundreds of facilities demands a structured relational foundation where facilities, personnel, compliance, and participants are tied together seamlessly.
By architecting a relational operating model for PlayLA, I turned fragmented civic data into an actionable system map. This exact discipline applies to enterprise operations: transforming complex multi-stakeholder workflows into clear, reliable systems that empower teams to execute without friction.
