Okaloosa County BOCC — July 29, 2014 — reading text

Packet Pg. 86  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. EXPENDITURES: Expenditures Budget FY12 FY13 FY14 FY15 Category Actual $ Actual $ Original $ Approved $ Personal Services 542,006 483,990 536,173 621,820 Operating Expenses 89,405 114,228 92,164 95,497 Capital Outlay 2,565 14,954 30,000 50,000 Other 0 0 0 0 Total 633,976 613,172 658,337 767,317 HISTORICAL STAFFING SUMMARY: Category FY12 FY13 FY14 FY15 Full-time 8 8 8 9 Part-Time 0 0 0 0 Relief 0 0 0 0 Total 8 8 8 9 Packet Pg. 87 MAJOR ACCOMPLISHMENTS LAST YEAR:  Managed the restoration of one major subsurface fiber optic utility cut at the Wright Land Fill.  Completed the 7SFG Fiber Optic Project; providing a necessary fiber optic link between Eglin AFB and the 7SFG Compound, resulting in approximately $1.3 million in revenue to the county.  Managed the installation of over 11 miles of new fiber optic cable to Duke Field, Gen Bond Blvd and various other locations including the necessary conduit systems.  Completed the county Cartegraph system migration to VMware and thin client technology, thus enhancing our datacenter approach and reducing the overall hardware footprint for the county.  Designed and built the hardware and software infrastructure in preparation to take over the administration of the Property Appraiser main website.  Migrated enterprise GIS databases to SDE and GIS Server and implemented policy to provide for continued support and maintenance.  Continued to make progress toward implementing credit card processing for county permitting and inspections.  Major system upgrades to OCWS Trimble/GIS/VMWare infrastructure.  Daily administration, management and maintenance of all GIS related hardware, software, over 95 geospatial datasets, over 25 websites, over 210 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. 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 access to the county fiber optic network by extending critical infrastructure to more partners. 6. Find ways to more effectively operate and maintain outside plant telecommunication infrastructure. 7. 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. 8. Increase efficiency with technological innovation. Packet Pg. 88 PERFORMANCE MEASURES: Actual Estimated Adopted Performance Measures FY12/13 FY13/14 FY14/15 Full Time Personnel 8 8 9 Total Operating expenditures 616,581 658,337 759,459 Input Sunshine One Locate Tickets (Fiber) 4,028 5,035 5,300 RTK GPS Fiber Locates (Fiber) 1,800 3,000 5,000 External Requests for Data and Services 1,025 1,100 1,500 Processed Basic Geospatial Data Edit Functions (GIS 2,500 3,000 3,200 geospatial data sets) Output Maintain custom reports for various departments 200 210 220 GIS related website hits 75,000 90,000 100,000 Management of geospatial and other mission-critical data sets (in terabytes) 6 6.5 7.5 Weekly Ratio of Sunshine One Locates to Staff (2) 77 97 110 Efficiency Percentage of Geospatial/Other Mission- Critical Data Set Effectiveness 100 100 99.99 Availability Packet Pg. 89  BOARD OF COUNTY COMMISSIONERS OKALOOSA COUNTY, FLORIDA SERVICE AREA: GENERAL GOVERNMENT DEPARTMENT/PROGRAM: INFORMATION SYSTEMS/ SYSTEMS & NETWORKS PROGRAM DESCRIPTION: The Systems and Networks Division maintains technical communication architecture utilizing both the County Fiber network and Ethernet network to ensure proper functioning of network topology and routers. This Division also configures and maintains the County Internet and Intranet/Email servers, while supporting over 800 clients that continually access the various systems. 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. EXPENDITURES: Expenditures Budget FY12 FY13 FY14 FY15 Category Actual $ Actual $ Original $ Approved $ Personal Services 440,649 450,636 463,919 470,899 Operating Expenses 102,489 82,413 122,349 297,759 Capital Outlay 31,079 1,077 235,000 85,000 Other 0 0 0 0 Total 574,217 534,126 821,268 853,658 HISTORICAL STAFFING SUMMARY: Category FY12 FY13 FY14 FY15 Full-time 7 7 7 7 Part-Time 0 0 0 0 Relief 0 0 0 0 Total 7 7 7 7 MAJOR ACCOMPLISHMENTS THIS PAST YEAR:  Extended and installed Aruba wireless at Crestview Courthouse from the FWB Annex Extension giving wireless service to all entities involved.  Replaced or upgraded approx 350 Windows XP PC’s.  Maintained legacy server and client hardware.  Upgrades performed on ECCC and EOC’s major software application.  Purchase and install new Backup system from tape library to disk platform. Packet Pg. 90  Implementation of network and computer components in support of the Airport Operations Center. PROGRAM GOAL: Provide a secure, reliable network along with skilled, competent, professional and courteous technical support to all Okaloosa County network and application users enabling BCC employees and partners to better serve the citizens of Okaloosa County through efficient technical initiatives. KEY OBJECTIVES: 1. Upgrade the County domain to Active Directory 2008 or above to stay current with the new OS’s due to the retirement of 2003 Server. 2. Replace Server 2003 hardware with virtual machines and provide redundancy by expansion and implementation of second VMWare setup. 3. Give users a current Office client and email product. 4. Keep all legacy hardware and software applications current with updates and patches. Replace as necessary. 5. Continue to train staff on all relevant technologies to ensure proper support of the infrastructure. PERFORMANCE MEASURES: Actual Estimated Adopted Performance Measures FY12/13 FY13/14 FY14/15 Full Time Personnel 7 7 8 Input Total Operating expenditures 522,654 841,451 908,646 SAN Helpdesk Ticket Entries 7,000 6,776 6,728 Output SAN Helpdesk Unlogged Calls 900 1,240 1,300 Avg. duration hours of Help Desk Ticket 1.6