bdit_data-sources
bdit_data-sources copied to clipboard
`wys.raw_data` `speed_count_uid` is not being assigned correctly
The assignment of wys.raw_data
column speed_count_uid
within function wys.aggregate_speed_counts_one_hour_5kph
is incorrect as it does not consider speed_uid. Will need to add a join to wys.speed_bins_old
within wys.aggregate_speed_counts_one_hour_5kph
UPDATE query.
Will also need to update all speed_count_uid
of table wys.raw_data
.