Database Schema(s) and/or Entity Relationship Diagram(s) for the database(s) that contain details on types, locations, timings, sequences, etc for traffic signals and traffic signal controllers managed by TfL, including both UTC/SCOOT and those that operate outside central control.
The controller is running configuration 66036 9.0 Checksum 9E BB 74 1E (attached). The site is on our UTC Cell EAST, Region 0716.
The timetable for R0716 is:
MON Timetable Source File For Group G0716
G0716;Barking Road / Upton Park
00:00 SCON 05 R716 ;WAT M-Su
05:00 SPAR TRND R716=ON ;WAT M-F
05:00 SPAR MAXC R716=96 ;WAT M-F
07:00 SCON 01 R716 ;WAT M-F
09:30 SPAR TRND R716=OFF ;WAT M-F
10:00 SPAR MAXC R716=88 ;WAT M-F
10:00 SCON 02 R716 ;WAT M-F
13:00 SPAR MAXC R716=96 ;WAT M-F
15:00 SPAR MAXC R716=104 ;WAT M-F
15:00 SCON 03 R716 ;WAT M-F
20:00 SPAR MAXC R716=88 ;WAT M-Su
20:00 SCON 08 R716 ;WAT M-Su
TUE Timetable Source File For Group G0716
G0716;Barking Road / Upton Park
00:00 SCON 05 R716 ;WAT M-Su
05:00 SPAR TRND R716=ON ;WAT M-F
05:00 SPAR MAXC R716=96 ;WAT M-F
07:00 SCON 01 R716 ;WAT M-F
09:30 SPAR TRND R716=OFF ;WAT M-F
10:00 SPAR MAXC R716=88 ;WAT M-F
10:00 SCON 02 R716 ;WAT M-F
13:00 SPAR MAXC R716=96 ;WAT M-F
15:00 SPAR MAXC R716=104 ;WAT M-F
15:00 SCON 03 R716 ;WAT M-F
20:00 SPAR MAXC R716=88 ;WAT M-Su
20:00 SCON 08 R716 ;WAT M-Su
WED Timetable Source File For Group G0716
G0716;Barking Road / Upton Park
00:00 SCON 05 R716 ;WAT M-Su
05:00 SPAR TRND R716=ON ;WAT M-F
05:00 SPAR MAXC R716=96 ;WAT M-F
07:00 SCON 01 R716 ;WAT M-F
09:30 SPAR TRND R716=OFF ;WAT M-F
10:00 SPAR MAXC R716=88 ;WAT M-F
10:00 SCON 02 R716 ;WAT M-F
13:00 SPAR MAXC R716=96 ;WAT M-F
15:00 SPAR MAXC R716=104 ;WAT M-F
15:00 SCON 03 R716 ;WAT M-F
20:00 SPAR MAXC R716=88 ;WAT M-Su
20:00 SCON 08 R716 ;WAT M-Su
THU Timetable Source File For Group G0716
G0716;Barking Road / Upton Park
00:00 SCON 05 R716 ;WAT M-Su
05:00 SPAR TRND R716=ON ;WAT M-F
05:00 SPAR MAXC R716=96 ;WAT M-F
07:00 SCON 01 R716 ;WAT M-F
09:30 SPAR TRND R716=OFF ;WAT M-F
10:00 SPAR MAXC R716=88 ;WAT M-F
10:00 SCON 02 R716 ;WAT M-F
13:00 SPAR MAXC R716=96 ;WAT M-F
15:00 SPAR MAXC R716=104 ;WAT M-F
15:00 SCON 03 R716 ;WAT M-F
20:00 SPAR MAXC R716=88 ;WAT M-Su
20:00 SCON 08 R716 ;WAT M-Su
FRI Timetable Source File For Group G0716
G0716;Barking Road / Upton Park
00:00 SCON 05 R716 ;WAT M-Su
05:00 SPAR TRND R716=ON ;WAT M-F
05:00 SPAR MAXC R716=96 ;WAT M-F
07:00 SCON 01 R716 ;WAT M-F
09:30 SPAR TRND R716=OFF ;WAT M-F
10:00 SPAR MAXC R716=88 ;WAT M-F
10:00 SCON 02 R716 ;WAT M-F
13:00 SPAR MAXC R716=96 ;WAT M-F
15:00 SPAR MAXC R716=104 ;WAT M-F
15:00 SCON 03 R716 ;WAT M-F
20:00 SPAR MAXC R716=88 ;WAT M-Su
20:00 SCON 08 R716 ;WAT M-Su
SAT Timetable Source File For Group G0716
G0716;Barking Road / Upton Park
00:00 SCON 05 R716 ;WAT M-Su
08:00 SPAR MAXC R716=88 ;WAT Sa-Su
08:00 SCON 02 R716 ;WAT Sa-Su
12:00 SPAR MAXC R716=104 ;WAT Sa-Su
12:00 SCON 03 R716 ;WAT Sa-Su
20:00 SPAR MAXC R716=88 ;WAT M-Su
20:00 SCON 08 R716 ;WAT M-Su
SUN Timetable Source File For Group G0716
G0716;Barking Road / Upton Park
00:00 SCON 05 R716 ;WAT M-Su
03:30 CC 05 R716 ;mins check
04:00 SCON 05 R716 ;mins check
08:00 SPAR MAXC R716=88 ;WAT Sa-Su
08:00 SCON 02 R716 ;WAT Sa-Su
12:00 SPAR MAXC R716=104 ;WAT Sa-Su
12:00 SCON 03 R716 ;WAT Sa-Su
20:00 SPAR MAXC R716=88 ;WAT M-Su
20:00 SCON 08 R716 ;WAT M-Su
The UTC Plans currently are :
AM PEAK SCOOT PLAN (WAT) OFF PEAK SCOOT PLAN (WAT) PM PEAK SCOOT PLAN (WAT)
Plan 1 Cycle 96/F Plan 2 Cycle 88/F Plan 3 Cycle 104/F
001/F1,DUM.99/1 (38) 001/F1,DUM.99/1 (35) 001/F1,DUM.99/1 (45)
039/F2.9/2 (1) 036/F2.9/2 (1) 046/F2.9/2 (1)
040/F1F2,NTO.99/2+ (12) 037/F1F2,NTO.99/2+ (12) 047/F1F2,NTO.99/2+ (13)
052/F3,DX.9/3 (25) 049/F3,DX.9/3 (20) 060/F3,DX.9/3 (25)
077/F4.16/4F (1) 069/F4.16/4F (1) 085/F4.16/4F (1)
078/F1.36/4F+ (19) 070/F1.36/4F+ (19) 086/F1.36/4F+ (19)
OVERNIGHT SCOOT PLAN LATE EVENING SCOOT MINS CHECK
(WAT) PLAN (WAT) Plan 32 Cycle 72
Plan 5 Cycle 80/F Plan 8 Cycle 88/F 001/F1.15 (22)
001/F1,DUM.99/1 (29) 001/F1,DUM.99/1 (35) 023/F2,DX.9 (9)
030/F2.9/2 (1) 036/F2.9/2 (1) 032/F3,DX.8 (15)
031/F1F2,NTO.99/2+ (12) 037/F1F2,NTO.99/2+ (12) 047/F4,DX.14 (26)
043/F3,DX.9/3 (18) 049/F3,DX.9/3 (20)
061/F4.16/4F (1) 069/F4.16/4F (1)
062/F1.36/4F+ (19) 070/F1.36/4F+ (19)