Government Technology

Florida Sheriff's Office Uses Appliance to Better Search Databases for Crime Information



July 30, 2013 By

The Orange County, Fla., Sheriff’s Office is five months into a unique project using the Google Search Appliance to locate and extract criminal justice information from three different internal databases, including the agency’s data warehouse.

Sheriff’s Office officials say they may be the first law enforcement agency to use the Google search hardware this way. The tool is being used primarily to search relational databases, but it also can crawl most standard file systems and social media feeds. For example, the Sheriff’s Office has tested it successfully with Twitter and RSS feeds.

Hal Trask, the Sheriff’s IT solutions delivery manager, and Sheena Lovette, a crime analysis supervisor, discussed the deployment in an email interview with Government Technology.

They said several multi-database searches conducted with the search appliance have resulted in the location or arrest of suspects. An armed robbery suspect was located and arrested. A homicide suspect was located and questioned for a neighboring police department. And a search query for “kegs” resulted in the identification and arrest of three suspects — a search that helped solve seven to 10 cases of theft and resale of beer kegs.

Although the technology is only being used to search Orange County Sheriff’s data, the office intends to expand the searches. “The next step in our initiative will be to begin working on arrangements with various local agencies in order to begin sharing data via [the search appliance],” wrote Trask and Lovette.

The system’s Web-based user interface has been dubbed CRAIG, for Criminal Research and Investigative Gathering application. The Google Search Appliance hardware sits on the Sheriff’s network. CRAIG currently works with internal databases within the sheriff’s Tiburon records management system, including the Automated Reporting System, Crime Analysis and Calls for Service.

The Sheriff’s Office anticipates no technical difficulty in expanding the search capability to other jurisdictions. “The only issue that we may run across is mapping each agency’s data elements to one common format,” said a Sheriff’s Office spokesperson. “The [search appliance] supposedly does have built-in functionality that should provide the ability to do this. We just haven’t gotten to that phase yet.”

Data shared between law enforcement agencies would be transferred using CJNET, a secure private network provided by the Florida Department of Law Enforcement.

The Sheriff’s Office technical team created the new system quickly, said Trask and Lovette. “Our programmers were able to produce a useful working prototype of CRAIG in approximately 30 days without ever having been exposed to the Google technology API. The learning curve was fairly minimal.”

However, they added, the project will need to continually adapt to changes in technology, system availability, the evolution of crime patterns, human interaction and even linguistic changes. “As we move forward toward a more federated search, searching across other agencies, it will be interesting to see if the challenges are more technical related or people related.”


| More

Comments

Add Your Comment

You are solely responsible for the content of your comments. We reserve the right to remove comments that are considered profane, vulgar, obscene, factually inaccurate, off-topic, or considered a personal attack.

In Our Library

White Papers | Exclusives Reports | Webinar Archives | Best Practices and Case Studies
Better security. Better government.
Powering security at all levels of government with simpler, more connected IT.
Cybersecurity in an "All-IP World" Are You Prepared?
In a recent survey conducted by Public CIO, over 125 respondents shared how they protect their environments from cyber threats and the challenges they see in an all-IP world. Read how your cybersecurity strategies and attitudes compare with your peers.
Maintain Your IT Budget with Consistent Compliance Practices
Between the demands of meeting federal IT compliance mandates, increasing cybersecurity threats, and ever-shrinking budgets, it’s not uncommon for routine maintenance tasks to slip among state and local government IT departments. If it’s been months, or even only days, since you have maintained your systems, your agency may not be prepared for a compliance audit—and that could have severe financial consequences. Regardless of your mission, consistent systems keep your data secure, your age
View All

Featured Papers