Computer Aided Dispatch (CAD) 3rd Party Product (Versaterm) Oracle DB Contains calls for service and dispatch information. Performance Data Call Data Geographical Crisis Response Team (CRT) Response Deployment History Records Management System (RMS) 3rd Party Product (Versaterm) Oracle DB Contains incident reports, narratives, offenses, investigations, property, etc. Arrests Employee Profiles/History Employee Status CRT Reports Street Checks Crisis Intervention Terry Stops Geographical Crime Learning Management System (LMS) 3rd Party Product (Cornerstone) Cloud solution Includes course scheduling, course attendance, certifications. Training Qualifications Geographical Information System (GIS) 3rd Party Product (ESRI) City System to store, manipulate, analyze, manage, and present geographical data. Geographical Clare (Citation Warning Tracking Database) Custom web app (Apex) Citation Warning Tracking database. Citation Tracking SECTOR 3rd Party Product SQL DB Contains information collected during a Traffic Citation event or a Traffic Collision event. Traffic Citation Reports Traffic Collision Reports Versonnel 3rd Party Product (Versaterm) Oracle DB HR database for Versaterm CAD and RMS. Current Assignments Certifications eDirectives In-house Oracle APEX Contains directives, comprehension scores, sign- offs and supervisory accountability Directive Accountability In-Car 3rd Product (Coban) SQL DB Contains tabular data about video collection (officer, vehicle, dates, tags, etc.) as well as pointers to specific video for each event Video Geographical Officer, Vehicle, Date, Time Use of Force evidence Holding Cell Video 3rd Party Product SQL DB Contains tabular data about video collection Video Use of evidence
Performance Appraisal In-house Oracle APEX Contains annual review data Annual Review data Digital Evidence Management System (DEMS) 3rd Party Product (Data Works Pro) SQL DB Contains still photos of crime scenes, audio records of investigations, chain of custody information, etc. Crime Scene photos Detective Interviews (audio recordings) Range In-house Oracle APEX Range Qualification application to tracking qualifications Officer Range Qualifications Hand Held Ticketing 3rd Product (gtechna) SQL DB Parking Citations Parking Citations Litigation City Legal system (OnTrack) Litigation tracking Litigation data Active Directory Microsoft AD Authentication Email Addresses HRIS ADP EV5 City HR system Employee data PEDS In-house Oracle APEX HR data Supervisor data Organization Structure Historical Supervisor data Vendors are advised that SPD is increasing its use of audio and video files to include, for example, In-Car Video Recordings Ofiicer-Worn Video Recordings Holding Cell Recordings 911 Audio Recordings And audio and/or video recordings of officer, subject, and witness narratives It is not expected that the DAP will contain or will be used to analyze native audio or video files; rather, the City expects that metadata about these files will be contained in, or accessible to, the DAP for association with specific officer-related events or incidents. 1.10 Access to Data Access to Law Enforcement data is governed by Federal and law as well as the FBI CJIS Policy. Attached is a summary list of those access control restrictions. Generally summarized, victim, complainant, witness, criminal history, sensitive sites (critical infrastructure, safe houses, etc.) are protected. Access to this kind of data must be limited to staff that has passed an SPD background check. MINIMUM QUALIFICATIONS
Deliverable 11.2 Training Materials Purpose To provide SPD with materials for each training session. Content Content and materials for each class, tailored to SPD’s Data Analytics Platform configuration and contents. Deliverable 11.3 Training Purpose To train SPD trainers on system use and to train technical staff on Data Analytics Platform administration and configuration for completion of knowledge transfer. Content The delivery of user and technical systems operation training in accord with the Training Plan. Objective 12: Provide go-live support and stabilization services Deliverable 12.1 Go-Live and Stabilization Plan Purpose To define the steps necessary for a successful launch and subsequent stabilization of the Data Analytics Platform. Content A detailed task plan, including a readiness checklist and resource assignments, to support moving the Data Analytics Platform into production. Deliverable 12.2 Business User Manual Purpose To SPD employees with the functionality and contents of the Data Analytics Platform. Content Online documentation that supports SPD-specific business use of the system and provides guidance to end users in correct execution of user-performed application maintenance and configuration activities. Includes site-specific customizations and usage considerations. Deliverable 12.3 Production Support Plan Purpose To SPD technical and operations staff in supporting the Data Analytics Platform in production. Content Online documentation that provides complete, detailed, accurate specifications for the Data Analytics Platform and supports SPD technical and operations staff in operating and maintaining the Platform, including routine system maintenance activities and schedules and techniques for trouble-shooting problems. Deliverable 12.3 Data Analytics Platform in Productive Use Purpose To provide SPD with a functioning Data Analytics Platform configured to meet SPD’s functional requirements, loaded with SPD’s data per the Conversion Plan, and updated regularly from SPD transactional systems per the Interface Plan. Content Implemented Data Analytics Platform in production. Deliverable 12.4 Stabilization Services Purpose To provide SPD with support services for a defined period of time (currently assumed to be six months) subsequent to Go-Live, including the identification and resolution of malfunctions and operational issues. Content Stabilization services, commencing at Go-Live and terminating at Services Final Acceptance. Deliverable 12.5 System Support Purpose To provide SPD ongoing system support for the first five years the DAP is in production. Services are to include troubleshooting and problem resolution; assisting with software