joey/busi488energy
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
31 Commits 1 Branch 0 Tags
Commit Graph

7 Commits

Author SHA1 Message Date
Joey Eamigh
2be824405d
fixes and tweaks to iran war content 2026-04-05 20:53:33 -04:00
Joey Eamigh
7423b8e622
iran war 2026-04-05 12:56:40 -04:00
Joey Eamigh
46a3416526
fixing backfill/live data bug 2026-04-05 11:42:21 -04:00
Joey Eamigh
ad1a6792f5
phase 8: UI/UX overhaul — layout, charts, map, data freshness 
- Fix ticker tape CLS with skeleton loader and fixed height
- Add Inter font, max-width container, responsive dvh units
- Hero metrics: trend deltas, per-metric sparkline colors, 3+2 grid
- GPU calculator: step=100 slider + text input, PUE factor, region comparison bars
- Grid stress: replace misleading arc gauges with demand status bars
- Demand summary: expand to 4-metric highlights grid
- Charts: responsive heights, ISO/non-ISO toggle, correlation R² + trend line
- Map: US-wide default view, marker clustering, enriched region panels, zoom controls
- Fix NYISO polygon (NYC), MISO polygon (Michigan), MISO south (MS/LA)
- Add automated ingestion via instrumentation.ts
- Add data freshness indicator in footer
- Fix backfill start date to 2019-01-01 (EIA RTO data availability)
 2026-02-11 19:59:01 -05:00
Joey Eamigh
8f99f6535e
phase 7: full US coverage — grid regions, datacenters, power plants, backfill, chart perf 
- Add 7 new grid regions (BPA, DUKE, SOCO, TVA, FPC, WAPA, NWMT) to cover entire continental US
- Expand datacenters from 108 to 292 facilities across 39 operators
- Add EIA power plant pipeline: download script, 3,546 plants >= 50 MW with diamond map markers
- Rewrite backfill script for 10-year data (2015-07-01) with quarterly/monthly chunking, 3-region parallelism, resumability
- Add materialized views (daily/weekly) with server-side granularity selection for chart performance
- Fix map UX: z-index tooltips, disable POI clicks, move legend via MapControl
 2026-02-11 16:08:06 -05:00
Joey Eamigh
7a1bbca339
fix: comprehensive review fixes — real price data, missing components, SQL bugs, security 
- Replace $0 electricity prices with real EIA retail-sales data (IND sector)
  with demand-based hourly variation (0.8x-1.2x)
- Add sparkline component and alerts feed to dashboard home
- Add animated number transitions to hero metric cards
- Fix ticker tape price direction (green/red arrows with % change)
- Fix AI milestone annotation alignment on price charts
- Fix SQL cartesian products in getDemandByRegion and getRegionPriceHeatmap
  using CTEs for independent aggregation
- Add unique composite constraints to prevent duplicate data
- Add bearer token auth to ingestion API routes
- Add 30s fetch timeouts to EIA and FRED API clients
- Add regionCode validation in server actions
- Fix docker-compose: localhost-only port binding, correct volume path
- Fix seed script to preserve ingested time-series data
 2026-02-11 13:23:21 -05:00
Joey Eamigh
64f7099603
phase 2: data layer — EIA/FRED clients, server actions, ingestion routes, backfill 2026-02-11 04:41:57 -05:00