Better Intersections - Traffic Light Timings (Public)

	A	B	C	D	E	F	G	H	I	J	K
1	Timestamp	Optional: What time (to the nearest 15 min) did you measure this? If not specified assumes current time.	Optional: What code is on the traffic light control box? Usually a number on yellow background, on a metal box near the intersection.	Describe the location (road you're crossing & nearest feature, adjacent road if traffic lights, or coordinates)	How many seconds was the pedestrian light green for?	How many seconds was the pedestrian light flashing red for?	How many seconds was the pedestrian light solid red for?	Optional: What is the OpenStreetMap node ID of the intersection? (exact crossing node preferable)	What sort of crossing is this?	Optional: Any other notes or observations? (possible improvements)	Are any of these features present?
2	26/05/2023 12:38:55		280	George st and king st, west side	10.8	10.2	21.2	6936407757	Pedestrian (green person)
3	26/05/2023 12:45:56		281	King st and York st, east side	6	11.2	27.2	10927817001	Pedestrian (green person)
4	26/05/2023 12:48:19		281	East of king and York st	8.9	11.5	25.5	10927817001	Pedestrian (green person)
5	26/05/2023 12:51:58		281	York and king st north	8	13	22	10927817004	Pedestrian (green person)
6	26/05/2023 12:56:48		2892	York and barrack st, south	10	11	35	10927835708	Pedestrian (green person)
7	26/05/2023 12:58:50		2892	Barrack st and York st, west	10	10	36	10927835707	Pedestrian (green person)
8	26/05/2023 17:09:03		237	Pitt st mall and market st, west side	10	8	67	3593631039	Pedestrian (green person)	Cars often blocking the intersection. Large pedestrian volume
9	26/05/2023 17:25:44			Regent st at Redfern st - the crossing to the station	10	13	101	1941652248	Pedestrian (green person)	Lots of pedestrians
10	26/05/2023 18:12:04		4545	McEvoy st at George st, nth/sth path	12	4	39	190036112	Bicycle (bike symbol)	Anecdotally has one of the fastest cycle times of bicycle traffic lights. Pressed bicycle beg button as soon as red of precious cycle.
11	26/05/2023 18:17:29			Bourke and George St, south-west	6	12	77	671952469	Pedestrian (green person)	Pedestrian (green person)
12	26/05/2023 18:20:30			Bourke and George st, south-west	6	11	74	671952469	Pedestrian (green person)	Other pedestrian pressed beg button
13	26/05/2023 18:31:25		526	Cleveland st and george st	12	4	104	7550999255	Bicycle (bike symbol)
14	26/05/2023 18:34:45		526	George st and Cleveland st, east side	8	8	104	7550999255	Pedestrian (green person)	Pedestrian and bike lights turn solid red simultaneously, however pedestrian light starts flashing red before bike light goes orange
15	29/05/2023 12:09:21		3041	York and erskine st, north	8	11	75	2999125455	Pedestrian (green person)	No ped crossing on south leg of intersection
16	29/05/2023 12:11:01		3041	York and erskine st, west	6	12	72	10935492527	Pedestrian (green person)
17	29/05/2023 12:15:41		3042	York st and Margaret st, east	22	13	32	10935500573	Pedestrian (green person)
18	29/05/2023 12:17:41		3042	York st and Margaret st south	7	14	40	10935500574	Pedestrian (green person)
19	29/05/2023 12:20:41		319	Clarence st and Margaret st, east	6	10	34	10188047947	Pedestrian (green person)
20	29/05/2023 18:17:54			King st and Pitt st, west	40	10	37	3593631035	Pedestrian (green person)
21	29/05/2023 18:23:24			Castlereigh and park st east	6	17	68	10936393450	Pedestrian (green person)
22	29/05/2023 18:28:24			-	7.4	18	64	5624232626	Pedestrian (green person)	Not protected during entire flashing red
23	29/05/2023 18:34:11			-	44	11	38	9309893760	Pedestrian (green person)
24	29/05/2023 18:36:14			-	7.3	16	55.6	10216883997	Pedestrian (green person)
25	29/05/2023 18:40:01			-	8.6	18.8	41.7	2039208753	Pedestrian (green person)
26	29/05/2023 18:42:13			-	17.2	14.7	41.1	4054127218	Pedestrian (green person)	Not protected on flashing red
27	29/05/2023 19:06:56		841	-	7.7	22.5	30.8	10936471816	Pedestrian (green person)
28	29/05/2023 20:29:03	08:15:00	I'll look next time	Spit Road by Bickell Road, Mosman	9-10 sec	11-12 sec (i didn't measure this. The total time from green man for pedestrian to green light for cars was 22 sec)	From 1min 28sec to 4min 18sec!		Pedestrian (green person)	The wait from pressing the beg button varied hugely but was often at or exceeding 2 mins
29	29/05/2023 23:01:51			-	8.4	14.4	62	4054127218	Pedestrian (green person)
30	31/05/2023 12:17:27		288	Martin place and Pitt st	17	7	45	15405025	Pedestrian (green person)	OSM appears to have two node ids	Countdown timers (orange number for time remaining instead of flashing red person)
31	31/05/2023 12:25:52			-	6.3	15	69.6	2268947005	Pedestrian (green person)	On eastern crossing cars can turn when red flashing ped light, but not northern or western
32	31/05/2023 12:29:48		315	-	15	4	86	10538888234	Bicycle (bike symbol)	Length of flashing red pedestrian parallel is longer than orange or bicycle lantern
33	31/05/2023 12:38:11			-	7.8	20.7	83	1800088617	Pedestrian (green person)	Red left arrow for cars turns off during flashing red of pedestrians
34	31/05/2023 12:41:31			-	7.3	23.4	84.1	960870167	Pedestrian (green person)
35	31/05/2023 12:46:56		423	-	5.6	17	64.3	3724300048	Pedestrian (green person)	Green ped light is very bright!	Countdown timers (orange number for time remaining instead of flashing red person)
36	31/05/2023 12:51:52		253	-	11.4	8.7	87	9936426580	Pedestrian (green person)	Green for slip turn starts at the same time, but stays green for longer (turns full red when north south car lights green)
37	31/05/2023 17:42:02			-	9	14.5	58	10941406244	Pedestrian (green person)	Often cars blocking crossing
38	31/05/2023 17:46:25			-	7.3	19	87	1157987739	Combined bike & pedestrian crossing	Cars blocking crossing. Lots of cyclists.
39	31/05/2023 17:52:48			-	8	22	77	13887497	Bicycle (bike symbol)	Narrow curb cut on north side
40	31/05/2023 17:59:49			-	8	7	75	3924594159	Pedestrian (green person)		Countdown timers (orange number for time remaining instead of flashing red person)
41	31/05/2023 22:15:30		416	-	6.5	24	24	3985408647	Pedestrian (green person)
42	31/05/2023 22:19:29		252	-	4.4	14	19	576277099	Pedestrian (green person)		Countdown timers (orange number for time remaining instead of flashing red person)
43	01/06/2023 09:13:43			-	17.8	14.4	62	4054127218	Pedestrian (green person)	Elizabeth st northbound still closed due to Surry hills fire
44	01/06/2023 09:19:13			-	6.2	21.3	34.3	3500777435	Pedestrian (green person)	Team also had green (white) light in same direction. Next cycle also had tram coming other direction.
45	01/06/2023 09:21:58			-	5.6	23.8	92.5	7048217086	Pedestrian (green person)	One team going westbound towards end of solid red
46	01/06/2023 09:33:20			-	7.3	16.1	88.9	10223437838	Pedestrian (green person)
47	02/06/2023 07:40:51			-	7.4	16.4	101	2708681807	Combined bike & pedestrian crossing
48	03/06/2023 12:12:33			-	8	13.5	34.4	10948221310	Pedestrian (green person)
49	03/06/2023 12:16:13			-	7.8	11.7	92.4	10213854308	Pedestrian (green person)
50	03/06/2023 12:25:07			-	6.1	10	26	5855284511	Pedestrian (green person)		Countdown timers (orange number for time remaining instead of flashing red person)
51	03/06/2023 12:27:03		4830	-	5.7	10	17.5	5855284511	Pedestrian (green person)	Low car traffic on a weekend	Countdown timers (orange number for time remaining instead of flashing red person)
52	03/06/2023 12:35:34		293	-	41.1	12.9	39.15	4054127224	Pedestrian (green person)	Weekend, Elizabeth st southbound closed due to Surry hills fire
53	03/06/2023 12:39:22			-	13.4	16	68.4	4054127218	Pedestrian (green person)	Weekend, Elizabeth st closed northbound due to Surry hills fire
54	04/06/2023 10:27:34			-	6.2	21.1	104	1769017639	Pedestrian (green person)	Missing bike lantern
55	04/06/2023 10:33:15			-	6.8	22.4	108.4	10950117061	Pedestrian (green person)	Weekend. Only one curb cut on east side for 2 crossings at 90 degrees
56	04/06/2023 11:27:32		4478	-	6.7	11.6	63.2	5386675571	Bicycle (bike symbol)
57	04/06/2023 12:08:25		452	-	6	13.45	51.5	8661385297	Pedestrian (green person)
58	07/06/2023 13:11:15		285	-	9.7	11	23.8	3420655031	Pedestrian (green person)		Countdown timers (orange number for time remaining instead of flashing red person)
59	08/06/2023 06:53:26	18:45:00		The Crescent and Johnson St Annandale, crossing The Crescent	6 secs	27 secs	50 secs	7637096828	Combined bike & pedestrian crossing	Lights are green for cars travelling south in same direction of crossing for a very long time. Bike green can be much longer . Intersection prob most dangerous and least efficient that you have seen
60	08/06/2023 20:32:50	14:00:00		Parramatta Road and Bland Street crossing Parra Rd	8	17	75	10964543776	Pedestrian (green person)
61	09/06/2023 12:15:06	17:02:00		Cambridge street & Oxford Street Epping - https://goo.gl/maps/jcF8QHGV8LbYtwNw8	16	24	41	176835402	Pedestrian (green person)	On one side entry is restricted to buses & taxis only - the other side has no specific restrictions that are signposted
62	09/06/2023 14:09:34	08:15:00		Crossing Parramatta Road to the east of the intersection with Dalhousie Street in Haberfield	8	16	105	10031352014	Pedestrian (green person)	Directly outside Ashfield Park so an important pedestrian crossing into Haberfield
63	14/06/2023 12:45:47		243	-	6.07	17.96	21.74	10188082797	Pedestrian (green person)
64	14/06/2023 12:47:16			-	6.3	18.2	40.04	10188082797	Pedestrian (green person)
65	14/06/2023 12:48:54			-	5.77	14.6	44.34	10188082798	Pedestrian (green person)
66	14/06/2023 12:50:48			-	5.92	14.62	44.99	10188082798	Pedestrian (green person)
67	14/06/2023 12:53:31			-	7.07	15.33	78.28	10188082798	Pedestrian (green person)
68	14/06/2023 12:56:09			-	7.12	15.67	56.43	10188082798	Pedestrian (green person)
69	17/06/2023 12:50:29		35	-	7.83	14.61	37.4	10981819781	Pedestrian (green person)
70	17/06/2023 14:05:42	17/06/2023 13:30:00		Crossing Bridge Street at intersection with Pitt on Western side	6	19	40	10188082788	Pedestrian (green person)
71	17/06/2023 14:08:36	17/06/2023 13:30:00		Pitt Street at intersection of Bridge Street, Southern side.	6	15	44	10188082798	Pedestrian (green person)
72	18/06/2023 18:31:31			-	6.15	22.41	68.61	1810708078	Pedestrian (green person)	Great candidate for countdown timer
73	18/06/2023 18:35:46			-	8.05	8.33	17.4	3072743463	Pedestrian (green person)	Very high number of people crossing on solid red - narrow road width and large setback from intersection. Essentially has a dedicated slip lane but without island.
74	18/06/2023 18:39:43			-	8.79	8.79	18.53	3072743463	Pedestrian (green person)	Slip lane (car left turn lantern) almost instantly allows cars after pedestrian lantern turns solid red (when on that half of the cycle - otherwise cars come from the east)
75	18/06/2023 18:43:12		252	-	6.3	14.15	30.38	576277099	Pedestrian (green person)		Countdown timers (orange number for time remaining instead of flashing red person)
76	23/06/2023 22:21:37		839	-	7.94	17.37	88.6	2355782699	Pedestrian (green person)	Missing pedestrian crossing
77	26/06/2023 15:05:17			-	6	17.7	65.2	5663268549	Pedestrian (green person)
78	26/06/2023 15:07:53			-	33	16.8	38.48	8519344335	Pedestrian (green person)	Very long green! Not synced with green ped crossing further east (2 crossings needed)
79	26/06/2023 15:11:13			-	7.3	15.6	67.7	7895181247	Pedestrian (green person)	Tiny island at north side. Connects cycleways but has no cycle lantern or lane.
80	26/06/2023 15:17:28		289	-	7.42	12.63	38.8	9991792458	Pedestrian (green person)	Cars crossed on green, not just red!
81	26/06/2023 15:19:53			-	9.77	13.27	23.02	8954172812	Pedestrian (green person)
82	26/06/2023 15:23:42		692	-	6.99	11.58	72.78	8954151372	Pedestrian (green person)	Car light goes green right as ped light flashes red. Car light goes red before ped light stops flashing! In sync with bike lantern at west.
83	26/06/2023 15:33:17		4096	-	5.4	13.76	83.67	2830871834	Combined bike & pedestrian crossing	Didn’t skip ped cycle
84	26/06/2023 15:43:15		1009	-	6.19	17.71	52.17	1850061344	Combined bike & pedestrian crossing	Ped and cycle lanterns in sync
85	26/06/2023 15:48:19			-	8.21	7.79	24.35	1850061344	Combined bike & pedestrian crossing	In sync with lights on other carriageway road (not enough time to cross both roads in one green)
86	26/06/2023 15:49:33			-	7.24	7.73	23.61	1850061344	Combined bike & pedestrian crossing
87	26/06/2023 15:54:36			-	8.11	22.26	124.14	1833330993	Pedestrian (green person)
88	26/06/2023 15:58:33			-	7.59	29.05	98.48	5382815755	Pedestrian (green person)	Signals across northbound and southbound synced, but there is an island and cars can cross on flashing red - unclear if you reach half way you have to let cars cross because you’re entering a crossing on flashing red.
89	26/06/2023 16:05:54			-	6.31	28.72	90.39	1319751026	Combined bike & pedestrian crossing	The only ped crossing on all 4 sides of this intersection. Light for bus lane ped crossing is red even when it’s physically impossible for a bus to enter/exit (and cars turning left) - high rates of pedestrians disobeying light.
90	26/06/2023 16:09:12			-	8.29	22	75	1845011913	Pedestrian (green person)
91	06/07/2023 17:22:21		719	-	5.95	13.72	112.31	11029534306	Pedestrian (green person)	Witnessed two near crashes of cars northbound turning right and cars southbound turning left (no green filter)
92	06/07/2023 17:30:22		54	-	6.1	15	99.05	11029548769	Pedestrian (green person)
93	06/07/2023 17:46:34			-	14	3	104.34	7550999255	Pedestrian (green person)	Green and flashing red going likely not accurate, but length of red is
94	08/07/2023 13:19:42			-	5.6	16.75	91.6	7764047943	Pedestrian (green person)
95	08/07/2023 22:02:58	08/07/2023 16:51:00	4815	(-33.9116476, 151.1777953) Campbell Rd at St Peters St. Western crossing.	7	8	38	10316095778	Combined bike & pedestrian crossing
96	09/07/2023 15:05:11			-	7.9	18.7	73.61	3984331291	Pedestrian (green person)
97	09/07/2023 15:08:47			-	7.12	22.41	76.07	1941652154	Combined bike & pedestrian crossing
98	09/07/2023 15:13:27			-	7.7	22.08	56.82	1941652154	Combined bike & pedestrian crossing	All pedestrian lights have same phase (like a scramble), but no scramble crossing markings	Scramble crossing (all pedestrian lights turn green simultaneously)
99	09/07/2023 15:15:56			-	7.92	22.56	83.78	1941652154	Combined bike & pedestrian crossing		Scramble crossing (all pedestrian lights turn green simultaneously)
100	09/07/2023 15:28:21			-	6.07	22.21	67.32	9301941935	Pedestrian (green person)