Challenge

Addresses are one of the most challenging information assets for Kern County to manage and maintain. Difficulties arise because departments have potentially divergent needs and uses for addresses and many options exist for managing the location-based component of addresses.

County departments develop independent address lists and databases, or maintain addresses in proprietary applications, such as asset management systems, computerized maintenance management systems, document management systems, or financial systems. Inevitably, this results in many address lists within the County, each of which tracks addresses with varying formats, degrees of accuracy, currency, and completeness.

Solution

Farallon developed a comprehensive business case for developing a Master Address Database for the County of Kern. The business case summarized current addressing workflows within County departments, within City governments, and between local governments. Based on these findings and review of Master Address Database implementations in similarly sized counties, Farallon developed a cost model, return on investment analysis, and a detailed Master Address implementation plan.

The implementation plan detailed the steps, responsibilities, deliverables, and estimated time frames for developing addressing standards, identifying address lists, and engineering data extraction/transformation/loading workflows. It also included a description of the Address Maintenance application functional capabilities and provided a blueprint for the initial project implementation plan.

Categories: GIS/IT Integration, Master Address Database

Selected screenshots from the project

Click on any thumbnail to view a high-res image

Kern County

Master Address Database (MAD) planning