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

Query with the agent

Native record

one row per WEIM area and priced location

slow-moving dimension, refreshed every 6 hours publication 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

Query from your own tools

Use the guarded HTTP endpoint directly, or connect an MCP client and load the dataset contract with describe_data before calling query_data.

BPA MCP API reference

HTTP endpoint

POST /api/v1/datasets/weim_locations/query

Schema4

Column

Type

baLowCardinality(String)

location_idLowCardinality(String)

nameLowCardinality(String)

kindLowCardinality(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

No time-indexed data — coverage isn’t applicable to this dataset.

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.
BPA Anemometer TowersBPA · daily	BPA's anemometer towers with coordinates, elevation and sensor heights, active and retired.