Loading...
HomeMy WebLinkAbout2008-031 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 III RESOLUTION NO. 2008-31 RESOLUTION OF THE CITY OF SAN BERNARDINO AUTHORIZING THE EXECUTION OF AN AGREEMENT AND ISSUANCE OF A PURCHASE ORDER FOR THE PURCHASE OF A "CRIMEVIEW ENTERPRISE" POLICE TACTICAL MAPPING SOLUTION FROM THE OMEGA GROUP LOCATED IN SAN DIEGO, CALIFORNIA. BE IT RESOLVED BY THE MAYOR AND COMMON COUNCIL OF THE CITY OF SAN BERNARDINO AS FOLLOWS: SECTION J. The City Manager is hereby authorized and directed to execute on behall' of the City an Agrcement for the purchase of police tactical mapping software with The Omega Group or San Diego, California, a copy of which is attached hercto, marked as Exhibit A, and incorporated herein by this reference. SECTION 2. That the Mayor and Common Council approve a sole source justification for the vendor, The Omega Group, bascd on their unique police tactical mapping software solution's ability to meet the needs of the San Bernardino Police Department (per Municipal Code 3.04.010 (b)(3)). SECTION 3. That the Purchasing Manager is authorized to issue a Purchase Ordcr to The Omega Group in an amount not to exceed $99,240 for a "CrimeVicw Enterprise" police tactical mapping solution as outlined in The Omega Group's quote dated Oetobcr 1 g. 2007. Thc Purchase Order shall read "CrimcView Enterprise Police Tactical Mapping Solution. l'\ot to exceed $99,240." SECTION 4. The above authorizations are rescinded if not executedlissued within sixty (60) days of the passage of this resolution. 1 2 3 4 5 6 RESOLUTION OF THE CITY OF SAN BERNARDINO AUTHORIZING THE EXECUTION OF AN AGREEMENT AND ISSUANCE OF A PURCHASE ORDER FOR THE PURCHASE OF A "CRIMEVIEW ENTERPRISE" POLlCE TACTICAL MAPPING SOLUTION FROM THE OMEGA GROUP LOCATED IN SAN DIEGO, CALIFORNIA. I HEREBY CERTIFY that the foregoing Resolution was duly adopted by the Mayor and Common Council of the City of San Bernardino at a joint reRulanneeting thereof, held 7 on the 7?nrl day of .T~nll~ry 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 ,2008, by the following vote, to wit: ABST AIN ABSENT NAYS Council Members: AYES ESTRADA X BAXTER X BRINKER X DERRY X KELLEY X JOHNSON ~ MCCAMMACK X Q~~~6~ Rachel G. Clark, City Clerk The foregoing resolution is hereby approved this c2.-of/n< day of Ja.nuary ,2008. 23 ~~ at( k J. Morris, Mayor City of San Bernardino 24 Approved as to Form: 25 26 27 28 MES F. PENMAN, City Attorney 2008-31 CITY OF SAN BERNARDINO - OMEGA GROUP SERVICES AGREEMENT This Services Agreement is entered into this 22nd day of January ,2008, by and between THE OMEGA GROUP ("OMEGA") and the City of San Bernardino ("CITY"). WITNESSETH: WHEREAS, CITY has need for police tactical mapping software, including software, installation, maintenance and training; and WHEREAS, OMEGA is competent, experienced and able to supply and support such software; NOW, THEREFORE, the parties hereto agree as follows: 1. SCOPE OF SERVICES. For the remuneration stipulated, San Bernardino hereby engages the services of OMEGA to provide those products and services as set forth on Exhibit "A," attached hereto and incorporated herein. Omega shall retain the right to perform work for others during the term of this Agreement. 2. CONDUCT OF SERVICES. Client agrees to provide working space and facilities, and any other services and materials Omega or its personnel may reasonably request in order to perform the work assigned to them. All work shall be performed in a workmanlike and professional manner by employees or subcontractors of Omega having a level of skill in the area commensurate with the requirements of the scope of work to be performed. Omega shall make sure its employees or subcontractors at all times observe security and safety policies of Client. 3. METHOD OF PERFORMING SERVICES. The parties acknowledge and agree that Client shall have no right to control the manner, means, or method by which Omega performs the services called for by this Agreement. Rather, Client shall be entitled only to direct Omega with respect to the elements of services to be performed by Omega and the results to be derived by Client. Client can review and assess the performance Omega services for the limited purposes of assuring that such services have been performed and confirming that such results were satisfactory. 4. COMPENSA nON AND EXPENSES. a. For tbe services delineated above, the CITY, upon presentation of an invoice, shall pay OMEGA up to the amount of$99,240.00. b. Payment shall be made in six installments which are due as follows: Ten percent (10%) Fifteen percent (15%) $10,424.00 $15,636.00 due upon execution of Agreement due upon delivery of Crime View Desktop and Omega Import Wizard software, ESRI Upgrade (Maintenance Costs) , and Annual Support Cost for CrimeView Desktop due upon completion of Task 3 CrimeView Desktop Deployment due upon completion of Task 6 CrimeView Web Application Development due upon completion of Task 7 Crime View Web Application Deployment due thirty (30) days after completion of services Twenty percent (20%) $20,848.00 Twenty percent (20%) $20,848.00 Fifteen percent (15%) $15,636.00 Ten percent (10%) $20,848.00 C. No other expenditures made by OMEGA shall be reimbursed by CITY. 1 2008-31 5. TERM; TERMINATION. This Agreement shall be in effect until thirteen (13) months after the completion of the software installation. This Agreement may be terminated at any time by sixty (60) days' written notice by either party if the other party breaches any term of this Agreement and the breaching party fails to cure the breach within the 60-day period; provided that, notwithstanding the foregoing, the cure period for any failure of CITY to pay fees and charges due hereunder shall be thirty (30) days from the date of receipt by CITY of notice of delinquency. The terms of this Agreement shall remain in force unless mutually amended. The duration of this Agreement may be extended with the written consent of both parties. Upon termination of this Agreement for any reason, OMEGA shall promptly return to CITY all copies of any CITY data, records, or materials of whatever nature or kind, including all materials incorporating the proprietary information of CITY. OMEGA shall also furnish to CITY all work in progress or portions thereof, including all incomplete work. 6. CONFIDENTIALITY. The parties agree not to disclose to any third party any proprietary or confidential 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 or confidential information as it does with its ovm, but in no event with less than a reasonable degree of care. this obligation of the parties shall survive beyond the effective tennination date of this Agreement. These restrictions shall not be construed to apply to (1) information generally available to the pnblic; (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 or the other party; or, (4) information approved for the use and disclosure of either party or its personnel without restriction. 7. INDEMNITY. OMEGA agrees to and shall indemnify and hold the City, its elected officials, employees, agents or representatives, free and harmless from all claims, actions, damages and liabilities of any kind and nature arising from bodily injury, including death, or property damage, based or asserted upon any actual or alleged act or omission of OMEGA, its employees, agents, or subcontractors, relating to or in any way connected with the accomplishment of the work or performance of services under this Agreement, unless the bodily injury or property damage was actually caused by the sole negligence of the City, its elected officials, employees, agents or representatives. As part of the foregoing indemnity, OMEGA agrees to protect and defend at its own expense, including attorney's fees, the City, its elected officials, employees, agents or representatives from any and all legal actions based upon such actual or alleged acts or omissions. OMEGA hereby waives any and all rights to any types of express or implied indemnity against the City, its elected officials, employees, agents or representatives, with respect to third party claims against OMEGA relating to or in any way connected with the accomplishment of the work or performance of services under this Agreement. 8. INSURANCE. While not restricting or limiting the foregoing, during the term of this Agreement, OMEGA shall maintain In effect policies of comprehensive public. general and automobile liability insurance, in the amount of $1,000,000.00 combined single limit, and statutory worker's compensation coverage, and shall file copies of said policies with the CITY's Risk Manager prior to undertaking any work under this Agreement. CITY shall be set forth as an additional named insured in each policy of insurance provided hereunder. The Certificate of Insurance furnished to the CITY shall require the insurer to notify CITY of any change or termination in the policy. 9. 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. IIII 2 2008-31 10. LIMITATION OF LIABILITY. Omega's cumulative liability under or for breach of this agreement shall be limited to the fees paid by client to omega. Omega shall have no liability for loss of data or documentation, it being understood that client is responsible for backup precautions. 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 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. 11. NON-DISCRIMINATION. In the performance of this Agreement and in the hiring and recruitment of employees, OMEGA shall not engage in, nor permit its officers, employees or agents to engage in, discrimination in employment of persons because of their race, religion, color, national origin, ancestry, age, mental or physical disability, medical condition, marital status, sexual gender or sexual orientation, or any other status protected by law, except as permitted pursuant to Section 12940 of the California Government Code. 12. INDEPENDENT CONTRACTOR. OMEGA shall perform work tasks provided by this Agreement, but for all intents and purposes OMEGA shall be an independent contractor and not an agent or employee of the CITY. OMEGA shall secure, at its expense, and be responsible for any and all payment of Income Tax, Social Security, State Disability Insurance Compensation, Unemployment Compensation, and other payroll deductions for OMEGA and its officers, agents, and employees, and all business license, if any are required, in connection with the services to be performed hereunder. 13. BUSINESS REGISTRATION CERTIFICATE AND OTHER REQUIREMENTS. OMEGA warrants that it possesses or shall obtain, and maintain a business registration certificate pursuant to Chapter 5 of the Municipal Code, and any other licenses, permits, qualifications, insurance and approval of whatever nature that are legally required of OMEGA to practice its business or profession. 14. NOTICES. Any notices to be given pursuant to this Agreement shall be deposited with the United States Postal Service, postage prepaid and addressed as follows: TO THE CITY: TO OMEGA: Mr. Tom Marek 300 North "D" Street San Bernardino, CA 92418 Telephone: (909) ~R4-'iq47 15. ATTORNEYS' FEES In the event that litigation is brought by any party in connection with this Agreement, the prevailing party shall be entitled to recover from the opposing party all costs and expenses, including reasonable attorneys' fees, incurred by the prevailing party in the exercise of any of its rights or remedies herelUlder or the enforcement of any 3 2008-31 of the tenns, conditions or provisions hereof. The costs, salary and expenses of the City Attorney and members of his office in enforcing this Agreement on behalf of the CITY shall be considered as "attorneys' fees" for the purposes of this paragraph. 16. ASSIGNMENT. OMEGA shall not voluntarily or by operation of law assign, transfer, sublet or encumber all or any part of OMEGA's interest in this Agreement without CITY's prior written consent. Any attempted assignment, transfer, subletting or encumbrance shall be void and shall constitute a breach of this Agreement and cause for the tennination of this Agreement. Regardless of CITY's consent, no subletting or assignment shall release OMEGA of OMEGA's obligation to perform all other obligations to be performed by OMEGA hereunder for the term of this Agreement. 17. VENUE. The parties hereto agree that all actions or proceedings arising in connection with this Agreement shall be tried and litigated either in the State courts located in the County of San Bernardino, State of California or the U.S. District Court for the Central District of California, Riverside Division. The aforementioned choice of venue is intended by the parties to be mandatory and not permissive in nature. 18. GOVERNING LAW. This Agreement shall be governed by the laws of the State of California. 19. 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. 20. SUCCESSORS AND ASSIGNS. This Agreement shall be binding on and inure to the benefit of the parties to this Agreement and their respective heirs, representatives, successors, and assigns. 21. HEADINGS. The subject headings of the sections of this Agreement are included for the purposes of convenience only and shall not affect the construction or the interpretation of any of its provisions. 22. SEVERABILITY. If any provision of this Agreement is determined by a court of competent jurisdiction to be invalid or unenforceable for any reason, such detennination shall not affect the validity or enforceability of the remaining tenns and provisions hereof or of the offending provision in any other circumstance, and the remaining provisions of this Agreement shall remain in full force and effect. 23. ENTIRE AGREEMENT; MODIFICATION. This Agreement constitutes the entire agreement and the understanding between the parties, and supercedes any prior agreements and understandings, either oral or written, relating to the subject manner of this Agreement 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 of any party, that are not 4 2008-31 embodied herein, and that no other agreement, statement, or promise not contained in this Agreement shall be valid or binding. This Agreement may be modified or amended only by a written instrument executed by all parties to this Agreement. IN WITNESS THEREOF, the parties hereto have executed this Agreement on the day and date set forth below. l' Dated: f.e b .1 <; , 2008 THE OMEGA. GROUP B~~~' Its: ["\,1<41 ~. I"l4tU-e.(, ~kt,.t I Date~........ old' , 2008 ARDINO By: Approved as to Form: James F. Penman, City Attorney ~~ 5 2008-31 San Bernardino Police Department, California The Omega Group, Inc. October 18, 2007 Proiect SUmmary - Quote The Package total is: $99,240.00 Software: All Omega and ESRI software includes one (I) year of maintenance. $52,005.00 CrimeView Desktop Ome~a Software: . One (I) licensed copies of Crime View 4.x ESRI Software: (ESRI Maintenance) By paying maintenance on your existing ESRI software licenses, you will qualify to receive the latest version of each software license that is available. . One (I) ArcGIS 9x and Spatial Analyst extension: CrimeView Web Omega Software: . One (I) licensed copy of Crime View Web ESRI Software: . One (I) licensed copy of ESRI's ArclMS 9.x Omega Dashboard Omega Software: . One (I) licensed copy of Omega Dashboard Viewer, Site License . One (I) licensed copy of Dashboard Administrator, with I - 5 Connections Other Omega Software: . One (I) licensed copy of The Omega Import Wizard Annual Support . CrimeView Desktop - One year annual back maintenance $2,495.00 Professional Services (Per Task) $44,740.00 Task 1 CrimeView Desktop Project Planning and Data Collection . Identify GIS map layers and design preferences . Identify source tabular data from RMS and CAD . Collect base map GIS data layers . Connect to records data source, extract sample datasets and send output profiles to Omega using Import Wizard . Collect lookup tables Task 2 CrimeView Desktop Application Development . Add GIS layers to map document and create address locators . Develop and configure data import profiles. Two (2) profiles are included . Create Saved Queries database and design Crystal Report templates Exhibit "A" 2008-31 San Bernardino Police Department, California The Omega Groop, loc. October 18,2007 . Add Omega functionality and other customizations to GIS application . Test application functionality . Develop training documents Task 3 CrimeView Desktop Application Deployment (At Client Site) . CrimeView Desktop Installation: Up to eight (8) hours on-site. One (1) Omega personnel. o Install and configure data import profiles on import machine o Test import profiles and import historical data o Schedule automated data import process o Install and configure OmegaGIS application on user machines . CrimeView Desktop On-site training: Sixteen (16) hours on-site for five (5) persons, One (1) Omega personnel. . Travel for The Omega Group: One (1) staff members to provide installation and training for one (I) trip Task 4 CrimeView Desktop Finishing Application Design . Edit and Customize Import Profiles, Saved Queries, Crystal Report Templates and Application Style, per user feedback. . Test Application Functionality Task 5 CrimeView Web Project Planning and Data Collection . Identify GIS ntap layers and design preferences . Identify data fields from each data set to be displayed in Crime View Web Task 6 CrimeView Web Application Development . Add GIS layers to map document and create address locators . Create map configuration file . Create data import profiles . Create Map Services . Attach Databases or Import data into SQL server . Create Saved Queries for each data set . Create config.xml file . Add Reports . Add Omega functionality and other customizations to GIS application . Additional graphics to web page, reports and/or splash screen Task 7 CrimeView Web Application Deployment (Via Remote Connection) . Install and configure OmegaGIS application . Configure data import profiles . Test import profiles and import historical data . Schedule automated data import process . Install and configure Omega Web application on Web Server Task 8 Task 9 2008- 31 San Bernardino Police Department, California The Omega Gronp, Inc. October 18, 2007 . Test Omega Web application functionality and tune application with client resources CrimeView Web Application Deployment (at Client Site) . One (I) Day (up to 8 hours) on-site. One (1) Omega personnel. . Application Training o User Training o Application maintenance requirements . Travel for The Omega Group staff members to provide training for one (I) trip Omega Dashboard Deployment (via Remote Access) . Omega Dashboard Installation via remote access o Install SQL Server 2003 on web server or SQL Server 2005 Express o Install lIS on web server o Install Dashboard Administrator and Dashboard Viewer components on the web server o License Dashboard extension that is available from a machine with The Omega Desktop software. o Configure administration and user access . Omega Dashboard Performance Testing Task 10 Omega Dashboard training (At Client Site) . Provide up to twelve (12) hours of Dashboard Training over two (2) days onsite: o Dashboard Data Creation (Using CrimeView Desktop) o Dashboard Data Automation o Dashboard Administrator Software Management . Provide any additional deployment steps not performed under Omega Dashboard Deployment. . Travel for The Omega Group staff members to provide training for one (I) trip NON.DISCLOSURE This quote has been prepared by the sales division of The Omega Group and is a confidential docwnent that contains ideas, concepts, methods and other proprietary infonnatim. Readers are to treat the infoonation contained herein as con.fidemial and may not copy or reproduce any of these materials for distmution outside of their organizatioo without. the written permission of The Omega Group. The quote will remain valid for 6 months from the date on the quote for Omega Software and Services only. During the same 6 months, doUars associated with ESRl software, ESRl training or Hardware cannot be guaranteed by Omega.. Maintenance Please see the Customer Support Program for detailed services and limitations for Omega solutions. Total Omega Software Maintenance Annual Cost $7,490.00 Total ESRl maintenance Annual Cost $3,000.00 2008-31 San Bernardino Police Department, California The Omega Group, Inc. October 18, 2007 Omega Maintenance Plan The Support fee is paid annually. The first year of support for each application is included in the initial purchase and begins 30 days after the completion of each application or at upon the date of acceptance. Support identified below is for Omega software and services only. Application Total Costs CrimeView Desktop Package $2,495.00 CrimeView Web Package $3,495.00 Omega Dashboard Package $1,500.00 Total Omega Software Maintenance $7,490.00 ESRI Maintenance Costs The San Bernardino Police Department will be required to stay active and current with its ESRl Software Maintenance Package. The maintenance costs are for the software quantities identified in this package. ArcView and Soatial Analvst The table below represents the cost of maintaining the first copy of ESRl's ArcGIS 9.x software, plus the extension (Spatial Analyst), followed by the secondary (second, third, fourth, etc) copy. Software Qnantity Unit Costs Total Cost Primary ArcView 9.x single use 1 $1000.00 $1,000.00 license, with one or more extensions ArcIMS The table below represents the cost of maintaining ESRl's ArcIMS 9.x software Software Quanti Unit Costs Total Cost ArcIMS Standard Edition I $2,000.00 $2,000.00 I Total ESRI maintenance I $3,000.00 Maintenance costs are current, as of October 2007. It is the client's responsibility to be aware of any changes in maintenance costs for ESRl software/ terms and conditions. The first year of support for each software license is included in the initial purchase. The first annual payment of maintenance occurs I year from the date of purchase. ESRl will invoice the client directly and client should make all payments directly to ESRl. 2008-31 San Bernardino Poliee Department, California The Omega Group, Ine. October 18,2007 Payment Schedule In consideration of the services to be performed by Omega, Omega shall be entitled to compensation in the total amount of $99,240.00. The payment schedule consists of four payments and is due as follows: . Ten percent $9,924.00 of the total amount due upon execution of this (10%) Agreement. . Ten percent $9,924.00 of the total amount due upon delivery of Crime View (10%) Desktop and Omega Import Wizard software, ESRI Upgrade (Maintenance Costs), and Annual Support Cost for CrimeView Desktop . Thirty percent $29,772.00 of the total amount due upon completion of Task 3 (30%) CrimeView Desktop Deployment . Thirty percent $29,772.00 Of the total amount due upon completion of Task 6 (30%) CrimeView Web Application Development . Ten percent $9,924.00 Of the total amount due upon completion of Task 7 (10%) CrimeView Web Application Deployment . Ten percent $9,924.00 of the total amount due thirty (30) days after (10%) completion of services Data Specifications Datasets to be Imported via Omega Import Wizanl™ The client operates a Tiburon CAD/RMS system. The following data sets represent tables of data to be extracted by The Omega Import Wizard. An Import Profile will be built for each data set listed CAD - Calls for service RMS - Incident database Please review the Omega Import Wizard Appendix for more details regarding the Omega Import Wizard and the use of Profiles. Because a significant amount of work ( and cost) can be attributed to the incident or person data being imported, it is important that Omega Project Management have access to local knowledge regarding the RMS or CAD data/database as outlined under General Requirements (see next page). 2008-31 San Bernardino Police Department, California The Omega Group, Inc. October 18, 2007 General Requirements Client Project Management Critical to the success of every implementation is having the appropriate client statT prepared to be active participants and to understand what is expected from them for the duration of the implementation. Two critical components to this implementation pertain to local knowledge of data schema for the RMS/CAD data sources and what data should be available for mapping and reporting. Database Schema The client should expect to provide statT resources who can demonstrate knowledge of the tabular structure (schema) of the RMS, CAD and other data sources. These persons will be expected to assist Omega Technicians in building SQL statements that includes all the fields of data that the client wants for mapping and reporting. This assistance would primarily be in the form of understanding database structure and table relationships. Report nata The client should expect to provide statT resources who can confrrm what data needs to be included for mapping and reporting. These persons should have direct experience in working with crime data through current extractions from the RMS, CAD and other data sources and from the perspective and experience of a crime analyst. The Omega Group maintains an inventory of data extraction templates (e.g. SQL Statements) that can be used to as a starting point for the development of a customized data interface. However, having client statT that can provide local knowledge of the database can reduce the overall project time, facilitate the ongoing maintenance of the application and produce a more useful crime mapping and reporting environment. Project Planning Remote Connectivity: Secure or confirm remote access via the use of Expert City's GoToMyPC or the use of a VPN Connection. . Establishing Remote Connection to the Server(s). o Data Collection, Installation and Technical Support may be performed through remote connection, reducing cost of project and time it takes to complete services o Omega Recommends ExpertCity's GoToMyPC or VPN for remote connections . Provide Network IP Address ifVPN is used . If the client is unable to provide high speed remote access with GoToMyPC or similar connection software to The Omega Group for the collection of the required data sets then an additional fee will be charged to the client based on the additional time required for data collection. 2008-31 San Bernardino Police Department, California The Omega Group, Inc. October 18, 2007 Data Geography: The client will provide for the geographic base data for the project. In addition to the Street Centerline this may include: Parks, Schools, Beats, Reporting Districts, Landmarks, Stations, Parcels, etc. During the project kick-off a discussion regarding the type and availability of data will ensue. . Street Centerline File: The client must provide accurate reference data that will be used to generate a geocoding service. Typically the reference data is a street centerline file, address points or a parcel layer. Data CoUection (For CrimeView Web) . Provide an .mxd file that includes geographic shapefiles or feature classes with desired RGB values and desired extents. o What are the Colors for each layer and the extents for which layers automatically turn on/off o Client should design the .mxd and sign off on the finished design, or sign off on Omega to determine the standards. . Confirm datasets to be used with the application (Associated with the 'What' Tab in the application o Common datasets include: Incident Reports, Calls for Service, Parolees, Arrestees, Sex Offenders, Gang Members . Confirm which of the geographic shapefiles or feature class data will be used for the 'Near a Feature' query. This routine creates a buffer distance around the selected features o Common data includes: Buildings, Schools, Parks, Police Stations, Major Roads, Neighborhoods o Provide both common name (parks) and file name (parks.shp) . Confirm which of the geographic shapefiles or feature class data will be used for the 'Within a Boundary' query. This routine filters the incident or person dataset for the boundary selected o Common data includes: Zip Codes, Police Beats, Districts, Neighborhoods, Wards, Police Team Areas, Reporting Districts o Provide both common name (parks) and file name (parks.shp) . Confirm street file to be used for geocoding. o Provide exact name (i.e. centerlines.shp, streets.shp, etc.) o Address style should be 'US Streets with Zone' Shapente Implementation Requirements for Shapefiles: . Field names for each Shapefi1e must be in Capital Letters 2008-31 San Bernardino Police Department, California The Omega Group, Inc. October 18, 2007 . The Directory path for Data Shapefiles should stay the same@i.e. Incident Reports, CAD, Known Offenders, etc.) o If directory Changes, then the work spaces in the .axl file must be updated to recognize the new directory path. . The Directory path for Geographic Shapefiles should stay the same@i.e. Parks,zip Codes, Rivers, etc.) o If Directory Changes, then the work spaces in the .axl file must be updated to recognize the new directory path System Architecture ArcIMS Server Implementation Requirements for ArcIMS installation, when Omega provides the installation! configuration services: . Provide server name to Omega Project Management . Provide IP Address of the ArcIMS Server o Need IP Address for Web Server if separate from ArcIMS Server . Provide Local Administrative Login: User Name and Password o Need Local administrative login for Web server is separate Requirements for ArcIMS Server if ArcIMS software is already installed on the server: . Provide ArcIMS Administrator Login: User Name and Password Prior to the CrimeVie~ Enterprise Installation: the following items should be completed by the Network Administrator / GIS Coordinator: . ESRI Training Course: The onsite administrators have completed ESRI's Training Courses. o The Omega Group highly recommends all personnel worldng with CrimeView to have the Introduction to ArcGIS I and/or Introduction to ArcGIS II training in addition to Crime View training. At least one person, preferably the on-site Crime View administrator, should have a solid understanding of ArcGIS (ArcMap and ArcCataIog). The Omega Group requires that at least the system administrator or primary user receive ArcGIS training prior to receiving CrimeView training. o GIS Training: The Omega Group recommends that all personnel administrating CrimeView Web attend the Introduction to ArcGIS I training course or possess comparable GIS experience before receiving CrimeView Web training. At least one person, preferably the primary system administrator, should have a solid understanding of GIS. GIS training is not available directly from Omega but can be taken from ESRI or from approved training centers at the following web address: htto:/ /www.esri.comltraining/index.httnl.