Presentation

AC Transit Enterprise Database & Applications Manjit K. Sooch Alameda – Contra Costa Transit District (AC Transit) Direc...

0 downloads 373 Views 2MB Size
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 ...,. [email protected]) 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 [email protected]

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