bdit_data-sources
bdit_data-sources copied to clipboard
Data sources used by the Big Data Innovation Team
First run ``` 2021-06-07 10:02:36,377 __main__ INFO Getting Access Token 2021-06-07 10:02:36,516 __main__ INFO Querying data from 2019-02-01 to 2019-02-28 2021-06-07 10:03:36,648 __main__ INFO Polling status of query request: 139025...
Here's a list of `intersection_movement` inconsistencies I've discovered while scanning through it. "U-turn inconsistent" means that u-turns are included for some legs, or some classes of vehicles, but not otherse,...
In support of our now year-old comparison of collision totals with TPS's records, we need to produce a set of control totals at the different stages of the ACC ingestion...
On 2020-12-14 there was a partial outage of Miovision data. From 18:30-18:45 some stations went offline, and from 18:45-19:00 all stations were offline. This can be seen using ```sql SELECT...
The distinction between Mobile Signs and Stationary Signs isn't made well enough in the documentation nor is it clear which tables to use for either and how those filter along...
We're trying to have all the OpenData datasets we're responsible for publishing documented in our root README, like for WYS https://github.com/CityofToronto/bdit_data-sources/#wys-open-data
Wards: 5,8,14,20 are missing data. I suspect this is because of the primary key constraint on `(installation_date, new_sign_number)`. Unfortunately nobody ever checked to see the data was actually successfully inserted....
Mohan branched it for review and update ## What this pull request accomplishes: - Raphael needs to confirm the changes/proposed changes in the detector table comments field to clear up...
While working on the speed limit dataset for the VZ network screening (Toronto-Big-Data-Innovation-Team/bdit_vz_analysis#62), I discovered that the speed limit along Yonge St. between Eglinton and Teddington Park Ave. is 80...