Exercise In Designing A Wastewater Data Model

1
Exercise In Designing A Wastewater Data Model
Clean Water Atlanta City of Atlanta Khafra
Engineering
Brad Morrow Khafra Engineering, Atlanta
GA Bmorrow_at_khafra.com (404) 979 6999 Clare
Brown (cbrown_at_khafra.com) Khafra
Engineering Keith Toomer (ktoomer_at_atlantaga.gov)
City of Atlanta
2
Background Review of Presentation

• Background of Clean Water Atlanta
• Design Process
• Data Model Development
• Data Migration
• Data Model Analysis
• Future of the Data Model

3
Background Consent Decree

• City of Atlanta was mandated by the
• U.S. Department of Justice (1998 1999) to
• reduce the number of overflows from
• their collection system
• Program Management Team (PMT) Established
• Montgomery Watson-Harza Khafra Selected to Lead
• PMT Along With Over 100 Sub-Contractors
• Develop GIS data and Provide Support
• for Clean Water Atlanta staff and City
• of Atlanta

4
Background Clean Water Atlanta

• Initiated in 2002 by City of Atlanta Mayor
  Shirley
• Franklin
• Clean Water Atlanta Key Points
• Manage Consent Decree Program
• Reduce Flooding and Pollution From Stormwater
• Sanitary Sewer Consent Compliance
• Water Quality Monitoring
• Combined Sewer Consent Compliance

5
Background Initial Conversion

• City Data in CADD Format
• Converted to Shapefile
• Survey Data Integrated Into Shapefiles

6
BackgroundShapefile Limitations

• Data File Structure Limited Expandability
• Duplicated Shapefile Data
• Business Table Based Data Is Static

7
Sewer Line Based Data
Sewer Main Shapefile
Macro / Micro Survey Shapefile
Creek Crossing Shapefile
Preventative Maintenance Shapefile
Cured-In Place Pipe (CIPP) Shapefile
8
Sewer Facility Based Data
Manhole Shapefile
Pump (Lift) Station Shapefile
Flow Meter Shapefile
Vented Manhole Shapefile
Spills Shapefile
Wastewater Reclamation Center Shapefile
9
Geodatabase Upgrade Factors In The Decision

• Manage Larger Amount of Data More Securely
• Database Connectivity
• Remove Duplication In Data
• Follow Enterprise Direction

10
Geodatabase Upgrade Initial Conversion

• Converted Shapefiles Into Personal Geodatabase
• Plan to Model Data

11
Geodatabase Upgrade Planning Issues

• Integrate Sanitary Sewer Evaluation
• Survey (SSES) Data
• Compliant With Hansen Work
• Management Software
• Review Field Definitions With
• City of Atlanta Staff and
• Engineering Group

12
Data Model Development Design Process

• Review Field Descriptions
• Microsoft Visio 2000 Enterprise
• CASE Tools
• Use Existing Data Model As Template
• Determine What to Enter Network, Domain
• Subtypes, etc.

13
Data Model Development Data Entry

• Copy / Paste Similar
• Feature Classes
• Large Amount of
• Repetitive Data Entry
• Cumbersome GUI

14
Data Model Development Modeling Decisions

• Feature Classes
• Domains
• Subtypes
• Geometric Networks
• Business Tables

15
Geodatabase Conversion Exporting UML

• Export UML Schema to Microsoft Repository
• Creation of Error Log
• Convert Microsoft Repository to Geodatabase
• Schema
• Load Geodatabase Schema Into SDE

16
Geodatabase Conversion Loading Data

• Load Data from ArcCatalog Interface
• Load Data from ArcMap Utility Interface
• Copy Business Tables in ArcCatalog

17
GeodatabaseModel
CIPP, Creek Crossing Etc Relationships
Flow Meters, Pump Stations, Etc Relationships
Sewer Main Feature Class
Sewer Facility Feature Class
Manholes, Catch Basins, Etc Subtypes
Trunks, Combined, Etc Subtypes
18
Geodatabase Analysis Benefits

• Data Stored in Centralized Manageable
• Library
• Data is Normalized and Efficient
• Inherent QA/QC
• Geometric Network Functionality
• Data Is Now Officially Modeled

19
Geodatabase Analysis Challenges

• Limited Support
• Not Intuitive At First
• Database Administrator Support Needed
• Server Issues
• Schema Is Locked

20
Geodatabase Analysis Future

• Fine-Tuning Data
• Expand Use of Geodatabase Tool Functionality
• Develop Geometric Network
• Integrate Additional Data
• Water Data Model

21
Exercise In Designing A Wastewater Data Model
Clean Water Atlanta City of Atlanta Khafra
Engineering
Brad Morrow Khafra Engineering, Atlanta
GA Bmorrow_at_khafra.com (404) 979 6999