Abstract Building Full Geodatabase Functionality for a Wastewater Collection System Track: Water, Wastewater, and Stormwater Author(s): Scott Humphrey, Jon Wells, Leo Schempp The Leucadia Wastewater District's (LWWD) GIS system was built upon a legacy of shape files linked to database tables full of operational, engineering, and management data. LWWD migrated to geodatabase format, but did not implement all of the new tools necessary to take full advantage of the powerful functionality available to wastewater utilities. Infrastructure Engineering Corporation (IEC) re-designed the geodatabase data model for LWWD and added geometric network functionality, attribute domains, and more efficient table joins. The end result is a streamlined geodatabse that eliminates data redundancy, preserves data accuracy and integrity, and serves as a central data repository for all of LWWD's wastewater collection system data. The resulting geodatabse is a true interdepartmental wastewater collection system tool with the potential to serve as a basis for future enterprise asset management and financial control projects. Scott Humphrey Infrastructure Engineering Corporation 717 Pier View Way Oceanside , California 92054 United States Phone: 760-529-0795 Fax: 760-529-0785 E-mail: shumphrey@iecorporation.com Jon Wells Infrastructure Engineering Corporation 5242 Katella Ave, Ste. 205 Los Alamitos , California 90720 United States Phone: 562-344-9060 E-mail: jwells@iecorporation.com Leo Schempp Leucadia Wastewater District 1960 La Costa Avenue Carlsbad , California 92009 United States Phone: (760) 753-0155 E-mail: lschempp@lwwd.org |