Loading...
HomeMy WebLinkAbout516354 THE OMEGA GROUP INC - CONTRACT - RFP - 7396 PFA FIRE SERVICE RESPONSE PERFORMANCE ANALYSISERVICES AGREEMENT THIS AGREEMENT made and entered into the day and year set forth below by and between THE CITY OF FORT COLLINS, COLORADO, a Municipal Corporation, hereinafter referred to as the "City" and also on behalf of Poudre Fire Authority, hereinafter referred to as PFA, and the Omega Group, Inc., hereinafter referred to as "Service Provider'. WITNESSETH: In consideration of the mutual covenants and obligations herein expressed, it is agreed by and between the parties hereto as follows: 1. Scope of Services. The Service Provider agrees to provide services in accordance with the scope of services attached hereto as Exhibit "A", consisting of sixteen (16) pages and incorporated herein by this reference. 2. Contract Period. This Agreement shall commence May 1, 2013, and shall continue in full force and effect until March 31, 2014, unless sooner terminated as herein provided. Time is of the essence. 3. Delay. If either party is prevented in whole or in part from performing its obligations by unforeseeable causes beyond its reasonable control and without its fault or negligence, then the party so prevented shall be excused from whatever performance is prevented by such cause. To the extent that the performance is actually prevented, the Service Provider must provide written notice to the City of such condition within fifteen (15) days from the onset of such condition. 4. Early Termination by City/Notice. Notwithstanding the time periods contained herein, the City may terminate this Agreement at any time without cause by providing written notice of termination to the Service Provider. Such notice shall be delivered at least fifteen (15) days prior to the termination date contained in said notice unless otherwise agreed in writing by the parties. All notices provided under this Agreement shall be effective when mailed, postage prepaid and sent to the following addresses: Services Agreement 7396 PFA Fire Service Response Software Page 1 of 33 • Compare peak vs. non -peak response times • Analyze the effect of changes in deployment Technical Approach The FireView Dashboard is a Service Provider -hosted, server -based application that presents a thin -client interface for user interaction. FireView Desktop is a client -based application that presents a graphic user interface for user interaction. Analysis within both applications is performed on data generated from other parts of the enterprise, for example the Records Management System (RMS) and Geographic Information Systems (GIS). The application is built around Esri's ArcGIS Server (FireView Dashboard) and Esri's ArcGIS Desktop (FireView Desktop) to support the geographic and analysis functions. FireView Dashboard and Desktop interface with the RIMS and GIS data using data extraction, preparation and automation processes via the Omega Import Wizard. Using the Omega Import Wizard, Service Provider creates data models tailored to the PFA's data sources that can be further modified to meet the PFA's specific business requirements. A (SQL Server & ArcGIS Server) spatial data warehouse will house information from the data sources and used to provide data to the application. Views of these data will become geographic data layers that can be queried and mapped. In the FireView Dashboard these data may then be used in the geographic widgets and analysis tools. In the FireView Desktop these data are used in the native Esri formats including a geodatabase and a feature class in an ArcSDE layer. Additional Considerations FireView Dashboard and FireView Desktop analyze data input through other systems and thus has an indirect dependency on those systems. Service Provider does not warrant the quality of data entered by the users into other systems that FireView Dashboard and FireView Desktop consumes, therefore, there is an inherent risk in the quality, accuracy, and availability of data outputted by both applications. Task Order Service Provider will deliver the FireView portfolio of solutions over a six month period of time. Milestones events relative to this deployment include: 1. Middleware Installation at Poudre Fire Authority 2. FireView Desktop deployment 3. FireView Dashboard deployment Project Planning/Management 1.1. Software and database requirements 1.1.1. Review deliverables for PFA 1.1.1.1. Service Provider PFA software: Omega Import Wizard, Omega Extractor 1.1.1.2. Esri software: ArcGIS Desktop 10 1.1.2. Review deliverables by PFA 1.1.2.1. Esri's ArcGIS 10 1.2. System Architecture 1.2.1. Identify hardware components and configuration. 1.2.1.1. Import server 1.3. GIS map layers and design preferences 1.3.1. Identify base map GIS data layers for geographic querying Services Agreement 7396 PFA Fire Service Response Software Page 10 of 33 1.3.2. Identify reference data for geocoding 1.4. CAD/RMS/other source data 1.4.1. Review import process and automation 1.4.2. Identify fields to be imported 1.4.3. Review database schema and tabular relationships 1.5. Dashboard Design 1.5.1. Review design options for baseline deployment 1.6. Determine remote connection method 1.7. Review roles and responsibilities 2. Omega Import Wizard Configuration 2.1. PFA will install ArcGIS on import workstation 2.2. PFA will install Import Wizard on import server or workstation 2.2.1. Service Provider will extract sample datasets for application development 2.3. Service Provider will update import profile for CAD or RMS data extraction 2.3.1. Service Provider will create SOL Statement 2.3.2. Service Provider will configure data processing steps 2.3.3. Service Provider will work with PFA to group incident types into one of the available standard Service Provider fire type categories (where applicable) 2.3.4. Service Provider will configure geocoding process, review the sample data's geocoding rates and provide recommendations 2.3.5. Service Provider will configure output data sets and automation FireView Desktop Deployment 3. FireView Application Configuration 3.1. Service Provider will add GIS layers to map document and design base map cartography, public safety symbology, labeling and layout template 3.2. Service Provider will create saved queries database 3.2.1. PFA will provide pick list values in tabular format 3.2.2. Define saved queries (not to exceed 5 saved query categories per import dataset) 3.3. Create Cost Matrix for response analysis tools 3.4. Configure Crystal Report templates 3.4.1. Incident Detail and Summary (Incident) 3.4.2. Apparatus Detail (Apparatus) 3.4.3. Incident Repeat Calls (Incident) 3.4.4. Exception Report (Incident) 3.4.5. Response Comparison Report (Apparatus) 3.4.6. Apparatus Response Time (Apparatus) Optional Reports, PFA will select no more than five (5) from the following list: 3.4.7. Response Time Fractals (Incident) 3.4.8. Response Time Percentiles (Incident) 3.4.9. Stacked/Concurrent Calls (Incident) 3.4.10. Incident Loss Value (Incident) 3.4.11. Apparatus 1710 Response (Apparatus) 3.4.12. Incident Audit (Incident) 3.4.13. Call Frequency (Incident) 3.4.14. Temporal Response Time (Apparatus) Services Agreement 7396 PFA Fire Service Response Software Page 11 of 33 3.4.15. Resource Allocation (Apparatus) 3.4.16. Effective Response Force (Apparatus) 4. FireView Application Deployment (Remote) 4.1.1. PFA will install/license ArcGIS Desktop on each workstation 4.1.2. PFA will install/license FireView Desktop on each workstation 4.1.3. PFA/Service Provider will establish a centralized location for the GIS data and shared application resources 4.1.4. Service Provider will test the import process and FireView Desktop application 4.1.5. Service Provider will import up to three (3) months of historical data for each dataset; PFA will be responsible for importing data beyond three (3) months 4.1.6. Service Provider will configure the profile import automation with PFA's assistance 5. FireView Application Training (At Client Site) 5.1. FireView Desktop on -site training 5.1.1. Up to six (6) computers for training; Recommended participants include the following: 5.1.1.1. Public Safety analyst 5.1.1.2. GIS manager 5.1.1.3. Command staff representative 5.1.1.4. IT representative 5.1.1.5. Records or data entry clerk 5.1.1.6. Database administrator 5.1.2. One (1) Service Provider trainer will conduct the training session 5.1.3. Training will be approximately twelve (12) hours over the course of two (2) days 5.1.4. PFA will ensure that the appropriate ESRI software is installed on the training workstations, prior to the arrival of Service Provider trainer 5.2. Service Provider will provide FireView Desktop refresher tutorials 6. Final Application Review 6.1. Following FireView Desktop training, there will be a fourteen (14) day review period. The review period serves as quality assurance/control to ensure the project has been completed and the deliverables conform to the scope. Areas to review: 6.1.1. FireView saved queries are working properly and the correct pick list values are included 6.1.2. FireView saved queries return anticipated results (records) 6.1.3. Data shown in the selection table and reports matches source data 6.1.4. Omega Street network is accurately tuned 6.1.5. Geocode process is configured properly 6.2. Service Provider will send PFA a project completion sign -off form; PFA will sign/date the form and e-mail/fax back to Service Provider and the project will be marked as complete. Services Agreement 7396 PFA Fire Service Response Software Page 12 of 33 FireView Dashboard Deployment 7. FireView Dashboard Application Configuration 7.1. The Dashboard will include a rolling thirty-six (36) months of historical data for each dataset 7.2. Service Provider will configure each dataset to display up to twenty (20) fields 7.3. Service Provider will use the Bing geocoding service unless PFA requests that their own spatial reference data be used in which case Service Provider will create the address locator 7.4. Service Provider will configure up to ten (10) geographic query layers 7.5. Service Provider can configure up to five (5) operational layers 7.6. Service Provider will create up to five hundred (500) total saved query pick list items per query layer 7.7. Service Provider will use Bing maps for the application's background layers or can possibly integrate with PFA's existing map caches (hosted on a different server at the client's site) 7.8. Configure FireView Dashboard design 7.8.1. Briefing Books 7.8.1.1. Service Provider will configure one (1) Briefing Book which will include RMS-NFIRS data 7.8.1.1.1. One (1) Executive Briefing Book with approximately (48) Widgets 7.8.2. Pages 7.8.2.1. Incident trends 7.8.2.2. Recent activity 7.8.3. Widgets 7.8.3.1. Filter/Pin Map/Heat Map 7.8.3.2. Density Map 7.8.3.3. Trend Chart 7.8.4. Hot Sheet; Service Provider will configure up to five (5) Alerts 8. FireView Dashboard Deployment 8.1. Service Provider will deploy the FireView Dashboard application 8.2. Service Provider will configure data import profiles for data transfer to the FireView Dashboard 8.3. Service Provider will import up to three (3) months of historical data for each dataset; PFA will be responsible for importing beyond three (3) months 8.4. Service Provider will schedule automated data import/extractor process 8.5. Dashboard Widgets will refresh at least one (1) time per day and up to four (4) times per day if the resources and configuration will allow for that 9. FireView Dashboard Application Training 9.1. Service Provider will provide up to six (6) hours of remote Administrator/Designer training for up to two (2) trainees 9.1.1. The FireView Dashboard Admin Designer Tutorial PDF document will be e- mailed to the Administrator/Designer trainees following training 9.2. Service Provider will provide up to two (2) sessions of up to four (4) hours of training on functionality features for up to ten (10) trainees per session (on -premise training). Services Agreement 7396 PFA Fire Service Response Software Page 13 of 33 9.2.1. The FireView Dashboard End User Tutorial PDF document will be e-mailed to the End User trainees following training 10. Final Application Review 10.1. Following End User training, there will be a fourteen (14) day review period. The review period serves as quality assurance/control to ensure the project has been completed and the deliverables conform to the scope. Areas to review: 10.1.1. Saved queries are working properly and the correct pick list values are included 10.1.2. Data shown in the report grid and identify box matches source data 10.1.3. Geographic query layers and selection fields are correct 10.1.4.Operational layers are working properly and are labeled with the correct field 10.1.5. Geocoding process is configured properly 10.1.6. Dashboard queries return anticipated results (records) 10.1.7. Dashboard is functioning properly 10.2. The application content is configurable around your data; the application interface is not customizable 10.3. Service Provider will send PFA a project completion sign -off form; PFA will sign/date the form and e-mail/fax back to Service Provider and the project will be marked as complete. Deliverables For each deliverable, the response of 'Both" indicates that FireView Dashboard and Desktop satisfy the requirement. Response of "Desktop" or "Dashboard" indicates one or the other application satisfies the requirement, but not both. Response of "Not Available" indicates Omega does not meet the deliverable. These responses are shaded. Required Service/Deliverable Application Methodology Analyze response performance Both Out of the box capability for both applications Specify alternate fire apparatus locations and scenarios Desktop Station Analysis is a routine in Desktop for analyzing how well a configuration of resources is able to deliver services to geographic areas within a community. Calculate response performance and provide graphical displays • Provide reports by call category Both Out of the box capability • Provide reports by individual fire management zones Both Out of the box capability Automatic color -coding of the service area according to Both Out of the box capability for both applications hazard type and time targets Calibrate response model to mimic real world street Desktop Street speed information will be adjusted (or network tuned) to reflect speeds commensurate with actual unit response data. This is done by using ArcGIS and FireView routines to raise/lower street speeds in areas around each existing station and throughout the street network based upon actual apparatus drive time response data. Estimate of response travel distance based on actual street Desktop Out of the box capability network Call -to -scene time estimates based on historical CAD data Desktop Out of the box capability. Apparatus run -loads and availability for new location Desktop Out of the box capability, Station analysis scenarios based on historical distribution of incidents calculates run loads relative to hypothetical distribution coverage Services Agreement 7396 PFA Fire Service Response Software Page 14 of 33 Response performance projections for apparatus Desktop, Future release, 2013 relocations calculated to match actual recorded Future performance Release Calculations of both average and percentile response performances for the jurisdiction, station areas and various fire management zones within the service area. Analyze selected incidents in multiple ways using multiple criteria: • Shift Both Out of the box capability. • Time of day Both Out of the box capability. • Day of week Both Out of the box capability. • Month Both Out of the box capability. • Type of call Both Out of the box capability. • Specific unit areas Both Out of the box capability. Displays of response performances for any designated call Both Out of the box capability. type (fires, medicals, rescues, hazardous materials etc.) Capabilities for using, deleting, saving, retrieving, and Both Out of the box capability. comparing different analysis scenarios An easy -to -use interface Dashboard Please check our references Capabilities for specifying and reviewing response Both Out of the box capability. performance at specific locations Compatible with Windows Operating System Both Out of the box capability. Taps into historical CAD data and reviews current workloads Both Out of the box capability. and response performance Performs on -the -spot "what if" analysis of the department's Desktop Out of the box Station Analysis current performance Generates objective, factual data to explain departmental Both Both applications use factual data derived performance at all levels from CAD or RMS records Enables decision -makers to gain insights into current Both Out of the box capability performance Prints easy -to -understand, color -coded maps for analysis Desktop Out of the box capability. and reporting Exports color -coded maps to other formats including Desktop Out of the box capability. Microsoft Excel, Word, PowerPoint and in PDF format. Zooms in for a view of all incident data and factors including Both Out of the box capability. landmarks, schools, or other specific identified risks Calculate workload and response performance for Both Out of the box capability. specifying days of the week, times of day, seasons of the year, and incident type groups. Extract incidents of a given type or time period and display their density thematically in a map. Displaying thematically the percentage of incidents meeting Dashboard Out of the box capability. performance targets. Zoom controls for close-up viewing of all color -coded Both Out of the box capability. incidents in an area. ID control to obtain all details about an incident including number, date, location, etc. Review current coverage using different response criteria Both Out of the box capability. Experiment with different time targets Both Out of the box capability. Calculate response performance reports by individual fire Both Out of the box capability. management zones Plot incident plots along with the line-up and response Desktop Out of the box capability. Response performance info Comparison report and map to see variance Services Agreement 7396 PFA Fire Service Response Software Page 15 of 33 between target time and actual time for first unit arrival Plot unit response plots along with their response Desktop Out of the box capability. Response performance Comparison report and map to see variance between target time and actual time for all units Analyze the frequency with which units respond outside Desktop Out of the box capability. Response Reliability their first due areas for purposes of response reliability I Report Compare peak vs. non -peak response times Both Out of the box capability. Temporal Heat Index charting and Reporting for comparing response times 240 Identify whether the CAD is dispatching the wrong units Not Available Analyze the effect of changes in deployment Desktop Out of the box, Reliability Report and Station Analysis Software vendor will provide adequate training on the use Both Package service, onsite training for both of both/each product applications provided. PFA Roles and Responsibilities Critical to the success of every implementation is having the appropriate client staff prepared to be active participants and to understand what is expected from them for the duration of the implementation. PFA Project Manager The PFA project manager is responsible for the timely coordination of assigned project tasks. Database Administrator The PFA database administrator is responsible for providing information about the CAD/RMS database and assisting with the collection of source data, including provision of an ODBC database connection when necessary. IT Specialist The PFA IT specialist is responsible for installing/licensing the Esri/Omega software, providing a method of remote access, and creating a sub -domain host header. GIS Analyst The PFA GIS analyst is responsible for providing and maintaining base map data in an ESRI compatible format. Public Safety Analyst The public safety analyst should have experience working with CAD/RMS data. The public safety analyst should provide input during the project's development. Dashboard Administrator The Dashboard Administrator is responsible for adding/maintaining user accounts. The Dashboard Administrator can also be the Dashboard Designer. Dashboard Designer The Dashboard Designer is responsible for creating/maintaining Dashboard content (Widgets, Pages, Alerts, Queries on Demand, etc). Services Agreement 7396 PFA Fire Service Response Software Page 16 of 33 Service Provider Roles and Responsibilities Service Provider Project Manager/Implementation Specialist The Service Provider project manager/Implementation Specialist is responsible for the coordination, development and implementation of a project. A project manager/ Implementation Specialist has both the technical proficiency and management skills to carry out all project tasks from inception to completion. Project managers will prioritize project tasks in accordance with project schedules and delegate work to project staff as necessary. Responsibilities include: • Leading internal and/or external meetings on project kickoff, implementation, scheduling, project status and project evaluation • Planning, executing, tracking and measuring all project activities required for the successful delivery of Service Provider application(s) • Identifying priorities and managing the resources required to meet the project objectives • Performing and/or managing the technical tasks involved in the GIS application development process to include, but not limited to: data collection, geocoding, queries, report writing, and map production • Delivering project in compliance with both client and internal quality control standards and guidelines • Conducting training Dashboard Deployment Specialist The Service Provider Deployment Specialist is responsible for remotely installing each server - based Service Provider application within the PFAs environment or at Service Provider's hosting facility. This takes place once the project build has been completed and the application has been fully tested at Service Provider's. Responsibilities include: • Verifying that the required hardware and software is in place to run the application • Installing all ESRI software required by the application (as well as SQL Server, where necessary) • Installing all FireView Dashboard software • Configuring the application to function within the specified environment • Troubleshooting any environmental issues that may arise during deployment General System Requirements Software Specifications FireView Desktop: the following software will be required for the deployment: • Omega Import Wizard • Esri's ArcGIS (ArcView), version 10 • Esri's ArcGIS (Spatial Analyst) version 10 FireView Dashboard: the following software will be required for Service Providers Cloud -based deployment: • Omega Import Wizard (Only one license required and will be shared with FireView Desktop, see above) • Omega Extractor • Esri's ArcGIS (ArcView), version 10 Data Specifications Services Agreement 7396 PFA Fire Service Response Software Page 17 of 33 FireView Dashboard automates the import of source data via an application called the Import Wizard. Each FireView Dashboard dataset (layer) is imported daily via Import Wizard profiles (licensed individually). The profile license contains configuration information for extracting data from an RMS (via a SQL Statement), geocoding, data processing, & subsequently outputs/appends the result into a GIS feature class format. It is important to consider that source data originating from a relational database will be transposed into a de -normalized (flat file) format. As a result, there will be one "dot' on the map per record in the FireView Dashboard dataset. The maximum number of records returned on a Dashboard widget or query is 5,000 records Dataset IData Source Dataset Data Source Incident Reports I High Plains RMS Apparatus Reports I High Plains RMS Data Schema The following data fields will be included within the standard offering of the FireView Dashboard and Desktop. If these fields are not readily available within the RMS database, this information will not be included in either application. No substitutions will be made for other available fields unless identified during contract negotiations. j AGENCY jj 11 AGENCY j YES I YES j YES jI YES j IIJf I11CNT NI IKADCD 9 ihll 1CNT NI IAA VCC - INCIDENT CATEGORY 0 FV LEGEND YES YES YES YES INCIDENT TYPE 4 r, INC TYPE YES YES YES YES SHIFT SHIFT YES YES VES YES ADDRESS 6 FV_ADDRESS YES _ APARTMENT �-7 AREA 1* 8 YES YES YES__ AREA 2* 0� YES YES YES AREA 3* 10 '_ ,' YES YES YES STATION 11 STATION YES YES YES YES ( RESPONSE --- — - - 'TYPE/PRIORITY RESPONSE 12 RESP_TYPE_DESC YES YES YES YES 911 DATE 13 911_DATE YES ��� j NOTIFY DATE 141 NOTIFY —DATE YES ARRIVAL DATE 15 ARRIVAL_DATE LAST UNIT CLEAR DATE 16 CLEAR DATE YES I DEPT RESPONSE 'TIME 18 DEPT RESP TIME YES YES** j� TOTAL_REFLEX_TI TOTAL REFLEX TIME y 19 , ME YES YES Services Agreement 7396 PFA Fire Service Response Software Page 18 of 33 ACTION TAKEN 20 _ ACTIONI_DESC YES YES YES YES PROPERTY USE 21 PROP_USE_DESC YES YES YES YES PROPERTY LOSS 22 PROP —LOSS YES PROPERTY VALUE I PROP_VALUE PROPERTY SAVED PROP LOSS, j (percent value) 24 PROP —VALUE _ YES_ MUTUALAID2SJ MUTUAL_AID_DE yES YES YES YES CAUSE OF IGNITION 26 CAUSE _IGN_DESC YES YES YES YES FS_FATAL, FS_N 0 N FATAL, OTHER —FATAL, OTHER_NONFATA INJURY FATALITY*** 27 L YES YES i REPORT COMPLETED 28 COMPLETED YES YES YES YES *Each Area field may include one of the following: District, Zone, Atom, First Due, City, Zip Code, etc. ** Part of "Response Times" query group *** If possible, created by using a formula to combine RMS/CAD fields into single Dashboard field IIVIIUOYI IMUIVIOLR L 11MlIVC1YI IYVIVI ICJ UNIT YES APPARATUS TYPE 4 UNIT TYPE DESC YES YES YES YES ARRIVAL ORDER �5 OVERALL ORDER_ yES YES YES YES INCIDENT CATEGORY 6 1 FV_LEGEND YES YES YES YES ���� YES OTOP INCIDENT TYPE I 7 INC TYPE_DESC YES YES YES (TOP 20) 2 ) � ADDRESS 8 FV_ADDRE_SS YES APARTMENT AREA 1* 10 YES YES YES AREA 2* 11 YES YES YES AREA 3* 12 YES YES YES STATION 13 STATION YES YES YES YES SHIFT 14 SHIFT YES YES YES YES RESPONSE TYPE/PRIORITY ��❑� � RESPONSE 15 RESP TYPE_DESC YES YE YES j Y S 911 DATE 16 911_DATE YES NOTIFY/DISPATCH I— 17 DISPATCH_DATE YES ��r Services Agreement 7396 PFA Fire Service Response Software Page 19 of 33 City: Copy to: Service Provider: City of Fort Collins Poudre Fire Authority The Omega Group, Inc. Attn: Purchasing Attn: Capt. Holger Durre Attn: Chris Baldwin, Regional Sales PO Box 580 PO Box 580 Executive Fort Collins, CO 80522 Fort Collins, CO 80522 5160 Carroll Canyon Road, Suite 100 San Diego, CA 92121 In the event of early termination by the City, the Service Provider shall be paid for services rendered to the date of termination, subject only to the satisfactory performance of the Service Provider's obligations under this Agreement. Such payment shall be the Service Provider's sole right and remedy for such termination. 5. Contract Sum. The City shall pay the Service provider for the performance of this Contract, subject to additions and deletions provided herein, per the attached Exhibit "A", consisting of seventeen (17) pages and Exhibit "C", consisting of two (2) pages, and incorporated herein by this reference. 6. City Representative. The City will designate, prior to commencement of the work, its representative who shall make, within the scope of his or her authority, all necessary and proper decisions with reference to the services provided under this agreement. All requests concerning this agreement shall be directed to the City Representative. 7. Independent Service provider. The services to be performed by Service Provider are those of an independent service provider and not of an employee of the City of Fort Collins. The City shall not be responsible for withholding any portion of Service Provider's compensation hereunder for the payment of FICA, Workmen's Compensation or other taxes or benefits or for any other purpose. 8. Personal Services. It is understood that the City enters into the Agreement based on the special abilities of the Service Provider and that this Agreement shall be considered as an agreement for personal services. Accordingly, the Service Provider shall neither assign any responsibilities nor delegate any duties arising under the Agreement without the prior written consent of the City. Services Agreement 7396 PFA Fire Service Response Software Page 2 of 33 DATE ENROUTE/ROLL DATE 18 ENROUTE_DATE_ YES ARRIVAL DATE IF 19 ARRIVAL_DATE ;CLEAR DATE 20 CLEAR —DATE YES TURNOUTTIME 2TI TURNOUT_TIME j TRAVEL TIME 22 . TRAVEL —TIME YES YES*** RESPONSE �� *** TIME �I 23 ! DEPT_P_TIME YES YES TIMERES TOTAL_REFLEX_TI TOTAL REFLEX TIME 24 ME YES _ YES*** RESOURCE TIME jr 25,LTOME_RESOURCE YES YES*** f j.PROPERTY USE 26 PROP USE YES YES*** YES YES ' ACTION TAKEN IF 27 ACTIONI-,DESC - YES YES Y S Y S . MUTUAL _AID DE II LMUTUALAID 28 SC YES YES YES YES *Each Area field may include one of the following: District, Zone, Atom, First Due, City, Zip Code, etc. **If not available, Service Provider can create the UNIT —NUMBER field when technically feasible ** Part of "Response Times" query group GIS Data Specifications Boundary and Landmark Features: PFA shall provide files of relevant boundaries and landmarks within the area of interest. Typical features include: • Boundaries and jurisdictions such as beats and reporting districts • Landmark information such as schools, parks, and other locations of interest Networkable Street Centerline File FireView Desktop Only It is important that the street network file accurately support networking functions, including travel speeds, one-way streets, prohibited turns, overpasses, underpasses, and closed streets, where appropriate. It will be PFA's responsibility at all times to ensure that the Street Network is accurate and compliant with the FireView application. Geocoding Reference Data PFA is responsible for providing accurate reference data that will be used to generate a geocoding service. Reference data may include the following geography: street centerline file, address points or a parcel layer. Background Layers FireView Dashboard Only The FireView Dashboard supports the use of one or more Background Layers (or map caches). These Background Layers are used to display a base map as a backdrop to the Geoprocessing results. Bing maps are the default map cache for the application's background layers. The following alternatives for map caches are available for Service Provider -Hosted and On Premise deployments: 1) MS Bing* or Esri Maps Services Agreement 7396 PFA Fire Service Response Software Page 20 of 33 - Both street and air photo for the application's background layers. 2) PFA map caches - The following criteria must be met if PFA wishes to use their own maps caches: a. Caches must be built using the Web Mercator Auxiliary Sphere (102100 or 3857) projection b. If multiple caches will be used in the Dashboard, the zoom levels must match between caches c. The caches must be accessible by URL to all intended end -users d. The client is responsible for maintaining the map cache(s) and assuring its' availability and accessibility. At any time, Service Provider maintains the exclusive right to determine a third party map cache source to be used in the FireView Dashboard application. At its sole discretion, Service Provider may replace one third party map cache source for another. Application Specifications Report Specifications FireView Dashboard Only Reporting is designed in Microsoft Silverlight. Capabilities include sorting and grouping of records, dynamic mapping and charting. Report Specifications FireView Desktop Only Crystal Reports is the standard reporting tool for FireView Desktop. FireView includes a set of standard report templates. Service Provider can design additional reports at the request of PFA (additional fees apply). Symbology All applications include standard Service Provider symbology for each data source. Operational Layers FireView Dashboard Only An operational layer represents a set of geographic features, typically boundaries or landmarks that can be displayed on top of the base geography. Saved Queries Saved queries are a set of pre -defined data queries organized in folders. Data queries are based on data available from the RMS system and vary in design from one application to another. Geographic Queries Geographic queries filter your data query by location, a known boundary, point of interest, address or intersection. This will limit your search results to those records occurring within the selected boundary, or within the specified radius of the point of interest, address or intersection. Windows Specifications A local administrator account is required for Service Provider use on all servers involved in the project. This account must be the same across all servers and must use the same, non - expiring password. Services Agreement 7396 PFA Fire Service Response Software Page 21 of 33 Remote Access Requirement • Establishing remote connection to the server(s) o Data collection, installation and technical support will be performed through remote connection o Service Provider recommends VPN or Citrix's GoToMyPC for remote connections • PFA must provide the necessary remote access details Hardware Specifications Import Server • Quad -Core Intel® Xeon® processor • 6 GB RAM • RAID 1 or RAID 5 disk configuration using SAS 15K RPM 146GB disks or better • Gigabit Ethernet network card Fire View Desktop End -user Workstations • Processor: Intel Core 2 Duo Processor (not less than 2.6 Ghz) • RAM: 4 GB • Hard drive: 250 GB • Graphics Card: 256 MB RAM or better • Network Card: Gigabit Ethernet • OS: Windows XPNistaiWindows 7 • Other: DVD drive Fire View Dashboard End -user Workstations • Processor: 2.00 GHz Dual -core Intel processor (or faster) • RAM: 2 GB • Network Card: 1 Gb (1000 Mb) Gigabit • Monitor: Minimum resolution: 1024px X 768px • OS: Windows XP SP3 or newer • Browser Support: Firefox, Safari, Chrome, or IE7 (or higher) • Other: Silverlight 4 (or higher) Services Agreement 7396 PFA Fire Service Response Software Page 22 of 33 Configuration Diagram The diagram below depicts a typical data flow from the client databases to the FireView Desktop Source RMS/ CAD Import Server User Workstations databases) -^ pis WD tw nrwm for Deshbp orr e.ImpPl Wtra0 itr.VWr M.M" The diagram below depicts a typical data flow from the client databases to the FireView Dashboard Client Network Ws W.n �st )uD ray.n Server �sRmw.xp 1 •hnW Wure �OmeP4nxm. \�rV� gj an.rsw.eee Omega Hosting Environment Internet aA I gym, sr�...xweo • •artsoesme.u..xp Services Agreement 7396 PFA Fire Service Response Software Page 23 of 33 EXHIBIT B INSURANCE REQUIREMENTS 1. The Service Provider will provide, from insurance companies acceptable to the City, the insurance coverage designated hereinafter and pay all costs. Before commencing work under this bid, the Service Provider shall furnish the City with certificates of insurance showing the type, amount, class of operations covered, effective dates and date of expiration of policies, and containing substantially the following statement: "The insurance evidenced by this Certificate will not be cancelled or materially altered, except after ten (10) days written notice has been received by the City of Fort Collins." In case of the breach of any provision of the Insurance Requirements, the City, at its option, may take out and maintain, at the expense of the Service Provider, such insurance as the City may deem proper and may deduct the cost of such insurance from any monies which may be due or become due the Service Provider under this Agreement. The City, its officers, agents and employees shall be named as additional insureds on the Service Provider's general liability and automobile liability insurance policies for any claims arising out of work performed under this Agreement. 2. Insurance coverages shall be as follows: A. Workers' Compensation & Employer's Liability. The Service Provider shall maintain during the life of this Agreement for all of the Service Provider's employees engaged in work performed under this agreement: Workers' Compensation insurance with statutory limits as required by Colorado law. 2. Employer's Liability insurance with limits of $100,000 per accident, $500,000 disease aggregate, and $100,000 disease each employee. B. Commercial General & Vehicle Liability. The Service Provider shall maintain during the life of this Agreement such commercial general liability and automobile liability insurance as will provide coverage for damage claims of personal injury, including accidental death, as well as for claims for property damage, which may arise directly or indirectly from the performance of work under this Agreement. Coverage for property damage shall be on a "broad form" basis. The amount of insurance for each coverage, Commercial General and Vehicle, shall not be less than $500,000 combined single limits for bodily injury and property damage. In the event any work is performed by a subcontractor, the Service Provider shall be responsible for any liability directly or indirectly arising out of the work performed under this Agreement by a subcontractor, which liability is not covered by the subcontractor's insurance. Services Agreement 7396 PFA Fire Service Response Software Page 24 of 33 EXHIBIT C COST SCHEDULE Schedule of Rates and Cost by Task Service Provider's presentation of costs is for a fixed -fee deployment. All software and services described under the headings of FireView Dashboard Hosted Deployment and FireView Desktop Deployment will be performed for the stated amounts due during the first and second year of service. Year 1 Year 2 Total Budget $48,550.00 $10,200.00 Discounts $1,080.00 $1,530.00 Amount Due: 47,470.0 8,670.0 Billing Rates All services performed by Service Provider's staff are billed at the rate of $185.00 per hour Subscription and Maintenance Fees Subscription and Maintenance fees represent the ongoing cost of maintaining the proposed applications. Fee payment will commence upon completion of installation and training of the system and cover the first twelve months of use of applications. The first year of subscription fees are included in the total year one costs. • Annual fees are subject to a maximum 3% increase per year. Payment Schedule In consideration of the services to be performed and delivered, Service Provider shall be entitled to compensation in the total amount of $47,470.00. The payment schedule consists of six (6) payments and is due as follows; assuming Services Agreement is signed and in force by May 1, 2013: FireView Desktop Application • FireView Desktop $8,850.00 Payment due upon completion of Project Planning software license costs Meeting (Task 1)* estimated May 14, 2013 and travel costs • FireView Desktop 40% $7,200.00 Payment due upon completion of FireView Desktop of Professional Application Deployment (Task 4)* estimated July 15, Services Costs 2013 • FireView Desktop 40% $7,200.00 Payment due upon completion of FireView Desktop of Professional Training (Task 5)* estimated July 31, 2013 Services Costs • FireView Desktop 20% $3,600.00 Payment due upon completion of FireView Desktop of Professional Final Application Review (Task 6)* estimated August 15, Service Costs 2013 Services Agreement 7396 PFA Fire Service Response Software Page 25 of 33 FireView Dashboard Application • Set up/ Training/ $14,500.00 Payment due upon project initiation estimated May 14, Travel 2013 or alternate date August 30, 2013 • Subscription Fee for $6,120.00 Payment due upon completion of installation and Year 1 training (Task 5)* estimated September 30, 2013 * See Task Order Third Party Software and Hardware Requirements/Price Summary The following software and hardware is required, however NOT included are part of the deliverables from Service Provider. PFA should use this table as a requirement/budgetary checklist. Software Esri Software • ArcGIS 10 • Spatial Analyst Hardware • Import Server Year 1 Year 2 2 single or concurrent $3,000.00 $1,000.00 1 single or concurrent $2,500.00 Data Tom Tom Dynamap Transportation Data Services Agreement 7396 PFA Fire Service Response Software $5,000.00 estimate $6,000.00 $2,500.00 Page 26 of 33 EXHIBIT D CUSTOMER SUPPORT PROGRAM Customer Support Program The Customer Support Program is limited to the policies below: Definitions Customer Support Program: The software and application maintenance package. Support Activation Date: The date support begins. This occurs on the installation date of the software application. Term Date: The due date for annual payment of the Customer Support Program will be referred to as the Term Date. The Term Date is established as the day and month that the software is installed on. Payment Guidelines 1. The cost of the Customer Support Program is calculated to be 20% the cost of software and data connections. 2. Payment for the Customer Support Program is collected annually on the Term Date. The first annual payment is due one (1) year after the Installation of software. 3. Approximately 45 days prior to the annual Term Date, Service Provider will send notice of payment in the form of an invoice to the client by email. 4. After the first annual payment, all future payments for the Customer Support Program are subject to an increase not to exceed a 3% increase, annually. 5. The Software Maintenance for additional software licenses that are purchased after the Support Activation Date will be paid on the Customer Support Program's Term Date. a. The first annual payment for the additional Software Maintenance will be prorated based on the number of days during the term that preceded the licensing of the additional software. b. Following the first annual (prorated) payment, annual payments for additional Software Maintenance will be paid in full on the Customer Support Program's Term Date. General Terms To be eligible for Service Provider support services, PFA users should be aware of, and adhere to the following terms: The software license will be registered with Service Provider. The Service Provider Project Manager may assist with software registration. Service Provider provides technical support for Service Provider software and the Omega Import Wizard interface(s) only. Specific items not included under technical support are provided below (Section: Limitations). Services Agreement 7396 PFA Fire Service Response Software Page 27 of 33 3. The initial Service Provider software application implementation and installation must be performed by a Service Provider Project Manager. This requirement assures that telephone support, future software service packs, and major version upgrades can be administered effectively. 4. By paying for support, PFA agrees to receive support services from Service Provider and accepts the terms and limitations of the Customer Support Program. 5. The Customer Support Program will automatically renew each term unless cancelled prior to the term date with 60 days written advance notice by sending an email to a olaNheomeoag rou o. com. 6. Should there be a lapse in payment, all past due fees must be paid to restart service. Limited to three years of past due payments. Limitations PFA Users should be aware of the following limitations regarding support services: Service Provider's technical support is limited to unmodified, "off -the -shelf" Service Provider software technology. Any issues that arise from PFA modifying the application's files, configuration, or environment without Service Provider approval will not be covered under this agreement. PFA will be charged an additional fee per incident or per hour to troubleshoot and resolve the issue. 2. Technical support is not a replacement for training. Additional application training is available from Service Provider at an additional cost. 3. Technical support does not cover configuration changes to existing applications and/or additional development to the Service Provider application (i.e. building new profiles, reports, saved queries, etc.). These professional services can be provided for an additional cost. 4. Technical Support only covers issues with Service Provider software and excludes any issues with 3rd party applications that interface with Service Provider software. 5. Technical support does not cover issues that arise from changes/upgrades in the PFA's hardware, operating system, source databases (RMS, CAD and other Databases), source data (geographic layers: including streets, boundaries, points or any reference data) or network environment. PFA will be charged an additional fee per incident or per hour to troubleshoot and resolve the issue. 6. Service Provider is not responsible for maintaining back-up files of the PFA's software application. Service Provider may have copies of the PFAs application files stored at Service Provider's (acquired during the application building and testing process), however, this data is limited to the extractions or samples received during the application development and can quickly become out-of-date. 7. In the event of complete data loss due to PFA's server crashing or other circumstances unrelated to the Service Provider's software, Service Provider can assist as resources Services Agreement 7396 PFA Fire Service Response Software Page 28 of 33 permit, but will not be held financially responsible for reinstalling and reconfiguring the application. Service Provider will provide these services at an additional charge for time, materials, and travel. B. Service Provider's Customer Support Program is not a replacement for ESRI's software Customer Support Program and does not include costs for ESRI's suite of software products, including costs to install/uninstall ESRI software components. 9. Service Provider's Customer Support Program includes software bug fixes and software enhancements for existing, unmodified applications. Service Provider will contact PFA to schedule updates to the application as they become available. 10. Service Provider software is dependent upon specific versions of 3rd party software applications. Upgrades to 3rd party software used to run Service Provider software will require a new version of Service Provider software to be installed to remain compatible. Upgrades to Service Provider software are only provided for products that have not reached the "mature' or "retired" phase of the product lifecycle. Full -version upgrades of Service Provider software in support of upgrading 3rd party applications are not covered under support and will require additional charges for time and materials. Please contact Service Provider before planning any upgrade to supporting 3rd party software applications. Remote Connectivity Technical Support will be performed through a remote connection. Service Provider recommends a VPN or Cirtrix's GoToMyPC for remote connections. PFA must provide the necessary remote access details if a VPN is used. If PFA is unable to provide a high speed remote connection, a fee will be incurred based on the additional time required for troubleshooting the support request. Support Hours Technical support hours are Monday through Friday, from 7:00 AM to 5:30 PM Pacific. Technical support can be reached by calling (800) 228-1059 or by sending email to Supportat7.theomegagroup.com. It is Service Provider's intent to respond to all technical support inquiries within twenty-four (24) hours of receiving the request, during normal business hours. Addendum to Service Provider Maintenance Program The FireView Dashboard Application Support Plan is intended to provide product enhancements, bug fixes, and on -going software support for the original, unmodified configuration of any FireView Dashboard application. This support plan includes the following: • Diagnosis of Service Provider (Dashboard application) software issues' • Resolution of Service Provider (Dashboard application) software issues2 • Diagnosis of configuration issues3 • Resolution of configuration issues° • Service Provider Software Updates Services Agreement 7396 PFA Fire Service Response Software Page 29 of 33 9. Acceptance Not Waiver. The City's approval or acceptance of, or payment for any of the services shall not be construed to operate as a waiver of any rights or benefits provided to the City under this Agreement or cause of action arising out of performance of this Agreement. 10. Warran a. Service Provider warrants that all work performed hereunder shall be performed with the highest degree of competence and care in accordance with accepted standards for work of a similar nature. b. Unless otherwise provided in the Agreement, all materials and equipment incorporated into any work shall be new and, where not specified, of the most suitable grade of their respective kinds for their intended use, and all workmanship shall be acceptable to City. C. Service Provider warrants all equipment, materials, labor and other work, provided under this Agreement, except City -furnished materials, equipment and labor, against defects and nonconformances in design, materials and workmanship/workwomanship for a period beginning with the start of the work and ending twelve (12) months from and after final acceptance under the Agreement, regardless whether the same were furnished or performed by Service Provider or by any of its subcontractors of any tier. Upon receipt of written notice from City of any such defect or nonconformances, the affected item or part thereof shall be redesigned, repaired or replaced by Service Provider in a manner and at a time acceptable to City. 11. Default. Each and every term and condition hereof shall be deemed to be a material element of this Agreement. In the event either party should fail or refuse to perform according to the terms of this agreement, such party may be declared in default thereof. 12. Remedies. In the event a party has been declared in default, such defaulting party shall be allowed a period of ten (10) days within which to cure said default. In the event the default remains uncorrected, the party declaring default may elect to (a) terminate the Services Agreement 7396 PFA Fire Service Response Software Page 3 of 33 o Updates to Service Provider software functionality (as new product releases become available) o Bug fixes to Service Provider software for known issues o Version -compatibility upgrades to Service Provider software • Limited Dashboard Designer & Administrator assistance • Access to help & tutorial documentation • Map Cache Updates (for applications using Service Provider-built/maintained map caches) o PFA is entitled to two (2) map cache rebuilds annually (only if originally built by Service Provider) o Map cache rebuilds are by PFA request when updated geographic data is made available • Geography Layer Updates o PFA is entitled to two (2) geographic query (filter) layer updates annually' o Geography layer updates are by PFA request when new data is made available • Saved Query Updates o PFA is entitled to two (2) saved query updates annuallye o Saved Query updates are by PFA request when new query values are made available This support plan is NOT intended to provide the following Service Provider Professional Services: Upon completion of any FireView Dashboard application project, the following requests for service will incur an additional cost for time and materials: • Changes to data fields, data schema, or import profiles required as a result of a change to or switch of source RMS/CAD database systems • Lookup table updates that result in changes to the original FireView Dashboard application configuration • Identify/Report Grid field changes • Symbology legend changes • Query layer changes or the addition of new query layers • Re -import of historical data • End-usersupport9 • Dashboard Designer tasks (create, edit, & manage Dashboard content, Briefing Books, Pages, Widgets, Alerts, Queries on Demand, etc.) • Administrator tasks (create, edit, & manage Dashboard logins & permissions) • Training (End -User, Designer, or Administrator) 6 • Moving of a FireView Dashboard application (or single component of a FireView Dashboard application) to a new physical server (On -Premise Deployments Only) • Restoring of a FireView Dashboard application (or single component of a FireView Dashboard application) after a catastrophic event (On -Premise Deployments Only) 1 "Software issues' include technical questions that are directly related to the Service Provider software application including error messages, unexpected behaviors, etc. "Software issues' do not include training -related questions. 2 Service Provider will troubleshoot and fix "software issues" that are completely diagnosed to be an issue with the FireView Dashboard application under this agreement. Issues that result from conflicts with any other software applications being installed alongside of a FireView Dashboard application on the same computer hardware are not covered under this support agreement. Service Provider will not provide support unless the FireView Dashboard application Services Agreement 7396 PFA Fire Service Response Software Page 30 of 33 remains in a dedicated environment. This support agreement does not cover the resolution of any issues that may arise with a FireView Dashboard application as a result of non -Service Provider personnel interfering with the configuration and/or operation of the application. Resolution of these issues is billable to PFA for time and materials. 3 "Configuration issues' include questions that are directly related to the settings and configuration of the FireView Dashboard application. "Configuration issues' do not include training -related questions. 4 Service Provider will troubleshoot and fix any mis-configuration of the original FireView Dashboard application if it is shown to differ from PFA's original requirements for the application. The original requirements for the application must be shown in writing by the client to have preceded the completion date of the FireView Dashboard application project. 5 Service Provider will develop upgrades to the FireView Dashboard application to remain compatible with the latest version of any supporting ESRI software applications. Until a supporting release of the FireView Dashboard application is completed by the Service Provider, the version of ESRI software must not be changed from the originally deployed version. If requested by PFA, upgrades will be performed by Service Provider for an additional charge for time and materials. Migrations to a newer Service Provider software product are not covered. Newer Service Provider software products may be purchased from Service Provider. 6 Dashboard Designer, Administrator & End -User training can be purchased for an additional cost. 7 Geography layer updates are required to have an identical field schema to the original layer's format. Changes to the schema require changing the application's configuration and will incur an additional cost. 8 Saved query updates are limited to the saved queries groups included within the original application configuration and based on the original source field. Adding a new saved query group(s) or changing the source field will incur an additional cost. 9 PFA's Dashboard Designer and/or Administrator will serve as the first point of contact for all end -user support requests. For requests that cannot be resolved by the appointed client Dashboard Designer and/or Administrator, it is the responsibility of the PFA Dashboard Designer or Administrator to contact Service Provider for technical support where appropriate. Addendum to Service Provider Maintenance Program The FireView Desktop Support Plan is intended to provide on -going software support for the oriainal configuration of the Service Provider Desktop product. This support plan includes the following: • Service Provider software updates (minor) o Compatibility with the current ArcGIS release o Updates for the Omega Desktop software routines / functionality o Hoffixes • Assistance with the setup of Omega Desktop on a new server and/or user's computer. • Provision of the current Omega Desktop tutorial (digital format) • Diagnosis of Omega Desktop software issues' • Resolution of Omega Desktop software errors 1 "Software issues" include technical questions that are directly related to the Omega Desktop software. "Software issues' do not include training -related questions. Services Agreement 7396 PFA Fire Service Response Software Page 31 of 33 • Diagnosis of Configuration issues3 • Resolution of Configuration errors° The Basic Support Plan is NOT intended to provide services for the following tasks: Under the Basic Support Plan, the following requests for service will incur an additional cost: • Change RMS/CAD vendor(s) • RMS/CAD database schema updates (field length, type, size... table name change, etc... ) • Lookup table updates (code/description) • Saved query updates • Crystal Report updates • GIS source file updates • Geocoding rate enhancement • Re -import of historical data • Assistance with the setup of Omega Desktop on a new server or user's computer. • Change the GIS format (Shapefile, Personal Geodatabase, File Geodatabase, ArcSDE Geodatabase, etc...) of the reference data or Import Wizard output data. • Add/remove Import Wizard profile fields • GIS editing • Other source file. integration • Additional profiles • Consulting • Street network & cost matrix updates (integrating new/updated street data into the cost matrices) "Configuration Files" include the following: 1. The Omega Import Wizard's profile configuration a. SQL Statement b. Composite fields c. OmegaGIS fields d. Lookup fields e. Data cleaning f. Spatial query g. Address locators h. Standardization fixes i. Geocoding steps j. Preferences k. Output steps 2. The Omega Import Wizard job configuration (including scheduled task) 3. Crystal Reports 4. Saved Queries 5. GIS and/or other data 2 "Software errors' include software problems that impede the successful completion of an Omega Desktop routine (i.e. software bug and/or error message). 3 "Configuration Issues" include questions that are directly related to the Service Provider configuration files. "Configuration issues" do not include training -related questions. 4 "Configuration Errors" include any mis-configuration of the original Omega Desktop product that would impede the successful completion of an Omega Desktop routine (i.e. error message). Services Agreement 7396 PFA Fire Service Response Software Page 32 of 33 6. Map configuration (.mxd & .mxt) 7. Cyclical Reports 8. Threshold Alerts Services Agreement 7396 PFA Fire Service Response Software Page 33 of 33 THEOM-1 OP ID: LM ,�coiro~ CERTIFICATE OF LIABILITY INSURANCE � DATE(MM 04/30/13""' 113 THIS CERTIFICATE IS ISSUED AS A MATTER OF INFORMATION ONLY AND CONFERS NO RIGHTS UPON THE CERTIFICATE HOLDER. THIS CERTIFICATE DOES NOT AFFIRMATIVELY OR NEGATIVELY AMEND, EXTEND OR ALTER THE COVERAGE AFFORDED BY THE POLICIES BELOW. THIS CERTIFICATE OF INSURANCE DOES NOT CONSTITUTE A CONTRACT BETWEEN THE ISSUING INSURER(S), AUTHORIZED REPRESENTATIVE OR PRODUCER, AND THE CERTIFICATE HOLDER. IMPORTANT: If the certificate holder is an ADDITIONAL INSURED, the policy(ies) must be endorsed. If SUBROGATION IS WAIVED, subject to the terms and conditions of the policy, certain policies may require an endorsement. A statement on this certificate does not confer rights to the certificate holder in lieu of such endorsement(s). PRODUCER 619-238-1828 CONTACT NAME: SBS Commercial Group Alliant Insurance Services Inc 619-849-4731 CA License - OC36861INC,No,Eai: PHONE 619-238-1828 FAX 619-849-4731 (All, No): E-MAIL SS: sbs@alliantinsurance.com ADDRE 701 B Street, 6th Floor San Diego, CA 92101 5135-Select Business Solutions INSURER(S) AFFORDING COVERAGE NAICN INSURER A: Federal Insurance Company INSURED The Omega Group Inc Ms. Hernadez-Poindexter INSURER B: 5160 Carroll Canyon Rd 1St Fl. INSURER c: INSURER D: San Diego, CA 92121-1775 INSURER E INSURER F COVERAGES CERTIFICATE NUMBER: REVISION NUMBER: THIS IS TO CERTIFY THAT THE POLICIES OF INSURANCE LISTED BELOW HAVE BEEN ISSUED TO THE INSURED NAMED ABOVE FOR THE POLICY PERIOD INDICATED. NOTWITHSTANDING ANY REQUIREMENT, TERM OR CONDITION OF ANY CONTRACT OR OTHER DOCUMENT WITH RESPECT TO WHICH THIS CERTIFICATE MAY BE ISSUED OR MAY PERTAIN, THE INSURANCE AFFORDED BY THE POLICIES DESCRIBED HEREIN IS SUBJECT TO ALL THE TERMS, EXCLUSIONS AND CONDITIONS OF SUCH POLICIES. LIMITS SHOWN MAY HAVE BEEN REDUCED BY PAID CLAIMS. I NSRADDLPOLICY Err POLICY EXP TR TYPE OF INSURANCE INSR SdB POLICY NUMBER MMIDDIYYYY MMIDDNYYV LIMITS GENERAL LIABILITY EACH OCCURRENCE $ 1,000,000 A X COMMERCIAL GENERAL LIABILITY X 35797495WCE 08/27112 08127/13 PREMISES Ea occurrence $ 1,000,000 CLAIMS -MADE OCCUR MED EXP(Any one person) $ 10,000 PERSONAL S ADV INJURY $ 1,000,000 GENERAL AGGREGATE $ 2,000,000 GENT AGGREGATE LIMIT APPLIES PER: PRODUCTS - COMP/OP AGG $ 2,000,000 POLICY PRO- LOG $ AUTOMOBILE LIABILITY COMBINED SINGLE LIMIT Ea accident $ BODILY INJURY (Per person) $ ANY AUTO ALLOWNED SCHEDULED AUTOS AUTOS BODILY INJURY (Per accident) $ NON -OWNED HIRED AUTOS AUTOS PROPERTY DAMAGE Per accident $ UMBRELLA LIAB OCCUR EACH OCCURRENCE $ AGGREGATE $ EXCESS LIAB CLAIMS -MADE DED RETENTION$ $ WORKERS COMPENSATION AND EMPLOYERS' LIABILITY YIN ANY PROPRIETORIPARTNER/EXECUTIVE❑ OFFICERIMEMBER EXCLUDED? NIA WC STATU- OTH- TORY LIMITS _ER EL EACH ACCIDENT $ EL DISEASE - EA EMPLOYE $ (Mandatory in NH) It yes, describe under DESCRIPTION OF OPERATIONS below E.L. DISEASE -POLICY LIMIT $ DESCRIPTION OF OPERATIONS I LOCATIONS I VEHICLES (Attach ACORD 101, Additional Remarks Schedule, If more space Is required) RE: GIS MAPPING. The City of Fort Collins, its officers, agents and employees, The Poudre Fire Authority are named Additional Insured. CERTIFICATE HOLDER CANCELLATION SHOULD ANY OF THE ABOVE DESCRIBED POLICIES BE CANCELLED BEFORE City t.l of Fort Collins THE EXPIRATION DATE THEREOF, NOTICE WILL BE DELIVERED IN ACCORDANCE WITH THE POLICY PROVISIONS. Poudre Fire Authority PO Box 580 AUTHORIZED REPRESENTATIVE 215 N Mason Fort Collins, CO 80522 e%� [,zve- ACORD 25 (2010/05) @ 1988-2010 ACORD CORPORATION. All rights reserved. The ACORD name and logo are registered marks of ACORD Agreement and seek damages; (b) treat the Agreement as continuing and require specific performance; or (c) avail himself of any other remedy at law or equity. If the non -defaulting party commences legal or equitable actions against the defaulting party, the defaulting party shall be liable to the non -defaulting party for the non -defaulting party's reasonable attorney fees and costs incurred because of the default. 13. Binding Effect. This writing, together with the exhibits hereto, constitutes the entire agreement between the parties and shall be binding upon said parties, their officers, employees, agents and assigns and shall inure to the benefit of the respective survivors, heirs, personal representatives, successors and assigns of said parties. 14. Indemnity/Insurance. a. The Service Provider agrees to indemnify and save harmless the City, its officers, agents and employees against and from any and all actions, suits, claims, demands or liability of any character whatsoever brought or asserted for injuries to or death of any person or persons, or damages to property arising out of, result from or occurring in connection with the performance of any service hereunder. b. The Service Provider shall take all necessary precautions in performing the work hereunder to prevent injury to persons and property. c. Without limiting any of the Service Provider's obligations hereunder, the Service Provider shall provide and maintain insurance coverage naming the City as an additional insured under this Agreement of the type and with the limits specified within Exhibit "B", consisting of one (1) page, attached hereto and incorporated herein by this reference. The Service Provider before commencing services hereunder, shall deliver to the City's Director of Purchasing and Risk Management, P. O. Box 580 Fort Collins, Colorado 80522 one copy of a certificate evidencing the insurance coverage required from an insurance company acceptable to the City. 15. Entire Agreement. This Agreement, along with all Exhibits and other documents Services Agreement 7396 PFA Fire Service Response Software Page 4 of 33 incorporated herein, shall constitute the entire Agreement of the parties. Covenants or representations not contained in this Agreement shall not be binding on the parties. 16. Law/Severability. The laws of the State of Colorado shall govern the construction interpretation, execution and enforcement of this Agreement. In the event any provision of this Agreement shall be held invalid or unenforceable by any court of competent jurisdiction, such holding shall not invalidate or render unenforceable any other provision of this Agreement. 17. Prohibition Against Employing Illegal Aliens. Pursuant to Section 8-17.5-101, C.R.S., et. seq., Service Provider represents and agrees that: a. As of the date of this Agreement: 1. Service Provider does not knowingly employ or contract with an illegal alien who will perform work under this Agreement; and 2. Service Provider will participate in either the e-Verify program created in Public Law 208, 104th Congress, as amended, and expanded in Public Law 156, 108th Congress, as amended, administered by the United States Department of Homeland Security (the "e-Verify Program") or the Department Program (the "Department Program"), an employment verification program established pursuant to Section 8-17.5-102(5)(c) C.R.S. in order to confirm the employment eligibility of all newly hired employees to perform work under this Agreement. b. Service Provider shall not knowingly employ or contract with an illegal alien to perform work under this Agreement or knowingly enter into a contract with a subcontractor that knowingly employs or contracts with an illegal alien to perform work under this Agreement. c. Service Provider is prohibited from using the e-Verify Program or Department Program procedures to undertake pre -employment screening of job applicants while this Agreement is being performed. d. If Service Provider obtains actual knowledge that a subcontractor performing Services Agreement 7396 PFA Fire Service Response Software Page 5 of 33 work under this Agreement knowingly employs or contracts with an illegal alien, Service Provider shall: 1. Notify such subcontractor and the City within three days that Service Provider has actual knowledge that the subcontractor is employing or contracting with an illegal alien; and 2. Terminate the subcontract with the subcontractor if within three days of receiving the notice required pursuant to this section the subcontractor does not cease employing or contracting with the illegal alien; except that Service Provider shall not terminate the contract with the subcontractor if during such three days the subcontractor provides information to establish that the subcontractor has not knowingly employed or contracted with an illegal alien. e. Service Provider shall comply with any reasonable request by the Colorado Department of Labor and Employment (the "Department") made in the course of an investigation that the Department undertakes or is undertaking pursuant to the authority established in Subsection 8-17.5-102 (5), C.R.S. f. If Service Provider violates any provision of this Agreement pertaining to the duties imposed by Subsection 8-17.5-102, C.R.S. the City may terminate this Agreement. If this Agreement is so terminated, Service Provider shall be liable for actual and consequential damages to the City arising out of Service Provider's violation of Subsection 8-17.5-102, C.R.S. g. The City will notify the Office of the Secretary of State if Service Provider violates this provision of this Agreement and the City terminates the Agreement for such breach. 18. Special Provisions. Special provisions or conditions relating to the services to be performed pursuant to this Agreement are set forth in Exhibit "D", consisting of seven (7) pages, attached hereto and incorporated herein by this reference. Services Agreement 7396 PFA Fire Service Response Software Page 6 of 33 CITY OF FORT COLLINS, COLORADO a municipal rporation n By: Gerry Paul Director of Purchasing and Risk Management Date: S— / Z% 13 POUDRE FIRE AUTHORITY O By: 7::� e Tom DeMint, FYe Chief Date: 6—/.3113 THE OMEGA GROUP, INC. By: IfEii�?14� M I I an M ue, kr PRINT NAME Pres t rl"4 CORPORATE PRESIDENT OR VICE PRESIDENT Date:- r4 - ?-1- 15 (Corporate Seal) CORPORATE SECRETARY Services Agreement 7396 PFA Fire Service Response Software Page 7 of 33 EXHIBIT A SCOPE OF WORK The City of Fort Collins, on behalf of the Poudre Fire Authority (PFA), is purchasing software for fire service data management to provide high quality data analysis for the purposes of a Standard of Cover study. This would include analyzing response performance, and incident coverage by actual drive time. The PFA is beginning the process of pursuing accreditation through the Commission on Fire Accreditation International by purchasing software that will enable it to analyze the performance of fire companies for the purposes of a standard of cover document required in the accreditation process. PFA further would like to be able to analyze system response performance based on changes made to deployment and/or station placement. SOFTWARE OBJECTIVES The goal of the PFA is to provide world class fire service to the community it serves and to meet the mission "To protect citizens and their property by being Prompt, Skillful and Caring". This involves timely response and an ability to accurately dispatch units to the appropriate locations. PFA desires to have access to daily information on response performance as well as a historical analysis of deployment capabilities. This would include analysis of the distribution, concentration and response reliability of units. Required Services/Deliverables: The software shall, at a minimum, meet the following: FIRE SERVICE RESPONSE PERFORMANCE ANALYSIS SOFTWARE (for SOC Study) • Analyze response performance • Specify alternate fire apparatus locations and scenarios • Calculate response performance and provide graphical displays -Provide reports by call category -Provide reports by individual fire management zones • Automatic color -coding of the service area according to hazard type and time targets • Calibrate response model to mimic real world street network • Estimate of response travel distance based on actual street network • Call -to -scene time estimates based on historical CAD data • Apparatus run -loads and availability for new location scenarios based on historical distribution of incidents • Response performance projections for apparatus relocations calculated to match actual recorded performance: Requirement will be met in future release • Calculations of both average and percentile response performances for the jurisdiction, station areas and various fire management zones within the service area. Analyze selected incidents in multiple ways using multiple criteria: -Shift Services Agreement 7396 PFA Fire Service Response Software Page 8 of 33 -Time of day -Day of week -Month -Type of call -Specific unit areas • Displays of response performances for any designated call type (fires, medicals, rescues, hazardous materials etc.) • Capabilities for using, deleting, saving, retrieving, and comparing different analysis scenarios • An easy -to -use interface • Capabilities for specifying and reviewing response performance at specific locations • Compatible with Windows Operating System • Taps into historical CAD data and reviews current workloads and response performance • Performs on -the -spot "what if analysis of the department's current performance • Generates objective, factual data to explain departmental performance at all levels • Enables decision -makers to gain insights into current performance • Prints easy -to -understand, color -coded maps for analysis and reporting • Exports color -coded maps to other formats including Microsoft Excel, Word, PowerPoint and in PDF format. • Zooms in for a view of all incident data and factors including landmarks, schools, or other specific identified risks • Calculate workload and response performance for specifying days of the week, times of day, seasons of the year, and incident type groups. Extract incidents of a given type or time period and display their density thematically in a map. • Displaying thematically the percentage of incidents meeting performance targets. • Zoom controls for close-up viewing of all color -coded incidents in an area. ID control to obtain all details about an incident including number, date, location, etc. • Review current coverage using different response criteria • Experiment with different time targets • Calculate response performance reports by individual fire management zones • Plot incident plots along with the line-up and response performance info • Plot unit response plots along with their response performance • Analyze the frequency with which units respond outside their first due areas for purposes of response reliability Services Agreement 7396 PFA Fire Service Response Software Page 9 of 33