Raphael Dumas

The municipality layer is going to have to come from the [Ontario government](https://geohub.lio.gov.on.ca/datasets/64fb702e16204c3e88b528d9759f1174_14/about) :meow_meh:

Good catch. Unfortunately because the site is internal it doesn't seem the SSL certificate is signed properly/recognized so, I think we can ignore the error.

another one! ```sql SELECT intersection_name , DATE(datetime_bin) dt, COUNT(DISTINCT datetime_bin), classification, SUM(volume) FROM miovision_api.volumes_15min NATURAL JOIN miovision_api.intersections NATURAL JOIN miovision_api.classifications WHERE Datetime_bin >= '2021-11-30' AND datetime_bin < '2021-12-03' GROUP BY...

Related https://github.com/CityofToronto/bdit_data-sources/issues/370

Testing on Ward 14. ```sql ALTER TABLE wys.ward_14 DROP CONSTRAINT ward_14_pkey; --INSERT script needs to have some constraint on the table. ALTER TABLE wys.ward_14 ADD CONSTRAINT ward_14_pkey PRIMARY KEY (location,...

Ran the following to clean up the existing data ```sql -- BEGIN; -- UPDATE wys.mobile_sign_installations -- SET --ward_no=?, location=?, from_street=?, to_street=?, direction=?, installation_date=?, removal_date=?, -- new_sign_number='3' -- WHERE (ward_no, location,...

https://github.com/CityofToronto/bdit_data-sources/commit/b23abd8b770a97186bc99d9e0220885f19372eac The above commit creates a separate table to rows that fail the duplicate check (signs for a given ward that have the same installation date). @KatiRG it would be...

In order to ensure data was aggregated up to OpenData Identified months that were missing mobile data for individual wards ```sql WITH summary AS( SELECT ward_no, date_trunc('month', removal_date)::DATE mon, COUNT(1)...

yeah maybe there should be a slack alert on failure....

We haven't reorganized the travel time datasets under one folder, there is loads of Bluetooth documentation under [`bluetooth`](../tree/master/bluetooth/)