Add column to ecocounter.flows to identify the type of device the flow is counting

[gabrielwol]

Could a column be added to ecocounter.flows to identify the type of device the flow is counting: scooter , bicycle, or combined micromobility?
So far the only equipment with separate scooter and bicycle flows is "Bloor St W, East of Old Mill Trail", site_id 300044518 and 300044519.

Originally posted by @A-DUYVESTYN in #1085 (comment)

[A-DUYVESTYN]

Similar to the device type, we also require an un-ambiguous way to define if a flow_id is contra or main flow. Column flow_direction is not standardized, and direction_main is not reliable, or null. Hoping there is a field from the API that can be used to define this.

For example see flow_id 353315312 YorkU - Keele St, North of Four Winds Dr
This appears to be contraflow based on the volumes, however the flow_direction southbound (IN) matches direction_main Southbound, suggesting it is a main flow.

[gabrielwol]

Looks like 'userType': 13 is a way to identify scooter flows from the API.

For contra flow it looks like we'll need to clean that up ourselves 😞 The IN/OUT designations are in the API but as you said they're not very accurate.