Upcoming events

Follow Us

Twitter Feed


Implementation of an Enterprise-wide Common Street Address Database

  • June 28, 2018
  • 1:00 PM - 2:00 PM
  • Webinar

Registration


Member Note - Please login with your email address to avoid duplication of your record.
Registration is closed

 June Webinar

Implementation of an Enterprise-wide Common Street Address Database

Speakers: John Bacon, City of Hamilton & Marc Curtis, AGSI

Problem

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.

Challenge

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.

Resolution

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.


About Us

We are recognized as the premier non-profit organization in Ontario. where members share their experiences through networking and program events for the use and integration of spatial data, information, applications and technologies that provide solutions and solve challenges in both the public and private sectors.

Become a Member

Show your commitment to the Geospatial Community by joining us. Be part of a dynamic geospatial and information community whose mandate is to advance the effective application of spatial and information to enable business services and decision making.  

MEMBER BENEFITS

 Education and research.

 Networking.

 Discounts and member-only events.

Find Us

Contact: INFO


Powered by Wild Apricot Membership Software