Category: Master Address Database

Enterprise Address & Maintenance System – Part 3: Why we released as Open Source

Enterprise Address & Maintenance System – Part 3: Why we released as Open Source

The Enterprise Addressing System is a complete master address repository, address creation & maintenance system, and address query & validation solution. In this three part series I try to describe the solution from both technical and usability perspectives. Part 1 of this series describes the context and motivation behind the Enterprise Addressing System (EAS). Part 2 discusses address maintenance workflows and the use of open standards. Part3 (this post)...
Enterprise Address Repository & Maintenance Solution – Part 2:  Workflows & Application Integration

Enterprise Address Repository & Maintenance Solution – Part 2: Workflows & Application Integration

In Part 1 of this series, I described the context and motivation behind the development of our Enterprise Addressing System, a complete master address repository, address creation & maintenance system, and address query & validation solution. To reiterate: Addresses are critical data Its a challenge to keep address system up to date Its almost impossible to keep systems synced across departments You can’t ask departmental staff to manage addresses...
Standardize Addressing Across the Enterprise: The Why and How of EAS

Standardize Addressing Across the Enterprise: The Why and How of EAS

Almost everything that a city or county government does or any service they provide is tied to an address. Whether it is firefighters responding to a 911 call, public works staff responding to work orders, or an individual applying for a street-parking permit, the ability of a city or county to provide services depends on knowing the address of where someone or something is located. Addressing Across the Enterprise...
Efficient processing of source address data into a Master Address Database (MAD) data model

Efficient processing of source address data into a Master Address Database (MAD) data model

I’m kinda jazzed because I just proved out a script that ingests a series of raw address files and loads them to the Master Address Database (MAD) data model that we built for San Francisco last year as part of their Enterprise Addressing System. (We are also in the process of implementing the same MAD data model for Walnut Creek and San Mateo County.) The data processing required is significant....