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
471 stars 108 forks source link

Import f1_fuel data into PUDL database #27

Closed zaneselvans closed 7 years ago

zaneselvans commented 7 years ago

Get at least the f1_fuel data automatically flowing into the PUDL database when init_db() is run. This will require cleaning up any data fields which are freeform strings (fuel, fuel_unit), deciding which records are so bad that they can't be imported, and ensuring that the necessary foreign key tables are consistent with the actual contents of the f1_fuel table.

zaneselvans commented 7 years ago

This is now working, but only for the year 2015 -- we need the glue tables to be updated with relationships between plants and utilities for the older years before we can pull more years worth of information into PUDL. See Issue #26 for details.