Integrates withdrawn and operational projects for GS and LBNL in the data warehouse. The iso_projects_*_format tables still only contain active projects.
Creates a change log of projects in the ISO queue called iso_projects_change_log. There is a record for every time a project's status changes. The effective_date column is the date the current status started, and the end_date is the date the project status ended. end_date is null if the record contains the current status for the project.
Create two additional data mart tables called iso_regions_change_log and iso_counties_change_log, which contain a number of projects and total capacity for a given geography, status and resource class over time.
This PR:
iso_projects_*_formattables still only contain active projects.iso_projects_change_log. There is a record for every time a project's status changes. Theeffective_datecolumn is the date the current status started, and theend_dateis the date the project status ended.end_dateis null if the record contains the current status for the project.iso_regions_change_logandiso_counties_change_log, which contain a number of projects and total capacity for a given geography, status and resource class over time.