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

Define DB Table & Ingest function for f1_accumdepr_prvsn #48

Closed zaneselvans closed 7 years ago

zaneselvans commented 7 years ago

Alongside the f1_plant_in_srvce table which describes the balances and changes in the electric plant in service, we need to ingest information about utility-wide depreciation, which comes from p. 219 of FERC Form 1, and is stored in table f1_accumdepr_prvsn. We need to define a PUDL DB table for this data, and write an ingest function. It appears similar in structure to f1_plant_in_srvce, which means we'll need to do a line number -> meaningful description dictionary/data table too, and hope that they don't change from year to year.

swinter2011 commented 7 years ago

I can get started with the dictionary!