Generalized MOVE Summary Stats Transform-nation

[radumas]

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

[mkewins]

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:

• Here is our Peak Hour calculation for the TMC Summary Report, or see the human-readable description; is it different from what you defined?
• There's been some discussion with Data Collection around changing the definitions of Peak Hours to accommodate continuous data, not just the legacy 8-hour Routine vs Ped hours; did you consider this?

[scann0n]

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

[radumas]

The percentile calculations in MOVE are documented here