Abstract
Developing an Integrated Parcel/Master Address Geodatabase for Oakland, California Track: Cadastral and Land Records Author(s): Julian Ware, Dennis Wuthrich Assessor parcel numbers (APNs) and situs addresses are two key attributes used by local governments to specify geographic locations. While parcels are often maintained according to formal GIS workflows, addresses are rarely managed as spatial datasets. Often, address datasets are edited without integrity constraints (spatial or otherwise), meaning they can quickly become inconsistent. At the City of Oakland, we developed a single integrated parcel/master address geodatabase, allowing us to automatically check the spatial integrity of address data edits and resolve the problem of multiple, inconsistent address databases. An immediate benefit of this approach is the ability for address-based workflows (such as permitting) that do not currently use GIS to become spatially enabled. This paper will present the design constraints, data model, and City of Oakland's implementation approach to building an Oracle/ArcSDE software-based parcel/master address geodatabase. Julian Ware City of Oakland OIT GIS 150 Frank H. Ogawa Plaza, Suite 7216 Oakland , CA 94612 US Phone: (510) 238-6744 E-mail: jware@oaklandnet.com Dennis Wuthrich Farallon Geographics 609 Mission St, 2nd Floor San Francisco 94105 US Phone: (415) 227 1140 E-mail: dwuthrich@fargeo.com |