GreenTrack — California 2025 findings
Energy (EIA, CAISO), weather (Open-Meteo, 5 cities) and air quality (OpenAQ, 10 reference monitors), processed by the GreenTrack data pipeline.
All six phases complete and reviewed. Phase 6 results: 202 automated tests passing; a full rebuild from raw data reproduces the processed tables exactly and the analytics tables to within 1e-15; every KPI view answers in under 5 ms. Data: calendar year 2025, California local time.
Energy
Renewables and imports by month
Renewable = solar, wind, hydro and geothermal (EIA definition). Share of generation peaks in spring; imports peak in winter.
Show table
2025 net generation by fuel (TWh)
Total 186.3 TWh vs 224.0 TWh demand: California imports the rest. OTH is net negative (battery charging).
Show table
Grid demand load factor by month (%)
Average ÷ peak hourly demand. Lowest May–Sep, when afternoon air-conditioning peaks sit far above the daily average.
Show table
Weather and air quality
Monthly mean temperature by city (°C)
Inland Fresno and Sacramento swing most; San Francisco least. Statewide 2025 mean 17.1 °C.
Show table
Days with daily mean PM2.5 above 35 µg/m³
A monitoring indicator, not a regulatory determination. LA's worst day was 79.0 µg/m³ on 8 Jan.
Show table
Data quality
A one-hour EIA glitch: 31 Jul 2025, 13:00 local
Hourly demand drops from 29,881 to 11,819 MWh and recovers the next hour; fuel totals disagree with net generation by 8.2 % in the same hour. Kept (validation never changes values) and logged as an open issue.
Show table
Issues logged in the final validation run
Accepted = known and expected (decided at the Phase 4 review); open = still worth attention. 0 records failed a hard rule.
Show table
Air-quality coverage: share of 2025 hours with a reading
29 sensor series at 10 AirNow monitors. Dashed line at 90 %.
Show table
Analytics reconciliation (spec success criterion 4)
Every daily and monthly KPI input is recomputed from the hourly data and compared.