Idea: Source-agnostic TMC and ATR views

[Nate-Wessel]

This is bubbling up from some recent data requests where people are basically wanting ALL THE COUNTS, whether TMC or ATR, and it would be nice to offer them not only the short-term TMC + ATR counts, but also the equivalent from Miovision, or perhaps even RESCU without turning the request into a sort of monster that needs to reference a dozen different tables with different structures and query logics, specific to each data sources and to the request itself.

So I'm wondering if it could be possible to define some sort of view to represent "TMCs" and/or "ATRs", in an abstract sense, where the different data sources all flow/transform into a single representation. And then we can just ask for "all the TMCs in area X between Y and Z" and get back a combo of miovision and short-term counts. Or they could ask for "all the ATRS... etc" and get back a combination of short-term ATRS, transformed short-term TMCs, and Miovision in ATR format.

The formats would be the same but of course the sources should still be identified so that we can flag any necessary caveats etc that are specific to that source.

[Nate-Wessel]

@scann0n thoughts?
I'm thinking in particular of

• https://github.com/Toronto-Big-Data-Innovation-Team/bdit_data_requests/issues/619

but also

• https://github.com/Toronto-Big-Data-Innovation-Team/bdit_data_requests/issues/616
• https://github.com/Toronto-Big-Data-Innovation-Team/bdit_data_requests/issues/615