Natalie

Seems like the below two DAGs have been deleted and are no longer in the branch. I will rm them in the dag folder on the ec2 as well. bt_read_history.py...

For function `reader_status_history`, there is a join to a `detectors_history_final` table which was not documented in the readme. There are also 5 versions of it in the schema currently. The...

List of modified things: SQL - Functions: - broken readers: simplified, need to know which version of `detectors_history_corrected` should be used - insert report date: simplified - reader locations dt...

Looking to move the `detectors_history_*` to bluetooth schema, `mohan.detectors_history_corrected` is the corrected version, however there are some null values on several columns. I will dig into how to populate those....

Working on the new segments tables and adding the missing columns: segment_name , bluetooth, wifi, duplicate, reverse, end_street For bluetooth and wifi, according to https://github.com/CityofToronto/bdit_data-sources/blob/e98182d30de5511a2a4c246e4771f14c937c6b0f/bluetooth/sql/create_tables/segments.sql seems like bluetooth was assigned...

In bluetooth.routes_temp, there are 61 routes out of 402 with no data in `bluetooth.aggr_5min` and `bluetooth.observations`.  But it does seems like some routes with data do have coverage on...

Checking the distinct status in reader_history table, `routepoint name` does not sounds like a status type (?), `added` is also ???. I guess technically according to this issue https://github.com/CityofToronto/bdit_data-sources/issues/196, this...

FYI, these are the content of the centreline intersection layer from GCC view INT_ID = INTERSECTION_ID (Unique id of the intersection) ELEV_ID = ELEVATION_ID (Unique id of the elevation) INTERSEC5...

There are a couple of functions under `wys.aggregate_speed_counts_one_hour_5kph()`, one without param, one with `_mon` and one with `_start_date` and `_end_date`. I believe only `wys.aggregate_speed_counts_one_hour_5kph()` is used in the wys_api.py, can...

Why without the updating raw_data part?