Penshurst "Local Area Traffic Management" The local community of Penshurst, situated in the Georges River Local Government Area are concerned about road traffic congestion and speeding within the vicinity of Penshurst Street and Forest Road. The specific area of concern is presented in Figure 1. Forest Road Forest Road Figure 1: Penshurst Study Area The study area consists of a number of different land uses including a school, churches, leisure centre, and at the southern end of Penshurst Street, the Penshurst town centre and Penshurst Train Station. Your consultancy firm has been asked by governing authorities to complete an assessment of the traffic conditions to quantify, evaluate and resolve some of the communities concerns. As the lead Traffic Engineer, you are faced with the problems described in the following pages of the brief. Prepare a response to each of the problems in the form of a brief report (technical note). Ensure you succinctly present any working or descriptions of methodology and use summary tables to display your results. Do not provide an excel spreadsheet as a response. Problem 1: Speeding near Penshurst Public School Residents have notified the presence of speeding vehicles travelling northbound along Penshurst Street, following the intersection of Forest Road (refer to Figure 2). In order to investigate the complaint, a pneumatic tube traffic survey was conducted on 19th of May 2021 to collect flow and speed data for Penshurst Street (for vehicles travelling northbound), at the location identified in Figure 2. The survey was conducted between 8:00AM and 9:00AM where the school zone speed limit of 40km/hr was in effect. shurst Street !!! Penshurst Public School 1 1 Observation Time (km/hr) Observation 445 446 447 227 Speed (km/hr) 53 37.5 31.2 38.7 37.8 39 39.1 37.5 35.9 31.2 38.2 41.2 33.3 33.9 40.3 35.9 230 41.3 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 8:53:10 AM 8:53:18 AM 8:53:28 AM 8:53:43 AM 8:53:54 AM 8:54:05 AM 8:54:15 AM 8:54:20 AM 8:54:24 AM 8:54:40 AM 8:54:51 AM 8:55:09 AM 8:55:15 AM 8:55:21 AM 8:55:27 AM 8:55:30 AM 8:55:35 AM 8:55:40 AM 8:55:44 AM 8:55:49 AM 8:56:04 AM 8:56:08 AM 8:56:24 AM 8:56:30 AM 8:56:39 AM 8:56:47 AM 8:56:53 AM 8:57:05 AM 8:57:18 AM 8:57:25 AM 8:57:34 AM 8:57:58 AM 8:58:02 AM 8:58:09 AM 8:58:14 AM 8:59:21 AM 8:59:29 AM 244 37.2 30.4 39.7 38 34.6 35.9 39.9 35 36.9 34.1 32.9 36.4 36.8 34.6 42.7 36.1 34 38.8 34.9 36.8 35.2 35.1 258 481 33.2 290 32.2 309 28.1 Assignment 1 - Speed Data Location: Northbound, Penshurst Street, Penshurst, NSW, 2222 Date, Time: 19/05/2021, 8:00AM to 9:00AM Weather: Fine (no inclement weather) Notes: Normal traffic conditions, no unusual disruptions Speed Observation Time Time Speed (km/hr 1 8:00:01 AM 35.1 223 8:26:56 AM 33.6 2 8:00:14 AM 38 224 8:27:01 AM 37.2 3 8:00:22 AM 39.1 225 8:27:06 AM 36.1 4 8:00:33 AM 36.9 226 8:27:15 AM 35.1 5 8:00:41 AM 36.8 8:27:21 AM 31 6 8:00:45 AM 34.5 228 8:27:26 AM 40.8 7 8:00:53 AM 36 229 8:27:30 AM 34.7 8 8:00:57 AM 36.8 8:27:37 AM 33.2 9 8:01:02 AM 38.8 231 8:27:45 AM 32.4 10 8:01:08 AM 33.5 232 8:27:56 AM 30.6 11 8:01:15 AM 36.3 233 8:28:03 AM 36.7 12 8:01:19 AM 34.7 234 8:28:09 AM 37.6 13 8:01:22 AM 33.2 235 8:28:13 AM 33.8 14 8:01:29 AM 37.1 236 8:28:22 AM 34.6 15 8:01:33 AM 36.3 237 8:28:28 AM 32.5 16 8:01:36 AM 36.7 238 8:28:31 AM 42.8 17 8:01:45 AM 35.9 239 8:28:37 AM 38.2 18 8:01:55 AM 33.9 240 8:28:44 AM 34.9 19 8:02:03 AM 34.9 241 8:28:51 AM 32.6 20 8:02:15 AM 32.6 242 8:28:59 AM 34.9 21 8:02:25 AM 31.4 243 8:29:06 AM 29 22 8:02:33 AM 38.9 8:29:11 AM 28.4 23 8:02:41 AM 245 8:29:25 AM 37.6 24 8:02:55 AM 33 246 8:29:29 AM 32.9 25 8:03:00 AM 32.3 247 8:29:35 AM 39.8 26 8:03:28 AM 34 248 8:29:45 AM 32.8 27 8:03:35 AM 32.1 249 8:29:57 AM 28 8:03:45 AM 33.8 250 8:30:01 AM 30.1 29 8:03:51 AM 34.1 251 8:30:07 AM 34.6 30 8:04:12 AM 32 252 8:30:11 AM 32.4 31 8:04:23 AM 31.7 253 8:30:18 AM 35.6 32 8:04:31 AM 31.8 254 8:30:27 AM 35.9 33 8:04:37 AM 36.2 255 8:30:34 AM 36.7 34 8:04:47 AM 27.5 256 8:30:39 AM 32.6 35 8:05:03 AM 32.7 257 8:30:44 AM 38.1 36 8:05:22 AM 28.6 8:30:48 AM 35.1 37 8:05:30 AM 30.6 259 8:30:57 AM 32.5 38 8:05:35 AM 30.2 260 8:31:05 AM 28.7 39 8:05:38 AM 29.2 261 8:31:13 AM 29.5 40 8:05:45 AM 37.6 262 8:31:20 AM 32.7 41 8:05:54 AM 37.9 263 8:31:27 AM 34 42 8:06:05 AM 35.2 264 8:31:35 AM 37.7 43 8:06:09 AM 29.3 265 8:31:41 AM 34.6 44 8:06:16 AM 36.4 266 8:31:48 AM 30 45 8:06:24 AM 32.0 267 8:31:55 AM 35.7 46 8:06:29 AM 36.3 268 8:32:00 AM 34.8 47 8:06:32 AM 29.4 269 8:32:06 AM 33 48 8:06:43 AM 34.0 270 8:32:12 AM 28.8 49 8:06:50 AM 35.1 271 8:32:19 AM 31 50 8:06:56 AM 31.6 272 8:32:26 AM 29.5 51 8:07:08 AM 39.0 273 8:32:33 AM 29 52 8:07:15 AM 33.4 274 8:32:40 AM 35.5 53 8:07:19 AM 36.1 275 8:32:47 AM 31 54 8:07:22 AM 29.3 276 8:32:53 AM 27.5 55 8:07:28 AM 36.3 277 8:33:00 AM 31.1 56 8:07:32 AM 37.9 278 8:33:07 AM 32.5 57 8:07:43 AM 36.7 279 8:33:14 AM 37.3 58 8:07:50 AM 35.6 280 8:33:22 AM 37.2 59 8:08:03 AM 39.1 281 8:33:29 AM 33.3 60 8:08:17 AM 35.1 282 8:33:36 AM 28.7 61 8:08:26 AM 28.2 283 8:33:43 AM 31.4 8:08:36 AM 33.7 284 8:33:50 AM 50.7 63 8:08:41 AM 31.0 285 8:33:56 AM 34.6 64 8:08:46 AM 32.2 286 8:34:02 AM 32.5 65 8:08:51 AM 32.8 287 8:34:10 AM 66 8:08:58 AM 31.6 288 8:34:17 AM 35.1 67 8:09:03 AM 37.0 289 8:34:25 AM 38 68 8:09:13 AM 30.7 8:34:31 AM 33.8 69 8:09:25 AM 34.6 291 8:34:37 AM 50 70 8:09:32 AM 29.7 292 8:34:45 AM 29.2 71 8:09:40 AM 38.0 293 8:34:50 AM 35.1 72 8:09:48 AM 31.4 294 8:34:55 AM 35.4 73 8:10:01 AM 34.4 295 8:35:01 AM 34.4 74 8:10:12 AM 36.9 296 8:35:05 AM 37.3 75 8:10:19 AM 32.0 297 8:35:09 AM 34.2 76 8:10:28 AM 298 8:35:15 AM 36.4 77 8:10:33 AM 37.4 299 8:35:23 AM 36.7 78 8:10:43 AM 33.5 300 8:35:30 AM 30.3 79 8:10:50 AM 35.5 301 8:35:40 AM 35.7 80 8:10:56 AM 33.3 302 8:35:54 AM 33.7 81 8:11:05 AM 28.2 303 8:36:06 AM 38.7 82 8:11:15 AM 32.4 304 8:36:18 AM 34.7 83 8:11:19 AM 30.9 305 8:36:28 AM 35.3 84 8:11:23 AM 29.0 306 8:36:32 AM 32.8 85 8:11:28 AM 37.9 307 8:36:35 AM 36.5 86 8:11:34 AM 38.5 308 8:36:40 AM 29.6 87 8:11:41 AM 28.6 8:36:48 AM 28.5 88 8:11:48 AM 28.8 310 8:36:59 AM 29.6 89 8:11:55 AM 33.6 311 8:37:06 AM 32.3 90 8:12:01 AM 40.9 312 8:37:13 AM 28.8 91 8:12:08 AM 29.1 313 8:37:20 AM 32.9 92 8:12:14 AM 34.8 314 8:37:26 AM 34 93 8:12:21 AM 31.7 315 8:37:32 AM 30.6 94 8:12:26 AM 316 8:37:37 AM 30.4 95 8:12:33 AM 30.5 317 8:37:42 AM 32.8 96 8:12:42 AM 33.5 318 8:37:48 AM 36.1 97 8:12:52 AM 36.9 319 8:37:53 AM 38.8 98 8:13:02 AM 32.4 320 8:38:08 AM 33.2 99 8:13:05 AM 37.7 321 8:38:18 AM 34.2 100 8:13:09 AM 30.7 322 8:38:22 AM 37.7 101 8:13:28 AM 32.5 323 8:38:32 AM 29.1 102 8:13:35 AM 28.6 324 8:38:36 AM 35.9 103 8:13:41 AM 37.2 325 8:38:40 AM 36.9 104 8:13:53 AM 38.5 326 8:38:50 AM 43 105 8:13:59 AM 37.8 327 8:38:54 AM 36.7 106 8:14:05 AM 31.0 328 8:39:01 AM 42.1 107 8:14:08 AM 35.1 329 8:39:05 AM 36.1 108 8:14:21 AM 330 8:39:10 AM 29.9 109 8:14:25 AM 36.1 331 8:39:18 AM 30.1 110 8:14:29 AM 36.1 332 8:39:26 AM 39.1 111 8:14:35 AM 37.9 8:39:35 AM 35.9 112 8:15:05 AM 34.7 334 8:39:43 AM 32.2 8:15:15 AM 30.8 335 8:39:49 AM 29.4 114 8:15:25 AM 28.1 336 8:39:56 AM 35.9 115 8:15:31 AM 33.6 337 8:40:01 AM 41.4 116 8:15:38 AM 38.6 338 8:40:05 AM 35.9 117 8:15:42 AM 30.6 339 8:40:08 AM 36.8 118 8:15:50 AM 35.7 340 8:40:12 AM 38.4 8:15:55 AM 31.4 341 8:40:18 AM 36 120 8:16:00 AM 30.9 8:40:23 AM 28.8 121 8:16:04 AM 36.5 343 8:40:29 AM 31.6 122 8:16:10 AM 36.5 8:40:35 AM 32.9 123 8:16:15 AM 32.0 345 8:40:43 AM 35.7 124 8:16:20 AM 47.8 346 8:40:50 AM 30.4 125 8:16:25 AM 29.8 8:40:58 AM 29.6 126 8:16:30 AM 37.8 348 8:41:05 AM 35.2 127 8:16:36 AM 30.8 349 8:41:12 AM 32.3 128 8:16:42 AM 33.9 350 8:41:20 AM 30.4 129 8:16:48 AM 33.4 351 8:41:27 AM 33.9 130 8:16:55 AM 35.0 352 8:41:35 AM 36.7 131 8:17:04 AM 38.4 353 8:41:44 AM 31.4 132 8:17:19 AM 29.7 354 8:41:48 AM 29 133 8:17:38 AM 33.0 355 8:41:55 AM 32.3 8:18:01 AM 32.7 356 8:42:02 AM 29.5 135 8:18:10 AM 357 8:42:10 AM 33.3 136 8:18:19 AM 30.7 358 8:42:17 AM 28.7 137 8:18:24 AM 37.2 359 8:42:25 AM 37.8 8:18:31 AM 32.1 8:42:32 AM 30.1 139 8:18:37 AM 35.1 361 8:42:37 AM 31.7 140 8:18:42 AM 31.9 362 8:42:40 AM 29.7 141 8:18:49 AM 30.4 363 8:42:45 AM 29.1 142 8:18:55 AM 28.4 364 8:42:53 AM 39.3 8:19:02 AM 37.9 365 8:43:02 AM 38.4 144 8:19:07 AM 45.6 366 8:43:10 AM 45.4 145 8:19:11 AM 35.1 367 8:43:17 AM 46.6 146 8:19:15 AM 33.0 8:43:25 AM 36.8 147 8:19:20 AM 34.8 369 8:43:34 AM 33.5 8:19:26 AM 33.8 370 8:43:41 AM 31.9 149 8:19:30 AM 29.1 371 8:43:48 AM 33.2 150 8:19:35 AM 31.9 372 8:43:55 AM 35.1 151 8:19:40 AM 36.4 373 8:44:04 AM 30.7 152 8:19:47 AM 30.5 374 8:44:12 AM 34.6 8:19:57 AM 30.5 375 8:44:20 AM 28.7 154 8:20:03 AM 36.8 376 8:44:28 AM 34.1 155 8:20:08 AM 39.5 377 8:44:36 AM 36.9 156 8:20:12 AM 30.1 378 8:44:42 AM 36.1 157 8:20:16 AM 31.9 379 8:44:48 AM 158 8:20:21 AM 39.4 380 8:44:53 AM 36.2 159 8:20:26 AM 30.9 381 8:44:59 AM 35 160 8:20:32 AM 30.4 382 8:45:11 AM 30 161 8:20:38 AM 32.2 383 8:45:20 AM 34.9 162 8:20:42 AM 29.5 8:45:27 AM 36 163 8:20:46 AM 36.3 385 8:45:31 AM 30.7 164 8:20:53 AM 30.5 386 8:45:42 AM 36.1 165 8:20:57 AM 35.2 8:45:53 AM 46.2 166 8:21:04 AM 30.9 388 8:45:59 AM 31.6 167 8:21:11 AM 37.1 8:46:04 AM 168 8:21:19 AM 36.4 390 8:46:08 AM 32.3 169 8:21:25 AM 31.8 391 8:46:14 AM 37.3 170 8:21:31 AM 34.6 392 8:46:21 AM 31.3 171 8:21:36 AM 35 393 8:46:28 AM 36 172 8:21:41 AM 36.6 8:46:37 AM 39.4 173 8:21:45 AM 35.1 395 8:46:45 AM 36.1 174 8:21:49 AM 34.6 396 8:46:55 AM 36.2 8:21:53 AM 397 8:47:02 AM 38.1 176 8:21:57 AM 32.4 398 8:47:10 AM 177 8:22:02 AM 28.5 399 8:47:17 AM 33.6 178 8:22:08 AM 33.2 400 8:47:26 AM 36 179 8:22:13 AM 40.1 401 8:47:35 AM 36.1 180 8:22:20 AM 402 8:47:44 AM 36.3 181 8:22:29 AM 38.6 403 8:47:53 AM 182 8:22:37 AM 29.4 404 8:48:00 AM 31 183 8:22:45 AM 29.7 405 8:48:09 AM 30.6 184 8:22:52 AM 31.7 406 8:48:14 AM 29.9 8:22:59 AM 32.5 407 8:48:19 AM 29.3 186 8:23:04 AM 30.1 408 8:48:24 AM 32.5 187 8:23:09 AM 30.1 409 8:48:29 AM 37.1 188 8:23:14 AM 29.6 410 8:48:38 AM 32.8 189 8:23:19 AM 33 411 8:48:45 AM 34.1 190 8:23:23 AM 32.3 412 8:48:49 AM 31.3 191 8:23:27 AM 31.8 413 8:48:52 AM 35.1 192 8:23:32 AM 38.9 414 8:48:55 AM 47.8 193 8:23:38 AM 32.6 415 8:49:01 AM 37.5 194 8:23:44 AM 34.9 416 8:49:07 AM 29.4 195 8:23:53 AM 32.1 417 8:49:12 AM 36.1 8:23:59 AM 26.6 418 8:49:18 AM 30.1 197 8:24:06 AM 25.7 419 8:49:30 AM 198 8:24:13 AM 27.5 420 8:49:45 AM 34.5 199 8:24:32 AM 30.6 421 8:49:54 AM 32.5 200 8:25:01 AM 30.7 422 8:49:58 AM 201 8:25:06 AM 36.9 423 8:50:03 AM 30.7 202 8:25:11 AM 25.2 8:50:10 AM 36.5 203 8:25:17 AM 24.5 425 8:50:18 AM 31.8 204 8:25:21 AM 26.4 426 8:50:25 AM 38.2 205 8:25:25 AM 26.8 427 8:50:31 AM 30.5 206 8:25:29 AM 32 428 8:50:37 AM 34.3 28.1 333 113 119 342 344 347 134 28.8 138 360 143 368 148 153 31.4 384 387 389 32.7 394 175 37.5 33.7 30.3 32.5 185 196 34.4 29.1 424 a) How many of the vehicles surveyed were speeding? What proportion of all surveyed vehicles were speeding? Are the community complaints valid? Clearly explain your answer. b) Aggregate the raw data into 5 minute intervals and fill out the following table. Vehicle Count Flow Rate (vehicles/hour) Time Interval 8:00 to 8:05 8:05 to 8:10 8:10 to 8:15 8:15 to 8:20 2.24 8:20 to 8:25 8:25 to 8:30 2:40. 8:30 to 8:35 8:35 to 8:40 8:40 to 8:45 8:45 to 8:50 8:50 to 8:55 8:55 to 9:00 c) Determine the Time-Mean Speed for each 5 minute interval. d) Determine the Space Mean Speed for each 5 minute interval. e) Using the fundamental relationships of traffic flow and linear regression (use Microsoft Excel) define the Greenshields model (speed-density relationship) for the northbound direction of Penshurst Street. Briefly describe your methodology and clearly identify the mathematical relationship. f) is the derived model a good fit for the observed data? Use a statistical measure to justify your answer g) Based on the results of part e) determine the mathematical relationship (present the equations) between speed and flow as well as the relationship between flow and density h) Using the Greenshields model derived, calculate the following key parameters for the northbound direction of Penshurst Street: 1. Free flow speed II. Jam Density iii. Capacity i) Considering the analysis completed in parts c) to h), discuss the traffic conditions on Penshurst Street and the response you would provide to the residents regarding their complaint. What further data collection would you complete to provide a more comprehensive assessment? Cleary justify your response (1/2 page, bullet point arguments are preferred). Penshurst "Local Area Traffic Management" The local community of Penshurst, situated in the Georges River Local Government Area are concerned about road traffic congestion and speeding within the vicinity of Penshurst Street and Forest Road. The specific area of concern is presented in Figure 1. Forest Road Forest Road Figure 1: Penshurst Study Area The study area consists of a number of different land uses including a school, churches, leisure centre, and at the southern end of Penshurst Street, the Penshurst town centre and Penshurst Train Station. Your consultancy firm has been asked by governing authorities to complete an assessment of the traffic conditions to quantify, evaluate and resolve some of the communities concerns. As the lead Traffic Engineer, you are faced with the problems described in the following pages of the brief. Prepare a response to each of the problems in the form of a brief report (technical note). Ensure you succinctly present any working or descriptions of methodology and use summary tables to display your results. Do not provide an excel spreadsheet as a response. Problem 1: Speeding near Penshurst Public School Residents have notified the presence of speeding vehicles travelling northbound along Penshurst Street, following the intersection of Forest Road (refer to Figure 2). In order to investigate the complaint, a pneumatic tube traffic survey was conducted on 19th of May 2021 to collect flow and speed data for Penshurst Street (for vehicles travelling northbound), at the location identified in Figure 2. The survey was conducted between 8:00AM and 9:00AM where the school zone speed limit of 40km/hr was in effect. shurst Street !!! Penshurst Public School 1 1 Observation Time (km/hr) Observation 445 446 447 227 Speed (km/hr) 53 37.5 31.2 38.7 37.8 39 39.1 37.5 35.9 31.2 38.2 41.2 33.3 33.9 40.3 35.9 230 41.3 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 8:53:10 AM 8:53:18 AM 8:53:28 AM 8:53:43 AM 8:53:54 AM 8:54:05 AM 8:54:15 AM 8:54:20 AM 8:54:24 AM 8:54:40 AM 8:54:51 AM 8:55:09 AM 8:55:15 AM 8:55:21 AM 8:55:27 AM 8:55:30 AM 8:55:35 AM 8:55:40 AM 8:55:44 AM 8:55:49 AM 8:56:04 AM 8:56:08 AM 8:56:24 AM 8:56:30 AM 8:56:39 AM 8:56:47 AM 8:56:53 AM 8:57:05 AM 8:57:18 AM 8:57:25 AM 8:57:34 AM 8:57:58 AM 8:58:02 AM 8:58:09 AM 8:58:14 AM 8:59:21 AM 8:59:29 AM 244 37.2 30.4 39.7 38 34.6 35.9 39.9 35 36.9 34.1 32.9 36.4 36.8 34.6 42.7 36.1 34 38.8 34.9 36.8 35.2 35.1 258 481 33.2 290 32.2 309 28.1 Assignment 1 - Speed Data Location: Northbound, Penshurst Street, Penshurst, NSW, 2222 Date, Time: 19/05/2021, 8:00AM to 9:00AM Weather: Fine (no inclement weather) Notes: Normal traffic conditions, no unusual disruptions Speed Observation Time Time Speed (km/hr 1 8:00:01 AM 35.1 223 8:26:56 AM 33.6 2 8:00:14 AM 38 224 8:27:01 AM 37.2 3 8:00:22 AM 39.1 225 8:27:06 AM 36.1 4 8:00:33 AM 36.9 226 8:27:15 AM 35.1 5 8:00:41 AM 36.8 8:27:21 AM 31 6 8:00:45 AM 34.5 228 8:27:26 AM 40.8 7 8:00:53 AM 36 229 8:27:30 AM 34.7 8 8:00:57 AM 36.8 8:27:37 AM 33.2 9 8:01:02 AM 38.8 231 8:27:45 AM 32.4 10 8:01:08 AM 33.5 232 8:27:56 AM 30.6 11 8:01:15 AM 36.3 233 8:28:03 AM 36.7 12 8:01:19 AM 34.7 234 8:28:09 AM 37.6 13 8:01:22 AM 33.2 235 8:28:13 AM 33.8 14 8:01:29 AM 37.1 236 8:28:22 AM 34.6 15 8:01:33 AM 36.3 237 8:28:28 AM 32.5 16 8:01:36 AM 36.7 238 8:28:31 AM 42.8 17 8:01:45 AM 35.9 239 8:28:37 AM 38.2 18 8:01:55 AM 33.9 240 8:28:44 AM 34.9 19 8:02:03 AM 34.9 241 8:28:51 AM 32.6 20 8:02:15 AM 32.6 242 8:28:59 AM 34.9 21 8:02:25 AM 31.4 243 8:29:06 AM 29 22 8:02:33 AM 38.9 8:29:11 AM 28.4 23 8:02:41 AM 245 8:29:25 AM 37.6 24 8:02:55 AM 33 246 8:29:29 AM 32.9 25 8:03:00 AM 32.3 247 8:29:35 AM 39.8 26 8:03:28 AM 34 248 8:29:45 AM 32.8 27 8:03:35 AM 32.1 249 8:29:57 AM 28 8:03:45 AM 33.8 250 8:30:01 AM 30.1 29 8:03:51 AM 34.1 251 8:30:07 AM 34.6 30 8:04:12 AM 32 252 8:30:11 AM 32.4 31 8:04:23 AM 31.7 253 8:30:18 AM 35.6 32 8:04:31 AM 31.8 254 8:30:27 AM 35.9 33 8:04:37 AM 36.2 255 8:30:34 AM 36.7 34 8:04:47 AM 27.5 256 8:30:39 AM 32.6 35 8:05:03 AM 32.7 257 8:30:44 AM 38.1 36 8:05:22 AM 28.6 8:30:48 AM 35.1 37 8:05:30 AM 30.6 259 8:30:57 AM 32.5 38 8:05:35 AM 30.2 260 8:31:05 AM 28.7 39 8:05:38 AM 29.2 261 8:31:13 AM 29.5 40 8:05:45 AM 37.6 262 8:31:20 AM 32.7 41 8:05:54 AM 37.9 263 8:31:27 AM 34 42 8:06:05 AM 35.2 264 8:31:35 AM 37.7 43 8:06:09 AM 29.3 265 8:31:41 AM 34.6 44 8:06:16 AM 36.4 266 8:31:48 AM 30 45 8:06:24 AM 32.0 267 8:31:55 AM 35.7 46 8:06:29 AM 36.3 268 8:32:00 AM 34.8 47 8:06:32 AM 29.4 269 8:32:06 AM 33 48 8:06:43 AM 34.0 270 8:32:12 AM 28.8 49 8:06:50 AM 35.1 271 8:32:19 AM 31 50 8:06:56 AM 31.6 272 8:32:26 AM 29.5 51 8:07:08 AM 39.0 273 8:32:33 AM 29 52 8:07:15 AM 33.4 274 8:32:40 AM 35.5 53 8:07:19 AM 36.1 275 8:32:47 AM 31 54 8:07:22 AM 29.3 276 8:32:53 AM 27.5 55 8:07:28 AM 36.3 277 8:33:00 AM 31.1 56 8:07:32 AM 37.9 278 8:33:07 AM 32.5 57 8:07:43 AM 36.7 279 8:33:14 AM 37.3 58 8:07:50 AM 35.6 280 8:33:22 AM 37.2 59 8:08:03 AM 39.1 281 8:33:29 AM 33.3 60 8:08:17 AM 35.1 282 8:33:36 AM 28.7 61 8:08:26 AM 28.2 283 8:33:43 AM 31.4 8:08:36 AM 33.7 284 8:33:50 AM 50.7 63 8:08:41 AM 31.0 285 8:33:56 AM 34.6 64 8:08:46 AM 32.2 286 8:34:02 AM 32.5 65 8:08:51 AM 32.8 287 8:34:10 AM 66 8:08:58 AM 31.6 288 8:34:17 AM 35.1 67 8:09:03 AM 37.0 289 8:34:25 AM 38 68 8:09:13 AM 30.7 8:34:31 AM 33.8 69 8:09:25 AM 34.6 291 8:34:37 AM 50 70 8:09:32 AM 29.7 292 8:34:45 AM 29.2 71 8:09:40 AM 38.0 293 8:34:50 AM 35.1 72 8:09:48 AM 31.4 294 8:34:55 AM 35.4 73 8:10:01 AM 34.4 295 8:35:01 AM 34.4 74 8:10:12 AM 36.9 296 8:35:05 AM 37.3 75 8:10:19 AM 32.0 297 8:35:09 AM 34.2 76 8:10:28 AM 298 8:35:15 AM 36.4 77 8:10:33 AM 37.4 299 8:35:23 AM 36.7 78 8:10:43 AM 33.5 300 8:35:30 AM 30.3 79 8:10:50 AM 35.5 301 8:35:40 AM 35.7 80 8:10:56 AM 33.3 302 8:35:54 AM 33.7 81 8:11:05 AM 28.2 303 8:36:06 AM 38.7 82 8:11:15 AM 32.4 304 8:36:18 AM 34.7 83 8:11:19 AM 30.9 305 8:36:28 AM 35.3 84 8:11:23 AM 29.0 306 8:36:32 AM 32.8 85 8:11:28 AM 37.9 307 8:36:35 AM 36.5 86 8:11:34 AM 38.5 308 8:36:40 AM 29.6 87 8:11:41 AM 28.6 8:36:48 AM 28.5 88 8:11:48 AM 28.8 310 8:36:59 AM 29.6 89 8:11:55 AM 33.6 311 8:37:06 AM 32.3 90 8:12:01 AM 40.9 312 8:37:13 AM 28.8 91 8:12:08 AM 29.1 313 8:37:20 AM 32.9 92 8:12:14 AM 34.8 314 8:37:26 AM 34 93 8:12:21 AM 31.7 315 8:37:32 AM 30.6 94 8:12:26 AM 316 8:37:37 AM 30.4 95 8:12:33 AM 30.5 317 8:37:42 AM 32.8 96 8:12:42 AM 33.5 318 8:37:48 AM 36.1 97 8:12:52 AM 36.9 319 8:37:53 AM 38.8 98 8:13:02 AM 32.4 320 8:38:08 AM 33.2 99 8:13:05 AM 37.7 321 8:38:18 AM 34.2 100 8:13:09 AM 30.7 322 8:38:22 AM 37.7 101 8:13:28 AM 32.5 323 8:38:32 AM 29.1 102 8:13:35 AM 28.6 324 8:38:36 AM 35.9 103 8:13:41 AM 37.2 325 8:38:40 AM 36.9 104 8:13:53 AM 38.5 326 8:38:50 AM 43 105 8:13:59 AM 37.8 327 8:38:54 AM 36.7 106 8:14:05 AM 31.0 328 8:39:01 AM 42.1 107 8:14:08 AM 35.1 329 8:39:05 AM 36.1 108 8:14:21 AM 330 8:39:10 AM 29.9 109 8:14:25 AM 36.1 331 8:39:18 AM 30.1 110 8:14:29 AM 36.1 332 8:39:26 AM 39.1 111 8:14:35 AM 37.9 8:39:35 AM 35.9 112 8:15:05 AM 34.7 334 8:39:43 AM 32.2 8:15:15 AM 30.8 335 8:39:49 AM 29.4 114 8:15:25 AM 28.1 336 8:39:56 AM 35.9 115 8:15:31 AM 33.6 337 8:40:01 AM 41.4 116 8:15:38 AM 38.6 338 8:40:05 AM 35.9 117 8:15:42 AM 30.6 339 8:40:08 AM 36.8 118 8:15:50 AM 35.7 340 8:40:12 AM 38.4 8:15:55 AM 31.4 341 8:40:18 AM 36 120 8:16:00 AM 30.9 8:40:23 AM 28.8 121 8:16:04 AM 36.5 343 8:40:29 AM 31.6 122 8:16:10 AM 36.5 8:40:35 AM 32.9 123 8:16:15 AM 32.0 345 8:40:43 AM 35.7 124 8:16:20 AM 47.8 346 8:40:50 AM 30.4 125 8:16:25 AM 29.8 8:40:58 AM 29.6 126 8:16:30 AM 37.8 348 8:41:05 AM 35.2 127 8:16:36 AM 30.8 349 8:41:12 AM 32.3 128 8:16:42 AM 33.9 350 8:41:20 AM 30.4 129 8:16:48 AM 33.4 351 8:41:27 AM 33.9 130 8:16:55 AM 35.0 352 8:41:35 AM 36.7 131 8:17:04 AM 38.4 353 8:41:44 AM 31.4 132 8:17:19 AM 29.7 354 8:41:48 AM 29 133 8:17:38 AM 33.0 355 8:41:55 AM 32.3 8:18:01 AM 32.7 356 8:42:02 AM 29.5 135 8:18:10 AM 357 8:42:10 AM 33.3 136 8:18:19 AM 30.7 358 8:42:17 AM 28.7 137 8:18:24 AM 37.2 359 8:42:25 AM 37.8 8:18:31 AM 32.1 8:42:32 AM 30.1 139 8:18:37 AM 35.1 361 8:42:37 AM 31.7 140 8:18:42 AM 31.9 362 8:42:40 AM 29.7 141 8:18:49 AM 30.4 363 8:42:45 AM 29.1 142 8:18:55 AM 28.4 364 8:42:53 AM 39.3 8:19:02 AM 37.9 365 8:43:02 AM 38.4 144 8:19:07 AM 45.6 366 8:43:10 AM 45.4 145 8:19:11 AM 35.1 367 8:43:17 AM 46.6 146 8:19:15 AM 33.0 8:43:25 AM 36.8 147 8:19:20 AM 34.8 369 8:43:34 AM 33.5 8:19:26 AM 33.8 370 8:43:41 AM 31.9 149 8:19:30 AM 29.1 371 8:43:48 AM 33.2 150 8:19:35 AM 31.9 372 8:43:55 AM 35.1 151 8:19:40 AM 36.4 373 8:44:04 AM 30.7 152 8:19:47 AM 30.5 374 8:44:12 AM 34.6 8:19:57 AM 30.5 375 8:44:20 AM 28.7 154 8:20:03 AM 36.8 376 8:44:28 AM 34.1 155 8:20:08 AM 39.5 377 8:44:36 AM 36.9 156 8:20:12 AM 30.1 378 8:44:42 AM 36.1 157 8:20:16 AM 31.9 379 8:44:48 AM 158 8:20:21 AM 39.4 380 8:44:53 AM 36.2 159 8:20:26 AM 30.9 381 8:44:59 AM 35 160 8:20:32 AM 30.4 382 8:45:11 AM 30 161 8:20:38 AM 32.2 383 8:45:20 AM 34.9 162 8:20:42 AM 29.5 8:45:27 AM 36 163 8:20:46 AM 36.3 385 8:45:31 AM 30.7 164 8:20:53 AM 30.5 386 8:45:42 AM 36.1 165 8:20:57 AM 35.2 8:45:53 AM 46.2 166 8:21:04 AM 30.9 388 8:45:59 AM 31.6 167 8:21:11 AM 37.1 8:46:04 AM 168 8:21:19 AM 36.4 390 8:46:08 AM 32.3 169 8:21:25 AM 31.8 391 8:46:14 AM 37.3 170 8:21:31 AM 34.6 392 8:46:21 AM 31.3 171 8:21:36 AM 35 393 8:46:28 AM 36 172 8:21:41 AM 36.6 8:46:37 AM 39.4 173 8:21:45 AM 35.1 395 8:46:45 AM 36.1 174 8:21:49 AM 34.6 396 8:46:55 AM 36.2 8:21:53 AM 397 8:47:02 AM 38.1 176 8:21:57 AM 32.4 398 8:47:10 AM 177 8:22:02 AM 28.5 399 8:47:17 AM 33.6 178 8:22:08 AM 33.2 400 8:47:26 AM 36 179 8:22:13 AM 40.1 401 8:47:35 AM 36.1 180 8:22:20 AM 402 8:47:44 AM 36.3 181 8:22:29 AM 38.6 403 8:47:53 AM 182 8:22:37 AM 29.4 404 8:48:00 AM 31 183 8:22:45 AM 29.7 405 8:48:09 AM 30.6 184 8:22:52 AM 31.7 406 8:48:14 AM 29.9 8:22:59 AM 32.5 407 8:48:19 AM 29.3 186 8:23:04 AM 30.1 408 8:48:24 AM 32.5 187 8:23:09 AM 30.1 409 8:48:29 AM 37.1 188 8:23:14 AM 29.6 410 8:48:38 AM 32.8 189 8:23:19 AM 33 411 8:48:45 AM 34.1 190 8:23:23 AM 32.3 412 8:48:49 AM 31.3 191 8:23:27 AM 31.8 413 8:48:52 AM 35.1 192 8:23:32 AM 38.9 414 8:48:55 AM 47.8 193 8:23:38 AM 32.6 415 8:49:01 AM 37.5 194 8:23:44 AM 34.9 416 8:49:07 AM 29.4 195 8:23:53 AM 32.1 417 8:49:12 AM 36.1 8:23:59 AM 26.6 418 8:49:18 AM 30.1 197 8:24:06 AM 25.7 419 8:49:30 AM 198 8:24:13 AM 27.5 420 8:49:45 AM 34.5 199 8:24:32 AM 30.6 421 8:49:54 AM 32.5 200 8:25:01 AM 30.7 422 8:49:58 AM 201 8:25:06 AM 36.9 423 8:50:03 AM 30.7 202 8:25:11 AM 25.2 8:50:10 AM 36.5 203 8:25:17 AM 24.5 425 8:50:18 AM 31.8 204 8:25:21 AM 26.4 426 8:50:25 AM 38.2 205 8:25:25 AM 26.8 427 8:50:31 AM 30.5 206 8:25:29 AM 32 428 8:50:37 AM 34.3 28.1 333 113 119 342 344 347 134 28.8 138 360 143 368 148 153 31.4 384 387 389 32.7 394 175 37.5 33.7 30.3 32.5 185 196 34.4 29.1 424 a) How many of the vehicles surveyed were speeding? What proportion of all surveyed vehicles were speeding? Are the community complaints valid? Clearly explain your answer. b) Aggregate the raw data into 5 minute intervals and fill out the following table. Vehicle Count Flow Rate (vehicles/hour) Time Interval 8:00 to 8:05 8:05 to 8:10 8:10 to 8:15 8:15 to 8:20 2.24 8:20 to 8:25 8:25 to 8:30 2:40. 8:30 to 8:35 8:35 to 8:40 8:40 to 8:45 8:45 to 8:50 8:50 to 8:55 8:55 to 9:00 c) Determine the Time-Mean Speed for each 5 minute interval. d) Determine the Space Mean Speed for each 5 minute interval. e) Using the fundamental relationships of traffic flow and linear regression (use Microsoft Excel) define the Greenshields model (speed-density relationship) for the northbound direction of Penshurst Street. Briefly describe your methodology and clearly identify the mathematical relationship. f) is the derived model a good fit for the observed data? Use a statistical measure to justify your answer g) Based on the results of part e) determine the mathematical relationship (present the equations) between speed and flow as well as the relationship between flow and density h) Using the Greenshields model derived, calculate the following key parameters for the northbound direction of Penshurst Street: 1. Free flow speed II. Jam Density iii. Capacity i) Considering the analysis completed in parts c) to h), discuss the traffic conditions on Penshurst Street and the response you would provide to the residents regarding their complaint. What further data collection would you complete to provide a more comprehensive assessment? Cleary justify your response (1/2 page, bullet point arguments are preferred)