MAP-21 Mobility Performance

Update Log

• September 5, 2024: added 2023 final csvs
• February 29, 2024: added 2022 final csvs
• August 26, 2022: added 2021 final csvs
• April 27, 2021: added 2020 final csvs
• August 6, 2020: added 2019 final csvs and reformated webpage
• March 8, 2019: added 2018 final csvs
• February 19, 2019: updated comparison map with 2018 values
• July 18, 2018: added 2018 Q1/Q2 csv files per MPA in table
• May 17, 2018: added reliability measure results per MPA, table and bar chart
• May 7, 2018: implemented new guidance regarding the nhs_pct value for use with the PHED per capita measure; updated the measure result for the Milwaukee area
• May 3, 2018: updated statewide default auto occupancy from 1.69 to 1.67, which slightly lowers the percent reliable measure result for interstates
• April 11, 2018: incorporated newly available January 2017 data; full re-run and all results updated
• March 1, 2018: full re-run to capture February updates to input data; all tables and graphs updated for draft release
• February 27, 2018: update log added; column headers in results tables modified to better align with recent HPMS format guidance; data column descriptions added; monthly plots modified to include additional info
• February 13, 2018: page established; draft results published

Data Column Descriptions

Here are all the columns in the results tables generated by the TOPS Lab. The columns that appear only in the HPMS-specfic format (see FHWA guide here for more detail) are indicated in red font.  Abbreviations used throughout include traffic message channel (TMC), national highway system (NHS), level of travel time reliability (LOTTR), truck travel time reliability (TTTR), and peak hour excessive delay (PHED), which is calculated anywhere posted speed limit and volume distributions are available (and officially reported for the Milwaukee adjusted urbanized area).

1. tmc (or travel_time_code) – the TMC segment identifier
2. year (or year_record) – calendar year
3. tt_amp50pct – AM peak 50th %ile travel time
4. tt_midd50pct – midday 50th %ile travel time
5. tt_pmp50pct – PM peak 50th %ile travel time
6. tt_we50pct – weekend 50th %ile travel time
7. tt_ovn50pct – overnight 50th %ile travel time
8. tt_amp80pct – AM peak 80th %ile travel time
9. tt_midd80pct – midday 80th %ile travel time
10. tt_pmp80pct – PM peak 80th %ile travel time
11. tt_we80pct – weekend 80th %ile travel time
12. tt_ovn80pct – overnight 80th %ile travel time
13. ttt_amp50pct – AM peak 50th %ile truck travel time
14. ttt_midd50pct – midday 50th %ile truck travel time
15. ttt_pmp50pct – PM peak 50th %ile truck travel time
16. ttt_we50pct – weekend 50th %ile truck travel time
17. ttt_ovn50pct – overnight 50th %ile truck travel time
18. ttt_amp95pct – AM peak 95th %ile truck travel time
19. ttt_midd95pct – midday 95th %ile truck travel time
20. ttt_pmp95pct – PM peak 95th %ile truck travel time
21. ttt_we95pct – weekend 95th %ile truck travel time
22. ttt_ovn95pct – overnight 95th %ile truck travel time
23. lottr_amp – AM peak LOTTR
24. lottr_midd – midday LOTTR
25. lottr_pmp – PM peak LOTTR
26. lottr_we – weekend LOTTR
27. lottr_ovn – overnight LOTTR
28. lottr_max – maximum LOTTR (excludes overnight)
29. tttr_amp – AM peak TTTR
30. tttr_midd – midday TTTR
31. tttr_pmp – PM peak TTTR
32. tttr_we – weekend TTTR
33. tttr_ovn – overnight TTTR
34. tttr_max – maximum TTTR
35. exde_amp – AM peak excessive delay
36. exde_midd – midday excessive delay
37. exde_php – PM peak excessive delay
38. exde_we – weekend excessive delay
39. exde_ovn – overnight excessive delay
40. phed – PHED metric, sum of AM and PM peaks
41. obs – count of 15-minute periods with data (max ~ 35k/year), a quality indicator
42. tmc_version – the date of the TMC inventory data used for calculations, for record keeping
43. road – route number or name
44. direction – usually a travel direction, NORTHBOUND, SOUTHBOUND, EASTBOUND, or WESTBOUND, but sometimes longer descriptions
    1. directionality – 1=NB; 2=SB; 3=EB; 4=WB; 5=other/unknown
