Generating Capability List

Every resource in the CAISO control area with its name, owner, technology, capacity, PTO area and COD, snapshotted monthly from the Master Control Area Generating Capability List.

Infrastructure data

Download data

Native record

event_time x resource_id

monthly snapshot publication cadence

Evidence

Observed market data

Published observations from the named source

Time basis

Point-in-time records

UTC · event_time

Overview

The OASIS `ATL_GEN_CAP_LST` report (version 4), one row per (monthly snapshot, resource_id). It is the registry that says what a resource IS: `caiso.resources` gives only the node a resource settles at, and this gives its name, owner, technology and capacity. `grid.plant_nodes` binds CAISO resources to EIA-860 plants through it. `gen_unit_name` is CAISO's name for the unit ("Bateria Del Sur" for `WESCAN_2_BDSBT1`), often not EIA's name for the plant. An aggregated resource lists its members as their own rows with `parent_resource_id` set, and the parent carries the aggregate's capacity, so summing every row counts an aggregate twice. `energy_source` is CAISO's fuel code: SUN, WIND, LESR (storage), HYBD (hybrid), WATER, URANIUM and so on. `pto_area` is the transmission owner's area (SDGE, SCE, PGAE, VEA); `baa_id` includes resources pseudo-tied or dynamically scheduled in from IID, LADWP and others. History starts 2023-07-01; OASIS returns no data for earlier months.

Query contract

Preserve one canonical row per (event_time, resource_id) before aggregating.

Analysis rules

Group only after preserving the declared grain: event_time, resource_id.

Schema20

Column

Type

event_timeDateTime64(6, 'UTC')

resource_idString

parent_resource_idNullable(String)

gen_unit_nameNullable(String)

classificationLowCardinality(Nullable(String))

qfLowCardinality(Nullable(String))

resource_agg_typeLowCardinality(Nullable(String))

resource_typeLowCardinality(Nullable(String))

net_dependable_capacity_mwNullable(Float64)

nameplate_capacity_mwNullable(Float64)

pto_areaLowCardinality(Nullable(String))

ownerNullable(String)

unit_typeLowCardinality(Nullable(String))

energy_sourceLowCardinality(Nullable(String))

zoneLowCardinality(Nullable(String))

codNullable(Date32)

river_systemLowCardinality(Nullable(String))

baa_idLowCardinality(Nullable(String))

udcLowCardinality(Nullable(String))

ingested_atDateTime64(6, 'UTC')

Sample data

