# Traffic Lab

Northern Arizona University College of Engineering, Forestry, and Natural Sciences CENE 420: Traffic Studies and Signal Systems Laboratory # 4 Out: September 24th, 2013 Due: October 1st, 2013 Time Stamped Data Analysis and Red Light Running At the conclusion of this lab, you will be able to: Recreate field conditions from collected data Compile possible red light violations from time stamped data Manipulate line data in excel to provide meaningful results Calculate vehicle velocity from a data log Review the video RedLight Violation1.
Document Preview:

Northern Arizona University College of Engineering, Forestry, and Natural Sciences CENE 420: Traffic Studies and Signal Systems Laboratory # 4 Out: September 24th, 2013 Due: October 1st, 2013 Time Stamped Data Analysis and Red Light Running At the conclusion of this lab, you will be able to: Recreate field conditions from collected data Compile possible red light violations from time stamped data Manipulate line data in excel to provide meaningful results Calculate vehicle velocity from a data log Review the video RedLight Violation1.wmv taken at the Purdue University test location. At approximately what time did the red vehicle allegedly enter the intersection on red? (2) What are the corresponding detectors on the overlay that could be used for estimating vehicle speed? (2) Based upon the video, mark and label the estimated location of MA1, MA2, MB1, MB2 on the figure below: (2) Figure 1: Location of Microloops Examine the file 20040922_0.txt. What punctuation mark is used for the delimeter? (2) Import the file into Excel (Data tab). The data file has no headings. To rectify this, insert a row at the top of the pageof the following column labels Detector #, Detector Name, Date, Time, Code, Time (millisecond), Detector State. For Detector State, ‘1’ indicates the detector is on. ‘0’ indicates the detector is off. In relationship to the alleged violation, and assuming that Detector # 106 is the red indication for the through movement: What time did MA2 turn on at (milliseconds)? (2) What time did MA1 turn on at (milliseconds)? (2) What time did Detector 106 turn on at (milliseconds)? (2) How long after MA1 turns off did 106 turn off (milliseconds)? (2) Assuming 15’ front edge to front edge for detectors, what was the velocity of the vehicle during this violation? Show your calculations. (Hint 1: Use detector…

Attachments:
Attachments: Northern Arizona University
College of Engineering, Forestry, and Natural Sciences

CENE 420: Traffic Studies and Signal Systems

Laboratory # 4 Out: September 24th, 2013
Due: October 1st, 2013

Time Stamped Data Analysis and Red Light Running

At the conclusion of this lab, you will be able to:

• Recreate field conditions from collected data
• Compile possible red light violations from time stamped data
• Manipulate line data in excel to provide meaningful results
• Calculate vehicle velocity from a data log

1. Review the video RedLight Violation1.wmv taken at the Purdue University test location. At approximately what time did the red vehicle allegedly enter the intersection on red? (2)

2. What are the corresponding detectors on the overlay that could be used for estimating vehicle speed? (2)

3. Based upon the video, mark and label the estimated location of MA1, MA2, MB1, MB2 on the figure below: (2)

Figure 1: Location of Microloops

4. Examine the file 20040922_0.txt. What punctuation mark is used for the delimeter? (2)

5. Import the file into Excel (Data tab). The data file has no headings. To rectify this, insert a row at the top of the pageof the following column labels Detector #, Detector Name, Date, Time, Code, Time (millisecond), Detector State. For Detector State, ‘1’ indicates the detector is on. ‘0’ indicates the detector is off.

6. In relationship to the alleged violation, and assuming that Detector # 106 is the red indication for the through movement:
• What time did MA2 turn on at (milliseconds)? (2)

• What time did MA1 turn on at (milliseconds)? (2)

• What time did Detector 106 turn on at (milliseconds)? (2)

• How long after MA1 turns off did 106 turn off (milliseconds)? (2)

• Assuming 15’ front edge to front edge for detectors, what was the velocity of the vehicle during this violation? Show your calculations. (Hint 1: Use detector turn on time to calculate your time value; Hint 2: Distance = Rate * Time) (4)

7. Using the detector turn off time, estimate the velocity of the vehicle. Show your calculations. (4)

The objective of the next section of this lab is to identify instances where red light violations may have occurred. This will be done using the data file that you have already been working with (20040922_0.txt).

8. Extract out all of the MA1, MA2 events into a separate sheet. You may wish to use the filter feature in excel.

9. Using conditional logic, calculate speed using the MA2, MA1 detector pair using turn on time. It will help to extract out only the occurrences of MA2 and MA1 where the detector is on (State = 1).

Example……=IF(AND(A2=109,A3=105),15000/(F3-F2),” “)

10. Extract out the phase indication (106).

11. For each speed value, determine if the speed occurred during RED or GREEN. The command ‘LOOKUP’ is best suited for this task in Excel, but you can accomplish this anyway you like.

12. Provide an annotated screen capture of a portion of your excel spreadsheet that determines Question 13. Using this screen capture, explain how you determined whether the speed occurred furing RED or not RED. (6)

13. Enumerate any observed red light violations. Verify with the corresponding video. Provide a list of each possible violation along with your visual determination of whether or not it appears to be a violation. (18)

We are always aiming to provide top quality academic writing services that will surely enable you achieve your desired academic grades. Our support is round the clock!