Gabe Wolofsky

## What this pull request accomplishes: - Creates a new DAG (`replicator_table_check`) to monitor the MOVE -> bigdata replication process - This will help notify us if the list of...

Add a notification to bigdata replicator DAG which identifies discrepancies between move_staging updated tables and airflow *_tables variables.

General Improvement Idea 3: add the classification table to `traffic` (and maybe do some more QC) _Originally posted by @scann0n in https://github.com/CityofToronto/bdit_volumes/pull/81#discussion_r1553971771_

Eco counter dagify

1

## What this pull request accomplishes: - Builds on Nate's ecocounter code for a daily airflow DAG. - Automatically inserts new sites/channels (marked as `validated = False`) and notifies in...

## What this pull request accomplishes: - adds `miovision_api.open_issues`, a view which references `anomalous_ranges` in a format that will be easier to share with outside parties (adds intersection / classification...

Create a RESCU to centreline equivalency table

1

> General Improvement Idea 4: make a RESCU to centreline equivalency table (consider expanding this to include other VDS types) https://github.com/CityofToronto/bdit_volumes/pull/81#discussion_r1553976225

`miovision_centreline` update instructions

1

Add instructions to update the miovision to centreline table when we add new intersections to: https://github.com/CityofToronto/bdit_data-sources/blob/master/volumes/miovision/update_intersections/Readme.md

## What this pull request accomplishes: - A small new DAG to pull Miovision Alerts into the database. Will be useful for communicating issues to Miovision - we can be...

Investigate new Smartmicro sensors on highways

2

Over the last year, 13 out of commission RESCU sensors have been replaced with Smartmicro sensors. Investigate and add to `vds.detector_inventory` table. ```SELECT DISTINCT ON (vds_id) * FROM vds.vdsconfig WHERE...

## What this pull request accomplishes: - Small changes to accommodate new smartmicro sensors on highways into `vds.detector_inventory` table. - Also included a few nondescript smartmicro sensors added in line...