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.

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

Deprecate various columns in the Transit Database Mart Tables #3525

Open
evansiroky opened this issue Nov 4, 2024 · 0 comments
Open

Deprecate various columns in the Transit Database Mart Tables #3525

evansiroky opened this issue Nov 4, 2024 · 0 comments

Comments

@evansiroky
Copy link
Member

evansiroky commented Nov 4, 2024

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 #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 #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.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant