HPMS Vehicle Summary Data Computation
The process involves computing vehicle summary data from HPMS, determining additional columns like VMT, SUVMT, and CTVMT based on various parameters such as urban code and AADT, calculating VMT by county and function class, creating pivot tables for rural roadway VMT, and selecting data based on specific conditions. This comprehensive analysis provides valuable insights for transportation planning and management.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
1 Part 4 HPMS Vehicle Summary Data Computation
Additional Columns 2 Ucode=if(urban_code=99999, Rural , Urban ) VMT=(end_point-begin_point)*AADT SUVMT=(end_point-begin_point)*SUAADT CTVMT=(end_point-begin_point)*CTAADT
Step 1: Calculate VMT using HPMS data by county and Function class (facility = 1, 2, 3) 3 Begin_Point End_PointAADT_VN COUNTY_CODE_VN 0 0.1 0.1 0.2 0.2 0.235 0.235 0.24 0.24 0.3 0.3 0.39 0.39 0.394 0.394 0.4 0.4 0.472 0.472 0.5 0.5 0.522 0.522 0.6 F_SYSTEM_VN FACILITY_TYPE_VN 2 2 2 2 2 2 2 2 2 2 2 2 URBAN_CODE_VN 99998 99998 99998 99998 99998 99998 99998 99998 99998 99998 99998 99998 Ucode VMT 2000 2000 2000 2000 2000 2000 2000 3200 3200 5700 5700 5400 5 5 5 5 5 5 5 5 5 5 5 5 4 4 4 4 4 4 4 4 4 4 4 4 2 2 2 2 2 2 2 2 2 2 2 2 200 200 70 10 120 180 8 19.2 230.4 159.6 125.4 421.2
Step 1: VMT by County and Function Class 5 Rural Roadway VMT pivot table Function class County 1 2 3 4 5 Rural Total 1 3 5 7 9 11 13 15 17 19 21 23 25 27 Grand Total 3,417,860 220,915 298,617 56,500 76,763 55,504 50,552 47,664 265,671 149,669 103,879 149,721 20,419 213,980 103,573 389,790 90,771 162,288 140,577 281,599 241,974 268,268 2,582,180 222,660 233,026 215,076 227,893 63,582 313,476 24,563 188,231 283,329 232,378 240,611 237,651 230,065 507,515 3,220,055 709,246 681,311 645,855 761,516 139,505 848,169 175,801 578,021 885,916 522,403 997,310 1,098,096 1,039,741 2,114,370 11,197,259 270,400 307,139 270,154 7 511,815 127,737 223 118 615,900 118,182 148,500 287,720 1,976,817 460,547 419,203 1,050,867 347
Step 2: Select * if IS_Sample=1 or AADT_Combination_vn<>0 6 Begin_Point End_PointAADT_VN AADT_COMBINATION_VN 0.235 0.24 2000 0.24 0.3 2000 0.3 0.39 2000 0.39 0.394 2000 0 0.1 2100 0.1 0.2 2100 0.2 0.225 2100 0.595 0.6 3300 0.6 0.7 3300 0.7 0.8 3300 0.8 0.837 3300 0 0.005 230 0.244 0.3 9900 0.3 0.4 9900 0.4 0.425 9900 1.635 1.64 11100 1.64 1.7 11100 1.7 1.8 11100 AADT_SINGLE_UNIT_VN COUNTY_CODE_VN 120 120 120 120 100 100 100 40 40 40 40 10 470 470 470 580 580 580 F_SYSTEM_VN FACILITY_TYPE_VN 2 2 2 2 2 2 2 1 1 1 1 2 2 2 2 2 2 2 URBAN_CODE_VN 99998 99998 99998 99998 99999 99999 99999 11755 11755 11755 11755 99999 99998 99998 99998 99998 99998 99998 IS_SAMPLE Ucode VMT SUVMT CTVMT 50 50 50 50 30 30 30 10 10 10 10 0 180 180 180 220 220 220 5 5 5 5 4 4 4 4 5 5 5 3 3 3 3 3 2 2 2 3 3 3 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 2 2 2 1 1 1 2 2 2 2 1 2 2 2 2 2 2 10 120 180 0.6 7.2 10.8 0.48 10 10 2.5 0.2 0.25 3 4.5 0.2 8 19 19 19 7 7 7 7 21 21 21 21 21 21 21 210 210 52.5 16.5 330 330 122.1 1.15 554.4 990 247.5 55.5 666 1110 3 3 0.75 0.05 4 4 1 1 1.48 0.05 26.32 0.37 0 10.08 47 18 4.5 1.1 13.2 22 11.75 2.9 34.8 58
Truck VMT for Sample Panel Data 8 Sample Panel Data VMT and Truck VMT Pivot Table VMT by Function Class SUVMT by Function Class CTVMT by Function Class County 1 3 5 7 9 11 13 15 17 19 21 23 25 27 1 2 3 4 5 1 2 3 4 5 1 2 3 4 5 176 258 168 210 249 70,095 107,640 19,064 58,214 18,548 47,120 11,726 37,971 2,821 35,889 4,846 51,738 13,262 36,914 23,107 91,378 22,497 24,459 18,216 20,091 9,794 17,457 5,081 54,888 413 4,845 18,299 14,977 12,867 23,189 23,042 52,831 4,371 5,848 1,596 2,215 1,179 3,414 654 2,001 202 2,108 373 2,662 647 2,370 1,529 4,061 1,494 1,546 1,014 1,068 938 828 292 4,228 314 1,122 1,136 752 1,087 1,820 3,063 2,971 4,821 726 3,143 1,161 3,997 461 1,025 159 963 1,285 369 917 1,741 1,270 434 387 1,360 381 434 107 286 225 908 251,913 292,901 0 18,266 13,623 0 27,252 19,924 0 73,180 7 5,976 0 6,158 0 26,158 1,191 50 2,144 72 33 58 480,018 89,438 32,165 5,348 36,119 12,346 223 118 278,341 40,906 60,430 44,326 14 7 16,576 2,232 4,404 4,373 10 12,427 1,758 2,717 2,152 252,445 330,892 923,634 15,527 14,965 60,588 17,149 30,476 61,925 7
Step 2 Continue Truck VMT% for Sample Panel Data 9 Truck VMT% for Sample Panel Data SUVMT% by function class CTVMT% by function class County 1 3 5 7 9 11 13 15 17 19 21 23 25 27 1 2 3 4 5 1 2 3 4 5 6.24% 5.43% 8.37% 3.81% 6.36% 7.25% 5.58% 2.56% 5.27% 7.14% 5.87% 7.70% 12.00% 5.14% 4.88% 6.42% 6.62% 4.44% 6.64% 6.32% 5.57% 5.32% 9.58% 4.75% 5.74% 7.70% 4.24% 4.48% 3.81% 5.40% 6.26% 8.48% 3.94% 0.56% 2.70% 5.64% 2.68% 1.49% 2.48% 2.78% 2.48% 7.53% 1.39% 1.93% 1.58% 0.97% 1.28% 1.72% 1.20% 4.90% 2.48% 8.00% 1.21% 2.08% 2.90% 0.83% 1.23% 0.98% 1.72% 7.25% 4.65% 10.82% 6.80% 8.17% 5.08% 8.41% 3.54% 4.55% 8.20% 6.48% 6.13% 7.58% 5.85% 4.69% 7.90% 5.80% 6.70% 5.98% 7.52% 13.80% 6.18% 5.61% 5.96% 5.46% 7.29% 9.87% 4.43% 5.71% 4.46% 4.30% 4.50% 4.85% 6.15% 4.52% 6.56% 6.79% 9.21% 6.70%
Step 3. Vehicle Class Data Analysis 10 It is recommended to use annualized count or adjusted count to a common time period: per day or per 48 hour It is extremely important to use the same time period for all stations Use simple average of vehicle % within county is not recommended
Vehicle Class Data Analysis Annualized and Seasonal Adjusted AADT and Vehicle Count Data 11 County 07 07 07 27 07 07 07 07 07 07 23 27 25 07 17 07 Urban C Urban Urban Urban Rural Urban Urban Urban Rural Urban Urban Rural Rural Urban Urban Rural Urban FC 1 1 1 1 1 1 2 1 1 3 1 1 1 1 1 3 AADT 55000 40200 39200 38500 35500 39400 30500 29300 30100 25200 25300 23100 23300 20800 19500 19300 MC 121 113 110 393 117 307 436 258 51 270 0 51 51 67 70 180 Car 42299 33142 30232 27518 27347 26940 22994 22637 20255 19833 19187 18433 17016 15491 14489 14316 LT Bus 462 225 317 320 312 433 271 316 87 146 66 30 261 181 234 208 SU 2200 977 1442 2672 1189 2475 869 973 2468 829 1804 358 911 888 957 1002 CT 1331 1105 1141 870 1427 1084 775 1319 921 537 1040 906 1871 1017 1217 836 8586 4639 5958 6727 5107 8161 5155 3797 6317 3586 3203 3322 3190 3156 2533 2758
Total Daily Counts by County and Function Class Pivot Table 13 Rural Function class County 01 03 05 07 09 11 13 15 17 19 21 23 25 27 1 3 MC Car LT Bus SU CT MC 1488 71724 19086 1184 5440 4378 750 57498 15775 783 4136 3187 449 21413 6922 307 2212 1198 147 17637 3441 152 488 11689 4675 245 1146 1256 321 11432 3935 142 1119 576 16529 5082 200 Car LT Bus SU CT 201 17732 4717 334 1822 2724 258 22637 3797 316 973 1319 739 1183 74 13734 3347 209 1282 1154 851 913 1900 366 49470 10871 814 3254 4325 134 17976 5167 376 1691 2326 96 7171 2244 102 348 43883 9633 450 4167 2519 261 36939 8379 513 2135 3964 1515 138093 34063 2279 11200 7830 2376 115183 34879 1524 9410 5528 436 453 3456 167050 53675 2587 14549 11423 549 15831 4945 169 1033 658 41536 10727 494 2979 2405 773
Daily Count Vehicle % 14 Rural Function class County 01 03 05 07 09 11 13 15 17 19 21 23 25 27 1 3 MC Car LT Bus SU CT MC 1.44% 69.43% 18.48% 0.91% 70.01% 19.21% Car LT Bus SU CT 1.15% 5.27% 0.95% 5.04% 0.94% 6.81% 0.65% 3.17% 1.26% 5.88% 0.80% 6.29% 0.80% 3.62% 4.24% 3.88% 3.69% 5.08% 6.44% 4.78% 7.54% 0.73% 64.41% 17.13% 1.21% 6.62% 9.90% 1.38% 65.89% 21.30% 0.88% 77.26% 12.96% 1.08% 3.32% 4.50% 0.63% 75.70% 14.77% 2.50% 59.95% 23.98% 0.38% 69.36% 16.90% 1.06% 6.47% 5.83% 1.80% 64.22% 22.11% 2.29% 65.59% 20.17% 0.53% 71.59% 15.73% 1.18% 4.71% 6.26% 0.49% 64.97% 18.67% 1.36% 6.11% 8.41% 0.91% 68.29% 21.37% 0.97% 4.15% 4.31% 1.37% 66.10% 21.24% 0.57% 71.94% 15.79% 0.74% 6.83% 4.13% 2.36% 67.95% 21.22% 0.50% 70.78% 16.05% 0.98% 4.09% 7.59% 1.12% 70.64% 18.24% 0.78% 70.82% 17.47% 1.17% 5.74% 4.02% 1.41% 68.20% 20.65% 1.02% 5.76% 0.72% 4.43% 0.84% 5.07% 0.90% 5.57% 4.52% 3.32% 4.09% 3.27%
Step 4: Combine Class Data and Truck AADT% Data 15 Adopt MC%, Car%, Light Truck% and Bus% data from class data Single Unit Truck% = Single Unit Vehicle% Bus% Passenger Car% = 1 - MC% - LT% - Bus% - SUV% - CT% Borrow vehicle % data from similar county if no there are no data available
Function Class 1, 2, 3 and 4 16 Data from Spatial Intersector table Daily County VMT 01 03 05 270,400 07 307,139 09 11 270,154 13 15 17 511,815 19 127,737 21 23 460,547 25 419,203 27 1,050,867 Calculated column R1 MC Single U Truck Single U Vehicle Car LT Bus CT 0.72% 0.88% 65.20% 74.71% 16.01% 12.96% 1.07% 1.08% 6.18% 3.57% 7.25% 4.65% 10.82% 6.80% 0.34% 65.65% 17.43% 0.84% 7.32% 8.17% 8.41% SU-Bus% =1-MC%-Car%-LT%-SU%-CT% 0.52% 0.39% 0.91% 0.74% 0.42% 0.80% 66.34% 59.17% 68.29% 67.91% 67.80% 67.39% 18.92% 20.65% 21.37% 18.41% 18.04% 18.54% 1.45% 1.36% 0.97% 1.00% 1.71% 1.39% 5.25% 4.62% 4.15% 5.15% 2.81% 5.17% 6.70% 5.98% 4.15% 6.15% 4.52% 6.56% 7.52% 13.80% 4.31% 6.79% 9.21% 6.70%
R5, U5 and U6 17 Daily U5 MC Single U Truck 4.18% 2.87% 4.83% 3.45% County ID VMT 01 03 05 07 09 11 13 15 17 19 21 23 25 Car LT Bus SU CT 15,474 50,353 14,711 358,506 0.85% 0.59% 0.83% 1.20% 76.21% 75.18% 70.15% 74.96% 16.98% 19.78% 22.39% 18.63% 0.25% 0.44% 0.53% 0.48% 4.43% 3.31% 5.36% 3.93% 1.53% 1.14% 1.27% 1.29% 21,520 0.65% 75.32% 18.27% 0.72% 3.43% 4.15% 1.61% 10,574 67,731 49,057 21,246 1.36% 0.83% 0.79% 0.56% 68.82% 69.84% 74.16% 76.80% 24.11% 23.69% 20.96% 18.62% 0.16% 0.40% 0.55% 0.05% 4.64% 3.74% 3.05% 3.10% 4.80% 4.14% 3.60% 3.16% 0.90% 1.50% 0.48% 0.86%
Or R5, U5 and U6 18 Daily R5 MC County ID VMT 01 03 05 07 09 11 13 15 17 19 21 23 25 27 Car LT Bus SU CT 222,660 233,026 215,076 227,893 63,582 313,476 24,563 188,231 283,329 232,378 240,611 237,651 230,065 507,515 2.39% 1.38% 1.89% 2.35% 2.74% 2.17% 2.28% 1.75% 1.93% 2.21% 1.79% 1.90% 1.70% 1.86% 66.33% 67.43% 65.04% 71.57% 58.60% 63.94% 70.11% 69.59% 65.66% 62.16% 63.83% 70.91% 66.65% 69.03% 23.65% 24.17% 25.20% 20.73% 29.29% 25.62% 21.71% 23.02% 25.54% 26.42% 26.35% 21.50% 24.25% 22.58% 0.69% 0.73% 0.52% 0.57% 0.45% 0.61% 0.45% 0.47% 0.50% 0.66% 0.94% 0.46% 0.59% 0.60% 5.16% 5.28% 5.73% 3.92% 5.13% 5.50% 3.79% 4.16% 4.88% 5.85% 5.27% 3.98% 5.87% 4.75% 1.77% 1.02% 1.62% 0.86% 3.79% 2.16% 1.67% 1.01% 1.48% 2.69% 1.83% 1.24% 0.93% 1.19%
R6, R7 and U7 (VMT data are statewide so no weighting) 19 Function class County 01 03 05 07 09 11 6 MC Car LT Bus SU CT 3.33% 0.47% 1.01% 2.12% 1.03% 2.62% 64.58% 75.16% 69.44% 73.50% 66.04% 67.15% 23.64% 20.72% 19.30% 20.13% 25.72% 28.17% 0.84% 0.21% 0.45% 0.41% 0.04% 0.00% 6.18% 3.17% 9.12% 3.15% 6.57% 1.87% 1.44% 0.27% 0.68% 0.69% 0.61% 0.19% Average all counties 6 MC 1.06% Daily VMT Car LT Bus SU CT 586,186 41.59% 13.77% 0.19% 3.01% 0.39%
Group VMT of Functional Classes (FC) to FS_Group 20 Description FS_Group FC 1 Rural Interstate R1 Rural Other Arterial (other rural freeways and expressways, other principal arterials, and minor arterial) 2 R2 + R3 + R4 Rural other (Includes major collectors, minor collectors, and local) 3 R5 + R6 + R7 4 Urban Interstate U1 Urban Other Arterial (other urban expressways and freeways, other principal arterials and minor arterials) 5 U2 + U3 + U4 Urban Other (includes major collectors, minor collectors, and locals) 6 U5 + U6 + U7
Step 5: Produce Vehicle Summary Data 21 VMT by FS_group and Vehicle class group FS 1 2 3 4 5 6 MC 22,325 85,662 109,183 5,249 27,831 27,107 Car LT Bus 44,043 40,691 35,490 9,959 13,524 11,879 SU CT 2,303,461 3,032,104 4,092,442 763,838 1,768,935 1,961,401 608,596 989,258 1,691,042 180,119 438,556 536,830 170,065 238,278 394,324 53,093 78,253 93,160 269,369 173,350 104,736 46,896 36,196 3,780 VMT% FS 1 2 3 4 5 6 MC 0.65 1.88 1.70 0.50 1.18 1.03 Car 67.39 66.50 63.67 72.12 74.85 74.46 LT Bus 1.29 0.89 0.55 0.94 0.57 0.45 SU 4.98 5.23 6.14 5.01 3.31 3.54 CT 7.88 3.80 1.63 4.43 1.53 0.14 17.81 21.70 26.31 17.01 18.56 20.38
Summary 22 VMT by county and function class (total VMT) Truck VMT% for sample panel data (sample panel VMT) Vehicle class count data analysis (common time period) Combine AADT truck % data with vehicle class count data for all road function classes Derive the VMT by vehicle for all function class Group VMT by function class group and vehicle class group to obtain VMT and VMT%
23 Thank You! Office of Highway Policy Information FHWA 1200 New Jersey Avenue, SE, Washington, DC 20590
