Gabe Wolofsky

I0617 rescu sensors eval

2

## What this pull request accomplishes: - Identify RESCU detectors to repair this year during annual repair blitz. - SQL to identify network wide outages and individual sensor outages. ##...

Automate data quality checks for VDS schema

3

Build on work done in #605, #626 to automate data quality checks for old `rescu` schema into `vds` schema. New schema contains more disaggregate RESCU data which allows us to...

Monitor special TTC-Miovision configurations

1

Special vehicle approach boxes were drawn at 3 intersections (Lakeshore/Spadina, Yonge/St Clair, Cherry/Eastern) to monitor streetcar ROW intrusion. We will need to monitor how the data shows up and possibly...

## What this pull request accomplishes: - Adds new `vds.centreline_vds` table: - I also manually assigned a bunch of centreline_ids using QGIS as part of this PR, so we now...

953 reduce notification frequency to weekly

2

## What this pull request accomplishes: - changes two daily "_check" DAGs to weekly. - adjust the schedule interval, external task sensors, and the sql params - removed a non...

## What this pull request accomplishes: - The addition of leg to anomalous_ranges broke the open_issues view + data check. - Other minor improvements include: fixing the `last_week_volume` to only...

## What this pull request accomplishes: - add a weekly notification about instances where miovision volumes have doubled week over week - `miovision_doubling_insert` function logs instances of doubling in a...

Identify when Miovision volume are unusually high

2

Last week I discovered [a case](https://bditto.slack.com/archives/C021YMH9BK5/p1715369265523089?thread_ts=1715358623.451909&cid=C021YMH9BK5) where bike volumes had gone up more than 4x in recent weeks and I wanted to investigate ways of identifying this automagically. 

:meow_pinghiss: - ecocounter_check.check_site_outages - miovision_check.check_intersection_outages