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.

Sign up for GitHub

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

Jump to bottom

Generalized MOVE Summary Stats Transform-nation #810

Open
radumas opened this issue Dec 27, 2023 · 3 comments · May be fixed by #828
Open

Generalized MOVE Summary Stats Transform-nation #810

radumas opened this issue Dec 27, 2023 · 3 comments · May be fixed by #828
Assignees
@scann0n
Labels
Volume

Comments

@radumas
Copy link
Member

radumas commented Dec 27, 2023 •
edited by scann0n

We did a request that required:

  • peak hour counts from TMCs and speed volumes
  • mean, 15th, 50th, 85th and 95th percentile speeds
  • Daily traffic volumes (from speed volumes)

Now can we generalize this to make future requests (and work) easier?

I was thinking a VIEW, but it might be more appropriate to be calculating summary stats on a function basis, which should maybe go into the MOVE count loading and then get replicated over to us.

cc: @peter-lyons @mkewins
@radumas radumas added the Volume label Dec 27, 2023
@mkewins
Copy link

mkewins commented Jan 2, 2024

Yes please! This would be fantastic. We've had fairly extensive conversations with David and Jesse about Peak Hour calculations in the past.

A couple notes:

@scann0n
Copy link
Collaborator

scann0n commented Jan 2, 2024

I defined peak hours based on that code! And I got a match with MOVE.

@scann0n scann0n changed the title Generalized Traffic Count Peak Hour Transform-nation Generalized MOVE Summary Stats Transform-nation Jan 10, 2024
scann0n added a commit that referenced this issue Jan 10, 2024
@scann0n
#810 move stats wip
923e031
scann0n added a commit that referenced this issue Jan 12, 2024
@scann0n
#810 MOVE match sqls from approved request
80f6234
@scann0n scann0n linked a pull request Jan 12, 2024 that will close this issue
Open
scann0n added a commit that referenced this issue Jan 23, 2024
@scann0n
#810 added a note specifiying the Speed Percentile Report summary
0427ad7
@radumas
Copy link
Member Author

radumas commented Apr 22, 2024

The percentile calculations in MOVE are documented here

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@scann0n scann0n

Labels
Volume
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

I810 move match CityofToronto/bdit_data-sources
3 participants
@mkewins @radumas @scann0n