AC Transit Enterprise Database & Applications Manjit K. Sooch Alameda – Contra Costa Transit District (AC Transit) Director of Systems & Software Development Oakland, California
9
6/18/2015
2
AC Transit Systems and Enterprise Database Key Performance Indicators( and Reports
\
Ellipse Asset Management System Equipments, Vehicle Miles, Vehicle, Work Order, Parts, I nventory
Q)
Operator TimeKeep ing System HP3000 Operator Bus Pull Out D ata
I
"' .D "'
L-----------~-~
-"'"'
----
0
Q)
"'
·;;:
eQ)
"E
UJ
Hast us Schedule Data
U T AAPC Ridership Data Monthly Ridership by Routes
--~--~--,......-; Road calls Application
l ~
rt:: -;;;
Q)
"' "§ .c "' u
- -"' .,.. "'
:I:
0
~
I< Q.o Q) E .,..
-
"' i7 ..c
c;;
Q)
"'
Peo pleSoft Finance and H R System Passenger Fare Accounts, Employees, Departments, TRCs, TRC Hours
"'
c:r::: Cl
Incidents, Arrivals, Routes, Time points, etc.
10
Customer Feedback System Tickets and Customer Data
3
6/18/2015
Decision Makers are… Managing with KPI’s
Managing with KPIs
Frequency: Daily, Monthly, Quarterly, Yearly
11
4
Critical Key Performance Indicators and Data Source #
KPI
Data Source
1
On-Time Performance
CADAVL (Arrivals)
2
Operator Log-On Rate
OTS (Bus Pull Outs, Operator Logons)
3
Maintenance Road Calls
Ellipse (Vehicle Miles) Road Calls Application (Road Calls)
4
Service Operated Percentage
CADAVL (# Incidents, # Trips Scheduled)
5
Accident Rates
Ellipse (Vehicle Miles) People Soft (# Accidents)
6
Maintenance Manpower Unavailability
PeopleSoft (TRC, Department, Attendance)
7
Operator Unavailability
PeopleSoft (TRC, Operator Attendance)
8
Ridership
APC (Average Passengers)
9
Service Efficiency Standards
PeopleSoft (Passenger Fare Revenues)
10
Customer Complaints
CusRel Application (# Complaints), APC (Ridership Boarding's)
11
Fare Revenue
PeopleSoft FIN(Accounts)
12
5
Dashboard Dashboard
Key Performance Indicators-
Transportabon-
Ubhbes-
KPI
Mi~
se·r ween ChafQ
On Time PRrforman~ Mire-s Between Cl'large~bie Road Calls
/'...._ -----....
S9JV1C41! Ope:ratad. Rollout
M~renance
Manpower UnavaUb.-y
22%
Operator Unavailabt&;tty
225%
Logon Rate
05%
_,?---~-------
~-
....... 22.8S'M.
&91:W.
N.IA
RideDhrp, Aven~ge Dafly Passengers Sennee EffiCJI!ncy SUIJ'tdard~
N 1A
Pay Hours to Platform Hou.rs
..
NJA Cu:stomer Complaints Compla..na; Per 100K Boardmgs
-----,--
,..,..,..
,.,..,..,,
$t.p' l4
U:tl' ' l 5
. . .y'l5
Set"vtoe Operated, Rotlouc
•
'""
.
- 1 ~ ...v ~ ""'=7 .
•
.. ..
V'
20
'l
Jul' l,.
s., ' 14
Nov ' 141
hn'16
M.r' l6
Miry 't6
.
..
~----~-------------------------------------,-t4ov ' 14
.Jo.A'14
..t.n'l5
Mw-' 16
Logon RMe
Jul 'l4
Mlly'Hi
Rklershlp, Aver,a.ge Deily
"-" '14
Ng.v ' 14
J.-. ' 16
..,.,,
Mly'15
Pes~
.. ~· I
..
u.~~~~~--~~~-S-.p'l4
JW~'t5
J:11n'U
l.'b.- '16
Compt.alncs Perr 100K BoerdJ~s
S.p'l4
tW.V '14
.bri ' Hi
hbr '15
....,. '15
>200000
......
,
·;L 20
13
p
•
I
e •
0
0
#
,Jul'l4
hby'15
.U'14
$.ep't4
..bill ' 15
6
6/18/2015
On Time Performance KPI -
~
+f ile
.Edit
~ew
F1vorites
I ools
l t MVACT- Home lP SuggestedSJtes ..,.. @)WebSiiceGallery ...,. .@) ACTran~it
.
• ---
-
tlelp
I
Ready l oCiose
-.#-J.~r Alameda-Contra Costa Transit District Dashboard
•
Key Perfonnance lndx:ators•
TransportatJon ...
f requency - Monthly
Roule
~
Ublltles•
Direclion
Day Type
r.IAI::;I=::.:_----,v c:ll ~
Daily Weekly
Monthly - Systemwide OTP for Division System Wide For Route -All & Direction -All ~ --- ~ --- T¥Qel:
100%
90%
..,.. D4 D2
D6
All
l
,...
..E .... ~ c:
.g
50%
.,~ .,E
....
c: 0
30%
20%
,...
... Frequency: Daily, Monthly, Quarterly, Yearly 0 2015 - AC Transn. All14Rlghls Reserved.
-
-------~,
l'l*ll_ 'l
7
6/18/2015
Logon Rate KPI - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - 1
------------------------------------------------------------------------
_+- ·~, ~ ~ · f ile
~dit
~ew
F.tvorites
!ools
Dasht>oaro
-
Key Performance ln
@J AC Transit I
Transponauon •
Ready To Close
utlllhes ·
Daily
Q .;
Monthly- % LOG-ON RATE FOR DIVISION System Wide
Frequency - Monthly I...... Actuai ...... TMoet 100%
Weekly 90%
~
~
~
~
l&
i&
~
00"4
~ 83.21
S8.6S
~
~
~
iii"'
"'~
"'~
~
::;
70%
~
60%
w
04
s
02
0
z
06
§
50"4
311%
All 211%
I ll%
0"4 ~
~
~
iii
iii
~
§'
"'
~
X
1'1*ll
tlelp
Suggested Srtes ~ @) Web Shce Gallety ...
C
~
~
%
C 2015 - AC Transit. All Rights Reserved.
15
iii"' ~
,. ~
~
8
6/18/2015
Miles Between Chargeable Road Calls KPI ---
~ ~ ~ ~· f ile
fdit
~~
F1vorit6
!ools
Dashboard
•
~ Web SliceGallety •
Key Performance lndecators •
~ AC Transit
I
ReadyToCiose
Transportation •
Frequency - Monthly
@Chargeable
0
Non~hargeable
0
All
Daily
Monthly- Miles Between Chargeable Road Calls for Division System Wide
Weekly ..._ Actuai . . . Taroet
aooo
7000
6000
D4
-'!)
D2
'"
D6
""
u
All
"0
~ 5000
J_J
"'~
:f
_j ~J IOOl ~
L
--~
- ..... c .__!_
ft*ll
J:::1elp
Sugg6ted Srtes •
-
iii ~
C 2015 · AC Transit All Rights
16
Reserve<~
9
6/18/2015
Service Operated KPI -
- -- - - - - - - - -
---------- -----
+-_,.t~ ~ ~ · ~dit
f ile
11,
¥-~
FJvOrit:H
! ools
Dasnt>oard
•
@)W~SiiceGallety • ID ACTransit I
Key Pelformance ln
TransportaMn •
Frequency - Monthly
@ Rollout
0
ReadyToCiose
utlllhes ·
All Service Disruptions
Daily
Monthly - Service Operated(%) With Rollout for Division System Wide
Weekly ...._ Actuai ...._ Taroet 101%
100%
..... 96%
04 02 06
l ]l ~
"'a. .\I "' i! 0
All
~
97%
96%
95%
9'1%
93%
92%
91%
90%
L
~
~
~
~
~ ~
~
~
~
&
0
!
-1
-~
c
~
ft*l:!
!:felp
EJ> MVACT - Home ~ SuggestedSrtes •
-
tl
~
~
z~
~
~
~
~
~
~
~ ~
~ ~
~ ~
~
~
~
C 2015- AC Transit All Rights Reserved
17
~
:
~
:E
10
6/18/2015
Accident Rate Per 100k Miles KPI ~- - ~~,. o_.___ x~
+- ~J ~ ~ · f ile •
f.dit
~iew
Fjvorites
lJ> MYACl· Home
!ools
ft* _l:l_
t:!.elp
SuggestedSrtes .... @:! WebShceGallery .... ID ACTransit
I
Readylo(lose
AIJ~r
~fi ~ Alameda-Contra Costa Transit District Dashboard
•
Key Performance lnchcators .....
frequency - Monthly
Weekly
Transportation .....
Utllrt.es ....
Accident category Preventable IVehicleCollisionsv ii~.:. AI;:ol_ _ _ _ _ v..JI
Monthly- Accident Rate Per 100k Miles for Division System Wide Vehicle Collisions- Preventable & Non-Preventable
04
02 06
All
~
~
~
~
~ ~
~ !'
~
~
..
~
1l
0
~
~
~
z
~
~
~
C 2015- AC Transit All Rtghts Reserved.
18
"'~ ~
"'~ ~
"'~ ~
"
"'~
:
"'~
~
"
11
6/18/2015
Total Maintenance Manpower Unavailability KPI --
----------------
~ '+ ~ ~ ~·--file
•
f dit
~iew
ftvorites
6} MYACT·Home
b
!ools
tlt:lp
Suggestt'dSrtes ,.. @) Wri>Siice:Gall~ .,. @J AC Tramit I
Readylo Ciose
----
-JIJ~~r Alameda-Contra Costa Transit District Dashboard
Key Performance IndiCators ..
• frequency - Monthly Biweekly
Transportation .....
utlllbes •
Manpower Unavailability Type
Maintenance Department Maintenance Group
ITotal Maintenance Manpower Unavailabil vii ALL
vi IAL=L c. __________v...JI
Monthly - Total Maintenance Manpower Unavailability(%) Quarterly
ALL- ALL
C 2015- AC Transit All Rtghts Reserved
19
---------
--
--~- - ~~ o _..__ ?C _
f'I* _El_
12
6/18/2015
Total Operator Unavailability KPI ~- - ~~,. o_.___ x~
+- ~J ~ ~ · f ile •
f.dit
~iew
Fjvorites
lJ> MYACl· Home
!ools
ft* _l:l_
t:!.elp
SuggestedSrtes .... @:! WebShceGallery .... ID ACTransit
I
Readylo(lose
AIJ~r
~fi ~ Alameda-Contra Costa Transit District Dashboard
•
Key Performance lnchcators .....
Transportation .....
frequency - Monthly
Utllrt.es ....
Unavailability Type
ITolal Operalor Unavailability
Biweekly
vi Monthly- Total Operator Unavailability(%) for Division- System Wide
04 21%
02 06
All
18<'1..
l
~IS"!..
:0 !!!.
-~
12"1..
c:
=>
9%
6%
,.. ~
"'~
~
iii g
~
iii ~
z
~
iii
:!
C 2015- AC Transit All Rtghts Reserved.
20
iii"' ~
iii"'
;!i
iii"' ~
::;
iii"'
~
"'
"'
~
:;
13
6/18/2015
Average Daily Passengers Ridership KPI ~ - - ~~,. o_.___ x~
+- ~J ~ ~ · file •
f.dit
~iew
Fjvorites
lJ> MYACl· Home
! ools
ft* _l:l_
t:!.elp
SuggestedSrtes .... @:! WebShceGallery .... ID ACTransit
Key Performance lnchcators .....
Transportation .....
Month
I
Readylo(lose
Utllrt.es ....
Report
Day Type
1 ;.;sy;::::;st'='em=w::;ide:;::----,v:-:11 I Average Daily Passenger; v I I Weekday v I
Sign Up Period
Ridership - Average Daily Passengers System Wide -Weekday 210000
200000 190000 18(l(XXI 170000 1600>) 150000
.,
~ 140000
~130000
~
120000
"'
"- 110000 1?:
·;;;
., .,~>
100000
0
<(
90000
80001 70000
""" 50000
40000
30000 20000 10000
August 2014
September 2014
October 2014
November 2014
December 2014
Monthly
C 2015- AC Transit All Rtghts Reserved.
21
January 2015
February 2015
March 20 15
14
6/18/2015
Fare Revenues KPI ~ - - ~~,. o_.___ x~
+- ~J ~ ~ · f ile •
f.dit
~iew
Fjvorites
lJ> MYACl· Home
!oo1s
ft* _l:l_
t:!.elp
SuggestedSrtes .... @:! WebShceGallery .... ID ACTransit
Key Performance lnchcators .....
Transportation .....
I
Readylo(lose
Utllrt.es ....
Report Type
Display
F'=a'=re::;R';:e:':v='e:C nu::: es:-----cv::![ @ Systom Wido 0 By Type 0 By Cotogory
fi[
Quarterly
Monthly- Fare Revenues - System Wide Annual
$-4,800,000
$4,i00,000
$4,000,000
$3,600,000
§
$3,200,000
"'c "'~ •~a l a: :;>
$2,iOO,OCJO
~
"'
LL $2,000,000
$1 ,600,000
$ 1,200,000
saoo,cm $400,00J
$0
~
..go
~
"'
1l 0
~
z
~
0
C 2015 · AC Transit All Rtghts Reserve<~
22
15
6/18/2015
Customer Complaints/100K Boarding KPI ~- - ~~,. o_.___ x~
+- ~J ~ ~ · file •
f.dit
~iew
Fjvorites
lJ> MYACl· Home
!ools
ft* _l:l_
t:!.elp
SuggestedSrtes .... @:! WebShceGallery .... ID ACTransit
Key Performance lnchcators .....
Transportation .....
I
Readylo(lose
Utllrt.es ....
Report
IComplaints Per 100K Boardings vi Quarterly Annual
Monthly - Customer Complaints/100K Boardings ....._ COfll)laintsPerlCXJ:: ....._ Taroet
100
90
"" "'en c
70
"' dl
60
~
"'00 ~ c
.'i'i. E 0 u
50
" "' 20
10
C 2015 - AC Transit All Rtghts Reserved.
23
16
6/18/2015
Public Facing KPI --
_±_ , ~ ~ · fil~
f.dit
~~
f,lvorit~
Iools
-
-~1
ft*P
tf4!!lp
@:I Web Slice Gallery • @) AC Transit I
Ready To Close
On Time Pelformance
Key Performance Indicators
Miles Between Chargeabte Road Calls Customer Complaints Per 100K
On T1me Performance
Board1ngs Ridership: Average Weekdays
Passengers Fare Revenues
'""'
• • ~
• • • • • • • •
......
• •
.....
L __ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ __
.,
Fob
....,
Miles Between Chargeable Road Calls
----------------------------------------------------~
----------------------------------------------------------------------------------------------------------------------
24
17
6/18/2015
1110
.. "'
..
20
FsreReveooes
•
.-----·---.--~--~--··---.--~·~
.... .,..
""',.
.,. ""'
' 1S ""
"" '15
Ridership: Average Weekdays Passengers
1"'.1100 1110.1100
111111111111 .,. ""'
Fare Revenues
56.CIXI.OIXI
1-t.Dl.OIXI
'""'""' "-""""' 51.2IXI.OOO
..
...
25
18
6/18/2015
Reporting Tool: SQL Reporting Services Home > Maintenance and Mater ials > Ellipse > Preventat ive Maintenance > Inspection Statistics Report Complete Sta rt
'-ls'/-' 1/_2_0 1_4_ _ _ _ _ _ ____,111!l
Report Ty pe
IMajor & Minor Inspection St at istics VI 1100%
Complete End
Home
View Report
Total Count Late -
40%
1::
3 3
,..,
2
:J 0
u
c
Ill
4
On Time
80%
0
...J
ro
0 >-
20% 0% D2
Help
Completed Dates: 8/1/2014-8/31 /2014
Percent On Time
60%
I Site Settings I
vi
100%
.,
My Subscriptions
'-81.:.../3_1_;_/_20_1_4_ _ _ _ _ _ __,1 illl!l
Maj or & Minor Inspection Statistics Report
~
I
D4
3
3
D2
D4
2 1 1 0
D6
Division
-
Lote
0 D6
Division
Division
Work Grp Date
Bus
Task
02
2014-07-28
0007
9030
Work Order Sched Date Compl Date Sched Stat Completed Stat 543484
02
2014-07-28
1016
9030
541202
2014-08-01
2014-08-01
365,516
02
2014-07-28
1059
9030
541219
2014-08-01
2014-08-01
545,501
02
2014-07-28
1086
9030
542864
2014-08-02
420,093
02
2014-07-28
1093
9050
542866
2014-08-02
434,810
02
2014-07-28
1099
9050
543457
2014-08-06
2014-08-02
02
2014-07-28
1338
9030
541285
2014-08-01
02
2014-07-28
1343
9050
543494
02
2014-07-28
1347
9030
02
2014-07-28
1348
02
2014-07-28
1352
02
2014-07-28
02 02
Early late
Status
-406.00
On_Time
365,203
-313.00
On_Time
545,388
-112.60
On_Time
419,824
-268.90
On_Time
434,644
-166.20
On_Time
417,013
416,656
-357.50
On_Time
2014-08-01
72,000
71,868
-132.50
On_Time
2014-08-06
2014-08-02
63,080
62,531
-549.30
Early
541296
2014-08-02
2014-08-01
60,000
59,817
-182.70
On_Time
9030
541300
2014-07-31
2014-08-01
66,041
65,881
-159.60
On_Time
9050
542855
2014-08-01
57,027
56,927
-99.70
On_Time
1355
9030
541312
2014-08-01
2014-08-02
72,000
71,740
-260.30
On_Time
2014-07-28
1358
9050
543512
2014-08-04
2014-07-28
1362
9050
542854
2014-08-04
2014-08-01
90,000
89,594
2014-08-02
63,000
62,710
-289.70
On_Time
2014-08-02
69,000
68,651
-348.80
On_Time
26 Maintenance: Inspection Statistics Report
-
...,
19
6/18/2015
Reporting Tool: Email Notification from SQL Reporting Services Transbay Dispatch Concerns
Weekday Schedule 9/26/2014
Evaluating Hastus blocks, OTS bus pull outs and Ellipse vehicles
9.48 % Overall Vehicle Dispatch Concerns 3.45 % Incorrect Vehicle 6.03 % Overcapacity Hastus
Vehicle Type 0
TB40
°/o
Overcapacity
07:19:00
12:1 2 :00
Incorrect Veh
MCI
BUS: GILLIG,2014
6152
07: 38:00
09:1 3:00
Incorrect Veh
MCI
BUS: GILLIG,2014
6151
07:33:00
09:48:00
Incorrect Veh
BUS : GILLIG,2014
61 34
06:22:00
08:56:00
Overcapacity
102002
B
06: 22:00
08:56:00
ST40
103001
c
05:14 :00
09:06: 00
ST40
BUS : GILLIG,2014
61 29
05:14 :00
09:06:00
Overcapacity
103003
658/ C
06:33:00
09: 23:00
ST4 0
BUS : GILLIG,2014
6114
06:33:00
09:23:00
Overcapacity
124008
NL
05: 24 :00
09:54: 00
ST40
BUS : 2002 MCI D450055645C
6077
05: 24:00
09:54 :00
Overcapacity
129015
NX
06: 50:00
08: 17: 00
ST40
BUS : GILLIG,2014
61 27
06:50:00
08:1 7 :00
Overcapacity
129017
638/ NX
07: 00:00
09: 11: 00
MCI
BUS : GILLIG,2014
61 36
07:00:00
09:11 :00
Incorrect Veh
129019
NX3
07: 34 :00
09:20: 00
ST4 0
BUS : GILLIG,2014
61 26
07:34:00
09:20:00
Overcapacity
5.88 M
°/o
06:52:00
Overall Concerns
10:45: 00
0
ST40
Transbay Dispatch Concerns
°/o
Incorrect Vehicle
BUS : GILLIG,2014
27
6118
5.88 °/o Overcapacity
06:52:00
10:45 :00
Overcapacity
20
6/18/2015
Comparison Table Before and After Enterprise Database Department and Application
Before
Training and Education Management System
Legacy Access Database
Customer Service Complaint System
Legacy Classic ASP Application
Information Service AD Updater N\A Scheduling Bus Stop Work Order System
N\A
Mobile Website
Legacy PHP web page
Key Performance Indicators (KPIs)
Manual KPIs
28
After
Web Based .NET MVC HTML5 Application, data stored in SQL Server Database and using Enterprise Database for other sources
21
6/18/2015
Comparison Table Before and After Enterprise Database Department and Application
Before
After
Maintenance PMI, Vehicle Location, Road Calls Reports, Vehicle Miles, Materials and other Asset Management Related Reports
Manual and legacy reports
SQL Server Reporting Services (SSRS) Reports
Fuel Tank Monitoring System
Veeder Root Desktop only
Sever Application Veeder Root, Inform.net version 1.1.0.7
Scheduling System Upgrade
Hastus 2006
Hastus 2012
Operator Signup System
Legacy Access Database
Hastus BID 2012
Internal Employee Portal
SharePoint 2007
SharePoint 2013 Office 365
29
22
6/18/2015
Training and Education Web Application -
+file
-+ ~ rllllllllllllll · f.dlt
Fc 1
1'1
- x- 1
*a
'f!t!W FJ.vorltes Iools tfelp
:-il,~r Training and Education .,. Course Enrollments Home
Course Type
Ctass DescnptJons
course Enrollments
Transportation, Maintenance, Other
@
Attendance
Course
Resources..
Hello ACTRANSIT\alajad
Adm•n •
Accident Training, All Hazards Awaret@
Employee
Employee Badge
~Just show current schedules
From
312612015
. / To
+ AcckJent Training + All Hazards Awareness/Preparedness for Transit EEs + Braun Lift Training
+ Bus Operator Retum from Leave - Engine overnaul aoo Trout>teshooting - HDCMAP
- 02102115-05119/15 (4·00 PM- 7·30 PM) Bi!dge
Trainee
Department
Divi sion
042021
Alfredo Vega
D-6 Garage
TED
042594
Jason Regoo
Revenue Vehk:te Maintenance
TED
041703
VICtor PterSOO
D-4 Garage
TED
042632
Mercedez Tarrant
Revenue VehK:te Maintenance
TED
042667
Ph~ll•p sala.c:es
Revenue Vehk:te Maintenance
TED
042726
Shawn Willtams
D-2 Garage
TED
Jr
+ Maintenance Coach QT/Ol 170 + New Bus Operator
+ New 5ervlce Empk:lyee QT + Retum from Leave Training
+ STB (Small Transit Bus Eklorado E-450) Maintenance + Sleeting and Suspension HDCMAP
30
Note
.... .... ....
M
Attendance
Attendance
Attendance
Atten
Attendance
Attendance
23
6/18/2015
Customer Relations Web Application Hello atajadod 1Log on
Customer Relations • Tickets • Update
Home
Reports •
Resources •
~ ~ ~ ~ ~ ~
. . . GO
Admin •
Help
PMINom\al
PMINoName
save
llcket 371113 (OPEN) Pass-Up
Reuon Code1 •
COntact Hostory
Customer
Reason Code 2
First Name ·
Girtle
Incident Date/Time *
Last Name •
Pans
Boarding Locarton
comments Not AppliCable
Address 1
City
Select..
Address 2
Route
200
City
Dtviskm
GO
State
v;.
Employee
Comment
Date& Time
CA {no data)
Direction of Travel
Fremont Bart
Vehide Number
1409
Email
Operato.- Badge
42999
Phone
Operator Name
GRI FFIN, KATHERINE JEWEL
Operator TittetoepiiGender
Bus Opera:or (42) I 1Hi BUS DRIVERS IF
ZiP COde
..
1---------------~------------------
I.----------T~K=~=t:5mnos ::::::::::::::::::::::~~ RespondVia
EJ
None
R~aKhH$ory~--------------------------Gomments
women
Operator Description
Ticket Status
Enter text
1.-----------~~::;:::::::::::::::::::::::::::~1 Oe~m.nt Customer Comments
Asstgned To
8 I
~
5-
FontSazes
•
e
~!;
Bus was due at stop at 7:11 am. Passenger was standing where passengers board the bus on the bus stop. Passenger wav ed at bus t o stop the bus kept going. Passenger was headed to Fremount Bart. The b us was on t i me with a women driver passenger wasn't able to get coach number
Created
,..
Priomy A DA? [ ]
Source
Employee
Comrnenl
Dare & Time
dwatton
Operator Gnffln stated at all of her stops. Operator was remstructed on checking for passengers at the stops and when they are wallang up to the
312512015 4:15 32 PM
Noonal Title VI?
D
Slop
Phone
31
24
6/18/2015
Active Directory Updater Web Application -
+- -+ ~~ · file
f.dlt
'f!t!W
FJ.vorltes
:-il'~r Dashboard
Iools
Fc 1
- x- 1
1'1*1:!
tfelp
Alameda-Contra Costa Transit District
Key Performance lndteators•
Tra nspoftatJOO •
Ut•l•hes•
F•nerc__ _ _ _ _ _ __ _ j
62:1 Just show mismatches ~Just show records which have People Soft data.
First Name
M iddle
initial
Last Name
Preferred First Name
Email
OffiCe
Phone
[email protected]
Budget Manager
Budget Department
GO
7123
[email protected]
Sr. Mar1teting Representattve
Marketing/ COmmunity Relations
GO
4709
JobTitle
Department
~
Heman
Vargas
"
Cleo Nichele
Good'win
sa1
Krtshnan
[email protected]
consultant/Contractor
Finance-senior Management
GO
TransportatiOn Supervisor
Road SuperviSiOn
02-CD
~
"
Ayers
GO, 5th Floor, Budget Dept.
Sr. Mar1teting Representative
[email protected]
"
Kim
Brooks
[email protected]
"
Elisabeth
West
[email protected]
~
Barwnlder
Padda
~
Richard
Pack
"
Michael
Nicote
[email protected]
~
02-M
Perin
[email protected]
Ek!ttrk:ian
Facilrtles Maintenance 0-2
02-M
Copney
[email protected]
Koch Sparrow
~
Ronald
Price
"
Lee
~
sandy Dametl
P""'e
~
7122
HVARGAS
5101316-8776
Vlctor1a Wake (VWAKE)
042191
Cgoodwin
5101206-0669
Lewts Clmton (Lclinton)
042254
skrishnan
51Dn74-0160
Joseph RObinson Qrot>inson)
030638
KBROOKS
NAYERS
EWEST bpadda
510/421-1388
Paul Ortiz (portiZ)
041655
510/407-7606
Paul OrtiZ (portiZ)
041939
4786
D-6 Bus Drivers
06-T
[email protected]
Journey Facil Mtce Mechanic
Facilities Maintenance 0-2
02-M
[email protected]
ATU Union Officer
Spec.al Drvts10n 7
GO
Service Empk)yee
0-2 Fuel Island
02 - M
RPACK
mpertn NCOPNEY
ckoch
4784 Bus Operator (42)
Alias
041636
02
bpad
Facilities Maintenance 0-2
Cheryl
Employee tO
James D. Pachan (Jpachan)
4785 Facilities Maintenance Trainer
Kenisha
Supervisor
4879
[email protected]
~
"
Dtv 3, Maintenance
Mobile
V~kl
5101915-2165
Riggin (vriggin)
Paul Ortiz (portiZ)
032103
KSPARROW
080988
roprice
031179
sa lee
Chris Durant (cdurant)
041850
dpterre jllarrtson
James
Hamson
[email protected]
Training Instructor
Transportation Training
TEC
2581
5107740515
Josepn rating (JiaUng)
032914
"
Lal~
saluja
[email protected]
consultant/Contractor
Finance-senior Management
GO
7120
510/452-7662
Lewts Cl1nton (Lclinton)
042298
lsaluja
~
Wi"ie
Bradley
[email protected]
waste Clean up Worker
Facilrtles Maintenance D-6
06-M
5104077228
Stanton Nusom (snusom)
040427
WBradley
Bus Operator (42)
0-4 Bus Drivers
04 - T
dcraw1ey (dcrawtey)
033454
rteong
[email protected] org
Inventory COntrol Cler1(
Materials Management
CMF
Fre
042013
j pgarcla
Parts Clerk
D-4 storeroom
04-M
Fredeliek Walls (fWalls)
041612
~
Roger
,..
James
Leong
p
Garcia
~
Gilt>ert
Torres
[email protected]
~
Stephante
Plummer
[email protected]
gtorres splummer
"
Chr1s
Andl1ctlak
[email protected]
"
Emily
Sutkus Cruz
[email protected]
"
Eyvoone
Eagles
eeag~actrans1t.org
Bus Operator
0-4 Bus Drivers
Senior capital Planmng Spec.
Cap!tal DevetopmenUGrant Mgmt
GO
James D. Pachan (jpachan)
042513
candrtchak
Dons Watson (dWatson)
031823
eeagles
5101919-7081
Paul Ortiz (portiZ)
040122
ssmith
5109261243
Michael Flocchini (mnocchi)
031970
scollins
Denise Standridge (dstan
043066
tchachere
4855
esutkus
4787 04- T
5109261246
~
Steve
Smith
[email protected]
Journey Facil Mtce Mechanic
Facilrties Mainenance Cmf
CMF
~
Sean
Collins
[email protected]
Training Instructor
0-4 Bus Drivers
04 - T
2560
"
Trisha
Chachere
[email protected]
Legal Asststant
General counsel
GO
4815
C 2015 - AC Transit. All Rights Reserved
32
""
25
6/18/2015
Bus Stop Work Orders System -
+- -+~ ~ · file
f.dlt
'f!t!W
FJ.vorltes
Iools
Fc 1
- x- 1
1'1*1:!
tfelp
:-il,~r Bus Stop ~ Work Orders Wor1< Order Types
Wor1< Orders
. .
AddNew
Stop Ids
Issue Oescnpt10n
Pnorrty
59656
Can we lOOk at mov.ng t>us stop pole further up to t>e in front of shelter Passenger/Opera
Urgent-
59098
Remove stiCkers and gratrrt1 from nag
56985
Remove stiCkers and graffiti from nag
59140
Remove stiCkers anc:J granm from nag
59917
Remove stiCkers and graffiti from nag
Hazard Minor Priority
Minor PriOrity
Minor PriOrity
Minor PriOrity
56622
Remove stiCkers and gratr1t1 from nag
Minor
54045
Replace generic Clec.ats with 54-a aoo "654 Lmited weekday hOurs• cJec:als
Minor
51527
52595
TaKe nag for stop 55099 (Broadway at Poedmont. SB) that iS at 06 Re-label It wrtn stop I Add 51 B-< to nag
55504
Replace generic 75 decal With 75-h cJec:al
54245
Remove temporary at-stop informatiOn mstalled for Oakland MarathOn Stops liSts will b
51340
mrss1og t>us stop bus drtvers are not stoppmg anymore USA kxatton arounc:J grassy area
59884
Replace gener1< deCal With 11-e
POOrity
Pnority
Normal Minor Priority
Normal Normal Normal Minor Priority
Minor
59144
Replace genenc decal wrth 86-c
58553
Replace genenc decats with~, 210-c & 801-b Leave other deCals
Minor
Replace gener1< deCals Wlth 14-b. 57-a. 805-a NX2-a &
Minor
57677 57245
-~l~ tr~#S/T
NXC-a Leave other decals Replace generic deCal WJtn 215-a
Priority
Priority
PriOrity
Minor Priority
ActiOn Notes
Requested By
Department
On
Work Order Type
PeterHo
Road Supervision
312612015
Ml NOR RELOCATION
Tony Gee
Marketing/ Community Relations
312512015
GRAFFITTI REMOVAL
Tony Gee
Marketing/ Community RelatiOns
312512015
GRAFFITTI REMOVAL
Tony Gee
Marketing/ Community Relations
312512015
GRAFFITTI REMOVAL
Tony Gee
Marketulg/ Community Relations
Tony Gee
Marketing/ Community Relations
Tony Gee
Marketing/ Community RelatiOns
Aaron Prtven
Marketing/ Community RelatiOns
Tony Gee
Marketing/ Community Relations
Tony Gee
Marketing/ Community Relations
Tony Gee
Marketing/ Community RelatiOns
Dan Talbott
Customer Srvcs Administration
Tony Gee
Marketing/ Community Relations
Tony Gee
Marketing/ Community Relations
Tony Gee
Marketing/ Community RelatiOns
Tony Gee
Mar1(etlng/ Community Relations
Tony Gee
Marketing/ Community Relations
33
312512015 312512015
312512015
312512015
312412015 312412015
312312015
312312015
312012015 312012015
312012015
312012015 312012015
GRAFFITTI REMOVAL GRAFFITTt REMOVAL
Status Not Assigned Not Assigned Not Assigned Not Assigned Not Assigned Not Assigned
MODIFY FLAG INFORMATION
Not
DETAILS
Assigned
REPAIR POLE ANO FLAG
Not Assigned
MODIFY FLAG INFORMATION
Not
DETAILS
Assigned
MODIFY FLAG INFORMATION
Not
DETAILS
Assigned
OTHER
USA BUS STOP LOCATION
Not Assigned Not Assigned
MODIFY FLAG INFORMATION
Not
DETAILS
Assigned
MODIFY FLAG INFORMATION
Not
DETAILS
Assigned
MODIFY FLAG INFORMATION
Not
DETAILS
Assigned
MODIFY FLAG INFORMATION
Not
DETAILS
Assigned
MODIFY FLAG INFORMATION
Not
DETAILS
Assigned
PrOJ€'CI
M001fied 312612015 312512015
312512015
312512015
312512015 312512015
312512015
312512015
312412015 312412015
312312015
312312015
312012015 312012015
312012015
312012015 312012015
S1gnup
26
6/18/2015
AC Transit Mobile Site . .eoo AT&T LTE
8:11AM
• . .oo AT&T LTE
8:10AM
c
actransit.org
c
actransit.org
Customer Feedback For information regarding claims for damages, please go to Government Tort Claims.
Select the kind of input you wish to give:
Report an Incident
•
Report an Incident
Real-Time Departures
Trip Planner
Maps and Schedules
Service Notices
Fares and Clipper
Contact Us
News
line Descriptions
Bus Stops by line
Transbay Service
Subscribe to eNews
511 SF Bay
First Name* t
s
1" 1
ne
Last Name*
Address
City
Zip Code
State
California
Full "
<
>
co 34
Home
<
e
F edt><.
>
~
~ull
l'nuTut
m
S1te
27
Next Steps… Upcoming Projects Public facing Key Performance Indicators Google Transit Feed Standards Real Time (GTFS-RT) Vehicle Updates and Service Updates AC Transit Schedule data and AVL Real Time API in .NET AC Transit Website: Responsive Rewrite of Vendor Registration and Procurement Tools New CAD\AVL System Upgrade Asset Management System (Ellipse 8.0) Hastus 2012 Daily Operations Upgrading Legacy and Manual Reports: Transportation, Claims, Time Keeping, and Scheduling Rewrite of Warranty Application
35
28
6/18/2015
GTFS-RT
36
29
6/18/2015
. .. ... 0
0 1"251'M-2:09 PM
~
44m&n
Q58l
" '"
1 ~SN from2ncl~o.t n!Atrt--~~t. lam !.itt
""'J)""'
limo
"'w.......
: . ~ #Ptpa',...
1~5PIA
\
l;
I ..... f
•
9 Oakland,CA
J
2nd StOakland Amtrak
~
11lPIA
lil
58l to.vards 58L Oa~'arod Amtral<. v--"
'Bs:~
0 )ii!PIA
3'~'""::.: s.:.ocs:.:~ .:
Coafida1llal
MacAI1hur Blvd:Mtllsbra~ Av
.. .•
Walk v!,t,o_•
mr'l ~!11!
2:09PM 0 MacArthur Blvd & S~inary Ave
'\
~
; . . 5:lr71 .... f
rrchtund ~fomution
\9
· -...,, II'OS
!wt4-"fe)"art7~..,."o;~trlJY~""'" f.~r«!'O'It.r4
n.o :1..,
i
,,~ cr~t"M'"_:sl':'.a. ~~~J:;c-errn•t
r".C'tt: !I~P.,l"MC>rf'J"')..~ft::-:rl"';" Yoc.~~:ot. lct7S \T~Cd :---.,:-.,~-~JtJ.~
,...,.... ....
~..,..
l..aook,rt
.......
........
IMI'IIllb•"
~~~
c..:.. A• fa.tnu1liMI
.
.tl
••
. .. 37
~
30
Questions…
T~/1/.5/T
38