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

Merge respondent_id_ferc714 with service territory GeoDataFrame #621

Closed zaneselvans closed 4 years ago

zaneselvans commented 4 years ago

Given the huge master GeoDataFrame which associates balancing authorities, utilities, and counties to each other, we should be able to merge it the respondent_id_ferc714 dataframe based on the eia_code found in that table, either on the balancing_authority_id_eia or utility_id_eia depending on whether eia_code_type yielding a collection of geometries which is a mix of balancing authorities and individual utilities, corresponding to the "planning areas" which are reporting their hourly demand in FERC 714. This will be the first complete draft of our own historical demand area geometries.

Then we can make some maps and aggregate some demand and see what the results look like and where the weirdness is hiding.

zaneselvans commented 4 years ago

This was done incidentally as part of the other georeferencing work.