|
Track: Electric and Gas Utilities
Fred Podesta
Seattle City Light
700 5th Avenue Suite 220
Seattle, WA 98104
Telephone: 206-386-3372
Fax: 206-684-3423
E-mail: fred.podesta@ci.seattle.wa.us
Scott Oswald
Data Modeling To Support Multiplatform GIS Application Development
Defining Issue: Strategies for maintaining spatial data in multiple formats to support a broad spectrum of GIS, AM/FM, and analytical applications. Solutions: Use of object modeling, relational databases, and GIS application development tools to support multiplatform GIS databases and applications. Methodology: Seattle City Light has built an extensive GIS database used to map and model its electrical distribution system. As City Light identifies new applications and implements new technologies, it is critical to maintain a data model that may be required to support a variety of data structures and software platforms. This problem has been addressed through the use of the object-oriented data modeling and relational database-driven applications. Software: Data modeling has been done using the object modeling technique as implemented in a simple CASE tool, Object Domain. The object class hierarchies were mapped to INFO and Oracle database tables, and applications were developed using ARC Macro Language
(AML), Avenue, Visual Basic with MapObjects, and AutoLISP. Databases have been implemented using ArcInfo LIBRARIAN and ArcStorm, Spatial Database Engine, and shapefiles.
|
|
