Gabe Wolofsky

Update Contributing.md file with new DAG standards

2

> I think it might be beneficial to start packing this block of code (updating Python path, setting DAG's default args, getting the doc_md, etc.) which is shared in almost...

## What this pull request accomplishes: Some Miovision Open Data tables ready for discussion/comments. A 15 minute view, based off of `volumes_15min_mvt` (TMC table), but extended to have ATR columns...

Miovision: discrepencies between volumes_15min_mvt and unacceptable_gaps

1

Here are 12 dates with records that should be nulls but are not. You were lucky to pick one of them at random! I will create a new issue for...

Need to monitor intersection_movements for missing high volume movements

3

> None of the new intersections have volumes for classification_uid 10 (bike approaches). > We'll need to confirm whether this is an algorithm change or a configuration issue. > >...

Create Miovision open data views. Meeting notes here: https://www.notion.so/bditto/Miovision-Open-Data-Schema-8651aa6f9c0e4aba95442b5d87c59c77#6a24b9f8edf24fb69d951a85de47327f

## What this pull request accomplishes: - Added a strikethrough to WorkVans in the readme. ## Issue(s) this solves: - #875 ## What, in particular, needs to reviewed: ## What...

## What this pull request accomplishes: - Update vz_google_sheets DAG: replace the `get_list_of_years` task with one that reads from the airflow spreadsheets variable and also filters specific years. By default...

Miovision: Should we filter unacceptable_gaps from volumes_15min_mvt via view instead of during insert?

3

Pros: - aggregate tables and unacceptable_gaps could not get out of sync! (#868) - enables the 15min look behind over midnight in find_gaps which is otherwise problematic to reflect in...

868 miovision find gaps bugs

2

## What this pull request accomplishes: fixes undesired behaviours in find_gaps: 1. Remove the 15 minutes lookback (23:45 to 00:00 + 1 day) previously used to identify small (10 to...

## What this pull request accomplishes: - add leg to `miovision_api.anomalous_range` table - add leg to `miovision_api.identify_zero_volumes` function (identify legs with zero volume) - uses `grouping sets` to simplify the...