As I sat at my 1970s metal-style desk holding a now cold cup of unsweetened green tea, I leaned back in my chair and mumbled, “Data, data, everywhere, but not a drop to drink.” I was surrounded by mountains of paper printouts, two computer monitors running three different data-management programs, and a frosted glass whiteboard covered in diagrams, numbers and the occasional sticky note. I was there, like you, hopelessly attempting to make sense of the data sets provided by antiquated police data systems.

The quote is actually from Samuel Taylor 1834 poem “The Rime of the Ancient Mariner” as he reflected his sad state of affairs of being a cursed captain, dying of thirst, stuck in an ocean of undrinkable water: “Water, water, everywhere, and nor a drop to drink.” But I felt the same, stuck in the middle of an ocean of data surrounded by undrinkable (unusable) information.

Police Love Data

For a little over a decade, police agencies have been hyperactively collecting data like kids fighting for candy from a piñata. Agencies focused on the volume of data collected but were less concerned about the relevancy of that data. Unfortunately, for many agencies this once small pool of data has grown into a large ocean of undrinkable data.Police agencies need more relevant data and less garbage that analysts and detectives can quickly convert into usable information.

Many departments are downloading information from CAD dispatch systems, uploading information from police officer’s vehicle-mounted computers, and sending information wirelessly using e-citation machines, all without understanding why and how the data is collected.

Understanding the “why” behind data collection will help encourage how the data is collected. The goal should never be to collect random data just to add to the pool of previously collected data – random collections of data will lead to an ocean of unusable data like what we have now. The goal should always be to collect data for a specific purpose: crime-fighting.

Once the data is collected with a purpose, it is now the job of the crime analysts and detectives to convert that data into information, then turn that information into insight.

Turning Data To Information 

Police agencies need more relevant data and less garbage that analysts and detectives can quickly convert into usable information. My undergrad health professor told me, “Garbage in equals garbage out,” and the same concept applies to data collection. I don’t like the phrase “bad data.” The fact is there is a TON of data out there. Law enforcement needs smart tools to help deliver the right/relevant information. Luckily, correcting irrelevant data collection habits is as easy as 1,2,3:

1. Numbers: Numbers pose an interesting problem for data collectors because they can be easily transposed. The numbers on VINs, license plates, serial numbers and addresses should be verified before recording it into any software. 

2. Individuals: Accurate data collection on people can also pose a problem. Many people share the same first and last name so collecting distinguishing characteristics is just as important as names. In Arizona, for example, 43 people share my first and last name; 4 share the same first, middle and last name; and 1 is a released violent felon from another state. Pay close attention to personal identifying information (PPI) including complete legal name, accurate social security number, visible tattoos and tattoo location, and race.

3. Associates and friends: Document friends and associates and I promise your analyst will thank you later! Always ask the passengers of traffic stops and friends of your suspect for their PII, too. Just remember in most states, passengers of traffic stops do not have to talk with you unless you have a violation on that person, but at least you can try.

The more accurate the information, the easier it will be to turn that information into insight.

Turning Information Into Insight

The next step is turning information into insight.  Data sets alone are useless. Data literacy – the ability to derive meaningful information from data – however, is priceless. The quickest way to become data-literate is by using software designed to help interpret that data.

Software can easily and efficiently sort through large data sets, link associates and friends, and paint the bigger picture. Combine data management software with a skilled analyst, investigator, or officer, and you have your recipe for crime-fighting success!

Big data needs to be made small to be effective. The best way to start to shrink data is by understanding the why behind the collection, recording accurate information and using analyzing software to turn data into insight so you are not left floating in an ocean of undrinkable data mumbling to yourself, “Data, data everywhere but not a drop to drink!”


Joshua Lee, M.L.S., CFE, CCCI, CTFI, CCIE - Detective Joshua Lee works in the Organized Crime Section for the Mesa (Arizona) Police Department. Joshua specializes in asset forfeiture and white-collar crimes including crypto-crimes.

Joshua earned a B.A. in Justice Studies, a M.S. in Legal Studies and is a Certified Fraud Examiner. He is an adjunct law and criminal justice professor at a large national university and smaller regional college. He also instructs police in-service training, teaches at the regional police academy and is a financial crimes consultant for banks and financial institutions throughout the State of Arizona.

This article originally appeared on PoliceOne.com. Read it here. 

 Forensic Logic Police Database Software Solutions

Forensic Logic has spent more than a decade collaborating with local, state and federal law enforcement agencies to deploy the largest, most powerful network of users, information and technology in American law enforcement.

We’ve combined our industry-leading search engine, LEAP, with COPLINK’s advanced analytics and reporting to offer a full suite of information technology in a single platform. The finest tools and the richest data are now matched with streamlined integrations and rapid deployment.

Contact Us