cal-itp / data-infra

Cal-ITP data infrastructure
https://docs.calitp.org/data-infra
GNU Affero General Public License v3.0
48 stars 13 forks source link

Rename 2022 NTD Annual Reporting Models since they now include 2023 data #3523

Closed erikamov closed 4 days ago

erikamov commented 3 weeks ago

User story / feature request

As a Analyst, I want to see the NTD annual models renamed to reflect that the data contains more than a year.

Starting Nov 1st all data points started receiving data from 2022 and 2023 report years.

We also need to fix the failing tests and add report_year on mart Keys.

Acceptance Criteria

No failing tests for:

Models renamed: old_model new_model
2022__breakdowns
2022__breakdowns_by_agency
2022__capital_expenses_by_capital_use
2022__capital_expenses_by_mode
2022__capital_expenses_for_existing_service
2022__capital_expenses_for_expansion_of_service
2022__employees_by_agency
2022__employees_by_mode
2022__employees_by_mode_and_employee_type
2022__fuel_and_energy
2022__fuel_and_energy_by_agency
2022__funding_sources_by_expense_type
2022__funding_sources_directly_generated
2022__funding_sources_federal
2022__funding_sources_local
2022__funding_sources_state
2022__funding_sources_taxes_levied_by_agency
2022__maintenance_facilities
2022__maintenance_facilities_by_agency
2022__metrics
2022__operating_expenses_by_function
2022__operating_expenses_by_function_and_agency
2022__operating_expenses_by_type
2022__operating_expenses_by_type_and_agency
2022__service_by_agency
2022__service_by_mode
2022__service_by_mode_and_time_period
2022__stations_and_facilities_by_agency_and_facility_type
2022__stations_by_mode_and_age
2022__track_and_roadway_by_agency
2022__track_and_roadway_by_mode
2022__track_and_roadway_guideway_age_distribution
2022__vehicles_age_distribution
2022__vehicles_type_count_by_agency
-----
stg_ntd_annual_data2022breakdowns
stg_ntd_annual_data2022breakdowns_by_agency
stg_ntd_annual_data2022capital_expenses_by_capital_use
stg_ntd_annual_data2022capital_expenses_by_mode
stg_ntd_annual_data2022capital_expenses_for_existing_service
stg_ntd_annual_data2022capital_expenses_for_expansion_of_service
stg_ntd_annual_data2022employees_by_agency
stg_ntd_annual_data2022employees_by_mode
stg_ntd_annual_data2022employees_by_mode_and_employee_type
stg_ntd_annual_data2022fuel_and_energy
stg_ntd_annual_data2022fuel_and_energy_by_agency
stg_ntd_annual_data2022funding_sources_by_expense_type
stg_ntd_annual_data2022funding_sources_directly_generated
stg_ntd_annual_data2022funding_sources_federal
stg_ntd_annual_data2022funding_sources_local
stg_ntd_annual_data2022funding_sources_state
stg_ntd_annual_data2022funding_sources_taxes_levied_by_agency
stg_ntd_annual_data2022maintenance_facilities
stg_ntd_annual_data2022maintenance_facilities_by_agency
stg_ntd_annual_data2022metrics
stg_ntd_annual_data2022operating_expenses_by_function
stg_ntd_annual_data2022operating_expenses_by_function_and_agency
stg_ntd_annual_data2022operating_expenses_by_type
stg_ntd_annual_data2022operating_expenses_by_type_and_agency
stg_ntd_annual_data2022service_by_agency
stg_ntd_annual_data2022service_by_mode
stg_ntd_annual_data2022service_by_mode_and_time_period
stg_ntd_annual_data2022stations_and_facilities_by_agency_and_facility_type
stg_ntd_annual_data2022stations_by_mode_and_age
stg_ntd_annual_data2022track_and_roadway_by_agency
stg_ntd_annual_data2022track_and_roadway_by_mode
stg_ntd_annual_data2022track_and_roadway_guideway_age_distribution
stg_ntd_annual_data2022vehicles_age_distribution
stg_ntd_annual_data2022vehicles_type_count_by_agency

Notes

The models with 2022 name will need to be Dropped after the new models were successfully created.