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

HERE Aggregation Proposal #1132

Open
gabrielwol opened this issue Jan 9, 2025 · 0 comments
Open

HERE Aggregation Proposal #1132

gabrielwol opened this issue Jan 9, 2025 · 0 comments
Assignees
@gabrielwol
Labels
enhancement here

Comments

@gabrielwol
Copy link
Collaborator

Proposed schema here: https://www.notion.so/bditto/Final-HERE-Schema-Planning-62af82e98e5d44c180f94c826e90b523?pvs=4#4ac37c13b4e24da38fb5b975209e4da4
@gabrielwol gabrielwol self-assigned this Jan 9, 2025
gabrielwol added a commit that referenced this issue Jan 9, 2025
@gabrielwol
#1132 raw_segments table definition
93b51dc
gabrielwol added a commit that referenced this issue Jan 9, 2025
@gabrielwol
#1132 raw_segments aggregation
9ba9b2d
gabrielwol added a commit that referenced this issue Jan 9, 2025
@gabrielwol
#1132 add time periods in addition to hours
f234008
gabrielwol added a commit that referenced this issue Jan 10, 2025
@gabrielwol
#1132 dynamic bins should not exceed 1hr in length
a0d618d
gabrielwol added a commit that referenced this issue Jan 10, 2025
@gabrielwol
#1132 reamde describing dynamic binning query
105b855
gabrielwol added a commit that referenced this issue Jan 10, 2025
@gabrielwol
#1132 remove unnecessary join from insert subquery
44515e3
gabrielwol added a commit that referenced this issue Jan 17, 2025
@gabrielwol
#1132 here dynamic binning: function
b1e1971
gabrielwol added a commit that referenced this issue Jan 30, 2025
@gabrielwol
#1132 update cache_tt_segment to return segment details + Check if ex…
f87ba3a 
…ists before routing
gabrielwol added a commit that referenced this issue Jan 30, 2025
@gabrielwol
#1132 cache_tt_segment procedure->function
f0a1d45
gabrielwol added a commit that referenced this issue Jan 30, 2025
@gabrielwol
#1132 cache_tt_results procedure->function
c38d0d1
gabrielwol added a commit that referenced this issue Jan 30, 2025
@gabrielwol
#1132 select map version func
d482f76
gabrielwol added a commit that referenced this issue Jan 30, 2025
@gabrielwol
#1132 cache_tt_results updates; use map version, fix end_bin bug, sav…
2441f58 
…e uri_string for result lookup
gabrielwol added a commit that referenced this issue Jan 30, 2025
@gabrielwol
#1132 tt_segments table; save map_version, nodes, remove link_dir con…
5223ac4 
…straint
gabrielwol added a commit that referenced this issue Jan 30, 2025
@gabrielwol
#1132 update dynamic bin results table; add uri
4e59c90
gabrielwol added a commit that referenced this issue Jan 30, 2025
@gabrielwol
#1132 update here_dynamic_bin_avg; use daily avgs -> avg method, use …
e9496e4 
…uri_string to locate results
gabrielwol added a commit that referenced this issue Feb 11, 2025
@gabrielwol
#1132 apply end_bin fix to congestion network query
b598778
gabrielwol added a commit that referenced this issue Feb 11, 2025
@gabrielwol
#1132 rename files/functions as per proposed dictionary
bbff938
gabrielwol added a commit that referenced this issue Feb 11, 2025
@gabrielwol
#1132 rename files/functions continued
b077a3a
gabrielwol added a commit that referenced this issue Feb 11, 2025
@gabrielwol
#1132 fluff
3cadf59
gabrielwol added a commit that referenced this issue Feb 14, 2025
@gabrielwol
#1132 congestion ntwrk hrly and period agg updates
3fc97db
gabrielwol added a commit that referenced this issue Feb 14, 2025
@gabrielwol
#1132 rename function for consistency
6902e23
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@gabrielwol gabrielwol

Labels
enhancement here
Projects
None yet
Milestone
No milestone
Development

When branches are created from issues, their pull requests are automatically linked.

1132-here-aggregation-proposal CityofToronto/bdit_data-sources
1 participant
@gabrielwol