No data for Mobile WYS sign Ward 3 - S6

[radumas]

Got a request for data from Mobile WYS sign Ward 3 - S6 because it was apparent in an image.

Located the installation in wys.mobile_sign_installations with:

SELECT ward_no, location, from_street, to_street, direction, installation_date, removal_date, new_sign_number, comments, id
	FROM wys.mobile_sign_installations
	WHERE location ILIKE '%Albert Ave%'

but... no data on OpenData. It does appear in wys.mobile_api_id which is a transformation of installations to match api_id to the speed count data from the API.

SELECT location_id, ward_no, location, from_street, to_street, direction, installation_date, removal_date, comments, combined, api_id
	FROM wys.mobile_api_id
	WHERE location ILIKE '%Albert Ave%'

Turns out there hasn't been data from this sign since 2019-03-15.

SELECT MAX(datetime_bin)
	FROM wys.raw_data_2019
	WHERE api_id = 6896

And it's unclear what the new sign (if it's a new sign) is.

SELECT api_id, address, sign_name, dir, start_date, loc, id
	FROM wys.locations
	WHERE sign_name LIKE '%Ward 3%'

A note that the speed count data stopped coming in before we started having an automated pipeline (hence the mismatch in start_date)

We should probably have a way of automating checking if a sign appears to stop producing data... especially with mobile installations.

I've asked staff responsible for WYS if there was a change in sign and will try to dig deeper... it does seem like there isn't anything wrong with updating locations...

[radumas]

There should be a check on all signs when they have stopped producing data after 2 months.