Raphael Dumas

Those links at the Toronto boundary seem perpendicular to it. I'm inferring that the geometry is being included in what we call "Toronto" through the clipping process when they are...

Updated what needs to happen for Open Data refresh

I think the below sub-task is unresolvable >Gardiner D to DVP F back-processing etc. etc.

Updated with two outstanding tasks

Example of the regular expression to catch these https://github.com/CityofToronto/bdit_data-sources/blob/text_to_centreline/gis/bylaw_text_to_centreline/sql/create-function-clean_bylaws_text2.sql#L37

To get all the `highway` with the two character code ```sql SELECT id, city, deleted, bylaw_no, chapter, schedule, schedule_name, highway, "between", speed_limit_km_per_h FROM jchew.bylaws_2020 WHERE highway ~ '.*\(..\).*' ``` There...

Vendor is working on a fix. Have implemented the `LEFT JOIN` with the two schedules tables in the stationary summary view. Will need to review the `wys.stationary_summary` table with the...

Vendor emailed to say that the API is fixed. We re-ran the above query and confirmed there is only 1 sign without a schedule

Good catch Nate! They are now folded into `Light`, so we should edit the documentation and remove them from the code and database.

Looks like just data requests and all last year, so there probably wouldn't have been volume returned.