Source code for pudl.metadata.resources.pudl

"""Definitions for the glue/crosswalk tables that connect data groups."""
from typing import Any, Dict

[docs]RESOURCE_METADATA: Dict[str, Dict[str, Any]] = { "plants_pudl": { "title": "PUDL Plants", "description": "Home table for PUDL assigned plant IDs. These IDs are manually generated each year when new FERC and EIA reporting is integrated, and any newly identified plants are added to the list with a new ID. Each ID maps to a power plant which is reported in at least one FERC or EIA data set. This table is read in from a spreadsheet stored in the PUDL repository: src/pudl/package_data/glue/mapping_eia923_ferc1.xlsx", "schema": { "fields": ["plant_id_pudl", "plant_name_pudl"], "primary_key": ["plant_id_pudl"], "foreign_key_rules": {"fields": [["plant_id_pudl"]]}, }, }, "utilities_pudl": { "title": "PUDL Utilities", "description": "Home table for PUDL assigned utility IDs. These IDs are manually generated each year when new FERC and EIA reporting is integrated, and any newly found utilities are added to the list with a new ID. Each ID maps to a power plant owning or operating entity which is reported in at least one FERC or EIA data set. This table is read in from a spreadsheet stored in the PUDL repository: src/pudl/package_data/glue/mapping_eia923_ferc1.xlsx", "schema": { "fields": ["utility_id_pudl", "utility_name_pudl"], "primary_key": ["utility_id_pudl"], "foreign_key_rules": {"fields": [["utility_id_pudl"]]}, }, }, "utility_plant_assn": { "schema": { "fields": ["utility_id_pudl", "plant_id_pudl"], "primary_key": ["utility_id_pudl", "plant_id_pudl"],
}, }, } """ PUDL-specifiic resource attributes by PUDL identifier (``resource.name``). Keys are in alphabetical order. See :func:`pudl.metadata.helpers.build_foreign_keys` for the expected format of ``foreign_key_rules``. """