event_time	resource_id	parent_resource_id	gen_unit_name	classification	qf	resource_agg_type	resource_type	net_dependable_capacity_mw	nameplate_capacity_mw	pto_area	owner	unit_type	energy_source	zone	cod	river_system	baa_id	udc	ingested_at
2026-08-01 00:00:00.000000	ZOND_6_UNIT	∅	ZOND WINDSYSTEMS INC.	Participating Unit	N	N	GEN	17.1	21.87	PGAE	Rooney Ranch Wind, LLC	WIND	WIND	NP15	1985-12-30	∅	CISO	PGAE	2026-09-29 02:16:49.754371
2026-08-01 00:00:00.000000	YUBACT_6_UNITA1	∅	Yuba City Energy Center (Calpine)	Participating Unit	N	N	GEN	47.16	49.9	PGAE	Gilroy Energy Center, LLC	COMBUSTION TURBINE	NATURAL GAS	NP15	2002-07-26	∅	CISO	PGAE	2026-09-29 02:16:49.754371
2026-08-01 00:00:00.000000	YUBACT_1_SUNSWT	∅	YUBA CITY COGEN	Participating Unit	Y	N	GEN	49.97	49	PGAE	Yuba City Cogeneration Partners, L.P.	COMBUSTION TURBINE	NATURAL GAS	NP15	1990-12-27	∅	CISO	PGAE	2026-09-29 02:16:49.754371
2026-08-01 00:00:00.000000	YELPIN_2_YP2SR3	∅	Yellow Pine 2 B PV	Participating Unit	N	N	GEN	65	65	SCE	Yellow Pine Solar Interconnect, LLC	PHOTO VOLTAIC	SUN	SP15	2024-06-27	∅	CISO	VEA	2026-09-29 02:16:49.754371
2026-08-01 00:00:00.000000	YELPIN_2_YP2SR2	∅	Yellow Pine 2 A PV	Participating Unit	N	N	GEN	60	60	SCE	Yellow Pine Solar Interconnect, LLC	PHOTO VOLTAIC	SUN	SP15	2024-06-14	∅	CISO	VEA	2026-09-29 02:16:49.754371
2026-08-01 00:00:00.000000	YELPIN_2_YP2SR1	∅	Yellow Pine 2	Participating Unit	N	N	GEN	125	125	SCE	Yellow Pine Solar Interconnect, LLC	PHOTO VOLTAIC	SUN	SP15	2023-07-26	∅	CISO	VEA	2026-09-29 02:16:49.754371
2026-08-01 00:00:00.000000	YELPIN_2_YP2BT3	∅	Yellow Pine 2 B BESS	Participating Unit	N	N	GEN	32	32	SCE	Yellow Pine Solar Interconnect, LLC	OTHER	LESR	SP15	2024-06-04	∅	CISO	VEA	2026-09-29 02:16:49.754371
2026-08-01 00:00:00.000000	YELPIN_2_YP2BT2	∅	Yellow Pine 2 A BESS	Participating Unit	N	N	GEN	53	53	SCE	Yellow Pine Solar Interconnect, LLC	OTHER	LESR	SP15	2024-05-24	∅	CISO	VEA	2026-09-29 02:16:49.754371
2026-08-01 00:00:00.000000	YELPIN_2_YP2BT1	∅	Yellow Pine 2 BESS	Participating Unit	N	N	GEN	65	65	SCE	Yellow Pine Solar Interconnect, LLC	OTHER	LESR	SP15	2023-07-26	∅	CISO	VEA	2026-09-29 02:16:49.754371
2026-08-01 00:00:00.000000	WSTWND_2_SBSBT3	∅	Sagebrush Solar 2 ESS 59	Participating Unit	N	N	GEN	59	59	SCE	Sagebrush ESS II, LLC	OTHER	LESR	SP15	2024-08-13	∅	CISO	SCE	2026-09-29 02:16:49.754371
2026-08-01 00:00:00.000000	WSTWND_2_SBSBT2	∅	Sagebrush Solar 2 ESS 40	Participating Unit	N	N	GEN	40	40	SCE	Sagebrush ESS II, LLC	OTHER	LESR	SP15	2024-09-16	∅	CISO	SCE	2026-09-29 02:16:49.754371
2026-08-01 00:00:00.000000	WSTWND_2_SBSBT1	∅	Sagebrush Solar 2	Participating Unit	N	N	GEN	80	80	SCE	Sagebrush ESS, LLC	OTHER	LESR	SP15	2023-05-23	∅	CISO	SCE	2026-09-29 02:16:49.754371
2026-08-01 00:00:00.000000	WSTWND_2_M90WD2	∅	Mojave 90	Participating Unit	N	N	GEN	64.82	64.9	SCE	Mojave 3/4/5, LLC	WIND	WIND	SP15	2020-06-02	∅	CISO	SCE	2026-09-29 02:16:49.754371
2026-08-01 00:00:00.000000	WSTWND_2_M89WD2	∅	Mojave 89 Wind	Participating Unit	N	N	GEN	58.3	82.7	SCE	Mojave 16/17/18 LLC	WIND	WIND	SP15	2023-05-25	∅	CISO	SCE	2026-09-29 02:16:49.754371
2026-08-01 00:00:00.000000	WSTWND_2_M89BT2	∅	Mojave 89 BESS 2B	Participating Unit	N	N	GEN	70.6	70.6	SCE	Mojave 16/17/18 LLC	OTHER	LESR	SP15	2023-05-25	∅	CISO	SCE	2026-09-29 02:16:49.754371
2026-08-01 00:00:00.000000	WSNR_5_TRCYDYN	∅	Central Valley Tracy	Participating Unit	N	N	TG	10	∅	PGAE	TRCYPGAE	HYDRO	WATER	NP15	2017-12-13	∅	BANC	PGAE	2026-09-29 02:16:49.754371
2026-08-01 00:00:00.000000	WSNR_2_TESLADYN	∅	Central Valley Tesla	Participating Unit	N	N	TG	10	∅	PGAE	TESLA230	HYDRO	WATER	NP15	2017-12-13	∅	BANC	PGAE	2026-09-29 02:16:49.754371
2026-08-01 00:00:00.000000	WSNR_2_CVPDYN	∅	Central Valley 1	Participating Unit	N	N	TG	10	∅	PGAE	CTW230	HYDRO	WATER	NP15	2017-07-26	∅	BANC	PGAE	2026-09-29 02:16:49.754371
2026-08-01 00:00:00.000000	WSENGY_1_UNIT 1	∅	Wheelabrator Shasta	Participating Unit	Y	N	GEN	50	50	PGAE	Shasta-Sustainable Resource Management Inc.	STEAM	BIOMASS	NP15	2017-12-01	∅	CISO	PGAE	2026-09-29 02:16:49.754371
2026-08-01 00:00:00.000000	WRGTSR_2_WSFSR1	∅	Wright Solar Freeman	Participating Unit	N	N	GEN	200	200	PGAE	Wright Solar Park LLC	PHOTO VOLTAIC	SUN	NP15	2019-12-31	∅	CISO	PGAE	2026-09-29 02:16:49.754371
2026-08-01 00:00:00.000000	WRGTSR_2_WSFBT1	∅	Wright Solar BESS	Participating Unit	N	N	GEN	80	80	PGAE	Stellar Wright BESS LLC	OTHER	LESR	NP15	∅	∅	CISO	PGAE	2026-09-29 02:16:49.754371
2026-08-01 00:00:00.000000	WOODWR_1_HYDRO	∅	Quinten Luallen	Participating Unit	N	N	GEN	7.3	7.3	PGAE	Friant Power Authority	HYDRO	WATER	NP15	2017-06-14	∅	CISO	PGAE	2026-09-29 02:16:49.754371
2026-08-01 00:00:00.000000	WOLFSK_1_UNITA1	∅	Wolfskill Energy Center	Participating Unit	N	N	GEN	48.68	49.9	PGAE	Gilroy Energy Center, LLC	COMBUSTION TURBINE	NATURAL GAS	NP15	2003-03-22	∅	CISO	PGAE	2026-09-29 02:16:49.754371
2026-08-01 00:00:00.000000	WNDSTR_2_WIND2	WNDSTR_2_WIND	Windstar Wind Farm	Non-Participating	N	Y	GEN	60	60	∅	Windstar Energy LLC	WIND	WIND	SP15	∅	∅	CISO	SCE	2026-09-29 02:16:49.754371
2026-08-01 00:00:00.000000	WNDSTR_2_WIND1	WNDSTR_2_WIND	Windstar Wind Farm	Non-Participating	N	Y	GEN	60	60	∅	Windstar Energy LLC	WIND	WIND	SP15	∅	∅	CISO	SCE	2026-09-29 02:16:49.754371

