As I've started to use Google Calendar to schedule more and more of my life, I've found that during the winter, it's really useful to know when it'll be raining. Of course this can be achieved through a variety of weather apps and websites, but it's a hassle to have to open an app, see when it's going to rain, and then update events accordingly. It would be much easier if hourly rain showed up as an event within Google Calendar!

So, I decided to attempt to create a solution with [OpenWeatherMap](https://openweathermap.org/) and [Google Apps Script](https://script.google.com). It turned out to be much simpler than I thought!

You can view a gist with the full code [here](https://gist.github.com/eIiot/0603add6cbfd967a000b3db1799f4a3e), but here's a quick rundown of how the script works:

1. All events are cleared on the "Rain" Google Calendar.

2. The script calls OpenWeatherMap's `onecall` API to get the next 48 hours of hourly weather data.

3. The script then loops through every hour.

   1. If rain starts in a given hour, the timestamp is stored as the start of a "rain period".

   2. If rain continues in a given hour, the duration of the current "rain period" is extended.

   3. If rain stops in a given hour, the current "rain period" is uploaded to Google Calendar.

4. If the current rain period hasn't stopped, the script uploads it to Google Calendar.

Using Google Apps Script, the script is automatically run every hour, so the forecast stays current. Unfortunately, OpenWeatherMap only provides the next 48 hours of hourly data for free, but this small script is still useful for some scheduling in the near future.

Display Rain in Google Calendar

Developer

TOC Quarterfinalist

🎓 Top 8 in the nation in Parliamentary Debate

Tournament Champion

🪪 Spoke about how students are surveilled by schools with tracking technology like Go Guardian

Forum

Trans and nonbinary students in Berkeley are fighting for the right to use the bathroom

Moved the Assembly Builders site away from Squarespace and onto Statamic, complete with a total site redesign.

Assembly Builders

📰 Making the news more accessible, interactive, and interesting for over 40k monthly visitors! Doubled annual web traffic (150k → 300k visitors per year). Migrated over 3,000 articles from Wordpress to Statamic. The Jacket is one of the only student newspapers in the country using a fully custom theme, and is highly ranked nationally by the NSPA and CSPA.

Web Design

🚊 In preparation for a trip across the US on Amtrak's California Zephyr, I build the "Rail Map," a way to discover railroad crossings and rail bridges, track Amtrak and Caltrain, and more.

The Rail Map

✨ Tracking historical OpenAI model status and latency

OpenAI Status Page

Find California DMV appointments faster. Create notifications for surprise openings.

DMV Filter

🚄 Helped to rewrite Amtraker, an API for tracking Amtrak trains which serves ~3M monthly requests. The new API uses Bun, a new JavaScript runtime that improves performance and request speed by over 3x when compared to node.

Amtraker v3

📝 A directory of times, dates, and locations of IB & AP exams at BHS

BHS Testing Schedule

BHS Countdown

BHS Map

Covid in Pixels

enroll.stanf.org

📝 Read and write to Google Forms with a free API!

openform

🌎 Launched a rework of my personal website

Personal Website

🚉 Interactive BART map that adjusts distance based on travel time

Subway

🍭 A Target cart aggregator and delivery service for Donner.

DonnerDash

🏡 Find photos of Stanford Dorms before arriving on campus. Fizz-varial. Opening again in Spring 2025.

Treehouses

📊 Scraped IBO grade information from PDFs, and made an interface to display it nicely, with some fun data visualizations! More planned...

IB Grade Boundaries

Rain in Google Calendar

BHS Fire Alarms

🕝 Super simple year progress indicator

yprog

🎓 Search through thousands of photos from my high school's graduation using facial recognition

Graduation Photo Finder

🌐 My original personal website. Lots of scroll based animations.

Personal Website v1

📷 Added a responsive photos gallery to my personal website

Photos Gallery

⏳ the world's most minimalist pomodoro timer

pomodoro

📊 Allowing Berkeley High students to contribute their high school experience, and creating data-visuals with crowdsourced results.

Rate My Small School

Occasional Judge for NYPDL and NYPDL-associated tournaments.

Judge

Music Mentor

CIT (Counselor in Training)

Journalist

Varsity Captain & Web Manager

👨‍💻 Improving web presence for the US' only fully student run Parliamentary Debate League.

Web Director

🌯 Helping local business expand their platform

Founder

📰 Making the news more accessible, interactive, and interesting!

Web Editor

🏗️ Working on numerous projects in the AI / ML / LLM space.

Eliot Hertenstein

2023