Investigate new Smartmicro sensors on highways

[gabrielwol]

Over the last year, 13 out of commission RESCU sensors have been replaced with Smartmicro sensors. Investigate and add to vds.detector_inventory table.

SELECT DISTINCT ON (vds_id) * FROM vds.vdsconfig WHERE detector_id LIKE 'SMARTMICRO - D%' ORDER BY vds_id, start_timestamp DESC'

[gabrielwol]

Some comparison plots between new smartmicro sensors and rescu sensors they replaced:

DS0030DSR: not clear what drives this difference. Both consistently reporting 1 lane of data (ramp).

DS0045DND:

DS0045DSD:

DS0050DND:

DS0050DSD:

DS0070DND:

DS0070DSD:

DW0050DWR:

• we noticed that this sensor and the one below need to be swapped.

DW0060DWR:

• we noticed that this sensor and the one above need to be swapped.

DW0070DER:

DW0080DWR:

DW0090DWR:

example query:

SELECT datetime_15min::date,
SUM(count_15min) FILTER (WHERE di.detector_id LIKE 'SMARTMICRO%') AS smartmicro_volume,
SUM(count_15min) FILTER (WHERE di.detector_id NOT LIKE 'SMARTMICRO%') AS pre_smartmicro_volume
FROM vds.counts_15min_div2 AS c15
JOIN vds.detector_inventory AS di ON di.uid = c15.vdsconfig_uid
WHERE di.detector_id LIKE '%DS0050DSD%'
GROUP BY 1 ORDER BY 1;

[gabrielwol]

@A-DUYVESTYN you may be interested in the graphs above