Okaloosa County BOCC — July 28, 2015 — Agenda Packet — reading text

Maintenance and replacement of copier/computer equipment 49 MISCELLANEOUS CHARGES $400 $200 $400 $200 100.0% 51 OFFICE SUPPLIES $4,000 $4,000 $4,000 $0 0% 52 OPERATING SUPPLIES $3,165 $3,425 $7,318 $3,893 113.7% Refrigerators, 4-H material, Audio/visual equipment accessories, cables, etc. 54 BOOKS/PUBS/SUBS & MEMBERSHIPS $1,000 $1,000 $1,500 $500 50.0% 55 TRAINING & EDUCATION EXPENSES $1,000 $1,000 $2,500 $1,500 150.0% Extension Professionals State meeting for agents 60 CAPITAL OUTLAY $15,000 $0 $27,000 $27,000 0% Replace 2007 Ford Van (current mileage: ~136,000) TOTAL $354,102 $347,218 $348,245 $1,027 0.3% Packet Pg. 49  BOARD OF COUNTY COMMISSIONERS AGENDA REQUEST DATE: July 28, 2015 TO: Honorable Chairman and Members of the Board FROM: John Hofstad, County Administrator SUBJECT: Information Systems The attached documents provide the Program Based Budget for the Information Systems Department. Packet Pg. 50 DEPARTMENT/PROGRAM: INFORMATION SYSTEMS/GEOGRAPHIC INFORMATION SYSTEM HISTORICAL STAFFING SUMMARY: Category FY13 FY14 FY15 FY16 Full-time Administrative & Support 1 1 1 1 Full-time Management & Professional 18 18 18 19 Full-time Operations & Trades 2 2 2 2 Total 21 21 21 22 EXPENDITURES: Expenditures Budget FY13 FY14 FY15 FY16 FY15/FY16 Increase/ Category Actual Actual Original Approved +/- Decrease Personnel Services $1,342,382 $1,388,107 $1,492,343 $1,661,369 $169,026 11.3% Operating Expenses $558,841 $685,381 $864,018 $885,162 $21,144 2.4% Capital Outlay $16,031 $196,487 $135,000 $74,000 -$61,000 -45,2% Debt Service $0 $0 $0 $0 $0 0% Grants & Aids $0 $0 $0 $0 $0 0% Other Uses $0 $0 $0 $0 $0 0% Total $1,917,254 $2,269,976 $2,491,361 $2,620,531 $129,170 5.2% ACCOUNTS: FY14 FY15 FY16 FY15/FY16 Increase/ Code Category Approved Approved Approved +/- Decrease 10 SALARIES & WAGES $1,117,890 $1,168,459 $1,253,041 $84,582 7.2% 20 BENEFITS $305,190 $323,884 $408,328 $84,444 26.1% 31 PROFESSIONAL SERVICES $67,500 $95,000 $100,000 $5,000 5.3% 34 CONTRACT SERVICES $26,000 $101,000 $211,000 $110,000 108.9% 40 TRAVEL & PER DIEM $7,550 $9,450 $10,000 $550 5.8% 41 COMMUNICATIONS SERVICES $42,400 $42,600 $44,300 $1,700 4.0% 42 FREIGHT & POSTAGE $450 $450 $500 $50 11.1% 44 RENTS & LEASES $46,223 $47,557 $1,500 -46,057 -96.8% 45 RISK MANAGEMENT ALLOCATION $18,152 $20,307 $22,053 $1,746 8.6% 46 REPAIR & MAINTENANCE $350,896 $458,366 $390,269 -$68,097 -14.9% 47 PRINTING & BINDING $250 $250 $250 $0 0% 49 MISCELLANEOUS CHARGES $5,000 $26,900 $26,900 $0 0% 51 OFFICE SUPPLIES $2,400 $3,100 $4,300 $1,200 38.7% 52 OPERATING SUPPLIES $74,770 $51,828 $66,380 $14,552 28.1% 54 BOOKS/PUBS/SUBS & MEMBERSHIPS $1,105 $1,050 $1,050 $0 0% 55 TRAINING & EDUCATION EXPENSES $6,600 $6,160 $3,330 $500 8.1% 60 CAPITAL OUTLAY $265,000 $135,000 $74,000 -$61,000 -45.2% TOTAL $2,337,375 $2,491,361 $2,620,531 $129,170 5.2% Packet Pg. 51  BOARD OF COUNTY COMMISSIONERS OKALOOSA COUNTY, FLORIDA SERVICE AREA: GENERAL GOVERNMENT DEPARTMENT/PROGRAM: INFORMATION SYSTEMS/GEOGRAPHIC INFORMATION SYSTEM PROGRAM DESCRIPTION: The purpose of the GIS Division is to plan, organize and manage the construction, operation and maintenance of the Okaloosa County fiber optic network system and associated telecommunications as well as all Geomatics and related technology activities to deliver an organized, shared geospatial-centric information infrastructure that enables our county to manage data and resources using a cost effective county-wide enterprise approach. REVENUE: Information Systems is funded within the General Fund. Supporting revenue of the General Fund are ad valorem taxes, state shared revenue, licenses, permits, charges for services, interest, other miscellaneous revenue and transfers from other funds. MAJOR ACCOMPLISHMENTS LAST YEAR: Ø Redesigned WebGIS Ø Implemented a new 3x2x1 VMware ESX Cluster Production Datacenter Ø Migrated from MapStar to VELA (911 dispatch mapping software) Ø Pictometry Online (POL) Implementation and Training for the following: a. Public Works b. Property Appraiser c. Growth Management d. City of FWB e. City of Destin f. Public Safety g. TDD Ø Enterprise Address Project: A comprehensive review of the effectiveness of current addressing processes and procedures Ø Implemented new Okaloosa County Transit (OCT) Trapeze Mapmaker software used to help manage routing, customer pickup and billing. Ø Major Project Management template implementation. Ø Implemented Growth Management front counter based credit/debit card processing. Ø Migrated all GIS related websites to new DMZ VMware Cluster. Ø Redesigned Growth Management monthly reports using SQL Server Report Server. Ø Daily administration, management and maintenance of all GIS related hardware, software, over 95 geospatial datasets, over 25 websites, over 215 custom reports and various departmental personnel necessary to keep the enterprise GIS/IT related functions of the County operational and effective. PROGRAM GOAL: The goal of the GIS Division is to provide robust, user friendly access to “on demand” geospatial data and systems for critical government services that affect the citizens of our county and manage the county fiber optic / telecommunications network as a mission critical utility. Packet Pg. 52 KEY OBJECTIVES: 1. Continue to leverage key development environments to produce maintainable, highly effective software applications. 2. Create a highly available (HA) GIS/IT infrastructure to insure mission critical applications and data services are available 24x7. 3. Coordinate and facilitate interdepartmental and interagency cooperation to reduce duplication of effort and wasted resources. 4. Work with federal, state and local governments to create and facilitate cost-sharing strategies. 5. Increase efficiency of current staff by developing better GIS/IT tools to increase fiber optic outside plant operations and maintenance activities to help prevent communication outages due to fiber optic cuts and utility relocates. 6. Increase efficiency with technological innovation. PERFORMANCE MEASURES: Actual Approved Proposed Performance Measures FY13/14 FY14/15 FY15/16 Full Time Personnel 8 9 9 Total Operating expenditures 740,697 759,459 837,447 Input Requests for Data and Services 1,100 1,500 1,500 GIS related website visitors 90,000 205,650 205,650 Output Management of geospatial and other mission-critical data 6.5 7.5 7.5 sets (in terabytes) Ratio of Work Orders to Staff (including 634 589 589 Efficiency Telecommunications) Percentage of Geospatial/Other Mission- Critical Data Set Effectiveness 100 99.5 99.5 Availability Packet Pg. 53 HISTORICAL STAFFING SUMMARY: Category FY13 FY14 FY15 FY16 Full-time Management & Professional 7 7 7