Issue overview
Historically, the dGen model queries a SQL database to return relevant load growth projections. The database version is linked with a look-up for the county_id variable based on the nerc_abbr variable. The county_id variable is used by the dGen model to then merge the load growth data onto the agent dataframe used in the model.
Work has been accomplished to make the SQL database tables available as a local CSV file. However, work will need to be done in the dGen code base to connect the relevant county_id, or other merge key, to replicate the processes from the SQL database
Issue overview
Historically, the dGen model queries a SQL database to return relevant load growth projections. The database version is linked with a look-up for the
county_idvariable based on thenerc_abbrvariable. Thecounty_idvariable is used by the dGen model to then merge the load growth data onto the agent dataframe used in the model.Work has been accomplished to make the SQL database tables available as a local CSV file. However, work will need to be done in the dGen code base to connect the relevant
county_id, or other merge key, to replicate the processes from the SQL database