WEIM Area Price Locations

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.

Infrastructure data BPA market

Open in Data Ask the agent

One row per: one row per WEIM area and priced location; Slow-moving dimension, refreshed every 6 hours cadence
Evidence: Reference data; Stable context used to interpret other datasets
Time basis: Point-in-time records; UTC · static reference

Overview

622 locations across 25 areas. Join atg.weim_prices_rt on location_id.

Query contract: Treat (ba, location_id) as the row identity; a current snapshot, not a history.
Analysis rules: Filter ba to your scope's code with a direct WHERE; search_data returns the allowed value. One ba per query keeps a region's rows from mixing with another's.The area's own price is its kind = 'aggregate' row (ELAP_<BA>-APND).
Interpretation: Only the ELAP and the locations CAISO names with the area's prefix are here. The area's full nodal set is priced in CAISO's own tables, which this scope cannot read.This table is a materialized MergeTree whose refresh has already collapsed source revisions. Do not add FINAL and do not re-apply argMax over ingested_at.

Access

Download: Query it in SQL, download it, or read it with an API key. Download data
MCP: Connect an MCP client and load the contract with describe_data before calling query_data.BPA MCP API reference
HTTP endpoint: POST /api/v1/datasets/weim_locations/query
Full history: Delivered to Snowflake, Databricks or your own storage on a schedule by Data services.
More coverage

Schema

4 columns

Column	Type
`ba`	`LowCardinality(String)`
`location_id`	`LowCardinality(String)`
`name`	`LowCardinality(String)`
`kind`	`LowCardinality(String)`

Sample data

ba	location_id	name	kind
AVA	AVA_AVA.AVRN-APND	AVA_AVA.AVRN-APND	interface
AVA	AVA_AVA.BPAT-APND	AVA_AVA.BPAT-APND	interface
AVA	AVA_AVA.COLSTRIP-APND	AVA_AVA.COLSTRIP-APND	interface
AVA	AVA_AVAT.NWMT-APND	AVA_AVAT.NWMT-APND	interface
AVA	AVA_COYSPR2-APND	AVA_COYSPR2-APND	interface
AVA	AVA_DRYCREEK-APND	AVA_DRYCREEK-APND	node
AVA	AVA_LOLO-APND	AVA_LOLO-APND	interface
AVA	AVA_MAINCANALGEN-APND	AVA_MAINCANALGEN-APND	interface
AVA	AVA_MALIN500-APND	AVA_MALIN500-APND	interface
AVA	AVA_MIDC.AV-APND	AVA_MIDC.AV-APND	interface
AVA	AVA_MIDCREMOTE-APND	AVA_MIDCREMOTE-APND	interface
AVA	AVA_POPD-APND	AVA_POPD-APND	interface
AVA	AVA_SUMMERFALLGEN-APND	AVA_SUMMERFALLGEN-APND	node
AVA	AVA_WALLAWALLA-APND	AVA_WALLAWALLA-APND	interface
AVA	ELAP_AVA-APND	ELAP_AVA-APND	aggregate
AVRN	AVRN_AVA.AVRN-APND	AVRN_AVA.AVRN-APND	interface
AVRN	AVRN_AVA.BPAT-APND	AVRN_AVA.BPAT-APND	interface
AVRN	AVRN_AVRN.PACW-APND	AVRN_AVRN.PACW-APND	interface
AVRN	AVRN_AVRN.PGE-APND	AVRN_AVRN.PGE-APND	interface
AVRN	AVRN_AVRN.SCL-APND	AVRN_AVRN.SCL-APND	interface
AVRN	AVRN_BPAT.AVRN-APND	AVRN_BPAT.AVRN-APND	interface
AVRN	AVRN_KFALLSGEN.AVRN-APND	AVRN_KFALLSGEN.AVRN-APND	interface
AVRN	AVRN_KFALLSGENAVRN-APND	AVRN_KFALLSGENAVRN-APND	interface
AVRN	AVRN_MSS_COLUMB-APND	AVRN_MSS_COLUMB-APND	interface
AVRN	AVRN_MSS_KLICK-APND	AVRN_MSS_KLICK-APND	interface

Coverage

This dataset has no time index, so it has no daily coverage.

Related 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.
Generating Capability ListCAISO · monthly snapshot	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. 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.
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.