Keeping a Common Address Database “Common” Using FME

The City of Hamilton has undertaken an initiative to establish a single authoritative (“Common”) property address and street centreline database. All city wide systems and services requiring address data or address validation are able to access this common database as a trusted source for addresses and street centrelines. A single authoritative database works in principle where systems and users are able to access the database directly. In many cases, address and street data must be transferred to other systems that cannot directly access the address database due to limitations of security access, limitations of ability to consume data services or require special reformatting of address data to meet the their respective systems data formats. This presentation will outline the City’s business needs for utilizing address and street data and our experiences of how FME was used to meet these needs.