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

Integrate boiler attributes from EIA 860 EnvrAssoc and EnvrEquip tables #2305

Closed jdangerx closed 1 year ago

jdangerx commented 1 year ago

This issue scopes out a subset of work identified in the issues #1189, #1162, #889.

EIA 860 Schedule 6 (Environmental Equipment and Environmental Association) reports data on the environmental quality control equipment, investments, regulatory standards and control strategies associated with particular boilers. Much of this information will need to be organized outside of our existing EIA860 data structure, as multiple pieces of control equipment may be associated with multiple boilers. More immediately, however, data associated with a boiler ID can be integrated into the existing harvesting process.

The following tables are associated 1:1 with boilers and should be incorporated into the existing boilers_eia860 and boilers_entity_eia objects:

The following tables have m:m associations with boilers and cannot be incorporated into the existing boilers_eia860 and boilers_entity_eia objects:

These associations will be addressed as part of next steps in #1162 .

e-belfer commented 1 year ago

All 1:1 boiler attribute tables have been merged in #2319. Additional data will be integrated in future steps of #1162. Closing this issue.