bdit_data-sources icon indicating copy to clipboard operation
bdit_data-sources copied to clipboard

`wys.raw_data` `speed_count_uid` is not being assigned correctly

Open gabrielwol opened this issue 1 year ago • 0 comments

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.

gabrielwol avatar Oct 06 '23 20:10 gabrielwol