Fort Walton Beach Council agenda — 09-11-2007 workshop agenda — reading text

PLAN THE DATA MANAGEMENT AND MAINTENANCE PLAN WILL INCLUDE: L Geographic Technologies Group 5 Scope of Services  City of Fort Walton Beach GIS Needs Assessment and Implementation Plan Development LOCATION OF DATA REQUIRED DATA UPDATES DATA UPLOADS TRANSFER OF DATA AND DATABASES REPLICATIONS OF DATA AND DATABASES BACKUP AND ARCHIVING OF GIS DATA TASK 7 DATABASE DESIGN GTG WILL WORK CLOSELY WITH THE CITY OF FORT WALTON BEACH TO GATHER INFORMATION FOR THE DATABASE DESIGN OF THE ENTERPRISE GIS. GTG WILL UTILIZE GEODATABASE TEMPLATES FOR THE DATA COLLECTION OF ALL INFORMATION THAT WILL BE REQUIRED FOR THE PHYSICAL DATABASE DESIGN. TASK 7. 1 CONCEPTUAL/ LoGICAL DATA MODEL THE CITY RECOGNIZES THAT THE CONCEPTUAL AND LOGICAL DATA MODEL " IS THE FIRST STEP IN DATABASE DESIGN WHERE THE CONTENTS OF THE INTENDED DA TABASE ARE IDENTIFIED AND DESCRIBED ALLOWING FOR A COMPREHENSIVE MENTAL FRAMEWORK AND ORGANIZED STRUCTURE TO BE REVEALED'. GTG WILL WORK CLOSELY WITH ALL DEPARTMENTS TO MAKE RECOMMENDATIONS AS TO THE DATA THAT SHOULD BE WITHIN THE DATABASE DESIGN. GTG WILL NOT PERFORM A COMPREHENSIVE PHYSICAL DATABASE DESIGN FOR THE ENTERPRISE SYSTEM. GTG WILL DOCUMENT THE REQUIRED DATA LAYERS. TASK 8 ApPLICATION DESIGN TASK 8. 1 RECOMMENDATIONS AND PRIORITY ApPLICATION MATRIX GTG WILL ADDRESS ALL PROPOSED SOFTWARE SOLUTIONS FOR THE CITY OF FORT WALTON BEACH USING A THREE~TIERED EXPLANATION. GTG WILL DEVELOP A DEPLOYMENT PLAN FOR THE RECOMMENDED SOFTWARE SOLUTIONS. GTG WILL ALSO RECOMMEND ANY APPLICATION TEMPLATES OR CUSTOM APPLICATIONS THAT MAY STREAMLINE THE USE OF THE CITY' S GIS. THIS SHALL INCLUDE DISCUSSION OF THE AVAILABLE APPLICATIONS RELATED TO THE SUNGARD HTE UTILITY BILLING SYSTEM, WORK ORDER MANAGEMENT, ASSET MANAGEMENT, HYDRAULIC MODELING, ETC. TASK 9 DATA COLLECTION & CONVERSION ( UTILITY PILOT PROJECT) THE FOLLOWING SCOPE OF WORK IS AN OUTLINE FOR THE GPS UTILITY PILOT PROJECT. THE GTG PROJECT TEAM WILL INCLUDE THE PROFESSIONAL LAND SURVEYOR ( PLS) AND A SENIOR GPS/ GIS MANAGER. BOTH INDIVIDUALS HAVE EXTENSIVE EXPERIENCE IN DESIGNING AND BUILDING WATER, STORM WATER, AND WASTE WATER SYSTEMS. BOTH INDIVIDUALS WILL BE ON-SITE AT THE CITY OF FORT WALTON BEACH FOR FOUR ( 4) FULL DAYS. To THE BEST OF THEIR ABILITY AND TIMEFRAME ALL WATER, STORM WATER, AND WASTE WATER FEATURES WITHIN THE DESIGNATED PILOT AREA (AND AITRIBUTES AS DEFINED BY THE GEO< DATABASE TEMPLATE) WITHIN A PILOT AREA WILL BE COLLECTED. NOTE: THERE MAY BE EXCEPTIONS TO THE RULE INCLUDING: DAMAGE, BLOCKAGE, INACCESSIBLE AREAS ETC.) BOTH INDIVIDUALS WILL BE RESPONSIBLE FOR ALL PRE-PLANNING ( APPROXIMATELY TWO 2) DAYS) AND POST INVENTORY WORK (AP ROXIMATELY TWO ( 2) DAYS). THE INTENTION IS TO CREATE A COMPLETE AREA OF THE CITY FOR EVALUATION PURPOSES. L Geographic Technologies Group 6 Scope of Services  City of Fort Walton Beach GIS Needs Assessment and Implementation Plan Development THE FOLLOWING TEXT REPRESENTS ONLY GUIDELINES FOR THE PILOT PROJECT: THE GTG TEAM WILL CONDUCT A GPS INVENTORY OF WATER, WASn;; WATER, AND STORMWATER INFRASTRUCTURE WITHIN THE PILOT AREA. FEATURES FOR THE WA TER SYSTEM SHALL INCLUDE ABOVEGROUND PHYSICAL ASSETS, SUCH AS FIRE HYDRANTS, WATER VALVES, WATER METERS, AND BACKFLOW PREVENTERS. WASTEWATER FEATURES SHALL INCLUDE ABOVEGROUND AND UNDERGROUND PHYSICAL ASSETS, SUCH AS SANITARY SEWER MANHOLE RIMS, PIPE INVERTS, PIPE DIAMETERS, PIPE MATERIALS, PIPE ALIGNMENT, LIFT STA TlON WET WELLS, VALVE BOXES, AND ANY OTHER ITEM INCLUDED WITH THE WASTEWATER COLLECTION AND TRANSMISSION SYSTEM. STORMWATER FEATURES SHALL INCLUDE ABOVEGROUND AND UNDERGROUND PHYSICAL ASSETS, SUCH AS CURB INLETS, JUNCTION BOXES/ MANHOLES, PIPE INVERTS, PIPE MA TERIALS, PIPE DIAMETERS, PIPE ALIGNMENT,AND OUTFALL STRUCTURES. THE PILOT AREA WILL BE DEFINED BY THE CITY AND THE GTG TEAM (INCLUDING GTG' s RETAINED PROFESSIONAL LAND SURVEYOR (PLS)). THE PILOT AREA WILL BE A SMALL REPRESENTA TlVE AREA OF THE CITY. AT THE DISCRETION OF THE GTG TEAM AND WITH APPROVAL FROM THE CITY, INFRASTRUCTURE WILL BE COLLECTED AS TO REPRESENT A SMALL BUT COMPLETE SECTION OF THE CITY. THE CITY OF FORT WALTON BEACH WILL PROVIDE A MAXIMUM OF ~ o (2) PEOPLE TO ASSIST THROUGHOUT THE DURATION OF THE PILOT PROJECT TO MARK FEA TURES AND ASSIST THE FIELD CREW. CITY STAFF WILL WALK AHEAD OF THE FIELD CREWS, MARKING AND LIFTING FEATURES. IT IS ANTICIPATED THA T THE FIELD INVENTORY WILL NOT EXCEED FOUR (4)DA YS OF ON-5ITE WORK. THIS TIMEFRAME DOES NOT INCLUDE ANY MISSED TIME DUE TO INCLEMENT WEATHER, EMERGENCIES, ETC. FOR THE WATER SYSTEM, ONLY HORIZONTAL DATA ARE REQUIRED. FOR THE WASTEWATER AND STORMWATER SYSTEMS, BOTH HORIZONTAL AND VERTICAL DATA IS REQUIRED. THE ASSETS SHALL BE LOCATED USING RTK GPS UNITS WITH SURVEY-GRADE ACCURACY TO 3 CENTIMETERS AND DOUBLE VECTORED USING NA VD B8 AND NAD 83. GTG WILL PROVIDE A REGISTERED LAND SURVEYOR TO OVERSEE FIELD INVENTORY WORK. GTG WILL USE AN EXISTING ESRI GEODATABASE TEMPLATE FOR THE WATER, WASTEWATER, AND STORMWATER DATABASES. IT SHALL BE DISCUSSED AND AGREED UPON BEFOREHAND THE A7TRIBUTES THAT WILL BE POPULATED FOR EACH SYSTEM. GTG WILL POPULA TE FEA TURE A7TRIBUTES FROM EXISTING HARD-COPY AS-BUILT DOCUMENTS AND DIGITAL FILES. GTG WILL DELIVER THE FINAL GEODA TABASE IN COMPLIANCE WITH SPECIFIED DA TA AND POSITIONAL ACCURACY STANDARDS. GTG WILL GEOREFERENCE (USING POINTS) THE CITY'S RECORD DRAWINGS TO THE FLORIDA STATE PLANE COORDINATE SYSTEM NORTH ZONE (0903) NAD B3. THIS WILL NOT EXCEED 5- 10 SETS OF DRAWINGS THAT WILL CORRESPOND WITH THE WATER, WASTEWATER, AND STORMWATER INFRASTRUCTURE IN THE PILOT PROJECT AREA. TASK 9. I STEP ONE: IDENTIFY PILOT PROJECT AREA THE PILOT PROJECT SHALL INCLUDE FIELD DATA COLLECTION OFA SMALL AREA OF THE CITY OF FORT WALTON BEACH THAT INCLUDES AS MANY DIFFERENT PHYSICAL FEATURES AS POSSIBLE TO INPUT MPLA TE GEODA TABASE(S). THE PILOT AREA SHALL BE AGREED UPON BY BOTH GTG AND INTO THE n;; THE CITY WITH THE CITY HA VING FINAL APPROVAL OF THE PILOT AREA. THE PILOT PROJECT SHALL SERVE TO " SIMULATE" THE IMPLEMENTA TION OF THE GIS PROGRAM AND SHALL " TEST" THE RECOMMENDED DATABASE STRUCTURES AND APPLlCA TlONS IN ORDER TO WORK OUT ANY "BUGS" IN THE PROCESS. TASK 9.2 STEP Two: DATA COLLECTION THE PROJECT TEAM WILL WORK CLOSELY WITH THE CITY OF FORT WALTON BEACH TO COLLECT AN APPROPRIATE AMOUNT OF UTILITY DATA TO INCORPORATE INTO THE NEW GIS SYSTEM. THE GTG FIELD CREWS ENSURE THAT THE COLLECTION OF ALL FEATURES IS CORRECTAND COMPLETE BASED ON EQUIPMENT, TIME AND FIELD OBSERVA TION. THE CITY OF FORT WALTON BEACH WILL BE REQUIRED TO L Geographic Technologies Group 7 Scope of Services  City of Fort Walton Beach GIS Needs Assessment and Implementation Plan Development MARK FEA TURES AHEAD OF THE COLLECTION TEAMS OR PROVIDE STAFF IN THE FIELD WITH KNOWLEDGE OF THE SYSTEMS BEING COLLECTED. DURING THE PILOT PROJECT, DAILY PLANNING MEETINGS SHALL BE HELD WITH CITY STAFF AND GTG FIELD CREWS TO DISCUSS THE PREVIOUS DA Y'S ACCOMPLISHMENTS, THE PRESENT DA Y'S TASKS, AND THE NEXT DAY'S GOALS. THIS WILL ALLOW CITY STAFF TO MARK THE REqUIRED FEATURES PLANNED FOR THE NEXT DAY SO AS NOT TO HOLD UP THE GTG FIELD CREWS. TASK 9.3 STEP THREE: NETWORK CREATION AND ATTRIBUTION GTG WILL CREA TE THE DIGITAL NETWORK OF THE SELECTED UTILITY INFRASTRUCTURE WITHIN THE PILOT PROJECT. GTG STAFF WILL LOAD ALL OF THE FIELD COLLECTED FEATURES INTO THE APPROVED ENTERPRISE GEODA TABASE AND REVIEW THE HARD-COPY AND ELECTRONIC AS-BUlLTS TO CREA TE THE DIGITAL NETWORK. THE GTG TEAM WILL ATTRIBUTE ALL DIGITAL FEA TURES WITH THE PHYSICAL INFORMA TION A VAlLABLE ON THE AS-BUILTS. TASK 9.4 STEP FOUR: CITY OF FORT WALTON BEACH REVIEW IT IS UNDERSTANDABLE THAT THE FIELD CREWS WILL NOT HA VE THE LOCAL KNOWLEDGE REqUIRED TO COLLECT THE ASSET DATA WITHOUT THE ASSISTANCE OF THE CITY OF FORT WALTON BEACH. THE CITY WILL WORK CLOSELY WITH THE GTG TEAM TO COLLECT ATTRIBUTES IN THE FIELD. THE CITY AND GTG WILL UTILIZE ESRl's RED LINING TECHNOLOGY OR MANUAL EDITS TO MAKE COMMENTS FROM THE NETWORK CREATION FOR FIELD CREWS TO VERIFY DISCREPANCIES BETWEEN FIELD COLLECTED DATA AND NETWORK CREATION. THE CITY WILL REVIEW THE TEMPLATE GEODATABASE AND NETWORK, AND DETERMINE WHETHER IT IS ACCEPTABLE. TASK 9.5 STEP AVE: PILOT PROJECT AUDIT AFTER THE COMPLETION OF THE PILOT PROJECT IT WILL BE REqUIRED THA T THE GTG PROJECT TEAM MEET WITH THE CITY OF FORT WALTON BEACH TO DISCUSS THE SUCCESS OF THE PILOT PROJECT AND TO ALSO REVIEW ISSUES. A FINALIZED COLLECTION AND CREATION PROCESS WILL BE PRESENTED AND REVIEWED DURING THIS MEETING. TASK 9.6 UTILITY DATA COLLECTION/ CONVERSION RECOMMENDATIONS GTG WILL REVIEWALL UTILITY DATA AND DATABASES AND RECOMMEND ALTERNA TIVES FOR DATA COLLECTION AND DA TA CONVERSION. THIS WILL INCLUDE CAD DA TA AND DA TA SUBMISSION STANDARDS. PHASE II DELIVERABLES DURING PHASE n, GTG WILL BE RESPONSIBLE FOR PROVIDING THE FOLLOWING DELlVERABLES TO THE CITY: TASK 3 DELIVERABLES 1. A CITY-WIDE VISION STATEMENT 2. PRIORITIZED LIST OF DEPARTMENTAL GOALS AND OBJECTIVES TASK 4 DELlVERABLES 1. A GOVERNANCE MODEL THAT BEST FITS THE CITY 2. AN OPTIMUM AND RECOMMENDED STAFFING STRUCTURE ( INCLUDING COSTS AND RECOMMENDED SALARIES) 3. RECOMMENDED STAFFING SOLUTIONS, BASED ON THE SIX FUNCTIONAL AREAS 4. GIS DATA POLICIES AND GENERAL PROCEDURES FOR THE GIS INITIATIVE TASK 5 DELIVERABLES SCHEMATIC FLOW DIAGRAMS DEPICTING THE EXISTING SYSTEM ARCHITECTURE FOR EACH DEPARTMENT 2. A RECOMMENDED SYSTEM ARCHITECTURE DESIGN 3. PROCUREMENT PLAN FOR THE PROPOSED SYSTEM ARCHITECTURE L Geographic Technologies Group 8 Scope of Services  City of Fort Walton Beach GIS Needs Assessment and Implementation Plan Development TASK 6 DELIVERABLES A MASTER DATA LIST 2. DOCUMENTATION OF ALL DATA LAYERS PERTAINING TO EACH DEPARTMENT' S OPERATIONS 3.