HomeMy WebLinkAbout34-Information Technology
....
INFORMATION
TECHNOLOGY
TECHNOLOGY ADMINISTRATION
NETWORK INFRASTRUCTURE
SUPPORT
I
. SUPPORT SERVICES FOR G.LS AND
OFFICE AUTOMATION
PUBLIC SAFETY CAD/RMS
SYSTEMS SUPPORT
.
BUSINESS SYSTEMS
SUPPORT
I
RADIOS, LAPTOPS, MDCS SUPPORT
.
I WEBSITE ADMINISTRATION i
.
-1-
mZ
oa
%:a
Z
~~
go
-<z
INFORMATION
TECHNOLOGY
Director ofInformation Technology
Tom Marek
IT Systems Operations Network
Administration
(1) Employee (11) Employees (6) Employees (2) Employees
INFORMATION TECHNOLOGY (L T.)
ACCOUNT NUMBER: 679-250 FUND: LS. FUND
I ABOUT THE DEPARTMENT I
IT is an internal service department providing technology creation and maintenance, and general
automation support to the City Departments, including the Water Department. IT is responsible
for all hardware, software, and network infrastructure within the City. Additionally, IT is
responsible for maintaining and coordinating all radios, MDC's, and miscellaneous public safety
gear.
EXPENDITURES BY DIVISION
2005-06 2006-07 2007-08 2008-09
DIVISION ACTUAL ACTUAL PROJECTED ADO PTED
INFORMATION TECHNOLOGY 3,617,999 3,364,552 3,855,452 3,658,400
COM M UNICA TIONS-OPERA T. 888,066 873,417 1,240,6 I 7 I, I 63,400
TOTAL 4,506,065 4,237,969 5,096,069 4,821,800
EXPENDITURES BY CATEGORY
2005-06 2006-07 2007-08 2008-09
CATEGORY ACTUAL ACTUAL PROJECTED ADOPTED
PERSONNEL 1,636,93 I 1,680,190 1,972,914 2,050,700
MAINrENANCE & OPERA nON 1,019,533 992,828 1,304,638 1,373,700
CONTRACTUAL SERVICES 490,589 557).75 682,420 987,300
INTERNAL SERVICE CHARGES 124,942 60,980 42,794 58,400
CAPITAL OUTLAY 524,002 227,976 851,439 109,700
DEBT SERVICE 710,068 718,72 I 241,864 242,000
CREDITSiBILLABLES 0 0 0 0
TOTAL 4,506,065 4,237,969 5,096,069 4,821,800
299
INFORMATION TECHNOLOGY
2007-08 KEY ACCOMPLISHMENTS
./ Implemented a recruitment and applicant tracking system that facilitates web-based
submission and processing of employment applications.
./ Implemented a citywide citizen request management system.
./ Expanded Police MDC bandwidth in 30 black-and-white patrol sedans, enabling field access
to California DOl's "Cal-Photo" statewide mug-shot/DMV photo database.
2008-09 KEY GOALS
y Upgrade the City's email and PC management system.
y Upgrade bandwidth on the City Internet connection.
y Implement electronic crime data briefings in patrol cars for real time updates.
y Implement Police electronic report writing software in patrol cars.
DID YOU KNOW?
y The Cities WAN (Wide Area Network) connects over 42 different facilities using 5 different
data communications technologies.
y The IT department nInS 2 different types of Spam filters. Cornbined, these 2 filters stop on
average 220,000 pieces of spam mail each week. Recent world-wide spam statistics indicate
that 80 to 90% of all email is spam and costs $140 billion to fight globally.
(http://technology.newscientist.com/article.ns?id-dn I 3777)
y This GIS department creates and prints about I 1,500 square feet of maps per year. The most
popular GIS Product sold to the public is the Zoning map.
y The document imaging system at the Police Department scans about 1,000,000 pages of
crime report documentation annually.
y Police and Fire vehicles report their location to their dispatch center via an Automatic
Vehicle Location (A VL) system every 60 seconds or every.2 miles that they travel.
300
FUND 679 J:HFORMATJ:ON TBCHNOLOGY FUND
ACCOUNT OBJBCT ~ TJ:TLB
BXPBHDJ:TURB BUDGBT LJ:D J:TBII DBTAJ:L
FXSCAL YEAR 2008-2009
ACTUAL 2005-06
DXVXSXON 251 XNPORMATXON TECHNOLOGY
ACTUAL 2006-07 PROJBCTBD 2007-08 ADOPTED 2008-09
5011 SALARIES PERM/FULLTIME
5013 AUTOMOBILE ALLOWANCE
5015 OVERTIME
5026 PERS RETIREMENT
5027 HEALTH & LIFE INSURANCE
5028 UNEMPLOYMENT INSURANCE
5029 MEDICARE
TOTAL PBRSOHNBL SBRVXCBS
5111 MATERIALS & SUPPLIES
5112 SMALL TOOLS & EQUIPMENT
5122 DUES & SUBSCRIPTIONS
5131 MILEAGE
5132 MEETINGS & CONFERENCES
5133 EDUCATION & TRAINING
5171 RENTALS
5172 EQUIPMENT MAINTENANCE
5174 PRINTING CHARGES
5175 POSTAGE
5176 COPY MACHINE CHARGES
TOTAL MAXNTBNANCB ~ OPBRATXON
5502 PROFESSIONAL/CONTRACTUAL SVCS
5505 OTHER PROFESSIONAL SERVICES
TOTAL CONTRACTUAL SBRVICBS
5601 GARAGE CHARGES
5602 WORKERS COMPENSATION
5603 LIABILITY
5605 TELEPHONE SUPPORT
5606 ELECTRIC
5612 FLEET CHGS FUEL
TOTAL INTBRNAL SBRVIC'B CHARGBS
5702 COMPUTER EQUIPMENT
5704 MISCELLANEOUS EQUIPMENT
5705 DEPT COMPUTER EQUIP
5706 ALTERATIONS & RENOVATIONS
TOTAL CAPITAL OUTLAY
5803 LEASE PAYMENTS
TOTAL OUT SBRVIC'B
TOTAL
1,255,834 1,281,627
2,150 4,219
1,090 1,123
180,269 201,359
163,943 156,141
3,148 3,217
17,361 18,514
1,623,794 1,666,200
36,673 40,282
2,100 2,986
16,091 18,798
135 644
6,250 4,094
36,996 40,346
123 301
589,542 607,180
325 486
357 483
94 45'
688,685 716,059
196,255 215,229
9,764 11,406
206,019 226,635
62,461 3,312
22,900 18,800
3,100 3,500
23,107 21,849
10,200 10,200
1,174 1,319
122,942 58,980
508,353 219,822
0 0
0 0
0 0
508,353 219,822
468,205 476,858
468,:105 476,858
3,617,999 3,364,553
301
1,452,828 1,464,600
4,275 4,500
4,340 0
287,741 313,700
182,934 225,600
3,656 3,800
21,313 22,300
1,957,087 2,034,500
40,155 56,600
675 0
37,424 16,400
4 0
7,429 2,800
16,035 9,300
104 0
809,549 895,400
649 400
912 500
235 1,500
913,371 98:1,900
227,543 243,800
12,346 308,500
239,890 552,300
2,883 6,500
18,800 18,000
2,600 2,400
16,858 18,000
0 10,000
1,653 1,300
42,794 56,200
671,942 32,500
591 0
5,457 0
24,327 0
70:1,317 32,500
0 0
0 0
3,855,459
3,658,400
BUDGET - JUSTIFICATION
251 INFORMATION TECHNOLOGY
679 INFORMATION TECHNOLOGY FUND
OBJ JUSTIFICATION
5111 DISPATCH CENTER EQUIPMENT, TAPES, CABLES, PRE-PRINTED FORMS, BLUEBAR, LABELS, BA1TERIES, TONER, OFFICE
SUPPLIES,MANUALS,MICE,KEYBOARDS.FLASH DRIVES,FOOTRESJ'
5122 COUNTY ASSESSOR DATA, MISAC, SUN, ORGANIZED EXECUTIVE, ESRI BUSINESS ANALYST, TECIINET
513 2 ESRI USER CONFERENCE, LEAGUE OF CALIFORNIA CITIES, DGS EXPO, IMCA FORUM, MISAC
5133 CHAMELEON, UNUX ADMIN, ACCELA, ISERIES, WESTHUG, ESRI, CISCO, COMPUDYNE, FlLl!NET, BIOKEY, TELIlSTAFF
5172 CITYWIDE HIW - SIW CONTRACTS
5174 RADIO ISSUANCE FORMS, BUSINESS CARDS
517 5 FEDEX, UPS, USPS
5176 COPVCARECHARGES,MACHINEPAYMENT
5502 CONTRACT PROGRAMMING SERVICES, FRAME RELAY, AMR, DA STAR, INTERNET, REMOTE USER SERVICES, '" PSAP
UPGRADE, DISPATCH EQUIPMENT/SERVER ROOM AIR CONDmONER REPLACEMENT
5505 MANDATED CLETS CHANGES, OFFSITE MEDIA STORAGE
5601 CHARGES FROM CITY'S FLEET DIVISION (INCLUDING STAFF TIME AND OVERHEAD) RELATED TIJE MAINTENANCE AND
OPERATION OF MOTOR VEHICLES ASSIGNED TO TIllS DEPARTMENT. (CHARGE-BACKS BASED ON ACTIJAL COSTS INCURRED.)
56 02 TIJE PORTION OF TIJE CITY'S TOTAL WORKER'S COMPENSATION COSTS (INLCUDING STAFF TIME) RELATED TO TIllS FUND
BASED ON LOSS HISTORY AND INDUSTRY STANDARDS.
5603 TIJE PORTION OF TIJE CITY'S TOTAL COSTS (INCLUDING STAFF TIME AND OVERHEAD) FOR RISK MANAGEMENT, UABILITY
INSURANCE PREMIUMS, PROPERTY INSURANCE PREMIUMS AND LIABILITY cosrs RELATED TO THIS FUND. BASED ON WSS
HISTORY AND INDUSI'RY SfANDARDS.
5605 CHARGES FROM THE CITY'S TELECOMMUNICATIONS DMSlON (INCLUDING STAFF TIME AND OVERHEAD) RELATED TO TIllS
DIVISION'S TELECOMMUNICATIONS COSTS (CHARGE-BACKS BASED ON ACTUAL COSTS INCURRED).
5606 CHARGES FROM THE CITY'S UTILITIES DIVISION (INCLUDING STAFF TIME AND OVERHEAD) RELATED TO THIS
DMSlON'S ELECTRIC COSTS (CHARGE-BACKS BASED ON ACTUAL COSTS INCURRED).
5612 CHARGES FROM TIJE CITY'S FLEET DIVISION (INCLUDING STAFF TIME AND OVERHEAD) FOR FUEL COSTS RELATED TO
MOTOR VEHICLES IN TIllS DIVISION (CHARGE-BACKS BASED ON ACTUAL COSTS INCURRED).
57 0 2 MICROSOFT SOFrW ARE UPG FOR BSG, REPL MONITORS, IMS EXTENSION, ESRI EXTENSION, SECURITY SOFrW ARE, SMART
UPS, PORTS, CISCO RADIO. ORACLE 91 UPG, ISE APP SERVER, SERVER HARD DRIVES
302
BXPBNDI'l'URB BtJOOllT LID ITD DETAIL
FISCAL YEAR 2008-2009
I'URD 679 INJ'ORXATIOH TBCIIHOLOGr I'URD
DIVISION 252 COJIIItJ1aCATIOHS OPBRATIONS
ACCOUH'l' OBJJ:cr &: TITLB ACTUAL 2005-06 ACTUAL 2006-07 PR~CTBD 2007-08 ADOPTBD 2008-09
5011 SALARIES PERM!FULLTIME 10,225 10,768 11,873 12,000
5014 SALARIES TEMP!PARTTIME 25 0 0 0
5026 PERS RETIREMENT 1,489 1,718 2,365 2,600
5027 HEALTH & LIFE INSURANCE 1,222 1,321 1,387 1,400
5028 UNEMPLOYMENT INSURANCE 26 " 30 0
5029 MEDICARE 148 156 172 200
TOTAL PUSONNBL snVICBS 13,136 13,991 15,827 16.200
5111 MATERIALS & SUPPLIES 46,603 11,155 46,050 37,400
5112 SMALL TOOLS & EQUI PMENT 0 0 4,122 3,500
5171 RENTALS 50,420 50,888 57,301 59,400
5172 EQUI PMENT MAINTENANCE 233,824 214,727 283,801 290,500
TOTAL KAINTBNANCE &; OPIlRATIOH 330,847 276,769 391,27. 390.800
5502 PROFESSIONAL/CONTRACTUAL SVCS 284,570 313,940 426,930 413,800
5505 OTHER PROFESSIONAL SERVICES 0 16,700 15,600 21,200
TOTAL CONTRACTUAL SBRVICBS 284,570 330,640 U2,530 ,(35,000
5606 ELECTRIC 2,000 2,000 0 2,200
TOTAL INTBRHAL SERVICE CHARGES 2,000 2,000 0 2,200
5701 MOTOR VEHI CLES 0 0 18,858 0
5702 COMPUTER EQUIPMENT 15,649 8,154 130,264 77,200
TOTAL CAPITAL OUTLAY 15.6U 8.15t lU,122 77.200
5803 LEASE PAYMENTS 241,863 241,863 241,863 242,000
TOTAL DBBT SERVIa 241,863 241,863 24.1,863 2402,000
TOTAL 888,066 873,4.17 1,24.0,617 1,163,-4.00
303
BUDGET - JUSTIFICATION
252 COMMUNICATIONS OPERATIONS
679 INFORMATION TECHNOLOGY FUND
OBJ JUSTIFICATION
5111 RADIO BATrERlESAND PARTS, MIJC PARTS, REPLACEMENT PORTABLE RADIO ANTENNAS
5112 REPLACEMENT TOOlS, 29 PRIORITY START DISCONNECT DEVICES
5171 COUNTY - 5 RACKS, 17 CIRCUITS, MIJC MICROWAVE CIRCUIT, MIJC WAN FEE, MIJC WAN CIRCUIT, CONTRACT FEE
5172 COUNTY. 6 POLICE CONSOLES, 3 FIRE CONSOLES, CITYWIDE 800 BACKBONE, 1300 RADIOS, 125 POLICE MIJC MAJNT
(COUNTY), 16 FIRE MIJC MAJNT (COUNTY), CITYWIDE 800 TIME AND MATERIALS
5502 COUNTY. 25 REPLACEMENT PATROL VEHICLE STRIPSIINSTALLS, 20 PATROL VEHICLE STEP-DOWN STRIPSIINSTALLS, 4
REPLACEMENT PATROL SGT VEHICLE (TAHOE) Sl'RIPSlINSTALLS, 125 POUCE MDC USER FEES, 16 FIRE MDC USER FEES
5505 QUARTERLY JAIL WCK SERVICE AND REPAIRS
5602 TIlE PORTION OF TIlE CITY'S TOTAL WORKER'S COMPENSATION COSTS (INLCUDING STAFF TIME) RELATED TO THIS FUND
BASED ON WSS HISTORY AND INDUSTRY STANDARDS.
5603 TIlE PORTION OF TIlE CITY'S TOTAL COSTS (INCLUDING STAFF TIME AND OVERHEAD) FOR RISK MANAGEMENT, LIABILITY
INSURANCE PREMIUMS, PROPERTY INSURANCE PREMIUMS AND LIABILITY COSTS RELATED TO THIS FUND. BASED ON LOSS
HISTORY AND INDUSTRY STANDARDS.
56 0 5 CHARGES FROM THE CITY'S TELECOMMUNICATIONS DIVISION (INCLUDING STAFF TIME AND OVERHEAD) RELATED TO THIS
DIVISION'S TELECOMMUNICATIONS COSTS (CHARGE-BACKS BASED ON ACTUAL COSTS INCURRED).
56 0 6 CHARGES FROM TIlE CITY'S UTILITIES DIVISION (INCLUDING STAFF TIME AND OVERHEAD) RELATED TO THIS
DIVISION'S ELECTRIC COSTS (CHARGE-BACKS BASED ON ACTUAL COSTS INCURRED).
5702 25 PATROL VEHICLE EMERGENCY EQUIPMENT KITS, 4 PATROL SGT VEHICLE (TAHOE) EMERGENCY EQUIPMENT KITS,
DISPATCH RADIO CONTROLLER UPGRADE
5 8 0 3 ESfIMA TED LEASE PAYMENT FOR MIJC REPLACEMENT (S-YEAR LEASE)
304