Queen Creek Video Count Analysis Project Summary�
Completed by the Town of Queen Creek with support from:
Dr. Jeff Jenq, MAG
Dr. Sarath Joshua, MAG (retired)
Tricia Brown, ADOT
Dr. Sarah Simpson, UCG
Arizona ITE-IMSA Annual Spring Conference
April 2024
Presentation Overview
Motivation
Process
Findings
Conclusions
2
Motivation
3
Motivation
4
Process
5
Process – Reconciliation of Human Counts
6
Statistical Comparisons
7
Pearson Test
8
Pearson Test
Ocotillo and Power NB Left
Ocotillo and Ellsworth Loop NB Thru 2
Note that Pearson of 0.98 does not mean “98% correct”
9
Where’s our good friend the T-test?
10
Tabulating over and under counts
11
Qualitative assignment of significant findings
Reminder: Pearson of 0.94 does not mean “94% correct”
Pearson indicates how closely a “straight line” can be drawn to connect the video and person counts
12
Acceptable
Sossaman Road and Riggs Road
Count
Frequency of Bin Count
Count range
Bin Start Time
13
Slight Undercount
Ocotillo Road and Power Road
Count
Frequency of Bin Count
Count range
Bin Start Time
14
Undercount
Ocotillo Road and Ellsworth Loop Road
Count
Frequency of Bin Count
Count range
Bin Start Time
15
Both Under/Over in the Same Period
Ocotillo Road and 226th Road
Count
Frequency of Bin Count
Count range
Bin Start Time
16
Over/undercount at the same time
17
Findings
18
Each Intersection, All TOD Periods
Note generally how high the Pearson values are at this level of total aggregation
Denotes finding of concern
19
Each intersection, Each TOD Period
Location | AM | Mid-Day | PM |
Rittenhouse/Ellsworth | EB over, WB/SB/NB under | Slight over | Slight under |
Rittenhouse/Hawes | Under | Slight Under | Under |
Ocotillo/Crismon | Under | EB/WB under, SB over | Under |
Ocotillo/226th | OK | OK | OK |
Ocotillo/Ellsworth | OK | OK | EB/WB over, NB/SB under |
Hawes/Chandler Heights | OK | OK | OK |
Ocotillo/Power | OK | OK | OK |
Sossaman/Riggs | OK | OK | OK |
Denotes finding of concern
20
Each Approach, Each TOD Period
Location | EB | WB | NB | SB | ||||||||
AM | Mid-Day | PM | AM | Mid-Day | PM | AM | Mid-Day | PM | AM | Mid-Day | PM | |
Rittenhouse/ Ellsworth | OK | Over | Over | OK | OK | OK | OK | OK | OK | OK | OK | OK |
Rittenhouse/Hawes | OK | Under | Under | OK | OK | Under | OK | OK | OK | N/A | N/A | N/A |
Ocotillo/Crismon | Under | Slight under | Slight Under | OK | OK | Under | N/A | N/A | N/A | OK | Over | OK |
Ocotillo/226th | OK | OK | OK | OK | OK | OK | Inc | OK | Inc | Inc | Over | OK |
Ocotillo/Ellsworth | OK | Over | Over | Over | U/O | U/O | Under | OK | Under | OK | U/O | Under |
Hawes/Chandler Heights | OK | OK | OK | OK | OK | OK | U/O | OK | OK | OK | Over | Under |
Ocotillo/Power | OK | OK | OK | OK | OK | OK | OK | OK | OK | OK | OK | Under |
Sossaman/Riggs | OK | OK | OK | OK | OK | OK | OK | OK | OK | OK | OK | OK |
Denotes finding of concern
N/A indicates approach does not exist
21
Each Lane, Each TOD Period, Each Approach
Ocotillo/Ellsworth | Lanes | ||||||
Left 1 | Left2 | Thru1 | Thru2 | Thru3 | Thru/R | Right | |
EB AM | OK | N/A | OK | OK | N/A | N/A | OK |
EB Mid | Over | N/A | Over | Over | N/A | N/A | OK |
EB PM | Slight over | N/A | Over | Over | N/A | N/A | O/U |
WB AM | OK | N/A | OK | Over | N/A | N/A | OK |
WB Mid | O/U | N/A | Over | Over | N/A | N/A | OK |
WB PM | Under | N/A | Over | Over | N/A | N/A | OK |
NM AM | OK | N/A | Under | Under | N/A | Under | N/A |
NB Mid | OK | N/A | Slight under | OK | N/A | Slight under | N/A |
NM PM | OK | N/A | Slight under | Under | N/A | Slight under | N/A |
SB AM | OK | N/A | OK | OK | N/A | OK | N/A |
SB Mid | Over | N/A | Slight Under | OK | N/A | OK | N/A |
SB PM | OK | N/A | Under | Under | N/A | Under | N/A |
Denotes finding of concern
N/A indicates lane does not exist
22
Each Lane,�Each TOD Period, Each Approach…
Skipping 10+ tables like previous…see report
23
Conclusions
Result | Number | Percent |
Acceptable | 194 | 63% |
Undercount | 41 | 13% |
Slight Undercount | 9 | 3% |
Slight Overcount | 18 | 6% |
Overcount | 34 | 11% |
Both overcount and undercount | 13 | 4% |
Total | 309 | 100% |
�
Time periods deemed “inconclusive” due to lack of enough information (<1%) were counted as “acceptable” for the purpose of this table.
Acceptable =
Pearson >0.95, per lane, per time period
24
Conclusions: West-pointing cameras
�
Time periods deemed “inconclusive” due to lack of enough information (<1%) were counted as “acceptable” for the purpose of this table.
Result | Left | Through | Shared Thru/Right | Right | Total |
Acceptable | 9 | 18 | 8 | 7 | 42 (48%) |
Undercount | 1 | 6 | 1 | 1 | 9 (10%) |
Slight Undercount | 0 | 1 | 0 | 0 | 1 (1%) |
Slight Overcount | 4 | 5 | 0 | 0 | 9 (10%) |
Overcount | 8 | 8 | 0 | 2 | 18 (20%) |
Both overcount and undercount | 2 | 4 | 0 | 2 | 8 (9%) |
Total | 24 | 42 | 9 | 12 | 87 |
Acceptable =
Pearson >0.95, per lane, per time period
25
Conclusions: East-pointing cameras
�
Time periods deemed “inconclusive” due to lack of enough information (<1%) were counted as “acceptable” for the purpose of this table.
Result | Left | Through | Shared Thru/Right | Right | Total |
Acceptable | 17 | 29 | 8 | 9 | 63 (75%) |
Undercount | 1 | 2 | 0 | 3 | 6 (7%) |
Slight Undercount | 0 | 0 | 1 | 0 | 1 (1%) |
Slight Overcount | 2 | 2 | 0 | 0 | 4 (5%) |
Overcount | 4 | 5 | 0 | 0 | 9 (11%) |
Both overcount and undercount | 0 | 1 | 0 | 0 | 1 (1%) |
Total | 24 | 39 | 9 | 12 | 84 |
Acceptable =
Pearson >0.95, per lane, per time period
26
Why is pointing West apparently harder than pointing East (in this data set)?
The unacceptable performance during sunset (west-pointing cameras) or sunrise (east-pointing cameras) tends to be to overcount.
27
Conclusions: Why is Ellsworth/Ocotillo least acceptable?
�
28
Summary of Conclusions
29
Questions?
Backups
Jump to Conclusions
33
Slight Overcount
Sossaman Road and Riggs Road
34
Overcount
Rittenhouse Road and Ellsworth Loop Road
35
All intersections/cameras by TOD
36
Each Approach, All TOD Periods
Location | EB | WB | NB | SB |
Rittenhouse/Ellsworth | OK | OK | OK | OK |
Rittenhouse/Hawes | Under | Under | OK | N/A |
Ocotillo/Crismon | Under | Under during PM only | N/A | OK |
Ocotillo/226th | OK | OK | OK | Over |
Ocotillo/Ellsworth | Over | Over | Under | Under |
Hawes/Chandler Heights | OK | OK | Errors at low volumes (AM) | Under in PM |
Ocotillo/Power | OK | OK | OK | Slight under |
Sossaman/Riggs | OK | OK | OK | OK |
Denotes finding of concern
37
Each Lane, All TOD Periods (EB)
Location | Eastbound | ||||||
Left 1 | Left2 | Thru1 | Thru2 | Thru3 | Thru/R | Right | |
Rittenhouse/ Ellsworth | OK | O/U | OK | OK | OK | N/A | OK |
Rittenhouse/Hawes | N/A | N/A | OK | N/A | N/A | OK | N/A |
Ocotillo/Crismon | Over | N/A | Slight Under | OK | N/A | N/A | N/A |
Ocotillo/226th | OK | N/A | Under | OK | N/A | N/A | Over |
Ocotillo/Ellsworth | O/U | N/A | Over | Over | N/A | N/A | OK |
Hawes/Chandler Heights | Slight over | N/A | Slight over | N/A | N/A | OK | N/A |
Ocotillo/Power | Over | N/A | N/A | N/A | N/A | OK | N/A |
Sossaman/Riggs | OK | N/A | OK | OK | OK | N/A | OK |
Denotes finding of concern
N/A indicates lane does not exist
38
Each Lane, All TOD Periods (WB)
Location | Westbound | ||||||
Left 1 | Left2 | Thru1 | Thru2 | Thru3 | Thru/R | Right | |
Rittenhouse/ Ellsworth | Over | OK | OK | OK | N/A | N/A | Under |
Rittenhouse/Hawes | OK | N/A | Under | Under | N/A | N/A | N/A |
Ocotillo/Crismon | N/A | N/A | OK | N/A | N/A | Under | N/A |
Ocotillo/226th | OK | N/A | Under | OK | N/A | N/A | Over |
Ocotillo/Ellsworth | O/U | N/A | Over | Over | N/A | N/A | OK |
Hawes/Chandler Heights | OK | N/A | OK | N/A | N/A | OK | N/A |
Ocotillo/Power | OK | OK | N/A | N/A | N/A | N/A | OK |
Sossaman/Riggs | OK | N/A | OK | OK | OK | N/A | OK |
Denotes finding of concern
N/A indicates lane does not exist
39
Each Lane, All TOD Periods (NB)
Location | Northbound | ||||||
Left 1 | Left2 | Thru1 | Thru2 | Thru3 | Thru/R | Right | |
Rittenhouse/ Ellsworth | Under | Under | OK | Under | N/A | N/A | Under |
Rittenhouse/Hawes | OK | N/A | OK | N/A | N/A | N/A | N/A |
Ocotillo/Crismon | N/A | N/A | N/A | N/A | N/A | N/A | N/A |
Ocotillo/226th | Under | N/A | N/A | N/A | N/A | OK | N/A |
Ocotillo/Ellsworth | OK | N/A | Under | Under | N/A | Under | N/A |
Hawes/Chandler Heights | O/U | N/A | OK | N/A | N/A | O/U | N/A |
Ocotillo/Power | OK | N/A | OK | OK | N/A | OK | N/A |
Sossaman/Riggs | OK | N/A | OK | N/A | N/A | N/A | OK |
Denotes finding of concern
N/A indicates lane does not exist
40
Each Lane, All TOD Periods (SB)
Location | Southbound | ||||||
Left 1 | Left2 | Thru1 | Thru2 | Thru3 | Thru/R | Right | |
Rittenhouse/ Ellsworth | OK | OK | OK | OK | N/A | Under | N/A |
Rittenhouse/Hawes | N/A | N/A | N/A | N/A | N/A | N/A | N/A |
Ocotillo/Crismon | OK | N/A | N/A | N/A | N/A | N/A | OK |
Ocotillo/226th | N/A | N/A | N/A | N/A | N/A | Over | N/A |
Ocotillo/Ellsworth | Over | N/A | Under | Under | N/A | Under | N/A |
Hawes/Chandler Heights | OK | N/A | Over | N/A | N/A | OK | N/A |
Ocotillo/Power | OK | N/A | OK | OK | N/A | OK | N/A |
Sossaman/Riggs | OK | OK | OK | N/A | N/A | N/A | OK |
Denotes finding of concern
N/A indicates lane does not exist
41
Conclusions: South-pointing cameras
�
Time periods deemed “inconclusive” due to lack of enough information (<1%) were counted as “acceptable” for the purpose of this table.
Result | Left | Through | Shared Thru/Right | Right | Total |
Acceptable | 17 | 16 | 11 | 0 | 44 (64%) |
Undercount | 1 | 8 | 4 | 0 | 13 (19%) |
Slight Undercount | 1 | 2 | 2 | 0 | 5 (7%) |
Slight Overcount | 0 | 0 | 0 | 0 | 0 |
Overcount | 4 | 0 | 0 | 0 | 4 (6%) |
Both overcount and undercount | 1 | 1 | 1 | 0 | 3 (4%) |
Total | 24 | 27 | 18 | 0 | 69 |
Acceptable =
Pearson >0.95, per lane, per time period
42
Conclusions: North-pointing cameras
�
Time periods deemed “inconclusive” due to lack of enough information (<1%) were counted as “acceptable” for the purpose of this table.
Result | Left | Through | Shared Thru/Right | Right | Total |
Acceptable | 16 | 14 | 10 | 5 | 45 (65%) |
Undercount | 3 | 6 | 4 | 0 | 13 (19%) |
Slight Undercount | 0 | 2 | 0 | 0 | 2 (3%) |
Slight Overcount | 3 | 2 | 0 | 0 | 5 (7%) |
Overcount | 2 | 0 | 0 | 1 | 3 (4%) |
Both overcount and undercount | 0 | 0 | 1 | 0 | 1 (1%) |
Total | 24 | 24 | 15 | 6 | 69 |
Acceptable = Pearson >0.95, per lane, per time period
43