Capturing the Power of ArcView GIS, Avenue, ArcView Spatial Analyst, and WaterCAD in Order to Automate, Gather, and Record Data

Author: Jos Bell
Organization: Little Rock Municipal Water Works

221 E Capitol Ave
Little Rock, AR 72202

Phone: 501-377-1221
Fax: 501-377-1287
jbell@aristotle.net

This presentation describes the development of a GIS automated application to transfer calculated and summarize values and information between a water utility GIS database in ArcView GIS, IBM AS400 service address database, and the WaterCAD hydraulic modeling software to determine and improve service boundaries to support master planning and for design and maintenance operations.

This presentation also describes the methods used to transfer the hydraulic junction information into ArcView GIS, create Thiessen polygons to sectionalize the service area, create an elevation grid using ArcView Spatial Analyst Assignment Proximity feature, create a geocode address shapefile for extracting and summing average day consumption, and write Avenue programs to batch process the data and automatically populate the required data fields.