Energy

An ISO (Independent System Operator) manages a 45GW regional grid. Grid frequency must stay within 59.95–60.05 Hz — deviations beyond this range trigger automatic load shedding. With 12GW of intermittent solar and wind, frequency stability is a second-by-second challenge.

SCADA polls every 4 seconds. A 180ms frequency excursion to 59.91 Hz caused a 2GW automatic load shed last summer because the control room saw it 3.6 seconds too late.
LIVEpmu_readings
pmu_idsubstationfrequency_hzvoltage_kvphase_anglerocofts
PMU-4401Riverside 345kV59.93344.2-2.14-0.082024-07-18T15:42:00.016Z
PMU-4401Riverside 345kV59.91343.8-2.31-0.122024-07-18T15:42:00.033Z
PMU-2208Mesa Verde 230kV59.96229.7-1.08-0.042024-07-18T15:42:00.016Z
PMU-2208Mesa Verde 230kV59.94229.5-1.22-0.062024-07-18T15:42:00.033Z
PMU-6615Clearwater 500kV60.01499.80.420.012024-07-18T15:42:00.016Z
PMU-3309Ironwood 138kV59.97137.9-0.73-0.032024-07-18T15:42:00.016Z
Streaming SQLRunning
Detect frequency excursions
CREATE MATERIALIZED VIEW frequency_excursions AS
SELECT
  pmu_id,
  substation,
  frequency_hz,
  voltage_kv,
  rocof,
  ts,
  CASE
    WHEN frequency_hz < 59.90 OR frequency_hz > 60.10 THEN 'CRITICAL'
    WHEN frequency_hz < 59.95 OR frequency_hz > 60.05 THEN 'WARNING'
  END AS severity,
  CASE
    WHEN rocof < -0.10 THEN 'ACCELERATING'
    WHEN rocof < -0.05 THEN 'DEVELOPING'
    ELSE 'STABLE'
  END AS trend
FROM pmu_readings
WHERE (frequency_hz < 59.95 OR frequency_hz > 60.05)
  AND ABS(rocof) > 0.05;
Correlate with generation-load balance
frequency_alertsauto-updating
substationfrequency_hzrocofseverityrecommended_actiondetected_at
Riverside 345kV59.91-0.12CRITICALSolar output drop at Mojave Flats Solar (84/300 MW)2024-07-18T15:42:00.033Z
Mesa Verde 230kV59.94-0.06WARNINGSolar output drop at Mojave Flats Solar (84/300 MW)2024-07-18T15:42:00.033Z
Sun Valley Solar 230kV59.95-0.05WARNINGLoad surge in Zone 4 South (3820 MW vs 3290 MW forecast)2024-07-18T15:42:00.016Z
RisingWave processes 50,000 PMU readings/second. When frequency at substation PMU-4401 drops to 59.93 Hz with rate-of-change at -0.08 Hz/s, the system dispatches battery reserves within 200ms.
Best-in-Class Event Streaming
for Agents, Apps, and Analytics
GitHubXLinkedInSlackYouTube
Sign up for our to stay updated.