SF2G — San Francisco Commute Tracker

A competitive cycling commute tracker for the SF2G community. Connect your Strava account, sync your rides, and see how you stack up across seven Bay Area corridors.

Live at sf2ging.com

Features

• 🔐 Strava OAuth — One-click login via Strava
• 🔄 Auto-Sync — Full history fetch for new users, incremental sync for returning riders
• 🏆 Leaderboard — Virtualized table ranking riders by total commutes, with expandable ride details
• 🗺️ Route Classification — GPS gateway-based classification into 7 corridors:
  • Bayway — Bay Trail along the eastern shoreline
  • Skyline — Skyline Blvd through the hills
  • HMBW — Coastal Highway 1 through Devil's Slide
  • Royale — El Camino Real boulevard route
  • Fleaway — Flat El Camino / Bayshore blend
  • MEBW — Middle East Bay Way through Castro Valley
  • FEBW — Far East Bay Way through Berkeley Hills and Dublin
• 🌬️ Wind Data — Tailwind/headwind indicators enriched from weather APIs
• 🗺️ Interactive Maps — Leaflet-powered route visualization with gateway markers
• 📊 Rider Profiles — Per-rider stats, ride history table, frequency charts, and route breakdowns
• 📈 Community Charts — Route distribution pie charts and growth trends
• 🔍 Leaderboard Filters — Filter by route, time period, and rider with chip-based UI
• 🌙 Dark/Light Mode — Theme toggle with system preference detection
• 📐 Unit Toggle — Switch between metric and imperial
• 📱 Responsive — Mobile-first design
• 📊 Analytics — PostHog integration for usage tracking

Tech Stack

Layer	Technology
Framework	TanStack Start (full-stack React)
UI	React 19, TanStack Table, TanStack Virtual
Data	TanStack Query
Backend	Supabase (PostgreSQL + REST)
Auth	Strava OAuth 2.0
Charts	Recharts
Maps	Leaflet
Analytics	PostHog
Styling	Vanilla CSS (custom properties, glassmorphism)
Testing	Vitest
Bundler	Vite
Deploy	Cloudflare Workers (Free plan)
Package Manager	pnpm

Getting Started

Prerequisites

• Node.js (v22+) and pnpm (v12, pinned via packageManager)
• Docker (Docker Desktop, or brew install colima docker && colima start)
• Supabase CLI (brew install supabase/tap/supabase)
• A Strava API application with localhost in its Authorization Callback Domain (only needed to log in locally)

Setup

git clone https://github.com/pmaier983/sf2g.git
cd sf2g
pnpm install

# Local database (never point local dev at production)
pnpm db:start        # starts Postgres + PostgREST in Docker
pnpm db:reset        # applies supabase/migrations/* and supabase/seed/*

cp .env.example .env.local   # local Supabase defaults are pre-filled
pnpm dev                     # http://localhost:5173

This is the beginning of the README. Read the rest at the original. Read the full README ↗