Document Debugging Missing Mobile WYS Open Data

[radumas]

It's happening enough that we get questions from the public about signs they have seen installed. Below is a bit of a draft WIP based on recent refreshing of knowledge.

The current process the Vision Zero Team have put in place for repairing/swapping out mobile WYS signs is such that the fixes should automatically flow through our pipeline to open data. Nevertheless, if some debugging/confirmation is required, go through the following steps

Have a look at the mermaid diagram to walk backwards.

1. Search for the location in wys.mobile_api_id this will give a few key data points for further investigation.

   SELECT location_id, location, comments, from_street, to_street, direction, installation_date, removal_date, combined, api_id
   FROM wys.mobile_api_id
   WHERE location LIKE '%STREETNAME%' ORDER BY installation_date DESC

Location is missing

If the recent installation isn't there, look up the location in wys.mobile_sign_installations.
If it's not there, figure out the ward and go to the appropriate spreadsheet in wys.ward_masterlist to debug whether installation details aren't being pulled properly

No data for sign

Use the api_id from above and look at the aggregation table wys.speed_counts_agg_5kph using it to see when the sign last reported data. If it appears to not be working. Then let Vision Zero team know by passing along the combined field from that query above which is effectively the sign name field from the locations table.

• Move the data dictionary and mermaid diagrams to the top level folder and fix the return characters which aren't displaying properly