The city has installed Watch Your Speed Signs that display the speed a vehicle is travelling at and flashes if the vehicle is travelling over the speed limit. Installation of the sign was done as part of 3 programs: the normal watch your speed sign program, mobile watch your speed which has signs mounted on trailers that move to a different location every few weeks, and school watch your speed which has signs installed at high priority schools. As part of the Vision Zero Road Safety Plan, these signs aim to reduce speeding.
apicontains code and documentation about how the dataset is extracted, transformed and loadedvalidationcontains notebooks analyzing the differences between WYS observation counts and other volume counts to determine how well these signs can be used as permanent volume counters
For most inquiries, the data prepared for Open Data should suffice, accessed either at the links below, or in the open_data schema of the bigdata database.
For more complex inquiries or investigations, the raw data is stored in the wys schema of bigdata. The aggregation process is described in detail in api/README.md.
Semi-aggregated and monthly summary data are available for the two programs (Stationary School Safety Zone signs and Mobile Signs) and are updated monthly. Because the mobile signs are moved frequently, they do not have accurate locations beyond a text description, and are therefore presented as a separate dataset. See WYS documentation for more information on how the datasets are processed.
- School Safety Zone Watch Your Speed Program – Locations: The locations and operating parameters for each location where a permanent Watch Your Speed Program Sign was installed.
- School Safety Zone Watch Your Speed Program – Detailed Speed Counts: An hourly aggregation of observed speeds for each location where a Watch Your Speed Program Sign was installed in 5 km/hr speed range increments.
- Safety Zone Watch Your Speed Program – Monthly Summary: A summary of observed speeds for each location where a Safety Zone Watch Your Speed Program Sign was installed.
- Mobile Watch Your Speed Program – Detailed Speed Counts: An hourly aggregation of observed speeds for each sign installation in 5 km/hr speed range increments for each location where a Mobile Watch Your Speed Program Sign was installed.
- Mobile Watch Your Speed Program – Speed Summary: A summary of observed speeds for each location where a Mobile Watch Your Speed Program Sign was installed.