Kern County Master Address Database Needs Assessment

kern-workflow-main

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.

Screenshots & Videos

Kern County, located in the heart of California, is a growing community with a variety of industries and recreational opportunities.

Kern County, located in the heart of California, is a growing community with a variety of industries and recreational opportunities.

Simplified address data transfer schematic between jurisdictions and stakeholders in Kern County

Simplified address data transfer schematic between jurisdictions and stakeholders in Kern County