Loading...
HomeMy WebLinkAbout2017-11-20-J02 Speed Limit Ordinance_Warrior Ln_INTRO, 1ST-3RD READJ2 Memorandum To: John Gibson, Waukee Public Works Director Date: 11/20/2017 From: Mark Perington, P.E., P.T.O.E CC: Rudy J. Koester, P.E., Waukee Asst. Public Works Director John F. Quinn, Waukee Chief of Police RE: Speed Limit Review Request Warrior Ln, North of Hickman Rd City of Waukee S&A Project Number: 117.0679.01 Location: Warrior Ln roadway segment between NE Sunrise Dr and NE Badger Ln Citizen Request/Concern: A request has been made to conduct a speed limit review on Warrior Ln. Evaluating the current and future traffic conditions could potentially result in lowering the current speed limits. There is concern within the neighborhood regarding the traffic flow through the residential area. Existing Conditions: Geometry: Warrior Ln is a two-lane major collector with 12 foot lanes and a urban cross section. All the intersections of Warrior Ln with NE Sunrise Dr, NE Grace Wood Dr, NE Fox Run Trail and NE Badger Ln are a “tee” or 3 leg intersections. There is currently a sidewalk on the east side of Warrior Ln which is set back approximately 30 feet from the edge of the road. All the side roads have sidewalks on both the north and south sides. NE Grace Wood Dr intersects Warrior Ln approximately 400-450 ft north of the crest of a vertical curve made by a 2.17% upgrade followed by 2.85% downgrade (for northbound traffic). Warrior Ln has no horizontal curvature and is met by all the side roads at a 90 degree horizontal angle. Warrior Ln Speed Review November 20, 2017 Page 2 of 5 Speed Limit: 25 mph on Side roads that include NE Sunrise Dr, NE Grace Wood Dr, NE Fox Run Trail and NE Badger Ln 35 mph on Warrior Ln (Hickman Rd to NE Sunrise Dr) 45 mph on Warrior Ln (NE Sunrise Dr to beyond NE Badger Ln) Traffic Control: All the side roads that meet Warrior Ln are stop sign controlled. There is a “Pavement Ends” sign 100 ft north of NE Grace Wood Dr. Parking is not permitted on either side of Warrior Ln. Passing vehicles is prohibited on Warrior Ln. Traffic Volumes: The City collected traffic counts by using road tubes at two locations on Warrior Ln. Date of Count: 11/1/2017 – 11/7/2017 Location of Count: Across Farrell’s Waukee which is located between NE Venture Dr and NE Sunrise Dr, and approximately 325 ft south of NE Grace Wood Dr intersection. Peak Hour Volumes: Farrell’s Peak Time Period NB Volume SB Volume Total AM 7:00-8:00 AM 68 150 218 PM 4:45-5:45 PM 121 126 247 Grace Wood Dr Peak Time Period NB Volume SB Volume Total AM 7:00-8:00 AM 56 117 173 PM 4:45-5:45 PM 98 106 204 Average Daily Volumes: Other: Farrell’s Time Period NB Average Volume SB Average Volume Total Weekday 1,010 1,070 2,080 Weekend 673 700 1,373 Grace Wood Dr Time Period NB Average Volume SB Average Volume Total Weekday 803 864 1,667 Weekend 518 531 1,049 See attached sheets for more detailed count data. Warrior Ln Speed Review November 20, 2017 Page 3 of 5 Speed: The City collected traffic speed data by using road tubes at two locations on Warrior Ln. Date of Study: 11/1/2017 – 11/7/2017 Average Speed: Location NB Speed (mph) SB speed (mph) Avg speed Farrell’s 31 30 31 Grace Wood Dr 37 37 37 85th %tile Speed: Location NB Speed (mph) SB speed (mph) Avg speed Farrell’s 37 36 37 Grace Wood Dr 43 43 43 Other: See attached sheets for more detailed speed data. Collision History: A total of 6 crashes were reported on Warrior Ln from 2012 – 2016. All the crashes reported were property damage only crashes and half of them were rear-end type crashes. Sight Distance: Due to the crest vertical curve on Warrior Ln near the NE Grace Wood Dr intersection, it is important to consider sight distances in evaluating the posted speed limit on the roadway. Warrior Ln Speed Review November 20, 2017 Page 4 of 5 Criteria: Analysis Performed: General Considerations: The American Associate of State Highway and Transportation Officials (AASHTO) produces A Policy on Geometric Design of Highways and Streets (Green Book). The Iowa DOT uses the information in The Green Book for its standards on vertical curvature design in its Statewide Urban Design and Specifications (SUDAS). Required sight distance in these documents (Intersection sight distance) is 500 ft for a design speed of 45 mph. The as-built plans for Warrior Ln were referred to determine the sight distance at NE Grace Wood Dr intersection. As recommended in the Green Book, a driver eye height of 3.5 ft was used to determine that there is approximately 550 ft of intersection sight distance for left turning vehicles from NE grace Wood Dr. While the provided sight distance meets the minimum requirements for intersection sight distance, it is just slightly above the minimum. The Green Book provides minimum sight distance for left turns from stop signs on the minor road which are summarized below: Design Speed (mph) Stopping Sight Distance (ft) Intersection Sight Distance (ft) 25 155 280 30 200 335 35 250 390 40 305 445 45 360 500 Similarly, stopping sight distance on Warrior Ln prior was also determined by using a driver eye height of 3.5 ft and an object height of 2 ft as recommended in the Green Book. The stopping sight distance was measured to be approximately 360 ft, which meets the minimum requirements. However, drivers going above the speed limit will not have adequate sight distance to make a complete stop if they come across an object on the road. Various studies have shown drivers tend to select speed in the absence of interference from traffic based on roadway characteristics such as geometry, lateral clearance to obstructions, driveway spacing, surrounding land use, and landscaping more than the posted speed limit. This appears to be the case on Warrior Ln as the average speed is around 35 mph and the 85th percentile speed is less than 45 mph. New development in the area on the west side will lead to addition construction traffic and additional street intersection approaches. This will result in more traffic conflicts. Warrior Ln Speed Review November 20, 2017 Page 5 of 5 Enforcement Issues: Following a conversation with the City police department, it is evident that there are no issues in speed enforcement. However, there have been complaints from the residents regarding drivers speeding through the residential area on NE Badger Ln. Recommendation: It is recommended that the speed limit for Warrior Ln between NE Sunrise Dr and NE Badger Ln be lowered to 35 mph. This would require the current posted speed limit signs to be replaced or removed. Lowering the speed limit to 35 mph will be consistent for drivers driving through to connect with Douglas Parkway. Residential area surrounding Warrior ln is expected to expand in the near future and having a lower speed limit will also provide safer roads for the neighborhood. Additionally, lowering the speed limit will improve intersection sight distance for drivers which is slightly above the minimum as of today. For interim basis, red flags should be added by the replaced signs to educate the motoring public for some period. Follow Up Action: Attachments: Speed enforcement should be present or a follow up speed data collection should take place following the change in speed limit to ensure that traffic speeds remain the same or lowered. • Road tube speed data • Road tube volume data • Record of construction drawing for Warrior Ln near NE Grace Wood Dr • Record of Crashes from the year 2012 to 2016 • Current Speed Limit Layout • Proposed Speed Limit Layout Project No:Speed Grand TotalsProjectLocation: 117.0679: Waukee, IA: Warrior Ln(Gracewood) Speed ReviewWednesday, 11/1/2017 3:00 PM -Tuesday, 11/7/2017 2:00 PM70 -< 20065 -< 7060 -< 6555 -< 6050 -< 5545 -< 5040 -< 4535 -< 4030 -< 3525 -< 3020 -< 2515 -< 200 -< 15TotalNBmphHourly Averages0.00.00.00.00.00.00.81.30.30.00.00.00.02.512:00 AM0.00.00.00.00.00.00.31.00.30.00.00.00.01.71:00 AM0.00.00.00.00.00.20.20.80.20.00.20.00.01.52:00 AM0.00.00.00.00.00.00.00.20.20.30.00.00.00.73:00 AM0.00.00.00.00.00.00.20.00.20.20.00.00.00.54:00 AM0.00.00.00.00.00.30.72.20.50.20.00.00.03.85:00 AM0.00.00.00.00.20.84.06.53.51.20.00.00.016.26:00 AM0.00.00.20.00.01.38.213.010.22.20.50.20.035.77:00 AM0.00.00.00.00.02.86.515.811.02.50.70.00.039.38:00 AM0.00.00.00.00.01.36.09.211.04.20.20.20.032.09:00 AM0.00.00.00.00.01.37.213.712.02.80.30.20.037.510:00 AM0.00.00.00.00.02.88.818.210.31.80.50.30.243.011:00 AM0.00.00.00.00.23.09.218.813.73.30.70.20.049.012:00 PM0.20.00.00.00.02.57.314.011.03.71.70.00.040.31:00 PM0.00.00.00.40.02.68.012.012.44.02.20.60.042.22:00 PM0.00.00.00.30.25.215.722.212.32.80.80.00.059.53:00 PM0.00.00.00.20.25.820.823.014.33.01.20.00.068.54:00 PM0.00.00.00.00.02.715.326.819.74.70.80.80.070.85:00 PM0.00.00.00.00.02.013.321.816.22.01.50.20.057.06:00 PM0.00.00.20.00.02.09.017.712.32.50.30.00.044.07:00 PM0.00.00.00.00.02.75.712.87.32.20.00.00.030.78:00 PM0.00.00.00.00.21.75.88.86.00.50.00.00.023.09:00 PM0.00.00.00.00.01.02.02.72.50.50.20.00.08.810:00 PM0.00.00.00.30.00.51.02.00.30.20.20.00.04.511:00 PM0.0 %170 -< 2000.20.0 %065 -< 700.00.0 %260 -< 650.30.2 %755 -< 601.20.1 %550 -< 550.86.0 %25345 -< 5042.621.9 %92840 -< 45156.037.2 %157535 -< 40264.526.3 %111430 -< 35187.76.2 %26425 -< 3044.71.6 %6920 -< 2511.90.4 %1515 -< 202.60.0 %10 -< 150.24234Total712.70.0 % (1)75 mph0.0 % (1)65 mph0.2 % (10)55 mph6.3 % (268)45 mph65.4 % (2771)35 mph43.890%42.685%37.250%32.415%Daily AverageStudy Grand TotalsNB31.7 - 41.7 mph 3071 vehicles (72.5 %)Speeds ExceededPercentile Speeds(mph)Pace Range10%30.425 mph98.0 % (4149)Average (Mean)36.9 mphMinimum14.2 mphMaximum82.7 mph2 Project No:Speed Grand TotalsProjectLocation: 117.0679: Waukee, IA: Warrior Ln(Gracewood) Speed ReviewWednesday, 11/1/2017 3:00 PM -Tuesday, 11/7/2017 2:00 PM70 -< 20065 -< 7060 -< 6555 -< 6050 -< 5545 -< 5040 -< 4535 -< 4030 -< 3525 -< 3020 -< 2515 -< 200 -< 15TotalCombinedmphHourly Averages0.00.00.00.00.00.21.32.01.30.00.00.00.04.812:00 AM0.00.00.00.00.00.20.51.71.00.00.00.00.03.31:00 AM0.00.00.00.00.00.20.21.00.50.20.20.00.02.22:00 AM0.00.00.00.00.00.00.00.20.20.30.00.00.00.73:00 AM0.00.00.00.00.00.71.32.31.20.30.00.00.05.84:00 AM0.00.00.00.00.01.84.78.84.31.00.00.00.020.75:00 AM0.00.00.00.00.22.211.318.57.32.00.00.20.041.76:00 AM0.00.00.20.20.86.024.735.522.84.01.70.20.096.07:00 AM0.00.00.00.20.58.224.843.026.76.01.20.30.0110.88:00 AM0.00.00.00.00.56.317.828.025.38.31.00.50.087.89:00 AM0.00.00.00.00.24.317.228.523.36.21.01.00.281.810:00 AM0.00.00.00.20.26.016.730.219.24.81.30.30.279.011:00 AM0.00.00.00.30.85.717.235.824.28.01.20.20.093.312:00 PM0.20.00.00.20.36.314.828.820.56.32.51.70.081.71:00 PM0.00.00.00.40.44.815.824.420.87.43.00.80.077.82:00 PM0.00.00.00.30.710.228.838.223.05.81.50.50.7109.73:00 PM0.00.00.00.20.711.035.746.524.86.01.30.80.7127.74:00 PM0.00.00.00.20.27.231.854.839.87.22.31.70.7145.85:00 PM0.00.00.00.00.24.025.245.234.85.31.70.71.3118.36:00 PM0.00.00.20.00.02.714.029.522.24.70.70.00.073.87:00 PM0.00.00.00.00.04.08.221.314.84.20.20.00.052.78:00 PM0.00.00.00.00.21.87.513.09.31.80.20.00.033.89:00 PM0.00.00.00.00.01.23.05.03.80.70.20.00.013.810:00 PM0.00.00.00.30.00.51.72.50.80.20.20.00.06.211:00 PM0.0 %170 -< 2000.20.0 %065 -< 700.00.0 %260 -< 650.30.2 %1455 -< 602.40.4 %3450 -< 555.76.5 %56745 -< 5095.322.1 %192940 -< 45324.137.1 %324435 -< 40544.725.3 %221230 -< 35372.16.1 %53725 -< 3090.71.4 %12420 -< 2521.20.6 %5215 -< 208.80.3 %220 -< 153.78738Total1469.30.0 % (1)75 mph0.0 % (1)65 mph0.2 % (17)55 mph7.1 % (618)45 mph66.3 % (5791)35 mph43.890%42.685%37.250%32.415%Daily AverageStudy Grand TotalsCombined31.7 - 41.7 mph 6264 vehicles (71.7 %)Speeds ExceededPercentile Speeds(mph)Pace Range10%30.425 mph97.7 % (8540)Average (Mean)37.0 mphMinimum10.8 mphMaximum82.7 mph0.0 %10.0 %00.0 %00.0 %00.0 %20.0 %00.2 %70.2 %70.1 %50.6 %296.0 %2537.0 %31421.9 %92822.2 %100137.2 %157537.1 %166926.3 %111424.4 %10986.2 %2646.1 %2731.6 %691.2 %550.4 %150.8 %370.0 %10.5 %2142344504SBNB3 Project NoSpeed Grand TotalsProject:Location: 117.0679.01: Waukee, IA: Warrior Ln (Farrells) Speed ReviewWednesday, 11/1/2017 3:00 PM -Tuesday, 11/7/2017 2:00 PM70 -< 20065 -< 7060 -< 6555 -< 6050 -< 5545 -< 5040 -< 4535 -< 4030 -< 3525 -< 3020 -< 2515 -< 200 -< 15TotalSBmphHourly Averages0.00.00.00.00.00.00.20.51.50.80.00.00.03.012:00 AM0.00.00.00.00.00.00.20.70.70.70.00.00.02.21:00 AM0.00.00.00.00.00.00.00.30.20.30.00.00.00.82:00 AM0.00.00.00.00.00.00.00.00.00.50.00.00.00.53:00 AM0.00.00.00.00.00.00.30.50.70.83.30.70.06.34:00 AM0.00.00.00.00.00.20.50.82.53.810.22.20.020.25:00 AM0.00.00.00.00.00.00.83.59.06.510.21.20.031.26:00 AM0.00.00.00.00.00.34.216.731.217.85.81.50.277.77:00 AM0.00.00.00.00.00.53.216.232.717.514.34.00.288.58:00 AM0.00.00.00.00.20.22.59.520.015.215.05.50.568.59:00 AM0.00.00.00.00.00.21.38.316.511.513.85.50.357.510:00 AM0.00.00.00.00.00.21.78.713.511.88.01.20.245.211:00 AM0.00.00.00.00.20.52.310.019.212.27.72.70.254.812:00 PM0.00.00.00.00.00.72.38.818.512.27.83.00.353.71:00 PM0.00.00.00.00.00.21.89.015.010.68.61.20.446.82:00 PM0.00.00.00.00.00.23.711.820.714.59.02.30.562.73:00 PM0.00.00.00.00.00.24.812.227.812.512.72.51.774.34:00 PM0.00.00.00.00.00.31.815.831.715.516.04.71.587.35:00 PM0.00.00.00.00.00.01.08.527.820.014.75.22.279.36:00 PM0.00.00.00.00.00.20.73.513.77.38.32.50.336.57:00 PM0.00.00.00.00.00.00.82.88.09.75.81.00.028.28:00 PM0.00.00.00.00.00.00.20.75.24.53.00.30.013.89:00 PM0.00.00.00.00.00.00.51.23.21.21.30.20.27.710:00 PM0.00.00.00.00.00.00.00.71.51.00.30.00.23.711:00 PM0.0 %070 -< 2000.00.0 %065 -< 700.00.0 %060 -< 650.00.0 %055 -< 600.00.0 %250 -< 550.30.4 %2245 -< 503.73.7 %20740 -< 4534.815.8 %89535 -< 40150.733.7 %190830 -< 35320.521.9 %124025 -< 30208.418.5 %104720 -< 25175.95.0 %28215 -< 2047.20.9 %520 -< 158.75655Total950.30 % (0)75 mph0 % (0)65 mph0 % (0)55 mph0.4 % (24)45 mph19.9 % (1126)35 mph37.290%36.385%30.450%22.615%Daily AverageStudy Grand TotalsSB26.6 - 36.6 mph 3363 vehicles (59.5 %)Speeds ExceededPercentile Speeds(mph)Pace Range10%21.325 mph75.6 % (4274)Average (Mean)29.9 mphMinimum10.3 mphMaximum53.2 mph1 Project NoSpeed Grand TotalsProject:Location: 117.0679.01: Waukee, IA: Warrior Ln (Farrells) Speed ReviewWednesday, 11/1/2017 3:00 PM -Tuesday, 11/7/2017 2:00 PM70 -< 20065 -< 7060 -< 6555 -< 6050 -< 5545 -< 5040 -< 4535 -< 4030 -< 3525 -< 3020 -< 2515 -< 200 -< 15TotalNBmphHourly Averages0.00.00.00.00.00.00.21.01.30.50.20.00.03.212:00 AM0.00.00.00.00.00.00.21.70.80.50.00.00.03.21:00 AM0.00.00.00.00.00.00.00.80.70.20.20.00.01.82:00 AM0.00.00.00.00.00.00.00.20.20.80.00.00.01.23:00 AM0.00.00.00.00.00.00.00.20.00.20.20.00.00.54:00 AM0.00.00.00.00.00.00.20.70.80.51.80.70.04.75:00 AM0.00.00.00.00.00.00.72.04.72.77.32.20.219.76:00 AM0.00.00.00.00.20.21.510.014.84.29.81.80.042.57:00 AM0.00.00.00.20.00.21.811.518.07.34.02.20.345.58:00 AM0.00.00.00.00.00.21.74.814.57.85.72.80.337.89:00 AM0.00.00.00.00.00.50.88.016.07.810.52.70.546.810:00 AM0.00.00.00.00.00.32.89.716.710.010.34.20.554.511:00 AM0.00.00.00.00.00.84.513.522.010.36.23.00.360.712:00 PM0.00.00.00.00.00.23.211.520.37.04.72.20.049.01:00 PM0.00.00.00.00.20.43.813.019.27.85.83.20.253.62:00 PM0.00.00.00.20.01.26.025.826.09.85.51.70.576.73:00 PM0.00.00.00.00.00.85.327.230.712.38.01.70.386.34:00 PM0.00.00.00.00.00.22.521.333.716.310.34.30.389.05:00 PM0.00.00.00.00.00.23.012.026.813.810.83.20.370.26:00 PM0.00.00.00.00.00.21.810.220.89.89.34.00.256.37:00 PM0.00.00.00.00.00.52.08.214.77.06.73.70.042.78:00 PM0.00.00.00.00.00.31.85.712.56.03.31.20.030.89:00 PM0.00.00.00.00.00.20.53.86.32.21.70.50.215.310:00 PM0.00.00.00.20.20.20.71.83.31.80.00.20.08.311:00 PM0.0 %070 -< 2000.00.0 %065 -< 700.00.0 %060 -< 650.00.1 %355 -< 600.50.1 %350 -< 550.50.7 %3845 -< 506.45.0 %26640 -< 4545.022.7 %121435 -< 40204.536.1 %193030 -< 35324.916.3 %87325 -< 30146.813.6 %72820 -< 25122.35.0 %26815 -< 2045.20.5 %250 -< 154.25348Total900.30 % (0)75 mph0 % (0)65 mph0.1 % (3)55 mph0.8 % (44)45 mph28.5 % (1524)35 mph38.290%37.285%32.450%23.315%Daily AverageStudy Grand TotalsNB29.2 - 39.2 mph 3451 vehicles (64.5 %)Speeds ExceededPercentile Speeds(mph)Pace Range10%21.625 mph80.9 % (4327)Average (Mean)31.2 mphMinimum10.3 mphMaximum59.6 mph2 Project NoSpeed Grand TotalsProject:Location: 117.0679.01: Waukee, IA: Warrior Ln (Farrells) Speed ReviewWednesday, 11/1/2017 3:00 PM -Tuesday, 11/7/2017 2:00 PM70 -< 20065 -< 7060 -< 6555 -< 6050 -< 5545 -< 5040 -< 4535 -< 4030 -< 3525 -< 3020 -< 2515 -< 200 -< 15TotalCombinedmphHourly Averages0.00.00.00.00.00.00.31.52.81.30.20.00.06.212:00 AM0.00.00.00.00.00.00.32.31.51.20.00.00.05.31:00 AM0.00.00.00.00.00.00.01.20.80.50.20.00.02.72:00 AM0.00.00.00.00.00.00.00.20.21.30.00.00.01.73:00 AM0.00.00.00.00.00.00.30.70.71.03.50.70.06.84:00 AM0.00.00.00.00.00.20.71.53.34.312.02.80.024.85:00 AM0.00.00.00.00.00.01.55.513.79.217.53.30.250.86:00 AM0.00.00.00.00.20.55.726.746.022.015.73.30.2120.27:00 AM0.00.00.00.20.00.75.027.750.724.818.36.20.5134.08:00 AM0.00.00.00.00.20.34.214.334.523.020.78.30.8106.39:00 AM0.00.00.00.00.00.72.216.332.519.324.38.20.8104.310:00 AM0.00.00.00.00.00.54.518.330.221.818.35.30.799.711:00 AM0.00.00.00.00.21.36.823.541.222.513.85.70.5115.512:00 PM0.00.00.00.00.00.85.520.338.819.212.55.20.3102.71:00 PM0.00.00.00.00.20.65.622.034.218.414.44.40.6100.42:00 PM0.00.00.00.20.01.39.737.746.724.314.54.01.0139.33:00 PM0.00.00.00.00.01.010.239.358.524.820.74.22.0160.74:00 PM0.00.00.00.00.00.54.337.265.331.826.39.01.8176.35:00 PM0.00.00.00.00.00.24.020.554.733.825.58.32.5149.56:00 PM0.00.00.00.00.00.32.513.734.517.217.76.50.592.87:00 PM0.00.00.00.00.00.52.811.022.716.712.54.70.070.88:00 PM0.00.00.00.00.00.32.06.317.710.56.31.50.044.79:00 PM0.00.00.00.00.00.21.05.09.53.33.00.70.323.010:00 PM0.00.00.00.20.20.20.72.54.82.80.30.20.212.011:00 PM0.0 %070 -< 2000.00.0 %065 -< 700.00.0 %060 -< 650.00.0 %355 -< 600.50.0 %550 -< 550.90.5 %6045 -< 5010.14.3 %47340 -< 4579.819.2 %210935 -< 40355.234.9 %383830 -< 35645.419.2 %211325 -< 30355.216.1 %177520 -< 25298.25.0 %55015 -< 2092.40.7 %770 -< 1512.911003Total1850.60 % (0)75 mph0 % (0)65 mph0.0 % (3)55 mph0.6 % (68)45 mph24.1 % (2650)35 mph38.290%36.385%31.750%22.615%Daily AverageStudy Grand TotalsCombined27.6 - 37.6 mph 6723 vehicles (61.1 %)Speeds ExceededPercentile Speeds(mph)Pace Range10%21.325 mph78.2 % (8601)Average (Mean)30.5 mphMinimum10.3 mphMaximum59.6 mph0.0 %00.0 %00.0 %00.0 %00.0 %00.0 %00.1 %30.0 %00.1 %30.0 %20.7 %380.4 %225.0 %2663.7 %20722.7 %121415.8 %89536.1 %193033.7 %190816.3 %87321.9 %124013.6 %72818.5 %10475.0 %2685.0 %2820.5 %250.9 %5253485655SBNB3 Project No:Weekly VolumeProjectLocation: 117.0679: Waukee, IA: Warrior Ln(Gracewood) Speed ReviewInterval StartMon10/30/2017Tue10/31/2017Fri11/3/2017Wed11/1/2017Thu11/2/2017Sat11/4/2017Sun11/5/2017Mon - FriAverageWeekly AverageSB NBNBSBNBSBNBSBNBSBNBSBNBSBNBSBNBSB12:00 AM---12451.53.0---13622.03.01:00 AM---01240.51.8---10350.52.32:00 AM---00110.00.5---30231.52.03:00 AM---00000.00.0---10020.50.84:00 AM - - - 11 17 2 0 14.0 7.5---00300.00.85:00 AM---29315130.016.5---108009.04.56:00 AM - - - 41 33 15 3 37.0 23.0---32355333.518.87:00 AM---124109275116.566.3---565613656.032.88:00 AM - - - 52 62 60 14 57.0 47.0---4135301338.029.89:00 AM---5765493861.052.3---3539421137.031.810:00 AM - - - 26 46 51 47 36.0 42.5---4442401643.035.511:00 AM---2831464929.538.5---5837494547.547.312:00 PM - - - 57 56 42 45 56.5 50.0---4345545644.049.51:00 PM---3348334440.539.5---3726394831.537.52:00 PM - - 8 33 42 32 39 37.5 36.5--54142444341.542.53:00 PM--436468384258.351.0--5110292394581.765.84:00 PM - - 78 79 78 26 40 78.3 60.2--699476335579.765.45:00 PM--11310581433999.776.2--8711090243895.769.86:00 PM - - 87 62 44 38 35 64.3 53.2--716245353659.349.87:00 PM--272621192124.722.8--444641252643.736.48:00 PM - - 32 23 18 16 10 24.3 19.8--493818191635.028.09:00 PM--414101199.39.6--132323191719.719.010:00 PM--657436.05.0--6810688.07.611:00 PM--112411.31.8--524763.74.812:00 AM - 12:00 PMVolumePeak HoursTotals0 0 399 871 872Factor568 495 883.8 724.40.880.960.670.910.940.860.880.640.610.780.790.89------47.366.356.0116.5455549615610960124------11:00 AM7:00 AM7:00 AM7:00 AM11:00 AM9:30 AM11:00 AM8:30 AM7:00 AM7:00 AM7:15 AM7:00 AM------Volume12:00 PM - 12:00 AM0.900.760.910.760.850.820.750.720.840.790.800.800.920.72----75.279.6100.0106.058495443948511811888115----4:30 PM4:45 PM4:30 PM4:45 PM3:45 PM12:45 PM12:00 PM4:45 PM4:30 PM4:30 PM4:30 PM4:45 PM4:30 PM4:45 PM----Factor0 0 400 888 767 537 500 811.8 685.1Combined007991759163911059951695.71409.5Split (%)49.550.153.250.549.9----47.952.148.651.450.351.446.849.748.61 Project No:Weekly VolumeProjectLocation: 117.0679: Waukee, IA: Warrior Ln(Gracewood) Speed ReviewInterval StartMon11/6/2017Tue11/7/2017Fri11/10/2017Wed11/8/2017Thu11/9/2017Sat11/11/2017Sun11/12/2017Mon - FriAverageWeekly AverageSB NBNBSBNBSBNBSBNBSBNBSBNBSBNBSBNBSB12:00 AM 02-----1.01.012-----1.51.51:00 AM21-----1.51.501-----0.50.52:00 AM 1 1 - - - - - 1.0 1.001-----0.50.53:00 AM00-----0.00.010-----0.50.54:00 AM 2 0 - - - - - 1.0 1.000-----0.00.05:00 AM2114-----17.517.523-----2.52.56:00 AM 31 30 - - - - - 30.5 30.51210-----11.011.07:00 AM5245-----48.548.54340-----41.541.58:00 AM 123 118 - - - - - 120.5 120.56750-----58.558.59:00 AM6066-----63.063.03332-----32.532.510:00 AM 46 50 - - - - - 48.0 48.03647-----41.541.511:00 AM2438-----31.031.03435-----34.534.512:00 PM 28 38 - - - - - 33.0 33.03759-----48.048.01:00 PM4248-----45.045.04646-----46.046.02:00 PM 32 8 - - - - - 32.0 32.04113-----41.041.03:00 PM46------46.046.028------28.028.04:00 PM 54 - - - - - - 54.0 54.084------84.084.05:00 PM69------69.069.076------76.076.06:00 PM 102 - - - - - - 102.0 102.093------93.093.07:00 PM65------65.065.082------82.082.08:00 PM 33 - - - - - - 33.0 33.044------44.044.09:00 PM17------17.017.043------43.043.010:00 PM 5 - - - - - - 5.0 5.015------15.015.011:00 PM1------1.01.03------3.03.012:00 AM - 12:00 PMVolumePeak HoursTotals856459000Factor0 0 865.5 865.50.840.900.840.90----------0.690.820.890.8358.5120.558.5120.5----------50118681237:45 AM8:00 AM7:45 AM8:00 AM----------8:00 AM8:00 AM7:45 AM8:00 AMVolume12:00 PM - 12:00 AM0.880.650.880.65----------0.950.800.880.6595.0106.095.0106.0----------6148951065:45 PM5:45 PM5:45 PM5:45 PM----------12:15 PM12:45 PM5:45 PM5:45 PMFactor82133900000828.0 828.0Combined1677798 000001693.5 1693.5Split (%)-----49.051.042.557.548.951.148.951.1-----2Note: Road tube counters do not adapt to daylight savings time. Project NoWeekly VolumeProject:Location: 117.0679.01: Waukee, IA: Warrior Ln (Farrells) Speed ReviewInterval StartMon10/30/2017Tue10/31/2017Fri11/3/2017Wed11/1/2017Thu11/2/2017Sat11/4/2017Sun11/5/2017Mon - FriAverageWeekly AverageSB NBNBSBNBSBNBSBNBSBNBSBNBSBNBSBNBSB12:00 AM---12671.54.0---14722.53.51:00 AM---02251.02.3---113121.04.32:00 AM---00120.00.8---31242.02.53:00 AM---11011.00.8---10220.51.34:00 AM - - - 13 18 2 1 15.5 8.5---00200.00.55:00 AM---35386136.520.0---9121110.55.86:00 AM - - - 52 42 17 3 47.0 28.5---40407340.022.57:00 AM---157141378149.085.8---7258141065.038.58:00 AM - - - 72 71 67 16 71.5 56.5---4941341345.034.39:00 AM---7178624974.565.0---4044521442.037.510:00 AM - - - 33 60 72 58 46.5 55.8---5353531853.044.311:00 AM---3849605643.550.8---7456625165.060.812:00 PM - - - 64 67 56 54 65.5 60.3---5362696257.561.51:00 PM---4156515848.551.5---4231525936.546.02:00 PM - - 27 40 53 43 57 46.5 48.3--235351576152.055.53:00 PM--567678525670.063.6--771161095858100.783.64:00 PM - - 106 97 91 39 52 98.0 77.0--911111004767100.783.25:00 PM--1351131025148116.789.8--1141301193246121.088.26:00 PM - - 102 81 64 51 50 82.3 69.6--797359435470.361.67:00 PM--363526242832.329.8--636055333459.349.08:00 PM - - 36 29 23 21 20 29.3 25.8--675329262349.739.69:00 PM--71415141312.012.6--203331282428.027.210:00 PM - - 6 7 12 11 4 8.3 8.0--101318151013.713.211:00 PM--205922.33.6--74101187.08.012:00 AM - 12:00 PMVolumePeak HoursTotals0 0 513 1070 1094Factor754 649 1099.3 918.30.910.870.710.830.850.880.780.890.580.800.850.85------60.885.868.0149.0516762825814178157------11:00 AM7:00 AM7:15 AM7:00 AM11:00 AM9:30 AM9:15 AM9:45 AM7:00 AM7:00 AM7:15 AM7:00 AM------Volume12:00 PM - 12:00 AM0.910.820.910.830.820.750.750.700.800.850.810.860.950.78----93.694.0124.3124.369636956119102136137118137----4:30 PM4:30 PM4:30 PM4:45 PM3:45 PM12:45 PM12:00 PM12:00 PM4:30 PM5:00 PM4:30 PM4:45 PM4:30 PM5:15 PM----Factor0 0 551 1084 984 710 636 1022.8 872.1Combined00106421542078146412852122.21790.4Split (%)49.751.852.650.348.2----48.251.848.751.349.551.547.450.548.51 Project NoWeekly VolumeProject:Location: 117.0679.01: Waukee, IA: Warrior Ln (Farrells) Speed ReviewInterval StartMon11/6/2017Tue11/7/2017Fri11/10/2017Wed11/8/2017Thu11/9/2017Sat11/11/2017Sun11/12/2017Mon - FriAverageWeekly AverageSB NBNBSBNBSBNBSBNBSBNBSBNBSBNBSBNBSB12:00 AM 02-----1.01.032-----2.52.51:00 AM22-----2.02.002-----1.01.02:00 AM 1 1 - - - - - 1.0 1.001-----0.50.53:00 AM00-----0.00.011-----1.01.04:00 AM 3 1 - - - - - 2.0 2.010-----0.50.55:00 AM2417-----20.520.532-----2.52.56:00 AM 36 37 - - - - - 36.5 36.51315-----14.014.07:00 AM6558-----61.561.55051-----50.550.58:00 AM 154 151 - - - - - 152.5 152.57363-----68.068.09:00 AM7972-----75.575.53740-----38.538.510:00 AM 59 63 - - - - - 61.0 61.04559-----52.052.011:00 AM3038-----34.034.04341-----42.042.012:00 PM 36 52 - - - - - 44.0 44.04771-----59.059.01:00 PM5759-----58.058.06050-----55.055.02:00 PM 41 11 - - - - - 41.0 41.04617-----46.046.03:00 PM58------58.058.042------42.042.04:00 PM 61 - - - - - - 61.0 61.0102------102.0102.05:00 PM75------75.075.093------93.093.06:00 PM 128 - - - - - - 128.0 128.0113------113.0113.07:00 PM70------70.070.093------93.093.08:00 PM 40 - - - - - - 40.0 40.058------58.058.09:00 PM20------20.020.049------49.049.010:00 PM 6 - - - - - - 6.0 6.026------26.026.011:00 PM4------4.04.010------10.010.012:00 AM - 12:00 PMVolumePeak HoursTotals1049 564000Factor0 0 1052.5 1052.50.830.890.830.89----------0.770.770.910.8468.0152.568.0152.5----------65151731548:00 AM8:00 AM8:00 AM8:00 AM----------8:15 AM8:00 AM8:00 AM8:00 AMVolume12:00 PM - 12:00 AM0.840.640.840.64----------0.930.820.840.64118.0128.0118.0128.0----------78591181285:45 PM6:00 PM5:45 PM6:00 PM----------12:15 PM1:00 PM5:45 PM6:00 PMFactor1008 415000001019.0 1019.0Combined2057979 000002071.5 2071.5Split (%)-----49.051.042.457.649.250.849.250.8-----2Note: Road Tube Counters do not adapt to daylight savings time. Major Cause Summary Report Version 1.1 Jan 2005 Warrior Ln Total Crashes Animal Improper Backing Ran Traffic Signal Illegally Parked/Unattended Ran Stop Sign Swerving/Evasive Action Crossed Centerline Over-Correcting/Over-Steering FTYROW: At Uncontrolled Intersection Downhill Runaway FTYROW: Making Right Turn on Red Signal Equipment Failure FTYROW: From Stop Sign1 Separation of Units FTYROW: From Yield Sign Ran Off Road - Right Major Cause Summary: FTYROW: Making Left Turn Ran Off Road - Straight FTYROW: From Driveway Ran Off Road - Left FTYROW: From Parked Position Lost Control FTYROW: To Pedestrian Inattentive/Distracted By: Passenger1 FTYROW: Other (explain in narrative)1 Inattentive/Distracted By: Use of Phone or Other Traveling Wrong Way or on Wrong Side of Rd Inattentive/Distracted By: Fallen Object Driving Too Fast for Conditions Inattentive/Distracted By: Fatigued/Asleep Exceeded Authorized Speed Other: Vision Obstructed Made Improper Turn Oversized Load/ Oversized Vehicle Improper Lane Change Cargo/Equipment Loss or Shift Followed Too Close1 Other: Other Improper Action1 Disregarded Railroad Signal Unknown Disregarded Warning Sign Other: No Improper Action1 Operating Vehicle in Reckless/Aggressive Manner None Indicated Crash Summary: Fatal Major Injury Minor Injury Possible/Unknown PDO - - - - 6 - - - - - $35,500TOT Property Damage: Fatal Major Injury Minor Injury Possible Unknown Injury Summary: 2013 [2], 2014 [1], 2015 [1], 2016 [2] Dry Wet Ice Snow Slush 4 2 - - - Sand/Dirt/Oil/Gravel Water Other Unknown Not Reported - - - - - Analysis Years: Surface Condition Summary: Total Injuries60 Total Crashes 6$5,917AVG Property Damage: Crash Mapping Analysis Tool11/9/2017 Selection Filter: ((YEAR <> 2007 and YEAR <> 2008 and YEAR <> 2009 and YEAR <> 2010 and YEAR <> 2011)) Analyst:Karthik Notes: 11Page:of 11/10/2017 Google Maps https://www.google.com/maps/@41.6200989,-93.8706334,818m/data=!3m1!1e3?hl=en 1/1 Imagery ©2017 Google, Map data ©2017 Google 200 ft 11/10/2017 Google Maps https://www.google.com/maps/@41.6200989,-93.8706334,818m/data=!3m1!1e3?hl=en 1/1 Imagery ©2017 Google, Map data ©2017 Google 200 ft