Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

1065 miovision stop aggregating bikes in crosswalk #1068

Open
wants to merge 4 commits into
base: master
Choose a base branch
from
Open

1065 miovision stop aggregating bikes in crosswalk #1068

wants to merge 4 commits into from

Conversation

gabrielwol
Copy link
Collaborator

@gabrielwol gabrielwol commented Sep 9, 2024 •
edited
Loading

What this pull request accomplishes:

  • Make sure bikes in crosswalk and bike exits do not end up in aggregate tables (via intersection_movements)
  • Delete existing bikes in crosswalk and bike exits.

Issue(s) this solves:

What, in particular, needs to reviewed:

What needs to be done by a sysadmin after this PR is merged

Run:

DELETE FROM miovision_api.volumes_15min_mvt WHERE classification_uid = 7;
DELETE FROM miovision_api.volumes_15min WHERE classification_uid = 7;
DELETE FROM miovision_api.intersection_movements WHERE classification_uid = 7;

--this is the only aggregate table that includes bike exits
DELETE FROM miovision_api.volumes_daily_unfiltered WHERE classification_uid = 7 AND (classification_uid = 10 AND movement_uid = 8);
--IMPORTANT: run a modified miovision_api.aggregate_volumes_daily to reaggregate classification_uid = 10 for all intersections to exclude bike exits.

@gabrielwol gabrielwol self-assigned this Sep 9, 2024
@gabrielwol gabrielwol linked an issue Sep 9, 2024 that may be closed by this pull request
Miovision: stop aggregating bikes in crosswalk #1065
Open
@gabrielwol gabrielwol marked this pull request as ready for review September 9, 2024 21:13
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Reviewers

@radumas radumas Awaiting requested review from radumas

At least 1 approving review is required to merge this pull request.

Assignees

@gabrielwol gabrielwol

Labels
Miovision
Projects
None yet
Milestone
No milestone
Development

Successfully merging this pull request may close these issues.

Miovision: stop aggregating bikes in crosswalk
1 participant
@gabrielwol