Raphael Dumas

Thanks for raising this issue! It also came up last night at CfB while someone else was demoing it publicly. Responding to your suggestions out of order > 2 Create...

How could you determine when location `H` started producing data again after detector 5009 went offline on 2017-04-01?

Update OpenData views to reference appropriate segments tables.

Update TODO to include confirm extraction automation.

So there is indeed a bug in the aggregation function. Because of the 0-padding of null-volumes it will try to insert a 0 where there might already be 0 data....

Iced the VIEW creation. It works nicely for retrieving 1 `(link_dir, tx)` combination, but falls apart when trying to get all data for a given 5-min period. I'm hung up...

Welp I did not realize that an intersection geometry has a same node_id, which **is not unique** across `z_level`s, and is duplicated for each link in that intersection :man_facepalming: Updating...

After investigating some ODs that didn't route, noticed that some streets which should be routable are not and it's because of `ar_traff = 'Y'` in `traffic_streets`. Created `here_gis.traffic_streets_18_3b` AND `here.routing_streets_18_3b`...

## Turn Restrictions Are a combination of `here_gis.cdms WHERE cond_type = 7` (condition/driving manoeuvres) and restricted driving manoeuvres `here_gis.rdms INNER JOIN here_gis.cdms USING (link_id, cond_id)`, which provides a target manoeuvre...

Kind of wondering if I should make these unusual errors fail it instead.