search

catalyst-cooperative / pudl

The Public Utility Data Liberation Project provides analysis-ready energy system data to climate advocates, researchers, policymakers, and journalists.
https://catalyst.coop/pudl
MIT License
456 stars 106 forks source link

Create FERC Form 1 entity tables #196

Closed cmgosnell closed 5 years ago

cmgosnell commented 5 years ago

Currently the plants_ferc and utilities_ferc (which have foreign key relationships with the ferc1 data tables), are generated through the pudl_id mapping excel sheet. Once ferc plants have their own id's, they need to be stored in entity tables and the eia/ferc glue ingest needs to be untangled from this dependency.

cmgosnell commented 5 years ago

unfortunately, we've learned that the plant ids are really only useful in the steam table... so this is no longer really necessary.