← All work
Project 07 · Case study OCT, 2026

California Grid

Custom Software · Web Design & Development · FastAPI, Postgres, React, Tailwind

A wind turbine seen from just below its hub, blades cropped off the top, solar fields far below, dithered paper on black
01 — Overview

Overview

A live dashboard of California's power grid, built from CAISO's public five-minute data.

California Grid is a live view of the state’s power grid. It reads CAISO’s public Today’s Outlook and OASIS data every five minutes and shows how much of the power is renewable, how much CO₂ each kilowatt-hour carries, what the batteries are doing, and how much spare capacity the grid has left.

A strip of today’s hours marks the cleanest stretch of the day next to the day-ahead price, so anyone charging a car or running a dryer can see when the grid is cleanest and cheapest. Charts below break the day down by fuel, compare demand with net demand after wind and solar, and track CO₂ intensity hour by hour.

Datasheet Midtown Pixel Studio
Date
OCT, 2026
Stack
FastAPI, Postgres, React, Tailwind
Services
Custom Software · Web Design & Development
02 — Screens

The work

Dashboard with renewable share, CO₂ intensity, batteries, demand and headroom tiles, and today's cleanest hours
Fig. 01 Dashboard, with today's cleanest hours under the live tiles
Hourly fuel mix, demand vs. net demand and CO₂ intensity charts
Fig. 02 Fuel mix, demand and CO₂ through the day
The dashboard in dark mode
Fig. 03 Dark mode
03 — Notes

How it was built

Brief

Show what California's grid is doing right now, and when today's power is cleanest and cheapest, from CAISO's public data.

Build

A poller stores CAISO's five-minute fuel mix, demand, storage and CO₂ feeds, plus day-ahead forecasts and prices. The API derives the renewable share, CO₂ intensity, battery output and spare capacity per request, and the page refreshes every five minutes.

Stack

FastAPI and SQLAlchemy over Postgres for the data, so the history can be backfilled and queried by day. React with TanStack Query and Tailwind for the page. Docker Compose behind Caddy, self-hosted on Coolify.

04 — Contact

Let's make an impact together.

workwith@midtownpixel.studio
Write to us →