Integrating Sanitary Sewer System Automation with GIS

GIS Functions

Map manipulation: display sewer system map with different layers, zooming, labeling
On-map identify: map tips, identify entity
Red-line mark-up: add text, line, polygon, etc. on the map
Spatial query: query database by drawing shapes on the map such as line, rectangle, circle, polygon, etc.
Hyper-link map elements to pictures, sketched drawings, documents
Print map

Management Function Menu

Management function list: inventory, public system, private system, complaints, billing, modeling, report generation
Activity menu for each function item

Data Collection Functions

Data collection for inventory
Data collection for inspection
Data collection for rehabilitation
Data collection for maintenance

Work Order Generation

Work order for inspection
Work order for rehabilitation

Database Management Functions

Account management
Generic database management tools

Complaints Handling

Phone logging
System search
Service request generation

Maintenance Scheduling

System query: both from the map and from the database
Maintenance scheduling

Billing

Mail automation
Billing status checking

Sewer Modeling

Design conditions
Design alternatives
Overloading search and display
Sewer system planning

Report Generation

Customized report generation

Based on the database model and the design specifications, a prototype system has been developed. The system was developed using standard Windows application development environment such as Visual Basic, and a component based GIS software developed by a major GIS vendor. The unique feature of this system allows users to query sewer system inventory, inspections, and customer accounts in GIS format (including vector and raster) and in tabular format with single point-and-click. The system built-in GIS functions such as search by shapes etc. enhances the power for sewer system management.