data ware house optimization for main query types

[ZhenyuZhu-Caltrans]

Duplicate the final data sets and optimize each data set toward major query types:

• [ ] query that aggregate data over geographic domain: District, Route, County
• [ ] query that aggregate data over time domain: Year, Month, Day, Hour, Minute
• [ ] query that aggregate data over geographic domain: geofencing .

[pingpingxiu-DOT-ca-gov]

@pingpingxiu-DOT-ca-gov

[jkarpen]

This is lower priority than the pipeline feature improvement tasks so keeping in the backlog for now.