Loading...
HomeMy WebLinkAboutContracts & Agreements_35-12_CCv0001.pdf AFORk w in GROUP CRI M E M) Dashboard Hosting Agreement March 6, 2012 5160 Carroll Canyon Road I Suite 1100 1 Sar Diego, C 92121 x'1858.450.2590 F11858AS0.0239 Elomeqa@theomeqagroup,cc CRI KXEVIE8�Dashboard March 6,2012 Hosting Agreement This Hosting Agreement ("Agreement") is entered into this 6"` day of March, 2012, ("Effective Date"), by and between The City of Redlands ("Client"), with its principal place of business located at35 Cajon St, Redlands, CA 92373, and The Omega Group, Inc. (iQmnega"), aCalifornia Corporation, with its principal place of business located at 5160 Carroll Canyon Road, Sam Diego, CA 92121. The Client and Omega are sometimes individually referred to herein as a "Party" and,together, as the "Parties." 1. Services Omega shall provide the services fully described in the quote for the CrinneVievv Dashboard application, dated January 17, 2012, , which is attached hereto as Exhibit "A~" and the following other attached exhibits (collectively the "Exhibits") which are all incorporated in full herein by reference. Exhibit B: [rinneVievvDashboard Task Order Exhibit C: [rinneViavv Dashboard Requirements Exhibit D: Omega Dashboard Hardware Exhibit E: Omega Dashboard Training Exhibit F: Omega Data Security Omega sha|l retain the right to perform work for others during the Term of this Agreement. 1.1 Purpose. This Agreement sets forth the terms and conditions under which Omega agrees to host software and provide all other services, data import / export, monitoring, support, backup, technology upgrades, and training necessary for Client's productive use of such software /the "Services"), as further set forth in Exhibit "A." 1.1.1 Authorized Users. Unless otherwise limited inthe Exhibits, Client and any Ofits employees that have aneed touse the software for the benefit nf Client shall have the right 10operate and use the same. Asapart ofthe Services, Omega shall be responsible for setting up identification and password use. 1.2 Control OfServices. The Parties acknowledge and agree that Client shall have no right to control the manner, means, or method by which []noeg@ performs the Services c8||Bd for bythis Agreement. Rather, Client shall be entitled only to direct Omega with respect to the elements of the Services to be performed by Omega and the results to be derived by Client. Client Can review and assess the performance of Omega's Services for the limited purposes 0fassuring that the CR|k8EV|EW ,Dashboard March 6,2012 Services have been performed and confirming that such results were satisfactory. 1.3 Backup and Recovery Of Client Data. As a part of the Services, Omega is responsible for maintaining a contemporaneous backup of Client Data, for an orderly and timely recovery of such data in the event that the Services may be interrupted. Additionally, Omega shall store a backup of Client Data no |85s than daily; however Omega will not be responsible for Client Data lost after the most current backup and before the next scheduled backup. 1.4 Changes inScope ofServices. Client may, upon written notice, request increases or decreases to the scope of the Services pursuant to Exhibit "A." if Client requests changes in the scope, Client shall notify Omega, and Omega shall notify Client whether or not the change is feasible and any associated costs for the change. Any change in the scope of Services shall be made by amendment to this Agreement, which will be executed by the Parties. 2. Term and Termination. 3.1 Term. The term (the "Initial Term") of this Agreement shall commence on the Effective Date of this Agreement and continue for 12 months thereafter. Following the Initial Term, the Services shall automatically renew for a successive one year term (the "Renewal Term") unless Client provides Omega with written notice of termination; provided, however, that: /a\ such notice be given no fewer than sixty (60) calendar days prior to the last day of the Initial Term; and, (b) any such termination shall be effective as of the date that would have been the first day of the Renewal Term. "Term" shall collectively mean and include the Agreement terms represented by the Initial Term and the Renewal Term. 2.2 Termination for Cause. If either Party materially breaches any ofits 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.3 Payments upon Termination. Upon the expiration or termination Of this Agreement for any reason, Client shall pay to (]rn8g3 all undisputed amounts due and payable hereunder. 2.4 Return of Materials. Upon expiration or earlier termination of this Agreement, each Party shall: /a\ promptly return to the other Party, orcertify the destruction CR|K8EV|EMDmsF,bnand March 6,2012 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 atimely and efficient manner. This Section 2 shall survive the termination ofthis Agreement. 3. Non-Disclosure of Confidential Information The Parties acknowledge that each Party may be exposed tooracquire communication or data of the other Party that is confidential, privileged communication not intended to bedisclosed tothird parties. 3.1 Meaning of Confidential Information. For the purposes of this Agreement, the term "Confidential Information" shall mean all information and documentation of Party that: (a) has been marked "confidential" or with words of similar meaning, at the time of disclosure by such entity; and (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. 4. Proprietary Rights. 4.1 Pre-existing Materials. Client acknowledges that, inthe course mfperforming the Services, Omega may use software and related processes, instructions, methods, and techniques that have been previously developed by Omega (collectively, the "Pre-existing Materials") and that same shall remain the sole and exclusive property ofOmega. 4.2 Data of Client. Client's information, Qrany derivatives thereof, contained in any {}nnGga repository (the "Client Dgta," which shall also be known and treated by Omega as Confidential Information) shall be and remain the sole and exclusive property mfClient. Orn2gJ is provided a license to Client Data hereunder for the sole and exclusive purpose ofproviding the Services, including license to store, record, transmit, maintain, and display Client Data only to the extent necessary inthe provisioning ofthe Services. 4.3 The provisions 0fthis Section 4shall survive the termination ofthis Agreement. 5. Information Security. CRIMEVIEW@ Dashboard March 6,2012 Omega provides an information security environment to protect Client's information assets, as set forth in Exhibit F (Omega Data Security). 5.1 Undertaking by Omega. Without limiting Omega's obligation of confidentiality as further described herein, Omega shall be responsible for establishing and maintaining an information security environment that is designed to: (i) ensure the security and confidentiality of the Protected Data; (ii) protect against any anticipated threats or hazards to the security or integrity of the Protected Data; (iii) protect against unauthorized access to or use of the Protected Data; (iv) ensure the proper disposal of Protected Data. 6. Fees and Expenses. Client shall be responsible for and shall pay to Omega the fees as further described in Exhibit "A," subject to the terms and conditions contained therein. Any sum due Omega for Services performed for which payment is not otherwise specified shall be due and payable thirty (30) days from the date of Client's receipt of an invoice from Omega. 6.1 Billing Procedures. Unless otherwise provided in Exhibit "A," Omega shall bill to Client the sums due pursuant to the quote 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 Brenda Boon (bboon a@redlandspolice.org), Administrative Analyst, 30 Cajon St, PO Box 1025, Redlands, CA 92373. 6.2 Late Payments. Payments made by Client later than thirty (30) days from the date of Client's receipt of an invoice are subject to a five (5%) penalty increase in fees. 6.3 Fees. In consideration of the Services to be performed, Omega shall be entitled to compensation in the total amount of $13,400.00. The payment schedule consists of two payments and is due as follows: • $6,100.00 of the total amount due fourteen (14) business days of the Effective Date of this Agreement . • $7,300.00 of the total amount due thirty(30) days after completion of the Services. 6.4 Additional Work. The fees and charges for any follow-on or additional work not described in Exhibit "A" shall be performed at Omega's current rates. Any 5f = CRIMEVIEWs Dashboard March 6,2012 additional work desired by Client shall be evidenced by a written amendement to this Agreement, executed by the Parties. 7. Relationship between ©mega and Client 7.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©mega or any employee or agent of Omega. 7.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 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. 7.3 Confidentiality. The Parties agree not to disclose to any third party any proprietary information disclosed to it by the other Party without the prior written consent of such disclosing Party. The Parties further agree to take the same care with the proprietary information 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 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; or (4) information approved for the use and disclosure of either Party or its personnel without restriction. 7.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 negligent acts or omissions, or willful misconduct, in Omega's performance of this Agreement. Client agrees to give Omega prompt notice of any such claim, demand, or action and shall, to the extent Client is not adversely affected, reasonably cooperate with Omega in defense and settlement of said claim, demand, or action. 6 1 P a _ e CRI MEVIEM-Dashboard march 6,2012 7.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. 7.6 LIMITATION OF LIABILITY. OMEGA SHALL NOT BE LIABLE TO CLIENT FOR ANY FAILURE 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. THIS LIMITATION UPON DAMAGES AND CLAIMS IS INTENDED TO APPLY WITHOUT REGARD TO WHETHER OTHER PROVISIONS OF THIS AGREEMENT HAVE BEEN BREACHED OR HAVE PROVEN INEFFECTIVE. 8. Miscellaneous 8.1 Governing Law. This Agreement shall be governed and construed in all respects in accordance with the laws of the State of California as they apply to a contract executed, delivered, and performed solely in such State. 8.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. Client shall be named as an additional insured, and such insurance shall be primary with respect to Client and non-contributing to any insurance or self-insurance maintained by Client. Upon the request of Client, Omega shall provide Client with evidence satisfactory to Client of such insurance, including certification and endorsements, prior to performing work at Client's premises. 8.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. 8.4 Notices. Any notices to be given hereunder by either Party to the other may be effected either by email, personal delivery in writing or by first class mail. Mailed 7 1§ .t _, CR|MEVEW@�,Dashboard March 6,201 notices ah3U be addressed as listed be|Ovv 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 bedeemed communicated a5Oftwo days after mailing. Redlands Police Department The Omega Group Chief ofPolice 5I6OCarroll Canyon Road, Suite 1OO 3OCajon 5t San Diego, [A 92121 POBox lO25 Redlands CA92373 Attn: Account Payable 8.5 Entire Agreement of the Parties. This Agreement supersedes any and all agreements, either oral or written, between the Parties with respect to the rendering ofthe Services byOmega 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 agreements, orally or otherwise, have been made by any Party, or anyone acting on behalf ofany 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. 8.6 Severability. |fany ofthe provisions ofthis Agreement are ruled illegal, invalid or unenforceable by a court of competent jurisdiction under any applicable statute or rule of law, they shall, tothat extent, be deemed omitted, and the remainder ofthis Agreement shall continue tobeinfull force and effect. 8.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. GRIMEVIEAG Dashboard March 6,2012 IN WITNESS WHEREOF, the parties have caused this Agreement to be executed by their duly authorized representatives as set forth below. For: The Omega Group For: City of Redlands By: By: z Milan Mueller Pete Aguilar, Mayor President, The Omega Group Attest: By: Sam Irwin, City Cleric 9 n THE OMEGA GROUP CRIMEVIEW* 1 &terwz��e Redlands Police Department Exhibit A: Price Proposal March 6, 2012 S lArl r € Prwn• FZr,;%r4I qijitp 100 Dipnn ('A 99191I ASP, k � AI; r trt=,r ram CRIMEVIEW C & March 6,2012 INTRODUCTION CRIMEVIEW ENTERPRISE SOLUTION FOR THE REDLANDS POLICE DEPARTMENT Providing a Foundation for Real-Time, Proactive, Information-led Policing TARGET: TO DEPLOY THE CRIMEVIEW ENTERPRISE SOLUTION BASED ON ESRI ARCGIS 10 TECHNOLOGIES • Installation and configuration of CrimeView Enterprise package to include: o CrimeView Dashboard with Executive Briefing Book o Two (2) Shared User Logins and One (1) Administrator Login, with additional briefing books c Three (3)years of historical data from RMS and CAD o Onsite Administrator and End User Train-the-Trainer Session FOUNDATION TECHNOLOGY Severe budget cuts threaten the ability of police departments across the country to provide intelligence based policing services and to the communities they serve. This new reality demands a focus on enhanced patrol strategies with less resources and cost. CrimeView Enterprise, from The Omega Group, directly addresses this mandate for maximum effectiveness & efficiency by providing a better way to integrate crime analysis, reporting and mapping with patrol in an actionable way to help deliver successful policing outcomes for fewer dollars. CrimeView Enterprise brings together enhanced data services, crime analytics, crime mapping and high visualization technologies into a single solution. Serving department needs for decision support, performance management and electronic briefings, our dashboard provides agency-customizable, easily accessible and visually relevant displays of the most important information needed to achieve organizational objectives and address specific crime priorities. c.im.►ne,. I wwon. ! r���,.we. import Wisa+A P�hda+rd � McGrk � hwAba.wd tr4mrM+pp��em CRIMEVIEW• l firkrpisr 3 NEAR' �A4Alir CRIMEYiE1N``I Arm> aon/ CRIMEMAPRM... CRIMEVIiE'W"AWAIv 2 P a g c CRIMEVIEW• I &tetp ** March 5,2012 Proposed Applications CrimeView Dashboard CrimeView Dashboard brings together enhanced data services, crime analytics, crime mapping and high visualization dashboard technologies into a single solution. Serving department needs for decision support, performance management and electronic briefings, our dashboard provides agency- customizable, easily accessible and visually relevant displays of the most important information needed to achieve organizational objectives and address specific crime priorities. Capabilities include: • Comprehensive ability to inform and optimize patrol-based strategies. • Handles a broad array of data sets including: calls for service, crime reports, field interviews, warrants, citations, arrests, tips, SARs, pawn shop data and persons-of-interest such as parolees, probationers, gang members and sex offenders. • Dashboard data and features based on role, organizational unit, geography, crime priority or specific intervention. • Ready to use 'Briefing Book' templates available for Executive, Roll Call, Directed Patrol, DDACTS, Border Crime Suppression, Special Event Planning, COMPSTAT. • Flexibility to customize the content and layout of the dashboard 'Briefing Books' and pages due to changing priorities. • Supports pattern recognition, suspect identification and spatial/ temporal optimization activities for patrol officers. • Leverage existing GIS investments or low/no-cost base map options. • Real-time policing with crime analysis and mapping products that are updated in near real-time without human intervention. • Supports establishment of agency-wide crime mapping& analysis platform. - Maws •a f r i 3Page CRIMEVIEW,l &terfirise March 6,2012 Pricing Totals CrimeView Dashboard Hosted Deployment CrimeView Dashboard Executive Briefing Book-Professional Service Package $5,000.00 • Data connection configuration for six(6)data connections • Executive Briefing Book setup CrimeView Dashboard Annual Module Subscription $&,000.00 • Includes.Executive Briefing Book • Two(2)Shared user login • One(1)Administrator user login • Data subscription for six(6)data connections CrimeView Dashboard Training Package $2,000.00 • Onsite Administrator and End-user Training Program o Train-the-Trainer Session o Travel Total Year One: $15;000.00 Total Year Two: $9,000.80 Enterprise Discount(20%): $1,600.00** Adjusted Year One: $13,400.00 Adjusted Year Two: $6,400.00 Subscription and Maintenance Fees Total year two subscription fees represent the ongoing cost of maintaining the CrimeView Dashboard, application. Fee payment will commence upon final acceptance of the operational system and cover the first twelve months of use of application. The first year of subscription fees are included in the total year one casts. **CrimeView Desktop and Dashboard 'Enterprise' Discount.The Enterprise Discount applies to subscription costs only.At any time should the CrimeView Enterprise package be discontinued, and CrimeView Dashboard application remains in use,the Enterprise discount will be cancelled and the application annual fees will revert back to current rate. THE OMEGA GROUP v-I`A'Vv, heornegaq CRIMEVIEW I Nshboard Exhibit B: Task Order Last Edited: March 6, 2012 5160 Carroh Canvon Road I Suite 100 San Dew, CA 92121 T 1858,4%2590 F 1185&450.0239 Eibmeca0theome-aaaroumcom � �EVIEW � � � Last Edited:March 6,2012 Exhibit B Professional Services and Training 1. Project Planning/Management 1.1. Software and database requirements 1.1.1. Review deliverables for client 1.1.1.1. Omega client software:Omega Import Wizard 1.1.1.2. Omega server application: Omega Dashboard 1.1.2. Review deliverables by Client 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 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. Client will install ArcGIS on import workstation 2.2. Client will install Import Wizard on import server or workstation 2.2.1. Omega will extract sample datasets for application development 2.3. Omega will update import profile for CAD/RMS data extraction 2.3.1. Omega will create SQL Statement 2.3.2. Omega will configure data processing steps 2.3.3. Omega will configure geocoding process, review the sample data's geocoding rates and provide recommendations 2.3.4. Omega will configure output data sets and automation 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 use the Sing geocoding service unless the client requests that their own spatial reference data be used in which case Omega will create the address locator 3.4. Omega will configure up to ten (10) geographic query layers 2 11 _ Last Edited:March 6,2012 Dashboard Exhibit B 3.5. Omega can configure up to five (5) operational layers; if the map caches are hosted on the same on-premise server where the Dashboard is to be installed, Omega will configure up to three (3) operational layers 3.6. Omega will create up to five hundred (500) total saved query pick list items per query layer 3.7. Omega will use Bing maps for the application's background layers or can possibly integrate with a client's existing map caches (hosted on a different server at the client's site) 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-Case data 3.8.1.1.1. One (1) Executive Briefing Book with up to twenty-five (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 3.8.2. Pages 3.8.2.1. 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. 4. CrimeView Dashboard Deployment 4.1. Omega will deploy the CrimeView Dashboard application 4.2. Omega will configure data import profiles for data transfer to the CrimeView Dashboard 4.3. 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.4. Omega will schedule automated data import/extractor process 4.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 3 11, Last Edited:March 6,2012 C RIMEVIEWIlt21' Exhibit B 5. CrimeView Dashboard Application Training 5.1. Omega will provide up to six (6) hours of remote 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 onsite training on functionality features for up to ten (10) trainees per session 5.2.1. The CrimeView Dashboard End User Tutorial PDF document will be e-mailed to the End User trainees following training 6. Final Application Review 6.1. Following on-site 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: 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 CrimeMannin .com CrimeMapping.com may be deployed prior to CrimeView Dashboard. 7. CrimeMapping.com Project Planning 7.1. Identify data source for incident data 7.2. Identify data fields from incident reports to be displayed in CrimeMapping.com 8. CrimeMapping Development and Deployment 8.1. Create CrimeMapping(CM) Layer Output 8.2. Set up Omega Extractor- Server Preparation 8.3. Set up Omega Extractor- Client Installation 8.4. Set up Omega Extractor—Automation (Web Service) 8.5. Verify CrimeMapping.com data returns anticipated results (records) in Staging area if needed 8.6. Launch CrimeMapping.com live to the public 4I THE OMEGA GROUP CRIMEVIEW ' l Dashboard Exhibit C: Project Requirements Last Edited: March 6, 2012 5160 Carr;l Canyon Road I Suite 1001 San Diego, CA 92121 T 1858.450.2590 F11858,450.0239 E I omega0theome-9 ag rou p co m ^ ExhibitC CRUMEVIEWiDamhboa,4 Last Edited:March 6,2012 &»��U���� ���KI��V������� ~ ..~x~.~~ REQUIREMENTS Software Specifications For [rirn8Vieyv Dashboard the fO[|Ovxing software may be required by the client for Omega-Hosted and OnPremise deployments: ESRksoftwame Omega-Hosted On Premise * ArcG|S Server Standard Enterprise,version lO No Yes � ArcEditor,version IU No Yes ° ArcG|S(ArcVievv), version 1O Yes No Database ° Microsoft SQL Server 2OOO, 2Processors No Yes Incident Data Specifications CrimoeVievv Dashboard automates the import of source data via an application called the Import Wizard. Each CrirneVievx Dashboard dataset (layer) is imported daily via Import Wizard profiles (licensed individually). The profile license contains configuration information for extracting data from an RK85 (via a SQL Statement), gencoding, data processing, & subsequent|ymutputs/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 o result, there will be one "dot" on the map per record in the [rinneViexvDashboard dataset. The maximum number ofrecords returned on a Dashboard widget mrquery is5,O00records CAD and RMS Data The following data fields will be included within the standard offering of the CrirneVievv 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 fields. CAD—Incident orCalls for Service l. Primary Key Z. Agency(for mu|tijurisdicbona| agencies) I Call# 4. [aUDate/Tinne S. Address(including Apartment, City, Zip code) 6. Common Name 7. 8eat/ReportingArea 8. District 9. Call Description 10. Call Source 11. Call Type 12. Disposition 13. Officer Name Exhibit C C R I M E V I E W ; Dashboard Last Edited: March 6,2012 14. Primary Unit 15. Priority 16. Shift RMS— Incident or Offense or Crime 1. Primary Key 2. Agency(for multijurisdictional agencies) 3. Case# 4. Report Date/Time 5. From Date/Time 6. To Date/Time 7. Address (including Apartment, City, Zip code) 8. Common Name 9. Premise Type 10. Beat/Reporting Area 11. District 12, Statute 13, UCR/NIBRS Code 14. Case Status 15. Clearance/Disposition 16. Weapon 17. Domestic Violence 18. Gang Related 19. Officer Name 20, Shift Figure 1 —Report Grid The fields listed above will be used to display data within the Dashboard's report grid 3Pa e CRIMEVIEW Dashboard Exhibit Last Edited: March 6,20122 Figure 2—Report(ID) The fields listed above will be used to display data within the Dashboard's report ID � cAse NUP+�ex :v1a-a7oa7�so ADDRESS Sl WA4.H2NG7ON GLvP AVT { ZIP Coot STATUTE COPE At 7 PC M STATUTE DESC DRAWING 011 f=H 151 TING WEAPON IN A RVPE OR THR[ATENING MANNER INC TVYE CODE 437PC ORANoiSH Wf APON INC TYPF OESC BRANOIS"WEAPON Q. 11 GANG ITEIATED J WSPO517109d ILMID CASE STATIIS cLOSEP - ..� 3R1aGt RRCM►—T—._ -_ __. _.�- Saved Queries (Pick list) The CrimeView Dashboard will have the following saved queries configured within the application, provided that the source fields are available and populated within the CAD/RMS databases: CAD — Incident or Calls for Service 1. Agency(for multi-jurisdictional agencies) 2. Call Source 3. Call Type 4. Disposition 5. Priority 6. Shift RMS— Incident or Offense or Crime 1. Agency (for multi-jurisdictional agencies) 2. Crime Query Type 3. Statute 4. UCR/NIBRS code 5. Case Status 6. Clearance/Disposition 7. Domestic Violence 8. Gang Related 9. Premise Type 10, Shift 11. Weapon 4Page Exhibit C CRIMEVIEW 1 Dashboard Last Edited: March 6,2012 Figure 3—Saved Queries The queries listed above will be available for use within the Dashboard. �u 'ptau , e I4I11T •-• 'b(rYCN i iMrth tYW 4lwnbwort OU"lWnDOnM YmfskM y qegrpM 79a�1rm AtY - ,;03640 FtciGkta-►A.&at I(rperublc I ,:430Y1 MvMeU-iA_Nd Otpi+ssOb MIl#R . ' - =Olin ud4lrtib A.4-tEywbbte ws/7f.w s+<ar•aca+s wn r 1Nxt4mil/1f3QEi .:011tl 4KjdbRY-Fnlc.i i MO 4wac 7/1 V 24ti ;O1T3i/tteMs Tn�wy/tX i R¢n TLY TYrw[41AM :83712#c iM.at^t4Ht1' Oay!of WMY:im6y.MaWT.taYmaT. i 1+dtrNaY,fir.�,1w.abY ..�0{il i llbe MamH-Empbyte rsir xvVw nwmDbre aaegrl o .,. - t GIS Data Specifications Boundary and Landmark Features: The client 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 • Aerial imagery (if deliverables include custom map caches) Geocoding Reference Data The client 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 The CrimeView 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. The following alternatives for map caches are available for Omega-Hosted and On Premise deployments: Map Caches Omega-Hosted On Premise 1) Bing Maps Yes Yes - Both street and air photo for the application's background layers. 5 1 P a g e C RIME € A i r° ' Exhibit C Last Edited:March 6,2012 2) Client map caches No Yes -The following criteria must be met if the client 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. 3) Omega-built map cache(s) No Yes -Additional fees apply a. If Omega is to build a map cache containing aerial raster data, the client must ensure that a spatial reference has been defined on all image files b. If the application will be hosted, source aerial raster data must not exceed 5 GB of disk space *Bing Maps are offered free of charge with the purchase of ESRI ArcGIS Server software. Omega does not guarantee the offer. All updates to Bing Maps including both data availability and price are not administered by The Omega Group.The Omega Group will do it's best to notify the client in advance of any changes to the offer.Any changes in price for Bing Maps will be passed on to the client either as part of annual maintenance or invoiced separately. Application Specifications Interactive Functionality Reporting capabilities include dynamic mapping, sorting, grouping, and charting. Symbology All applications include standard Omega symbology for each data source. Operational Layers 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 6j ' C RIME Exhibit C Last Edited:March 6,2012 Saved queries are a set of pre-defined data queries organized in folders. Data queries are based on data available from the RMS or CAD 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. 7111 _ v H R GROUP OMEGA DASHBOARD Powered by ArcGIS Server Exhibit D: Hardware Requirements Omega Cloud Hosting 160 Carroll Canyon Road I Suite 100 1 San Diego, CA 92121 71858.45 .2590 F 1858.4%0239 EI rn g t e meg group o OMEGA DASHBORRO Powered by ArcGIS Server Exhibit D Omega Dashboard Module Specifications Server Import Server* • Quad-Core Intel Xeon® processor • 6 GB RAM m RAID 1 or RAID 5 disk configuration using SAS 15K RPM 146GB disks or better i Gigabit Ethernet network card Workstation End-user Workstations Minimum user machine specifications for workstations accessing Omega Dashboard: • 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) Windows Accounts A local administrator account is required for Omega 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. 2 jP a z e OMEGA DASHBOARD Powered by ArcGIS Server Exhibit D Configuration Diagram The diagram below depicts the data flow from the law Enforcement Databases to the Omega Dashboard application. Gent Network o►fga H"ting Envltonrt Bricfirlp 0 Internet Data source CAD WA a RMS im%Kwt Serer •.0.m_Ed400 lO t,nptxx y:a na �erxba Emxior O A - Orhtr Sources Server[Oot orrai i �Str"r NOS R2 � .oecSDE Str+d-Fnv f0 Remote Connectivity Determine Method of Remote Access • Establishing remote connection to the server(s) o Data collection, installation and technical support will be performed through remote connection o Omega recommends VPN or Citrix's GoToMyPC for remote connections ■ Client must provide the necessary remote access details • If the client is unable to provide high speed remote access, a fee will be incurred based on the additional time required for data collection and application development 3 Page THE OMEGR GROUP CRIMEVIEIN I Dashboard Exhibit E: Training Proposal March G, 2012 5160 Carroll Canyon Road I Suite 100 1 San Dieqo, CA 92121 T i S8A50 2 1858,450.0239 E Iomeqa*theomeciaqrour,.c, Exhibit E CRIME Dashboard March 6,2012 TRAINING An Omega instructor-led course provides students with the knowledge and skills that are needed to operate manage and support the Omega modules. Each course offers a significant amount of hands-on practices, 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. Omega Dashboard Training We believe there's more to training than following a scripted slide show. Our Omega Dashboard training session is highly personalized and interactive covering capabilities under each of the three (3) types of user groups including shared users, designers and system administrators as well as a complete review of all features and functionalities of the Omega Dashboard. This comprehensive training package is broken down into 2 components: Module Administration The Administration training discusses the set-up, deployment, security configuration and performance tuning of the server-side environment supporting the Omega Dashboard module. This administrative training package includes: • Configuring the Omega Dashboard Environment • Connectivity to internal and external data sources • Adding and deleting users • Deploying Widgets • Setting Up and Configuring Security and Permissions • Performance Tuning End User Training The end user Omega Dashboard training package,trains your end users and/or the end user trainer (train-the-trainer)on the Omega Dashboard web-based user interface.The topics covered range from simple user interaction to more advanced ad hoc report,widget creation, and interactive data analysis, etc. Navigating/Using the Omega Dashboard. • On the fly query creation and report modification Creation of Omega Dashboard widgets, pages & editions (for Designers only) • Data Monitoring Alerts • Interactive Data Analysis 2jPag