8f99f6535e
- 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
5 lines
165 B
SQL
5 lines
165 B
SQL
SELECT id, plant_code, name, operator, capacity_mw, fuel_type, state,
|
|
ST_AsGeoJSON(location)::TEXT as location_geojson
|
|
FROM power_plants
|
|
ORDER BY capacity_mw DESC
|