Gabe Wolofsky

628 make text to centreline case insensitive

1

## What this pull request accomplishes: 3 modified and 1 new function to make `text_to_centreline` case insensitive. - new function: `custom_case`: new function to selectively capitalize/lowercase certain words - `gis._clean_bylaws_text`:...

The link for how to generate geometries for HERE requests [here](https://github.com/CityofToronto/bdit_data-sources/blob/master/here/here_aggregation.md#geometry) is broken. This was the link: https://github.com/Toronto-Big-Data-Innovation-Team/bdit_data_requests/tree/master#how-to-generate-geometries-for-requests

## What this pull request accomplishes: - Delete dags/traffic_transfer.py, dags/collisions_replicator_transfer.py and all the SQL functions / tables they maintained. - Fix one view that's not broken but had name inconsistent...

This is to allow Chris to mark them as logged. It will be less confusing to change the view into a table than to have both.

https://github.com/CityofToronto/bdit_data-sources/blob/39e425891405b75e5cf992a8af633bce9cc23304/dags/gcc_layers_pull.py#L37-L41

Miovision Aggregation Improvements (ATR view, intersection_movements AFTER INSERT trigger, unacceptable_gaps)

1

## What this pull request accomplishes: 1. Remove `miovision_api.volumes_15min` (table) in place of view (`volumes_15min_atr_filtered`). Reduces duplicate storage (~75GB) and complexity in aggregation. 2. Add an `AFTER INSERT` trigger to...

Note: travel times are Wifi based, sniffing frequency as low as 30s.

Develop schema to store Spectrum manual counts and resulting factors for scaling Ecocounter counts. - include table detailing sensitivity levels by date - Builds off work in [data_collection_automation/ecocounter_validation_counts](https://github.com/Toronto-Big-Data-Innovation-Team/data_collection_automation/tree/main/ecocounter_validation_counts).