Loading...
HomeMy WebLinkAboutContract 44848 (2)Hosting Agreement � iit�J e , �, • � t.' 1 1;�� .—�..,. . _•.�.__.-_.. �, : _ This Hosting Agreement ("Agreement") is entered into this �� � day of September, 2013, to be ("Effective Date"), by and between the City of Fort Worth for the use and benefit of the Fort Worth Police Department ("Client"), with its principal place of business located at 350 West Belknap Street, Fort Worth, TX 76102 and The Omega Group, Inc. ("Omega"), a California Corporation, with its principal place of business located at 5160 Carroll Canyon Road, San Diego, CA 92121. 1 2 Services 1.1 Purpose. Omega agrees to host software and provide data import and export, monitoring, support, backup, technology upgrades, and training necessary for the Client's productive use of such software in addition to all the services described in the CrimeView Dashboard Scope of Work ("Scope of Work") to upgrade Client's data and interfaces from the CrimeView Server local, server-based application to the CrimeView Dashboard hosted application. The Scope of Work is attached hereto as Exhibit "A" and incorporated herein for all purposes as though it were set forth at length. Omega retains the right to perForm work for others during the terms of this Agreement. 1.2 Backup and Recovery of Client Data. Omega is responsible for storing a backup of the Client's data no less than daily and for an orderly and timely recovery of its data in the event that the Services may be interrupted. Omega will not be responsible for the Client's data lost after the most current backup and before the next scheduled backup. Omega is responsible for establishing and maintaining an information security environment that does the following: (i) ensures the security and confidentiality of the Client's data; (ii) protects against any anticipated threats or hazards to the security or integrity of the Client's data; (iii) protects against unauthorized access to or use of the Client's data; and (iv) ensures the proper disposal of the Client's data. 1.3 Control of Services. The method and means of providing the Services shall be under the exclusive control, management, and supervision of Omega, giving due consideration to the requests of the Client. 1.4 Change Order Procedure. The Client may make written requests for changes in the scope of the Services, and Omega shall notify the Client whether or not the change is feasible and any associated costs for the change. With written approval from the Client, Omega shall issue a change order for execution by both parties. Term and Termination. 2.1 Term. The term (the "Initial Term") shall commence on the Effective Date and continue for 12 months thereafter. Following the Initial Term, the Agreement may be renewed for successive one year terms (each, a"Renewal Term") by Omega issuing the Client a signed, written invoice that sets forth the term of the renewal period and the applicable fee for that period, and the Client signifying its acceptance of the renewal and fees by signing and returning the invoice to Omega. "Term" shall collectively mean ��.n�+ ?n^'� ��'� -��re-�greement terms represented by the Initial Term and the Ren�u������. ���������� Hosting Agreement — Omega and City of Fort Worth � _ : � o- :;. ,. ( ' �: Page 1 of 7 2.2 Termination for Cause. If either party materially breaches any of its duties or obligations hereunder, and such breach is not cured, or the breaching party is not diligently pursuing a cure to the non breaching party's sole satisfaction, within thirty (30) calendar days after written notice of the breach, then the non breaching party may terminate this Agreement for cause as of a date specified in such notice. 2.2.1 Termination Due to Lack of Appropriations. As to the Client's performance of the obligations in this Agreement, Omega acknowledges and agrees that the Client is a governmental entity, and because of statutory, constitutional and local charter provisions, it cannot commit to the funding of the Client's obligations described herein beyond each fiscal year. Therefore, the funding obligations of the Client described herein are subject to and conditioned upon the Fort Worth City Council appropriating for each fiscal year sufficient funds to satisfy such obligations. If for any reason, at any time during any Term of this Agreement, the City Council fails to appropriate funds sufficient for the Client to fulfill all or part of its obligations under this Agreement, the Client may terminate this Agreement ("Funding Termination") to be effective on the later of: (i) thirty (30) days following delivery by the Client to Omega of written notice of the Client's intention to terminate or (ii) the last date for which funding has been appropriated by the City Council for the purposes set forth in this Agreement. 2.3 Payments upon Termination. Upon the expiration or termination Agreement for any reason, Client shall pay to Omega all undisputed due and payable hereunder. of this amounts 2.4 Return of Materials. Upon expiration or earlier termination of this Agreement, each party shall: (a) promptly return to the other party, or certify the destruction of any of the following of the other party held in connection with the perFormance of this Agreement or the Services: (i) all Confidential Information; and, (ii) any other data, programs, and materials; and, (b) return to the other party, or permit the other party to remove, any properties of the other party then situated on such party's premises. In the case of Client Data, Omega shall, immediately upon termination of this Agreement, certify the destruction of any Client Data within the possession of Omega. The parties agree to work in good faith to execute the foregoing in a timely and efficient manner. This Section shall survive the termination of this Agreement. 3. Non-Disclosure of Confidential Information The parties acknowledge that each party may be exposed to or acquire communication or data of the other party that is confidential, privileged communication not intended to be disclosed to third parties. 3.1 Meaning of Confidential Information. For the purposes of this Agreement, the term "Confidential Information" shall mean all information and documentation of a party that: (a) has been marked "confidential" or with words of similar meaning, at the time of disclosure by such entity; (b) if disclosed orally or not marked "confidential" or with words of similar meaning, was subsequently summarized in writing by the disclosing entity and marked "confidential" or with words of similar meaning. Hosting Agreement — Omega and City of Fort Worth Page 2 of 7 Hosting Agreement — Omega and City of Fort Worth Page 3 of 7 � .• . 4.1 Pre-existing Materials. The Client acknowledges that, in the course of performing the Services, Omega may use software and related processes, instructions, methods, and techniques that have been previously developed by Omega and that same shall remain the sole and exclusive property of Omega. 4.2 The provisions of this Section shall survive the termination of this Agreement. 5. Fees and Expenses. Client shall be responsible for and shall pay to Omega the fees not to exceed Forty- Seven Thousand Nine Hundrecf Fifty-Five Dollars and tVo Cents ($47,955.00) for all Services provided during the initial one-year Term as outlined in the Cost Summary, which is attached hereto as Exhibit "B" and incorporated herein for all purposes as though it were set forth at length. Payments shall be made in accordance with the Payment Schedule included in the Cost Summary. For any Renewal Term, the fee shall be limited to the Annual Subscription Fee as defined in Exhibit B. Any sum due Omega for Services perFormed for which payment is not otherwise specified shall be due and payable thirty (30) days from Invoice Date by Client of an invoice from Omega. 5.1 Billing Procedures. Unless otherwise provided for herein, Omega shall bill to Client the sums due by Omega's invoice, which shall contain: (a) Client purchase order number, if any, and invoice number; (b) description of Services rendered; (c) the Services fee or portion thereof that is due; and, (d) total amount due. Omega shall forward invoices in electronic copy format to: w� r,� t�° �C� t, r; �J �" 5.2 Late Payments. Payments made by Client later than thirty (30) days from Invoice Date are subject to five (5%) APR interest on such payment. 5.3 Fees. In consideration of the services to be performed and delivered, Omega shall be entitled to compensation in the total amount of $47,955.00. 5.4 Additional Work. -Omega shall not perform any additional services for the Client not specified by this Agreement unless the Client requests and approves in writing the additional costs for such services. The Client shall not be liable for any additional expenses of Omega not specified by this Agreement unless the Client first approves such expenses in writing. 6. Relationship between Omeqa and Client 6.1 Independent Contractor Status. The parties are and shall be independent contractors to one another, and nothing herein shall be deemed to cause this Agreement to create an agency, partnership, or joint venture between the parties. Nothing in this Agreement shall be interpreted or construed as creating or establishing the relationship of employer and employee between Client and either Omega or any employee or agent of Omega. 6.2 Non-solicitation. During the term of this Agreement and for a period of six (6) months after the expiration or termination of this Agreement, for any reason whatsoever, the parties covenant and agree not to hire or engage or attempt to Hosting Agreement — Omega and City of Fort Worth Page 4 of 7 hire or engage employees of the other party, except through advertisements directed to the general public or as expressly pre-approved by the other party. 6.3 Confidentiality. The parties agree not to disclose to any third party any Confidential Information disclosed to it by the other party without the prior written consent of such disclosing party. Each party further agrees to take the same care with the Confidential Information of the other party as it does with its own, but in no event with less than a reasonable degree of care. This obligation of the parties shall survive beyond the effective termination date of this Agreement. These restrictions shall not be construed to apply to (1) information generally available to the public; (2) information released by either party generally without restriction; (3) information independently developed or acquired by either party or its personnel without reliance in any way on other protected information of the other party; (4) information approved for the use and disclosure of either party or its personnel without restriction; or (5) information that is required to be disclosed pursuant to subpoena, court order, or other legal mandate, including, but not limited to, the Texas Public Information Act (Tex. Govt Code Ch. 552). 6.4 Indemnification. Omega shall defend, indemnify and hold Client harmless from and against any and all liabilities, losses, damages, fines, judgments, claims, suits, actions and expenses (including, but not limited to, attorneys' fees and costs) arising out of or relating to personal injury or death to persons, including Omega's employees, contractors, and agents or damage to personal or real property, including Client's property, arising out of or in connection with Omega's grossly negligent perFormance of this Agreement and arising out of or relating to claims from any third party regarding infringement of intellectual property rights by or related to the products and services Omega provides to Client. Client agrees to give Omega prompt notice of any such claim, demand, or action and shall, to the extent Client is not adversely affected, cooperate fully with Omega in defense and settlement of said claim, demand, or action. However, with the exception of damages related to claims of infringement of intellectual property rights, Client agrees that Omega's liability hereunder for damages, regardless of the form of action, shall not exceed the total amount paid for services under this Agreement. _ 6.5 DISCLAIMER OF WARRANTY. EXCEPT AS EXPRESSLY PROVIDED IN THIS AGREEMENT, OMEGA DOES NOT MAKE ANY WARRANTY, EXPRESS OR IMPLIED, WITH RESPECT TO THE SERVICES RENDERED BY ITS PERSONNEL OR THE RESULTS OBTAINED FROM THEIR WORK, INCLUDING, WITHOUT LIMITATION, ANY IMPLIED WARRANTY OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. 6.6 LIMITATION OF LIABILITY. WITH THE EXCEPTION OF CLAIMS OF INFRINGEMENT OF INTELLECTUAL PROPERTY RIGHTS, OMEGA'S CUMULATIVE LIABILITY UNDER OR FOR BREACH OF THIS AGREEMENT SHALL BE LIMITED TO THE FEES PAID BY CLIENT TO OMEGA. IN NO EVENT SHALL OMEGA BE LIABLE FOR ANY LOSS OF PROFITS, ANY INCIDENTAL, SPECIAL, EXEMPLARY OR CONSEQUENTIAL DAMAGES, OR ANY CLAIMS OR DEMANDS BROUGHT AGAINST CLIENT, EVEN IF OMEGA HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH CLAIMS OR DEMANDS. OMEGA SHALL NOT BE LIABLE TO CLIENT FOR ANY FAILURE Hosting Agreement — Omega and City of Fort Worth Page 5 of 7 � OR DELAY CAUSED BY EVENTS BEYOND OMEGA'S CONTROL, INCLUDING, WITHOUT LIMITATION, CLIENT'S FAILURE TO FURNISH NECESSARY INFORMATION; SABOTAGE; FAILURE OR DELAYS IN TRANSPORTATION OR COMMUNICATION; FAILURES OR SUBSTITUTIONS OF EQUIPMENT; LABOR DISPUTES; ACCIDENTS; SHORTAGES OF LABOR, FUEL, RAW MATERIALS OR EQUIPMENT; OR TECHNICAL FAILURES. WITH THE EXCEPTION OF CLAIMS OF INFRINGEMENT OF INTELLECTUAL PROPERTY RIGHTS, THIS �IMITATION UPON DAMAGES AND CLAIMS IS INTENDED TO APPLY WITHOUT REGARD TO WHETHER OTHER PROVISIONS OF THIS AGREEMENT HAVE BEEN BREACHED OR HAVE PROVEN INEFFECTIVE. 7. Miscellaneous 7.1 Governing Law. This Agreement shall be governed and construed in all respects in accordance with the laws of the State of Texas as they apply to a contract executed, delivered, and performed solely in such State. 7.2 Insurance. To the extent that Omega's personnel may perform work at Client's premises, Omega shall maintain comprehensive general liability insurance, including broad form property damage coverage, with limits of at least $1 million combined single limit for personal injury and property damage for each occurrence. Upon the request of Client, Omega shall provide Client with evidence satisfactory to Client of such insurance. 7.3 Remedies. All remedies available to either party for one or more breaches by the other party are and shall be deemed cumulative and may be exercised separately or concurrently without waiver of any other remedies. The failure of either party to act in the event of a breach of this Agreement by the other shall not be deemed a waiver of such breach or a waiver of future breaches, unless such waiver shall be in writing and signed by the party against whom enforcement is sought. 7.4 Notices. Any notices to be given her�under by either party to the other may be effected either by email, personal delivery in writing or by first class mail. Mailed notices shall be addressed as listed below, but each party may change such address by written notice in accordance with this paragraph. Notices delivered personally will be deemed communicated as of actual receipt. Mailed notices will be deemed communicated as of two days after mailing. City of Fort Worth c/o FWPD 350 West Belknap Street Fort Worth, TX 76102 Attn: Accounts Payable The Omega Group 5160 Carroll Canyon Road, Suite 100 San Diego, CA 92121 Attn: Accounts Receivable 7.5 Entire Agreement of the Parties. This Agreement (together with all attachments and exhibits) supersedes any and all agreements, either oral or written, between the parties with respect to the rendering of services by Omega for Client and contains all the covenants and agreements between the parties with respect to the rendering of such services in any manner whatsoever. Each party to this agreement acknowledges that no representations, inducements, promises, or Hosting Agreement — Omega and City of Fort Worth Page 6 of 7 agreements, orally or otherwise, have been made by any party, or anyone acting on behalf of any party, that are not embodied herein, and that no other agreement, statement, or promise not contained in this agreement shall be valid or binding. Any modification of this agreement will be effective only if it is in writing signed by the party to be charged. 7.6 Severability. If any of the provisions of this Agreement are ruled illegal, invalid or unenforceable by a court of competent jurisdiction under any applicable statute or rule of law, they shall, to that extent, be deemed omitted, and the remainder of this Agreement shall continue to be in full force and effect. No waiver of any breach of any provision of this Agreement shall constitute a waiver of any other breach of the same or any other provision hereof, and no waiver shall be effective unless made in writing and signed by an authorized representative of the waiving party. 7.7 Headings. The section headings used herein are for reference only, and shall not limit or control any term or provision of this Agreement or the interpretation or construction hereof. IN WITNESS WHEREOF, the parties have caused this Agreement to be executed by their duly authorized representatives as set forth below. The Omega Group, Inc., San Diego, CA � ��L `i �: t� (, '� wL1':� -�' � �' -G`'�� City of Fort Worth Fort Worth, TX Milan Mueller, President i iiie Date o q zs i3 Hosting Agreement — Omega and City of Fort Worth Page 7 of 7 ACCEPTED AND AGREED: APPROVAL RECOMMENDED: sy: u' • � Jeffrey W. alstead Chief of Police Date: � 2 3 / 3 APPROVED AS TO FORM AND �.�GALI'�Y: ; � By: � � �� � Denis McErr.oy Sr. Assistant City Ab Contract Authorization: M&C: � C tv� � � 1����� 4� Date Approved: ATTEST: / By: ��' � Mary J. Kayser City Secretary .� F� � � u� �� ��; ...; � f� � , ,., , �. ,. � Hosting Agreement — Omega and City of Fort Worth ,: , k. - r Exhibit �► .. - . ��. Omega shall perform all tasks outlined below, which are further described in Completion of the tasks is subject to Client's compliance with its obligations as the heading "Roles and Responsibilities." Task 1. - Project Planning/Management 1.1. Software and database requirements 1.1.1. Review deliverables for Client 1.1.1.1. Omega Client software this Exhibit A. outlined under Omega Import Wizard, Omega Extractor 1.1.1.2. Omega server application 1.1.2. Review deliverables by Client 1.1.2.1. ESRI ArcGIS 10 1.2. System Architecture 1.2.1. Identify hardware components and 1.2.1.1. Import Server 1.3. GIS map 1.3.1. CrimeView Dashboard configuration layers Identify base map GIS data layers for geographic querying and operational layers 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 Task 2. Omega Import Wizard Configuration 2.1. Client will install/license ArcGIS on import server or workstation 2.2. Client will install/license Import Wizard on import server or workstation 2.3. Omega will create import profiles for CAD/RMS/AFR/Parole data extraction 2.3.1. Omega will create SQL statement 2.3.2. Omega will configure data processing steps 2.3.3. Omega will work with the Client to group incident types/call types into one of the available standard Omega crime type categories (where applicable) 2.3.4. Omega will configure geocoding process, review the sample data's geocoding rates and provide recommendations 2.3.5. Omega will configure output dataset Task 3. CrimeView Dashboard Application Configuration 3.1. The Dashboard will include a rolling thirty-six (36) months of historical data for each dataset 3.2. Omega will configure each dataset to display up to twenty (20) fields 3.3. Omega will configure ESRI geocoding services 3.4. Omega will configure up to ten (10) geographic query layers 3.5. Omega will configure up to five (5) operational layers 3.6, Omega will create up to five hundred (500) total saved query pick list items per Exhibit A-Scope of Work Page 1 of 10 query layer 3.7. Omega will use ESRI map caches for the application's background layers, or possibly integrate with a Client's existing map caches (hosted on a server at the Client's site), or use Bing Maps if the Client procures and provides a license key from Microsoft. 3.8. Configure CrimeView Dashboard design 3.8.1. Briefing Books 3.8.1.1. Omega will configure up to two (2) Briefing Books which will include CAD-Calls for Service and RMS-Incident data 3.8.1.1.1. One (1) Executive Briefing Book with up to twenty-five 3.8.2. Pages 3.8.2.1 (25) Widgets 3.8.1.1.2. One (1) Roll Call Briefing Book with up to thirty-five (35) Widgets; the Client will be responsible for building identical Roll Call Briefing Books for the other area(s) of accountability following the Administrator/Designer training Crime trends 3.8.2.2. Recent activity 3.8.3. Widgets 3.8.3.1. Filter/Pin Map/Heat Map 3.8.3.2. Density Map 3.8.3.3. Trend Chart 3.8.4. Hot Sheet; Omega will configure up to five (5) Alerts 3.8.5. The Dashboard content listed above will be configured according to the Dashboard Briefing Books document. Client should review those documents and identify any changes during the sales process. An additional cost may be incurred with changes. Task 4. CrimeView Dashboard Deployment 4.1. Omega will deploy the CrimeView Dashboard application 4.2. Omega will import up to three (3) months of historical data for each dataset; the Client will be responsible for importing beyond three (3) months 4.3. Omega will configure the Omega Extractor and configure the profile import automation with the ClienYs assistance 4.4. 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 Task 5. CrimeView Dashboard Application Training 5.1. Omega will provide up to six (6) hours of web-based Administrator/Designer training for up to six (6) trainees 5.1.1. The CrimeView Dashboard Admin Designer Tutorial PDF document will be e-mailed to the Administrator/Designer trainees following training 5.2. Omega 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). 5.2.1. The CrimeView Dashboard End User Tutorial PDF document will be e- mailed to the End User trainees following training Task 6. Final Application Review 6.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 Exhibit A-Scope of Work Page 2 of 10 completed and the deliverables conform to the scope. Areas to review: 6.1.1. Saved queries are working properly and the correct pick list values are included 6.1.2. Data shown in the report grid and identify box matches source data 6.1.3. Geographic query layers and selection fields are correct 6.1.4. Operational layers are working properly and are labeled with the correct field 6.1.5. Geocode process is configured properly 6.1.6. Dashboard queries return anticipated results (records) 6.1.7. Dashboard is functioning properly 6.2. The application content is configurable around your data; the application interface is not customizable 6.3. Omega will send the Client a project completion sign-off form; the Client will sign/date the form and e-mail/fax back to Omega and the project will be marked as complete. Exhibit A-Scope of Work Page 3 of 10 Training Omega shall provide instructor-led courses that provide students with the knowledge and skills that are needed to operate manage and support the Omega modules, that offer significant hands-on practice opportunities as well as discussions, and assessments that assist students in becoming proficient in the skills that are needed to manage and execute the functions of each Omega module successfully. CrimeView Dashboard Training Omega shall provide CrimeView Dashboard training sessions that are highly personalized and interactive, covering capabilities under each of the four (4) types of user groups including system administrators, designers, standard and shared users as well as a complete review of all features and functionalities of the CrimeView Dashboard. This comprehensive training package shall consist of and include the following components: Administrator Training Omega shall provide an Administrator training that introduces the Dashboard and provides guidance on how to manage the Dashboard's users, roles and content. The Administrator training package shall include: • Reviewing the data collection process • Adding and deleting users • Setting Up and configuring security and permissions • Creating CrimeView Dashboard widgets, pages, and Briefing Books • Navigating/using the CrimeView Dashboard Designer Training Omega shall provide a Designer training that introduces the Dashboard and provides guidance on how to manage the Dashboard's content. The Designer training package shall include: s Creating CrimeView Dashboard widgets, pages, and Briefing Books s Navigating/using the CrimeView Dashboard End User Training Omega shall provide an End User training package that trains the Client's end users and/or the end user trainer (train-the-trainer) on the CrimeView Dashboard web-based user interface. The End-User training shall include topics ranging from simple user interaction to more advanced ad hoc reporting and interactive data analysis, etc. The End User training package shall include: • Navigating/using the CrimeView Dashboard • PerForming on-the-fly query creation and report generation (data analysis) s Using Queries on Demand and Alerts Exhibit A-Scope of Work Page 4 of 10 Roles and Responsibilities Client Roles anc! Responsibilities Completion of the implementation is dependent on Client staff actively participating throughout the duration of the implementation. Client Project Manager The Client shall assign a project manager who shall be responsible for the timely coordination of assigned project tasks. Database Administrator The Client shall assign a database administrator who shall be 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 Client shall designate an IT specialist who shall be responsible for installing/licensing the ArcView and Omega Desktop software, providing a method of remote access, and creating a sub-domain host header. GIS Analyst The Client shall assign a GIS analyst who shall be responsible for providing and maintaining base map data in an ESRI compatible format. Crime Analyst The Client shall designate a crime analyst with experience working with CAD/RMS data. The crime analyst will provide input during the project's development. Dashboard Administrator The Client shall designate a Dashboard Administrator who shall be responsible for adding/maintaining user accounts. The Dashboard Administrator can also be the Dashboard Designer. Dashboard Designer The Client shall assign a Dashboard Designer who shall be responsible for creating/maintaining Dashboard content (Widgets, Pages, Alerts, Queries on Demand, etc.). Omega Roles and Responsibilities Omega Project Manager/Lead Omega shall designate a project manager/lead who shall be responsible for the coordination, development and implementation of a project. A project manager/lead 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 Omega application(s) • Identifying priorities and managing the resources required to meet the project objectives s PerForming and/or managing the technical tasks involved in the GIS application Exhibit A-Scope of Work Page 5 of 10 development process to include, but not limited to: data collection, geocoding, queries, report writing, and map production s Delivering project in compliance with both Client and internal quality control standards and guidelines • Conducting training Deployment Specialist Omega shall designate a Deployment Specialist who shall be responsible for remotely installing each server-based Omega application within the Client's environment or at Omega's hosting facility. This installation takes place once the project build has been completed and the application has been fully tested at Omega. Responsibilities for the Deployment Specialist 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 CrimeView Dashboard software • Configuring the application to function within the specified environment • Troubleshooting any environmental issues that may arise during deployment Exhibit A-Scope of Work Page 6 of 10 Customer Support Program The Customer Support Program is covered under the annual subscription fee. The customer support program is defined by 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 installation of the software is accepted by Client. General Terms Omega support services are subject to Client's compliance with the following terms: 1. The software license must be registered with The Omega Group. The Omega Project Manager may assist with software registration. 2. The Omega Group provides technical support for Omega software and the Omega Import Wizard interFace(s) only. Specific items not included under technical support are provided below (Section: Limitations). 3. The initial Omega software application implementation and installation must be performed by an Omega Project Manager. This requirement ensures that telephone support, future software service packs, and major version upgrades can be administered effectively. 4. By paying for support, Client agrees to receive support services from The Omega Group and accepts the terms and limitations of the Customer Support Program as described herein. 5. 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 The following limitations shall apply to Omega's support services: 1. Omega's technical support is limited to unmodified, "off-the-shelf' Omega software technology. Any issues that arise from Client modifying the application's files, configuration, or environment without Omega approval will not be covered under this agreement. 2. Technical support is not a replacement for training. Additional application training is available from Omega at an additional cost. 3. Technical support does not cover configuration changes to existing applications and/or additional development' to the Omega application (i.e. building new profiles, reports, saved queries, etc.). 4. Technical Support only covers issues with Omega software and excludes any issues with 3rd party applications that interFace with Omega software. Exhibit A-Scope of Work Page 7 of 10 5. Technical support does not cover issues that arise from changes/upgrades in the Client'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. 6. The Omega Group is not responsible for maintaining back-up files of the Client's software application. The Omega Group may have copies of the Client's application files stored at Omega's offices (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 a Client's server crashing or other circumstances unrelated to the Omega software, The Omega Group can assist as resources permit for an additional fee, but will not be held financially responsible for reinstalling and reconfiguring the application. 8. The Omega Group'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. The Omega Group's Customer Support Program includes software bug fixes and software enhancements for existing, unmodified applications. The Omega Group will contact the Client to schedute updates to the application as they become available. 10. Omega software is dependent upon specific versions of 3rd party software applications. Upgrades to 3rd party software used to run Omega software will require a new version of Omega software to be installed to remain compatible. Upgrades to Omega software are only provided for products that have not reached the "mature" or "retired" phase of the product lifecycle. Full-version upgrades of Omega software in support of upgrading 3rd party applications are not covered under support and will require additional charges for time and materials. Remote Connectivity 1. Technical Support will be performed through a remote connection. 2. Omega recommends a VPN or Cirtrix's GoToMyPC or GoToAssist for remote connections. Client must provide the necessary remote access details if a VPN is used. 3. Omega customer support is contingent on the Client providing a high speed remote connection. 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 Support@theomegagroup.com. Omega shall respond to all technical support inquiries within twenty- four (24) hours of receiving the request, during normal business hours. Addendum to Omega Maintenance Program The CrimeView Dashboard Application Support Plan is intended to provide product enhancements, bug fixes, and on-going software support for the original, unmodified configuration of any CrimeView Dashboard application. Exhibit A-Scope of Work Page 8 of 10 This support plan includes the following: • Diagnosis of Omega (Dashboard application) software issues' • Resolution of Omega (Dashboard application) software issues2 • Diagnosis of configuration issues3 • Resolution of configuration issues4 • Omega Software Updates o Updates to Omega software functionality (as new product releases become available) o Bug fixes to Omega software for known issues o Version-compatibility upgrades to Omega software5 s Limited Dashboard Designer & Administrator assistances • Access to help & tutorial documentation • Geography Layer Updates o Clients are entitled to two (2) geographic query (filter) layer updates annually' o Clients are entitled to two (2) Operational Layer (geography only) updates annually' o Geography layer updates are by Client request when new data is made available • Saved Query Updates o Clients are entitled to two (2) saved query updates annuallye o Saved Query updates are by Client request when new query values are made available This support plan is NOT intended to provide the following Omega Professional Services: Upon completion of any CrimeView Dashboard application project, the following requests for service will be subject to additional fees: s 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 o Lookup table updates that result in changes to the original CrimeView Dashboard application configuration • Identify/Report Grid field changes • Symbology legend changes • Query layer changes or the addition of new query layers s Re-import of historical data • End-user support9 • 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 CrimeView Dashboard application (or single component of a CrimeView Dashboard application) to a new physical server • Restoring of a CrimeView Dashboard application (or single component of a CrimeView Dashboard application) after a catastrophic event '"Software issues" include technical questions that are directly related to the Omega software application including error messages, unexpected behaviors, etc. "Software issues" do not include training-related questions. 2 Omega will troubleshoot and fix "software issues" that are completely diagnosed to be an issue with the CrimeView Dashboard application under this agreement. Issues that result from conflicts with any other software applications being installed alongside of a CrimeView Dashboard application on the same computer hardware are not covered under this support agreement. The Omega Group will not provide support unless the CrimeView Dashboard application remains in a dedicated environment. This support agreement does not cover the resolution of any issues that may arise with a CrimeView Dashboard application as a result of non-Omega personnel intertering with the configuration and/or operation Exhibit A-Scope of Work Page 9 of 10 of the application. 3"Configuration issues" include questions that are directly related to the settings and configuration of the CrimeView Dashboard application. "Configuration issues" do not include training-related questions. 4 Omega will troubleshoot and fix any mis-configuration of the original CrimeView Dashboard application if it is shown to differ from the Client's original requirements for the application. The original requirements for the appiication must be shown in writing by the Client to have preceded the completion date of the CrimeView Dashboard application project. 5 The Omega Group will develop upgrades to the CrimeView Dashboard application to remain compatible with the latest version of any supporting ESRI software applications. Until a supporting release of the CrimeView Dashboard application is completed by the Omega Group, the version of ESRI software must not be changed from the originally deployed version. If requested by the Client, upgrades will be pertormed by The Omega Group for an additional charge for time and materials. Migrations to a newer Omega software product are not covered. Newer Omega software products may be purchased from The Omega Group. 6 Dashboard Designer, Administrator & End-User training can be purchased for an additional cost. � 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 The Client'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 Client Dashboard Designer or Administrator to contact The Omega Group for technical support where appropriate. Exhibit A-Scope of Work Page 10 of 10 Data Schema Addendum The following data fields will be included within the standard offering of the CrimeView Dashboard. If these fields are not readily available within the RMS/CAD databases, this information will not be included in the Dashboard. No substitutions will be made for other available fieids unless identified in the sales process. Incidents 2 CASE NUMBER 3 CRIME CATEG�RY 4 NIBRS OR UCR CAS E_N U M YES CU LEGEND YES' YES YES YfS CRIME ' DESC YES YES ' YES YES 6 ADDRESS CV ADDRESS YES 7 ii APT APT YES 8 AREA 1* YES YES YES 9 AREA 2* YES' YES YES 10 AREA 3* YES YES YES 12 ' COMMON NAME COMMON_NAME YES 14 FROM DATE FROM bATE YES 16 REPORT DATE 18 CASE STATUS TO_DATE YES' REPORT_DATE YES SHIFT ' YES' YES YES YES CASE STATUS DESC' YES YES YES YES 20' PREMISE PREMISE_DESC YES YES YES YES 21 WEAPON WEAPON_DESC YES' YES YES YES 22 DOMESTIC VIOL DV YES YES YES YES 23 GANG RELATED 24 ALCOHOL RELATED OL YES 'YES YES 26 PRIMARY KEY PRIMARY_KEY YES *Each Area fieid may include one ofthe following: Beat, District, Precinct, Sector, City, Zip Code, etc. Calls for Service 2 CALL NUMBER CAL� NUM YES Hosting Agreement - Omega and City of Fort Worth 3 CALL TYPE CALL 7YPf YES 'YES YES YES 4 CALLDESC CALL DESC YES YES `YES 5' CA�L DATE CALL DATE YES 6 ADDRESS CV ADDRESS YES 7 APT APT YES 8 COMMON NAME -`COMMON NAME YES 10 AREA 2* YES 12 ,4REA 4* YES 14 DISPOSITION ` 15 CALL SOURCE I 16 SHIFT 17 PRIMARY UNIT 18 PRIMARY OFFICER � YES SHIFT YES YES YES YES PRIM 11NiT YES OFFICER YES REMARKS YES 20 PRIMARY KEY PRIMARY_KEY YES *Each Area field may include one of the following: Beat, District, Precinct, Sector, City, Zip Code, etc. 2 ' PERSON ID DISPO DESC YES YES ' PERSON_ID `ALIAS NAME ALIAS YES Parolees 15 SEX 16 RACE HOME ADDRESS AREA 1* 12 PAR BEGIN DATE 13 PAR END'DATE 14 PAR STATUS 18 AGE CV_ADDRESS ' YES `YES YES PAROLE_DATE YES PAR STATUS DESC YES YES YES YES SEX YES YES YES YES RACE DESC YES YES YES YES Y ETHNICITY YES' YES YES YES AGE `YES YES YES YES Hosting Agreement - Omega and City of Fort Worth 20 HEIGHT 22 EYES 24 SCARS MARKS TATS DOB YES HEIGHT YES WEIGHI' YES EYES : YES HAIR YES SMT YES 26 PRIMARY OFFICER OFFICER YES 27 MUG SHOT MUG SNOT ' YES 28 PRIMARY KEY PRIMARY 'KEY YES *Each Area field may include one of the following: Beat, District, Precinct, Sector, City, Zip Code, etc. Recovered Vehicies 2 CASE NUMBER GASE NUM YES 4 RECOV DATE 'REC DATE YES 6 TO DATE TO DATE YES 8 APT APT YES 9 COMMON NAME C�MON'_NAME YES 10 PREMISE PREMISE DESC YES ' YES YES YES 11' AREA 1* YES YES YES 12 AREA 2* YES YES YES 13' AREA 3* ! YES YES YfS 14 AREA 4* YES YES YES 16 VEH STATUS VEH_STATUS DESC ` YES `YES 18 VEHICLE TYPE VEH_T 20 VEHICLE MAKE ' V YES 22 VEN COLOR VEH COLOR YES 24 VEH LIC PLATE NO 25' VEH l.IC PL�iTE ST �'ES YES fES YES fES YES VEH_LICENSE YES Hosting Agreement - Omega and City of Fort Worth E_DESC YES YES 26 VEHICLE VIN VEH VIN YES YES 'YfS 28 PRIMARY OFFICER OFFICER YES 29 PRIMARY KEY PRIMARY_KEY " YES *Each Area field may include one of the following: Beat, District, Precinct, Sector, City, Zip Code, etc. Arrests (Arrest �ocation) 2 ARR NUMBER ARREST NUM YES 3' CASE NUMBER CASE_NUM YES 4 PERSON NAME FULL NAME ' YES 5 AL1AS NAME AUAS '' YES STATUTE OR � � CHARGE .• �. 10 APT CHARGE DESC YES YES YES YES CRIMf DESC ' YES YES YES YES ARR DATE YES ARR ADDRESS YES APT YES 12 AREA 2* YES 14 AREA 4* YES 15 ARR TYPE l�RR_TYPE_DESC YES 16 SEX SEX YES YES 5 5 5 � 18 ETHNICITY ETHNICITY YES YES YES YES 19 AG E AG E YES ' YES ' YES YES 20 DOB DOB YES 21 HEIGHT HfiGNT YES 22 WEIGHT WEIGHT YES 23 NA1R HAIR YES 24 fYES EYES YES 26 DRIVERS �ICENSE LICENSE' YES 27 HOME LOCATION HOME_ADDRESS YES 28 PRIM ARR OFFICER OFFICER YES YES Hosting Agreement - Omega and City of Fort Worth 30 PRIMARY KEY PRIMARY KEY YES *Each Area field may include one of the following: Beat, District, Precinct, Sector, City, Zip Code, etc. Arrests (Home Location) 1 A6ENCY' AGENCY YES YES YfS 2 ARREST NUMBER ARREST` NUM YES 3 CASE NUMBER CASE NUM YES 4 PERSON NAME FULL NAME YES 5" ALIAS NAME ALIAS YES STATUTE OR 6 CHAR6E CHARGE DESC> YES YES YES YES 8 ARR DATE ARR DATE YES 9 HOME LOCATION HOME ADDRESS YES 10 APT APT YES 12 AREA 2* YES Y 13 ARfA 3* YES Y 14 AREA 4* YES Y 15 ARR TYPE ARR TYPE DESC YES ' YES ' Y 16 SEX SEX YES YES Y YES S YES S YES S YES 17 RACE RACf DESC YES YES YES YES 18 ETHNICITY fTHNICITY YES YES YES YES 19 AGE AGE YES ' YfS ' YES YES 20 ` DOB DOB YES 22 WEIGHT WEIGHT YES 24 EYES 'EYES YES 26 DRIVERS I.ICENSE LICENSE YES 27 ARR LOCATION ARR ADDRfSS ' YES 28 PRIM ARR OFFICER OFFICER YES 30 PRIMARY KEY PRIMARY_KEY YES *Each Area field may include one of the following: Beat, District, Precinct, Sector, City, Zip Code, etc. Hosting Agreement - Omega and City of Fort Worth Accidents 4 ACC DATE ACCIDENT DATE YES 5 ADDRESS CV ADDRESS YfS 6 APT APT YES 7 IIUTERSEGTION CV INTERSECTION YES 8 AREA 1* YES YES YES 9 AREA 2* YES YES YES 10 AREA 3* YES YES YES 11 AREA 4* YES YfS YES 12 CAUSE DESC CAUSE DESC ` YES YES YES YES 13 INIURY INIURY YES YES ! YES YES 14 FATA�ITY FATALITY YES YES YES YES 15 16 ALCOHOLRELATED 18 HIT & RUN 19 WEATHER 20 TRAFFIC GONTROL 22 PRIMARY KEY ALCOHOL_RELATED HIT RUN TRAFFIC_CONTROL PRIMARY_KEY YES YES 'YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES *Each Area field may include one of the following: Beat, District, Precinct, Sector, City, Zip Code, etc. Hosting Agreement - Omega and City of Fort Worth 2 ACC NUM AGCIDENT NUM YES Exhibit B Cost Summary CrimeView Dashboard Hosted Deployment Professional Service Package o Incidents (ARS) o Accident (Report Beam) o Arrest (RMS) o Arrest Home Location (RMS) o Parolee (in house SQL database) o Recovered Vehicle (RMS) � 0 • Login configuration • Training o Web-based training for Administrators/Designers o On-site training for Standard and Shared Users o Travel Total Implementation: • Data connection configuration for seven (7) data connections o Calls for Service (CAD) Application configuration and deployment Briefing Book configuration $11,655.00 lncluded lncluded $2,460.00 $2,460.00 $4,440.00 $4,440.00 lncluded lncluded lncluded Included $5,000.00 Included Included $2,500.00 $32,955.00 Annual Subscription � Briefing Books: Included Included o Executive Briefing Book o Roll Call Briefing Book � Logins: o One (1) Shared User logins o One (1) Administrator User login o Unlimited Designer User Logins o Unlimited Standard User Logins • Data Connection/Storage o Seven (7) data connections ■ Calls for Service (CAD) ■ Incidents (ARS) ■ Accident (Report Beam) ■ Arrest (RMS) ■ Arrest Home Location (RMS) ■ Parolee (In House SQL Database) ■ Recovered Vehicle (RMS) o Three (3) years of data Annual Subscription Fee: lncluded Included Included lncluded Included Included Included lncluded Included lncluded Included Included Included lncluded $15,000.00� * For each Renewal Term, the annual subscription fee may increase by an amount not to exceed 3% above the fee from the preceding Term. Omega shall notify Client in writing at least sixty (60) days prior to the end of the then- current Term if the subscription fee will be increasing in the next Renewal Term. Exhibit B Cost Summary Page 1 of 2 Payment Schedule In consideration of the services to be performed and delivered, Omega shall be entitled to compensation in the total amount of $47,955.00. The payment schedule consists of three (3) payments, which are due as follows: Ob�ective Fee Terms Set up/Training/Travel. 60% Payment due after kick-off of im lementation costs. $19,773.00 meetin net 30 Payment after invoice Initial configuration, data received (net 30) Completion inputs are set, and ready to of Task 4 and Client test. 40% of implementation acceptance, CrimeView costs. $13,182.00 Dashboard deplo ment. Final payment after invoice Testing, quality assurance, received (net 30) Completion etc. of task 6, Final Application 100% of Subscription Fees $15,000.00 review. Login Description The CrimeView Dashboard is a subscription based service with four types of user logins with the following permissions: �� �� � Feature Shared User Nan�e ar�d E�gEn Vie��+�tssigneci BrEefiing Books liievd C]lc�eries tan E?�m�nd �I�e�nt �I�r�s Acces� ta Anal�sis llriad� �:reaie �uerEes-On-�er�-�and �reate Aler�s C�eat�e B�ie�fin� eoa�s, Qashbaarcl �i�ge#s Greate liser Ro�es and �4c�ount �agin x x x x x �� ��a �'�� x x x x x ��� ��fi x x. x x x x x_ x x x x � x x x Exhibit B Cost Summary Page 2 of 2