HOME


Track: Database Design and Automation

Larry Gunderson
City of Naperville
400 S Eagle Street
Naperville, IL 60566-7020


Telephone: 630-305-5956
Fax: 630-305-5957



Jack Gains

Full Power of an ArcInfo Database for Local Government

Defining Issue: The theme of this presentation is the challenges that face local governments in developing a comprehensive ArcInfo GIS land base. The focus of the presentation will be the critical path that starts long before the capture/conversion phase and is completed when the users have a fully functional ArcInfo database. The paper will cover the real-world development that went into the database development by the City of Naperville and Merrick & Company. GIS Solution: The paper presentation will cover all of the tasks that must be completed to insure the successful development of a GIS database. The first step is the definition of the GIS application requirement of all departments within the municipal government. This step is followed by the determination of GIS data requirements and development of conversion specifications. Before the data capture/conversion phase begins, the conceptual data model is translated into a physical ArcInfo database design. Finally, data is compiled and delivered to the City in the target database structure. Methodology: The paper will highlight the end result of the database design process for the City of Naperville: a comprehensive GIS land base that contains planimetric, topographic, and cadastral features organized into twenty-seven ArcInfo coverages and summarized in a 216 page database design document. The full range of ArcInfo spatial types are utilized, including point, node, arc, and polygon features, as well as complex feature classes such as regions, and raster image (digital orthophoto) data. In addition, text attribute tables (.TAT) and annotation subclasses were developed for each of the coverages to organize the large volume of annotation. Software: The database was designed for ArcInfo Version 7 and its extensions, as well as ArcView Version 3.0. In order to meet the application needs of the City's GIS users, special attention was made in the ArcInfo data model design and coding of attributes to ensure flexibility of use. For example, the Digital Terrain Model (DTM) coverage includes both points and arcs (breakline features) uniquely coded for the ARC TIN surface modeling module, as well as third party civil engineering software packages. The cadastral coverage includes parcel, subdivision, and right-of-way regions to enable many possible applications from one coverage, and to integrate and simplify data maintenance within ARCEDIT. Also, a street centerline coverage with address ranges was developed to utilize the geocoding capabilities of the ARC NETWORK extension.



Copyright 1997 Environmental Systems Research Institute