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

Deprecate various columns in the Transit Database Mart Tables #3525

Open evansiroky opened 2 weeks ago

evansiroky commented 2 weeks ago

Describe the bug

Some columns are not named as "deprecated" when they should be. They are as follows:

Table Column Alternative Use
dim_organizations roles No longer maintained
dim_organizations itp_id An artifact from previous iterations
dim_organizations caltrans_district Caltrans Districts are maintained in the "County Geographies" table. To get the Caltrans District for an organization you'd join with bridge_organizations_x_headquarters_county_geography and also dim_county_geography.
dim_organizations reporting category This used to be used to calculate which agencies appeared in our default list. This was changed to a different formula in https://github.com/cal-itp/data-infra/pull/2675.
dim_organizations gtfs_static_status This complex Airtable formula uses outdated info from the services table. See the GTFS Schedule Adoption question for example query.
dim_organizations gtfs_realtime_status This complex Airtable formula uses outdated info from the services table. See the GTFS-RT Coverage dashboard instead for example queries to calculate.
dim_services service_type The service type has been split up into multiple areas. There is now the dim_services.fixed_route column and paratransit data is pending update work in https://github.com/cal-itp/data-infra/issues/3431.
dim_services mode Mode information is available via the bridge_services_x_modes table to the dim_modes table.
dim_services operating counties Operating County info is available from the bridge_services_x_operating_county_geographies table.
dim_services gtfs_schedule_status No longer maintained.
dim_services gtfs_schedule_quality No longer maintained.
dim_gtfs_service_data category This field has been deprecated in favor of the field "Customer Facing" and a combo of gtfs_datasets.regional_feed_type.