bdit_data-sources
bdit_data-sources copied to clipboard
CityofToronto
Data sources used by the Big Data Innovation Team
The format of intersection names is applied inconsistently across intersections within `miovision_api.intersections.intersection_name`. My proposal: update `intersection_name` to reflect the original naming convention: [E / W street] / [N / S...
e.g. https://github.com/CityofToronto/bdit_data-sources/blob/master/vision_zero/schools.py#L143
from 2018-08-31: Shep Sheppard to Pharmacy (and reverse) Shep Sheppard to Settlers (and reverse) I've set them to `Obsolete` on the Blip server but it isn't accepting an end date.
Start date should be when that detector was installed at that location. Will provide a query to identify incorrect rows.
## What this pull request accomplishes: Currently, `gis.text_to_centreline()` fails if the input text is capitalized, e.g.: ``` SELECT * FROM gis.text_to_centreline(111,'BLOOR ST W', 'BETWEEN SHAW ST AND OSSINGTON AVE', NULL);...
Miovision has a contract with Metrolinx to provide TMC volumes at Finch Avenue West and Jane Street (there's a few other locations listed by the API, but these are only...
There are 3 tables involved in updating the Community Safety Zone layer. 1. the master spreadsheet that comes by email has to be imported manually into the `toadd` table 2....
Arising from https://github.com/CityofToronto/bdit_data_requests/issues/39, did some digging around the newer HERE data and found some issues (not sure if this is something that is a known issue, or perhaps I'm just...
For the daily `check_miovision` Airflow process, it would make sense in light of #410 to have a check like: ```sql WITH vol_1min AS ( SELECT intersection_uid, classification_uid, leg, movement_uid, SUM(volume)...
Metadata
Owner
Metadata
Data sources used by the Big Data Innovation Team