Join The Atlas to access free features for city officials & staff like: posting questions, favoriting case studies & more!

Unsupported Browser

We've detected an older browser version that will not give you the best experience while using The Atlas. Please consider revisitng this site after downloading one of the alternatives below.

Rockford IT Department outsources data cleaning & mapping to tackle blight

Rockford, IL, USA

Goverment Champion

Community and Economic Development Department


30 Thousand USD
30 Thousand USD

Project Status

Operational since 2017



Challenges Addressed

Housing & Affordable Housing
Digital Government
Process Improvement


Smart city

Funding / Financing

General Fund/Existing Public Funds

Project Type


At a Glance

Rockford sought to enhance data collection as a cornerstone of its community development strategy, but information was spread across a half dozen systems and GIS staff were inundated with mapping requests. BuildingBlocks helped the City’s IT Department keep pace with demand for data visualization and analysis.

Problem Addressed

To help shape Rockford’s strategy against blight, the Community and Economic Development Department secured a technical assistance grant from the Center of Community Progress (CCP). The resulting report, “Laying the Foundation: Developing an Improved Approach to Problem Properties in Rockford,” identified enhanced data collection and analysis as a core recommendation. While the City has a sophisticated & capable Information Technology Department, it struggled with insufficient resources to build a robust data analysis and visualization tool to address the needs outlined in the CCP report. The CEDD team spent hours each week looking across six enterprise systems to get holistic information on a single problem property. And if there was a need for more complex reporting or analysis—such as prioritizing the list of problem properties by combining data on open code violations, police & fire incidents, tax delinquency, foreclosures, and more—the City had to query multiple databases and standardize datasets across disparate systems, an onerous process that could take up to a week.

Rockford used/is using BuildingBlock's data management platform to address this/these challenge(s).

Solution(s) Used

After an in-depth review of a half-dozen software products, including Rockford’s existing enterprise GIS tools, the City selected Tolemi’s BuildingBlocks to support the data-driven strategy because it was easy to setup and use. They started by consulting the code enforcement and community development users about which data sources to integrate from the various SQL servers and GIS applications across the City and Winnebago County. Once BuildingBlocks was up and running, the CEDD staff had the information they need at their fingertips to make fast, effective decisions.


  1. Instead of building a tool or cobbling together existing resources, Rockford opted for the off-the-shelf BuildingBlocks application, which is saving weeks of staff time per year.
  2. GIS Manager can now deliver dynamic data, rather than static information that was out of date the day after it was made.

Who Should Consider?

Cities of any size that are looking for customized information without increasing the burden on staff time.

Want to message the folks involved in this case study? Want to favorite it? You need to log in!