1 / 50

Travel Time Reliability in PostGIS and R

Travel Time Reliability in PostGIS and R. Michael Fuller Transportation Planner Toledo Metropolitan Area Council of Governments (TMACOG). Ohio GIS Conference. September 24 – 26, 2018. Hyatt Regency Columbus. Columbus, Ohio. Outline. Background and motivation Problem

epickney
Download Presentation

Travel Time Reliability in PostGIS and R

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Travel Time Reliability in PostGIS and R Michael Fuller Transportation Planner Toledo Metropolitan Area Council of Governments (TMACOG) Ohio GIS Conference September 24 – 26, 2018 Hyatt Regency Columbus Columbus, Ohio

  2. Outline Background and motivation Problem Data processing: Postgres/PostGIS Visualization: Rstudio

  3. LOTTR TTTR

  4. Motivation Moving Ahead for Progress in the 21st Century Act (MAP-21) Congestion Management Process (CMP) Long Range Plans and Transportation Improvement Program

  5. Background

  6. Background

  7. Problem

  8. Problem Excel/Access file size limits ArcMap query limits

  9. Solution: Postgres/PostGIS Size limited only by hardware Has the query options I need Free

  10. Setting Up Postgres/PostGIS/pgAdmin https://www.postgresql.org/download/ For Windows: https://www.youtube.com/watch?v=e1MwsT5FJRQ For MAC: https://www.youtube.com/watch?v=5AOkxqFaYEE For Linux ubuntu: https://www.youtube.com/watch?v=-LwI4HMR_Eg For linux mint: https://www.youtube.com/watch?v=8FREKimc1oU

  11. Create Database and Extension

  12. Create Database and Extension

  13. Create Table and Insert Data

  14. Create Table and Insert Data

  15. Create Table and Insert Data

  16. Load NPMRDS Network Shapefile(s)

  17. Load NPMRDS Network Shapefile(s)

  18. Load NPMRDS Network Shapefile(s)

  19. Load NPMRDS Network Shapefile(s)

  20. Load NPMRDS Network Shapefile(s)

  21. Load NPMRDS Network Shapefile(s)

  22. #QueryGoals

  23. LOTTR Query

  24. LOTTR Query Part 1

  25. LOTTR Query Part 2

  26. LOTTR Query Part 3

  27. LOTTR Query Part 4

  28. LOTTR Query Part 5

  29. LOTTR Query Part 5

  30. LOTTR Query Part 5

  31. Time of Day and Day of Week variation • Hour 0 = Midnight-12:59 AM • Hour 23 = 11:00-11:59 PM • Days of the week are zero-indexed • AM Peak: 5<hour<10, 0<dow<6 • Midday: 9<hour<16, 0<dow<6 • PM Peak: 15<hour<20, 0<dow<6 • Weekend: 5<hour<20, dow = 0 or dow = 6 • Overnight (trucks only): hour<6 or hour >19

  32. LOTTR Query Part 6

  33. Batch Queries

  34. R/Rstudio Install and Set Up • Windows: https://www.youtube.com/watch?v=9-RrkJQQYqY • Mac: https://www.youtube.com/watch?v=lVKMsaWju8w • Linux Ubuntu: https://www.youtube.com/watch?v=pqrO-Jqs_2Q

  35. R Visualization Script

  36. R Visualization Script part 1

  37. R Visualization Script part 2

  38. R Visualization Script – gather() Image source: https://github.com/gadenbuie/tidy-animated-verbs/#tidy-data

  39. R Visualization Script – gather() before

  40. R Visualization Script – gather() after

  41. R Visualization Script

  42. R Visualization Script

  43. R Visualization Script

  44. R Visualization Script

  45. R Visualization Script

  46. R Visualization Script

  47. R Visualization Script

  48. Final Visualization

  49. Resources and contact information Email: fuller@tmacog.org PostGIS files: Github.com/mr-fuller/npmrds R files: Github.com/mr-fuller/inrix-congestion FHWA reporting guidance: https://www.fhwa.dot.gov/tpm/guidance/pm3_hpms.pdf Postgres download: https://www.postgresql.org/download/ R download: https://www.r-project.org/

More Related