Using Business Intelligence to Track Home Foreclosures

In the past the Village of Northbrook, IL has worked with Geographic Information Systems (GIS) to setup a process to help better record and track properties as they move through the foreclosure process.  This process involves a monthly review of mailed foreclosure documents and entry of dates into an excel spreadsheet correlating to when a lis pendens or pre-foreclosure notice is filed, when the property is found to be in foreclosure, and finally when the court approves the sale of that property and it is no longer in foreclosure.  Previously a static map was created from this information and sent to the Community Development and Planning Department and Police for use in their workflows.  With the new capabilities provided by Business Intelligence connections in the village’s browser-based mapping application, MapOffice™ Web Access, this process has been streamlined and provides increased access to the associated foreclosure information. 

To allow for this connection to occur, GIS created a database connection that allows Village Staff to query the information stored in the foreclosure spreadsheet in MapOffice™ by property status and date.  These query results are then displayed by location in MapOffice™ Web Access.  Using Business Intelligence, community staff has increased access to the information being tracked within the excel spreadsheet, where before they could only see the latest date and status for a specific property.  They also able to view the individual dates and gain a better understanding of the history behind a property.  Also, because the legal documents are scanned and stored by address within the village’s document management environment, a custom hyperlink is included with each entry which staff is able to click on to directly find and view the specific documents associated with the dates displayed on the map for verification or more information.