Loading...
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