City of San Mateo Master Address Database

City of San Mateo Master Address Database

Challenge

Addresses are a key dataset used by the City of San Mateo to provide essential services.  City agencies and departments (e.g., Public Works, Building Division, Inspections, Police, Fire, Economic Development, Planning, and Finance) rely on addresses to complete their business operations or provide services to area residents. Over time however, different departments had developed their own independent versions of address databases and their own maintenance processes.

No single complete, accurate, and current address list existed within the City that could be used as the authoritative list of business and residential locations. This situation limited the ability for City departments to coordinate efforts and integrate information across business systems. It also meant that the City was spending significant resources on managing redundant address data.

The City needed a Master Address Database (MAD) to be developed, deployed within their existing production GIS database, and made available to staff throughout the City.

Solution

Farallon Geographics designed and deployed a Master Address Database that could be used as a central authoritative service by all authorized City departments. The MAD was deployed using the City’s SQL server database accessible over an Intranet website. It also integrated with the City’s existing Intergraph GeoMedia geodatabase so that point address data could be related to GIS parcel polygons used for property assessment and management. Farallon’s MAD implementation offers the City increased data availability, reduced errors and maintenance, elimination of costly duplicate data, and enhancement of City services.

Using the MAD interface, authorized City staff including non-GIS users can search for addresses by street name and/or number, Assessor Parcel Number (APN) or the owner’s name. In addition to the list of valid addresses, results also include a display of a street-level map showing the location of the address within the City. Simply by clicking on the map, users can mark any address within the MAD as needing review or request the addition of address points.

The site’s web mapping functionality uses Microsoft Virtual Earth which allows high-performance viewing as regular maps, ortho and oblique aerial images, or in 3D. Virtual Earth will also permit display of other non-address data such as ownership name or environmental planning data.

The MAD has provided the City with the ability to verify addresses at the tenant and suite level where this was previously unavailable.  The browser-based address data maintenance application dynamically queries address points from the City’s GIS database and maps them onto Virtual Earth maps as pushpins.  To make the site as easy to use as possible, address points are dynamically clustered and symbolized based on the type of address point displayed (e.g., single family residence, multi-address building).  Simply hovering over an address point opens a dialog that allows users to view address information and request updates of either attribute or spatial data based.

Farallon developed the application using modern web application design methods, including AJAX (Asynchronous JavaScript and XML), and a web services based architecture.

Screenshots & Videos

San Mateo Master Address Database Web Application

San Mateo Master Address Database Web Application