My Weird Prompts
Daniel noticed his nocturnal delivery runs through Jerusalem felt quieter at certain hours — but he wanted confidence intervals, not vibes. This episode walks through how to programmatically query Google's Routes API, dump results into BigQuery, and use percentile analysis to find the exact quietest 45-minute window for any route on any day. We cover sampling strategy, API mechanics, the free tier math, and why Jerusalem's Shabbat-driven traffic patterns make this genuinely non-trivial. No gut feelings — just durationInTraffic data and statistical confidence.
300 episodes
Comments
0Be the first to comment
Sign up now and become a member of the My Weird Prompts community!