45. intersection – a cross street or interchange
46. state – for Wisconsin this is always WI
    1. state_code – state FIPS code, which for Wisconsin is 55
47. county – there are 71 since there is no NHS in Menominee
48. zip – the five-digit zip code
49. start_latitude – degrees from equator for TMC start
50. start_longitude – degrees from prime meridian for TMC start
51. end_latitude – degrees from equator for TMC end
52. end_longitude – degrees from prime meridian for TMC end
53. miles (or segment_length) – the TMC length in miles
54. road_order – a sequencing number in the travel direction
55. timezone_name – either America/Chicago or America/Menominee
56. tmc_type – P1 is most common (98% of TMCs), P3 indicates a jurisdictional boundary, P4 is a ramp
57. country – these are all USA
58. tmclinear – an integer that can be helpful for sequencing
59. frc – an alternative classification for TMCs
60. border_set – for international boundaries, all of Wisconsin’s are N
61. f_system – FHWA functional class, 1=interstate, 2=other freeways and expressways, etc.
62. urban_code – Census urban area, e.g., Milwaukee=57466, corresponds closely with mpa_cd
63. faciltype (or facility_type) – 1=one-way, 2=two-way (used to divided two-way volumes into directional volumes)
64. structype – for bridges and other structures, usually zero, less than 1% are bridges
65. thrulanes – total through lanes in both travel directions
66. route_numb – a signed route number, but only a handful of TMCs in Wisconsin are a number other than zero
67. route_sign – code for route signing, 2=interstate, 3=US route, 4=state, 10=other
68. route_qual – a qualifier for the route signing, 1=none, 3=business route, 10=other
69. altrtename – an alternative route name, e.g., “51N” or “Pilgrim R”
70. aadt – average annual daily traffic (AADT) volume, bi-directional
71. aadt_singl – AADT for single-unit trucks and buses
72. aadt_combi – AADT for larger combination trucks
73. nhs – a code for NHS component, 1=typical (99%), 3=port, 4=rail station, 6=bus terminal, 9=ferry terminal
74. nhs_pct – percent of TMC designated as NHS
75. strhnt_typ – the Strategic Highway Network (STRAHNET) type, 0=undefined (85% of TMCs), 1=regular (14%), 2=connector (1%)
76. strhnt_pct – percent of TMC on STRAHNET
77. truck – part of the National Truck Network, 0=undefined (15% of TMCs), 1=yes (46%), 2=other (39%)
78. region – the two-letter code for the five WisDOT regions
79. interstate – 0=non-interstate NHS, 1=interstate
80. df – directional factor for AADTs, usually the default 0.5, but 1.0 for one-way roads (faciltype=1)
81. freeway – a value-added identifier from SEWRPC for identifying non-interstate freeway segments (freeway=1), used for volume distributions
82. psl – posted speed limit, distance weighted per TMC, furnished by SEWRPC, otherwise blank
83. avoc – average vehicle occupancy for cars
84. avob – average vehicle occupancy for buses
85. avot – average vehicle occupancy for trucks
86. mpa_cd – the three-character code for MPAs, corresponds closely with urban_code
87. mpa_nm – the MPA name, e.g., Chippewa-Eau Claire
88. uza – an indicator for the Milwaukee adjusted urbanized area, 0=no, 1=yes, needed for delay reporting
89. pctc – percent cars
90. pctb – percent buses
91. pctt – percent trucks
92. avo (or occ_fac) – average vehicle occupancy factor, from car/bus/truck occupancies and percents
    1. dir_aadt – directional AADT volume (aadt x df)
    2. metric_source – data source, 1=NPMRDS, 2=other
93. reliable – if lottr_max is less than 1.5 then the TMC is reliable (reliable=1)
94. pmt – annual person miles traveled