bdit_data-sources
bdit_data-sources copied to clipboard
Miovision: stop aggregating bikes in crosswalk
Although we say in the docs not to use bikes in crosswalk data, they are currently included in intersection_movements table and being aggregated into volumes_15min.
SELECT * FROM miovision_api.intersection_movements WHERE classification_uid = 7 AND movement_uid IN (5,6)