The City of Hamilton has many service delivery applications utilizing and storing resident addresses. For example, street addresses are solicited from the resident in a free form method and are never validated against a common address database. Thus, the City has numerous instances of address databases that are not accurate or consistent, which are used on a daily basis to communicate to the residents. In many cases, these address databases are misused and often invalid addresses cause breakdown of communications. This has led to embarrassment for the City, anger by the residents and in some cases legal action.
The challenge is to establish a single authoritative address database which all service delivery applications can valid against. Establishing which is most correct and then comparing others to get the best of breed is the greatest challenge. Other challenges are the adoption of a single authoritative database, “clean up” existing databases and encourage application stewards to use the single authoritative database as truth.
The City engaged a subject matter expert to help collect business requirements, design a solution and implement this solution. The technical solution consisted of a consolidated database model, application database cleanup, address maintenance tool, redlining tool for identifying address issues and a method to deliver addresses to other service delivery applications.
Also a sustainability model to ensure that addresses were maintained accurately and on a timely basis by identified stewards. The address model would ensure that new or updated addresses would be available to other service delivery applications.