Coverage

3.4% complete1,090 gap days38 days with data

Show coverage history

Coverage: 3.4%Days with data: 38Gaps: 1,090

2026

2025

2024

2023

gaplessmore

Related infrastructure data

Related infrastructure data
Dataset	Description
CAISO Interconnection QueueCAISO · monthly snapshot	CAISO's public generation interconnection queue, combining active, completed, and withdrawn projects with the proposed point of interconnection, technology, requested capacity, status, and completion dates. Each posting is a snapshot: current totals must use one latest snapshot, and requested queue MW is not operating capacity, available transmission headroom, or evidence that a project will be built.
CAISO Price LocationsCAISO · slow-moving dimension, refreshed every 6 hours	Every CAISO location that carries a price, as three columns: location_id, name, and kind. 26,632 rows — node (26,048), interface (578), zone (6). This is the dimension the CAISO price, and where applicable constraint, tables join to, and it is the one place a location's type is decided: resolve "which hubs exist", "is this a zone or a node", or "give me the readable name for this id" here rather than inferring a type from a name prefix. For CAISO, name equals location_id (the pnode name). The same three columns exist for every market, so the equivalent question in another ISO is the same query against that ISO's table.
PNode Reference MapCAISO · reference (periodic snapshot)	CAISO pricing-node (PNode) reference map: pricing-node id, aggregate-node id, name, voltage, node type, and the effective-date window each definition is valid for. This is a dimension / reference table, not a time series — it is a slow-moving registry snapshotted periodically (a handful of vintages), so use it to resolve and label pricing nodes and their attributes rather than for time-based analysis. Join it to the CAISO LMP and shadow-price tables to give nodes human-readable names and group them. The official source is CAISO OASIS.
WEIM Area Price LocationsCAISO · slow-moving dimension, refreshed every 6 hours	The CAISO-priced locations that belong to each WEIM balancing area, keyed by ba: the area's energy load aggregation point (ELAP_<BA>-APND, kind 'aggregate', the area's own price) plus the interfaces and nodes CAISO names with the <BA>_ prefix. 622 locations across 25 areas. Join atg.weim_prices_rt on location_id.