Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Integrate EIA923 Energy Storage Operations Table #3463

Closed
4 of 5 tasks
zaneselvans opened this issue Mar 14, 2024 · 2 comments
Closed
4 of 5 tasks

Integrate EIA923 Energy Storage Operations Table #3463

zaneselvans opened this issue Mar 14, 2024 · 2 comments
Assignees
@aesharpe
Labels
eia923 Anything having to do with EIA Form 923 epic Any issue whose primary purpose is to organize other issues into a group. excel Issues involving data in Microsoft Excel spreadsheets gridlab Work related to open modeling input data integration funded/coordinated by GridLab new-data Requests for integration of new data.

Comments

@zaneselvans
Copy link
Member

zaneselvans commented Mar 14, 2024 •
edited by aesharpe
Loading

Design Considerations

  • Does the energy storage operations table have the same format as the other "generation and fuel" tables, or does it stand alone?
  • Should there be a qualifier / descriptor in the table name beyond e.g. core_eia923__monthly_energy_storage? Is it _operations? _generation_fuel?
  • The EIA923 energy storage tab begins appearing in 2014, but the corresponding EIA860 energy storage equipment tab only appears as of 2016. Early energy storage operations data seems only to refer to pumped storage / hydro facilities, so they may all be in the existing EIA860 generators data, but something to watch out for.

Tasks
Preview Give feedback
  1. Compile column maps and other required metadata for the EIA923 energy storage operations table (exists in 2014-2023 data) #3512
    eia923 gridlab new-data
    aesharpe
  2. Extract EIA923 energy storage operations into a raw_eia923__energy_storage asset #3513
    eia923 gridlab new-data
    aesharpe
  3. Transform raw extracted EIA923 energy storage attributes into a clean _core_eia923__energy_storage asset for harvesting. #3535
    eia923 gridlab new-data
    aesharpe
  4. Define a normalized core_eia923__energy_storage_??? table #3537
    eia923 gridlab new-data
    aesharpe
@zaneselvans zaneselvans added eia923 Anything having to do with EIA Form 923 new-data Requests for integration of new data. epic Any issue whose primary purpose is to organize other issues into a group. excel Issues involving data in Microsoft Excel spreadsheets gridlab Work related to open modeling input data integration funded/coordinated by GridLab labels Mar 14, 2024
@zaneselvans zaneselvans moved this from New to Backlog in Catalyst Megaproject Mar 14, 2024
@Nancy9ice
Copy link
Contributor

Hello,
I noticed the 3rd task for this has the status of 'In progress', can I take it up? Or is it already being worked on?

@aesharpe
Copy link
Member

Deprioritized creating denormalized output tables

@github-project-automation github-project-automation bot moved this from Backlog to Done in Catalyst Megaproject Jun 26, 2024
@aesharpe aesharpe mentioned this issue Dec 17, 2024
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@aesharpe aesharpe

Labels
eia923 Anything having to do with EIA Form 923 epic Any issue whose primary purpose is to organize other issues into a group. excel Issues involving data in Microsoft Excel spreadsheets gridlab Work related to open modeling input data integration funded/coordinated by GridLab new-data Requests for integration of new data.
Projects
Catalyst Megaproject
Archived in project
Milestone
No milestone
Development

No branches or pull requests
3 participants
@zaneselvans @aesharpe @Nancy9ice