Government Technology

    Digital Communities
    Industry Members

  • Click sponsor logos for whitepapers, case studies, and best practices.
  • McAfee

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
Digital Cities & Counties Survey: Best Practices Quick Reference Guide
This Best Practices Quick Reference Guide is a compilation of examples from the 2013 Digital Cities and Counties Surveys showcasing the innovative ways local governments are using technological tools to respond to the needs of their communities. It is our hope that by calling attention to just a few examples from cities and counties of all sizes, we will encourage further collaboration and spark additional creativity in local government service delivery.
Wireless Reporting Takes Pain (& Wait) out of Voting
In Michigan and Minnesota counties, wireless voting via the AT&T network has brought speed, efficiency and accuracy to elections - another illustration of how mobility and machine-to-machine (M2M) technology help governments to bring superior services and communication to constituents.
Why Would a City Proclaim Their Data “Open by Default?”
The City of Palo Alto, California, a 2013 Center for Digital Government Digital City Survey winner, has officially proclaimed “open” to be the default setting for all city data. Are they courageous or crazy?
View All