Law Enforcement and Justice

Automating RMS/CAD Data Import with the Crime Analysis Solution

Crime Analysis with ArcGIS Pro Video Blog Series—Part 1

For many crime analysts, one of the biggest challenges to doing their work is data access. The crime and incident data needed by analysts to perform their job duties typically resides in a computer-aided dispatch (CAD) or records management system (RMS). It is often difficult to access data from these systems of record. The extract, transform, and load (ETL) process from CAD/RMS to ArcGIS can be tedious and time-consuming, and many analysts struggle with the process.

In this video, we will discuss how you can use ArcGIS Pro and the Crime Analysis solution to automate RMS/CAD import to ArcGIS and show you how to create a database connection, geocode and update the data in ArcGIS Pro, and then schedule it to update regularly.

What you will need for this process:

Now let’s join Chris Delaney as he walks us through the entire workflow.

Resources for Automating Data Import

Thank you for joining us for the first episode of the Crime Analysis with ArcGIS Pro video blog series. If you have questions or feedback about this workflow or any of the tools in the upcoming blogs, you can connect with us:

John Beck, Director, Law Enforcement Solutions:

Chris Delaney, Product Owner, Law Enforcement Solutions:

About the authors

John Beck is the Director of Law Enforcement Solutions at Esri where he is responsible for helping police agencies worldwide understand and implement GIS for every mission. Before joining Esri, Beck was a police officer and crime analyst in Nevada. In his role at Esri, he helps police agencies apply GIS to crime analysis, strategic planning, patrol operations, investigative support, and citizen engagement. John has also worked with agencies to implement GIS for open and transparent policing and to tackle hard problems like the opioid epidemic and homelessness. He is also helping police realize the value of new geospatial technologies including machine learning and big data analysis to gain a real-time understand of crime patterns and make better informed decisions. John earned undergraduate degrees in geography and anthropology and a master’s degree in criminal justice from the University of Nevada.


Chris is the product owner for Law Enforcement solutions at Esri.


Next Article

How a Regional Council is Tackling the Housing Shortage

Read this article