Dave Iannone

Here is a starting analysis based on what you described. The goal is to surface and connect the information you already have — replacing a system is a last resort.

System inventory summary

CAD/RMS (county dispatch provider): Computer-aided dispatch and records management for incident logging and patrol operations.
Case management system (detective use): Separate system for case tracking and investigation details.
Evidence/property room tracking system: Tracks physical evidence and property intake and storage.
Internal scheduling tool: Manages patrol shift assignments.
Payroll system: Processes compensation and pay periods.
Public-facing website: Hosts press releases and community information.

Isolated systems & manual burden

CAD/RMS and case management system do not communicate: Detectives manually re-key incident narratives and details when opening cases, consuming several hours per detective per week.
Evidence tracking system is isolated from both CAD/RMS and case management: Property intake is logged twice (once in evidence system, once elsewhere), creating duplicate data entry.
Scheduling tool does not feed payroll system: Overtime and shift hours are manually re-entered during each pay cycle by administrative staff.

Highest-value connection opportunities

Connect CAD/RMS to case management system: Enable automatic or one-time transfer of incident narratives, case numbers, and initial case details from dispatch to detective case system to eliminate the highest-cost manual re-entry (several hours per detective per week).
Connect scheduling tool to payroll system: Feed shift assignments and overtime hours directly to payroll to eliminate weekly re-entry by administrative staff.
Surface evidence data into CAD/RMS and case management: Link or embed property tracking information in both systems so detectives and dispatch can view evidence status without duplicate intake logging.
Evaluate data export capability for evidence system: If the evidence system cannot export in standard formats, work with the vendor or establish a manual export protocol to at least reduce the frequency of duplicate entry.

Systems to investigate

CAD/RMS integration capability: Confirm whether the county dispatch provider's CAD/RMS supports API or batch data exchange with third-party case management systems, or if the case management vendor offers native CAD/RMS connectors.
Case management system integration readiness: Verify whether the detective case management system can accept automated incident data feeds and in what formats (API, database link, flat-file import).
Scheduling system integration options: Determine if the scheduling tool can export shift and overtime data in a format payroll can ingest, or if payroll can import from the scheduling system directly.
Evidence system export feasibility: Confirm current data export formats and whether the vendor can improve export capability or support API integration with CAD/RMS and case management systems.

Consider-alternatives (last resort)

Consider evaluating alternatives to the evidence/property room tracking system: The current system is old, the vendor is unresponsive to support requests, it does not export data in usable formats, and it cannot integrate with CAD/RMS or case management. If the vendor cannot commit to export capability or integration within your timeline, a modern system that integrates with your other platforms may reduce duplicate entry and improve data access.

90-day connection plan

Weeks 1 - 2: Map the technical requirements for CAD/RMS to case management integration (data fields, format, frequency, APIs) and confirm with both vendors whether a native connection exists or can be built.
Weeks 3 - 4: Investigate scheduling tool export and payroll system import capabilities; identify the quickest path to reduce overtime re-entry (direct export, middleware, or manual protocol).
Weeks 5 - 6: Assess evidence system vendor's willingness and timeline to support data export or integration; begin evaluating alternative evidence systems if the vendor cannot commit.
Weeks 7 - 8: Pilot automated CAD/RMS - to - case management data feed with a subset of cases to validate data quality and reduce detective re-entry.
Weeks 9 - 10: Implement scheduling-to-payroll connection or establish interim export workflow to eliminate overtime re-entry by administrative staff.
Weeks 11 - 12: Deploy full CAD/RMS - to - case management integration across all detectives; finalize evidence system decision and begin procurement or vendor negotiations if replacement is warranted.

How this was made. This report pairs a structured public-safety framework with AI drafting to give you a strong, fast starting point. Treat it as informed guidance, not a final answer, and confirm the specifics against your department’s own facts and judgment before you act.