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

Build process for aggregating 5-min link data to 30- or 60- min (TBD) segment data #42

Open
aharpalaniTO opened this issue Jan 14, 2020 · 0 comments
Open

Build process for aggregating 5-min link data to 30- or 60- min (TBD) segment data #42

aharpalaniTO opened this issue Jan 14, 2020 · 0 comments
Assignees
@jovenc
Projects
Congestion Hotspots

Comments

@aharpalaniTO
Copy link

aharpalaniTO commented Jan 14, 2020 •
edited by jovenc
Loading

For this purposes:

  • links = disaggregate links (i.e. link_dir in HERE tables)
  • segments = aggregated links = 200m (or whatever we decide) long segments based on future grid creation process
@aharpalaniTO aharpalaniTO created this issue from a note in Congestion Hotspots (3. Data Aggregation) Jan 14, 2020
jovenc pushed a commit that referenced this issue Jan 16, 2020
#42 query for speeds_links_30min
561c160
jovenc pushed a commit that referenced this issue Jan 17, 2020
#42 find total obs for each link_dir
5096fce
jovenc pushed a commit that referenced this issue Jan 17, 2020
#42 aggregate links to segments (testing)
bc81b10
jovenc pushed a commit that referenced this issue Jan 17, 2020
#42 include all segments in test data
491178c
jovenc pushed a commit that referenced this issue Jan 20, 2020
#42 Aggregate 5min bin to 30min bin
666ad6a
jovenc pushed a commit that referenced this issue Jan 20, 2020
#42 Aggregate links to segments
7a3118c
jovenc pushed a commit that referenced this issue Jan 20, 2020
#42 Calculate baseline tt & spd
5f87c01
jovenc pushed a commit that referenced this issue Jan 20, 2020
#42 histograms for baselines
50cddc9
jovenc pushed a commit that referenced this issue Jan 21, 2020
#42 scatter plot for baseline speeds
7e54c09
jovenc pushed a commit that referenced this issue Jan 21, 2020
#42 calculate metrics
20ce94d
jovenc pushed a commit that referenced this issue Jan 21, 2020
#42 Fixed avg spd calculation
e4a48df
jovenc pushed a commit that referenced this issue Jan 21, 2020
#42 modified tti calculation
511c5a6
jovenc pushed a commit that referenced this issue Jan 23, 2020
#42 added num_bin
a1d5a8f
jovenc pushed a commit that referenced this issue Jan 23, 2020
#42 plot pdf for different speeds
52d05d4
jovenc pushed a commit that referenced this issue Jan 28, 2020
#42 edited for grid v1
072f2a3
jovenc pushed a commit that referenced this issue Jan 28, 2020
#42 renamed files to v1
4accb17
jovenc pushed a commit that referenced this issue Jan 30, 2020
#42 plotted figures to analyse v1 data
f82f266
jovenc pushed a commit that referenced this issue Jan 30, 2020
#42 use mean instead of median/pct_50 for speed
c89e515
jovenc pushed a commit that referenced this issue Jan 31, 2020
#42 added time taken and rows returned as a reference
ab0e20d
jovenc pushed a commit that referenced this issue Jan 31, 2020
#42 fixed the mistake of using an old table
4fec39a
jovenc pushed a commit that referenced this issue Jan 31, 2020
#42 testing only, do not refer to this notebook
b23308a
jovenc pushed a commit that referenced this issue Jan 31, 2020
#42 Comparing mean and median speeds
0829913
jovenc pushed a commit that referenced this issue Feb 3, 2020
#42 calculate metrics using mean speeds
1757f50
jovenc pushed a commit that referenced this issue Feb 3, 2020
#42 added comments to explain differences
d2c1577
jovenc pushed a commit that referenced this issue Feb 6, 2020
#42 queries to get data for grid v2
b52bbcd
@jovenc jovenc moved this from 3. Data Aggregation to 1. Metric Definition in Congestion Hotspots Feb 6, 2020
@jovenc jovenc moved this from 1. Metric Definition to 3. Data Aggregation in Congestion Hotspots Feb 6, 2020
jovenc pushed a commit that referenced this issue Feb 10, 2020
#42 rearraging queries for different grid version
883f4fe
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@jovenc jovenc

Labels
None yet
Projects
Congestion Hotspots
  
3. Data Aggregation
Milestone
No milestone
Development

No branches or pull requests
2 participants
@aharpalaniTO @jovenc