AIS Models FBI Uniform Crime Reporting Data

FBI UCR

The FBI’s Uniform Crime Reporting (UCR) Program is a nationwide, cooperative statistical effort of more than 18,000 city, university and college, county, state, tribal, and federal law enforcement agencies voluntarily reporting data on crimes brought to their attention. The program’s primary objective is to generate reliable information for use in law enforcement administration, operation, and management. Over the years, however, this data has become one of the country’s leading social indicators. The FBI is required by law to store national UCR data in a platform that will allow the public to search/view results and download for off-line analysis.

The current UCR data reporting tool was built in Cold Fusion and has not received an update since 2010. The FBI released an RFI solicitation with the intent to gather information about possible ways to replace the current UCR tool. Criteria for the new tool is that it should be web based with the ability to filter on any UCR attribute and then export the results in a .csv format. 

Using 2 gigabytes of sample data provided by the FBI, AIS set out to determine if, in just a few weeks, a minimally viable product (MVP) solution could be built leveraging public cloud services that were currently (or soon to be) available in the Azure Government Cloud. The resulting MVP was designed to fully support the capability for citizens to be able query, filter, correlate and display public FBI National Uniform Crime Reporting (UCR) information. Take a look at the solution we built!

AIS Demo FBI UCR

Technologies:

  • ASP.NET MVC 4.5 (with jQuery, bootstrap, ADO.NET)
  • Power BI embedded
  • SQL Azure Data Warehouse
  • Blob storage with SaaS for file download