ATTACHMENT A – STATEMENT OF REQUIREMENTS
SJPD Command
5 FOR A HYBRID SOLUTION
5.2. Propose the server specifications for production and test environments, as well as the development environment, running on the latest Windows server operating system
5.3. Propose required license for each environment if required.
5.4. Propose a server redundancy architecture if required.
5.5. Propose the number of instances, instance type, data transfer rate, storage rate, and other relevant specifications.
5.6. Describe how the software application meets the minimal security requirements for CJIS, FIPs 140-2, and City of San José Data retention policies (available on sanjoseca.gov).
5.7. Propose the storage space requirement for the converted data and the storage space projection for the next five years for the production and test environments, as well as the development environment if required.
5.8. Propose any other hardware and software required for the solution including, bridge servers – servers that run software to act as a data bridge, and/or proxy servers.
6
IMPLEMENTATION
6.1. Replace/update current Ops Force: Discover™ Software.
6.1.1. Phase I: Data model design for software that will replace and/or upgrade Ops Force Discover.
6.1.2. Phase II: Perform the data and report conversion of existing tool. Provide required training for CAU personnel. Provide applications to support the approved workflow.
6.2. Install a Mobile Predictive Analysis Tool
6.2.1. Phase I: Perform data design required to access and use the SJPD’s CAD
(Intergraph) and/or RMS (Versaterm) information. Develop mapping layer for SJPD beat structure with mapping overlays. Design designations by Police division so each division is given a view of their respective parts of the City. Design data import mechanism.
6.2.2. Phase II: Perform system testing on desktop. Perform system and performance testing on mobile computers using wireless access. Optimize data upload feed using a standard data transfer mechanism. Deploy system on desktop and Mobile client.
Perform stress testing. Provide long-term application support and periodic workflow changes.
7
CURRENT TECHNICAL COMPONENTS
7.1. The SJPD currently utilizes the following applications that provide useful information to the Crime Analysis Unit:
7.1.1. Computer Aided Dispatch - provided by Intergraph and uses Oracle as a Database Management System.
7.1.2. Records Management System– provided by Versaterm and uses Informix as the Database Management System.
8
SJPD’S RESPONSIBILITIES
8.1. Technical TasksBid RFP 14-15-07 City of San Jose
18 8.1.1. For a hybrid and/or cloud solution:
8.1.1.1. SJPD pays the cloud subscription fees.
8.1.1.2. Procure the necessary software licenses if required;
8.1.1.3. Acceptance testing of all software recommendations and installations.
8.2. Administrative Tasks
8.2.1. Facilitate all required logistics, including scheduling, room reservations, hardware, etc. needed for workshops and training.
8.2.2. Provide follow-up written comments to Contractor when necessary within ten business days following review sessions.
8.2.3. Provide workshop/training facilities on-site. Contractor will be provided reasonable access to the training/workshop facilities, such as the building, room, and hardware.
8.2.4. Provide Enterprise account privileges and passwords to Contractor as needed.
8.2.5. Provide a work space and a computer when Contractor is working on- site.
8.3. Provision of Data
To assist Proposers in preparing their implementation plans and cost estimates, the SJPD will provide data examples that include schema and sample data.
8.3.1. Access to Intergraph CAD system, schema design, technical resources and available Application Programming Interface (API).
8.3.2. Access to Versaterm RMS system, schema design, technical resource and available API.
8.4. SJPD Resources
8.4.1. The SJPD will appoint a project manager, whom the Contractor’s project manager will report to.
8.4.2. The SJPD will provide system administration of the new system(s) once implemented and accepted.
9
IMPLEMENTATION, DATA CONVERSION AND APPLICATION INTEGRATION WARRANTY
9.1. Proposer shall include a warranty of one year on their work to ensure that all errors relevant to the implementation of this project, whether discovered by the SJPD, Proposer, or other City-authorized users, are corrected to the satisfaction of the City.
9.2. The Twelve (12) month warranty shall begin at the completion of the project.
9.3. 24/7 phone support and error reporting via email or proposers website.
10
SCOPE OF SERVICES
10.1. Phase I Overview10.1.1. The objective of Phase I is the successful design of the data model for the SJPD’s implementation, and the successful installation and configuration of all necessary software in a test environment. This phase shall be completed within one month from approval of Phase I work plan. Contractor must obtain formal approval and signoff of each deliverable before moving to the next phase.
Bid RFP 14-15-07 City of San Jose
10.1.2. The Phase I tasks for both the Crime Analytics tool and the Mobile Predictive Analytics tool shall be done concurrently.
10.1.3. In Phase I, the Contractor shall:
10.1.3.1. Develop a work plan that outlines Phase I technical approach and methodology.
10.1.3.2. Hold data model review meetings with the SJPD team and obtain approval from SJPD.
10.1.3.3. Set up communication with the SJPD team to resolve any issues found.
10.2. Phase I Deliverables
Phase I Deliverables – Crime Analytics Tool
1. Kick-off meeting agenda and meeting minutes for all the meetings with The SJPD.
2. Issues List/Decision Log maintained and regularly presented for review for all phases.
3. Phase I work plan
Work Plan that lays out an effective strategy for Phase 1.
Detailed project plan and schedule.
4. Data model for the new system implementation
Entity relationship diagram (ERD).
Analysis of design of any interface(s) needed to transfer information from the CAD or RMS systems
Data model documentation and ERD.
5. For a hybrid and/or cloud solution
Software installation and configuration for the test environment.
Deploy any hardware and or system required for hybrid system.
6. System Architecture Diagram
Diagram shows the system components (web application server software, databases, servers, server redundancy, etc.) and their relationships.
Diagram clearly drawn in the Visio and PDF formats.
7. User training on the installation and configuration of system
Training curriculum
Successful user training as determined by SJPD staff 8. Other related tasks
9. Project status report at the completion of Phase 1
Bid RFP 14-15-07 City of San Jose
Phase I Deliverables – Mobile Predictive Analytics tool
1. Kick-off meeting agenda and meeting minutes for all the meetings with SJPD.
2. Issues List/Decision Log maintained and regularly presented for review for all phases.
3. Phase I work plan
Work Plan that lays out an effective strategy for Phase 1.
Detailed project plan and schedule.
4. Data model for the new system implementation
Entity relationship diagram (ERD).
Analysis of design of any interface(s) needed to transfer information from the CAD or RMS systems
Data model documentation and ERD.
5. For a hybrid and/or cloud solution
Software installation and configuration for the test environment.
Deploy any hardware and or system required for hybrid system.
6. System Architecture Diagram
Diagram shows the system components (web application server software, databases, servers, server redundancy, etc.) and their relationships.
Diagram clearly drawn in the Visio and PDF formats.
7. User training on the installation and configuration of system
Training curriculum
Successful user training as determined by SJPD staff 8. Other related tasks
9. Project status report at the completion of Phase 1
10.3. Phase II Overview
10.3.1. The objective of Phase II is to perform system and performance testing on mobile computers using wireless access. Optimize data upload feed using a standard data transfer mechanism. Deploy system on desktop and Mobile client. Perform stress testing and fully deploy system.
10.3.2. The Phase II tasks for both the Crime Analytics tool and the Mobile Predictive Analytics tool shall be done concurrently.
10.3.3. In Phase II, Contractor shall:
10.3.3.1. Develop a work plan that outlines Phase II technical approach and methodology.
10.3.3.2. Hold work plan and data conversion review meetings with the SJPD team.
10.3.3.3. Verify the application stability and utility on the desktop and mobile environments.
10.4. Phase II Deliverables
Phase II Deliverables - Crime Analytics Software Tool 1. Phase II work plan
Perform system and performance testing with live data
Test system performance on desktop computers
20
Bid RFP 14-15-07 City of San Jose
Develop and/or test existing reports and system output.
2. Obtain the SJPD’s approval for full production
Ready the production environment.
Server redundancy implementation for the production environment if proposed by the proposer and approved by the SJPD.
Server redundancy installation and configuration documentation, and support procedures, if installed.
Final Testing will include:
SEARCHES
Capable of searching all data contained within a CAD event
o Dispatcher Comment
Drill down search capabilities using the following or combination of:
o Call Type
Download results in application such as excel
Data uploaded near real time
NOTIFICATIONS
Capable of setting up a notifications when the following occurs or combination of:
o Call Type
Capable of reporting/summarizing the following data:
o Call Count Summary o Frequent Event Locations
o Geographic Comparisons (Based on Beat/Call Type/etc) o Officer and Unit Comparisons
o Simple Lists (Case Numbers/Daily Event Report/etc o Time Analysis (Events by Day of Week/Time of Day etc) o Police Response Time Analysis (Average/Time Spent etc)
Bid RFP 14-15-07 City of San Jose
22
MAPPING
Capable of mapping selected event calls if possible.
3. Project status report at the completion of Phase II
4. User training on the new system, including data structure and system design, location of interface location server redundancy if applicable.
Training curriculum
Successful completion of the user training for Phase II 5. Other related tasks
Phase II Deliverables - Mobile Predictive Analytics tool 1. Phase II work plan
Perform system and performance testing with live data
Test system performance on desktop computers
Develop and/or test existing reports and system output.
2. Obtain the SJPD’s approval for full production
Ready the production environment.
Server redundancy implementation for the production environment if proposed by the proposer and approved by the SJPD.
Server redundancy installation and configuration documentation, and support procedures, if installed.
3. Project status report at the completion of Phase II
4. User training on the new system, including data structure and system design, location of interface location server redundancy if applicable.
Training curriculum
Successful completion of the user training for Phase I 5. Other related tasks
Bid RFP 14-15-07 City of San Jose