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

Welcome new count data! #1109

Open
2 of 6 tasks
radumas opened this issue Dec 5, 2024 · 2 comments
Open
2 of 6 tasks

Welcome new count data! #1109

radumas opened this issue Dec 5, 2024 · 2 comments
Assignees
Labels
MOVE For stats linked to MOVE Volume

Comments

@radumas
Copy link
Member

radumas commented Dec 5, 2024

Speed Volume Classification counts and Turning Movement Counts are being replicated into our database in a new, more streamlined format. While the full documentation won't be ready immediately here are some things we can do to make it easier for the unit to understand the data:

  • link to the OpenData documentation pages when they go live
  • create a new schema for volume data
  • (rename the old one?)
  • purge volumes/short_term_counting_program/move_match, now redundant
  • identify what documentation needs to change/can be deleted in the short-term
  • Identify which useful views are still useful and should get updated
@gabrielwol
Copy link
Collaborator

gabrielwol commented Dec 5, 2024

Created an traffic_new schema for now and linked to open data (qa) documentation.

@gabrielwol
Copy link
Collaborator

Update:

  • traffic now contains up to date SVC and TMC tables being replicated from MOVE.
  • traffic_archive contains the previously replicated MOVE tables and dependent views.
  • traffic_flow_archive contains other miscellaneous tables copied from Flow.
    Select permissions for bdit_humans will remain on all three schemas for now until more thorough documentation/training is available.

@gabrielwol gabrielwol added the MOVE For stats linked to MOVE label Dec 16, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
MOVE For stats linked to MOVE Volume
Projects
None yet
Development

No branches or pull requests

3 participants