Baja California (CENACE) Price Locations

Every Baja California (CENACE) location that carries a price, as three columns: location_id, name, and kind.

Infrastructure data

Download data

Native record

one row per priced location and kind

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

4 rows — zone (4). This is the dimension the Baja California (CENACE) 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 Baja California, location_id is CENACE's load zone (TIJUANA, MEXICALI, ENSENADA, SANLUIS) and joins cenace.zonal_prices.load_zone; name is the city it is named for. CENACE prices Baja California by load zone only; there are no nodes or hubs in this dimension. The same three columns exist for every market, so the equivalent question in another ISO is the same query against that ISO's table.

Query contract

Treat (location_id, kind) as the row identity. This is a current dimension snapshot, not a history: it describes the locations that exist now and carries no validity dates.

Analysis rules

Counting rows by kind describes the market's current location inventory. It does not describe how many locations were priced on some past date.
Join fact tables on location_id, and add kind to the join when the fact table also carries kind — the pair, not the id alone, is the identity.

Interpretation

A location existing here does not mean it has a price in any particular interval; check the price table for that.
kind is a classification of the priced object, not of the physical equipment behind it, and carries no capacity, voltage, or geography. Location geography lives in grid.entities.

Schema3

Column

Type

location_idLowCardinality(String)

nameLowCardinality(String)

kindLowCardinality(String)

Sample data

location_id	name	kind
ENSENADA	Ensenada	zone
MEXICALI	Mexicali	zone
SANLUIS	San Luis Rio Colorado	zone
TIJUANA	Tijuana	zone

Coverage

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

Related infrastructure data

Related infrastructure data
Dataset	Description
Baja Grid Footprint (OpenStreetMap)OpenStreetMap · weekly snapshot	The administrative boundaries that make up the Baja California control area's footprint: Baja California and San Luis Rio Colorado, Sonora.
Baja Power Plants (OpenStreetMap)OpenStreetMap · weekly snapshot	Power plants mapped in OpenStreetMap across Baja California and San Luis Rio Colorado (gas, geothermal, wind, solar, oil) with rated output and operator.
Baja Substations (OpenStreetMap)OpenStreetMap · weekly snapshot	Substations mapped in OpenStreetMap across Baja California and San Luis Rio Colorado, with operator, type and voltage where tagged.
Baja Transmission Lines (OpenStreetMap)OpenStreetMap · weekly snapshot	Transmission lines mapped in OpenStreetMap across Baja California and San Luis Rio Colorado, 69 to 400 kV, with voltage, circuits, operator and route.