Congestion Network 2.0: Create tables and function for aggregated data

CityofToronto / bdit_congestion

Determining most congested streets and days in Toronto

https://github.com/orgs/CityofToronto/teams/bigdatainnovationteam

GNU General Public License v3.0

0 stars 0 forks source link

Congestion Network 2.0: Create tables and function for aggregated data #61

Open chmnata opened 1 year ago

chmnata commented 1 year ago

Tables:

[x] network_segments_daily
[x] network_segments_weekly
[x] network_segments_monthly

Functions: Aggregation:

[x] generate_network_daily
[x] generate_network_weekly
[x] generate_network_monthly

Maintenance:

[x] create_yearly_daily_table
[x] create_yearly_monthly_table

chmnata commented 1 year ago

Originally summed up sample_size as the "confidence" column, but I feel like the number of 5 min bin used for aggregation would be more useful. However, we could use sample_size as a filter for things like citywide tti aggregation to filter out observations that is only based on 1 vehicle or sth :meow_thinking: