HomeMy WebLinkAbout36-Information Technology
.
INFORMATION
TECHNOLOGY
I TECHNOLOGY ADMINISTRATION I
NETWORK INFRASTRUCTURE
SUPPORT
SUPPORT SERVICES FOR G.LS AND
OFFICE AUTOMATION
PUBLIC SAFETY CAD/RMS
SYSTEMS SUPPORT
BUSINESS SYSTEMS
SUPPORT
RADIOS, LAPTOPS, MDCS SUPPORT
WEBSITE ADMINISTRATION
-1-
mZ
o"Tl
:3;0
z:ll
01:
,..~
0_
GlO
<z
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.
EXPENDI1'CJ1tF.8 BY DIVISION
2006-07 2007-08 2008-09 2009-10
DIVISION ACfUAL ACfUAL PROJECfED ADOPfED
INFORMATION TECHNOlffiY 3,364,552 3,855,452 3,633,200 3,007,100
COMMUNlCATIONS-OPERAT. 873,417 1,240,617 1,101,437 901,900
TOTAL 4J.37,9(1) 5,096,069 4,734,637 3,909,000
EXPENDITURES BY CATEGORY
2006-07 2007-08 2008-09 2009-10
CATEOORY ACTUAL ACTUAL PROJECTED AOOPfED
PERSONNEL 1,680,190 1,972,914 1,973,726 1,667,000
MAINTENANCE & OPERA nON 992,827 1,304,638 1,218,917 1,277,900
CONTRACTUAL SERVICES 557,275 682,420 983,007 590,700
INTERNAL SERVICE CHARGES 60,980 42,794 58,400 50,900
CAPITALOUfLAY 227,976 851,439 258,723 201,500
DEBT SERVICE 718,721 241,864 241,864 121,000
TOTAL 4,237,969 5,096,069 4,734,637 3,909,000
304
INFORMATION TECHNOLOGY
2008-09 KEY ACCOMPLISHMENTS
,/ Upgraded the City's PC management system and file servers.
,/ Added an internal GIS interactive web site.
,/ Upgraded the City firewalls and the bandwidth on the City Internet connection.
,/ Deployed a new internal crime mapping solution for the Police.
,/ Upgraded the Police and Fire Computer-Aided-Dispatch (CAD) system and the Police
Records Management System (RMS).
,/ Implemented a new Code Enforcement system that is integrated with the existing citizen
request management (CRM) system.
2009-10 KEY GOALS
;.. Upgrade the City's email system.
;.. Complete the implementation of mobile crime mapping and electronic report writing in
patrol vehicles.
;.. Deploy the new public "Community Crime Mapping" (web based) software.
;.. Complete the implementation of an internal city-wide intranet web site.
DID YOU KNOW?
;.. The Citizen request management (CRM) system's frequently asked questions (FAQ) pages,
which answer common questions, are viewed over 100,000 times a year.
;.. The first piece of email spam was sent over 30 years ago in 1978 to 393 people. Today,
spam makes up 80 to 90% of all emails sent - around 120 billion messages per day.
:>- The IT department runs 2 different types of Spam filters. Combined, these 2 filters stop on
average 220,000 pieces of spam mail each week.
;.. An officer can scan over 3,000 vehicle license plates in a lO-hour shift from a patrol car
equipped with an Automated License Plate Reader (ALPR) system.
;.. The Police Department's automated Red Light Camera (RLC) enforcement system records
video of violations at 30 frames per second.
305
FUND 679 INFORMATION TECHNOLOGY FUND
ACCOUNT OBJBCT . TITLE
BXPENDITURB BUDGBT LINE ITEM DETAIL
FISCAL YEAR 2009-2010
DIVISION 251 INFORMATION TECHNOLOGY
ACTUAL 2006-07 ACTUAL 2007-08 PROJBCTBD 2008-09 ADOPTBD 2009-10
50ll SALARIES PERM/FULLTIME
5013 AUTOMOBILE ALLOWANCE
5015 OVERTIME
5026 PERS RETIREMENT
5027 HEALTH & LIFE INSURANCE
5028 UNEMPLOYMENT INSURANCE
5029 MEDICARE
TOTAL PERSONNEL SERVICES
SIll MATERIALS & SUPPLIES
5112 SMALL TOOLS & EQUIPMENT
5121 ADVERTISING
5122 DUES & SUBSCRIPTIONS
5131 MI LEAGE
5132 MEETINGS & CONFERENCES
5133 EDUCATION & TRAINING
5171 RENTALS
5172 EQUI PMENT MAINTENANCE
5174 PRINTING CHARGES
5175 POSTAGE
5176 COPY MACHINE CHARGES
TOTAL MAINTENANCE . OPBRATION
5502 PROFESSIONAL/CONTRACTUAL SVCS
5505 OTHER PROFESSIONAL SERVICES
TOTAL CONTRACTUAL SERVICES
5601 GARAGE CHARGES
5602 WORKERS COMPENSATION
5603 LIABILITY
5605 TELEPHONE SUPPORT
5606 ELECTRIC
5612 FLEET CHGS FUEL
TOTAL INTBRNAL SBRVICE CHARGBS
5702 COMPUTER EQUIPMENT
5705 DEPT COMPUTER EQUIP
5706 ALTERATIONS & RENOVATIONS
TOTAL CAPITAL OUTLAY
5803 LEASE PAYMENTS
TOTAL DBBT SERVICB
TOTAL
1,281,627
4,219
1,123
201,359
156,141
3,217
18,514
1,666,199
39,525
2,986
757
18,798
644
4,094
40,346
301
607,180
486
483
458
716,058
215,229
1l,406
226,635
3,312
18,800
3,500
21,849
10,200
1,319
58,980
193,482
26,340
o
219,822
476,858
476,858
3,364,552
306
1,452,828 1,443,919 1,209,900
4,275 3,563 3,100
4,340 4,422 0
287,741 294,7ll 247,300
182,934 186,528 171,900
3,656 3,630 2,800
21,313 21,177 16,900
1,957,087 1,957,950 1,651,900
40,155 21,647 38,600
875 0 600
0 0 0
37,424 18,779 18,900
4 0 0
7,429 0 2,800
16,028 2,798 28,000
104 0 0
809,549 803, III 737,800
649 47 400
912 270 500
235 105 1,500
913,364 846,758 829,100
227,543 335,339 282,300
12,346 249,603 8,700
239,890 584,942 291,000
2,883 6,500 1,400
18,800 18,000 15,400
2,600 2,400 2,400
16,858 18,000 18,000
0 10,000 10,200
1,653 1,300 1,500
42,794 56,200 48,900
672,533 180,801 186,200
5,457 6,549 0
24,327 0 0
702,317 187,350 186,200
0 0 0
0 0 0
3,855,452
3,633,200
3,007,100
BUDGET - JUSTIFICATION
251 INFORMATION TECHNOLOGY
679 INFORMATION TECHNOLOGY FUND
OBJ JUSTIFICATION
5111 TAPES, CABLES, PRE-PRINTED FORMS, BLUEBAR, LABELS, BA ITERlES, TONER, OFFICE
SUPPLIES,MANUALS.MICE.KEYBOARDS,FLASH DRIVES,FOOTREST
5112 REPLACEMENT TOOLS
5122 COUNTY ASSESSOR DATA, MISAC. SUN, ORGANIZED EXEClITIVE, ESRI BUSINESS ANALYST, TECHNET
513 2 ESRI USER CONFERENCE, LEAGUE OF CALIFORNIA CITIES, DGS EXPO, IMeA FORUM, MISAC
5133 CHAMELEON, LINUX ADMIN, ACCELA, lSERIES. WESTIlUG. ESRI. CISCO. COl\1PUDYNE, FILENET. BIOKEY, TELESI'AFF
517 2 CITYWIDE HIW - SIW CONTRACTS
5174 RADIO ISSUANCE FORMS, BUSINESS CARDS
517 5 FEDEX, UPS, USPS
5176 COPYCARE CHARGES, MACHINE PAYMENT
5502 CONTRACT PROGRAMMING SERYICES, FRAME RELAY. AMR, DA STAR. INTERNET. REMOTE USER SERVICES, 911 PSAP
UPGRADE, DISPATCH EQUIPMENT/SERVER ROOM AIR CONDITIONER REPLACEMENT
5 5 0 5 MANDATED CLETS CHANGES, OFFSITE MEDIA STORAGE
5601 CHARGES FROM CITY'S FLEET DIVISION (INCLUDING STAFF TIME AND OVERHEAD) RELATED mE MAINTENANCE AND
OPERATION OF MOTOR VEHICLES ASSIGNED TO mIS DEPARTMENT. (CHARGE-BACKS BASED ON ACTUAL COSTS INCURRED.)
5602 THE PORTION OF THE CITY'S TOTAL WORKER'S COMPENSATION COSTS (INLCUDING STAFF TIME) RELATED TO THIS FUND
BASED ON LOSS HISTORY AND INDUSTRY STANDARDS.
5603 THE PORTION OF mE CITY'S TOTAL COSTS (INCLUDING STAFF TIME AND OVERHEAD) FOR RISK MANAGEMENT, UABILITY
INSURANCE PREMIUMS, PROPERTY INSURANCE PREMIUMS AND LIABILITY COSTS RELATED TO THIS FUND. BASED ON WSS
HISTORY AND INDUSTRY STANDARDS.
5605 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).
5606 CHARGES FROM THE CITY'S UTILITIES DIVISION (INCLUDING STAFF TIl'dE AND OVERHEAD) RELATED TO THIS
DIVISION'S ELECTRIC COSTS (CHARGE-BACKS BASED ON ACTUAL COSTS INCURRED).
5612 CHARGES FROM THE CITY'S FLEET DIVISION (INCLUDING STAFF TIl'dE AND OVERHEAD) FOR FUEL COSTS RELATED TO
MOTOR VEHICLES IN THIS DIVISION (CHARGE-BACKS BASED ON ACTUAL COSTS INCURRED).
5702 MICROSOFT SOFTWARE UPG FOR BSG, REPL MONITORS, IMS EXTENSION, ESRI EXTENSION, SECURITY SOFTWARE, SMART
UPS, PORTS, CISCO RADIO, ORACLE 91 UPG, lSE APP SERVER, SERVER HARD DRIVES
307
FOND 679 INFORKATION TECHNOLOGY FUND
ACCOUNT OBJECT & TITLB
EXPENDITURE BUDGET LINE ITBM DETAIL
PISCAL YEAR 2009-2010
DIVISION 252 COMMUNICATIONS OPBRATIONS
ACTUAL 2006-07 ACTUAL 2007-08 PROJECTED 2008-09 ADOPTED 2009-10
5011 SALARIES PERM/FULLTIME
5026 PERS RETIREMENT
5027 HEALTH & LIFE INSURANCE
5028 UNEMPLOYMENT INSURANCE
5029 MEDICARE
TOTAL PERSONNEL SERVICES
5111 MATERIALS & SUPPLIES
5112 SMALL TOOLS & EQUIPMENT
5171 RENTALS
5172 EQUIPMENT MAINTENANCE
TOTAL MAINTENANCE & OPERATION
5502 PROFESSIONAL/CONTRACTUAL SVCS
5505 OTHER PROFESSIONAL SERVICES
TOTAL CONTRACTUAL SERVICES
5606 ELECTRIC
TOTAL INTERNAL SERVICE CHARGES
5701 MOTOR VEHICLES
5702 COMPUTER EQUIPMENT
TOTAL CAPITAL OUTLAY
5803 LEASE PAYMENTS
TOTAL DBBT SBRVICB
TOTAL
308
10,768 11,873 11,647 11,200
1,718 2,365 2,494 2,300
1,321 1,387 1,437 1,400
28 30 29 0
156 172 170 200
13,991 15,827 15,776 15,100
11,155 46,050 29,691 37,400
0 4,122 3,407 2,000
50,888 57,301 59,094 62,700
214,727 283,801 279,967 346,700
276,769 391,274 372,159 448,800
313,940 426,930 386,765 289,100
16,700 15,600 11,300 10,600
330,640 442,530 398,065 299,700
2,000 0 2,200 2,000
2,000 0 2,200 2,000
0 18,858 0 0
8,154 130,264 71,373 15,300
8,154 149,122 71,373 15,300
241,863 241,863 241,863 121,000
241,863 241,863 241,863 121,000
873,417 1,240,617 1,101,437 901,900
BUDGET - JUSTIFICATION
252 COMMUNICATIONS OPERATIONS
679 INFORMATION TECHNOLOGY FUND
OBJ JUSTIFICATION
5111 RADIO BATIERIES AND PARTS, MDC PARTS. REPLACEMENT PORTABLE RADIO ANTENNAS
5112 REPLACEMENT TOOLS, 29 PRIORITY START DISCONNECT DEVICES
5171 COUNTY - 5 RACKS, 17 CIRCUITS, MDC MICROWAVE CIRCUIT, MDC WAN FEE, MDCWAN CIRCUIT, CONTRACT FEE
517 2 COUNTY - 6 POLICE CONSOLES. 3 FIRE CONSOLES, CITYWIDE 800 BACKBONE. 1300 RADIOS. 125 POLICE MDC MAINT
(COUNTY), 16 FIRE MDC MAINT (COUNTY), CITYWIDE 800 TIME AND MATERIALS
5502 COUNTY - 25 REPLACEMENT PATROL VEHICLE STRIPS/INSTALLS, 20 PATROL VEHICLE STEP-DOWN STRIPS/INSTALLS. 4
REPLACEMENT PATROL SGT VEHICLE (TAHOE) STRIPS/INSTALLS, 125 POLICE MDC USER FEES, 16 FIRE MDC USER FEES
5505 QUARTERLY JAIL LOCK SERVICE AND REPAIRS
56 0 6 CHARGES FROM THE CITY'S UTIUTIES 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
5803 LEASE PAYMENT FOR MDC REPLACEMENT (FINAL PAYMENT)
308